Capacity Gap Analysis Calculator

Example Data Table

Use these sample values to test the calculator quickly.

Scenario	Planned UPH	Actual UPH	Hours	Utilization	Efficiency	Downtime	Scrap	Demand	Overtime	Days	Shift	Lines
Base Month	120	96	160	85%	92%	8	4%	15000	10	20	8	1
High Demand	140	112	176	88%	94%	6	3%	19000	16	22	8	2
Downtime Stress	100	78	160	80%	87%	18	6%	12500	12	20	8	1

Formula Used

Scheduled Hours = Available Hours + Overtime Hours

Effective Hours Before Factors = Scheduled Hours − Downtime Hours

Designed Capacity = Planned Units per Hour × Scheduled Hours × Lines

Rated Capacity = Planned Units per Hour × Effective Hours Before Factors × Lines

Effective Capacity = Rated Capacity × Utilization Rate × Efficiency Rate

Actual Gross Output = Actual Units per Hour × Effective Hours Before Factors × Lines

Good Output = Actual Gross Output × (1 − Scrap Rate)

Capacity Gap Units = Effective Capacity − Demand Units

Capacity Gap Percentage = (Capacity Gap Units ÷ Demand Units) × 100

Extra Hours Needed = Required Hours at Actual Speed − Effective Hours Before Factors

How to Use This Calculator

Enter the planned and actual hourly production rates.
Provide available hours, overtime, downtime, and number of lines.
Input utilization, efficiency, and scrap percentages.
Enter demand units for the planning period.
Submit the form to view capacity, output, and gap results.
Review the chart to compare design, effective, demand, and good output.
Use CSV for sharing data and PDF for printable review.
Adjust inputs to test improvement scenarios like lower downtime or extra overtime.

Frequently Asked Questions

1. What does a negative capacity gap mean?

A negative gap means capacity is below demand. The plant may miss orders unless it adds hours, improves throughput, reduces scrap, or shifts load elsewhere.

2. Why are utilization and efficiency both included?

Utilization reflects how much scheduled time is actually used. Efficiency reflects how well the line performs while running. Together, they create a more realistic capacity estimate.

3. Is good output more useful than gross output?

Yes. Good output removes scrap losses and better represents saleable units. It is usually the most practical number for order fulfillment and planning decisions.

4. Should downtime include planned maintenance?

It can. Many teams include planned maintenance, breakdowns, changeovers, and waiting time if they reduce productive hours during the selected planning period.

5. Can I use this for multiple production lines?

Yes. Enter the number of active lines. The calculator multiplies capacity and output across those lines, assuming similar rates and operating conditions.

6. What is the required gross rate metric?

It estimates the hourly production rate needed before scrap losses. This helps planners see the actual line speed required to satisfy net demand.

7. When should I add overtime instead of capacity investment?

Use overtime for short-term spikes or seasonal demand. Consider investment when shortages persist, overtime costs rise, or service risk stays consistently high.

8. Can this support scenario planning?

Yes. Change utilization, efficiency, scrap, downtime, or lines to test improvement plans. It is useful for weekly, monthly, and budgeting reviews.