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. 8 9 10 11 12 13 14 15 16 17 18 19 20 Traditional method Direct costs per unit Indirect costs per unit MOH costs allocated per unit under ABC Selling price per unit $ $ 8.00 4.00 2.50 16.00 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. Calculate the total product cost per unit under the traditional method and the ABC method. Unit product cost Traditional Gross margin percentage What gross margin percentage is Marty generating under each method? ABC Traditional ABC