New Tariffs and Cost Chaos: Why Simulation-Ready Costing Models Matter

When new tariffs are announced, the same pattern repeats in manufacturing companies around the world. Finance teams scramble to open spreadsheets. They manually adjust material cost cells. They try to trace the impact through to product costs, customer quotes, and margin projections. It takes days, sometimes weeks. By the time the analysis is ready, the market has already moved.

This is not a tariff problem. It is a costing infrastructure problem.

The Real Issue: Static Costing in a Dynamic World

Most manufacturing companies calculate product costs once per year, sometimes once per quarter. The process typically involves pulling data from the ERP, layering it into spreadsheets with hundreds of tabs and thousands of formulas, and producing a cost book that becomes the reference until the next cycle.

This approach works reasonably well in stable environments. But stable environments are increasingly rare. Tariff changes, raw material price swings, energy cost fluctuations, supply chain disruptions, and currency movements can alter the cost landscape in weeks, not quarters.

When the costing model is a static spreadsheet updated periodically, every external change triggers a fire drill. Finance teams are forced into reactive mode, manually retracing cost flows and hoping they have not broken a formula somewhere in the process.

What Simulation-Ready Costing Looks Like

A simulation-ready costing model is fundamentally different from a static cost calculation. It is designed to answer “what if” questions quickly and reliably. Its key characteristics include:

Parameterised inputs: Material costs, labour rates, energy prices, overhead allocations, and other cost drivers are defined as adjustable parameters rather than hard-coded values. Changing a tariff rate on imported steel should be a single input change, not a manual search through dozens of spreadsheet tabs.

Transparent cost flows: Every cost element traces from its source (the general ledger, the bill of materials, the process definition) through to the final product or customer cost. This transparency means you can see exactly how a tariff change propagates through the model.

Scenario comparison: The model can hold multiple scenarios simultaneously, allowing side-by-side comparison of current costs versus projected costs under different assumptions. What happens if the tariff on Component A increases by 15%? What if it increases by 25%? What if you switch to a domestic supplier at a different price point?

Speed: A useful simulation produces results in minutes, not days. If the analysis takes two weeks, the window for proactive decision-making has already closed.

Tariffs as a Stress Test

Tariff changes are a particularly effective stress test for a company’s costing capabilities because they expose every weakness in the model.

First, tariffs affect purchased materials, which flow into bills of materials, which flow into product costs, which flow into customer pricing and margin calculations. A single tariff change can touch every level of the cost hierarchy.

Second, tariffs often affect some products and suppliers but not others. A useful simulation must be able to apply the change selectively, not as a blanket percentage increase across all inputs.

Third, the response to a tariff change often involves evaluating alternatives. Can you source from a different country? Can you substitute a different material? Can you absorb the cost increase on some products and pass it through on others? Each alternative requires its own simulation, and the ability to compare outcomes across all of them.

Beyond Tariffs: The Broader Case for Scenario Planning

While tariffs make the headlines, the need for simulation-ready costing extends to every cost variable in the business. Consider these common scenarios that manufacturers face:

Labour cost changes: A new collective bargaining agreement increases wages by 4%. What is the actual impact on product costs, and which products are most affected?

Energy price volatility: Natural gas prices have doubled. For an energy-intensive manufacturer, how does this change the competitive position of different product lines?

Volume shifts: A major customer increases their order by 30%. How does that volume change affect per-unit costs across the product range, considering capacity utilisation effects?

Make vs. buy decisions: Outsourcing a subcomponent is quoted at a certain price. But what is the true internal cost when all relevant overheads are properly allocated?

Each of these scenarios requires the same capability: the ability to change inputs and see the impact on outputs quickly, accurately, and transparently.

Moving from Reactive to Proactive

The shift from static costing to simulation-ready costing is fundamentally a shift from reactive to proactive management. Instead of waiting for the next disruption and then scrambling to understand the impact, companies with simulation capabilities can prepare in advance, evaluate options calmly, and make decisions based on data rather than urgency.

The starting point does not need to be complex. A well-structured cost model, built on a solid methodology like TDABC and fed with accessible data, can deliver simulation capabilities that transform how a manufacturing company responds to change.

The next tariff announcement is coming. The next commodity price shock is coming. The question is whether your costing model is ready for it.

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