ERP & MRP Planning calculator
Planned vs Actual Production Calculator
Planned vs actual production measures the variance between the good units you actually produced and the units your plan called for, as both a raw quantity and a percentage. Schedulers, supervisors, and operations managers use it to catch over- and under-production early, before it ripples into inventory carrying costs or stockouts. Because it nets actual good output against the plan, a negative variance flags a shortfall and a positive one flags overbuild — each carries a different cost. It is the simplest, fastest read on whether your demand plan and your floor capacity are in sync.
What this calculator does
- Calculate production variance between actual output and planned output.
- an operations manager needs to explain whether production beat or missed plan
- It computes the unit gap between actual good output and planned output, and expresses that gap as a percentage of the planned reference.
Formula used
- Production variance = actual good output - planned output
- Production variance percent = variance ÷ planned output reference × 100
Inputs explained
- Actual good production output:
- Planned production output:
- Planned output reference:
How to use the result
- Use it at shift or order close to quantify production shortfalls or overbuilds against the plan.
- It compares quantities only — it won't tell you the root cause (downtime, scrap, material) or whether the original plan was sound.
Current U.S. benchmarks
- Manufacturing hourly earnings average $30.27 (BLS, Jun 2026), up 4.4% from a year earlier. Median machinist pay is $28.24/hr (OEWS 2025), with state medians on each state page. Manufacturers have 529k open positions nationally (BLS JOLTS).
- U.S. manufacturing runs at 75.6% of capacity (Federal Reserve, May 2026). New factory orders are up 2.3% year over year (Census).
Common questions
- How do you calculate production variance? Subtract planned output from actual good output to get the unit variance, then divide by the planned reference and multiply by 100. With 1,880 actual against 2,000 planned, variance is -120 units, or -6%.
- Is a negative production variance bad? A negative variance means you produced less than planned — a shortfall that can cause late orders. The -120 units (-6%) in the example would need recovery or a re-plan to protect ship dates.
- What about positive variance — isn't more production good? Not always. Overproducing builds excess inventory, ties up cash, and can hide demand-planning errors. Positive variance is only 'good' when it's pulling ahead on real, scheduled demand.
- What is the difference between planned vs actual and schedule attainment? Schedule attainment measures the on-time percentage of the plan you hit. Planned vs actual measures the size and direction of the quantity gap, including overbuild — it shows whether you missed and by how much.
- Why use only good output in the actual figure? Counting scrap or rework as production overstates performance. Using good output ties variance to sellable, usable units so the number reflects real fulfillment, not gross throughput.
Last reviewed 2026-05-12.