ERP & MRP Planning worked example

Capacity Gap Analysis with available capacity hours of 2,100 hr: a worked example in erp & mrp planning

Suppose available capacity hours falls to 2,100 hr. This page works the full calculation at that level so you can see exactly which result moves and by how much. Calculate the gap between available capacity and required capacity, reported against a reference capacity basis.

The inputs for this scenario

  • Available capacity hours: 2,100 hr (the input this scenario stresses; the baseline uses 4,200)
  • Required demand load hours: 4,650 hr (held at the documented default)
  • Reference capacity basis: 4,650 hr (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Capacity gap = available capacity hours - required demand load hours.
  • Capacity gap percent works out to -54.84 % at these inputs, and this is the headline figure for the scenario.
  • Capacity gap hours works out to -2,550 hr at these inputs.
  • Available capacity hours works out to 2,100 hr at these inputs.
  • Required demand load hours works out to 4,650 hr at these inputs.

How this compares with the baseline

  • Against the tool's baseline example, where available capacity hours sits at 4,200 hr and the headline result is -9.68 %, this scenario comes in 467% below the baseline at -54.84 %.
  • It computes the capacity gap in hours (available minus required) and as a percent of a reference capacity basis. When the numbers land here, the stressed input is the lever to work; the walkthrough above shows exactly how much each output recovers as it climbs back toward the baseline.

Results at a glance

  • Capacity gap percent: -54.84 % (headline result)
  • Capacity gap hours: -2,550 hr
  • Available capacity hours: 2,100 hr
  • Required demand load hours: 4,650 hr

Run it with your numbers

  • To rerun this with your own numbers, open the live Capacity Gap Analysis calculator, set available capacity hours to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.