Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing

E$14\mathrm{.}2$a $-$ Using Excel to Allocate Support Department Costs Using the Direct Method

PROBLEM

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input the required

mathematical formulas or functions with cell references to the Problem area or work area as

indicated.

Allocate the support department costs using the direct method to determine the total costs for

which each operating department should be accountable.