Capacity Requirements Planning Calculator

Calculate CRP by summing planned and released order hours per work center per period. Validate detailed capacity against production plans.

hrs
hrs
hrs
%
%
Capacity Load105.9%
โš  Overloaded by 10.0 hrs
Total CRP Load
180.0 hrs
Planned 120 + Released 60 hrs
Effective Capacity
170.0 hrs
Available 200 ร— 85% efficiency
Load %
105.9%
Over capacity โ€” action required
Capacity Position
-10.0 hrs
Deficit โ€” overtime or outsourcing needed
Setup Hours
21.6 hrs
12% of total load
Run Hours
158.4 hrs
Value-added production time
Per Work Center Load
45.0 hrs
105.9% average utilization
Overtime Required
10.0 hrs
5.0% capacity increase needed

Planning Horizon Summary (4-week)

Horizon Load
720 hrs
Total load over 4 weeks
Horizon Capacity
680 hrs
Effective capacity over 4 weeks
Horizon Position
-40 hrs
Infeasible โ€” adjust MPS

Work Center Load Breakdown

Work CenterLoad (hrs)Capacity (hrs)UtilizationStatus
WC-0135.442.5
83%
OK
WC-0246.142.5
109%
Over
WC-0351.842.5
122%
Over
WC-0455.542.5
131%
Over

CRP Load Classification Reference

Load RangeStatusRecommended Action
0โ€“60%Under-utilizedConsider consolidating work centers or accepting new orders
60โ€“85%OptimalIdeal operating range โ€” maintain current planning
85โ€“100%Near CapacityMonitor closely โ€” prepare contingency plans
100โ€“120%OverloadedSchedule overtime, outsource, or defer orders
>120%CriticalInfeasible โ€” must revise MPS or add capacity
Planning notes, formulas, and examples

About the Capacity Requirements Planning Calculator

Capacity Requirements Planning (CRP) is a detailed capacity validation tool that sums the hours from all planned and released production orders at each work center for each time period. Unlike rough-cut capacity planning (RCCP), CRP uses actual routing data and order quantities for precise load calculations.

CRP answers the question: given all the orders we plan to run and are already running, do we have enough capacity at each work center in each week? It provides a work-center-level, period-by-period load profile that shows exactly where and when capacity constraints will occur.

This calculator performs a simplified CRP for one work center, letting you enter planned order hours and released order hours, then comparing the total against available capacity. It shows load percentage, overload, and remaining capacity.

Precise measurement of this value supports data-driven planning and helps manufacturing professionals make informed decisions about resource allocation and process optimization strategies. Quantifying this parameter enables systematic comparison across time periods, shifts, and production lines, revealing patterns that might otherwise go unnoticed in routine operations.

When This Page Helps

CRP catches detailed capacity problems that RCCP misses. By using actual order data and routings, it provides the most accurate picture of whether your production plan is executable at each work center.

How to Use the Inputs

  1. Enter the total hours from planned orders at the work center.
  2. Enter the total hours from released (open) orders at the work center.
  3. Enter the available capacity in hours for the work center in the period.
  4. View total load, load percentage, and capacity position.
  5. If overloaded, adjust order timing, add overtime, or re-route work.
  6. Run CRP weekly as MRP regenerates planned orders.
Formula used
CRP Load = Planned Order Hours + Released Order Hours Load % = (CRP Load / Available Capacity) ร— 100 Capacity Position = Available Capacity โˆ’ CRP Load

Example Calculation

Result: 180 hrs load, 112.5% โ€” overloaded by 20 hrs

Total load = 120 + 60 = 180 hours. Available capacity is 160 hours. The work center is at 112.5% loading, overloaded by 20 hours that need to be resolved through scheduling changes or overtime.

Tips & Best Practices

  • Include both setup and run time in order hours โ€” setup can be significant.
  • Check CRP at each key work center, not just the known bottleneck.
  • Allow for efficiency factors if historical performance differs from standard.
  • Look ahead at least 4-8 weeks to catch problems early enough to resolve.
  • Use CRP to validate MRP output before releasing orders to the shop floor.
  • Combine CRP data from all products sharing a work center.

CRP Data Flow

CRP pulls data from three sources: (1) planned orders from MRP, (2) released orders from the shop floor control system, and (3) work center capacity from the capacity calendar. The intersection of these three data sources produces the CRP load profile.

Infinite vs. Finite Loading

Standard CRP performs infinite loading โ€” it piles all orders onto the work center timeline regardless of capacity limits. Finite loading then levels the load by moving orders to periods with available capacity. Most ERP systems offer both views.

CRP and Shop Floor Feedback

CRP accuracy depends on production reporting. When operators report completions, released order hours decrease. Late reporting makes CRP show more load than actually exists. Ensure timely production reporting for accurate CRP.

Sources & Methodology

Last updated:

Frequently Asked Questions

  • RCCP uses MPS quantities and aggregate load factors for quick validation. CRP uses detailed planned and released order data with actual routing times. CRP is more accurate but requires MRP to have run first.