Please do it in excel and copy it here 4.0 points this tab
	Cost/Volume/Profit
	1. Please complete the template below for the initial forecast, accounting breakeven, target profit, and price sensitivity.
	a. Fixed operating expense is $2,400
	b. Interest expense is driven by the rate given in D:30
	c. Tax expense is driven by the rate given in D:32
	d. The initial forecast is for 1,050 units
	2. Please determine revenues, costs, and units for all conditions
	Selling Price	-
	Variable Cost	80.00
	Gross Margin	(80.00)
								Forecast @	Forecast @
				Forecast	Acct Br Even	Target profit	Price Sensitivity	88.5	101
	Units			1,050			1,050	-	-
											SP
	Revenues										VC
	Variable cost										Unit CM
	Gross Margin			-	-	-	-
	Operating Exp			2,400	2,400	2,400	2,400	2,400	2,400
	Earnings Before Interest & Tax
	Interest Expense		0.10
	Earnings Before Tax
	Tax		0.40
	Net			-	-	-	-
	Target profit					8,500	8,500
	Note Principal	100,000
	Mean =	95
	Std Dev =	2.00
	Z value	Value	Probability	Random	Table		Forecast
	(6.00)
	(5.75)
	(5.50)
	(5.25)
	(5.00)
	(4.75)
	(4.50)
	(4.25)
	(4.00)
	(3.75)
	(3.50)
	(3.25)
	(3.00)
	(2.75)
	(2.50)
	(2.25)
	(2.00)
	(1.75)
	(1.50)
	(1.25)
	(1.00)
	(0.75)
	(0.50)
	(0.25)
	-
	0.25
	0.50
	0.75
	1.00
	1.25
	1.50
	1.75
	2.00
	2.25
	2.50
	2.75
	3.00
	3.25
	3.50
	3.75
	4.00
	4.25
	4.50
	4.75
	5.00
	5.25
	5.50
	5.75
	6.00
	Rate
	0.01
	0.02
	0.03
	0.04
	0.05
	0.06
	0.07
	0.08
	0.09
	0.10