K M N $9.00 $10.00 $11.00 B D E H 1. Extreme H20 2 Break-even Analysis for River Float Project 3 4 Revenue Two-Variable Data Table 5 Average Number of Guests (per day) 85 Price 6 Days of Operations per Year 225 ($230,363) $4,00 $5.00 $6.00 $7.00 $8.00 7 71 Price $6.02 35 8 Gross Revenue $115,181 40 9 Expenses 45 10 Fixed Costs 50 11 Site Development $32,200 55 12 Equipment $3,450 60 13 Insurance $1,400 65 14 Total Fixed Costs $37,050 70 15 Variable Costs 75 16 Labor expense (per day) $275 80 17 Transportation (per guest) $0.85 18 Total Variable Costs $78,131 90 19 Net Income $230,363 95 20 100 21 105 22 110 23 24 25 26 Break-Even Analysis PriceAnd Guest DaysAndPrice 85 Ready Ta Create a data table in the range F5: N22. The price (row 6) needs to start at $4 and increase to $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase in increments of 5. Be sure to add a reference to cell D19 in cell F6. Format the data in the data table so any net profit under $5,000 has a light red background and dark red text, data that is above or equal to -$5,000 and below $5,000 will have a light yellow background and dark yellow text, and anything $5,000 or greater will have a light green background and dark green text. |