Quantity effect uses planned unit price; price effect uses actual quantity. Both effects sum to actual cost less plan.
Reconciliation / Department controller
Variance Explained
Split cost variance into quantity and unit-price contributions.
01 / Inputs
Working sheet
Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.
| Cost line | Planned units | Plan EUR/unit | Actual units | Actual EUR/unit | Row |
|---|
02 / Review
Decision sheet
| Line | Quantity effect | Price effect | Net |
|---|---|---|---|
| Support | €60.00 | €55.00 | €115.00 |
| Storage | €-20.00 | €0.00 | €-20.00 |
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.
The free tool runs independently on your device.