Need Help finding Manufacturing overhead and Depreciation.

Pacific Rim Industries is a diversified c mpany whose products are marketed both a mestically and internationally. The cmpany's major product lines are furniture, sports equipment, and household appliances. At a recent meeting of Pacific Rim's 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 ab ut individual corporateperations in rder 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. Wuld 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 198,000 Total 473,000 Production and sales in units Average selling price per unit Average variable manufacturing cost per unit Average variable selling expense per unit Fixed manufacturing overhead, 137,500 $ 10.00 20.00 23.00 16.50 2.50 137,500 5.00 3.00 10.00 2.50 excluding depreciation Depreciation of plant and equipment Administrative and selling expense $ 550,000 378,400 1,150,000 1. The division managers concluded that Murphy should allocate fixed manufacturing overhead to both product lines and geographic 2. Each of the division managers agreed that a reasonable basis for the allocation of depreciation on plant and equipment would be 3. There was little agreement on the allocation of administrative and selling expenses, so Murphy decided to allocate only those areas on the basis of the ratio of the variable costs expended to total variable costs the ratio of units produced per product line (or per geographical area) to the total number of units produced 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 Furniture Sports Appliances Sales Staff $125,000 United States 145,000 Canada 85,000 Asia $ 65,000 105,000 255,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 Furniture Sports Appliances 58% 40% 40% 88% 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 3e, 2exe Product Lines Furniture Appliances 53,162,500 $ 550,800 S 232,222 Unallocated Sales in units Sales variable manufacturing and selling costs Contribution margin Fixed costs: 198,e00 $1,375,eee $3,968,e8e 2,475,0ee S 275,800 $1,485,800 $8,497,500 6.187,500 52,319,0e Fixed manufacturing overhead Depreciation Administrative and selling expenses Total fixed costs $ 97,778 22e,e0e 118,600 378,400 1,150,e00 158 S 332,778 523,408 5 427,222 795,80 (795,eee) operating income (loss) S (57,778) $ 961,600 S 122,778 231,6ee re 1. Prepare a segmented income statement for Pacific Rim Industries based on the company's geographical areas. The statement should show the operating income for each segment. (Do not round your intermediate calculations and round your final answers to the nearest dollar mount.) PACIFIC RIM INDUSTRIES Segmented Income Statement by Geographic Areas For the Fiscal Year Ended April 30, 20x0 Geographic Areas United States Canada Unallocated Sales in units 137,500 198,000 137,500 473.000 Furniture 55,000 79.200 13,750 147,950 79,200 39.600 110.000 Total unit sales 106,700 s 550,00037,500 687,500 792,000 2,530,000 S 2,450,250 S 2,037,750S 4,009,500 Furniture S 1,375,000 1,584,000 1,584,000 3,960,000 316.250 316,250 Total revenue S 8,497,500 Variable costs Furniture S 440,000 S 000 S 550,000 S 1,100,000 2,475,000 2,612,500 S 6,187,500 S 2,310,000 990,000 990,000 261,250 2,090,000 S 1,691,250 S 1,361,250S 3,135,000 S 759,000 S 676,500S 874,500 261.250 Total variable costs Fixed costs Manufacturing overhead Depreciation Administrative and selling expenses 55000725,000 1,150,000 65.000 | $ 105.000 IS 255.000 | $ 725.000|$ 1.150.000 S 694,000 571,500 S 619,500 (725,000S 1,160,000 105,000 Total fixed costs Operating income (loss)