50.1K

Verified Solution

Link Copied!

Pacific Rim Industries is a diversified company whose productsare marketed both domestically and internationally. The company’smajor product lines are furniture, sports equipment, and householdappliances. At a recent meeting of Pacific Rim’s board ofdirectors, there was a lengthy discussion on ways to improveoverall corporate profitability. The members of the board decidedthat they required additional financial information aboutindividual corporate operations in order to target areas forimprovement.

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

	Product Lines
	Furniture			Sports			Appliances			Total
Production and sales in units		170,000			212,500			170,000			552,500
Average selling price per unit	$	9.00		$	20.00		$	20.00
Average variable manufacturing cost per unit		4.00			10.20			14.50
Average variable selling expense per unit		3.00			2.40			2.25
Fixed manufacturing overhead, excluding depreciation										$	562,000
Depreciation of plant and equipment											442,000
Administrative and selling expense											1,180,000

   

1. The division managers concluded that Murphy should allocatefixed manufacturing overhead to both product lines and geographicareas on the basis of the ratio of the variable costs expended tototal variable costs.

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

3. There was little agreement on the allocation of administrativeand selling expenses, so Murphy decided to allocate only thoseexpenses 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	$	125,000		United States	$	65,000
Sports		145,000		Canada		105,000
Appliances		85,000		Asia		255,000

   

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

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

   

Murphy prepared the following product-line income statementbased 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		170,000				212,500				170,000
Sales	$	1,530,000			$	4,250,000			$	3,400,000				—			$	9,180,000
Variable manufacturing and selling costs		1,190,000				2,677,500				2,847,500				—				6,715,000
Contribution margin	$	340,000			$	1,572,500			$	552,500				—			$	2,465,000
Fixed costs:
Fixed manufacturing overhead	$	99,595			$	224,089			$	238,316			$	—			$	562,000
Depreciation		136,000				170,000				136,000				—				442,000
Administrative and selling expenses		125,000				145,000				85,000				825,000				1,180,000
Total fixed costs	$	360,595			$	539,089			$	459,316			$	825,000			$	2,184,000
Operating income (loss)	$	(20,595	)		$	1,033,411			$	93,184			$	(825,000	)		$	281,000

Required:

1. Prepare a segmented income statement for Pacific Rim Industriesbased on the company’s geographical areas. The statement shouldshow the operating income for each segment. (Do not roundyour intermediate calculations and round your final answers to thenearest dollar amount.)