ERP & MRP Planning worked example

Planned vs Actual Production with actual good production output of 940 units: a worked example

Suppose actual good production output falls to 940 units. This page works the full calculation at that level so you can see exactly which result moves and by how much. Calculate production variance between actual output and planned output.

The inputs for this scenario

  • Actual good production output: 940 units (the input this scenario stresses; the baseline uses 1,880)
  • Planned production output: 2,000 units (held at the documented default)
  • Planned output reference: 2,000 units (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Production variance = actual good output - planned output.
  • Production variance percent works out to -53 % at these inputs, and this is the headline figure for the scenario.
  • Production variance quantity works out to -1,060 units at these inputs.
  • Actual good production output works out to 940 units at these inputs.
  • Planned production output works out to 2,000 units at these inputs.

How this compares with the baseline

  • Against the tool's baseline example, where actual good production output sits at 1,880 units and the headline result is -6 %, this scenario comes in 783% below the baseline at -53 %.
  • It computes the unit gap between actual good output and planned output, and expresses that gap as a percentage of the planned reference. When the numbers land here, the stressed input is the lever to work; the walkthrough above shows exactly how much each output recovers as it climbs back toward the baseline.

Results at a glance

  • Production variance percent: -53 % (headline result)
  • Production variance quantity: -1,060 units
  • Actual good production output: 940 units
  • Planned production output: 2,000 units

Run it with your numbers

  • To rerun this with your own numbers, open the live Planned vs Actual Production calculator, set actual good production output to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.