Manufacturing Capacity Planning Excel Template (Free, by Work Center)
This capacity planning template compares the hours your work centers can deliver with the hours your orders require. Enter machines, shifts and realistic efficiency, add load from your orders, and see which work center is overloaded.
| Work center | Machines | Hours per shift (h) | Shifts per day | Working days in period (days) | Efficiency x utilization (%) | Available capacity | Load (required hours) (h) | Load vs capacity | Spare (+) / short (-) | |
|---|---|---|---|---|---|---|---|---|---|---|
998 hrs | 22% | 778 hrs | ||||||||
768 hrs | 31.3% | 528 hrs | ||||||||
262 hrs | 114.3% | -38 hrs | ||||||||
272 hrs | 69.9% | 82 hrs | ||||||||
144 hrs | 83.3% | 24 hrs |
Anything above 100 percent in the Load vs capacity column is overloaded: add shifts, outsource, move work to another center or move the due date. Above roughly 85 to 90 percent, queues grow quickly even though the center is not formally overloaded.
Ask your ERP about capacity
Optional: see how a private AI layer could answer capacity and load questions from your own ERP data.
Optional. The tool and every export work without this. No spam.
How to use the capacity planning template
Choose the planning period, for example a month with 20 working days, and list your work centers. Enter machine count, hours per shift, shifts per day and working days, then an efficiency figure that reflects real productive time. Available capacity is calculated for you. Enter load as the setup plus run hours from open and forecast orders on that work center, taken from your routings. The sheet shows load as a percentage of capacity and the spare or short hours. Edit rows, add work centers, and export to Excel or PDF for the planning meeting.
- Use realistic efficiency, not 100 percent.
- Load = setup hours + run time per piece x quantity, from routings.
- Plan the bottleneck work center first.
- Re-run weekly as orders change.
The formula behind the sheet
Available capacity = machines x hours per shift x shifts x days x efficiency. Load = sum of required hours of all orders in the period. Load versus capacity = load divided by capacity. Rated capacity in many ERP systems uses the same logic: calendar hours times efficiency times utilization. If your efficiency figure is a single number, it should combine planned downtime, changeovers and typical performance loss. Compare it with OEE from the shop floor when you have it.
Reading the result and common mistakes
A plant average of 75 percent can hide a grinder at 150 percent. Always read by work center. Common errors are using nameplate hours with no efficiency, ignoring setup time, loading from sales forecasts without routings, and forgetting maintenance shutdowns. When a center is overloaded, look at overtime, extra shifts, alternate routings, subcontracting and lot-size changes before moving customer dates. Keep the plan updated so it matches the ERP's finite or infinite load views.
Frequently Asked Questions
How do you calculate manufacturing capacity?
Multiply machines by hours per shift, shifts per day and working days to get scheduled hours, then apply an efficiency or utilization factor for downtime and changeovers. Compare that to the hours required by the orders.
What efficiency should I use?
Use history where you have it, such as OEE or reported versus standard hours. Many discrete job shops plan between 70 and 85 percent. Start conservative and adjust after a few periods of actuals.
Is this the same as finite scheduling?
No. This is rough-cut capacity planning by period. Finite scheduling sequences individual jobs by day against capacity. Use this first to see whether the plan is feasible at all.
Can I export it to Excel?
Yes. The sheet exports to Excel, CSV or PDF, and the formulas are computed in the export so you can keep working in your own spreadsheet.
If load and routing data live in your ERP, Netray can add a private AI layer on your own servers that answers 'which work center is overloaded next month' from live data, without sending it outside.
Related Tools
Finite Capacity Scheduling Worksheet
Load jobs against a work center with setup, run time and available hours per day, and see the hours and days of work you are committing.
SAPSAP Work Center Weekly Load Worksheet
A weekly capacity versus load sheet per work center using the SAP available capacity logic, with utilization and free hours.
Infor SyteLineSyteLine Work Center Capacity Load Worksheet
Compare weekly available capacity with planned load by work center and spot overloaded and underused resources.
MES & Shop FloorDaily Production Schedule Board Worksheet
An editable job board that totals setup and run hours per line so a scheduler can see whether the day fits the shift.
More MES & Shop Floor tools
See all- Line Balancing Worksheet
- SMED Changeover Reduction Worksheet
- Production Schedule Template
- Bottleneck Analysis Calculator
- Drum Buffer Rope Buffer Sizing Calculator
- Production Schedule Adherence Calculator
- Production Schedule Release Checklist
- Shift Handover Production Log Template
- Changeover Sequence Planning Worksheet
Keep exploring
Free tools
- Manufacturing Capacity Planning Template (Excel)An editable capacity planning spreadsheet for work centers. Enter machines, shifts and planned load by week and see available hours, utilization, spare hours and overload flags.
- SAP Work Center Capacity Planning CalculatorCalculate available capacity, capacity requirements and load percent for a work center from shifts, utilization, setup and run times.
- VISUAL Shop Load Versus Capacity CalculatorEnter load hours and shift pattern for a work center to see utilization, overload hours and the weeks needed to clear the backlog.
Guides
- Capacity Requirements Planning Configuration in SyteLineConfigure SyteLine Capacity Requirements Planning with work center capacity, routing-based load calculation, and bottleneck analysis for production scheduling.
- How to Configure Work Centers in Infor SyteLineStep-by-step guide to configuring work centers in Infor SyteLine. Learn how to define capacity, efficiency rates, cost categories, and scheduling parameters.
- Infor LN Capacity Requirements Planning (CRP) ConfigurationConfigure capacity requirements planning in Infor LN with work center setup, capacity profiles, CRP analysis, and finite scheduling for load balancing.