QS $22-7($Algo$)$ Allocating costs to departments LO P$2$

SodaPop Company has two operating departments: Mixing and Bottling. Mixing has $375$ employees and Bottling has $375$ employees. Office costs of $$220,000$ are allocated to operating departments based on the number of employees. Determine the office costs allocated to each operating department.

$\backslash$table$[[$Department$,$Employees,Percent of Total,Cost Allocated$],[$Mixing$,,,\%,],[$Bottling$,,,\%,],[$Total$,0\mathrm{.}00,\%,$$$,]]$