A purchase price variance calculation in three numbers: the price you budgeted, the price the invoice charged, and what the gap costs you this month and across a year.
What is price variance? The gap between the price you planned to pay and the price the invoice actually charged. Put both prices in to see what it cost you this month and over a year.
Standard and actual
$
The price you budgeted, quoted or last agreed. Accounting calls the gap against it the material price variance.
$
What the invoice really charged for the same case, same pack, same grade.
Volume on the invoice
cases
Cases of this item received in the month. To calculate price variance you hold the quantity still, so the price variance formula measures both prices on this same volume.
Unfavorable price variance
$2,400
$0.40 a case across 6,000 cases
Variance per case
$0.40
$22.40 actual against the $22.00 standard
Variance as a percent
1.8%
$0.40 on a $22.00 standard price
Spend at the standard price
$132,000
6,000 cases at $22.00
What you actually spent
$134,400
$132,000 plus the $2,400 variance
A year at this variance
$28,800
12 months of $2,400
1.8% reads like rounding. It is $2,400 this month and $28,800 a year, and it never appears on a price list because the list price never changed.
Estimates only. This is a pure price variance, so it holds the quantity still. A full cost variance calculation also carries the usage and mix you bought, not just the price you paid for it.
Are you paying your own price list?
Five quick questions. At the end you get the gap between what you agreed and what you paid, and what a year of it is worth.
Step 1 of 6
The situation
What made you look?
Pick the closest one.
Pick one to carry on.
The two prices
What did you agree, and what did you pay?
Standard is the price on the agreement. Actual is what the invoice said.
$
The price on the agreement or the price list.
$
What you were actually billed.
Enter a standard price above zero.
The volume
And how many cases?
This is what turns a few cents into a number worth a phone call.
cases
From this supplier, of this item.
That cannot be negative.
How you run it today
How do you catch a price that moved without warning?
A few cents a case does not look like anything on one invoice.
Pick one to carry on.
And who does it
Who checks an invoice against the quote?
Last one before your numbers.
Pick one to carry on.
Your breakdown is ready
Price variance this month
--
The headline number. The rest are below.
Want to see your results?
You have given us enough to work this out. Fill this in and the full breakdown opens up.
Loading the form.
The form did not load.Your browser or your network is most likely blocking it. That should not cost you the numbers you just worked out.
Your details go straight to our team, who will follow up about these numbers.
Your result
Working it out.
Here is your breakdown.
Price variance this month
--
A year at this variance
--
Variance per case
--
Variance as a percent
--
Spend at the standard price
--
What you actually spent
--
A cost increase costs you twice if your own price list never catches up.
VoiceOrder Solutions keeps personalized order guides per customer tied to current pricing, so a cost change reaches every account instead of waiting on a spreadsheet.
Estimates only. Confirm the standard price against the agreement before raising it.
$2,400
Unfavorable price variance on one item in one month
1.8%
How small the same gap looks as a percentage
$28,800
What that 1.8% is worth across a year
The Basics
What is purchase price variance?
Purchase price variance is the gap between what you paid for an item and its standard price, times the quantity bought. Paying more is unfavorable and paying less is favorable. It measures price alone, with quantity held still. It is how a buyer checks whether a supplier held the agreed price.
When the gap is counted
Teams differ on when they count it: when the goods arrive or when the invoice posts. Pick one point and hold it, or one month will not compare with the next.
Shorter payment terms slip past it
Payment terms. A supplier can hold the $22.00 price and give you fewer days to pay. Your cost of buying rises, and no variance shows it.
Where a distributor starts
Start with the lines you buy most. A 1.8% gap on a slow item is small change. The same gap on your busiest line repeats on every delivery.
Who It's For
Who uses a purchase price variance calculator
Purchasing and finance teams at food distributors use it when supplier invoices are checked against agreed prices. Anyone who approves invoices or owns a cost budget should see each gap in dollars.
Owners watching cost of goods
Buyers holding suppliers to contract
Finance teams tracking cost trends
Receiving clerks checking deliveries
Accounts payable approving invoices
Category managers renewing contracts
Pricing staff passing on increases
Purchasing leads recovering overcharges
Controllers comparing standard and actual
How It Works
How to run a purchase price variance calculation
Three numbers, one item, one month. Hold the quantity still and the answer is price and nothing else.
1
Enter the standard price you budgeted
$22.00 a case is the price you quoted, agreed or last paid. Write the date next to it, because an old standard reads as a variance.
2
Enter the price the invoice charged
$22.40 for the same case, same pack, same grade. The 40 cents between them is your price variance per case.
3
Enter the cases you bought this month
6,000 cases turns 40 cents into $2,400, and the panel carries it out to $28,800 a year.
What You See
What the calculator shows you
The headline
The total variance, with its sign
$0.40 a case across 6,000 cases is $2,400 unfavorable and the card is red. Pay $21.60 instead and the same $2,400 is favorable and the card turns green.
The subtraction is exact. The variance is only as honest as three inputs, and each one fails in a familiar way.
1
Overcharges already credited
If the supplier has already credited an overcharge, use the corrected price. Otherwise the variance flags a gap that has been settled.
2
The same unit on both sides
Check that the standard and the invoice price the same unit. A standard per case against an invoice priced per pound gives a gap that is only arithmetic.
3
Supplier item codes matched to yours
A supplier that renumbers an item can make it look new, with no standard at all. Match their item code to your own before you compare.
Sound Familiar?
A price variance hides in the percentage, not in the dollars
What is price variance? The gap between the price you planned to pay and the price you were charged. It is small on one case and large on a year.
The invoice looked about right.
$22.40 against a $22.00 standard is 40 cents, which nobody queries. Across 6,000 cases it is $2,400 this month and $28,800 a year.
Nothing changed on the price list.
It never does. A standard price is the one you budgeted, so a 1.8% drift lands on invoices and never on the list you compare against.
We came in under standard, so we are fine.
A favorable $2,400 is worth the same look. Paying $21.60 instead of $22.00 is a saving only if the pack, grade and count are the same.
The Comparison
Three ways to watch what you pay, and which one holds up
Same $22.00 standard, same $22.40 invoice, same 6,000 cases. These are the three ways a 40 cent gap gets caught or missed.
What you need before you approve the next invoice
Actual price against a standard price
Eyeballing the invoice total
Watching your gross margin instead
Names the gap in dollars per case
No, a total hides 40 cents a case
No, it reports the result and not the cause
Puts the gap on the month's real volume
Only if last month's invoice is in front of you
Yes, but blended with every other item
Shows the percent and the dollars together
No, neither one
Percent only, and a month late
Separates price from quantity
No, a bigger total can just be more cases
No, mix and volume move it as well
Carries the gap out to a year
No
No, it reads backward and not forward
Catches a favorable gap too
Rarely, a lower total reads as good news
No, a favorable buy just looks like a better month
Works one item at a time
No, the invoice covers the whole truck
No, one item disappears in the blend
Needs nothing you do not already have
Yes
Yes
Where it falls down
It is only as good as the standard you typed, so an old standard reads as a variance
It only catches a jump big enough to see
By the time margin moves, the quarter is already priced
Best used for
Holding a supplier to the price you agreed, item by item
One of these six is the standard you compare against. The other five are why the invoice stops matching it.
The standard you set
A standard from last year is not a standard. $22.00 has to be a price somebody agreed to, with the date it was agreed on beside it.
Pack and grade substitutions
A favorable $2,400 can be a cheaper grade in the same case. Compare like for like or the variance measures the swap instead of the price.
Freight sitting on the invoice
A 40 cent gap can be freight rather than product. Decide once whether freight belongs in the $22.00 standard, then keep it there.
A volume tier you did not hit
Tier pricing is still a price, so a tier you missed lands here. Run the tool per tier rather than blending two prices into one standard.
When you bought, not just what
An off-contract buy to cover a hole prices at the spot number. A $0.40 gap often starts as a shortage somebody solved in a hurry.
Rebates and off-invoice allowances
An off-invoice allowance never touches the $22.40 you were charged, so the $2,400 is real this month. Decide once whether the standard is gross or net of rebates.
See how VOS turns every order it takes into a dated record
VoiceOrder Solutions numbers, dates and timestamps every order placed in it. The volume your accounts ordered is then a dated record, which is where a 6,000 case month should start.
Customer orders arrive in a format you already use
VOS does not read supplier invoices or calculate variance. It covers the same items on the way out, as customer orders. Each one placed in the VOS app reaches you by email, EDI, API or QuickBooks.
PDF, Excel or Word by email to a rep or purchasing team
PPV is purchase price variance, the gap between the price you budgeted for an item and the price you were charged for it. Subtract the standard price from the actual price, then multiply by the cases you bought. $22.40 against a $22.00 standard across 6,000 cases is $2,400 unfavorable for the month.
How do you calculate the purchase price variance (PPV)?
Per item, per month, straight off the invoices. Pull every receipt line for that item, take the price each one charged, and set it against the $22.00 standard. Multiply the gap by the cases you received, not the cases you ordered. Hold the quantity still on both sides, because this answers price and nothing else.
What is a good PPV value?
There is no published benchmark, so judge it in dollars and by direction. A 1.8% gap reads like rounding and is $28,800 a year, which is worth a phone call. A good PPV is small, explained and shrinking, and a favorable one still needs a reason.
What is the formula for price variance?
Price variance is actual price less standard price, times the quantity you bought, which accounting also calls the material price variance. $0.40 times 6,000 cases is $2,400. This is the cost accounting kind of variance, not the statistical kind, so nothing here gets averaged or squared.
What is the formula for PPV?
PPV equals actual unit price less standard unit price, times units purchased. A positive answer is unfavorable, because you paid more than you planned. Pay $21.60 against the same $22.00 standard and the figure is $2,400 favorable, with actual spend at $129,600 rather than $134,400.
What is a PPV calculation?
It is a monthly check that your invoices match the prices you planned, run item by item. Here it holds $132,000 of spend at standard against the $134,400 you really spent. It is not a full cost variance calculation, because the quantity and the mix you bought are held still.
How is MUV calculated?
Material usage variance takes the quantity side: actual quantity less standard quantity, times the standard price. Price variance and usage variance split the same total gap between them, so run both before you blame the supplier. This tool does the price half, with the 6,000 cases held constant.
Catch a cost increase before your own price list misses it
VoiceOrder Solutions keeps personalized order guides tied to your current pricing, so a $0.40 cost increase reaches every account's guide instead of waiting on a spreadsheet.