Compare standard and actual material use by multiplying the planned quantity for each product by output, then subtracting that total from actual usage. A bakery expects a certain amount of flour for each loaf. A candle maker expects a certain amount of wax and wick for each jar. The question that often gets missed is whether the materials actually leaving the storeroom match that expectation. When they do not, the gap is money, and it usually shows up only as a stock count that looks wrong at the end of the month.
Accounting textbooks have a name for this comparison: a variance analysis. You do not need an accounting background to run one. OpenStax's managerial accounting text puts the core idea in one sentence: "There are two components to a direct materials variance, the direct materials price variance and the direct materials quantity variance, which both compare the actual price or amount used to the standard amount." ( OpenStax, section 8.2). In plain terms, you compare what you paid and used with what you planned to pay and use.
This post uses three figures to make that comparison:
- The standard quantity: the amount of each material you planned to use for one unit of a product.
- The actual quantity: the amount you really used, worked out from your stock records and counts.
- The variance: the difference between actual use and the standard quantity allowed for the products made.
Margins in a small shop are often thin, so a material that leaks a little each week can wipe out a month's profit on a product without anyone noticing. Comparing standard and actual use is one of the cheapest ways to catch that leak. It does not need new equipment, and it works whether you sell ten products or several hundred.
You need a stock count sheet, your purchase invoices, and your sales or production records for the same period. Nothing here requires special software, although a spreadsheet makes the arithmetic easier. The steps below are in the order you would take them.
1. Write the standard for each product
A standard is the amount of material you expect one product to use when it is made the way you intend. It is a planning figure, set before production starts, and it should be written down before anyone counts anything. OpenStax's example of a production standard describes a firm where "The consulting firm’s standard was production of 100 gallons of ice cream every 45 minutes" ( OpenStax, section 8.1). That is a rate of output, not a recipe, but the idea carries over to a small shop. A standard states how much input a given output should take, and everyone who works on the product should be working to the same figure.
For most independent shops, the standard is a bill of materials: a list of each ingredient or component and the amount needed for one sellable unit. Write each material in one unit of measure, such as grams, millilitres or single items, and include packaging. A gift basket standard should list the basket, the tissue, the card, the ribbon length and the cellophane, not just the name of the product. Keep the list on one page and date it, so you always know which version applied to which count.
Set the standard honestly. A standard that is too easy to meet gives you a false sense of control. A standard that nobody can meet makes staff stop paying attention to it. Either way, the comparison in the later steps will mislead you. When you do not know what a realistic figure looks like, measure several batches made under normal conditions, use the average as the starting point, and review it after a few cycles.
2. Work out the actual quantity used
The actual quantity is what really left your storeroom for the products in question, over a fixed period. The simplest method for most independent shops is a stock movement calculation. Take the opening count, add what was bought during the period, subtract the closing count, and then subtract any stock that moved out for other reasons, such as samples, transfers to another shop, or items written off. What remains is the material you actually used.
Use the same period for every figure. If your sales run to the end of the week but your stock count is taken on the Friday morning, the two numbers do not describe the same time, and the variance will be false. Pick one cut-off point and keep it.
Be disciplined about three things. First, count at the same point in the day each time, before or after service, so you are not comparing a full shelf with an empty one. Second, use the same units as the standard. If the standard says grams and your invoice says kilograms, convert before you subtract. Third, record waste, breakage and samples on their own lines instead of folding them into a general "other" figure. Those lines often explain the gap on their own.
Opened packs need care too. A half-used bag of oats or a partly full jar of wax cannot be counted as a whole unit. Weigh it, or estimate it by a fixed method you write down, and use that same method each time. If you round up for one count and down for the next, the difference will look like usage when it is only a change in how you counted.
Packaging and small consumables are the usual blind spot. They often sit outside the recipe, so nobody counts them, and they can add up to more than the main ingredient. Give them their own standard too. An example from OpenStax shows why this matters. A popcorn seller trains staff to use a fixed amount of butter for each bag, so "total butter usage is based on the number of bags of popcorn sold" ( OpenStax, section 8.2). The same logic applies to your shop. For help checking the count behind this comparison, see physical inventory reconciliation.
3. Calculate the variance
Now for the comparison itself. For each material and each product, calculate the expected usage and the actual usage, then subtract one from the other.
Expected usage is the standard for one unit multiplied by the number of units made in the period; use units sold only when they match production. Actual usage comes from step 2. The variance is actual minus expected. A positive result means you used more than the standard allowed. A negative result means you used less. Keep the sign convention the same every time, so that trends can be read across months.
Consider a simple case. Suppose the standard for a bag of granola is a fixed weight of oats for each bag, and you made and sold a month's worth of those bags. The expected usage is that standard weight multiplied by the number of bags sold. Your count then shows the oats actually used. If the count is higher than the expected figure, the difference is the variance, and it is written down as a number rather than a vague feeling that the oats seem to go quickly.
Express the variance as a share of expected usage as well as in units. A percentage lets you compare a large product with a small one on the same scale. Do not decide in advance which percentage counts as a problem. Pick a level your shop can act on, write it on the count sheet, and record how often you cross it.
Check the sales side as well. If you use units sold, make sure the till or order records match the products you actually made. If a bundle was sold but its components were recorded under the wrong product, the expected usage will be wrong and the variance will point in the wrong direction. Reconcile the sales count against the production log before you trust the result.
Look at the variance by material first, and only then by product. One product's gap can be cancelled out by another's, and the same ingredient often appears in several products. A material with a steady gap across three products is usually a bigger issue than a one-off gap in a single product.
4. Split the variance into price and quantity
The total cost variance is a mix of two different things. One is price: you paid more or less for each unit of material than the standard assumed. The other is quantity: you used more or less material than the standard assumed. They have different causes and different owners, so if you mix them together, the answer stays hidden.
OpenStax's candy example sets a standard price of $7.00 for each pound of candy-making materials ( OpenStax, section 8.2). Suppose your standard price for the granola oats is a fixed amount for each kilogram. If the invoice comes in at a higher price, the extra cost is a price variance, even if the shop used exactly the right amount. A supplier increase, a different pack size or a rushed order can cause it. The fix sits with whoever buys the stock, not with the people making the product.
The quantity variance is the usage difference valued at the standard price. In the granola example, the extra kilograms of oats are multiplied by the standard price for each kilogram to give their cost at standard. That cost belongs to production and stock handling. Splitting the variance this way tells you who to ask, and it stops a purchasing problem from being blamed on the kitchen, or the reverse.
To split the figures, use two simple calculations. The price variance is the actual price minus the standard price for one unit, multiplied by the actual quantity used. The quantity variance is the actual quantity minus the expected quantity, multiplied by the standard price. Together they add up to the total cost variance for the materials used. If they do not add up, check that the prices and quantities describe the same materials and period before you go further.
In one costing system, costs can be adjusted later. Microsoft's documentation for one costing system describes the case where prices settle later: "When the actual cost is realized later, the standard cost must be adjusted to the actual cost through variance values" ( Microsoft Learn, costing methods). In a spreadsheet, you do the same thing by hand. Record the standard cost first, then record the difference once the invoice shows the real price.
5. Find out why the gap happened
A variance is a question, not a verdict. The number tells you where to look, and it does not tell you who caused the gap. Before blaming a person, check the common explanations, because many gaps come from the process or the standard rather than from carelessness.
OpenStax gives a plain example of a quantity problem: "Some reasons why more butter was used than expected (unfavorable outcome) would be because of inexperienced workers pouring too much, or the standard was set too low, producing unrealistic expectations that do not satisfy customers" ( OpenStax, section 8.2). That sentence names two causes that look the same on a count sheet but need different fixes. Inexperienced staff need training and a visible portion guide. A standard set too low needs rewriting, because no amount of training will close a gap the standard never allowed for.
Other causes to check in a small shop include:
- Over-portioning: extra topping, extra wrap, or a heavier scoop than the standard assumes.
- Spoilage and breakage: product that was made and then thrown away, or packaging that was damaged during handling.
- Unrecorded use: samples, tastings, or staff use that never reached the sheet.
- Counting errors: a miscount at either end of the period, or a delivery logged in the wrong week.
- Changed supplies: a new pack size or a different product spec from a supplier, which changes usage without anyone noticing.
- Unexplained loss: theft or missing stock. Look into this after the simpler causes have been checked, not before.
A useful habit is to test each suspected cause before you act on it. If you think portions are the problem, weigh a sample of finished products and compare them with the standard. If you think a supplier changed the pack, check the last three invoices. If you think a count is wrong, recount the same shelf with a second person. Each test takes a few minutes, and each one turns a guess into a finding.
Write the likely cause next to each variance that crosses your threshold. Over a few cycles, the list of causes will show patterns. A cause that repeats every month is the most useful thing your count sheets can produce, because it points to a fix you can actually make.
6. Repeat the check on a fixed cycle
A one-off comparison tells you what happened once. A repeated comparison tells you whether the shop is under control. Decide who runs the check, and who reviews it. In many shops the stock-count staff do the counting, the manager checks the arithmetic, and the owner looks at the summary. Separating those jobs reduces the chance that one person's error goes unnoticed. Whoever runs the check should have the standards in front of them, not just the last count.
Choose a cycle that matches how often you count. A monthly check suits many small shops, and a weekly check may suit fast-moving stock. Run the same steps each time, with the same count method, the same units and the same sheet layout, so the figures stay comparable.
Review the standards at the same time. If a product's variance keeps going in one direction, either the process has drifted or the standard was wrong from the start. Update the standard when the evidence supports it, and date the change, so that the earlier comparisons still make sense. Do not quietly change a standard to make a bad month look better. That removes the very signal you are trying to read.
Keep the workings together. The standard, the count sheet, the invoices and the variance calculation should sit in one place, with the date of the count and the initials of whoever did it. When someone asks why a figure moved, you can show the working rather than rebuild it from memory. This also helps when a new member of staff takes over the count, because they can follow the same steps without guessing.
A shop that does this every cycle learns quickly which products are steady, which materials are leaking, and which standards need to change. The three figures are simple on their own. Put together, they show whether the materials you bought are going into the products you planned to make.
Related guides: Predicted and actual usage: 7 steps to check gaps · Material chute safety: 8 design and operation rules · Check 4 refund fields before stock goes back on shelf.