Calculate cost of goods
Calculate the cost of goods used and the food cost ratio for one month at your restaurant.
Stock and purchases in euros excluding VAT, valued consistently. Book returns and transfers to the right goods category.
Your food cost ratio
Calculate cost of goods: opening stock plus purchases minus closing stock
Cost of goods = opening stock + purchases − closing stock. The result is the value of goods used in the period. Stock and movements must be valued with one consistent method and assigned to the right period.
€8,000 opening stock + €22,000 purchases − €6,000 closing stock gives €24,000 of goods used. So a big stock purchase doesn't automatically mean higher usage.
Calculate food cost ratio
Food cost ratio = cost of goods used ÷ net revenue × 100. With €24,000 of goods used and €80,000 net revenue, the ratio is 30 percent. Both calculations are model examples, not customer or industry figures.
For a food ratio, use food usage and food net revenue; for beverages, the matching beverage figures. Don't set one goods category against the revenue of the whole restaurant.
Purchases or usage: which figure do I enter?
If your usage already comes from a stocktake with a clean cut-off, enter it directly. Otherwise, choose the stock calculation. A purchase amount without a stock reconciliation only gives you a purchasing ratio.
The stocktake guide explains how to count stock. With the free inventory Excel template you can work out stock and usage for your period in a way anyone can follow.
What food cost ratio is normal?
Sales mix, recipes, purchase prices and concept determine the ratio. Instead of a generic traffic-light value, look at your own trend and the gap to your recipe costs. The target vs. actual cost of goods guide gives you formulas and the steps to check.
Up-to-date recipe costs and stocktakes are the foundation of Kiosa Inventory. For labor and goods together, use the Labor Cost Calculator and the prime cost guide.