Wellness Guest Programme Planner: Hotel Wellness Weekend Programme, Cost Sheet and Room Spec

Full description

For spa managers, food and beverage managers and general managers who want to sell a weekend wellness programme without guessing the numbers. The workbook holds a programme menu of 24 sample items across sleep, air, nutrition and movement. Each row takes capacity, runs, guests, price and cost per run, then calculates revenue, margin, fill rate, cost per guest and a price floor from your target cost percentage. A flag shows the first problem: blank price, no capacity cap, over capacity, below the floor or outside the fill band. A 30-point room and lounge specification covers sleep, air, the relaxation lounge, service and safety with tests, ratings and owners. A partner list tracks instructors, therapists and suppliers. The Word guide supplies a guest programme card, menu wording, room and lounge checklists, health forms, partner briefs and a feedback card.

What is inside

• Wellness_Programme_Planner.xlsx: 7 tabs, 427 formulas, 2 native charts, 21 drop-down and input rules
• Programme Menu: 24 sample items plus 8 spare rows; revenue, cost, margin, fill rate, price floor and flag calculated
• Room Spec: 30 specifications in 5 areas with target, measured value, test result, weight, rating, owner, check date and flag, plus 6 spare rows
• Partner Needs: 14 sample needs plus 8 spare rows; status calculated from agreement, qualification check and due date
• Dashboard: 7 KPI tiles, a check tile, 2 charts and 4 summary tables; 10 integrity checks on the Checks tab
• Guest_Programme_Card_and_Guide.docx and PDF: 6 pages with a weekend calendar, a guest programme card, menu wording, room and lounge checklists, health forms, partner briefs, team roles, a feedback card and a worked example
• README.txt and LICENSE-and-Terms.txt

How it works

1. Enter rooms, occupancy, target cost percentage and bands on Settings.
2. List each programme item on Programme Menu and fix every flagged row.
3. Test the rooms and lounge on Room Spec and rate each specification.
4. Track partner agreements and qualification checks on Partner Needs.
5. Read the Dashboard, then print the programme card and checklists from the Word guide.

Details

• Formats: 1 Excel workbook (.xlsx), 1 guide in Word (.docx) and PDF, English
• Software: Excel 2016 or later, or LibreOffice Calc 7 or later
• No macros, no external links, no data tables, no array formulas
• 3 files plus README and license; instant digital download

Good to know

• Sample data is illustrative. Replace it with your own figures.
• Health, safety, fire and food rules differ by location. These files are planning tools, not medical, legal or safety advice: verify local requirements.
• Price floors and fill bands are editable inputs. The sample uses a target cost of 50% of price.
• Single-user license. Do not redistribute.

FAQ

How is the price floor set?

Cost per guest divided by your target cost percentage. A price below the floor is flagged.

What counts as session fill rate?

Guests per run divided by capacity, for sessions only. Treatments are measured by therapist hours instead.

How is spa utilisation calculated?

Treatment hours sold divided by therapist hours available for the month, both entered by you.

Can I add my own items and themes?

Yes. Spare rows hold new items. Lists on Settings control the themes, formats and slots.

Do I need macros?

No. Every result is a standard worksheet formula.