Can someone walk me through how to do this please?
Management of Great Springs Bottled Water Company has asked you, the controller, to develop a transfer pricing system for the company. The Transportation Department of the company sells all of its product to the Bottling Department of the company. Thus the Transportation Department's sales become the Bottling Department's cost of goods sold. In order to determine an optimal transfer pricing system, management would like you to demonstrate what an income statement would look like under a cost, market, and negotiated transfer pricing structure. These various transfer prices are listed below Cost-based $0.62 Market-based $0.74 Negotiated $0.69 Gallons transferred 277,000 Prepare an income statement for each of the transfer prices by filling in the missing numbers in the provided income statement based on each transfer price and calculate the operating income/loss percentage. Round your answers to the nearest whole number. Great Springs Bottled Water Company Income Statement (Cost-based) Month Ending August 31, 20xx Bottling 89,305 Transportation Sales Cost of goods sold Gross profit Expenses: Fuel/utility expense Wages expense Costs allocated from corporate Total expenses Operating income/(loss) in dollars Operating income/(loss) in percentage $15,000 43,100 17,237 $75,337 $3,300 57,200 15,000 $75,500 Management of Great Springs Bottled Water Company has asked you, the controller, to develop a transfer pricing system for the company. The Transportation Department of the company sells all of its product to the Bottling Department of the company. Thus the Transportation Department's sales become the Bottling Department's cost of goods sold. In order to determine an optimal transfer pricing system, management would like you to demonstrate what an income statement would look like under a cost, market, and negotiated transfer pricing structure. These various transfer prices are listed below. Cost-based $0.62 Market-based $0.74 Negotiated $0.69 Gallons transferred 277,000 Prepare an income statement for each of the transfer prices by filling in the missing numbers in the provided income statement based on each transfer price and calculate the operating income/loss percentage. Round your answers to the nearest whole number. Great Springs Bottled Water Company Income Statement (Cost-based) Month Ending August 31, 20xx Transportation Transportanon Bottling Sales $280,000 Cost of goods sold 89.800 Gross profit Expenses: Fuel/utility expense $15,000 $3,300 Wages expense 43,100 57,200 Costs allocated from corporate 17,237 15,000 Total expenses $75,337 $ 75,500 Operating income/loss) in dollars Operating income/(loss) in percentage Great Springs Bottled Water Company Income Statement (Market-based) Month Ending August 31, 20xx Transportation Bottling Sales $286,000 Cost of goods sold 89,305 Gross profit $ $15,000 Expenses: Fuel/utility expense Wages expense Costs allocated from corporate $3,300 57,200 43,100 17,237 $75,337 15,000 > Total expenses $75,500 Operating income/(loss) in dollars Operating income/(loss) in percentage % % Great Springs Bottled Water Company Income Statement (Negotiated) Month Ending August 31, 20xx Transportation Bottling Sales $286,000 Cost of goods sold 89,305 Gross profit Great Springs Bottled Water Company Income Statement (Negotiated) Month Ending August 31, 20xx Transportation Bottling $286,000 Sales Cost of goods sold 89,305 Gross profit Expenses Foel/utility expense $15,000 $3.300 Wages expense 43,100 57,200 Costs allocated from corporate 17,237 15,000 Total expenses $75,337 575,500 Operating income/(los) in dollars Operating income/loss) in percentage Which of the following statements best describes your results? 1. The operating income of the transportation division will be higher than the operating income of the bottling division under all three transfer pricing systems b. The operating Income of the transportation division will be higher than the operating income of the bottling division under the cost-based and market-based transfer pricing systems only c. The operating income of the transportation division will be higher than the operating income of the botting division under the cost-based and negotiated transfer pricing systems only d. The operating income of the transportation division will be higher than the operating income of the botting division under the negotiated and market-based transfer pricing systems only
