Skip to article content
NUMERISH / INSIGHTSFinance operations

Budget variance analysis when volumes and unit prices both change

Separate volume and unit-price effects with a worked purchasing example and explain which operating owner can investigate each change.

Rows of tinned goods fill the shelves of a supermarket aisle.
Finance operations / Numerish Insight
Jump to a section
  1. 01Show a reproducible bridge
  2. 02Connect each difference to a decision

A distribution team budgets 1,000 units at 8 each and buys 1,100 at 9. Actual spend is 9,900 versus a budget of 8,000. Calling all 1,900 an overspend says little about whether purchasing or demand planning should investigate.

Show a reproducible bridge

One convention measures volume at the budget price and price at the actual volume. The extra 100 units account for 800. The extra 1 per unit across 1,100 units accounts for 1,100. Together the effects explain the 1,900 difference. State the convention and use it consistently when comparing periods.

Connect each difference to a decision

Check whether additional units reflect demand, waste or a purchasing minimum. Then investigate the price movement for freight, supplier changes or expired terms. Where product mix also changed, analyse comparable items before adding the results. Record who owns each explanation in the reporting pack.

Use the budget and variance review stages in FinPlan360 to assign the volume and price explanations to their operating owners.

KEEP EXPLORING

More to discover in Numerish.

Explore related insights and practical enterprise workflows.

Browse all insights
FROM INSIGHT TO ACTION

Put the ideas to work.

Explore connected finance and accounting workflows.

Explore Accounting360