From Actuals to Simulations: Building a Strategic Costing Layer Above Your ERP

Every manufacturer with an ERP system has access to an enormous volume of cost data. Purchase orders, production orders, labour records, material consumption, overhead allocations. The data is there, meticulously recorded, transaction by transaction.

And yet, when the CFO asks “what would our product costs look like if we moved production of Line B to Plant 2 and material prices increased by 8%?”, the answer takes weeks to prepare. Often it arrives in the form of a spreadsheet that nobody fully trusts.

This is the fundamental limitation of ERP-based costing: it is excellent at recording what happened but poorly equipped to explore what could happen.

What ERPs Do Well

It is important to acknowledge what ERPs handle effectively. Modern ERP systems are powerful transactional engines. They capture actual costs as they occur: the exact price paid for each raw material purchase, the actual labour hours recorded against each production order, the real overhead rates applied to each cost centre.

This transactional data is essential for financial reporting, inventory valuation, and operational control. No costing approach should attempt to replace it. The ERP is the system of record for what happened.

Where ERPs Fall Short

The limitation appears when you try to move from recording actuals to exploring alternatives. ERPs are not designed for forward-looking cost analysis because their architecture is built around transactions, not scenarios.

Consider these common strategic questions that manufacturers face:

Pricing strategy: If we want to quote a new customer with a 20% volume increase on Product Family X, what will the true cost per unit be, accounting for the capacity utilisation change?

Sourcing decisions: If we switch Supplier A for Supplier B on three key components, with different prices and lead times, what is the net impact on product costs across the entire portfolio?

Capacity planning: If we add a second shift to Line 3, how do the fixed cost absorption rates change, and what does that mean for the profitability of every product running on that line?

External shocks: If energy costs increase by 20% and a 10% tariff is applied to imported components, which products remain profitable and which fall below margin thresholds?

These questions require the ability to modify assumptions, recalculate costs, and compare outcomes. ERPs simply do not do this. You can change a standard cost in the ERP, but you cannot easily run parallel scenarios, compare them, and trace the differences back to their root causes.

The Strategic Costing Layer

The solution is not to replace the ERP but to build a strategic costing layer above it. This layer sits between the ERP’s transactional data and the company’s strategic decision-making process. It imports actuals from the ERP but transforms them into a flexible, simulation-ready model.

This layer operates in four steps:

Step 1: Import. Extract relevant data from the ERP: general ledger costs, bills of materials, production volumes, labour records, and operational data. This creates the baseline, a model that reflects the current reality as captured by the ERP.

Step 2: Model. Structure the imported data into a proper cost model using a methodology like TDABC. This means defining resource pools, calculating cost rates, building time equations, and establishing the relationships between resources, activities, and cost objects. The model transforms raw transactional data into an analytical framework.

Step 3: Simulate. With the model in place, create scenarios by adjusting input variables. Change material prices, modify labour rates, alter production volumes, add or remove product lines, shift production between facilities. Each scenario produces a complete recalculation of product and customer costs.

Step 4: Compare. Analyse the differences between the baseline and each scenario. Which products are most sensitive to the variable you changed? Where do margin thresholds get crossed? What is the total P&L impact? This comparison is where strategic insight emerges.

Why This Is Not Just a Bigger Spreadsheet

Some finance teams attempt to build this capability in spreadsheets. For very simple businesses, that can work temporarily. But for any manufacturer with more than a handful of products, the spreadsheet approach breaks down for predictable reasons:

Formula fragility: Complex spreadsheet models with thousands of cells and cross-references are extremely prone to errors. Studies consistently show that a significant percentage of large spreadsheets contain material errors.

Version chaos: When multiple people work on the model, version control becomes a nightmare. Which version has the latest assumptions? Which scenario was the one the board reviewed?

Speed limitations: Large spreadsheet models can take minutes to recalculate, making iterative scenario analysis painfully slow.

Audit trail gaps: Tracing how a specific product cost was calculated, through all the allocation steps and assumptions, is extremely difficult in a spreadsheet. In a purpose-built costing platform, every calculation step is transparent and traceable.

The Competitive Advantage of Speed

The manufacturers who build this strategic costing capability gain a competitive advantage that compounds over time. When a tariff changes, they know the impact within hours. When a customer requests a volume quote, they can calculate the true cost implications before the sales team responds. When the board considers a capacity investment, the financial analysis is ready in days, not months.

This speed advantage matters because business decisions have time windows. The company that can evaluate a sourcing change in three days while competitors take three weeks will consistently make better, more timely decisions.

The ERP will always be the foundation for transactional accuracy. But the strategic costing layer is where manufacturing companies turn data into decisions.

By Miguel Guimaraes, Partner at Cost and Profitability Consulting and Co-Founder of CostCTRL