What Is Automated Cost Propagation and Why CPG Brands Need It

Here is a scenario that every CPG operator has lived through. Your vanilla extract supplier sends a price increase notice: the cost is going up 20%, effective next month. You know this affects your margins, but you are not sure by how much. You have six SKUs that use vanilla. They sell through three channels. You need to know: which SKUs are now unprofitable? Do you need to raise prices? Which channel gets hit hardest?

To answer those questions manually, you have to open each BOM, update the vanilla cost, recalculate the total BOM cost, update the COGS for each SKU, then rebuild the channel P&L for each SKU across each channel. If you have six SKUs and three channels, that is 18 separate calculations, each dependent on the previous one being done correctly. It takes hours. And the moment another ingredient changes, you start over.

Automated cost propagation means the system does all of that the moment the new price is entered. You see the updated COGS and channel margins for every affected SKU instantly.

What Cost Propagation Actually Does

Cost propagation is the process of traversing the dependency graph from a raw material price change all the way to the final net margin calculation. The dependency graph looks like this:

Raw Material Price Change
  → Ingredient Landed Cost (tariffs, FX, freight)
    → BOM Cost (usage quantity x ingredient cost)
      → Finished Good COGS (BOM + co-packer fee + overhead)
        → Channel Net Margin (COGS vs. net revenue per channel)

Each step in this chain depends on the step before it. If any step is stale, every downstream calculation is wrong. Automated cost propagation means the system maintains these dependencies and recalculates the entire chain whenever any input changes.

The Vanilla Example: 6 SKUs, 3 Channels, 18 Calculations

A functional beverage brand uses vanilla extract in six of their twelve SKUs. The SKUs include a vanilla protein shake, a vanilla oat milk, a vanilla collagen drink, a vanilla pre-workout, a vanilla recovery drink, and a vanilla kids' nutrition drink. Each sells through wholesale (UNFI), Amazon FBA, and Shopify DTC.

Vanilla extract costs $45/kg. The supplier announces a 20% increase to $54/kg. Here is what needs to happen.

Why This Matters More Than It Sounds

The reason cost propagation matters is not just efficiency. It is accuracy. When brands do this manually, they often do not do it at all, or they do it partially. They update the COGS for the SKUs they remember are affected and miss the ones they forgot. They update the wholesale channel margin but not the Amazon margin. They use a blended average cost instead of the actual new cost.

The result is that brands make pricing decisions, promotional commitments, and channel allocation decisions based on COGS numbers that are weeks or months out of date. A brand that committed to a scan promotion at Whole Foods in January based on a $2.20 COGS might not realize until March that the COGS is now $2.45 and the promotion is running at a loss.

The Dependency Graph: What Gets Recalculated

A full cost propagation system maintains a dependency graph that maps every ingredient to every BOM that uses it, every BOM to every finished good, and every finished good to every channel. When a price changes, the system resolves the graph in the correct order: ingredients first, then BOMs, then finished goods, then channels.

This ordering matters because some finished goods share sub-assemblies. A vanilla flavor base might be used in three different finished goods. The system needs to recalculate the flavor base cost first, then use that updated cost to recalculate each finished good that uses it. If the order is wrong, some calculations use stale inputs.

Guidance's cost propagation engine (built around the CP-1 and CP-2 equations in the core pipeline) resolves the full dependency graph in the correct topological order every time a price changes, ensuring every downstream calculation is based on current inputs.

Variance Learning: When Actual Costs Differ from Standard

Cost propagation handles planned price changes. But what about unplanned variances? A co-packer runs a batch and the actual yield is 94% instead of the standard 96%. The actual COGS for that lot is higher than the standard COGS. A system with variance learning captures that actual yield, calculates the variance, and updates the standard cost assumption for future production runs.

Over time, a system with variance learning produces increasingly accurate standard costs because it is learning from actual production data rather than relying on estimates that were set when the product was first launched.

Frequently Asked Questions