Trusted by Students Everywhere
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

Accounting Nov 22, 2020

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
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment