Exercise 22-5 (Algo) Departmental expense allocations LO P2Renata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows.Employees Square Feet34176851170DepartmentMaterialsPersonnelManufacturingPackagingTotalThe four departments share the following indirect expenses for supervision, utilities, and insurance according to their allocation bases.Indirect ExpenseSupervisionUtilitiesInsuranceTotalSupervision expensesDepartmentMaterialsPersonnelAllocate each of the three indirect expenses to the four departments.ManufacturingPackagingTotalsUtilitiesDepartmentMaterialsPersonnel32,00016,00088,00024,000160,000ManufacturingPackagingTotalsAsset Values$ 13,2001,98034,98015,840$ 66,000CostAllocation Base$ 83,100 Number of employees56,000 Square feet occupied25,500 Asset values$ 164,600Allocation BaseAllocation BasePercent of Allocation BaseNumerator Denominator % of TotalPercent of Allocation BaseNumerator Denominator % of TotalCost to be Allocated Allocated CostCost to be Allocated Allocated Cost InsuranceDepartmentMaterialsPersonnelManufacturingPackagingTotalsAllocation BasePercent of Allocation BaseNumerator Denominator % of TotalCost to be Allocated Allocated Cost

Activity-based costing is used to distribute the overhead. Using ABC, overheads are allocated on the…

Exercise 22-5 (Algo) Departmental expense allocations LO P2 Renata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows. Employees Square Feet 34 17 Department Materials Personnel Manufacturing Packaging Total 68 51 170 Indirect Expense Supervision Utilities Insurance Total 32,000 16,000 88,000 24,000 160,000 Asset Values $ 13,200 1,980 34,980 15,840 $ 66,000 The four departments share the following indirect expenses for supervision, utilities, and insurance according to their allocation bases Cost Allocation Base $ 83,100 Number of employees 56,000 Square feet occupied 25,500 Asset values $ 164,600 Allocate each of the three indirect expenses to the four departments.