Every Dollar Has a Story: Looking Beyond Planned vs. Actual Costs

Imagine reviewing your monthly manufacturing report.

Planned production cost: $500,000

Actual production cost: $540,000

An 8% variance.

What actually happened? Was it higher material prices? Scrap? Overtime? A supplier issue? A machine breakdown? Or a dozen small inefficiencies spread across hundreds of jobs?

This is the fundamental problem with planned vs. actual costing: the headline number rarely tells the story.

And in manufacturing today, that story matters more than ever.

Cost variances are typically a combination of material, labour, overhead, and usage differences that must be analysed individually to be meaningful. Without that breakdown, manufacturers risk missing the operational causes behind shrinking margins.

The right people can see it at the right time need to see that information. Modern ERP platforms such as Odoo provide a single source of truth, but it's the people using that information (i.e. production managers, buyers, accountants, planners, and executives) who turn cost data into better decisions.

Planned Costs Define “How Things Should Go”

Planned (or standard) costs are essential.

They set expectations for:

  • Materials required per BOM
  • Labour time per operation
  • Machine and overhead rates
  • Expected scrap and yield


In ERP systems, these standards are often built from routings and bills of materials, forming the baseline for pricing and budgeting.

In other words, planned cost is the assumption, reflecting how production should behave under ideal or expected conditions.

But, if you’re reading this then you probably know: manufacturing is rarely ideal.

A production planner may create the original routing, engineering may define the BOM, and finance may approve the standard costs. Each department contributes to the expected cost model, making it a company-wide benchmark rather than simply an accounting figure.

Actual Costs Capture Reality

  • What materials were consumed
  • Actual labour hours worked
  • Real machine time used
  • Real overhead absorbed
  • Scrap, rework, delays, and disruptions


Modern ERP systems automatically capture these events through production reporting, inventory transactions, purchasing, and job costing.

Platforms like Odoo don't determine why costs changed. ERPs  simply connect the information from across the business into one place.


That visibility allows different teams to answer different questions.

  • A production supervisor might notice that one work centre consistently exceeds expected cycle times.
  • A procurement manager may discover that a supplier's recent price increases are driving material variance.
  • Finance can immediately see how those operational changes affect margins and profitability.


Ultimately, the benefit of the visibility ERPs like Odoo bring is the ability to investigate variances before they become a larger problem.

The Problem with Averages

One of the biggest mistakes manufacturers make is relying on total or average cost variance.

Because averages hide extremes.

Consider this:

Job

Planned

Actual

A

£10,000

£10,050

B

£10,000

  £9,950

C

£10,000

£10,000

  D

£10,000

£10,100

  E

£10,000

  £14,900

Job

Planned

Actual

A

£10,000

£10,050

B

£10,000

£9,950  

C

£10,000

£10,000

D

£10,000

£10,100  

E

£10,000

£14,900  

The overall variance might look “manageable” on average.

But Job E tells a very different story:

  • major scrap event
  • A supplier failure
  • A routing issue
  • A machine breakdown
  • A planning error

Aggregate cost variance can mask offsetting favorable and unfavorable movements, making it harder to identify root causes without drilling into the underlying transactions.

ERP dashboards and drill-down reporting became invaluable in these scenarios by allowing managers to trace costs back through production orders, inventory improvements, purchase receipts and shop floor activity to understand the root of the problem.

Every Variance is a Signal

Planned vs. actual costing is often viewed as an accounting exercise.

We see it as a diagnostic tool.

Each variance type tells a different story:


Material variances could indicate:

  • Supplier price changes
  • Waste or scrap
  • Incorrect BOM assumptions
  • Substitutions or shortages


Labour variances could indicate:

  • Overtime usage
  • Inefficient workflows
  • Training gaps
  • Machine downtime


Overhead variances could indicate:

  • Underutilised capacity
  • Unexpected maintenance
  • Scheduling inefficiencies
  • Production volatility


Breaking cost variance into these categories helps organisations identify operational causes instead of simply reporting financial outcomes.

Every dollar, in this sense, is a clue.

The Real Goal: Understanding the Story Behind the Number

Every plant manager and every manufacturing business should be able to answer questions like:

  • Which jobs are trending over budget right now?
  • Where is scrap increasing during production?
  • Which suppliers are driving cost instability?
  • Which operations are consistently underperforming?


Modern costing approaches increasingly combine real-time production data with predictive analytics to identify these deviations earlier in the process. ERP platforms help make this possible by connecting production, inventory, purchasing, and finance data into a single source of truth. With greater visibility, teams across the business can identify problems sooner and take action before they become costly.

Every Dollar Has a Story 

Looking at total cost variance is like reading only the headline of an article.

You learn that fuel prices have increased.

But you don't see the supply chain disruptions, geopolitical events, or market shifts that caused them.

The real insight comes when you zoom in:

Company → Plant → Job → Operation→ Transaction

That’s where the story lives.

And that’s where improvement becomes possible.

Conclusion: Planned vs. Actual is Not an Accounting Exercise

Manufacturers that treat cost variance as a story rather than simply a report are more equipped to understand and improve their margins.

ERP platforms like Odoo provide the visibility needed to uncover those stories, enabling finance teams to analyze trends, production managers to improve efficiency, procurement professionals to strengthen supplier performance, and leadership to make more informed strategic decisions.

Because every dollar has a story. The manufacturers that learn to read it are the ones best positioned to improve profitability, reduce waste, and stay competitive.