For Independent Food Distributors

Purchase Price Variance Calculator

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.
VoiceOrder app ordering screen

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.
Book A Demo →
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.
Plus sign, for the point at which the variance is recorded

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.
Minus sign, for payment terms a price variance does not see

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.
Light bulb, for starting with the lines bought in the most volume

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.
Person, for owners watching cost of goods

Owners watching cost of goods

Check mark, for buyers holding suppliers to the contract price

Buyers holding suppliers to contract

Two people, for finance teams tracking cost trends by item

Finance teams tracking cost trends

Clipboard, for receiving clerks checking deliveries against the invoice

Receiving clerks checking deliveries

Office building, for accounts payable approving supplier invoices

Accounts payable approving invoices

Speech bubble, for category managers renewing supplier contracts

Category managers renewing contracts

Slider controls, for pricing staff passing a cost increase on

Pricing staff passing on increases

Mobile phone, for purchasing leads recovering overcharges

Purchasing leads recovering overcharges

Magnifying glass, for controllers comparing standard and actual price

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

A $0.40 a case gap across 6,000 cases is $2,400 unfavorable when invoiced at $22.40 and $2,400 favorable at $21.60, against a $22.00 standard.
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.
Red when unfavorable, green when favorable
Names the gap per case and the volume
Settles to whole cents before multiplying
Reads $0 when the invoice matches standard
Percent and dollars

The same gap in both units

40 cents on a $22.00 standard is 1.8%, which reads like rounding. The dollar cards sit beside it so you see the $2,400 at the same time.
Percent measured against the standard price
Dollars on the month's real volume
A penny a case still reads 0.0%
Holds the quantity still, so this is price only
A $0.40 a case gap on a $22.00 standard reads as 1.8% but is $2,400 this month, and a penny a case reads 0.0% while costing $60 a month.
6,000 cases at the $22.00 standard is $132,000 budgeted, while the invoices came to $134,400, exactly the $2,400 variance apart.
Two spend cards

Budget against what you actually paid

6,000 cases at $22.00 is $132,000 budgeted. The invoices came to $134,400, and the two cards differ by exactly the $2,400 headline.
Spend at standard and spend actual
The two always differ by the headline
Subtracts instead of adding when you beat standard
Works on one item at a time, which is the point.
A year of it

What the gap is worth if nothing changes

$2,400 a month is $28,800 a year. Widen the gap to $1.10 and the same 6,000 cases is $6,600 a month and $79,200 a year.
Twelve months at this month's rate
Scales straight with the price gap
Red while the variance runs against you
No cases yet means no cost, not a red card
A $0.40 gap on 6,000 cases is $2,400 a month and $28,800 a year, and widening it to $1.10 makes it $6,600 a month and $79,200 a year.
What to Look For

Make the price variance compare like with like

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.
Percent sign for a variance that hides in the rate

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.
Rising line for a cost that crept up off the price list

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.
Falling line for an invoice that came in under standard

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
A quick sanity check, not a measurement
Seeing that something slipped, not what
Six Levers

What actually moves a purchase price variance

One of these six is the standard you compare against. The other five are why the invoice stops matching it.
Target marking the standard price you set

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.
A single case standing in for a pack or grade substitution

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.
Route map for freight charged on the invoice

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.
Rising bars for a volume tier you did not hit

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.
Clock for when an off-contract buy was placed

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.
Dollar sign for the price your own accounts pay

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.
Order Formats

Where VOS fits next to purchase price variance

Order review screen in the VOS app, listing each item and quantity before the order is placed
Your Selling Side

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
Each account orders at the prices you set
Guide prices updated from one admin platform
Works alongside your ERP, with nothing to rip out
After The Numbers

What to do once you know the variance

A variance only pays off if somebody owns it. These nine habits turn the number into a conversation with the supplier.
Price tag marking a standard price per item

Set a standard price per item

Calendar for dating each standard price you set

Date every standard you set

Invoice being checked against the standard price

Check invoices against it weekly

Bar comparison of invoice price against standard price

Query the gap while the invoice is open

Stacked cases showing a pack or grade change

Ask what changed, pack or grade

Delivery truck for separating a short ship from a price gap

Keep a price gap apart from a short ship

Price list being updated the same week a cost moves

Move your own price list the same week

Balance scale weighing favorable against unfavorable variance

Report favorable and unfavorable apart

Cycle arrows for repricing every standard each quarter

Reprice every standard quarterly

What to Do Next

What to run after purchase price variance

The variance tells you what a price cost you. These three free calculators look at savings, freight and the terms you pay on.
Calculator, for separating hard savings from avoided increases

Separate real savings from avoided ones

See which part of a reported saving reaches the P&L, with hard savings kept apart from the increases you avoided.
Right arrow, for ranking supplier offers with freight in

Rank offers with freight counted

Weigh three supplier offers unit by unit, freight in, before the next standard price is set.
Cash bills, for putting a price on payment terms

Put a price on payment terms

See what a discount for paying a supplier early is worth once it is turned into a yearly rate.
FAQ

Common questions about purchase price variance

What is PPV and how is it calculated?
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.