Management thinks an average of 85 guests a day would be a realistic average. Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and $0 in Net Income. Expenses Revenue Net Income 75 225 Number Guests 50 Goal Seek ? $113,269 1 0 0 E18 + 0 9 Sgt cell: To yalue Dy ghanging cell 0 0 SO 10 + 0 $32,200 $3,450 $1,400 $37.050 OK Cancel 3 Revenue 4 Average Number of Guests (per day) 5 Days of Operations per Year 6 Price 7 Gross Revenue 8 Expenses Axed costs Site Development 11 Equipment 12 Insurance 13 Total Fored Costs 14 Variable Costs 13 Labor expense (per day) 16 Transportation (per guest) 17 Total Variable Costs 18 Net Income 19 20 21 Break-Even Analysis PriceAnd Guest 0 0 0 0 3 95 100 105 110 115 120 o o o o o o o o o o $275 $0.85 $76,219 DaysAndPrice