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.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
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.