Renata Company has four departments: Materlals, Personnel, Manufacturing, and Packaging. Information follows.

$\backslash$table$[[$Department$,$Employees,Square Feet,Asset Values$],[$Materials$,27,58,609,$$$7,509],[$Personnel$,9,7,250,1,509],[$Manufacturing$,69,65,250,48,750],[$Packaging$,54,14,509,17,250],[$Total$,150,145,609,$$$75,609]]$

The four departments share the following indirect expenses for supervislon, utilitles, and insurance according to their allocation bases.

$\backslash$table$[[$Indirect Expense,Cost,Allocation Base$],[$Supervision$,$$$84,690$ Number of employees,$],[$Utilities$,65,690$ Square feet occupied,$],[$Insurance$,39,699$ Asset values,$],[$Total$,$$$179,090,]]$

Allocate each of the three indirect expenses to the four departments.

$\backslash$table$[[\backslash$table$[[$Supervision$],[$expenses$]],$Allocation Base,Percent of Allocation Base,$\backslash$table$[[$Cost to be$],[$Allocated$]],$Allocated Cost$],[$Department$,,$Numerato Denominator $\%$ of Total,,$],[$Materials$],[$Personnel$],[$Manufacturing$],[$Packaging$],[$Totals$],[$Utilities$,$Allocation Base,Percent of Allocation Base,$\backslash$table$[[$Cost to be$],[$Allocated$]],$Allocated Cost$],[$Department$,,$Numerator Denominator $\%$ of Total,,$],[$Materials$],[$Personnel$],[$Manufacturing$],[$Packaging$],[$Totals$],[$Insurance$,$Allocation Base,Percent of Allocation Base,$\backslash$table$[[$Cost to be$],[$Allocated$]],$Allocated Cost$],[$Department$,,$Numerator Denominator $\%$ of Total,,$],[$Materials$],[$Personnel$],[$Manufacturing$],[$Packaging$],[$Totals$,,,,,]]$