Exercise 22-5 Departmental expense allocations LO P2 Woh Che Co has four departments Materials, Personnel, Manufacturing, and Packaging in a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow Indirect Expense Supervision Utilities Insurance Total Cost Allocation Base $ 83,500 Number of employees 60,000 square feet occupied 27,500 Value of assets in use $171,000 Departmental data for the company's recent reporting period follow Department Materials Personnel Manufacturing Packaging Total Employees 20 10 40 Square Feet 40, 10.000 120,000 30,000 200,000 Asset Values $14,000 1,400 35,000 19.600 $70,000 100 1. Use this information to allocate each of the three indirect expenses across the four departments 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments Complete this question by entering your answers in the tabs below. --- 1. Use this information to allocate each of the three indirect expenses across the four departments 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments Complete this question by entering your answers in the tabs below. Required 1 Required 2 ces Use this information to allocate each of the three indirect expenses across the four departments. Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominato % of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Allocation Base Cost to Allocated Allocated Cost Percent of Allocation Base Numerator Denominato % of Total Numerator Denominator % of Total Department Materials Personnel Manufacturing Packaging Totals Cost to be Allocated Allocated Cost Allocation Base Percent of Allocation Base Numerator Denominato % of Total Litilities Department Materials Personnel Manufacturing Packaging Totals Insurance Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Department Materials Personnel Manufacturing Packaging Totals Department Materials Personnel Manufacturing Packaging Total Employees 20 10 40 30 100 Square Feet 40,000 10,000 120,000 30,000 200,000 Asset Values $14,000 1,400 35,000 19,600 $70,000 1. Use this information to allocate each of the three indirect expenses across the four departments 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Total Supervision Utilities Insurance Materials Personnel Manufacturing Packaging Totals ! Next > Exercise 22-1 Responsibility accounting report-cost center LO P1 Arctica manufactures snowmobiles and ATVs. These products are made in different departments, and each department has its own manager. Each responsibility performance report only includes those costs that the particular department manager can control raw materials, wages, supplies used, and equipment depreciation Snowmobile $19,920 11,210 Raw materials Employee wages Dept. manager salary Supplies used Depreciation-Equip. Utilities Rent Totals Snowmobile $19,990 10,900 4,800 3,850 6,500 410 6,200 $52,650 Budget ATV $28,000 21,000 5,700 1,400 13,000 590 6,800 $76,490 Combined $ 47,990 31,900 10,500 5,250 19,500 1.000 13,000 $129,140 3,670 6,500 380 5,800 $52,380 Actual ATV Combined $29,320 $ 49,240 21,740 32,950 9,800 1,420 5,00 13,000 19,500 550 930 6,800 12,600 $77,730 $130,110 Prepare a responsibility accounting report for the snowmobile department (Under budget amounts should be indicated by a minus sign.) Responsibility Accounting Performance Report Dept. Manager, Snowmobile Department For the Year Budgeted Over (Unden Next > Totals Prepare a responsibility accounting report for the snowmobile department. (L sign.) Over (Under) Budget Responsibility Accounting Performance Report Dept. Manager, Snowmobile Department For the Year Budgeted Actual Amount Amount Controllable Costs Raw materials Employee wages Supplies used Depreciation Equipment Totals $ 0 $ 0 $ O