AI Timetable Planning: Build a Class Schedule From Attendance Data

AI class schedule planning for a gym works best when every slot runs through one framework: the Fill, Floor, Fit audit. Fill measures true demand, waitlist included. Floor is the headcount that pays the instructor and room. Fit asks who gets stranded if the class moves. AI speeds up all three. You still make the call.

The stakes keep rising. The Health & Fitness Association reports that 81 million Americans held a fitness facility membership in 2025. More members means more booking data, and more ways to schedule the wrong class at the right time.

What does AI actually do in timetable planning?

AI finds patterns across months of check-ins faster than a person can, then forecasts each slot. It does not know your members, so you decide.

In practice it does three jobs. It forecasts check-ins per slot for the next four to eight weeks. It adjusts for seasonality: the January rush, the summer dip, school holiday weeks. And it flags slots trending down before the drop shows up in revenue.

What it cannot know is that your Thursday 9:30 am crowd is four friends who carpool. That is why the audit ends with a human Fit check. The industry is moving toward data anyway: data-driven technology appears in ACSM's 2026 Worldwide Fitness Trends, a survey of exercise professionals, clinicians and researchers. For a wider view of where AI helps a small studio, see our guide to practical AI for studio owners.

Which attendance data do you need before trusting a forecast?

You need at least eight clean weeks of check-ins per slot, with holiday weeks removed. Bookings alone overstate demand because they include no-shows.

Pull five fields per session: capacity, check-ins, late cancels with timestamps, waitlist count at class start, and the instructor who taught it. Then clean it:

• Drop holiday weeks and any week the room or capacity changed.
• Drop the first four weeks of any new class. Launch weeks run on novelty and free-class promos.
• Keep twelve months if you have them. Eight weeks shows a trend. Twelve months shows the season.

How do you measure true demand for a class slot?

True demand equals check-ins plus unserved waitlist demand. A class that is full every week tells you its ceiling is too low, not its demand.

Use this rule: true demand = average check-ins + (average waitlist at class start × 0.5). Halve the waitlist because people join several lists and drop off.

Scenario: Tuesday 6:00 pm spin, 22 bikes. Eight weeks of 22 check-ins, with an average of 10 people still waitlisted at start. True demand is about 27. That supports a second ride at 6:45 pm far better than squeezing bikes into a room that cannot fit them.

Set review triggers:

• Under 40% fill for six straight weeks: run Floor and Fit before any decision.
• Over 90% fill with a live waitlist for three or more weeks: add capacity in an adjacent slot.
• Between the two: leave it alone. Most timetables get worse from tinkering in the middle band.

What is the break-even headcount for a class?

Floor is the headcount where a class covers its instructor and room. Below it for six weeks, a class needs a reason to exist.

Floor = (instructor pay per class + room cost per hour) ÷ revenue per visit. Revenue per visit is monthly membership revenue divided by monthly check-ins.

Worked example with illustrative numbers: you pay $45 per class, the room costs $20 an hour in rent and utilities, and members pay $140 a month and average 7 visits, so each visit is worth $20. Floor = $65 ÷ $20 = 3.25. Round up to 4.

Use your real per-class rate, not a benchmark. The Bureau of Labor Statistics puts median pay for fitness trainers and instructors at roughly $22 an hour in recent data, but most studios pay group instructors per class, so the hourly median is only a sanity check. Contractor status changes the cost again; see 1099 vs W-2 for fitness instructors.

One exception most operators miss: a class below floor can still earn its slot. If your intro class sits at 3 people but converts trials into memberships, measure its floor in new members, not visits.

Who gets stranded if you cut or move a class?

Before cutting any class, check how many regulars attend nothing else. Those members are not moving to another slot; they are moving to another studio.

Run the single-slot check:

1. List everyone who attended the class 3 or more times in the last eight weeks.
2. For each, count bookings in any other class in the last 60 days.
3. If more than a third have zero, do not cut. Move the class by 30 minutes or less, or message each regular personally first.

Scenario: a Thursday 9:30 am gentle yoga class averages 7 people against a floor of 4. A forecast ranks it near the bottom. But 5 of the 7 attend nothing else. Cutting it saves one instructor fee and risks five memberships. Daytime classes for older members are often the most slot-dependent; see designing classes for members over 55. For anyone you do move, watch their next three weeks of visits with at-risk member detection.

How do you tell a weak time slot from a weak instructor?

Use substitute weeks as a natural experiment. If attendance holds when someone covers, the slot is strong; if it collapses, members follow the instructor.

Pull every week a cover taught the class and compare it with the regular instructor's weeks. You need at least two cover sessions to read anything.

• Attendance within 10% on cover weeks: the slot carries the class. Any trained instructor can hold it.
• Attendance down 25% or more: members follow the instructor. Moving that instructor into a weak slot may lift it, and losing them will hurt more than the timetable suggests.

Read the timing of late cancels too. Cancels bunched in the last two hours before a 5:30 pm class point to commute friction, not content. Moving it to 6:15 pm can fix more than a new format would.

When should a forecast change your overbooking rules?

Forecast no-show rates per slot, then release extra spots only up to that rate. Overbook a 6:00 am class differently from Saturday 9:00 am.

Extra spots = capacity × forecast no-show rate, rounded down. A 20-spot reformer class with a 12% no-show rate over eight weeks gives 2.4. Release 2. Never round up on equipment classes: one surplus booking means a member standing at the door with no reformer. Mat-based yoga or HIIT can flex by a spot or two.

Rates vary by slot more than by class type. Early classes booked the night before tend to hold. Weekend classes booked on Monday tend to slip. Forecast each slot separately.

How should you roll out a timetable change?

Change one thing per slot, announce it 14 days ahead, and judge it after six weeks. Earlier verdicts mostly measure habit disruption, not demand.

• Change at most three slots per quarter, so you can tell which change did what.
• Message affected regulars personally before the public announcement. A text from their instructor beats an email blast.
• Keep the old slot visible in the booking app for two weeks, labeled with the new time.
• Expect a dip in weeks one and two. Do not reverse a change on that data.
• Avoid launching changes in early January, when new joiners are building habits around the current timetable.

How do AI tools compare with a spreadsheet?

As a rule of thumb, spreadsheets hold up to roughly 40 weekly classes. Beyond that, the manual Fill, Floor and Fit math tends to stop getting done.

Disclosure: Zatrovo publishes this blog and sells studio software, so weigh this table accordingly. The rows describe capabilities, not measured results.

Growth makes the manual approach harder to sustain. The 2026 HFA Global Report describes double-digit operator revenue growth in 2025. More members on the same timetable means more slots in the 90% band, where the waitlist math matters most.

Does this work for salons, spas and appointment businesses?

Yes. Replace class slots with staff shifts and measure booked minutes per chair or room. The same Fill, Floor and Fit logic applies.

• Fill: booked minutes ÷ available minutes per staff member per shift.
• Unserved demand: waitlist requests plus booking-page visits that found no opening.
• Floor: the hourly cost of that chair or treatment room plus the staff member's pay.
• Fit: clients who only ever book one person on one day. If your Saturday colorist moves to weekdays, those clients may leave with them.

In beauty, clients often follow the person rather than the time slot, so weight Fit heavily. See beauty client retention for how to protect those relationships during a schedule change.