Material Price Variance Formula vs Quantity Variance

The material price variance formula is (actual price minus standard price) times actual quantity. That is the accounting definition, and AccountingTools states it exactly that way. Its partner is the materials quantity variance: (actual quantity used minus standard quantity) times standard price, as taught in the Penn State managerial accounting text. Together they add up to the total direct materials cost variance, which is just (actual quantity times actual price) minus (standard quantity times standard price).

In contractor terms: “standard price” is the unit price you carried in your estimate. “Standard quantity” is your takeoff. Price variance is what the counter did to you. Quantity variance is what the field did to you. They are two different problems with two different fixes, and the reason “we lost money on material” never gets solved in most shops is that nobody splits the number.

This post walks the formulas, runs them on real-shaped line items, and shows how to tell a price problem from a quantity problem from your own invoices.

The two formulas, written for a takeoff instead of a factory

The textbook language assumes a manufacturer with a standard cost card. You have an estimate, which is the same thing wearing work boots.

The three calculations:

• Material price variance = (AP minus SP) times AQ. Positive is unfavorable, you paid more per unit than you carried.
• Material quantity variance = (AQ minus SQ) times SP. Positive is unfavorable, you used more than you took off.
• Total material cost variance = (AQ times AP) minus (SQ times SP).

Notice the asymmetry, because it trips people up. Price variance is multiplied by the actual quantity. Quantity variance is multiplied by the standard price. That is a convention, not an accident: it is what makes the two pieces sum exactly to the total, with no leftover. If you multiply both by actual figures you will double-count the corner where a high price meets a high quantity, and your two numbers will not reconcile to the total. When your variances do not tie out, this is almost always why.

A worked example on 12/2 Romex

The numbers below are illustrative. They are not pulled from any supplier’s price file. The point is the shape of the arithmetic.

Say you bid a residential rough-in carrying 40 rolls of 12/2 Romex, 250 foot rolls, at $92.00 each. That is $3,680 in the estimate. The job closes and you have bought 44 rolls at an average of $99.50.

$330 plus $368 is $698. The pieces tie.

Now look at what you learned that “we went $698 over on wire” did not tell you. Roughly half the damage is a buying problem: you are paying $7.50 a roll more than you carried, on every roll, and you will keep paying it on the next job unless something changes at the supply house. The other half is a field or takeoff problem: four extra rolls. Those go to different people. The $330 goes to whoever owns the supplier relationship. The $368 goes to the foreman and, if it repeats across jobs, back to the estimator.

The case where the two hide each other

Same job, the fittings line. You carried 100 EMT set screw connectors at $0.62 each, $62.00 total. You actually bought 90 at $0.71.

• Total variance: (90 x $0.71) minus (100 x $0.62) = $1.90 unfavorable.
• Price variance: ($0.71 minus $0.62) x 90 = $8.10 unfavorable.
• Quantity variance: (90 minus 100) x $0.62 = $6.20 favorable.

The line looks like it landed within two dollars of budget. It did not. You are buying that connector 15% over the number you estimated, and the only reason it does not show is that the takeoff was fat by ten pieces. Next job, the takeoff is tighter and the same price problem shows up as a real loss. This is exactly the case that makes variance splitting worth the ten minutes: a line that reconciles at the total level can be two errors cancelling.

What actually causes an unfavorable price variance

AccountingTools names the usual suspects for an unfavorable price variance: rush delivery charges, commodity price swings, supplier pricing power, and buying a volume different from what the estimate assumed. All four are recognizable from the counter. On a contractor’s invoices they show up in specific, checkable forms.

The market genuinely moved. This is the one that is not anybody’s fault, and it is real right now. BLS’s producer price index for copper and brass mill shapes sat at 747.384 in January 2026 and 803.275 in June 2026 (preliminary), roughly 7.5% in five months. If your copper line ran 7% over and you bid it in January, that is the market, not your supplier. Check the index before you make a phone call you cannot back up.

You fell off contract price. A substituted part number, a branch that does not have your agreement loaded, a will-call ticket written as a walk-in, an apprentice buying on the wrong account. Any of those reprices a line without anyone deciding to. That mechanism is the whole subject of contract price versus counter price, and it is the most common single cause of a price variance that nobody can explain.

The price drifted month over month with no notice. Slower and harder to see than a single bad ticket, because no invoice looks wrong on its own. This is material price creep, and it only appears when you line up your own unit prices for the same SKU across a year.

The invoice did not match the quote. You bid off a quoted number and were billed something else, which is a quote versus invoice mismatch rather than a pricing problem at all. If you bid off a job quote, this is the first thing to check, because it is the easiest to get credited.

You bought a different quantity than the agreement assumed. Contract and special pricing frequently attaches to purchase thresholds. Buying in twos when the rate was written at tens produces a legitimate, contractual price variance that no amount of arguing will reverse.

What causes an unfavorable quantity variance

Fewer categories, but they are harder to fix.

• Waste and breakage. Normal, and your estimate should carry a factor for it. If actual waste beats the carried factor consistently, the factor is wrong, not the crew.
• Rework. Material consumed twice for one installed result.
• Theft and walk-off. Real, unpleasant, and usually visible as small consumables rather than gear.
• Takeoff error. A missed run, a wrong count, a scale misread.
• Scope that grew without a change order. This one is not a quantity variance at all in the honest sense. It is unbilled scope wearing a quantity variance costume, and the fix is a change order, not a conversation with the foreman.
• Quantities charged but never delivered. A short shipment billed in full reads as a quantity overrun in your job cost, because the material was paid for and not installed. This one belongs in the price and billing bucket, not the field bucket, and it is what receiving documents exist to catch.

That last point is why the split only works if your incoming paperwork is checked. Three-way matching cross-checks the invoice against the purchase order and the delivery receipt, and that is what keeps a billing error from being misfiled forever as a field problem. The contractor version of it is in three-way matching for contractors.

You cannot run this without committed cost

The variance math assumes you know what you bought. On a job with real purchase orders you do. Purchase orders let a contractor track committed cost and remaining committed cost at the job, cost code, or cost class level, and without them there is a real risk of thinking a job is more profitable than it is, simply because the invoices have not landed yet.

That is the trap. If you calculate variance in week three off posted costs only, every job looks fine. Material bought on Monday invoices in ten days and posts in three weeks. Run variance monthly against committed cost, not against posted cost, or you are grading a test that is half-finished.

For shops where a lot of material walks out the door on counter tickets with no PO behind it, this gets harder, and it needs its own procedure. That is covered in job costing material when most purchases are counter runs.

A monthly variance routine that takes under an hour

Do this per job, on your top ten material lines by dollar value. Not on every SKU. The tail is not worth the time.

1. Pull the estimate line. Standard quantity and standard unit price, straight off the takeoff.
2. Pull actual quantity and actual dollars for that item from the job’s material transactions, including anything committed but not yet invoiced.
3. Compute actual price as actual dollars divided by actual quantity. This is a weighted average across every purchase, which is what you want.
4. Run the three numbers. Total, price, quantity. Confirm price plus quantity equals total. If it does not, you multiplied one of them by the wrong side.
5. Sort by price variance dollars, descending. The top three lines are your supplier conversation.
6. Sort by quantity variance dollars, descending. The top three lines are your field or takeoff conversation.
7. For each top price variance, pull your own last three invoices for that SKU and compare unit prices, branch, and account. That is where you find out whether it was the market, the contract, or the ticket.

Step 7 is the one that turns a number into a credit request. A variance report says the number is wrong. An invoice line next to your own prior price for the same part number says exactly how, and that is a document rather than an argument. If the answer is that you were billed off contract, there is a ready-to-send credit request email for that case.

What to do with the answer

The two variances point at completely different actions, and mixing them wastes everybody’s time.

The short version

• Price variance is (AP minus SP) times actual quantity. Quantity variance is (AQ minus SQ) times standard price. They sum to the total.
• Multiply price variance by actual quantity and quantity variance by standard price, or your pieces will not tie to the total.
• A line that lands on budget can still be two large errors cancelling. Split every material line that matters, not just the ones that look bad.
• Price variance is a buying problem: contract fall-through, price creep, quote mismatch, or a real market move. Check which before you call your rep.
• Quantity variance is a field or takeoff problem, unless the quantity was billed and never delivered, in which case it is a billing problem.
• Run it against committed cost, monthly, on your top ten lines by dollar value.

Sources

• Materials Price Variance, AccountingTools
• Direct Materials Variances, Penn State ACCTG 211
• Job Costs and Purchase Orders, Foundation Software
• PPI: Copper and Brass Mill Shapes (WPU102502), U.S. Bureau of Labor Statistics
• 3-Way Invoice Matching, Stampli