Class Schedule Utilization Calculator

A class costs the same to run with four people in the room as with nineteen. The instructor is paid, the floor is heated and lit, and the hour is gone either way. That makes attendance the entire margin, and it makes the break-even head count a hard number you can put next to every line of the timetable — which is uncomfortable reading for the mid-morning slots.

Tabs work instead of pipes. Attendance is the average of the last several weeks, not a good week. Instructor pay is what leaves the business for that class, including your own payroll burden if they are on payroll.
For a membership base this is monthly dues divided by the classes an average member actually attends in a month, which is the only honest way to credit a class. For drop-ins it is the drop-in price net of tax. If you run both, use a weighted average.
min
Add changeover time if the floor is genuinely unavailable during it.
Rent, utilities, insurance, cleaning and equipment for that room, divided by the hours a week you could realistically program it. Yours, from your own books.
Towel, equipment wear, booking system fee, whatever moves with a body in the room.
Class Schedule Utilization — Fill Rate and Break-EvenBuildFigure

The cost of a class does not know how many people came

Book the instructor, heat the room, and the hour costs what it costs. Four people or nineteen, the two largest lines on the sheet are identical. Everything that varies is a towel and a booking fee. That gives every slot on a timetable a hard break-even head count: instructor pay plus the floor cost, divided by what one attendance leaves behind.

Write that number next to each line and a timetable stops being a schedule and starts being a list of small businesses, most of which are fine and two or three of which are being carried by the rest. On the defaults here the break-even sits at nine heads for a 45 dollar instructor, and the Tuesday and Thursday mid-morning slots come in at five and four.

Adding classes to a half-full schedule makes it worse

The natural response to soft attendance is more choice: another time slot, another format, something for the people who cannot make the evening. Each addition brings its own instructor cost and its own hour of floor, and it draws part of its attendance from the classes you already run. Fill rate falls, contribution falls, and the schedule looks busier while earning less.

The opposite move is uncomfortable and usually right. Two thin classes merged into one well-attended one pay one instructor instead of two, use one hour of floor instead of two, and serve very nearly the same people. The one-more-person section on this page puts a number on the other half of that: every attendance added to a class that already exists is worth the full contribution per head, because nothing on the cost side moves at all.

What a class attendance is worth, when nobody pays for classes

In a drop-in business this is easy. In a membership business it is an allocation problem, and getting it wrong invalidates everything downstream. The defensible method is monthly dues divided by the classes an average member actually attends in a month. If dues are $89 and the average attending member comes ten times, an attendance is worth $8.90 and no more.

Two things follow that people find unwelcome. Members who attend far more than average are credited less per visit and can genuinely cost more than they pay, which is the arithmetic behind class caps and tiered memberships. And members who never come at all are the ones carrying the schedule, which is a fact about the business model rather than a strategy anybody should lean on.

Floor cost is the line that gets left out

Instructor pay is visible because it is a payment. The room is not, so it usually goes missing from class-level thinking entirely, and every class then looks profitable. Work it out the blunt way: rent, utilities, insurance, cleaning and equipment for that room, divided by the hours a week you could realistically program it. A studio open ninety hours a week with $10,000 a month of room-attributable cost is a little over $25 an hour.

That allocation is deliberately crude, and it is still transformative, because it is the only line that makes an empty hour on the timetable cost anything. Without it, adding a class is always free and the answer is always more classes.

Cutting a slot is a retention decision

The arithmetic says the thin classes lose money and cutting them helps. What the arithmetic does not know is that a member who chose the quiet Thursday morning class because it was quiet may not move to the packed Tuesday evening one, and that a member who cancels takes an entire subscription rather than one attendance with them. The upper figure in the cut section assumes everyone moves; the honest planning number is somewhere below it, and where exactly is a question about your members rather than your spreadsheet.

Related pages

For a one-off course rather than a repeating timetable, workshop pricing works back from a target hourly rate to a seat price and a break-even. For the membership side, subscription metrics covers churn, lifetime value and payback, which is where the credited revenue per attendance ultimately comes from, and membership break-even is the same question from the member's side of the counter.

Empty seats caused by people who booked and did not come are a separate problem with its own arithmetic — no-shows and deposits covers it. For instructor pay as an employment cost rather than a per-class fee, employee total cost builds the loaded hourly figure from your own rates.

Questions people ask

How many people does a class need to break even?

Instructor pay plus the floor cost for that hour, divided by what one attendance leaves behind after the variable cost per attendee. That is a fixed number for each slot and it does not move with how full the room is, which is why it belongs written next to every line of the timetable. On the default figures a class with a $45 instructor and $21.67 of floor needs nine people, and the two mid-morning slots on that timetable are running at five and four.

How do I value a class attendance if everyone is on a membership?

Divide monthly dues by the number of classes an average member actually attends in a month. If dues are $89 and the average attending member comes ten times, an attendance is worth $8.90. It is an allocation rather than a price, and it has two consequences worth sitting with: heavy attenders are credited less per visit and can cost more than they pay, and members who never come are the ones funding the schedule. Both are facts about flat-rate memberships rather than problems with the arithmetic.

Should I add more classes to grow?

Not while the ones you run are half full. Each new slot brings a whole instructor cost and a whole hour of floor, and it draws part of its attendance from classes that already exist, so overall fill and contribution both fall while the timetable looks busier. The one-more-person section on this page shows the alternative: an attendance added to an existing class is worth the full contribution per head because nothing on the cost side moves. Fill first, add second.

What should I use for floor cost per hour?

Rent, utilities, insurance, cleaning and the equipment for that room, divided by the hours a week you could realistically program it — not by the hours you currently do, or a thin schedule flatters itself. It is a crude allocation and it does not matter that it is crude. What matters is that it is not zero, because a zero floor cost makes every additional class look free and the answer to every question becomes more classes.

Should I cut the classes that lose money?

The schedule arithmetic says yes and it is only half the question. Cutting frees the instructor and the hour immediately, and whether it also keeps the revenue depends on whether those attendees move to another class or leave. A member who chose a quiet slot because it was quiet may not want the busy one, and a member who cancels takes a whole subscription rather than one visit. Run the cut figure as a range — nobody moves at the bottom, everybody moves at the top — and treat the decision as a retention question rather than a timetable one.

Related