S&OP, Demand Planning & Forecasting calculator
Supply Review Capacity Gap Calculator
Supply review capacity gap estimates the hours required to work through a supply plan in the S&OP supply review, where planners validate that capacity, materials, and lead times can meet the demand plan. Supply planning managers use it to know whether the review can be completed before the pre-S&OP meeting or whether constraint analysis is outrunning available hours. It converts the number of plan lines and a review pace into a realistic hour figure with overhead. When SKU or resource complexity grows, this is the number that reveals the capacity crunch.
What this calculator does
- Estimate supply review capacity gap for sandop, demand planning and forecasting using production-ready inputs so teams can plan labor hours, schedule the work, or check whether the job fits the available shift time.
- Use it when supply review capacity gap in s and op, demand planning and forecasting is changing rate or allowance and you want to see the impact.
- It computes base supply review time as plan lines divided by review pace, then applies a setup, handling, and delay allowance to yield required hours.
Formula used
- Base supply review capacity gap time = supply review capacity gap workload ÷ supply review capacity gap completion rate
- Required supply review capacity gap time = base supply review capacity gap time × allowance factor
Inputs explained
- Supply plan lines to review:
- Supply lines reviewed per minute:
- Setup, handling, and delay allowance:
How to use the result
- Use it when scheduling the supply review, testing whether headcount can absorb added resources or constraints, or scoping tools that speed constraint checking.
- It uses one average review pace, but constrained lines needing what-if analysis take far longer than balanced ones, so the flat allowance can understate effort in a tight capacity period.
Current U.S. benchmarks
- The producer price index for steel mill products stands at 348.53 (BLS, May 2026), up 6.7% from a year earlier. Quotes priced off last quarter's material cost miss this move.
- The U.S. has 3,569 primary metal manufacturing establishments employing about 354,911 workers (Census County Business Patterns, 2023).
Common questions
- How do you calculate supply review hours? Divide the plan-line count by the review pace for base minutes, convert to hours, then multiply by one plus the allowance. With 120 lines at 12 per minute and a 10% allowance, base time is 10 hours and required time is 11 hours.
- What is a good allowance for supply review? Because supply review involves constraint checking and what-if analysis, a 10% to 25% allowance is typical. Periods with active capacity bottlenecks or supplier issues justify the higher end; balanced, unconstrained plans sit near 10%.
- How is supply review different from demand review? Demand review validates the forecast; supply review validates the ability to make and deliver it. Supply review lines often carry constraint math, so even at the same count and pace, the exception tail tends to be heavier.
- Why does the review pace matter so much? Pace is the biggest driver of hours. Doubling the review pace halves base time. In the example, 12 lines per minute yields 10 base hours; a slower manual pace would multiply the required hours and can create the capacity gap the calculator is named for.
- How do I close a supply review capacity gap? Constraint-based planning tools that pre-flag infeasible lines let planners focus only on real bottlenecks, raising effective pace. Standardizing what-if templates and cleaning capacity master data also cut the per-line time.
Last reviewed 2026-05-12.