McGraw Hill Excel Question - Saved Search for tools, help, and mor File Home Insert Draw Formulas Data Review View Help Calibri (Body) 11 A A BI U ab D v Av | ab Wrap Merge v F16 v X fx A B C D E F G H 1 2 Interin Machines is a highly decentralized conglomerate manufacturer that has strength in adapting to new markets. Currently, the Steel Fabrications department needs a part from the Aluminum Fabrications department for a new product it is introducing next quarter. For pricing this new product, Steel Fabrications plans to simply add the market price of the aluminum casing to the final product. Below is more information regarding this part. 3 4 Aluminum Casing 5 Market Price 6 Variable Cost es is $ 45.00 $ 24.00 7 Fixed Cost (per unit) 8 Full Cost es es $ 8.00 32.00 5,000 3,000 1,000 9 Capacity 10 Capacity Used 11 Transfer Amount Demanded 12 13 Required: 14 Answer the questions below regarding the transfer of this part. 15 16 What is the maximum transfer price for this part? 17 What is the minimum transfer price for this part? 18 What is the mutually beneficial price for this part? 19 20 If the aluminum fabricators accept the Variable Cost for this part, show the profitability of each department. 21 22 23 Sales 24 Variable Cost Steel Fabricators 25 Contribution Margin $ 26 27 Aluminum Fabricators 28 Sales 29 Variable Cost 24 vallavic CUST A 25 Contribution Margin 26 27 28 Sales 29 Variable Cost B $ Aluminum Fabricators 30 Contribution Margin 31 $ E 32 If the aluminum fabricators accept the Market Price for this part, show the profitability of each department. 33 34 35 Sales 36 Variable Cost Steel Fabricators 37 Contribution Margin 38 39 40 Sales 41 Variable Cost Aluminum Fabricators 42 Contribution Margin 43 44 If the aluminum fabricators accept the mutually beneficial price for this part, show the profitability of each department. 45 46 47 Sales 48 Variable Cost Steel Fabricators 49 Contribution Margin 50 Aluminum Fabricators 51 52 Sales 53 Variable Cost 54 Contribution Margin 55 56