Manufacturing Capacity Planner
€19.99 · Excel template, digital download
- Calculate required production time
- Monitor machine capacity utilization
- Identify overloaded production lines
- Detect production bottlenecks
Free calculator
Free Manufacturing Capacity Calculator
Compare ideal and expected output with a target and see the extra time needed.
Enter the available production time and the ideal cycle time to see the capacity.
Ideal Capacity
Theoretical maximum, not a target
Expected Capacity
Needs validationEstimated good units, not a guarantee
Data check required
Note
Additional Planned Production Time Required
Available Production Time
—
Planned time, planned non-production time excluded
Overall Efficiency used
—
Full OEE: availability × performance × quality
Time needed at ideal speed
—
Target × Ideal Cycle Time ÷ 60
Time needed at expected efficiency
—
Target × Ideal Cycle Time ÷ (60 × efficiency)
Additional planned time at ideal speed
—
Time needed − available time, never below 0
Additional planned time at expected efficiency
—
Time needed − available time, never below 0
Capacity on one scale
Good units over the available time. The dashed line marks your target once you have entered it.
Ideal Capacity (theoretical maximum)
Expected Capacity (estimated good units)
| Measure | Whole units | Fractional |
|---|---|---|
| Ideal Capacity | ||
| Expected Capacity | ||
| Target Quantity | ||
| Gap at ideal capacity | ||
| Gap at expected capacity |
Three different things
Theoretical maximum
Ideal Capacity: output if every available minute ran at the ideal cycle time with no stops, slow running or defects.
Expected good-unit output
Ideal Capacity × your overall efficiency. An estimate from historical or assumed performance.
Guaranteed delivery
Never calculated here. It also depends on materials, labour, maintenance, scheduling and day-to-day variation.
What is manufacturing capacity?
Capacity is how many good units a process can produce in the time available. For planning, three numbers are easy to confuse: the theoretical maximum, a realistic estimate, and what you can actually promise a customer. This calculator shows the first two and is explicit about the third.
Theoretical maximum
Ideal Capacity = 60 × Available Production Time ÷ Ideal Cycle Time. It assumes every available minute runs at the ideal speed, with no stops, no slow running and no defects. It is an upper limit, not a plan.
Expected good-unit output
Expected Capacity = Ideal Capacity × Overall Efficiency. An estimate for good first-pass units, using the efficiency you supply or your historical OEE. It is only as good as that figure.
Guaranteed delivery
Never calculated by this page. Delivering an order also depends on materials, labour, maintenance, scheduling, quality and day-to-day variation that no single efficiency figure captures.
Additional Planned Production Time Required = Target × Ideal Cycle Time ÷ (60 × efficiency) − Available Production Time, never below zero. It is not automatically paid overtime.
Limits of this calculator: one product, or one consistently defined unit, with one ideal cycle time and one overall efficiency. Mixed products, batch processes, parallel machines and changeovers need additional analysis. The projection assumes the same overall efficiency continues during any additional time. Fixed losses, variable product mixes and production constraints can invalidate that. It is a planning estimate, not a schedule and not a delivery promise.
Worked example
An illustrative case. Use "Load full example" above to fill in these values. The page itself opens with only the time and the cycle time, because efficiency and target are yours to enter.
| Measure | Value | How |
|---|---|---|
| Available Production Time | 450 min | Planned production time |
| Ideal Cycle Time | 30 s per unit (120 units/hour) | |
| Ideal Capacity | 900 units | 60 × 450 ÷ 30 |
| Overall Efficiency (full OEE) | 79.7% | Historical, entered by the user |
| Expected Capacity | 717.3 units (717 complete) | 900 × 0.797 |
| Target Quantity | 800 good units | Entered by the user |
| Potential shortfall | 83 units | 717 − 800 |
| Time needed at expected efficiency | 501.9 min | 800 × 30 ÷ (60 × 0.797) |
| Additional Planned Production Time | 51.9 min | 501.9 − 450 (assumes the same efficiency continues) |
| Time needed at ideal speed | 400 min | 800 × 30 ÷ 60: fits in 450 min, so 0 min additional |
The target of 800 would fit in the available time at the ideal speed, but at 79.7% efficiency the process is expected to fall 83 units short. With a target of 1,000 the target exceeds even the theoretical maximum of 900 units.
Manufacturing capacity calculator FAQ
What is the difference between ideal and expected capacity?
Ideal Capacity is the theoretical maximum: output at the ideal cycle time for the whole available time. Expected Capacity multiplies that by your overall efficiency, so it reflects the stops, slow running and defects you typically see. The expected figure is an estimate. Neither is a guarantee of delivery.
Which efficiency figure should I enter?
Your overall equipment effectiveness (OEE): availability × performance × quality. It is the share of planned production time that turns into good units. If you only know one component, for example performance on its own, do not enter it here, because the result would ignore the other losses.
Why is there no downtime field?
Because full OEE already contains the time lost to stops. Subtracting downtime and then applying OEE counts the same loss twice. With 450 minutes, a 30-second cycle and 79.7% OEE, the correct expected output is 717 units. Removing 47 minutes of stops first and then applying 79.7% would give only 642.
Why does the calculator not assume a default efficiency?
Any default would be a guess presented as a fact. Expected Capacity stays unavailable until you enter an efficiency or bring one over from the OEE calculator, and the Ideal Capacity is always shown.
What does "Additional Planned Production Time Required" mean?
The extra scheduled production time needed to make the target as good units, at the efficiency you entered: Target × Cycle Time ÷ (60 × efficiency) minus the available time, never below zero. It is not automatically paid overtime. It could also be an extra shift, a longer run or a later due date.
How reliable is the additional time?
It is an estimate. It assumes the same overall efficiency continues during the additional time. Fixed losses such as changeovers, a variable product mix and production constraints can invalidate that assumption.
What if my efficiency is above 100%?
A full OEE cannot exceed 100% of the ideal output. The calculator keeps the mathematical values visible but marks them as needing validation. It will not describe the target as achievable until the data is corrected. Check the ideal cycle time, the unit counts and the time basis.
Why are shortfall and surplus in whole units?
Customers need complete good units, so the comparison counts only whole units. The fractional capacity, for example 717.3, is shown as supporting information.
Can I use it for several products, batches or parallel machines?
Not in this version. It describes one product or one consistently defined unit, on one process, with one ideal cycle time. Mixed products, batch processes, parallel machines and changeovers need additional analysis.
Can I bring my OEE over from the OEE calculator?
Yes. The OEE calculator offers a link that passes only your Ideal Cycle Time and your OEE, in the address, so you can see exactly what is passed. The values arrive in the fields marked as imported, and you can edit both. Your planned production time and target are never passed.
Is my data stored or sent anywhere?
No. The calculation runs in your browser and nothing you type is sent to our servers.
Related free tools: the OEE calculator to measure your efficiency, and the takt time calculator to check your pace against demand.
Plan several jobs and machines
This free calculator gives one snapshot for one product and never needs a purchase. For several jobs, machines and setup effects, SmartFactoryTools has Excel workbooks, sold through Etsy.
Smaller alternatives
- Machine Capacity Calculator · Calculate required production hours; Compare required time with available machine hours€7.99
- Line Capacity Planner · Plan multiple production orders in one workbook; Assign orders to different production lines€7.99