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. The company also has $66,000 of utlities 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 36 employees and the Clothing department has 84 employees. Personnel expense is allocated to operating departments based on the number of employees. Office expense is allocated to operating departments based on sales. 1. Allocate utilities expense to the four departments. 2. Allocate personnel expense to the Shoes and Clothing departments. 3. Allocate office expense to the Shoes and Clothing departments. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Utilitios & Allocation Base & \multicolumn{3}{|c|}{ Percent of Allocation Base } & \multirow[t]{2}{*}{ Cost to bo Allocated } & \multirow[t]{2}{*}{ Allocated Cost } \\ \hline Department & Square feet occupled & Numerator & Denominator & % of Total & & \\ \hline Personnel & 400 & 400 & 5,000 & 8.00% & 64,000 & \\ \hline Otfice & 400 & 400 & 5,000 & 8.00% & 64,000 & \\ \hline Shoes & 1,600 & 1,600 & 5,000 & 32.00% & 64,000 & \\ \hline Clothing & 2,600 & 2,600 & 5,000 & 52.00% & 64,000 & \\ \hline Totals & 5,000 & & & 100.00% & & 64,000 \\ \hline Personnel expense & Allocation Base & \multicolumn{3}{|c|}{ Percent of Allocation Base } & Cost to be Allocated & \& Allocated Cost \\ \hline Department & & Numerator & Denominator & % of Total & & \\ \hline Shoes & + & & & 0 & & \\ \hline Clothing & & & & 0 & & \\ \hline Totals & & & & 0 & & \\ \hline Office expense & Allocation Base & \multicolumn{3}{|c|}{ Percent of Allocation Base } & Cost to be Allocated & Allocated Cost \\ \hline Department & & Numerator & Denominator & % of Total & & \\ \hline Shoes & & & & 0 & & \\ \hline Clothing & & & & 0 & & \\ \hline Totals & & & & 0 & & \\ \hline \end{tabular}