Function: SUM: Formula: Add, Multiply; Cell Referencing

BE$9\mathrm{.}2-$ Using Excel to Use Cost$-$Plus Pricing to Determine Selling Price

PROBLEM

Gruner Corporation produces snowboards. The following cost information per unit is available:

Direct materials

Direct labour

Variable manufacturing overhead

Fixed manufacturing overhead

Variable selling and administrative expenses

Fixed selling and administrative expenses

Markup percentage on total cost per unit

$ $12$

$8$

$6$

$14$

$4$

$12$

$30\%$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area, and to the work area as indicated.