Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate capacity utilization in Excel and Google Sheets
Excel & Google Sheets
=B2/A2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Max Capacity (hrs) | Actual Output (hrs) |
| 1600 | 1240 |
=B2/A2→0.775
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1In A2 enter the maximum possible output for the period — define this as practical capacity (planned downtime removed), not theoretical maximum (24/7, no maintenance). Example: 1600 machine-hours.
- 2In B2 enter the actual output achieved in the same period (e.g. 1240 machine-hours).
- 3In C2 enter =B2/A2 and format as a percentage. The result is your utilization rate (e.g. 77.5%).
- 4For a team of resources (machines, staff, servers), put each in its own row. Compute an overall weighted-average rate at the bottom: =SUM(B2:B8)/SUM(A2:A8) — this is more accurate than averaging the individual percentages.
- 5Add a target column (D) with your planned utilization and flag under-performers: =IF(C2<D2,"Below Target","On Track").
Tips
- Theoretical capacity (24/7, no downtime) and practical capacity (accounting for planned maintenance and shift patterns) give very different denominators. Choose one and apply it consistently.
- Very high utilization (>90%) sounds positive but often signals a bottleneck — there is no buffer for demand spikes or quality issues. Industry targets in manufacturing are typically 80-85%.
- Track utilization as a weekly trend rather than a single snapshot to distinguish a systemic bottleneck from a one-off peak.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can capacity utilization exceed 100%?
Yes — if actual output exceeds practical capacity by running overtime or deferring maintenance. Values consistently above 100% signal unsustainable operations, not just high performance.
How do I calculate utilization when capacity varies by day?
Use NETWORKDAYS or a schedule table to calculate actual available hours per period rather than a fixed maximum. This produces a more accurate denominator.