Question
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
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 household 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.
Product Lines Furniture Sports Housewares Total Production and sales in units 150,000 170,000 150,000 470,000 Average selling price per unit $ 8.00 $ 22.00 $ 16.00 Average variable production cost per unit 4.00 9.70 8.24 Average variable selling expense per unit 2.00 2.10 2.23 Fixed production overhead, excluding depreciation $ 513,000 Depreciation of plant and equipment 413,000 Administrative and selling expense 1,200,000 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.
Production Staff Sales Staff Furniture $ 122,000 United States $ 62,000 Sports 142,000 Canada 102,000 Housewares 82,000 Mexico 252,000 4. The division managers were able to provide reliable sales percentages for their product lines by geographical area. Percentage of Unit Sales United States Canada Mexico Furniture 40 % 10 % 50 % Sports 40 % 40 % 20 % Housewares 20 % 20 % 60 % Murphy prepared the following product-line income statement based on the data presented above. NORTH AMERICAN INDUSTRIES Segmented Income Statement by Product Lines For the Fiscal Year Ended April 30, 20x0 Product Lines Furniture Sports Housewares Unallocated Total Sales in units 150,000 170,000 150,000 Sales $ 1,200,000 $ 3,740,000 $ 2,400,000 $ 7,340,000 Variable production and selling costs 900,000 2,006,000 1,570,500 $ 4,476,500 Contribution margin $ 300,000 $ 1,734,000 $ 829,500 $ 2,863,500 Fixed costs: Fixed production overhead $ 110,000 $ 226,000 $ 174,000 $ $ 510,000 Depreciation 127,000 148,000 132,000 407,000 Administrative and selling expenses 122,000 142,000 82,000 855,000 1,200,000 Total fixed costs $ 359,000 $ 514,000 $ 389,000 $ 855,000 $ 2,117,000 Operating income (loss) $ (59,000 ) $ 1,220,000 $ 440,500 $ (855,000 ) $ 746,500 Required: 1. Prepare a segmented income statement for North American Industries based on the company's geographical areas. (Round intermediate calculations to 6 decimal places and final answers to the nearest dollar amount.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started