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.73 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 Sales $fill in the blank 1   $286,000   Cost of goods sold 89,305   fill in the blank 2   Gross profit $fill in the blank 3   $fill in the blank 4   Expenses:         Fuel/utility expense $14,000   $3,200   Wages expense 43,090   57,100   Costs allocated from corporate 17,237   15,000   Total expenses $74,327   $75,300   Operating income/(loss) in dollars $fill in the blank 5   $fill in the blank 6   Operating income/(loss) in percentage fill in the blank 7 % fill in the blank 8 %   Great Springs Bottled Water Company Income Statement (Market-based) Month Ending August 31, 20xx   Transportation Bottling Sales $fill in the blank 9   $286,000   Cost of goods sold 89,305   fill in the blank 10   Gross profit $fill in the blank 11   $fill in the blank 12   Expenses:         Fuel/utility expense $14,000   $3,200   Wages expense 43,090   57,100   Costs allocated from corporate 17,237   15,000   Total expenses $74,327   $75,300   Operating income/(loss) in dollars $fill in the blank 13   $fill in the blank 14   Operating income/(loss) in percentage fill in the blank 15 % fill in the blank 16 %   Great Springs Bottled Water Company Income Statement (Negotiated) Month Ending August 31, 20xx   Transportation Bottling Sales $fill in the blank 17   $286,000   Cost of goods sold 89,305   fill in the blank 18   Gross profit $fill in the blank 19   $fill in the blank 20   Expenses:         Fuel/utility expense $14,000   $3,200   Wages expense 43,090   57,100   Costs allocated from corporate 17,237   15,000   Total expenses $74,327   $75,300   Operating income/(loss) in dollars $fill in the blank 21   $fill in the blank 22   Operating income/(loss) in percentage fill in the blank 23 % fill in the blank 24 %

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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.73
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
Sales $fill in the blank 1   $286,000  
Cost of goods sold 89,305   fill in the blank 2  
Gross profit $fill in the blank 3   $fill in the blank 4  
Expenses:        
Fuel/utility expense $14,000   $3,200  
Wages expense 43,090   57,100  
Costs allocated from corporate 17,237   15,000  
Total expenses $74,327   $75,300  
Operating income/(loss) in dollars $fill in the blank 5   $fill in the blank 6  
Operating income/(loss) in percentage fill in the blank 7 % fill in the blank 8 %

 

Great Springs Bottled Water Company
Income Statement (Market-based)
Month Ending August 31, 20xx
  Transportation Bottling
Sales $fill in the blank 9   $286,000  
Cost of goods sold 89,305   fill in the blank 10  
Gross profit $fill in the blank 11   $fill in the blank 12  
Expenses:        
Fuel/utility expense $14,000   $3,200  
Wages expense 43,090   57,100  
Costs allocated from corporate 17,237   15,000  
Total expenses $74,327   $75,300  
Operating income/(loss) in dollars $fill in the blank 13   $fill in the blank 14  
Operating income/(loss) in percentage fill in the blank 15 % fill in the blank 16 %

 

Great Springs Bottled Water Company
Income Statement (Negotiated)
Month Ending August 31, 20xx
  Transportation Bottling
Sales $fill in the blank 17   $286,000  
Cost of goods sold 89,305   fill in the blank 18  
Gross profit $fill in the blank 19   $fill in the blank 20  
Expenses:        
Fuel/utility expense $14,000   $3,200  
Wages expense 43,090   57,100  
Costs allocated from corporate 17,237   15,000  
Total expenses $74,327   $75,300  
Operating income/(loss) in dollars $fill in the blank 21   $fill in the blank 22  
Operating income/(loss) in percentage fill in the blank 23 % fill in the blank 24 %
Transportation
Bottiing
Sales
$286,000
Cost of goods sold
89,305
Gross profit
$
Expenses:
Fuel/utility expense
$14,000
$3,200
Wages expense
43,090
57,100
Costs allocated from corporate
17,237
15,000
Total expenses
$74,327
$75,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
$3,200
Wages expense
43,090
57,100
Costs allocated from corporate
17,237
15,000
Total expenses
$74,327
$75,300
Transcribed Image Text:Transportation Bottiing Sales $286,000 Cost of goods sold 89,305 Gross profit $ Expenses: Fuel/utility expense $14,000 $3,200 Wages expense 43,090 57,100 Costs allocated from corporate 17,237 15,000 Total expenses $74,327 $75,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 $3,200 Wages expense 43,090 57,100 Costs allocated from corporate 17,237 15,000 Total expenses $74,327 $75,300
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.73
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
he operating income/loss percentage. Round your answers to the nearest
number
Great Springs Bottled Water Company
Income Statement (Cost-based)
Month Ending August 31, 20xx
Transportation
Bottling
Sales
2$
$286,000
Cost of goods sold
89,305
Gross profit
$4
Expenses:
Fuel/utility expense
$14,000
$3,200
Wages expense
43,090
57,100
Costs allocated from corporate
17,237
15,000
Total expenses
$74,327
$75,300
Operating income/(loss) in dollars
$
Operating income/(loss) in percentage
%
Transcribed Image Text: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.73 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 he operating income/loss percentage. Round your answers to the nearest number Great Springs Bottled Water Company Income Statement (Cost-based) Month Ending August 31, 20xx Transportation Bottling Sales 2$ $286,000 Cost of goods sold 89,305 Gross profit $4 Expenses: Fuel/utility expense $14,000 $3,200 Wages expense 43,090 57,100 Costs allocated from corporate 17,237 15,000 Total expenses $74,327 $75,300 Operating income/(loss) in dollars $ Operating income/(loss) in percentage %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 6 images

Blurred answer
Knowledge Booster
Transfer Pricing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education