Excel Chapter 10 Assessment - Extreme H20
abparsley
Parsley_Excel_Ch10_PS2_Float.xlsxBreak-Even Analysis
| Extreme H2O | ||||||||
| Break-even Analysis for River Float Project | ||||||||
| Revenue | Number | Expenses | Revenue | Net Income | ||||
| Average Number of Guests (per day) | 75 | Guests | ||||||
| Days of Operations per Year | 225 | 50 | ||||||
| Price | 55 | |||||||
| Gross Revenue | 60 | |||||||
| Expenses | 65 | |||||||
| Fixed Costs | 70 | |||||||
| Site Development | $32,200 | 75 | ||||||
| Equipment | $3,450 | 80 | ||||||
| Insurance | $1,400 | 85 | ||||||
| Total Fixed Costs | 90 | |||||||
| Variable Costs | 95 | |||||||
| Labor expense (per day) | $275 | 100 | ||||||
| Transportation (per guest) | $0.85 | 105 | ||||||
| Total Variable Costs | 110 | |||||||
| Net Income | 115 | |||||||
| 120 | ||||||||
&F
PriceAndGuest
| Extreme H2O | ||||||
| Break-even Analysis for River Float Project | ||||||
| Two-Variable Data Table | ||||||
| Price | ||||||
&F
DaysAndPrice
| Extreme H2O |
| Break-even Analysis for River Float Project |
&F
