Chair utilization is booked hours over available hours — how full your stations or treatment rooms run. Empty chairs are lost revenue you’re already paying rent on.
The example
30 booked of 40 available.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 30 / 40 | — |
| 3 | Utilization | → 75% |
The formula
The formula:
How it works
How it works:
- Available hours = chairs × open hours — the capacity you pay for.
- Divide booked service hours by it for utilization.
- Low utilization = idle capacity; multiply the gap by your average hourly revenue for the cost.
- Track by day and stylist to find the slow windows worth promoting.
Utilization prices your empty chairs. At 75% utilization on a chair that grosses $80/hour, the idle 25% over a 40-hour week is 10 hours × $80 = $800 of unearned capacity — every week. Seeing that number is what justifies a Tuesday promotion or a double-booking policy. Fill rate, not just total revenue, is the lever for a fixed-cost salon.
Try it: interactive demo
Booked and available hours.
Variations
Idle hours
Capacity unused:
Idle revenue
Cost of empty:
Available hours
Chairs × open hours:
Pitfalls & errors
Service hours. Use actual service time, not appointment slots, if they differ.
Capacity honestly. Available hours = staffed chairs × open hours.
Zero available. Closed day gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate chair utilization in Excel?
How do I value the empty chairs?
How do I find available hours?
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