Purchase Price Variance Calculator
Work out purchase price variance instantly with clear inputs, formula shown and shareable results.
About Purchase Price Variance Calculator
Purchase price variance values the difference between standard and actual price at the quantity actually bought, and it is the primary measure of purchasing performance. Separating the volume variance keeps demand changes out of the purchasing measure.
Formulas
Purchase price variance
PPV = (Standard price - Actual price) x Quantity purchased
Volume variance
Volume variance = (Budgeted quantity - Actual quantity) x Standard price
Worked example
With the default values below, Purchase Price Variance Calculator returns Purchase price variance of -$576,000.00. Change any input above and every figure here is recalculated in your browser.
Inputs used
- Standard or contracted price
- 680
- Actual price paid
- 712
- Quantity purchased
- 18,000
- Budgeted quantity
- 16,000
Results
- Purchase price variance
- -$576,000.00
- Variance per unit
- -$32.00
- Price variance as % of standard
- 4.706%
- Volume variance at standard price
- -$1,360,000.00
Step by step
- 1Values used
- 2Purchase price variance
- 3Volume variance
- 4Purchase price variance= -576,000.00
- 5Variance per unit= -32.00
- 6Price variance as % of standard= 4.706
- 7Volume variance at standard price= -1,360,000.00
Assumptions and limits
- The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
- In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
- Figures are rounded for display to 3 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.
Frequently Asked Questions
Is a positive PPV always good?
Not if it came from buying lower-grade material or a larger quantity than needed. Read it alongside quality rejection and inventory data.
Who owns the variance?
Purchasing owns the price element; the requisitioning function owns the volume element. Splitting them prevents unproductive argument.
Related Calculators
- Cost Per Purchase Order Calculator
- Index Linked Price Adjustment Calculator
- Price Benchmarking Index Calculator
- Price Variation Clause Calculator
- Purchase Order Consolidation Saving Calculator
- Advance Payment Recovery Calculator
- Approval Cycle Time Calculator
- Asset Disposal Value Calculator
- Backhaul Revenue Calculator
- Bid Comparison Matrix Calculator
You might also need
- Price Benchmarking Index CalculatorAlso in Procurement, Contracts & Vendor Management
- Price Variation Clause CalculatorAlso in Procurement, Contracts & Vendor Management
- Cost Per Purchase Order CalculatorAlso in Procurement, Contracts & Vendor Management
- Index Linked Price Adjustment CalculatorAlso in Procurement, Contracts & Vendor Management
- Purchase Order Consolidation Saving CalculatorAlso in Procurement, Contracts & Vendor Management
- Backhaul Revenue CalculatorAlso in Procurement, Contracts & Vendor Management
