Formula: Subtract; Cell Referencing

BE$4\mathrm{.}2-$ Using Excel to Calculate Contribution Margin

PROBLEM

The local ice cream shop sells single$-$scoop cones. The store employs a

manager plus one full$-$time and two part$-$time employees, and also

incurs costs for labor, rent, and insurance. Information concerning

operations follows.

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.

What is the contribution margin per unit of a single$-$scoop cone?

Contribution margin per unit