Rolling Average Cost: Know the True Cost of Every Ingredient, Every Day
- Amiya
- 22 hours ago
- 3 min read
Your chicken breast was $2.80/lb last week and $3.10/lb this week. Your olive oil jumped $4 in a single delivery. Ingredient prices shift with every invoice, and if you're using the last price you paid to calculate food cost, your margins are based on a number that's already outdated. Rolling average cost solves this by giving you a stable, accurate cost for every ingredient - updated automatically as new invoices come in. Here's how it works and why it matters for your bottom line.
Why does the same ingredient have a different price on every invoice?
Distributors adjust pricing constantly based on market conditions, seasonal availability, and order volume. Your case of tomatoes might cost $22 on Monday and $25 on Thursday from the same supplier. If you're tracking food cost using just the most recent invoice price, a single expensive delivery can make your entire menu look unprofitable overnight - even though your actual average cost over the month is much lower. Every new invoice can carry a different price for the same ingredient, and relying on any single invoice gives you a distorted picture of what you're truly paying.
What is rolling average cost and how does it work?
Rolling average cost takes the prices you've actually paid for an ingredient across your last four weeks of purchases and averages them — weighted by quantity. So if you bought 100 lbs of chicken at $2.80 and then 50 lbs at $3.10, your rolling average isn't simply $2.95. It's weighted toward the larger purchase, giving you $2.90. This average updates automatically every time a new invoice is processed. The result is a stable, reliable cost for every ingredient that smooths out the noise of individual deliveries while still reflecting real market movement.
Why does the average cost change from month to month?
Because the market changes. The average price of an ingredient in January can look very different from February. Produce costs spike in winter, protein prices fluctuate with supply chains, and distributor promotions create temporary dips. A four-week rolling window captures these shifts gradually rather than all at once. You'll see your average cost for salmon slowly climb from $12.40 in January to $13.10 in February rather than a sudden jump on a single invoice. This gives you time to adjust — renegotiate with your supplier, tweak your portion size, or update your menu pricing before margins erode.
How does rolling average cost help me know my true menu item cost?
This is where it all comes together. On any given day your restaurant makes a sale, Cactus uses the rolling average cost of every ingredient in that dish to calculate your actual food cost for that day. Not last month's cost. Not the cost from your most recent delivery. The cost that reflects what you've actually been paying over the past four weeks. So when you sell a grilled salmon plate on a Tuesday, the food cost tied to that sale reflects the true average cost of salmon, asparagus, lemon, butter, and every other ingredient - as of that Tuesday. This means your daily food cost percentage is accurate and actionable, not a lagging estimate.
How does Cactus calculate this automatically?
Every time you upload or email an invoice to Cactus, the system extracts the ingredient, quantity, and price. It then recalculates the rolling average cost for that ingredient across the trailing four-week window. When your POS data flows in through Bill Fetch, Cactus matches each menu item sold to its recipe, applies the current rolling average cost for every ingredient, and gives you a real-time food cost for every dish and every day. No spreadsheets. No manual lookups. Just accurate food cost that updates itself.
How Cactus can help you with food cost tracking
Cactus helps you save time, reduce errors, and get real-time insights into your operations. Get full control of your food cost with automatic invoice processing, rolling average cost tracking, and daily margin visibility. Whether you run a single location or manage multiple restaurants, Cactus gives you the tools to track every dollar spent on ingredients — and turn that data into smarter purchasing, pricing, and menu decisions.
Learn more here:
DISCLAIMER: This information is provided for general informational purposes only, and publication does not constitute an endorsement. Cactus does not warrant the accuracy or completeness of any information, text, graphics, links, or other items contained within this content. Cactus does not guarantee you will achieve any specific results if you follow any advice herein. It may be advisable for you to consult with a professional such as a lawyer, accountant, or business advisor for advice specific to your situation.
