Please respond like the table provided

Exercise $22-5($Algo$)$ Departmental expense allocations LO P$2$

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

$\backslash$table$[[$Department$,$Employees,Square Feet,Asset Values$],[$Materials$,28,39,000,$$$12,600],[$Personnel$,7,6,500,3,150],[$Manufacturing$,63,65,000,31,500],[$Packaging$,42,19,500,15,750],[$Total$,140,130,000,$$$63,000]]$

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

$\backslash$table$[[$Indirect Expense,Allocation Base$],[$Supervision$,$$$82,800$ Number of employees$],[$Utilities$,53,000$ Square feet occupied$],[$Insurance$,24,000$ Asset values$],[$Total$,$$$159,800]]$

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

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