This worksheet from Silvermoor Business Loans in Napa, California walks through the food cost percentage formula with a worked, invented example. It is arithmetic, not an offer or advice.
Food Cost Percentage Formula Calculator: Inputs Restaurant Owners Already Have
The formula uses four figures most kitchens already track:
- Beginning inventory: the dollar value of food on hand at the start of the period, from the last count.
- Purchases: food bought during the period, from supplier invoices.
- Ending inventory: the value of food on hand at the end of the period, from a new count.
- Food sales: food revenue for the period, from the POS, without drinks if the bar is tracked separately.
Food cost = beginning inventory + purchases − ending inventory. Food cost percentage = food cost ÷ food sales × 100. Count inventory the same way each time, on the same day of the week, or the result moves for reasons that have nothing to do with the kitchen.
An Invented Napa, CA Bistro Month, Worked Through the Formula
Illustration only, invented figures: a Napa, CA bistro starts the month with $18,400 of food on hand, buys $41,700 during the month, and counts $16,900 at the end. Its food cost is $18,400 + $41,700 − $16,900 = $43,200. Food sales for the month were $138,000, so the food cost percentage is $43,200 ÷ $138,000 × 100 = 31.3% (our arithmetic).
| Line | Amount |
|---|---|
| Beginning inventory | $18,400 |
| Plus purchases | $41,700 |
| Less ending inventory | $16,900 |
| Food cost | $43,200 |
| Food sales | $138,000 |
| Food cost percentage | 31.3% |
In this invented case, the bistro spent about 31 cents of every food dollar on ingredients. Whether that is high or low depends on its menu and its own past months, which is the comparison that matters.
Reading the Food Cost Percentage Formula Calculator Result Before Food Orders
A large food order (a whole-animal buy, a case price on olive oil, a stock-up ahead of a banquet) raises purchases this month and should raise ending inventory too. If the food cost percentage jumps after a big order, check whether the stock was counted at the end of the month. A line of credit suits orders like these, drawn for the order and paid down as the food sells.
Business lines of credit sets out how draws and repayments on a line work.
Reading the Food Cost Percentage Formula Calculator Result Before a Dining-Room Remodel
A partner reading a remodel request looks at whether the restaurant can carry a new payment. Food cost is one line in that picture: a kitchen with a steady food cost percentage month to month shows control over its largest variable cost. Bring six to twelve months of the calculation, with the counts behind it, alongside the bank statements and the remodel bid.
Reading the Food Cost Percentage Formula Calculator Result Before Slow-Week Payroll
A short payroll week often follows a slow sales week, and food cost percentage can rise in the same week because spoilage and staff meals do not fall with sales. Reading both together shows whether the gap is a one-week dip or a pattern. A short dip fits a draw on a line of credit; a pattern points to menu or staffing changes before any funding. Working capital loans covers the payroll side.
What the Food Cost Formula Leaves Out of a Funding Decision
- It does not count labor, rent or utilities, which together with food decide whether the restaurant makes money.
- It does not separate waste, theft, comps and staff meals from food that was sold.
- It depends entirely on accurate counts; a skipped count makes the result meaningless.
- It says nothing about prices, menu mix or how sales will move next month.
Use it as one line in the picture, not the whole picture. Restaurant loans in Napa, CA and the request form are the next steps when the numbers point to a funding need.
By Silvermoor Business Loans · Updated
