Use direct materials price variance calculator to find out whether your business paid more or less than the standard price for raw materials. Enter the actual price, standard price and actual quantity to calculate the variance instantly. The tool identifies favorable and unfavorable results, displays the complete calculation, and provides an illustrative journal entry. You can also choose whether the variance is recognized when materials are purchased or consumed.
Direct Materials Price Variance Calculator
Find your direct materials price variance in seconds with the formula (Actual Price โ Standard Price) ร Actual Quantity. Instantly see whether it is favourable or unfavourable, follow every calculation step, and get the matching journal entry.
Your result
What this result means
Step-by-step calculation
Journal entry for this varianceIllustrative standard-costing entry only. Account names and recognition procedures may vary by accounting policy and system.
Written & Reviewed by Jhanzayb, Qualified Chartered Accountant (ACA, ICAP)
Last Updated: November, 2026
How This Direct Materials Price Variance Calculator Works
The calculator applies the standard costing formula and shows its working, so you can check the answer instead of just trusting it. Here is what each part does.
What You Enter
| Input | What It Does |
|---|---|
| Quick-start examples | Two ready-made cards, “Paid more than planned” and “Paid less than planned”, fill the fields for you. Load one, then press Calculate Variance to see a full result. |
| When the variance is recognised | Choose “At purchase” to use the quantity you bought, or “At consumption” to use the quantity you used in production. This only changes what the quantity field means, and the label updates to match. |
| Sign convention | Choose Actual โ Standard (positive means unfavourable) or Standard โ Actual (positive means favourable). The size of the variance never changes, only the sign. |
| Currency, unit and rounding | Display options only. Pick a currency symbol, a unit such as kg or litres (or type your own) and 0 to 4 decimal places. The unit is a label, not a converter, so use the same unit for the price and the quantity. |
| Actual price (AP) and standard price (SP) | The price per unit, from 0 up to 1,000,000,000, with up to 8 decimal places. |
| Actual quantity (AQ) | The units purchased or used, depending on the basis you chose. It must be above zero and up to 1,000,000,000,000, with up to 8 decimal places. |
Commas are fine as thousands separators, such as 1,250.50 or 1,00,000. A value like 12,50 is rejected with a message instead of being guessed, because it could be read two ways.
What You Get After Pressing Calculate Variance
- The headline variance with a clear Favorable, Unfavorable or No variance label
- The signed result, the sign convention you chose and the formula applied, so a positive or negative number can never be misread
- The price difference per unit and the variance as a percentage of standard cost at actual quantity (SP ร AQ), which show whether the amount is big or small relative to the spend
- A bar comparison of the actual cost (AP ร AQ) and the standard cost at actual quantity (SP ร AQ), with the amounts
- A plain-English explanation of what the result means for profit
- A four-step calculation: actual cost, standard cost, the formula applied, and a cross-check using total costs
- The journal entry for your numbers, based on the basis you selected. It is a simplified illustration, because account names and recognition procedures vary between companies
- Copy, print and CSV download buttons if you need the result for homework, a report or a spreadsheet
How the Math Is Handled
- Results appear only when you press the button. If you change any input afterwards, the old result is hidden so you never read a number that no longer matches your inputs
- The arithmetic is exact. The calculator works with exact decimals instead of floating-point numbers, so a figure like 0.1 ร 3 is exactly 0.3. Amounts are rounded only for display, and the step-by-step working is shown at full precision
- Two methods must agree. The variance is worked out as (AP โ SP) ร AQ and again as actual cost minus standard cost. Both are shown
- Bad input is rejected, not guessed. Blank, negative, non-numeric, out-of-range or zero-quantity entries show a message beside the field and produce no result
- Small variances are not hidden. If rounding would show $0.00 for a real variance, the calculator tells you the exact amount and how to display it
- The journal entry always balances as displayed
What the Calculator Does Not Do
- It calculates the price variance only. The usage (quantity) variance needs the standard quantity allowed for your output
- It does not convert units or currencies. Convert your figures first
- It compares the actual price with one benchmark price. To compare an invoice with a purchase-order price instead of a standard price, enter the PO price in the standard price field
- It cannot know which basis your course, exam board or employer uses, so check that before relying on a result for assessed work or formal reporting
What Is Direct Materials Price Variance?
Direct materials price variance is the difference between what a business actually paid for direct materials and what it should have paid at the standard price, applied to the quantity involved. Direct materials are the raw materials that become part of the finished product, such as steel in a machine or flour in bread.
You will also see it called material price variance, direct material price variance or DMPV. In purchasing teams and ERP systems the closely related term is purchase price variance (PPV). Depending on the company, PPV compares the invoice price with the standard cost or with the purchase-order price, so the two measures are similar but not always identical.
The variance belongs to standard costing. A company sets a standard price for each material, records what it really pays, and investigates the gap. That approach is often called management by exception: you don’t chase every small difference, you look hard at the ones that matter.
Direct Materials Price Variance Formula
Direct Materials Price Variance = (Actual Price โ Standard Price) ร Actual Quantity
Short form: (AP โ SP) ร AQ
| Term | Meaning |
|---|---|
| AP | Actual price paid per unit of material |
| SP | Standard (budgeted) price per unit of material |
| AQ | Actual quantity, either purchased or used, depending on when the variance is recognised |
The formula can be written in two other ways that give the same answer:
- Total costs: Actual Cost (AP ร AQ) โ Standard Cost at the actual quantity (SP ร AQ)
- Per unit first: (AP โ SP) gives the price difference per unit, then multiply by AQ
Some textbooks reverse the subtraction and use (SP โ AP) ร AQ. The amount is identical, but the sign flips, so positive means favorable instead of unfavorable.
Direct Materials Price Variance Formula in Excel
Put AP in B2, SP in B3 and AQ in B4. Then:
- Variance:
=(B2-B3)*B4 - Label (for the Actual โ Standard convention):
=IF(B5>0,"Unfavourable",IF(B5<0,"Favourable","No variance")), where B5 holds the variance
How to Calculate Direct Materials Price Variance
- Find the actual price per unit (AP). Use the price on the supplier invoice, including any costs your standard includes, such as freight
- Find the standard price per unit (SP). This comes from your budget or standard cost card
- Decide which quantity to use (AQ). Use the quantity purchased if you recognize the variance at purchase, or the quantity used if you recognize it at consumption
- Subtract the standard price from the actual price. This is the price difference per unit.
- Multiply by the actual quantity. The answer is the direct materials price variance
- Label it. Under Actual โ Standard, a positive number is unfavorable and a negative number is favorable
Direct Materials Price Variance Example
You can load both of these into the direct materials price variance calculator with the example cards.
Example 1 – Unfavorable Variance
A manufacturer budgets steel at $10.00 per unit. It pays $12.00 per unit and buys 1,000 units.
| Step | Calculation | Result |
|---|---|---|
| Actual cost | $12.00 ร 1,000 | $12,000 |
| Standard cost at actual quantity | $10.00 ร 1,000 | $10,000 |
| Price variance | ($12.00 โ $10.00) ร 1,000 | $2,000 Unfavourable |
The company paid $2 more per unit than planned, so materials cost $2,000 more than the standard predicted. That is 20% above standard cost.
Example 2 – Favorable Variance
A bakery budgets flour at $10.00 per unit. It negotiates $9.50 per unit and buys 2,400 units.
| Step | Calculation | Result |
|---|---|---|
| Actual cost | $9.50 ร 2,400 | $22,800 |
| Standard cost at actual quantity | $10.00 ร 2,400 | $24,000 |
| Price variance | ($9.50 โ $10.00) ร 2,400 | $1,200 Favourable |
The bakery paid 50 cents less per unit than planned, which is 5% below standard cost.
Example 3 – Using Kilograms
A plastics manufacturer budgets resin at a standard price of $5.00 per kg. The supplier invoices $5.20 per kg and the company buys 10,000 kg.
| Step | Calculation | Result |
|---|---|---|
| Actual cost | $5.20 ร 10,000 kg | $52,000 |
| Standard cost at actual quantity | $5.00 ร 10,000 kg | $50,000 |
| Price variance | ($5.20 โ $5.00) ร 10,000 | $2,000 Unfavourable |
The business paid $0.20 more per kilogram than its standard, which adds up to an extra $2,000 over the whole purchase. That is 4% above standard cost.
To try it yourself, choose kg in the calculator’s unit menu and enter 5.20, 5.00 and 10,000.
Favorable Vs Unfavorable Material Price Variance
A favorable variance means you paid less than the standard price. An unfavorable variance, also called an adverse variance, means you paid more.
| Situation | (AP โ SP) ร AQ | Label | Effect On Profit |
|---|---|---|---|
| Paid more than standard | Positive | Unfavorable | Reduces profit |
| Paid less than standard | Negative | Favorable | Increases profit |
| Paid exactly standard | Zero | No variance | No effect |
Watch the Sign Convention
Not every textbook or calculator subtracts in the same direction, so a bare “+2,000” can mean different things.
| Convention | Positive Result Means | Negative Result Means |
|---|---|---|
| Actual โ Standard: (AP โ SP) ร AQ | Unfavorable | Favorable |
| Standard โ Actual: (SP โ AP) ร AQ | Favorable | Unfavorable |
Always check which one your course or employer uses, and always write the word Favorable or Unfavorable next to the number. The direct materials price variance calculator does this for you.
A favorable variance is not automatically good news, because cheaper material can bring hidden costs. The section on why a favorable variance may not always be good explains what to check.
Quantity Purchased Vs Quantity Used – Which Should You Use?
The formula never changes, but the quantity depends on when the price variance is recognised.
| Basis | Quantity to Use | Inventory Is Carried at |
|---|---|---|
| Recognized at purchase | Actual quantity purchased | Standard cost |
| Recognized at consumption | Actual quantity used in production | Actual cost until issued |
Recognizing the variance at purchase is the more common approach in standard costing. It isolates purchasing performance at the moment the price is paid, which is when the purchasing manager can still do something about it. Recognizing it at consumption keeps inventory at actual cost and only releases the variance as materials are used.
Why the Choice Matters (A Quick Example)
A company budgets $4.00 per unit and pays $4.20. It buys 5,000 units but uses only 4,200 this period.
| Basis | Calculation | Variance |
|---|---|---|
| At purchase (AQ = 5,000) | ($4.20 โ $4.00) ร 5,000 | $1,000 Unfavorable |
| At consumption (AQ = 4,200) | ($4.20 โ $4.00) ร 4,200 | $840 Unfavorable |
The $160 difference is the price variance on the 800 units still sitting in inventory. Under the consumption basis it stays on the balance sheet until those units are used.
Neither answer is wrong. They answer different questions. Pick the basis your course, textbook, exam board or employer uses, and don’t mix the two within one analysis.
Causes of Direct Materials Price Variance
(a) Common Causes of an Unfavorable Variance
- Supplier price increases or general inflation
- Currency movements on imported materials
- Rush or emergency orders at premium prices
- Losing a volume discount by buying in smaller lots
- Higher freight or delivery costs
- Buying a higher grade of material than the standard assumed
- A standard price that was set too low or has gone out of date
(b) Common Causes of a Favorable Variance
- Good negotiation or a switch to a cheaper supplier
- Volume or early-payment discounts
- Falling market prices
- Buying a lower grade of material (check the quality impact)
- A standard price that was set too high
Who Is Responsible?
The purchasing department usually owns the price variance because it negotiates prices, order sizes and delivery terms. Be fair about it, though. If the cause was a market-wide price rise, or production asked for an urgent order, the buyer may not have had much control.
What to Do About an Unfavorable Variance
Start with size, not the sign. The direct materials price variance calculator shows the variance as a percentage of standard cost because $2,000 on $10,000 of materials is a problem, while $2,000 on $2,000,000 is noise. Many companies set their own thresholds, such as a percentage or a fixed amount, to decide which variances deserve a closer look.
When a variance does need attention, ask:
- Did the supplier price change, or was the standard out of date?
- Was this a rush order or a smaller-than-usual lot?
- Did freight, tariffs or exchange rates move?
- Did we switch grade or supplier?
- Is the cause likely to repeat?
To reduce unfavorable variances, buyers typically renegotiate contracts, consolidate orders to earn discounts, line up alternative suppliers, plan purchases earlier to avoid rush orders, and review standards regularly so they reflect current market prices.
Direct Materials Price Variance Journal Entry
In a standard costing system, the variance gets its own account. Using Example 1 (AP $12, SP $10, 1,000 units, unfavorable):
Variance Recognized at Purchase
| Account | Debit | Credit |
|---|---|---|
| Raw Materials Inventory (at standard cost) | $10,000 | |
| Direct Materials Price Variance | $2,000 | |
| Accounts Payable (at actual cost) | $12,000 |
Variance Recognized at Consumption
| Account | Debit | Credit |
|---|---|---|
| Work in Process (at standard cost) | $10,000 | |
| Direct Materials Price Variance | $2,000 | |
| Raw Materials Inventory (at actual cost) | $12,000 |
For a favorable variance, the Direct Materials Price Variance account is credited instead of debited. At period end, a small variance is usually closed to cost of goods sold, while a material one may be split between inventory and cost of goods sold. Account names vary between companies and software.
Material Price Variance Vs Purchase Price Variance (PPV)
The two terms are closely related, and people often use them as if they meant the same thing. The difference lies in the benchmark.
- Material price variance compares the actual material price with the standard price
- Purchase price variance (PPV) compares the actual purchase or invoice price with a benchmark that depends on the company. Some businesses measure it against the standard cost, others against the purchase-order (PO) price or another expected price
- The benchmark and the cost components included can differ, so the two measures can produce different results
- A business should define whether freight, duties, discounts, rebates and other acquisition costs are included in the price being compared
A Simple Example
| Description | Amount |
|---|---|
| Standard material price | $10.00 |
| Purchase order price | $10.20 |
| Actual invoice price | $10.50 |
| Quantity purchased | 1,000 units |
| Comparison | Calculation | Result |
|---|---|---|
| Invoice vs standard (material price variance) | ($10.50 โ $10.00) ร 1,000 | $500 Unfavorable |
| Invoice vs purchase order (PPV against the PO) | ($10.50 โ $10.20) ร 1,000 | $300 Unfavorable |
| Purchase order vs standard | ($10.20 โ $10.00) ร 1,000 | $200 Unfavorable |
The two measures reconcile, the $500 against standard is made up of $200 from agreeing a PO price above standard and $300 from the supplier invoicing above the PO price.
The point is not that one measure is right and the other wrong. They answer different questions. Against the standard, you ask whether purchasing beat the budgeted price. Against the PO, you ask whether the supplier billed what was agreed.
You can run either comparison in the direct materials price variance calculator. For the PO version, enter the PO price in the standard price field. The label will still say “standard”, but the math is identical.
Direct Materials Price Variance Vs Quantity (Usage) Variance
Price variance asks, “Did we pay the right price?” Usage variance, also called quantity or efficiency variance, asks, “Did we use the right amount?”
| Measure | Formula | What It Tells You |
|---|---|---|
| Direct materials price variance | (AP โ SP) ร AQ | Purchasing: the price paid |
| Direct materials usage variance | (AQ โ SQ) ร SP | Production: how much material was used compared with what the output should have needed |
| Total direct materials cost variance | Price variance + usage variance | Overall materials cost performance |
Here SQ is the standard quantity allowed for the actual output produced.
Putting the Two Together
Take Example 1 again: AP $12, SP $10, AQ 1,000 units. Suppose the output achieved should only have needed 950 units (SQ).
- Price variance: ($12 โ $10) ร 1,000 = $2,000 Unfavorable
- Usage variance: (1,000 โ 950) ร $10 = $500 Unfavorable
- Total: $2,500 Unfavorable
Check: actual cost of $12,000 minus the standard cost allowed of $9,500 (950 ร $10) is also $2,500.
The two variances are often linked. Cheaper material can mean more scrap, which turns a favorable price variance into an unfavorable usage variance.
Can a Favorable Price Variance Occur Alongside an Unfavorable Usage Variance?
Yes, and it is one of the most useful things to understand about variance analysis. Take a company that buys a cheaper grade of material and uses more of it.
| Item | Amount |
|---|---|
| Actual price | $4.80 per kg |
| Standard price | $5.00 per kg |
| Actual quantity used | 1,000 kg |
| Standard quantity allowed | 950 kg |
For this example the quantity purchased equals the quantity used.
| Variance | Calculation | Result |
|---|---|---|
| Price variance | ($4.80 โ $5.00) ร 1,000 | $200 Favorable |
| Usage variance | (1,000 โ 950) ร $5.00 | $250 Unfavorable |
| Total material cost variance | $250 โ $200 | $50 Unfavorable |
Check: the actual cost is $4,800 (1,000 ร $4.80) and the standard cost allowed is $4,750 (950 ร $5.00), a difference of $50 unfavorable.
Buying cheaper material did not improve overall manufacturing cost. The saving on price was more than cancelled by the extra material used, which is why price variance should never be judged on its own.
How to Verify Your Direct Materials Price Variance Calculation
There are two equivalent ways to calculate the price variance. Doing both is the quickest way to catch a mistake.
| Method | Calculation |
|---|---|
| Price difference method | (AP โ SP) ร AQ |
| Total cost method | (AP ร AQ) โ (SP ร AQ) |
Both must give the same result before display rounding. With the earlier steel example (AP $12, SP $10, AQ 1,000):
- Price difference method: ($12 โ $10) ร 1,000 = $2,000
- Total cost method: $12,000 โ $10,000 = $2,000
The direct materials price variance calculator shows this cross-check in its step-by-step working, but it is just as useful when you are working by hand.
A Quick Checklist
- Are the actual price, standard price and quantity in the same unit?
- Are you using the same quantity basis (purchased or used) throughout?
- Is the sign convention clear, and have you written Favourable or Unfavourable next to the number?
- Do the two methods agree?
- Does the percentage of standard cost look sensible for the material?
Do Not Round Too Early
Rounding prices before multiplying can hide a real variance. If the actual price is $10.004, the standard is $10.00 and you buy one unit, the true variance is $0.004. Round the price to $10.00 first and you would wrongly conclude there is no variance at all. Carry full precision through the calculation and round only the final figure. The calculator does this, and warns you when rounding would display a real variance as zero.
Why a Favorable Material Price Variance May Not Always Be Good
A favorable variance means you paid less than the standard price. That sounds like good news, but it only tells you about price. It says nothing about what the cheaper price cost you elsewhere.
| Possible Hidden Cost | What to Check |
|---|---|
| Lower-grade raw materials | Does the specification match what the standard assumed? |
| Increased production wastage | Is the usage variance now unfavourable? |
| Higher rejection rates | Has the defect or scrap rate risen? |
| Additional rework | Are labour hours or machine time increasing? |
| Lower-quality substitutes bought to avoid emergency purchases | Is the substitute really equivalent in performance? |
| Excess inventory and storage costs | Was extra stock bought to win a bulk discount, and will it sell or be used? |
The earlier example with a $4.80 price against a $5.00 standard shows the effect, a $200 favorable price variance produced a $50 unfavorable total result once the extra material used was counted.
Treat a favorable variance as a prompt to ask questions, not as automatic proof of good purchasing. Read it together with the usage variance, quality data and inventory levels.
How Is the Standard Price of Direct Materials Determined?
The standard price is the price a company expects to pay for one unit of a material in the coming period. It is not an arbitrary number, and the variance is only as meaningful as the standard behind it. Standard prices are commonly based on:
- Supplier quotations for the period ahead
- Contractual purchase prices already agreed
- Expected market prices, especially for commodities
- Historical purchase costs, adjusted for current conditions
- Freight and other costs that the company’s standard-cost policy includes in the price
- Expected discounts and rebates
Standards are usually reviewed periodically. A standard that is out of date creates misleading variances and an old, low standard makes every purchase look unfavorable, while an old, high one flatters purchasing. When you use the direct materials price variance calculator, the standard price field is where this number goes.
Why Actual and Standard Material Prices Must Use the Same Unit
The variance formula only works when the actual price, the standard price and the quantity are all measured in the same unit, for the same material specification.
A price of $5.20 per kilogram cannot be compared directly with a standard of $5.00 per pound. A pound is smaller than a kilogram, so the standard in kilograms is about $11.02 per kg ($5.00 ร 2.20462). Comparing 5.20 with 5.00 would give a meaningless answer.
The same rule applies to quantity. If your prices are per kilogram, enter the quantity in kilograms. Ten tons is 10,000 kg.
| Conversion | Value |
|---|---|
| 1 kilogram | about 2.20462 pounds |
| 1 ton | 1,000 kilograms |
| 1 US gallon | about 3.78541 litres |
| 1 yard | 0.9144 metres |
The direct materials price variance calculator lets you choose kg, pounds, liters, meters and other units, but the choice is a display label only. It does not convert your figures. Convert first, then enter the numbers.
Common Mistakes When Calculating Material Price Variance
- Mixing quantity purchased and quantity used in the same calculation
- Misreading the sign. Check which subtraction your source uses and write the label
- Using the standard quantity allowed. That belongs in the usage variance. Price variance uses the actual quantity
- Forgetting what is in the price. If your standard includes freight or duties, the actual price should too
- Judging by the amount alone. Compare the variance with standard cost as a percentage
- Treating favorable as automatically good. Check quality and usage before drawing conclusions
- Comparing prices in different units, such as a price per kilogram against a standard per pound
- Rounding too early. Round prices or costs before multiplying and a small real variance can disappear. Round only the final figure
Key Takeaways
- The formula is (Actual Price โ Standard Price) ร Actual Quantity
- Under Actual โ Standard, positive is unfavorable and negative is favorable
- Use the quantity purchased if the variance is recognized at purchase, or the quantity used if it is recognized at consumption
- Price variance measures purchasing. Usage variance measures production. Together they give the total materials cost variance, and one can be favorable while the other is not
- Material price variance compares with the standard price. PPV can use the standard cost or the PO price, so the two can differ
- Verify every answer two ways: (AP โ SP) ร AQ and (AP ร AQ) โ (SP ร AQ)
- Use the same unit for the actual price, standard price and quantity
- A favorable variance is not always good. Check quality, usage and inventory
- The percentage of standard cost matters more than the raw amount
Frequently Asked Questions
What is direct materials price variance?
Direct materials price variance is the difference between the actual price paid for direct materials and the standard price, multiplied by the actual quantity. It shows whether purchasing came in above or below the budgeted price.
What is the formula for direct materials price variance?
Direct Materials Price Variance = (Actual Price โ Standard Price) ร Actual Quantity. It can also be written as actual cost (AP ร AQ) minus standard cost at the actual quantity (SP ร AQ).
How do you calculate direct materials price variance?
Subtract the standard price per unit from the actual price per unit, then multiply the difference by the actual quantity. For example, ($12 โ $10) ร 1,000 units gives $2,000, which is unfavorable because you paid more than standard.
What causes direct materials price variance?
Typical causes are supplier price changes, inflation, exchange rate movements, order size and volume discounts, freight costs, rush orders, material grade and out-of-date standard prices. Favorable variances often come from good negotiation, discounts or falling market prices.
Does this direct materials price variance calculator work for any currency or unit?
Yes. You can choose from several currency symbols or none, pick a unit such as kg, liters or pieces, or type your own, and set the rounding. These options change how results are displayed, not how they are calculated.
About the Author
Jhanzayb is a Qualified Chartered Accountant and an Associate Member (ACA) of the Institute of Chartered Accountants of Pakistan (ICAP, membership no. R-12893, verifiable on the ICAP website). He holds a Master of Commerce (M.Com) from a Higher Education Commission (HEC) Pakistan institution and a Bachelor of Accounting (Honours) from Asia e University, Malaysia.
With more than 7 years in professional practice, he writes on financial reporting (IFRS/IAS), audit and assurance, business finance, management and strategy, corporate law and tax, for entrepreneurs, business owners, finance students and working professionals. Connect with him on LinkedIn.
This page is for general educational purposes and is not professional accounting, tax, legal or financial advice. Standard-costing conventions differ between textbooks, exam boards and companies, so follow the one your course or employer uses.
Sources Consulted:
- OpenStax, Principles of Managerial Accounting: Compute and Evaluate Materials Variances
- Corpay, Purchase Price Variance: What the Number Means and What AP Should Do About It
The price-variance examples on this page were recalculated with the direct materials price variance calculator.
Related Finance Calculators:
Basic Earnings Per Share Calculator
Accumulated Depreciation Calculator
(Qualified) Chartered Accountant – ICAP
Master of Commerce – HEC, Pakistan
Bachelor of Accounting (Honours) – AeU, Malaysia