Hotel Day-Use & Daycation Product Planner: Day Pass Pricing and Capacity Spreadsheet

Full description

For hotel general managers, revenue managers and sales teams who sell day-use rooms, pool passes, spa days or work-from-hotel packages to non-staying guests. You list each product with its price and cost per sale, set daily capacity by time slot and log bookings. The workbook shows the contribution of each product, which slots run full or empty, and on which dates day-use rooms would push out an overnight sale, so you can open, cap or close them before the date arrives.

Save with a bundle: this template is also in the Hotel Sales, Marketing & Revenue Bundle, 14 templates for $39 instead of $100. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

• Hotel_Day_Use_Daycation_Planner.xlsx: 8 tabs, 21,966 formulas, 3 native charts, 14 drop-down or number rules. No macros.
• Settings: rooms, target contribution margin, occupancy level that closes day-use rooms, turnaround buffer, report period, 7 booking channels with commission %, 5 product categories, 4 time slots, 4 booking statuses.
• Product_Menu: room for 20 day products (13 sample products). Total cost, contribution, margin % and the minimum price at your target margin calculate, with a Below target flag.
• Capacity_Slots: units per day and open days for each product, then capacity, units sold, utilisation and revenue per available unit for the period, plus category-by-slot grids and an Add capacity or Low demand signal.
• Displacement_Check: 31 days of overnight forecast. Rooms free for day-use, rooms at risk, displacement cost, net gain and an Open, Cap or Close decision for each date.
• Bookings_Log: room for 3,000 rows (1,380 sample rows). Slot, price, commission, variable cost and contribution fill in from the product and channel.
• Product_Summary: bookings, units, net revenue, commission, contribution, margin, cancel rate and rank by product, plus totals by category and a chart.
• Dashboard: 8 KPI tiles, net revenue and contribution by week, and net revenue by category.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Enter rooms, target margin, closing occupancy, report period and channel commissions on Settings.
2. List your day products with price and cost per sale on Product_Menu and fix any line marked Below target.
3. Set units per day and open days on Capacity_Slots.
4. Each month, enter the overnight forecast on Displacement_Check and follow the decision column.
5. Log bookings daily, then review Product_Summary and the Dashboard each week.

Details

• Format: Excel workbook (.xlsx). No macros.
• Language: English. Currency is a label you choose.
• Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files, such as Google Sheets.
• Delivery: instant digital download. Nothing is shipped.

Good to know

• All sample products, prices, costs, forecasts and bookings are illustrative. Replace them with your own data.
• Channel commission rates are examples. Use the rates in your own contracts.
• Rules for selling pool, spa and room access to non-resident guests, and the taxes on them, differ by location. Verify local requirements.
• Single-user license. Do not share or resell the files.

FAQ

What counts as one unit?

One room, one pass, one guest or one package, as you name it on Product_Menu. Capacity and utilisation use the same unit.

How does the displacement check decide?

It compares forecast overnight rooms sold plus a turnaround buffer with your hotel rooms. Day-use rooms above the free level are at risk, and dates at or above your closing occupancy show Close day-use.

Can I change the categories, slots and channels?

Yes. Edit the lists on Settings and the drop-downs follow. Slot times are inputs too.

Does it work in Google Sheets?

It opens in Google Sheets and the formulas calculate. Check the drop-downs after import.

Is this a physical product?

No. It is a digital download. Refund terms follow the store policy at the time of purchase.