Support department cost allocation$-$reciprocal services method

and costs from the Security Department are allocated based on asset value. Information about each department is provided in the following table:

DATA

REQUIRED:

Determine the total cost of each production department affer allocating all support departiment cosits to the production departments using the reciprocal services method.

Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV$2$ for grading.

Security department costs percentage

Maintenance department costs percentage

Total cost to be allocaled from security department

Total cost to be allocated from maintenance department

Maintenance department cost allocalion $-$ Maintenance Department

Maintenance department cost allocation $-$ Cutting Department

Maintenance department cost allocation $-$ Molding Department

Security department cost allocation $-$ Maintenance Department

Security department cost allocation $-$ Cutting Department

Security department cost allocation $-$ Molding Department

Production departments' total costs $-$ Cutting Department

Production departments' total costs $-$ Molding Departmient

Formulas

Support department cost allocation$-$reciprocal services method

and costs from the Security Department are allocated based on asset value. Information about each department is provided in the following table:

DATA

REQUIRED:

Determine the total cost of each production department affer allocating all support departiment cosits to the production departments using the reciprocal services method.

Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV$2$ for grading.

Security department costs percentage

Maintenance department costs percentage

Total cost to be allocaled from security department

Total cost to be allocated from maintenance department

Maintenance department cost allocalion $-$ Maintenance Department

Maintenance department cost allocation $-$ Cutting Department

Maintenance department cost allocation $-$ Molding Department

Security department cost allocation $-$ Maintenance Department

Security department cost allocation $-$ Cutting Department

Security department cost allocation $-$ Molding Department

Production departments' total costs $-$ Cutting Department

Production departments' total costs $-$ Molding Departmient

Formulas

Please help asap!