Create excel and use cell for appropiate formula example $(=$b$7*$ a$7)$ 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:

Activity Cost Pools

Total Cost

Customer

Orders

Product

Development

Customer rtlations

Other

Total

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\%$

R$$ Palazzi:

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.$)$

Customer Orders

Activity Cost Pools

Product

Customer

Development

Relations

Other

Total

H

Production Department:

Indirect factory wages

Factory equipment depreciation

Factory utilities

Factory property taxes and insurance

General Administration Department:

Administrative wages and salaries

Office equipment depreciation

Adminstrative property taxes and insurance

$+$

Marketing Department:

Marketing wages and salaries

Selling expenses

Total