Required: Using excel, create a model input block area so that you can compute the following chart:

	Original	Scenario 1	Scenario 2
Sales
-Variable Costs
= Contribution Margin
-Fixed Costs
= Profit
Unit contribution margin
Unit Contribution margin ratio
Breakeven units
Breakeven sales dollars
Breakeven units with target profit
Breakeven sales dollars with target profit
Margin of safety dollars
Margin of safety ratio
Degree of operating leverage
% change in profit
New operating profit

(note, Your chart should be set up like the chart above. The above chart is to be displayed in your excel file and is to be printed out). Dont print out the model input block!

Use the following information in your model input block:

Unit Sales price	$23
Unit variable cost	4.95
Target Profit	$1,600,000
Fixed cost (total)	1,352,000
Number of units sold	162,000
Scenario 1, increase in sales volume 36%, decrease in sales price 10%, decrease of variable cost 1.75%, fixed costs stay the same
Scenario 2, increase in sales volume 44%, decrease in sales price 15%, decrease in variable cost 2.2%, fixed costs increase $20,000 (change is compared to the original information)

Include in your model input block the ability to insert % increases in unit sales, unit sales price, unit variable cost. Also include the ability to adjust fixed costs (total).