Exercise $22-3($Algo$)$ Service department expenses allocated to operating departments LO P$2$

Lucia Company has two service departments: Office and Purchasing. Total expenses for the Office is $$85,600$ and for Purchasing is $$51,400.$ Expenses for the Office are allocated to operating departments based on sales. Expenses for Purchasing are allocated to operating departments based on purchase orders.

$\backslash$table$[[$Department$,$Sales,$\backslash$table$[[$Purchase$],[$Orders$]]],[$Books$,$$$193,200,1,551],[$Magazines$,109,200,693],[$Newspapers$,117,600,1,056],[$Total$,$$$420,000,3,300]]$

Allocate the expenses from $($a$)$ the Office and $($b$)$ Purchasing to each of the company's three operating departments using the given information.

$\backslash$table$[[$Office$,$Allocation Base,Percent of Allocation Base,Cost to be Allocated,Allocated Cost$],[$Department$,,$Numerator,Denominator,$\%$ of Total,,$],[$Books$],[$Magazines$],[$Newspapers$],[$Totals$],[$Purchasing$,$Allocation Base,Percent of Allocation Base,Cost to be Allocated,Allocated Cost$],[$Department$,,$Numerator,Denominator,$\%$ of Total,,$],[$Books$],[$Magazines$],[$Newspapers$],[$Totals$,,,,,,]]$