Food cost calculator.
The free food cost calculator for restaurants. Enter beginning inventory, purchases, ending inventory, and food sales to get COGS and food cost percentage instantly. Used by independent operators tracking weekly margin.
Total value of all stock at the start of the period
Invoices received during the period
Total value of stock at the end of the period
Revenue from food sales during the period
COGS
$0.00
Food cost %
—
Status
—
Formula: (Beginning + Purchases − Ending) ÷ Sales × 100. Industry-typical range is 28–35%. Above 35% usually signals waste, portioning issues, or price creep.
Want this calculated for you automatically?
Choose your planBy Jeremy Dudet, founder of Stockcount · Last updated 2026-05-19
How to calculate food cost percentage
Food cost percentage is the share of your food revenue that gets consumed by ingredient cost. It is the single most important number in a restaurant’s kitchen P&L. The formula is four inputs and one division.
Food cost % = (Beginning Inventory + Purchases − Ending Inventory) ÷ Food Sales × 100
What the numbers mean
- Beginning inventory: the dollar value of every ingredient and beverage on your shelves at the start of the period (week, month, quarter).
- Purchases: every dollar you spent on food during the period: invoices from produce, protein, dairy, dry goods, beverage, and any cash purchases.
- Ending inventory: the dollar value of everything still on your shelves at the end of the period.
- Food sales: revenue from food only. Don’t include beverage, retail, or catering unless you’re calculating a combined number.
Worked example: a 90-seat restaurant
Say your kitchen opens the week with $8,400 in inventory. You receive $11,200 in food invoices Monday through Friday. Friday night’s count puts the walk-in, dry storage, and prep room at $9,100. The week’s food sales close at $32,500.
COGS = 8,400 + 11,200 − 9,100 = $10,500
Food cost % = 10,500 ÷ 32,500 × 100 = 32.3%
32.3% sits in the healthy full-service range. If the same kitchen ran 38% the following week with similar sales, the swing is roughly $1,800 of margin, usually traceable to a vendor price jump, a count error, or waste in one category.
What’s a good food cost percentage?
Under 28%: strong margin. Common in cafés with high-margin beverages or concepts with deliberate premium pricing.
28–35%: typical industry range for full-service restaurants. Most profitable FSRs sit at the low end of this band.
Above 35%: too high. Usually means waste, theft, portioning issues, or price creep that hasn’t been passed through to the menu.
Common mistakes that wreck this number
- Mixing in beverage. Food and beverage have different margins. Run them separately and you’ll catch a beer-cost problem that food cost would hide.
- Skipping the prep room. An accurate count requires counting where the ingredients are, not just the walk-in. Pars on the line, dressings on the rack, proteins in the marinade tubs.
- Estimating partial cases. “About half a case” for ten different SKUs adds up to real money. Count partials by unit (bottles, bags, lbs), not by feel.
- Letting the count slip a day. If you count Monday morning instead of Sunday close, you’re mixing the new week’s deliveries into the old week’s ending number. The percent looks better than reality.
- Forgetting comps and waste. The formula assumes everything sold hit a guest check. Heavy comps, employee meals, and waste should be split out so you can see what real guest sales cost you.
Food cost calculator vs Excel
The formula =((B1+B2-B3)/B4)*100 works in any spreadsheet. The reason to use this calculator instead is the health-check: the moment you enter your numbers, you see whether 32% means “fine” or “investigate” without having to remember the industry benchmarks. If you want the long-form guide, how to calculate food cost percentage walks through the formula step by step.
Why this number is wrong half the time
The formula is correct. The inputs are usually not. Beginning and ending inventory require an accurate count. Most operators rush through counts or skip categories, which turns a real number into a confidence estimate. That’s the single biggest reason food cost drifts unnoticed.
Voice counting and automatic invoice parsing fix both inputs at the source, which is why Stockcount recalculates this number live instead of showing it to you once a month.
Frequently asked questions
- What is a good food cost percentage?
- Most full-service restaurants run a food cost between 28% and 35%. Under 28% is strong margin (common in cafés and concepts with deliberate premium pricing). Above 35% usually signals waste, theft, portioning issues, or menu prices that have not kept up with vendor cost increases.
- How do I calculate food cost percentage?
- Food cost % = (Beginning Inventory + Purchases − Ending Inventory) ÷ Food Sales × 100. The top of the equation is your Cost of Goods Sold (COGS). Divide COGS by food revenue for the period to get the percentage.
- Is this food cost calculator free?
- Yes. Completely free. No signup, no email gate, no watermark, no usage limits. The calculator runs in your browser. If you want it calculated continuously from voice counts and invoice scans instead of by hand, Stockcount starts at $19/month.
- How often should I run this calculation?
- Weekly is the operator standard. Monthly is too late to fix anything. Daily is overkill unless you are actively debugging a variance. A weekly cycle catches drift while it is still small enough to trace to a cause.
- Can I use this calculator for a bar or for beverage cost?
- Yes. The formula is the same. Use beginning beverage inventory, beverage purchases, ending beverage inventory, and beverage sales. For more bar-specific math (pour cost, beer cost, cocktail cost) use the pour cost calculator.
- Does it work in Excel or Google Sheets?
- The formula does, yes. Copy =((B1+B2-B3)/B4)*100 into any spreadsheet. The advantage of this calculator over a sheet is the built-in health-check (28-35% range, color-coded status) so you do not have to remember what number is good.
- Why is my food cost different from theoretical?
- Theoretical food cost is what your menu mix should cost given your recipes. Actual food cost (this calculator) is what your inventory and sales actually produced. The gap between them is your variance, usually some combination of waste, over-portioning, theft, comps, or recipe inaccuracy.
Related calculators
Recipe cost calculator
Cost out a single dish by ingredient and yield.
Open calculator →
Menu pricing calculator
Price a menu item against a target food cost percentage.
Open calculator →
Pour cost calculator
Beverage, cocktail, beer, and liquor cost in one place.
Open calculator →
Labor cost calculator
Track labor % alongside food cost for full prime cost.
Open calculator →
Stop calculating this by hand.
Stockcount tracks beginning inventory, purchases, and ending inventory continuously from voice counts and invoice scans. Your food cost % updates itself.