Insights
Plugging the leak of distorted production costs with ERP cost variance analysis
blog
“Sales is celebrating orders that have smashed their target, and a major customer has booked production capacity well into next year! But at the month-end close, the CFO walks into the meeting room looking tense and lays out a report deep in the red: ‘The more we sell, the more we lose!’… When management demands to know where the money went, the answer is: ‘We don’t know, because we’ve always used blanket costing.’…”
If “strong sales but no profit” is the nightmare draining your factory’s cash flow, the problem may not be the economy or competitors undercutting you. It may be that your costing method is badly out of date.
In manufacturing, selling prices are usually based on a standard cost that engineers and accountants estimated in an Excel file at the start of the year. In reality, though, the shop floor is full of volatility: steel prices spike, electricity bills soar, operators produce more defects than usual, or machines break down and overtime costs balloon. These factors push the actual cost well above what was planned. When you price based on an idealized cost, you end up eating into your own margin on every single unit you produce.
The “cost blindness” crisis: when accounting still relies on averages
Estimating production costs in Excel, or in an accounting system that isn’t connected to the shop floor, leads to structural losses:
- Blanket overhead allocation (peanut-butter costing): Accounting often takes monthly water, electricity, and machine depreciation costs and spreads them evenly across every order, when in reality product A may spend three times as long in the oven as product B. This kind of averaging leaves product A under-costed and priced too low, so it loses money, while product B is over-costed and priced too high, putting it at a competitive disadvantage.
- Finding out too late (post-mortem analysis): By the time accounting has gathered all the material and labor bills to close the books, it is already the middle of the following month. If there is a leak on the production line, management can’t fix it in time, because the goods have already been produced and delivered at a loss.
- No clear accountability: When costs spiral, purchasing blames production for excessive waste, and production blames purchasing for overpaying for materials, because there is no central data source showing which department caused the problem.
Recovering every baht of profit with ERP cost variance analysis
Factories that want world-class accuracy integrate their production and finance functions in ERP (Enterprise Resource Planning) software to calculate costs in real time, with three features that make or break your profit:
1. Detailed variance analysis
The ERP doesn’t simply report that costs are over budget; it breaks the overrun down component by component so you can pinpoint responsibility immediately! When a work order (lot) is completed, the system compares standard cost with actual cost and shows exactly where the difference lies:
- Material price variance: Costs are over because purchasing paid more for materials than the standard price.
- Material quantity variance: Costs are over because the line used more material than planned, or scrapped more than its allowance.
- Labor efficiency variance: Costs are over because operators took longer than the standard time, creating hidden labor costs.
Data at this level of detail lets management bring in the right department head and fix the problem at its source, with no more finger-pointing.
2. Activity-based costing (ABC)
Say goodbye to arbitrary averaging! The ERP can link overhead allocation rules to the actual production steps in the routing. For example, if a metal stamping press runs for 5 hours, the system applies the machine’s hourly rate and adds exactly that amount to the cost of that lot. This gives you an accurate picture of the true overhead cost of each product model.
3. Profit margin simulation before accepting an order
Before sales signs a contract with a customer, the system can pull the latest inventory costs (moving average or FIFO) together with current labor rates and run a real-time cost roll-up. Salespeople can see immediately how much profit the company will keep if they give the customer a 5% discount, which prevents closing big deals that end up losing money.
Summary: stop guessing your costs and let data measure your profit
Not knowing your true costs is the greatest risk a manufacturing business can take. Investing in ERP for manufacturing cost accounting is not just about keeping your paperwork in order; it gives you a magnifying glass that exposes every financial leak. It helps you set prices with confidence, compete effectively, and ensure that every increase in sales genuinely turns into net profit for the company.
Time for a financial health check… is the best-selling product in your factory actually making money for the company, or quietly bleeding it dry? Upgrade your standard costing and variance analysis. Talk to our manufacturing ERP experts today!
References
- Datar, S. M., & Rajan, M. V. (2020). Horngren’s Cost Accounting: A Managerial Emphasis. Pearson. (Cited for managerial cost accounting principles and variance analysis between standard and actual costs for materials, labor, and overhead.)
- Drury, C. (2018). Management and Cost Accounting. Cengage Learning. (Cited for activity-based costing theory and the impact of mispricing caused by traditional costing systems.)