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 50.74 Negotiated $0.70 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 Bottling $206,000 Sales 89,305 Cost of goods sold Gross profit Expenses: $14,000 43,080 17,236 $74,316 Fuel/utility expense Wages expense Costs allocated from corporate Total expenses Operating income/(loss) in dollars $3,100 57,200 14,000 $74,300 Operating income/(loss) in percentage Great Springs Bottled Water Company Matsed 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 Expenses: $14,000 Fuel/utility expense Wages expense Costs allocated from corporate Total expenses 43,080 17,236 $3,100 57,200 14,000 $74,316 $74,300 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 Expenses: Fuel/utility expense $14,000 43,080 17,236 $3,100 57,200 14,000 Wages expense Costs allocated from corporate Previous Next Ch 09 HW Operating Income/(loss) in percentage 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: Fuel/utility expense $3,100 Wages expense $14,000 43,080 17,236 57,200 14,000 $74,300 Costs allocated from corporate $74,316 Total expenses Operating income/(loss) in dollars Operating income/(loss) in percentage Which of the following statements best describes your results? a. 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 bottling 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 bottling division under the negotiated and market-based transfer pricing systems only
