Procurement leaders
Turn purchasing records into priorities for savings and risk reviews.
Manufacturing Planning Tools
Production Capacity Planner Online Free
Compare required production hours with effective machine or line capacity and identify shortages or surplus.
Required hours
300
Effective capacity hours
538.56
Capacity utilization
55.7%
Maximum output
17,952
Capacity available
Surplus of 238.56 effective hours. Confirm maintenance, changeovers and demand timing before accepting additional work.
Business context
The business problem this tool helps solve
Production commitments often use theoretical machine hours while ignoring planned downtime, realistic efficiency and cycle time. Capacity planning converts these factors into effective hours so bottlenecks are visible before due dates are promised.
What can happen when the issue is ignored
- • Customer date committed without feasible capacity
- • Overtime approved without quantified shortage
- • Downtime double-counted or ignored
- • Cycle-time improvements not reflected in planning
Who should use this tool?
This guidance is designed for people who need to use production capacity planner results in a real approval, planning or operational workflow.
Finance and FP&A
Understand spending movements, exposure and performance trends.
Business analysts
Prepare a management-ready view from ordinary CSV or Excel data.
Input guide
Prepare the inputs before calculation
| Column | Purpose | Example |
|---|---|---|
| Required Units * | Production quantity to complete in the planning horizon. | 10000 |
| Cycle Time * | Standard minutes required per unit. | 1.8 |
| Machines / Lines * | Equivalent resources available. | 4 |
| Working Time * | Hours per day and working days. | 8 hours × 22 days |
| Downtime % * | Planned or expected unavailable time. | 10 |
| Efficiency % * | Realistic operating efficiency. | 85 |
Mapping note: Use consistent dates, currencies, units and definitions. A correct calculation based on inconsistent inputs can still lead to a poor decision.
From raw data to a business decision
Use the analysis as a controlled decision-support step: prepare reliable data, review the exceptions, verify the cause and document the action taken.
- STEP 1
Prepare
Clean the source data and confirm the required fields and reporting period.
- STEP 2
Analyse
Run the tool and prioritise the most important production capacity results.
- STEP 3
Investigate
Validate the cause with contracts, transactions and operational evidence.
- STEP 4
Act and review
Assign actions, export the report and measure improvement in the next cycle.
Decision support
Recommended next actions
These actions are practical review priorities. Apply your organisation's approval limits, tolerance rules and contractual requirements.
- 1
Immediate
Review the material production capacity exceptions
Start with records that have the greatest financial, service or operational effect. Confirm the source data before taking action.
- 2
Next
Identify the business cause
Separate genuine performance or demand movement from data quality, timing, unit, currency and process issues.
- 3
Monitor
Create a repeatable review
Run the analysis on a consistent schedule, record decisions and compare whether corrective actions improve the next period.
Practical review tips
- • Use one reporting period and consistent definitions.
- • Review high-value exceptions before low-value noise.
- • Keep operational context with the analysis.
Common mistakes
- • Using incomplete or stale records.
- • Mixing units, currencies or reporting periods.
- • Taking action without checking the underlying transaction.
Good control practices
- • Define thresholds before reviewing results.
- • Assign each action to an owner and due date.
- • Retain the exported report with management decisions.
Practical examples
How teams use this analysis
The same result can require a different response depending on product criticality, shelf life, contract terms, service impact and available alternatives.
Packaging
A seasonal order pushes utilization above effective capacity.
Expected outcome: The business evaluates a second shift and phased delivery before accepting the date.
Machining
One process has enough calendar hours but low effective efficiency.
Expected outcome: The bottleneck is addressed through setup and minor-stop reduction rather than buying another machine immediately.
About this manufacturing tool
Capacity planning tests whether available machines, working time, downtime and efficiency can meet a planned production quantity. It supports due-date commitments, overtime review and bottleneck discussions.
How to use it
- Enter values or upload a prepared CSV/Excel file where supported.
- Review units, standards and column mapping before analysis.
- Investigate exceptions using approved BOM, routing and inventory records.
- Download or print the result and document the authorised action.
Related Manufacturing Planning Tools
Frequently asked questions
Are uploaded manufacturing files sent to a server?
No. Supported CSV and Excel analysis runs locally in your browser.
Can this replace an ERP or MRP system?
No. It is transparent decision support for analysis and planning. Confirm results against approved masters, transactions and schedules.
Which units should I use?
Use consistent units for quantities, time and cost. Convert pack, weight, length and machine-time units before comparing or rolling up values.
How often should I review the result?
Review after meaningful demand, price, BOM, routing, yield, capacity or inventory changes and during the normal planning cycle.