Restaurant Food Cost & Variance Calculator
Calculate what food usage cost during a complete period, then compare it with theoretical cost if you have reliable recipe and sales data.
How to use this worksheet
- Use food sales and food inventory from the same reporting period. Keep beverage costs separate.
- Enter net purchases after credits. Adjust consistently for transfers and non-sales usage in your reporting.
- Theoretical cost is optional. It should reflect recipes and actual sales mix for this period, not a generic target.
Free to use. No registration. Inputs stay in your browser unless you choose to include your results with a demo request. Device saving is optional; avoid saving sensitive information on a shared device.
Your worksheet
What actual food cost percentage measures
Actual food cost percentage tells you how much of every food sales dollar went to the ingredients your kitchen used during a period. It measures usage, not purchasing. A big delivery on the last day of the month raises your purchases but not your usage, because most of that product is still on the shelf when you count.
The formula has two steps. First, food usage cost = opening inventory + purchases − closing inventory. Second, actual food cost % = food usage cost ÷ food sales × 100. Both numbers must cover the same dates, the same locations, and the same scope (food only, beverages tracked separately).
A worked example
Say your opening food inventory on the first of the month is $8,000. You buy $22,000 of food during the month, net of credits. Your closing count on the last night is $7,000. Food usage cost is $8,000 + $22,000 − $7,000 = $23,000.
If food sales for the same month were $70,000, actual food cost is $23,000 ÷ $70,000 = 32.9%. Now add theoretical cost. If your recipe costs and that month's sales mix say the menu should have run at 30%, the kitchen should have used about $21,000 of food. The gap is 2.9 percentage points, or roughly $2,000 of product that went somewhere other than a guest's plate at standard portions.
Actual versus theoretical food cost
Theoretical food cost is what you would have spent if every dish were made exactly to recipe, with no waste, comps, or errors. It comes from costed recipes multiplied by the items you actually sold. The difference between actual and theoretical is your variance, and variance is where most of the useful questions live. Common causes include:
- Waste and spoilage that nobody records
- Portions drifting above the recipe standard
- Staff meals, comps, and voids that are not logged
- Receiving errors, short deliveries, or credits never claimed
- Supplier price increases that have not reached your recipe costs
- Counting mistakes, such as cases counted as units or items missed in a second walk-in
What a good result looks like
There is no single right number. Many full-service restaurants report actual food cost somewhere around 28% to 35% of food sales, but the range moves with the concept. Pizza and fast-casual menus often run lower, while steak and seafood menus often run higher. Your own trend matters more than an industry average.
Pay closest attention to variance. A gap of a point or two is common and often hard to eliminate entirely. A gap that is larger, or that grows month after month, usually points to a process problem worth investigating before you change prices or suppliers.
Common mistakes and how often to calculate
Most bad food cost numbers come from the inputs rather than the math. Watch for mixing beverage and food purchases, using sales that include tax or tips, counting at different times of day each period, valuing inventory with old prices one month and new prices the next, and booking invoices dated outside the period.
Calculate at least monthly, lined up with your P&L. Weekly calculations are worth the effort when you are chasing a specific problem, rolling out a new menu, or running a high-volume kitchen where a bad week costs real money. Whatever cadence you choose, count at the same point in the day every time.
Let Edesia keep the records for you
The hard part of this calculation is keeping the inputs clean. Edesia tracks inventory (including lots), logs waste, records vendors and purchase orders, and compares distributor prices, so the counts, purchases, and losses behind your food cost are in one place when you sit down to review. Edesia costs $2 a day to operate.
See how Edesia worksRelated help and reading
Frequently asked questions
How do you calculate restaurant food cost percentage?
Add opening inventory and purchases, subtract closing inventory to get food usage cost, then divide by food sales for the same period and multiply by 100. For example, $23,000 of usage on $70,000 of food sales is a 32.9% food cost.
What is a good food cost percentage for a restaurant?
Many full-service restaurants land roughly between 28% and 35%, but it depends on the concept, price point, and menu mix. Compare your result with your own history and your theoretical food cost rather than relying only on an industry average.
What is the difference between actual and theoretical food cost?
Actual food cost comes from inventory counts and purchases, so it shows what the kitchen really used. Theoretical food cost comes from recipe costs and the sales mix, so it shows what the kitchen should have used. The gap between them is your variance.
Why is my actual food cost higher than theoretical?
The usual causes are unrecorded waste, over-portioning, comps and staff meals that are not logged, receiving errors, outdated recipe costs, and counting mistakes. Check the records first, then look at kitchen practices.
Should beverages be included in food cost?
Track them separately. Beverages, especially alcohol, usually have very different cost structures, and mixing them into food cost hides what is happening in the kitchen.
How often should I count inventory to calculate food cost?
At least once per accounting period, usually monthly, at a consistent time and with consistent units. Many operators count high-value items such as proteins weekly to catch problems sooner.