Direct Material Price Variance Calculator (with quantity variance)

Understanding the direct material price variance calculator — concept and principle

This calculator compares what you actually paid for materials with the standard price you planned, and also checks whether production used more or less material than the standard allows. It reports the price variance, the quantity (usage) variance and the total variance on the material used, each labelled favorable or unfavorable. Cost accountants and production managers use it in monthly standard-cost reports.

Paid more than standard — with the default inputs: $1,500.00.

How it is calculated

Price variance = (actual price − standard price) × actual quantity purchased = (AP − SP) × AQ
Quantity variance = (actual quantity used − standard quantity allowed) × standard price = (AQused − SQ) × SP
Total variance on material used = AQused × AP − SQ × SP

Positive values are unfavorable (cost more than planned); negative values are favorable. The calculator shows the size and the label.

The principle

Standard costing separates two reasons why material cost differs from plan. The price variance isolates buying: paying more or less per unit. The quantity variance isolates usage: consuming more or less material than the actual output should need, valued at the standard price so that price effects do not leak in. Calculating the price variance on the quantity purchased flags buying problems at the moment of purchase. When purchased and used quantities are equal, price and quantity variances add up exactly to the total.

Worked example

Defaults: 5,000 units bought at 4.30 (standard 4.00); 4,800 used; 4,600 allowed for the actual output.

Price difference = 4.30 − 4.00 = $0.30 per unit, 7.5% above standard.
Price variance = 0.30 × 5,000 = $1,500.00, Unfavorable — paid more.
Quantity variance = (4,800 − 4,600) × 4.00 = $800.00, Unfavorable — used more.
Total on material used = 4,800 × 4.30 − 4,600 × 4.00 = 20,640 − 18,400 = $2,240.00, Unfavorable overall.

Because 5,000 were bought but 4,800 used, 1,500 + 800 is not 2,240; on the 4,800 used, the price part is 1,440, and 1,440 + 800 = 2,240.

Each point is the calculator re-run with only “Actual price paid per unit” changed; the gold point is the default example. Change the inputs above and this chart follows your numbers.

Actual price paid per unit	Direct material price variance
1.07	$14,625.00
2.15	$9,250.00
3.23	$3,875.00
4.3	$1,500.00
5.38	$6,875.00
6.45	$12,250.00
8.6	$23,000.00

How to read the result

An unfavorable price variance points to purchasing, supplier prices or rush orders; an unfavorable quantity variance points to waste, scrap or poor-quality material. The two can be linked: cheap material may cause more waste. Investigate large or repeated variances rather than every small one.

Common mistakes

Using quantity used for the price variance when the policy is quantity purchased.
Valuing the quantity variance at the actual price.
Using the standard quantity for budgeted output instead of actual output.
Reading "favorable" as always good.

Keep in mind: Variances show where to look, not who is to blame. Standards must be realistic and kept up to date.

Frequently asked questions

Is a favorable price variance always good?

No. Buying cheaper, lower-quality material can create a larger unfavorable quantity variance.

Who is usually responsible for the price variance?

Purchasing, because it controls suppliers, order sizes and timing.

Why value the quantity variance at standard price?

So that it measures usage only, without mixing in price changes.

Sources: OpenStax, Principles of Accounting, Volume 2: Managerial Accounting, section 8.2 "Compute and Evaluate Materials Variances"

Checked 9 Nov 2026. Materials price, quantity and total variance formulas and the favorable/unfavorable convention: OpenStax, “Principles of Accounting, Volume 2: Managerial Accounting”, section 8.2 “Compute and Evaluate Materials Variances”.

Your numbers