In: Accounting
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 | Cost | Allocation Base | |
Supervision | $ | 84,500 | Number of employees |
Utilities | 70,000 | Square feet occupied | |
Insurance | 32,500 | Value of assets in use | |
Total | $ | 187,000 | |
Departmental data for the company’s recent reporting period
follow.
Department | Employees | Square Feet | Asset Values | |||||||||
Materials | 40 | 39,000 | $ | 12,000 | ||||||||
Personnel | 10 | 19,500 | 1,600 | |||||||||
Manufacturing | 84 | 107,250 | 47,200 | |||||||||
Packaging | 66 | 29,250 | 19,200 | |||||||||
Total | 200 | 195,000 | $ | 80,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.
Answer to Part 1 | ||||||
Super Vision Expenses | Allocation Base | Percentage of Allocation | Indirect Cost | Allocated Cost | ||
Department | Number of Employees | Numerator | Denominator | % of Total | (Indirect Cost*% of Total) | |
Materials | 40 | 40 | 200 | 20% | 84500 | 16900 |
Personnel | 10 | 10 | 200 | 5% | 84500 | 4225 |
Manufacturing | 84 | 84 | 200 | 42% | 84500 | 35490 |
Packaging | 66 | 66 | 200 | 33% | 84500 | 27885 |
Total | 200 | 84500 | ||||
Utilities | Allocation Base | Percentage of Allocation | Indirect Cost | Allocated Cost | ||
Department | Square Feet Occupied | Numerator | Denominator | % of Total | ||
Materials | 39000 | 39000 | 195000 | 20% | 70000 | 14000 |
Personnel | 19500 | 19500 | 195000 | 10% | 70000 | 7000 |
Manufacturing | 107250 | 107250 | 195000 | 55% | 70000 | 38500 |
Packaging | 29250 | 29250 | 195000 | 15% | 70000 | 10500 |
Total | 195000 | 70000 | ||||
Insurance | Allocation Base | Percentage of Allocation | Indirect Cost | Allocated Cost | ||
Department | Asset Value | Numerator | Denominator | % of Total | ||
Materials | 12000 | 12000 | 80000 | 15% | 32500 | 4875 |
Personnel | 1600 | 1600 | 80000 | 2% | 32500 | 650 |
Manufacturing | 47200 | 47200 | 80000 | 59% | 32500 | 19175 |
Packaging | 19200 | 19200 | 80000 | 24% | 32500 | 7800 |
Total | 80000 | 32500 |
Answer to Part 2: | ||||
Super Vision Expenses | Utilities | Insurance | Total | |
Materials | 16900 | 14000 | 4875 | 35775 |
Personnel | 4225 | 7000 | 650 | 11875 |
Manufacturing | 35490 | 38500 | 19175 | 93165 |
Packaging | 27885 | 10500 | 7800 | 46185 |
84500 | 70000 | 32500 | 187000 |