Campground & Glamping Site Economics: Pitches and Units, Seasonal Occupancy, Rate Ladders, Amenity Costs & Payback

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn each unit type's opening dates into nights open, multiply by the number of units to get available unit-nights, and measure how much of the site's capacity is glamping.
• Calculate occupancy for every month and unit type, pool July across the whole site and the glamping units across the season with SUMIFS, and count the rows that reach a fictional high-occupancy level.
• Look up nightly rates in a two-way rate table with INDEX/MATCH, price stays that mix weeknights and weekend nights, apply a length-of-stay discount with an approximate match and work out the net price per night.
• Calculate the average nightly rate and the revenue per available unit-night for each unit type, the extras revenue per stay from take-up rates and prices, and one site-wide figure that includes the extras.
• Turn per-stay cleaning and laundry into a cost per occupied night with the average length of stay, add booking-portal commissions and card fees, and find the variable cost and contribution per night for each unit type.
• Build monthly staff hours from base hours, changeovers and occupied unit-nights, cost the rota with on-costs, round up the staff needed and find the staff cost per occupied unit-night for the season.
• Forecast eight years of cash flow for four new safari tents with a ramp-up in occupancy, discount it with NPV, compare the simple payback and find the flat occupancy at which the investment just breaks even.
• Close Maren's season: the total revenue, the glamping share, the best month with INDEX/MATCH and a stacked column chart of the accommodation revenue by month and unit type.