Karen Cohas 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 Cost Allocation Base Supervision $ 83,700 Number of employees Utilities 62,000 Square feet occupied Insurance Value of assets 28,500 in use Total $174,200 Departmental data for the company's recent reporting period follow. Department Employees Square Asset Feet Values Materials 24 28,750 $ 7,200 Personnel 12 11,500 2,880 Manufacturing 48 57,500 37,440 Packaging 36 17,250 24,488 Total 120 115,000 $72,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 Required Use this information to allocate each of the three indirect expenses across the four departments Supervision Allocation expenses Cost to be Allocated Percent of Allocation Base Base Allocated Cost Department Number of Numerator Denominator % of employees Total Materials 24 24 0 Personnel 12 12 0 Manufacturing 48 48 0 o Packaging 36 36 0 0 Totals 120 0 Utilities Allocation Base Cost to be Percent of Allocation Base Allocated Allocated Cost Department Square feet Occupied of Numerator Denominator Total Materials 28.750 0 Personnel 115 000 0 Manufacturing 57.500 0 0 Packaging 17.250 0 0 Totals 218.500 0 Insurance Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost VDO Department % of assets in use Numerator Denominator TO Materials 5 2200 6 000 $ 50 000 10 001 Personnel 2.880 0 Manufacturing 37440 0 Packaging 24 480 80.000 0.00% Total 5 72.000 0 od Karen 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 Cost Allocation Base Expense Supervision $ 83,700 Number of employees Utilities occupied Insurance Value of assets 28,500 in use Total $174,200 62,000 square feet Departmental data for the company's recent reporting period follow. Department Employees Materials 24 Personnel 12 Manufacturing 48 Packaging 36 Total 120 Square Feet 28,750 11,500 57,500 17,250 115,000 Asset Values $ 7,200 2,880 37,440 24,489 $72,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 Required Prepare a summary table that reports the Indirect expenses assigned to each of the four departments. Supervision Utilities Insurance Total Materials $0 Personnel Manufacturing Packaging Totals $ 0 $ 0 $ 0
