ASAP. Please answer it correctly and in Excel
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated based on their own division's return on Investment (ROI). Assume the following information relative to the two divisions: Case 1 2 3 4 51,000 289,000 104,000 191,000 51,000 289,000 79,000 191,000 Alpha Division: Capacity in units Number of units now being sold to outside customers Selling price per unit to outside customers Variable costs per unit Fixed costs per unit (based on capacity) Beta Division: Number of units needed annually Purchase price now being paid to an outside supplier $ $ 104 $ 67 $ 39 $ 20 $ 69 $ 44 $ 44 28 $ 27 $ 9 $ 28 $ 6 9,400 66,000 20,000 60,000 $ 97 $ 39 $ 69* *Before any purchase discount. Required: 1. Refer to case 1 shown above. Alpha Division can avoid $4 per unit in commissions on any sales to Beta Division. a. What is Alpha Division's lowest acceptable transfer price? b. What is Beta Division's highest acceptable transfer price? c. What is the range of acceptable transfer prices (if any) between the two divisions? Will the managers probably agree to a transfer? 2. Refer to case 2 shown above. A study indicates that Alpha Division can avoid $4 per unit in shipping costs on any sales to Beta Division. a. What is Alpha Division's lowest acceptable transfer price? b. What is Beta Division's highest acceptable transfer price? c. What is the range of acceptable transfer prices (if any) between the two divisions? Would you expect any disagreement between the two divisional managers over what the exact transfer price should be? d. Assume Alpha DIVISION offers to sell 66,000 units to Beta Division for $38 per unit and that Beta Division refuses this price. What will be the loss in potential profits for the company as a whole? 3. Refer to case 3 shown above. Assume that Beta Division is now receiving an 6% price discount from the outside supplier. a. What is Alpha Division's lowest acceptable transfer price? b. What is Beta Division's highest acceptable transfer price? C. What is the range of acceptable transfer prices (if any) between the two divisions? Will the managers probably agree to a transfer? d. Assume Beta Division offers to purchase 20,000 units from Alpha Division at $59.86 per unit. If Alpha Division accepts this price, would you expect its ROI to increase, decrease, or remain unchanged? 4. Refer to case 4 shown above. Assume that Beta Division wants Alpha Division to provide it with 60,000 units of a different product from the one Alpha Division is producing now. The new product would require $25 per unit in variable costs and would require that Alpha Division cut back production of its present product by 30,000 units annually. What is Alpha Division's lowest acceptable transfer price? Complete this question by entering your answers in the tabs below. Req 1A to 10 Req 2A to 2D Req 3A to 3D Reg 4 1. Refer to case 1 shown above. Alpha Division can avoid $4 per unit in commissions on any sales to Beta Division. a. What is Alpha Division's lowest acceptable transfer price? b. What is Beta Division's highest acceptable transfer price? c. What is the range of acceptable transfer prices (if any) between the two divisions? Will the managers probably agree to a transfer? Show less Identify the lowest and highest acceptable transfer prices: Lowest acceptable transfer price Highest acceptable transfer price Identify the range of acceptable transfer prices (if any): There is not a range of acceptable transfer prices. There is a range of acceptable transfer prices as shown below: Transfer price S the tra Will the managers agree Yes Ono Req 1A to 10 Req 2A to 2D > Complete this question by entering your answers in the tabs below. Req 1 A to 1C Reg 2A to 2D Reg 3A to 3D Reg 4 2. Refer to case 2 shown above. A study indicates that Alpha Division can avoid $4 per unit in shipping costs on any sales to Beta Division. a. What is Alpha Division's lowest acceptable transfer price? b. What is Beta Division's highest acceptable transfer price? c. What is the range of acceptable transfer prices (if any) between the two divisions? Would you expect any disagreement between the two divisional managers over what the exact transfer price should be? d. Assume Alpha Division offers to sell 66,000 units to Beta Division for $38 per unit and that Beta Division refuses this price. What will be the loss in potential profits for the company as a whole? Show less Identify the lowest and highest acceptable transfer prices: Lowest acceptable transfer price Highest acceptable transfer price Identify the range of acceptable transfer prices (if any): There is not a range of acceptable transfer prices. There is a range of acceptable transfer prices as shown below: Transfer price s s Will the managers agree to the trade? Yes No Loss in potential profits for the company price, would you expect its ROI to increase, decrease, or remain unchanged? (Round your final answers to 2 decimal places.) Identify the lowest and highest acceptable transfer prices: Lowest acceptable transfer price Highest acceptable transfer price Identify the range of acceptable transfer prices (if any): There is not a range of acceptable transfer prices. There is a range of acceptable transfer prices as shown below: Transfer price s s Will the managers agree to the trade? Yes Ono Division A's ROI should O Increase Decrease Complete this question by entering your answers in the tabs below. Req 1A to 10 Req 2A to 2D Req 3A to 3D Reg 4 Refer to case 4 shown above. Assume that Beta Division wants Alpha Division to provide it with 60,000 units of a different product from the one Alpha Division is producing now. The new product would require $25 per unit in variable costs and would require that Alpha Division cut back production of its present product by 30,000 units annually. What is Alpha Division's lowest acceptable transfer price? Show less Lowest acceptable transfer price
