A chair’s output is appointments × average ticket, and its occupancy is booked slots over available. Together they show how hard each chair works and the room to grow.
The example
110 appts, $45 ticket.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 110 × 45 | — |
| 3 | Revenue | → $4,950 |
The formula
The formula:
How it works
How it works:
- Chair revenue = appointments × average ticket for the month.
- Occupancy = booked slots ÷ available slots — how full the chair runs.
- Multiply open slots by the ticket for the revenue opportunity.
- Lift revenue by raising occupancy, ticket, or rebooking — three independent levers.
Chair revenue has three independent levers — pull the cheapest. More appointments (occupancy), a higher average ticket (add-ons, upsell), and better rebooking each raise the same number, but the easiest win varies by chair. A full chair at a low ticket needs upsell; a half-full chair needs marketing and rebooking. Tracking revenue and occupancy together tells you which lever to pull on each barber’s chair.
Try it: interactive demo
Appointments, average ticket, available slots.
Variations
Occupancy
Booked ÷ available:
Revenue at full
All slots booked:
Opportunity
Open slots × ticket:
Pitfalls & errors
Same month. Appointments and slots over the same period.
Three levers. Occupancy, ticket, and rebooking each raise revenue.
Zero slots. No availability gives #DIV/0! in occupancy.
Practice workbook
Frequently asked questions
How do I calculate monthly chair revenue in Excel?
What's chair occupancy?
How do I grow chair revenue?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class