North American Industries is a diversified company whose products are marketed both domestically and internationally. The company's major product lines are furniture, sports equipment, and house hold appliances. At a recent meeting of the 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.

1. The division managers concluded that Murphy should allocate fixed production overhead to both product lines and geographic areas on the basis of the ratio of the variable costs expended to total variable costs.
2. 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.
3. 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.

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

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

Required:
1. Prepare a segmented income statement for North American Industries based on the company’s geographical areas. The statement should show the operating income for each segment.
2. As a result of the information disclosed by both segmented income statements (by product line and by geographical area), recommend areas where North American Industries should focus its attention in order to improve corporate profitability.
(CMA,adapted)

Transcribed Image Text:

Product Lines Furniture SportsHousewares 250,000 Production and sales in units Average selling price per unit Average Average variable selling expense per unit Fixed production overhead, 90,000 $16.00 variable production cost per unit .8.00 ..4.00 19.00 5.00 $30.00 16.50 4.50 Depreciation of plant and equipment.. Administrative and selling expense.. S 500,000 400,000 1,160,000 Production Staff Sales Staf Furniture Sports Housewares 120,000 United 140,000 80,000 $60,000 100,000 250,000 Staies. Mexoico Percentage of Unit Sales United States 40% 40% 20% Canada 10% 40% 20% Mexico 50% 20% 60% Sports Housewares. NORTH ANERICAN INDUSTRIES Segmented Income Statement by Product Lines For the Fiscal Year Ended April 30, 20x4 Product Lines Furniture Sports Housewares Unallocated Total Sales in units 80,000 $1,280,000 $3,600,000 $2,400,000 Variable production and selling costs.960,000 2,160,000 1,680,000 S 320,000 $1,440,000 S 720,000 80,030 90,000 $7,280,000 4,800,000 2,480,000 Sales Contribution margin Fixed costs: Fixed production overhead Depreciation. Administrative and selling expenses 500,000 400,000 1,160,000 S 348,000 $509,000 S 383,000 820,000 2,060,000 $ (28,000)931,000 S 337,000 $/820,000) S 420,000 100,000 225,000 S 175,000 128,000 80,000 28,000 144,000 140,000 120,000 820.000 Total fixed costs Operating income (loss)