Amazon Beverages produces and bottles a line of soft drinks using exotic fruits from Latin America...

Transcribed Image Text:

Amazon Beverages produces and bottles a line of soft drinks using exotic fruits from Latin America and Asia. The manufacturing process entails mixing and adding juices and coloring ingredients at the bottling plant, which is a part of Mixing Division. The finished product is packaged in a company-produced glass bottle and packed in cases of 24 bottles each. Because the appearance of the bottle heavily influences sales volume, Amazon developed a unique bottle production process at the company's container plant, which is a part of Container Division. Mixing Division uses all of the container plant's production. Each division (Mixing and Container) is considered a separate profit center and evaluated as such. As the new corporate controller, you are responsible for determining the proper transfer price to use for the bottles produced for Mixing Division. At your request, Container Division's general manager asked other bottle manufacturers to quote a price for the number and sizes demanded by Mixing Division. These competitive prices follow. Price per Volume 450,000 equivalent cases 900,000 1,350,000 Total Price $3,465,000 Case $7.70 6,030,000 7,965,000 6.70 5.90 a An equivalent case represents 24 bottles. Container Division's cost analysis indicates that it can produce bottles at these costs. Volume 450,000 equivalent cases 900,000 1,350,000 Total Cost $2,875,000 4,900,000 6,925,000 Cost per Case $6.39 5.44 5.13 These costs include fixed costs of $850,000 and variable costs of $4.50 per equivalent case. These data have caused considerable corporate discussion as to the proper price to use in the transfer of bottles from Container Division to Mixing Division. This interest is heightened because a significant portion of a division manager's income is an incentive bonus based on profit center results. Mixing Division has the following costs in addition to the bottle costs. Cost per Volume Total Cost Case 450,000 equivalent cases $1,850,000 $4.11 900,000 2,650,000 2.94 1,350,000 3,450,000 2.56 The corporate marketing group has furnished the following price-demand relationship for the finished product: Total Sales Sales Price Sales Volume 450,000 equivalent cases 900,000 1,350,000 Revenue $ 9,225,000 16,650,000 20,925,000 per Case $20.50 18.50 15.50 Required: a. Amazon Beverages has used market price-based transfer prices in the past. Using the current market prices and costs and assuming a volume of 1.35 million cases. Calculate operating profits for Container Division, Mixing Division, Amazon Beverages. b-1. Calculate operating profits for Container, Mixing and Amazon Beverages for volumes of 450,000, 900,000 and 1,350,000 cases. b-2. Which volume of production is the most profitable for Container, Mixing and Amazon Beverages? Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Amazon Beverages has used market price-based transfer prices in the past. Using the current market prices and costs and assuming a volume of 1.35 million cases. Calculate operating profits for Container Division, Mixing Division, Amazon Beverages. (Enter your answers in thousands of dollars.) Profits for Container Division Profits for Mixing Division Profits for Amazon Beverages Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Calculate operating profits for Container, Mixing and Amazon Beverages for volumes of 450,000, 900,000 and 1,350,000 cases. (Enter your answers in thousands of dollars.) 450,000 cases 900,000 cases 1,350,000 cases Container profit Mixing profit Amazon Beverages profit < Req A Req B2 > Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Which volume of production is the most profitable for Container, Mixing and Amazon Beverages? Most profitable volume for Container Most profitable volume for Mixing Most profitable volume for Amazon Beverages < Req B1 Req B2 > Amazon Beverages produces and bottles a line of soft drinks using exotic fruits from Latin America and Asia. The manufacturing process entails mixing and adding juices and coloring ingredients at the bottling plant, which is a part of Mixing Division. The finished product is packaged in a company-produced glass bottle and packed in cases of 24 bottles each. Because the appearance of the bottle heavily influences sales volume, Amazon developed a unique bottle production process at the company's container plant, which is a part of Container Division. Mixing Division uses all of the container plant's production. Each division (Mixing and Container) is considered a separate profit center and evaluated as such. As the new corporate controller, you are responsible for determining the proper transfer price to use for the bottles produced for Mixing Division. At your request, Container Division's general manager asked other bottle manufacturers to quote a price for the number and sizes demanded by Mixing Division. These competitive prices follow. Price per Volume 450,000 equivalent cases 900,000 1,350,000 Total Price $3,465,000 Case $7.70 6,030,000 7,965,000 6.70 5.90 a An equivalent case represents 24 bottles. Container Division's cost analysis indicates that it can produce bottles at these costs. Volume 450,000 equivalent cases 900,000 1,350,000 Total Cost $2,875,000 4,900,000 6,925,000 Cost per Case $6.39 5.44 5.13 These costs include fixed costs of $850,000 and variable costs of $4.50 per equivalent case. These data have caused considerable corporate discussion as to the proper price to use in the transfer of bottles from Container Division to Mixing Division. This interest is heightened because a significant portion of a division manager's income is an incentive bonus based on profit center results. Mixing Division has the following costs in addition to the bottle costs. Cost per Volume Total Cost Case 450,000 equivalent cases $1,850,000 $4.11 900,000 2,650,000 2.94 1,350,000 3,450,000 2.56 The corporate marketing group has furnished the following price-demand relationship for the finished product: Total Sales Sales Price Sales Volume 450,000 equivalent cases 900,000 1,350,000 Revenue $ 9,225,000 16,650,000 20,925,000 per Case $20.50 18.50 15.50 Required: a. Amazon Beverages has used market price-based transfer prices in the past. Using the current market prices and costs and assuming a volume of 1.35 million cases. Calculate operating profits for Container Division, Mixing Division, Amazon Beverages. b-1. Calculate operating profits for Container, Mixing and Amazon Beverages for volumes of 450,000, 900,000 and 1,350,000 cases. b-2. Which volume of production is the most profitable for Container, Mixing and Amazon Beverages? Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Amazon Beverages has used market price-based transfer prices in the past. Using the current market prices and costs and assuming a volume of 1.35 million cases. Calculate operating profits for Container Division, Mixing Division, Amazon Beverages. (Enter your answers in thousands of dollars.) Profits for Container Division Profits for Mixing Division Profits for Amazon Beverages Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Calculate operating profits for Container, Mixing and Amazon Beverages for volumes of 450,000, 900,000 and 1,350,000 cases. (Enter your answers in thousands of dollars.) 450,000 cases 900,000 cases 1,350,000 cases Container profit Mixing profit Amazon Beverages profit < Req A Req B2 > Complete this question by entering your answers in the tabs below. Req A Req B1 Req B2 Which volume of production is the most profitable for Container, Mixing and Amazon Beverages? Most profitable volume for Container Most profitable volume for Mixing Most profitable volume for Amazon Beverages < Req B1 Req B2 >