Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pacific Rim Industries is a diversified company whose products are marketed both domestically and internationally. The companys major product lines are furniture, sports equipment, and

Pacific Rim Industries is a diversified company whose products are marketed both domestically and internationally. The companys major product lines are furniture, sports equipment, and household appliances. At a recent meeting of Pacific Rims board of directors, there was a lengthy discussion on ways to improve overall corporate profitability. The members of the board decided that they required additional financial information about individual corporate operations in order to target areas for improvement.

Danielle Murphy, the controller, has been asked to provide additional data that would assist the board in its investigation. Murphy believes that income statements, prepared along both product lines and geographic areas, would provide the directors with the required insight into corporate operations. Murphy had several discussions with the division managers for each product line and compiled the following information from these meetings.

Product Lines
Furniture Sports Appliances Total
Production and sales in units 216,000 202,500 216,000 634,500
Average selling price per unit $ 7.00 $ 18.00 $ 17.00
Average variable manufacturing cost per unit 3.00 9.50 11.50
Average variable selling expense per unit 2.00 2.50 2.75
Fixed manufacturing overhead, excluding depreciation $ 528,000
Depreciation of plant and equipment 507,600
Administrative and selling expense 1,180,000

The division managers concluded that Murphy should allocate fixed manufacturing overhead to both product lines and geographic areas on the basis of the ratio of the variable costs expended to total variable costs.

Each of the division managers agreed that a reasonable basis for the allocation of depreciation on plant and equipment would be the ratio of units produced per product line (or per geographical area) to the total number of units produced.

There was little agreement on the allocation of administrative and selling expenses, so Murphy decided to allocate only those expenses that were traceable directly to a segment. For example, manufacturing staff salaries would be allocated to product lines, and sales staff salaries would be allocated to geographic areas. Murphy used the following data for this allocation.

Manufacturing Staff Sales Staff
Furniture $ 140,000 United States $ 80,000
Sports 160,000 Canada 120,000
Appliances 100,000 Asia 270,000

The division managers were able to provide reliable sales percentages for their product lines by geographical area.

Percentage of Unit Sales
United States Canada Asia
Furniture 50 % 10 % 40 %
Sports 40 % 40 % 20 %
Appliances 30 % 30 % 40 %

Murphy prepared the following product-line income statement based on the data presented above.

PACIFIC RIM INDUSTRIES
Segmented Income Statement by Product Lines
For the Fiscal Year Ended April 30, 20x0
Product Lines
Furniture Sports Appliances Unallocated Total
Sales in units 216,000 202,500 216,000
Sales $ 1,512,000 $ 3,645,000 $ 3,672,000 $ 8,829,000
Variable manufacturing and selling costs 1,080,000 2,430,000 1,890,000 5,400,000
Contribution margin $ 432,000 $ 1,215,000 $ 1,782,000 $ 3,429,000
Fixed costs:
Fixed manufacturing overhead $ 105,600 $ 237,600 $ 184,800 $ $ 528,000
Depreciation 172,800 162,000 172,800 507,600
Administrative and selling expenses 140,000 160,000 100,000 780,000 1,180,000
Total fixed costs $ 418,400 $ 559,600 $ 457,600 $ 780,000 $ 2,215,600
Operating income (loss) $ (13,600 ) $ 655,400 $ 1,324,400 $ (780,000 ) $ 1,213,400

Required:

Prepare a segmented income statement for Pacific Rim Industries based on the companys geographical areas. The statement should show the operating income for each segment. (Round intermediate calculations to 2 decimal places (i.e. 0.1234 is 12.34%) and final answers to the nearest dollar amount.)

PACIFIC RIM INDUSTRIES
Segmented Income Statement by Geographic Areas
For the Fiscal Year Ended April 30, 20x0
Geographic Areas
United States Canada Asia Unallocated Total
Sales in units
Furniture 0
Sports 0
Appliances 0
Total unit sales 0 0 0 0
Revenue
Furniture $0
Sports 0
Appliances 0
Total revenue $0 $0 $0 $0
Variable costs
Furniture $0
Sports 0
Appliances 0
Total variable costs $0 $0 $0 $0
Contribution margin $0 $0 $0 $0
Fixed costs
Manufacturing overhead $0
Depreciation 0
Administrative and selling expenses 0
Total fixed costs $0 $0 $0 $0
Operating income (loss) $0 $0 $0 $0 $0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Solitary Auditor

Authors: Michael Knapp

1st Edition

161163878X, 978-1611638783

More Books

Students also viewed these Accounting questions

Question

4. Will technology eliminate the need for HR managers?

Answered: 1 week ago