1 Function: SUM; Subtract, Add, Divide; Cell Referencing 3 BE9.3 - Using Excel to Calculate Gross Margin Percentages 4 PROBLEM 5 Under a traditional job costing system, Marty understood the activities used to 6 generate that product involved machine setup, material moves, and assembly. 7 The selling price and costs included in primary product are presented here. Direct costs per unit Indirect costs per unit MOH costs allocated per unit under ABC Selling price per unit $2.50 16.00 \begin{tabular}{l|l|l|l|r} \hline D & E & F & G \\ \hline & & & H \\ \hline & & & Student Work Area \\ \hline \end{tabular} 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. Calculate the total product cost per unit under the traditional method and the ABC method. Unit product cost Traditional ABC What gross margin percentage is Marty generating under each method? Gross margin percentage