https://projectsalsa.co.nz/blog/leak-resistant-billing-for-nz-3pl-operators
Skip to content
NetSuite 2026 - Part 2-24 (1)
6 min read

Do You Know What Each Product Really Costs to Make?

Why the cost on your recipe and the cost on the production floor rarely match, and how to see the difference.

Ingredient, packaging and freight costs rarely stand still. For food manufacturers working on thin margins, a few cents a kilo on a key ingredient can quietly change whether a product makes money.

Yet many businesses still price from a recipe cost kept in a spreadsheet and updated a few times a year. That gives you one number: what a product should cost. It doesn't tell you what it actually cost the last time you made it.

The gap between those two numbers is where margin leaks. This post explains where each number comes from, what causes the gap, and how the costing method you choose affects what you see.

The Two Numbers That Matter

Every product you make has two costs:

  • Expected cost. What the product should cost, based on its recipe and current ingredient and packaging costs.

  • Actual cost. What it did cost, based on what was really used when it was made.

Say your recipe for a batch of muesli bars calls for 50 kg of oats. On the day, the team uses 53 kg, and the honey was bought at a higher price than last month. If your costs live in a spreadsheet updated a few times a year, neither change shows up in your recipe cost, but both show up in your margin.

With average costing in NetSuite, the higher honey price lifts the honey’s average cost, so every kilo issued to the work order carries the new price. The finished muesli bars then pick up both costs: the extra oats used, and the higher price of the honey. Your expected cost reflects the new honey price too, but it still assumes 50 kg of oats. That 3 kg difference is the gap between what the bars should have cost and what they did.

Where the Expected Cost Comes From

In NetSuite, a product you manufacture is set up as an assembly item with a bill of materials: the recipe that lists each ingredient and the quantity needed. Combined with the cost of each ingredient, this gives the product's expected cost.

NetSuite can show this as a costed bill of materials, breaking down what each ingredient contributes to the total. If the recipe changes or ingredient costs move, the costed bill of materials updates with them.

It's a planning figure, though. It tells you what a product should cost today. It doesn't record what any production run actually cost.

Where the Actual Cost Comes From

Actual cost is captured on the work order, the record of each production run. Ingredients are issued to the work order as they're used, and finished goods are received from it, so the work order builds up a record of what that run really cost.

The actual cost is only final when the work order is closed. At that point, NetSuite reconciles everything recorded against it and accounts for any difference from the expected cost.

The Gap: Understanding Production Variances

The difference between expected and actual cost is called a production variance. It usually comes from two places:

  • Quantity variance. More or less of an ingredient was used than the recipe planned. Over-portioning, spillage or a recipe that no longer reflects how the product is really made will all show up here.

  • Price variance. Ingredients cost more or less than the expected cost assumed, perhaps because a supplier put prices up or you bought from a different source. This mainly applies under standard costing, as average costing builds price changes into the ingredient’s cost as soon as you buy it.

Under standard costing, NetSuite posts quantity and price variances separately when a work order is closed, so you can see whether the difference came from how much you used or what you paid.

Standard vs Average Costing: Which Suits You?

How production variances show up depends on the costing method each product uses. NetSuite supports both standard and average costing for manufactured products.

  Standard costing Average costing
How cost is set  A fixed benchmark cost that you set and review  Recalculated from actual costs as they occur
How variances show Posted to separate variance accounts when a work order closes, so they're very visible Differences flow into the product's average cost
Upkeep Benchmarks need regular review to stay accurate Simpler to run day to day
Suits Businesses that want to measure performance against a fixed target Businesses that want costs to reflect reality with less maintenance

Neither is right for every business. For many NZ food manufacturers, average costing is the simpler place to start. Standard costing suits businesses that want to measure performance against a fixed target and are prepared to keep their standards up to date.

Seeing Expected and Actual Side by Side

Knowing both numbers exist is one thing. Seeing them together, product by product, is what helps you act.

NetSuite records the expected cost, the actual cost and the variance. For products using average costing, Oracle’s Cost Variance Analysis SuiteApp compares planned and actual cost for each work order, down to individual ingredients, so you can see where costs ran over. Project Salsa can also set up reporting during implementation to compare actual against expected cost across products, whichever costing method you use.

Lot costing can also tie costs to specific lots, which links naturally with lot traceability. And once products are sold, NetSuite's profitability reporting shows the margin each product delivers.

Do You Know Your True Product Costs?

Ask yourself:

☐    When were our product costs last updated?
☐    Do we know which products cost more to make than planned last month?
☐    Can we tell whether the difference came from ingredient usage, ingredient prices or both?
☐    Are our selling prices based on current costs, or last year's?
☐    Would our finance and production teams give the same answer?

If any of these are hard to answer, your margins may not be what you think they are.

Not sure how your costing stacks up? Talk to our team about getting a clearer view of what each product really costs to make.

Frequently Asked Questions

What is the difference between expected and actual product cost?
Expected cost is what a product should cost, based on its recipe and current ingredient costs. Actual cost is what it did cost, based on what was really used when it was made.

What is a costed bill of materials?
A costed bill of materials breaks down a product's expected cost by ingredient, using the recipe and current costs. It's a planning figure, not a record of what a production run actually cost.

What is a production variance?
A production variance is the difference between the expected and actual cost of a production run. It usually comes from using more or less of an ingredient than planned, or paying more or less for it.

When is the actual cost of a production run known?
In NetSuite, the actual cost is final when the work order for that run is closed.

What is the difference between standard and average costing?
Standard costing uses a fixed benchmark cost that you set and review, with differences posted as variances. Average costing recalculates cost from actual costs as they occur.

Which costing method is best for a food manufacturer?
It depends on how you want to manage cost. Average costing is simpler to run, while standard costing suits businesses that want to measure performance against a fixed target and can keep their standards up to date.

avatar
Cassie Robinson
Cassie is part of the wider Verde Group marketing team, focusing on campaign delivery and management, helping New Zealand businesses navigate the move to cloud ERP with clarity and confidence. With over fifteen years' experience in marketing roles spanning SaaS, technology, and digital solutions, she brings a strategic, data-driven approach to positioning, campaigns, and customer-facing content. Cassie holds a degree in Marketing and International Business from Victoria University and has built her career translating complex technical concepts into compelling, customer-centric messaging. Outside of work, Cassie can usually be found exploring the outdoors with her family, tending to her backyard chickens, or baking a cheesecake.

RELATED ARTICLES