How to Find Food SKUs Losing Margin After Ingredient Costs Rise
Cases are moving, but the weekly margin is down. Start with the products using ingredients whose prices changed, then check what sales actually realized after credits.
What to pull
Use an Excel sales and recipe-cost workbook, or export invoice lines and credits from accounting, recipe quantities from production, and ingredient cost history from purchasing.
How to check it
Compare the same sales unit and periods. Use the appropriate effective ingredient costs and separate packaging and labor where available. Flag missing recipes and credits without SKU references.
Which SKUs lost the most margin from ingredient cost changes? Show price, cost, volume and source rows.
What to do with the result
Review high-volume items with repeat declines before changing prices. Give purchasing and sales the ingredient and SKU rows behind each change.
Use approved cost and margin definitions and verify credits before acting.