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

Using Excel for Cost$-$Plus Pricing

PROBLEM

Mussatto Corporation produces snowboards. The following per unit cost and markup information is available.

Direct materials

Direct labor

Variable manufacturing overhead $18$

Fixed manufacturing overhead $14$

Variable selling and administrative expenses $4$

Fixed selling and administrative expenses $12$

Markup percentage on total per unit cost

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.

Compute the target selling price.

Total unit cost

Target selling price