The rota spreadsheet on a Thursday afternoon
The spa manager is writing the rota for four weeks' time. She copies the last one, adjusts for holidays and a therapist who has asked to drop Mondays, and saves it. Four weeks later, Saturday is full by Wednesday with a waiting list, and there is no therapist free to add. The following Tuesday, two therapists spend the afternoon on laundry and retail displays because only three treatments are booked between them.
Nobody made a bad decision. The rota was written without any view of what demand would look like.
A rota template meets real demand
Spa demand is predictable in patterns but not from a template. It moves with school holidays, occasions such as Mother's Day and Valentine's Day, the post-Christmas voucher wave, and the local events calendar.
- Rotas are copied from the last period rather than planned against forecast demand.
- Bookings already in the diary for the rota period are not looked at when writing it.
- Vouchers approaching expiry, which bring a predictable wave of bookings, are not considered.
- Waiting list demand, which shows unmet weekend need, is not recorded.
- Therapist contracts and preferences are held in someone's memory.
Idle hours and turned-away guests
Therapist hours are your biggest cost. When they land on the wrong days, you pay for idle time and still turn guests away on your best days. Late rota changes to fix it frustrate therapists. Guests who cannot get a weekend slot book elsewhere, and some do not come back.
How we build demand-led rota planning
- We read booking history from your spa system and build a simple picture of demand by day of week, season and occasion, in treatment hours.
- For the rota period, we add what is already booked, vouchers due to expire in that period and waiting list requests.
- The planner shows expected treatment hours per day next to the therapist hours on the draft rota, so gaps and surpluses are visible before it is published.
- Therapists' contracted hours, availability and skills are held in the planner, so a suggested change never puts someone in a day they cannot work or a treatment they cannot do.
- As the rota period approaches, the view updates with new bookings, so a surge is spotted in time to offer extra shifts.
- The final rota can be published to your rota or HR tool, or exported, depending on what you use.
| Day | Expected treatment hours | Rostered therapist hours | Signal |
|---|---|---|---|
| Tuesday | Low, few bookings, no occasions | Template level | Surplus, consider fewer hours |
| Saturday | High, waiting list, vouchers expiring | Template level | Shortfall, consider extra shift |
| Mother's Day weekend | Very high | Template level | Plan well ahead |
The planner shows what the numbers suggest. Contracts, fairness and who works when are your decisions, and your employment arrangements are a matter for you and your adviser.
Rota decisions with the numbers beside them
The manager writes the rota with expected demand in view, not a copy of last month. Therapists get earlier notice of busy periods and extra shifts. Weekends turn fewer guests away and midweek has less idle time. Over a year, you learn which patterns hold, and planning gets quicker.
Holiday requests become easier to answer too. When a therapist asks for a week off in February, the manager can see straight away whether that week looks quiet or whether it falls in the post-Christmas voucher rush, and say yes or suggest another week with a reason the therapist can understand.
Seasonal packages benefit in the same way. If you are launching a new signature treatment for spring, the planner shows how many trained therapists will be on shift across the launch weeks, before the marketing goes out rather than after the first Saturday sells out.
Is your rota written blind?
- Rotas are copied from the previous period.
- Weekends turn guests away while weekdays have spare therapists.
- Nobody looks at upcoming voucher expiries when planning.
- Extra shifts are arranged at short notice.
- Therapist availability and preferences are tracked informally.