Use Data Tables to perform a Sensitivity Analysis.

Assume you are starting a lawn service business. You estimate that you can

mow 1,200 lawns per year with the personnel you have. Determine the profit at each price per lawn and cost per lawn using the estimates below (Revenue - Total Variable Costs - Fixed Costs).

Please example how step by step using excel formulas.

Lawns	1,200
Price charged per Lawn	$50.00
Cost per Lawn (Labor & Gas)	$24.00
Fixed Overhead Costs	$30,000
		Cost per unit
		$20.00	$22.00	$24.00	$26.00	$28.00	$30.00
Price charged per lawn	$35.00
	$40.00
	$45.00
	$50.00
	$55.00
	$60.00