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,$\backslash$table$[[$Square$],[$Feet$]],\backslash$table$[[$Asset$],[$Values$]]],[$Materials$,27,58,000,7,500],[\backslash$table$[[$Personnel$],[$Manufacturing$],[$Packaging$]],\backslash$table$[[9],[60],[54]],\backslash$table$[[7,250],[65,250],[14,500]],\backslash$table$[[1,500],[48,750],[17,250]]],[$Total$,150,145,000,75,{000}^{\text{\$}}$