Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Caldwell Supply, a wholesaler, has determined that its operations have three primary activities: purchasing, warehousing, ond distributing The firm reports the following operating data for the year just completed Activity Quantity of Cost per unit of Cost Cost Driver Cost Driver Driver Purchasing Number of purchase orders 1
Caldwell Supply, a wholesaler, has determined that its operations have three primary activities: purchasing, warehousing, ond distributing The firm reports the following operating data for the year just completed Activity Quantity of Cost per unit of Cost Cost Driver Cost Driver Driver Purchasing Number of purchase orders 1.06 $156 per order Warehousing Number of moves 8,600 36 per move Distributing Number of shipments 560 86 per shipment Caldwell buys 100,600 units at an average unit cost of $16 and sells them at an average unit price of $26. The firm also has toed operating costs of $250,600 for the year. Caldwell's customers are demanding a 16% discount for the coming year. The company expects to set the same amount it the demand for price reduction can be met. Caldwell's suppliers, however, are willing to give only a 10% discount Required: Caldwell has estimated that it can reduce the number of purchase orders to 740 and can decrease the cost of each shipment by $9 with minor changes in its operations. Any further cost savings must come from reengineering the warehousing processes. What is the maximum cost (le, target cost) for warehousing if the firm desires to earn the same amount of profit next year? Maximum cost
Expert Solution
Solution
Calculation of current income
| Particulars | Amount($) | Amount($) | |
| Sale[100,600 units *26] | 2,615,600 | ||
| Less:- Operating costs:- | |||
| Variable costs[100,600 units *16 | 1,609,600 | ||
| Fixed Costs | 250,600 | ||
| Total Operating Cost | (1,860,200) | ||
| 755,400 | |||
| Less :_ Overheads | |||
| Purchasing [1,060 order *156] | 165,360 | ||
| ware housing [8,600*36] | 309,600 | ||
| Distributing[560* 86] | 48,160 | ||
| Total overhead | (523,120) | ||
| Net Income | $232,280 | ||
| Now calculate Revised Price | Selling | Buying | |
| Current price | 26 | 16 | |
| Less:-Discount[26*16%][16*10%] | 4.16 | 1.60 | |
| Revised price | 21.84 | 14.40 |
Calculate net income as per Estimations
| Income statement | ||
| Particulars | amount($) | amount($) |
| sale [100,600 *21.84] | 2,197,104 | |
| Less:-Operating costs[100,600 *14.40] | 1,448,640 | |
| Fixed cost | 250,600 | |
| Total operating costs | (1,699,240) | |
| Gross Profit | 497864 | |
| Less:- Overhead:- | ||
| Purchasing [740 *156] | 115,440 | |
| warehousing | - | |
|
Distributing[560 *77](86-9) |
43120 | |
| Total Overhead | (158,560) | |
| Net income | 339,304 | |
| Current net income | (232,280) | |
| Target warehousing cost | $107,024 |
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





