Perform a sensitivity analysis using a Data Table to show how annual profit changes as the percentage of seats filled varies between 10%-100%.
Total seats	24
Fixed cost	$400,000.00
Profit per lunch check	$8.00
Profit per dinner check	$20.00
Fraction of seats filled	50%
Lunch seatings	2
Dinner seatings	3
Days open	312
Lunches sold per year	48	determine the number of seats using total seats, number of seating, the days open, and the fraction of seats filled
Dinners sold per year	72	determine the number of seats using total seats, number of seating, the days open, and the fraction of seats filled
Pro forma Model (already built)	Amount
annuallunchprofit	$384.00	=B16*profitperlunchcheck
annualdinnerprofit	$1,440.00	=B17*profitperdinnerccheck
fixedcost	$400,000	=fixedcost
total profit	-$398,176	=B20+B21-B22
Make sure to remember that in a one-way table, the formula is placed in the top of the column
fraction seats filled	10%
	20%
	30%
	40%
	50%
	60%
	70%
	80%
	90%
	100%