Variance Explained
Split cost variance into quantity and unit-price contributions.
Prepare your sheet
Use one row per cost line observation. Enter Planned units, Plan EUR/unit, Actual units, Actual EUR/unit. Check that every row belongs to the same review scope.
Decision rule
Quantity effect uses planned unit price; price effect uses actual quantity. Both effects sum to actual cost less plan.
Worked result
The fictional example contains 2 input rows. Its result is €95.00 net variance.
| Line | Quantity effect | Price effect | Net |
|---|---|---|---|
| Support | €60.00 | €55.00 | €115.00 |
| Storage | €-20.00 | €0.00 | €-20.00 |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
Split cost variance into quantity and unit-price contributions. The business case pairs prepared back-office work with a person responsible for exceptions. Benchcraft designed this tool’s inputs, decision rule and example for this office task. Reviewed source · Greg Isenberg at 1:45.
Request a custom workflow. €149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.