Price history and cost-impact analysis across your formulas

Ingredient prices move constantly — a supplier raises a quote, a commodity shifts, a currency swings. Each change ripples through every product that uses the ingredient, eroding or improving margins in ways that are invisible until you recompute. "This ingredient went up 15% — which of our products are now underwater?" is a question most manufacturers cannot answer quickly. Software that tracks price history and recomputes cost impact across formulas answers it instantly. Here is how.

The cost-impact blind spot

When an ingredient's price changes, the immediate question is its effect on your products — but in a manual setup, that effect is hidden. The ingredient is used in many formulas, each at a different inclusion level, so the same price rise hits each product differently. Working out the impact means recomputing every affected product's cost by hand, which rarely happens — so margins quietly erode and nobody notices until a product is unprofitable.

This blind spot is costly. Pricing decisions, supplier negotiations, and reformulation choices all depend on knowing the cost impact, yet it is exactly what manual costing fails to surface in time.

Where-used: which products are affected

The first piece is knowing where an ingredient is used. A where-used view shows every product and compound containing a given ingredient — so when its price changes, you immediately see which products are affected. No more wondering whether a price rise matters; you see the full list of products that use the ingredient and will feel the change.

This is the foundation of impact analysis: you cannot assess the impact of a price change without knowing where the ingredient is used, and the system tracks that automatically.

Cost impact, recomputed automatically

The second piece is recomputing the impact. Because product cost rolls up from ingredient prices, a price change can flow through to every affected product's cost automatically — showing the new cost and the change. So "this ingredient went up 15%" becomes "these eight products' costs rose by these amounts, and these two now have margins below target." The impact is quantified across the catalogue, instantly.

This turns a price change from an invisible margin erosion into a visible, actionable picture: exactly which products are hit, by how much, so you can respond — reprice, renegotiate, or reformulate.

Price history over time

Tracking price history — how an ingredient's cost has changed over time — adds the trend dimension. You can see which ingredients are drifting up, spot cost pressure building, and inform negotiations and forecasting with actual price movement rather than a single current number. Price history turns costing from a snapshot into a trend you can manage.

Better decisions across the board

With where-used, automatic cost-impact recompute, and price history, costing decisions get sharper. You negotiate from knowledge of which ingredients drive your costs and how they are trending; you respond to a supplier price rise knowing its exact impact; you reformulate with the cost consequence visible. The whole commercial side of formulation becomes data-driven rather than reactive.

Because cost data should reflect your actual suppliers and prices, confirm the figures for your specific situation rather than relying on a general summary.

Where Lemoniq fits

Lemoniq tracks where each ingredient is used and recomputes cost impact across every affected product when a price changes — so a price rise shows immediately which products are hit and by how much, including which now fall below margin targets. Price history captures how ingredient costs move over time, informing negotiation and forecasting. The cost-impact blind spot becomes a clear, instant picture across your catalogue.

The takeaway

An ingredient price change ripples through every product that uses it, eroding margins invisibly in a manual setup — because no one recomputes the impact across the catalogue. Software that tracks where ingredients are used, recomputes cost impact automatically, and keeps price history makes the effect of any price change instantly visible and actionable. Stop discovering margin erosion after the fact; see the impact the moment the price moves.

Lemoniq shows which products a price change hits and by how much, and tracks price history over time — so margin impact is instant, not invisible. We solve this exact problem. See how it works