---
title: "Procurement Budget Variance Analysis: Formulas and Tracking"
description: "Procurement budget variance is actual spend minus budgeted spend. This guide shows the formulas, a worked price, volume and mix example, a spend vs budget…"
canonical: "https://www.auravms.com/blogs/procurement-budget-variance-analysis-spend-tracking-guide"
author: "Dhrumil Barot"
author_bio: "Dhrumil is a procurement veteran. Dhrumil built AuraVMS to take the manual chasing out of RFQs, supplier quotes and purchase orders."
published: 2026-06-01
updated: 2026-10-29
image: "https://www.auravms.com/og.png"
---

# Procurement Budget Variance Analysis: Formulas and Tracking

*By [Dhrumil Barot](https://www.auravms.com/about#founder) | Published June 1, 2026 | Updated October 29, 2026*

*How to calculate budget vs actual variance, split it into price, volume and mix, and catch overruns before month-end close.*

> **TL;DR:** Procurement budget variance is actual spend minus budgeted spend. This guide shows the formulas, a worked price, volume and mix example, a spend vs budget tracking template with thresholds and owners, and how to estimate commodity and tariff impacts.

Procurement budget variance is the gap between what you planned to spend and what you actually spent: **Variance = Actual spend − Budgeted spend**, and **Variance % = (Actual − Budget) ÷ Budget × 100**. On a cost budget, a positive number means you are over budget (unfavorable) and a negative number means you are under (favorable). Variance analysis is the next step: splitting that number into price, volume, mix and timing so each part goes to the person who can fix it, and doing it early enough to act.

This guide covers the formulas, a worked price, volume and mix example, a spend vs budget tracking template with thresholds and owners, and a quick way to put a dollar figure on commodity and tariff swings before they reach your invoices.

## Budget Variance Formulas for Procurement

You can run variance analysis at three levels: a single PO or invoice against its quote, a category (packaging, MRO, freight) against its budget line, and total spend against the annual plan. The same formulas work at each level.

| Measure | Formula | What it tells you |
| --- | --- | --- |
| Budget variance ($) | Actual spend − Budgeted spend | How far over or under you are |
| Budget variance (%) | (Actual − Budget) ÷ Budget × 100 | Size of the gap relative to the line, so you can compare categories |
| Price variance (PPV) | (Actual price − Budget price) × Actual quantity | Cost of paying a different unit price |
| Quantity variance | (Actual quantity − Budget quantity) × Budget price | Cost of buying more or fewer units |
| Volume variance | (Total actual qty − Total budget qty) × Budget average price | The part of quantity variance caused by total demand |
| Mix variance | Sum over items of (Actual qty − Actual total qty × Budget mix %) × Budget price | The part of quantity variance caused by buying a different blend of items |
| Quote-to-invoice variance | (Invoiced price − Awarded quote price) × Invoiced quantity | Price creep after the supplier was chosen |

Price variance plus quantity variance equals total variance, and volume plus mix equals quantity variance. If the pieces don't add back to the total, a formula or a data pull is wrong. This only works when the budget was built as quantity × price for each item. If a budget line is just a dollar figure, all you can calculate is the total, which is a good reason to build at least your largest categories with quantities.

On sign convention: these formulas show overspend as a positive number. Many finance teams report Budget − Actual instead, so overspend shows as negative. Either is fine. Pick one, state it on the report, and don't switch.

## Worked Example: Price, Volume and Mix Variance

Illustrative example: a manufacturer budgets $24,000 for corrugated boxes for one quarter, across two sizes.

| Item | Budget qty | Budget price | Budget spend | Actual qty | Actual price | Actual spend |
| --- | --- | --- | --- | --- | --- | --- |
| Small box | 12,000 | $1.00 | $12,000 | 12,600 | $1.05 | $13,230 |
| Large box | 4,000 | $3.00 | $12,000 | 5,400 | $3.10 | $16,740 |
| Total | 16,000 | $1.50 average | $24,000 | 18,000 |  | $29,970 |

Total variance = $29,970 − $24,000 = **$5,970 over budget (24.9%)**. Now split it:

1. **Price variance.** Small: ($1.05 − $1.00) × 12,600 = $630. Large: ($3.10 − $3.00) × 5,400 = $540. Total **$1,170**.
2. **Volume variance.** (18,000 − 16,000) × $1.50 budget average price = **$3,000**.
3. **Mix variance.** The budget mix was 75% small and 25% large. At 18,000 units that would be 13,500 small and 4,500 large. Small: (12,600 − 13,500) × $1.00 = −$900. Large: (5,400 − 4,500) × $3.00 = $2,700. Total **$1,800**.
4. **Check.** $1,170 + $3,000 + $1,800 = $5,970. It ties to the total.

What it means: only $1,170, about a fifth of the overrun, is a pricing issue procurement can take to the supplier. The $3,000 volume piece is demand. The plant shipped more product, and the budget should probably be flexed for it. The $1,800 mix piece is a shift toward the large box, which is a question for whoever changed the packing spec or the product mix. Reporting "packaging is 25% over" sends everyone after the supplier. Reporting the split sends each part to the person who can act on it.

## What Causes Procurement Budget Variance, and the Fix for Each

| Cause | How it shows up | Controllable by procurement? | Typical corrective action |
| --- | --- | --- | --- |
| Supplier price increase | Price variance on renewals or new POs | Partly | Re-quote with three or more suppliers; tie future changes to a named index in the contract |
| Commodity or currency swing | Price variance across a whole category at once | No, but it can be indexed or fixed for a period | Index-linked pricing, fixed-price periods, reforecast the rest of the year |
| Tariff or duty change | Landed cost jumps on imported items | No | Reprice remaining volume, check other countries of origin, update the budget |
| Demand forecast error | Volume variance | No, operations owns demand | Flex the budget to actual output; share forecasts with key suppliers monthly |
| Spec or scope change | Mix variance or new line items | Shared with engineering | Require a cost impact estimate before a spec change is approved |
| Rush or emergency buying | Premium prices and expedite fees | Yes | Safety stock for critical items; pre-agreed rush rates |
| Off-contract (maverick) spend | Purchases from non-preferred suppliers at higher prices | Yes | PO required above a set dollar limit; a short approved supplier list |
| Change orders after award | Quote-to-invoice variance | Yes | Fixed-price quotes with written change terms; approval for any price deviation |
| Timing | Spend lands in a different month than planned | Usually not a real cost | Phase the budget by month; don't chase timing-only variances |

Add three tags to every material variance: **favorable or unfavorable**, **controllable or uncontrollable**, and **one-time or permanent**. A favorable price variance from moving to a cheaper, lower-grade supplier can come back later as rework or returns, so check total cost before counting it as a win. Judge procurement mainly on controllable variance, but still report the uncontrollable part so finance can reforecast. A permanent change, such as a sustained raw material increase, means the budget needs restating, not a fresh explanation every month.

## How to Track Budget Deviations and Act Early

Most overruns surface at month-end close because teams compare the budget only to invoiced spend. By then the POs went out weeks ago. Track committed spend as well as invoiced spend, and keep a year-end forecast for each category:

- **Remaining budget = Annual budget − Invoiced to date − Open PO commitments**
- **Forecast at year-end = Invoiced to date + Open POs + (Remaining expected quantity × Current price)**

If the forecast at year-end is above the annual budget, you have an overrun today, even if year-to-date actuals look fine.

### Spend vs Budget Tracking Template

Set up one row per category, or per major supplier, with these columns:

| Column | What goes in it |
| --- | --- |
| Category and owner | For example: Packaging, owned by the plant buyer |
| Annual budget | The approved figure, plus budget quantity and price where you have them |
| YTD budget (phased) | Budget for the months to date, phased by expected usage rather than divided by 12 |
| Invoiced YTD | From AP or the ERP |
| Open commitments | Approved POs not yet invoiced |
| Forecast at year-end | Formula above |
| Variance $ and % | Forecast vs annual budget, and YTD actual vs YTD budget |
| Root cause code | Price, volume, mix, spec, rush, off-contract, change order, or timing |
| Action, owner, due date | One line, one name |

Illustrative example row: Packaging has an annual budget of $96,000 and a six-month phased budget of $46,000. Invoiced to date is $44,500, so year-to-date looks $1,500 under. But open POs are $9,000 and remaining demand at current prices is $53,000, giving a year-end forecast of $106,500. That is $10,500 (10.9%) over. Code: volume and mix. Action: flex the budget for higher output and review the large-box spec, owned by the plant buyer, due the 15th. Without the commitments and forecast columns, this line would look healthy until autumn.

### Thresholds: When to Investigate

| Variance on a category | Action | Owner | Deadline |
| --- | --- | --- | --- |
| Under 5% and under $5,000 | Note it in the monthly report | Category owner | Monthly review |
| 5% to 10%, or $5,000 to $25,000 | Root cause code and one line of commentary | Category owner | 5 business days after close |
| Over 10%, or over $25,000 | Price, volume and mix split, corrective action plan, reforecast | Procurement lead with the budget holder | Before the monthly review |
| Forecast to exceed the annual budget | Escalate before the next PO in that category is approved | Budget holder and finance | Immediately |

These thresholds are starting points. Tighten them for high-spend categories and loosen them for small discretionary ones.

### The Monthly Cycle, With Owners

1. **Days 1 to 3 after month end: pull actuals and commitments.** Finance or AP closes invoices, and procurement exports open POs. Fix miscoded transactions now, because many "unexplained" variances turn out to be coding errors.
2. **Days 3 to 5: calculate and flag.** The procurement analyst, or the procurement manager in a small team, updates the tracker and marks every line over threshold.
3. **Days 5 to 8: find the root cause.** The category owner talks to the budget holder and the supplier, splits the variance into price, volume and mix, and assigns a code.
4. **Days 8 to 10: act and reforecast.** Agree corrective actions with owners and dates, update the year-end forecast, and restate the budget for permanent changes.
5. **Monthly review: report.** One page for leadership: total variance and trend, the three largest drivers, actions taken, and decisions needed.
6. **Weekly, for volatile categories.** Check new POs and quotes against budget price for freight, metals, energy and anything priced off an index.

## Quantifying Commodity Price Swings and Tariff Changes

When a commodity index or a tariff moves, estimate the budget impact before suppliers send new price lists:

- **Expected impact per unit = Current unit price × Commodity share of cost × Index change %**
- **Budget impact = Impact per unit × Remaining volume for the year**

Illustrative example: a fabricated bracket costs $40, and steel makes up about half of the supplier's cost, or $20. The steel index named in the contract is up 12% since the price was set. Expected pass-through is $20 × 12% = $2.40 per unit. With 25,000 units still to buy this year, the exposure is $60,000. That gives you a number to reforecast with and a way to test the supplier's request: if they ask for $4.00 a unit, that is more than the index explains. Get the commodity share from a cost breakdown in the quote, or estimate it from a should-cost model.

Tariffs work the same way on landed cost: change in tariff rate × customs value per unit × remaining imported units. Illustrative example: a 10-point tariff increase on a part with a $15 customs value adds $1.50 per unit, or $60,000 across 40,000 units.

For software, a spreadsheet linked to the index you use is enough for most small teams. ERP planning modules and spend analytics tools can model it across many items at once. Re-quoting the affected items through an RFQ shows the actual market price rather than an estimate. AuraVMS lists price forecasting on its Enterprise plan.

## Key Metrics for Spend vs Budget Tracking

| Metric | Formula | Use it to |
| --- | --- | --- |
| Budget variance % | (Actual − Budget) ÷ Budget × 100 | Rank categories by how far off they are |
| Purchase price variance | (Actual price − Standard price) × Actual quantity | Track pricing by supplier and category |
| Quote-to-invoice variance | (Invoiced price − Quoted price) × Invoiced quantity | Catch price creep after award |
| Forecast accuracy | 1 − (absolute value of Actual − Forecast) ÷ Actual | See whether your reforecasts can be trusted |
| Spend under PO or contract | Spend on approved POs or contracts ÷ Total spend | Measure off-contract buying |
| Variance by cause | Variance per root cause code ÷ Total variance | Find which lever matters most |
| Days to detection | Date variance flagged − Date PO placed or price changed | See whether you catch issues early or only at close |

Quote-to-invoice variance needs the awarded quote stored somewhere you can match against invoices. If you collect quotes in AuraVMS, every supplier's price sits in one side-by-side comparison, and the Medium Team plan exports complete RFQ data to Excel, where you can line it up against invoice data from your accounting system.

## Tools for Variance Analysis, and What to Ask Vendors

- **Spreadsheets.** Fine for a few dozen categories. Lock the formulas, keep one owner, and save a copy at each close so reported numbers don't change afterwards.
- **ERP budget vs actual reports.** The source of record for invoiced and committed spend, but often rigid when you want root cause codes or a price, volume and mix split.
- **Spend analytics and BI tools.** Classify spend across systems and chart trends. They look backward and are only as good as the data fed in.
- **RFQ software.** Sets the price baseline before you buy. AuraVMS collects quotes in one format with side-by-side comparison, so the awarded price is on record. It does not replace your budgeting or accounting system.
- **Planning and performance management tools.** Driver-based budgets, reforecast versions and scenarios. Usually worth it only for larger teams with many budget holders.

### Questions to Ask a Variance Analysis or Planning Software Vendor

- Which systems does it pull actuals and open POs from, and how often does the data refresh?
- Does it show committed spend against budget, or only invoiced spend?
- Can it split variance into price, volume and mix out of the box, or do we have to build that?
- Can we add our own root cause codes and comments on each variance line?
- How are reforecasts versioned, and can we compare one version with another?
- What does implementation involve, who does the work, and how long does it take for a team our size?
- What support is included: hours, response times, a named contact, and training for new users?
- Can we export all our data, in what format, and what happens to it if we cancel?
- Who can view and edit each budget line, and is there an audit trail of changes?

## Example: Finding Quote-to-Invoice Price Creep

Illustrative scenario: a manufacturer has been over its procurement budget for a year and can't say why. It lines up awarded quotes against invoices for its largest categories. In machined parts, the awarded quotes for the year's volume total $180,000 but invoices total $207,000, a $27,000 (15%) quote-to-invoice variance. Of that, $19,000 came through change orders and spec adjustments, and $8,000 was price increases with no paperwork at all. The supplier had quoted low to win the work and recovered margin afterwards.

The fixes are procedural. Ask for fixed-price quotes with written change terms. Keep at least two other suppliers quoting on each re-bid so the incumbent knows it has competition (anonymous bidding in an RFQ tool like AuraVMS helps here). And put a change order rule in every PO. A clause you can adapt with your legal team:

*"Prices on this order are fixed for 12 months from the PO date. Any price change, including changes tied to specification, material or quantity, requires a written change request showing the cost impact and the buyer's written approval before work proceeds. Invoice amounts above the PO price without an approved change request will be paid at the PO price."*

## Common Mistakes and How to Fix Them

- **Comparing budget to invoices only.** Fix: add open PO commitments and a year-end forecast column.
- **Budgets with dollars but no quantities.** Fix: build your top categories as quantity × price so variance can be split.
- **Dividing the annual budget by 12.** Fix: phase it by the production plan or past usage. Otherwise seasonal categories look over or under every month for no reason.
- **Treating every variance as a supplier problem.** Fix: separate price from volume and mix before you call anyone.
- **Ignoring favorable variances.** Fix: check whether it is a real saving, a delayed purchase, or a lower spec that will cost more later.
- **Re-explaining the same permanent variance every month.** Fix: restate the budget or forecast once the change is confirmed.
- **No baseline price on record.** Fix: keep the awarded quote for every significant purchase so quote-to-invoice variance can be measured.

## Frequently Asked Questions

### What is a good target for procurement budget variance?

There is no universal standard. A common working tolerance is plus or minus 5% for controllable categories with stable demand, and wider for volatile ones such as freight or commodities. Measure your actual variance for two or three months, then set targets by category. Also check categories, not just the total: a small overall variance can hide large ones that cancel each other out.

### What is the difference between budget variance and purchase price variance?

Budget variance is actual spend minus budgeted spend, so it includes price, quantity, mix and timing. Purchase price variance isolates price: (actual price − standard price) × actual quantity. A category can be on budget with a bad PPV if volume fell, or over budget with zero PPV if volume rose.

### How often should variance analysis be done?

Monthly for every category, right after close. Weekly checks of new POs for volatile or high-value categories. A deeper quarterly review to reforecast the year and feed next year's budget.

### Who should own variance analysis?

Procurement owns price analysis and supplier actions. Finance owns the budget and the close data. Budget holders own volume and spec decisions. In a small company the procurement manager usually runs the tracker and the monthly review with one finance contact. Whatever the setup, each budget line needs one named owner.

### What should I do when I can't explain a variance?

Check the data first: miscoded GL accounts, invoices posted to the wrong period, missing accruals for goods received but not invoiced, and duplicate invoices. If the data is clean, compare PO price to invoice price line by line for the largest suppliers. If it still won't resolve, record what you checked, label it unexplained, and set a date to revisit.

### How do I present variance findings to leadership?

One page: total variance in dollars and percent, the trend against last period, the year-end forecast, the three largest drivers with their price, volume and mix split, actions with owners, and any decision you need from them. Put the detail in an appendix.

### How does quote collection software help with variance control?

It fixes the price baseline. When suppliers quote in the same format and you compare them side by side, the awarded price is clear and on record, so you can measure quote-to-invoice variance later. Tools like AuraVMS handle the quoting side. You still need your ERP or a spreadsheet for budgets and invoices.

## Conclusion

Budget variance analysis comes down to a few habits: build budgets as quantity × price, track commitments and a year-end forecast alongside invoices, split every material variance into price, volume and mix, and hand each piece to the person who can act on it. Start with your five largest categories and one tracker, and add the rest once the monthly cycle runs on time.

Ready to reduce procurement budget variance? AuraVMS helps you collect accurate supplier quotes, compare pricing side-by-side, and establish reliable baselines that prevent variance before it happens. Start your free trial at auravms.com.

## About the author

Written by [Dhrumil Barot](https://www.auravms.com/about#founder). Dhrumil is a procurement veteran. Dhrumil built AuraVMS to take the manual chasing out of RFQs, supplier quotes and purchase orders.

[LinkedIn](https://www.linkedin.com/in/bdhrumil) | [X](https://x.com/fyidhrumil)

## Continue this topic

- [Request for quotation definition](https://www.auravms.com/terms/request-for-quotation)
- [Manage an RFQ beyond the document](https://www.auravms.com/)
- [Compare the responses](https://www.auravms.com/side-by-side-easy-vendor-quote-comparison)

Source: https://www.auravms.com/blogs/procurement-budget-variance-analysis-spend-tracking-guide