Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 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

Accounting

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

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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

Related Questions