Tabellab
Hospitality, Food & Leisure Intermediate

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

Run the numbers on a campsite or glamping field: unit mix, seasonal occupancy, nightly rates, cost per occupied night and the payback of new units, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

This course turns a campsite season into spreadsheet work you can check. On a fictional site with tent pitches, hook-up pitches, bell tents and cabins you count available unit-nights from opening dates, measure occupancy by month and unit type with SUMIFS, and price stays from a two-way rate ladder with weekend rates and length-of-stay discounts. You calculate the average nightly rate, revenue per available unit-night and extras per stay, the variable cost and contribution per occupied night, a seasonal staff rota, the NPV, payback and break-even occupancy of new glamping units, and finish with a season dashboard and stacked chart.

Lessons

  1. Unit Mix: Pitches, Glamping Units and Available NightsLab14 min Pro
  2. Seasonal Occupancy: Occupied Nights by Month and Unit TypeLab15 min Pro
  3. Rate Ladders: Season, Weekday vs Weekend and Length-of-Stay DiscountsLab17 min Pro
  4. Revenue per Available Unit-Night and Extras per StayLab15 min Pro
  5. Cost per Occupied Night: Utilities, Cleaning, Laundry and CommissionsLab16 min Pro
  6. Staffing by Season: Hours per Occupied Unit and Rota CostLab16 min Pro
  7. New Glamping Units: Investment, NPV, Payback and Break-Even OccupancyLab18 min Pro
  8. Capstone: Season Dashboard by Month and Unit TypeLab17 min Pro