BE4.2 - Using Excel to Calculate Contribution Margin					Student Work Area
PROBLEM					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.
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.
					What is the contribution margin per unit of a single-scoop cone?
	Selling price of single-scoop cones	$2.00
	Unit cost of ice cream per scoop	0.25				Contribution margin per unit
	Unit cost of cone	0.05
	Montlhy labor costs	3,500
	Monthly rent and insurance cost	500