Exercise $9-6($Static$)$ Departmental expense allocations LO P$2$

Gomez Company has two service departments $($Personnel and Office$)$ and two operating departments $($Shoes and Clothing$).$ Following are the direct expenses and square feet occupied by the four departments, and the total sales for the two operating departments.

$\backslash$table$[[$Department$,$Direct Expenses,Square Feet,Sales$],[$Personnel$,$$$18,000,1,120,],[$Office$,25,000,1,400,],[$Shoes$,103,000,7,140,$$$273,000],[$Clothing$,15,000,4,340,77,000]]$

The company also has $$64,000$ of utilities expense, which is an indirect expense to all departments and is allocated to the four departments based on square feet occupied. The Shoes department has $9$ employees and the Clothing department has $3$ employees. Personnel expense is allocated to operating departments based on the number of employees. Office expense is allocated to operating departments based on sales.

Allocate utilities expense to the four departments.

Allocate personnel expense to the Shoes and Clothing departments.

Allocate office expense to the Shoes and Clothing departments.

$\backslash$table$[[\backslash$table$[[$Utilities$],[$Department$]],$Allocation Base,Percent of Allocation Base,Cost to be Allocated,Cost Allocated$],[$Numerator$,$Denominator,$\%$ of Total$],[$Personnel$,,,,0,,],[$Office$,,,,0,,0],[$Shoes$,,,,0,,0],[$Clothing$,,,,0,,],[$Totals$,,,,0,,],[$Personnel expense,Allocation Base,Percent of Allocation Base,Cost to be Allocated,Cost Allocated$],[$Department$,,$Numerator,Denominator,$\%$ of Total,,$],[$Shoes$,,,,0,,],[$Clothing$,,,,0,,],[$Totals$,,,,0,,],[$Office expense,Allocation Base,Percent of Allocation Base,Cost to be Allocated,Cost Allocated$],[$Department$,,$Numerator,Denominator,$\%$ of Total,,$],[$Shoes$,,,,0,,],[$Clothing$,,,,0,,],[$Totals$,,,,0,,]]$