Name: ________________________________ The following table concerns the allocation of overhead expenses at a central office. From the information given in the following table, compute the allocations indicated in problems #1 - #4. Remember: Answers for each problem should sum to the total monthly overhead expense. Locations Monthly Overhead Expense Total Expense Basis of Allocation North East West South TOTAL Insurance $40,000 Square feet 13,420 13,420 15,860 18,300 61000 sq. feet Utilities $21,000 Machine hours worked 17,200 21,500 25,800 21,500 86000 hours Rent $36,000 Units produced 6,970 12,300 13,120 8,610 41000 units Maintenance $25,000 Number of Employees 20 27 28 25 100 employees #1. Allocate insurance expense based on the number of square feet at each location: North: $__________________ East: $__________________ West : $__________________ South: $__________________ #2. Allocate utilities expense based on the number of machine hours worked at each location: North: $__________________ East: $__________________ West : $__________________ South: $__________________ #3. Allocate rent expense based on the number of units produced at each location: North: $__________________ East: $__________________ West : $__________________ South: $__________________ #4. Allocate maintenance expense based on the number of employees at each location: North: $__________________ East: $__________________ West : $__________________ South: $__________________ #5. Total expense based on the four categories: North: $__________________ East: $__________________ West : $__________________ South: $__________________ TOTAL: $122,000