ERP & MRP Planning calculator

Capacity Gap Analysis Calculator

Capacity gap analysis measures the difference between the hours a work center can supply and the hours your demand load requires, expressed both in raw hours and as a percent of a reference capacity. Capacity planners and master schedulers run it to see at a glance whether a period is overloaded or has slack, and by how much. It matters because a small percentage gap can still mean hundreds of unschedulable hours at the bottleneck, forcing overtime, outsourcing, or pushed-out orders. The percent view normalizes the gap so you can compare across work centers and weeks regardless of their size.

What this calculator does

  • Calculate the gap between available capacity and required capacity, reported against a reference capacity basis.
  • a capacity planner needs to quantify overload or unused capacity
  • It computes the capacity gap in hours (available minus required) and as a percent of a reference capacity basis.

Formula used

  • Capacity gap = available capacity hours - required demand load hours
  • Capacity gap percent = capacity gap ÷ reference capacity basis × 100

Inputs explained

  • Available capacity hours:
  • Required demand load hours:
  • Reference capacity basis:

How to use the result

  • Use it during rough-cut and detailed capacity planning, whenever load hours are estimated, to flag overloaded or underloaded periods.
  • It is a single-period, single-resource snapshot; a positive net gap can still hide a daily or work-center bottleneck that the aggregate number averages away.

Current U.S. benchmarks

  • Manufacturing hourly earnings average $30.27 (BLS, Jun 2026), up 4.4% from a year earlier. Median machinist pay is $28.24/hr (OEWS 2025), with state medians on each state page. Manufacturers have 529k open positions nationally (BLS JOLTS).
  • U.S. manufacturing runs at 75.6% of capacity (Federal Reserve, May 2026). New factory orders are up 2.3% year over year (Census).

Common questions

  • How do you calculate a capacity gap? Subtract required demand load hours from available capacity hours, then divide that gap by your reference capacity basis and multiply by 100 for the percent. With 4,200 available and 4,650 required against a 4,650 basis, the gap is -450 hours, or -9.68%.
  • What does a negative capacity gap mean? It means demand exceeds capacity; you're overloaded. The -450-hour, -9.68% result says you need about 10% more hours than you have, which must come from overtime, added shifts, outsourcing, or re-timing orders.
  • What is a good capacity gap percentage? A small positive gap, often a few percent, is healthy: it leaves slack for variability without idling resources. A negative gap signals overload; a large positive gap (say above 15-20%) may mean underused, costly capacity worth reallocating.
  • Why express the gap as a percent instead of just hours? Hours show the absolute shortfall, but percent normalizes it against capacity so you can compare a small cell to a large plant. A -450-hour gap is alarming on a 4,650-hour base (-9.68%) but trivial on a 50,000-hour base.
  • Which reference basis should I use? Usually available capacity or required load, depending on whether you want the gap relative to what you have or what you need. Here the 4,650-hour required load is the basis, so the percent reads as the shortfall against demand.

Last reviewed 2026-05-12.