A

B

C

D

$E$

F

G

The following information relates to overhead cost at Chocolates by Jacki for the current year.

Total costs and distribution of resource consumption across activity cost pools:

$\backslash$table$[[,$Total Cost,Activity Cost Pools,Total$],[,\backslash$table$[[$Customer$],[$Orders$]],\backslash$table$[[$Product$],[$Development$]],\backslash$table$[[$Customer$],[$Relations$]],$Other$],[$Production Department:$],[$Indirect factory wages,$$400,000,50\%,30\%,15\%,5\%,100\%],[$Factory equipment depreciation,$150,000,55\%,30\%,0\%,15\%,100\%],[$Factory utilities,$120,000,59\%,34\%,0\%,7\%,100\%],[$Factory property taxes and insurance,$75,000,57\%,33\%,0\%,10\%,100\%],[$General Administrative Department:$],[$Administrative wages and salaries,$275,000,20\%,10\%,40\%,30\%,100\%],[$Office equipment depreciation,$40,000,32\%,16\%,15\%,37\%,100\%],[$Adminstrative property taxes and insurance,$60,000,0\%,0\%,0\%,100\%,100\%],[$Marketing Department:$],[$Marketing wages and salaries,$150,000,20\%,10\%,40\%,30\%,100\%],[$Selling expenses,$100,000,32\%,16\%,15\%,37\%,100\%]]$

Required:

Use the data to complete a First$-$Stage Allocation to Activity Cost Pools.

When completing the table, copy formulas as approriate.

$($Use cells A$5$ to G$20,$ as well as the "Chart of Accounts" tab for cell referencing and$/$or formulas needed to complete this question.$)($Please use the cells and show me which cells you used to do the math pls$,$ I'll give you a good rating$)$