Restaurant Inventory Turnover: Formula, Days on Hand and Waste

Inventory in a restaurant is cash that is slowly going off. Inventory turnover measures how fast you convert that stock into sales, and — read with a waste log — it tells you whether the walk-in is a working asset or a place where margin quietly disappears. This article covers the formula for a food business (which differs from the retail version), the interpretation, what moves the number, and the waste metric that should always sit beside it.

Definition and formula

Inventory turnover = cost of goods sold ÷ average inventory value, for the period.

Average inventory = (opening inventory + closing inventory) ÷ 2, using the stock counts at the start and end of the month.

The companion measure most operators find more intuitive is days of inventory on hand = days in period ÷ turnover.

Use cost of goods sold, not sales, in the numerator: inventory is valued at cost, so the ratio must be too. Use food and beverage separately if the bar carries deep stock (spirits, wine), because beverage turnover is naturally slower and will drag a blended figure down.

Worked example

A restaurant’s food inventory: $7,400 at the start of the month, $6,800 at the end. Cost of food sold for the month (opening + purchases − closing): $23,500.

• Average inventory = (7,400 + 6,800) ÷ 2 = $7,100
• Turnover = 23,500 ÷ 7,100 = 3.3 times per month
• Days on hand = 30 ÷ 3.3 ≈ 9 days

Nine days of food stock for a restaurant serving fresh produce and proteins is on the long side; it suggests over-ordering, slow-moving items, or dry goods bought in bulk that flatter the count. The next step is to look at turnover by category.

How to interpret it

There is no single right number. Fresh-led kitchens should turn food stock every few days; a bar with an aged-spirit list will turn in months and that is fine. The interpretation comes from the trend and from category detail:

• Turnover falling, sales flat → stock is building. Either ordering has drifted above par or a menu change left items without a home.
• Turnover rising sharply → good, unless it comes with 86’d items, emergency retail purchases or complaints. Very high turnover can mean stock-outs.
• Turnover fine, food cost rising → the problem is waste, portioning or theft, not stock levels. The two KPIs together isolate the cause.

Waste: the metric that belongs next to turnover

Waste % = recorded waste at cost ÷ sales × 100. Slow turnover produces waste (spoilage); fast turnover with poor prep planning also produces waste (over-prepping to be safe). Waste is only measurable if it is recorded, and the simplest system works: a sheet by the bin with four columns — spoilage, prep trim, plate waste, comps and staff meals — filled in at the end of every shift. One month of that log, by category, usually reveals a single item or a single process responsible for a large share of the total.

What moves inventory turnover

• Par levels and ordering discipline. Ordering from a par sheet tied to forecast covers rather than from the “usual order”.
• Delivery frequency. Two smaller deliveries a week turn stock faster than one large one, if the supplier’s minimums allow it.
• Menu length and cross-utilisation. Ingredients used in one dish only sit; ingredients used in five move.
• Bulk buying. Volume discounts lower unit cost and raise stock; the trade-off is only positive if the item genuinely turns.
• Storage and rotation. First-in-first-out labelling, dated containers, and a walk-in that is organised so the oldest stock is in front.
• Counting accuracy. An inconsistent count makes turnover meaningless; same day, same method, same person if possible.

Practical actions

1. Count monthly at minimum; count high-value items weekly. Proteins, seafood, cheese and spirits are where the money is.
2. Set par levels per item from the last eight weeks’ usage, and order to par, not to habit.
3. Run the waste log for 30 days and act on the top category before adding any other system.
4. Review slow movers monthly: anything with more than two weeks on hand needs a home on the menu, a special, or removal from the order guide.
5. Calculate turnover by category (produce, protein, dairy, dry goods, beverage) at least quarterly — a blended number hides the problem category.

Limitations

Turnover depends entirely on the quality of two stock counts, and a single missed shelf can swing it. It is a monthly KPI in practice; weekly counts of everything are rarely sustainable in an independent kitchen. It also cannot distinguish healthy dry-goods stock from rotting produce without category detail, and a good ratio does not by itself prove low waste. Use it as one of a pair — turnover plus recorded waste — and always alongside food cost percentage, which is where any inventory problem eventually shows up.

Related restaurant KPIs

Inventory turnover and waste are the stock-control KPIs in the restaurant KPI framework. They explain movements in food cost, they affect the cash tied up in the business, and through COGS they shape gross margin. The generic inventory turnover guide covers the ratio for other business types.