Capacity utilization is actual output over maximum possible output — how much of a line’s capacity you’re using. It guides whether to add shifts, defer capex, or chase more orders.
The example
3,600 of 4,800 possible.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Actual | 3600 |
| 3 | Capacity | 4800 → 75% |
The formula
The formula:
How it works
How it works:
- Max capacity = ideal rate × available hours — the most the line could make.
- Divide actual output by it for the utilization percentage.
- Low utilization means idle capacity; sustained high means you may need more.
- Distinguish demand-limited (no orders) from capability-limited (line maxed) idle time.
Why you’re under capacity matters more than the number. 75% utilization because of weak demand calls for sales; 75% because of downtime and changeovers calls for maintenance and SMED. Split the lost capacity into demand-limited vs capability-limited buckets — the same percentage points to completely different actions.
Try it: interactive demo
Actual output and max capacity.
Variations
Max capacity
Ideal × hours:
Idle capacity
Unused:
Output at a target %
Plan to a level:
Pitfalls & errors
Define max honestly. Use a realistic ideal rate and true available hours.
Demand vs capability. Idle from no orders differs from idle from breakdowns.
Headroom is healthy. 100% leaves no slack for surges or maintenance.
Practice workbook
Frequently asked questions
How do I calculate production capacity utilization in Excel?
How do I find max capacity?
What does low utilization mean?
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