Parts price variance: 6 figures to compare before you quote

• Match each standard unit price to the invoice unit before you subtract.
• Compare the latest actual price with the standard, and label the price variance.
• Check that each job's standard quantity still matches how the work is done.
• Keep bought and used quantities in separate, clearly labeled periods.
• Tell the estimator which costs are standard and which are current.

If you quote jobs from a standard cost, you have already made a useful decision. A standard tells you what a part should cost before the invoice arrives, so you can build a price for the customer without waiting for the supplier's paperwork. The trouble starts when the standard quietly becomes the only number anyone looks at. Parts costs move. Suppliers change prices, buyers purchase in odd quantities, and technicians use more or less material than the estimate assumed. A quote built on last year's figure can lose money on this year's job.

Parts price variance is one of the simplest checks you can run, and it is worth doing before every quote where the parts cost is large enough to matter. This post walks through six figures to compare, shows how they fit together, and gives you a short routine you can use before you send a number to a customer.

Nothing here replaces your own accounting records or advice from your accountant. The goal is to make the numbers you already have easier to read, so that the price you quote reflects what the parts are likely to cost, not what the standard sheet said months ago.

A standard cost is a planned cost. Someone decided what a part should cost for each unit and how much of it a finished job should use. The OpenStax example sets a standard price and expects a standard quantity for each box. In one common teaching example, a candy maker sets a standard price for candy-making materials of $7.00 a pound , and each box of candy is expected to use 0.25 pounds of candy-making materials . Those two figures together give the planned material cost of one box.

This setup lets you separate two different questions. The first is whether the price you paid for the material differed from the planned price. The second is whether you used more or less of the material than planned. These questions have different causes, different owners, and different fixes. If you mix them together, you will often blame the wrong person or the wrong supplier.

Before you quote a job built on a standard cost, pull these six figures side by side. You do not need special software. A spreadsheet with one row for each part is enough for most shops. For a related guide, see parts pricing spreadsheet .

1. Standard unit price. This is the price you assumed when you built the standard cost. Write down the unit of measure too: each, box, foot, pound, gallon, or whatever the supplier sells. Many variance errors start with a unit mismatch, such as a standard set by the pound while the invoice counts boxes.

2. Actual unit price. This is what you actually paid, taken from the latest invoice or purchase record and adjusted to the same unit as the standard. If you received a discount, a freight charge, or a restocking fee, decide now how you will treat it, and treat every part the same way.

3. Standard quantity for one job. This is how much of the part the standard says one finished job should use. A bill of materials, a service checklist, or a repair guide usually holds this number. It is planned usage, not the amount a good technician might use on a lucky day.

4. Actual quantity purchased. This is how many units you bought in the period you are reviewing. Price variance is often calculated on what you bought, not what you used. If you bought a larger lot, the price difference applies to that whole lot.

5. Actual quantity used. This is how many units went into finished jobs. Compare it with the standard quantity multiplied by the number of jobs. Usage differences often come from waste, rework, returns, or a standard that no longer matches how the work is done.

6. Rolled-up unit cost. This is the total standard cost of the finished item or service line, built from its parts. It is the figure that goes into your quote. If one part changes, this number changes too, and you need to see the effect before the customer does.

Looking at all six at once helps you answer a simple question: is the cost change coming from the price you paid, the amount you used, or the way the standard was built? Each answer leads to a different action.

The standard formula for material price variance compares the actual price with the standard price, then multiplies the difference by the quantity purchased. A positive difference means you paid more than planned, which is unfavorable. A negative difference means you paid less than planned, which is favorable.

The OpenStax example uses exactly this setup. The candy maker found that the actual price of materials was $6.00 a pound , and they purchased 20 pounds of materials . Against a standard of $7.00 a pound, the lower actual price produces a favorable price variance on that purchase. It is worth understanding before you celebrate, because a lower price may mean the supplier changed the product, the quality differs, or the timing was simply lucky.

The source describes the case as one where the actual unit price of materials is $6.00, the standard unit price of materials is $7.00, and the actual quantity purchased is 20 pounds . Those three inputs are all you need for the price side of the calculation.

The same logic applies to any part in your shop. Take the standard unit price, subtract it from the invoice unit price, and multiply by the units bought. Label the result favorable or unfavorable. Do this for each part that goes into the quote, not only the expensive ones. Small parts bought in bulk can add up faster than a single large part bought once.

Usage variance is the companion to price variance. It compares the quantity you actually used with the quantity the standard allowed, then values the difference at the standard price. If your technicians use more of a part than the standard allows, the usage variance is unfavorable, even if you bought the part at a good price.

The same OpenStax source shows the usage side. Each box is expected to use a set amount of material, and the actual amount used can differ. The value of the example is the habit it teaches: compare planned usage with real usage, job by job or period by period, so you can see where material goes.

Be careful about the time window. If you bought 20 units but used only some of them this month, the rest sits in inventory. Usage variance should compare material used in finished work against the standard for that work. Price variance can use purchases. Mixing the two windows is a common source of confusing reports.

A practical habit is to count usage for a small set of recent jobs of the same type. If the standard assumes one unit on every job but the crew averages one and a half, you have found a usage gap worth examining. Decide whether the standard is wrong, the process is wasteful, or the job scope has changed without anyone updating the quote sheet.

This example uses made-up numbers. A shop sets a standard unit price of 5 for a fitting and assumes one fitting on each job. It buys 10 fittings at an actual unit price of 6, then completes 10 jobs that use 12 fittings in total.

The price variance is (6 - 5) x 10 = 10, unfavorable, because the shop paid more than planned. The usage variance is (12 - 10) x 5 = 10, also unfavorable, because the jobs used 2 more fittings than the standard allowed. The two gaps have different causes, so each needs its own fix.

The candy example becomes more useful when the price moves the other way. The source includes a variation where the actual price for candy-making materials is $9.00 a pound . The standard is still $7.00 a pound, so the actual price sits above standard. On the same purchase, the price variance is unfavorable, and the cost of each box is higher than the plan.

This matters for quoting. If you priced a job at the standard cost and the parts now cost more for each unit than planned, your margin on that job shrinks, even though your technicians did everything right. You have three choices. You can absorb the difference, pass it on to the customer, or change how you buy, schedule, or specify the part. The right choice depends on your margins, your customer relationships, and whether the increase is likely to last.

Do not wait for an unfavorable variance to appear at the end of the month. If you see a supplier price change on an invoice, update the quote-ready cost right away, or flag the job so the estimator knows the standard is out of date. For a related check, see supplier price changes . A quote that is correct on the day you send it protects you more than a variance report that explains the loss later.

Once you have price and usage figures for each part, you need to combine them into a single cost for the item you are quoting. This is where many small shops get stuck. They have a list of parts with prices but no clear way to turn those prices into a finished quote line.

The Business Central documentation describes this roll-up using a bill of materials. In its example, the INV-COMP item's unit cost of 10 multiplied by the BOM quantity of 2 gives the cost contribution of that component. A second component, with the NONINV-COMP item's unit cost of 4 multiplied by the BOM quantity of 3 , contributes its own amount. Add the contributions together and you have the cost of the assembly. Your shop may use different software, or none, but the arithmetic is the same.

The idea is to spread a total cost over the number of units it covers. If a batch of parts costs 120 and yields 10 units, each unit carries 12 of cost. If you forget to divide, or divide by the wrong count, your quote will be wrong in a way that is hard to spot.

When you roll up costs, keep three things separate: the cost of each component, the quantity of each component in the finished item, and any extra cost that applies to the whole job, such as a fitting kit, a disposal fee, or a delivery charge. Mixing these levels is a frequent mistake. A part used at a rate of two for every job should not be treated as used once for every job just because you bought it that way.

A quote routine does not need to be complicated. It needs to be done the same way every time.

First, pick the parts that drive most of the cost. You do not need to analyze every bolt and washer for every quote. Focus on the parts that make up most of the material cost, and on any part whose price has changed recently.

Second, pull the six figures for each of those parts. Confirm the standard price and unit, the latest actual price, the standard quantity for each job, the quantity bought in the period, the quantity used, and the rolled-up unit cost of the item you are quoting. If a figure is missing, write that down rather than guessing.

Third, calculate the price variance and the usage variance for each part. Label each favorable or unfavorable, and keep the sign convention the same across all parts so your team reads the report the same way.

Fourth, decide whether the standard needs updating. A consistent price variance suggests the standard is out of date. A consistent usage variance suggests the standard may be wrong, or the process needs attention. A one-time difference from a single unusual invoice does not always justify changing the standard, but a pattern does.

Fifth, set the quote. Use the current, reviewed cost for any part with a known price change, then add your normal markup or margin. If you decide to hold the old price for a customer relationship, record that choice so you can see its effect later.

Sixth, check the quote against the variance report after the job closes. Did the parts cost what you expected? Did the crew use what the standard allowed? The answer tells you whether your routine works and gives you evidence for improving the next one.

The first mistake is comparing a box price with a pound standard, or any other unit mismatch. Convert to the same unit before you subtract. A quick check is to confirm that the invoice unit matches the standard unit, and to write both down.

The second mistake is calculating variance on the wrong quantity. Keep the two calculations clearly labeled.

The third mistake is treating a favorable variance as pure good news. A lower price can come from a cheaper substitute, a smaller pack, a short promotion, or a purchase made before a planned increase. Find out why the price is lower before you bank the savings in your quote.

The fourth mistake is updating the standard too often or too rarely. Changing it every time an invoice differs makes quotes unstable. Never updating it lets quotes drift away from reality. Set a review schedule and make exceptions only for large, lasting changes.

The fifth mistake is ignoring the parts you consider minor. Small items bought in volume can add up to a meaningful share of cost, especially on jobs that use many of them.

The sixth mistake is failing to tell the estimator. A variance report sitting in a manager's inbox does nothing for the person writing the next quote. Share current quote-ready costs with everyone who prices work, and say clearly which numbers changed and why.

Parts price variance is not a complicated idea, but it is easy to skip when the workload is high. The six figures are the standard price, the actual price, the standard quantity for each job, the actual quantity purchased, the actual quantity used, and the rolled-up unit cost. Compare them before you quote, and you will know whether a cost change came from the market, your buying, your crew, or an out-of-date standard.

You do not need perfect data to get value from this. You need consistent units, a clear record of what you paid and used, and a habit of checking numbers before a customer sees them. Start with the parts that matter most, run the calculations for one month, and see what the variances tell you.

Related guides: Silica dust limits: 2 California figures before you price · Service call cost: 5 expenses to add before you quote · Used oil rules: 6 checks before you price an oil change .

What is the difference between price variance and usage variance?

Price variance compares the price you paid with the standard price. Usage variance compares the quantity you used with the quantity the standard allowed.

Should price variance use the quantity bought or the quantity used?

Price variance is often calculated on the quantity you bought, while usage variance uses the quantity used in finished work.

Is a favorable price variance always good news?

No. A favorable variance can come from a cheaper substitute, a smaller pack, a short promotion, or a purchase made before a planned increase.