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.61 Market-based $0.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 Great Springs Bottled Water Company Income Statement (Cost-based) Month Ending August 31, 20xx Transportation Bottling Sales $fill in the blank 1 $285,000 Cost of goods sold 87,864 fill in the blank 2 Gross profit $fill in the blank 3 $fill in the blank 4 Expenses: Fuel/utility expense $16,000 $3,200 Wages expense 43,080 57,300 Costs allocated from corporate 17,235 15,000 Total expenses $76,315 $75,500 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 $285,000 Cost of goods sold 87,864 fill in the blank 10 Gross profit $fill in the blank 11 $fill in the blank 12 Expenses: Fuel/utility expense $16,000 $3,200 Wages expense 43,080 57,300 Costs allocated from corporate 17,235 15,000 Total expenses $76,315 $75,500 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 $285,000 Cost of goods sold 87,864 fill in the blank 18 Gross profit $fill in the blank 19 $fill in the blank 20 Expenses: Fuel/utility expense $16,000 $3,200 Wages expense 43,080 57,300 Costs allocated from corporate 17,235 15,000 Total expenses $76,315 $75,500 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.61
Market-based $0.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
Great Springs Bottled Water Company
Income Statement (Cost-based)
Month Ending August 31, 20xx
  Transportation Bottling
Sales $fill in the blank 1   $285,000  
Cost of goods sold 87,864   fill in the blank 2  
Gross profit $fill in the blank 3   $fill in the blank 4  
Expenses:        
Fuel/utility expense $16,000   $3,200  
Wages expense 43,080   57,300  
Costs allocated from corporate 17,235   15,000  
Total expenses $76,315   $75,500  
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   $285,000  
Cost of goods sold 87,864   fill in the blank 10  
Gross profit $fill in the blank 11   $fill in the blank 12  
Expenses:        
Fuel/utility expense $16,000   $3,200  
Wages expense 43,080   57,300  
Costs allocated from corporate 17,235   15,000  
Total expenses $76,315   $75,500  
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   $285,000  
Cost of goods sold 87,864   fill in the blank 18  
Gross profit $fill in the blank 19   $fill in the blank 20  
Expenses:        
Fuel/utility expense $16,000   $3,200  
Wages expense 43,080   57,300  
Costs allocated from corporate 17,235   15,000  
Total expenses $76,315   $75,500  
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 %
Expert Solution
steps

Step by step

Solved in 2 steps with 4 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