Restaurant Inventory Turnover and Days on Hand: How to Calculate and Use Them
By Marji · Published · 7 min read
Inventory turnover is the food cost used in a period divided by average inventory value; days on hand is average inventory divided by average daily food cost. A kitchen that used $32,000 of food in a month and held $6,400 on average turned its stock 5 times, about 6 days on hand. Calculate both by category, not just in total.
The two numbers say the same thing in different units. Turnover tells you how many times the shelves were emptied and refilled; days on hand tells you how many days of cooking the shelves hold right now. Both measure the cash sitting in the walk-in and the time food spends waiting to be used — the time in which it can spoil, be over-portioned or go missing.
The formulas
Inventory turnover
Food cost used in the period ÷ average inventory value
Average inventory = (opening inventory + closing inventory) ÷ 2. Food cost used = opening inventory + purchases − closing inventory, the same period figure behind food cost percentage.
Days on hand
Average inventory value ÷ average daily food cost used
Equivalently, days in the period ÷ turnover. For stock on the shelf today, divide today's count value by average daily food cost.
These are the standard accounting ratios. OpenStax's Principles of Accounting defines inventory turnover as cost of goods sold divided by average inventory, and days' sales in inventory as average inventory divided by average daily cost of goods sold. It also names both failure modes: "Too little inventory means lost sales opportunities, whereas too much inventory means unproductive investment of resources as well as extra costs related to storage, care, and protection of the inventory."
Worked example: one month, one kitchen
Worked example · Hypothetical 30-day month, food only
- Opening inventory, counted and valued
- $6,100
- Food purchases received
- $32,600
- Closing inventory, counted and valued
- $6,700
- Food cost used: 6,100 + 32,600 − 6,700
- $32,000
- Average inventory: (6,100 + 6,700) ÷ 2
- $6,400
- Turnover: 32,000 ÷ 6,400
- 5.0 times
- Days on hand: 6,400 ÷ (32,000 ÷ 30)
- 6.0 days
Use cost, not sales, in both ratios. Inventory is valued at cost, so dividing sales by inventory mixes two measures and makes turnover look faster than it is.
Split the numbers by category
A kitchen-wide six days can hide two days of produce and twelve days of dry goods. The categories behave differently — different shelf lives, different delivery schedules, different cost to hold — so the useful view is one row per category, each measured against its own delivery cycle.
| Category | Food cost used | Average inventory | Turns per month | Days on hand |
|---|---|---|---|---|
| Produce | $5,400 | $360 | 15.0 | 2.0 |
| Meat and seafood | $12,600 | $1,680 | 7.5 | 4.0 |
| Dairy and eggs | $3,900 | $390 | 10.0 | 3.0 |
| Dry goods and canned | $6,300 | $2,520 | 2.5 | 12.0 |
| Frozen | $3,800 | $1,450 | 2.6 | 11.4 |
| Total | $32,000 | $6,400 | 5.0 | 6.0 |
Compare days on hand with the delivery cycle
When an item is ordered up to a par on a fixed schedule, stock runs from the par down toward the buffer and is then refilled. What a count should show therefore depends on when it is taken: just after a delivery, about one full cycle plus the buffer; the night before the next truck, about the buffer alone; mid-cycle, or averaged across the cycle, about half a cycle plus the buffer. Compare each category's days on hand with the figure for the point in the cycle when you counted.
Worked example · Meat and seafood, delivered twice a week, counted mid-cycle
- Delivery cycle
- 3.5 days
- Half a cycle of usage
- 1.75 days
- Buffer (from the par calculation)
- 0.5 days
- Expected at a mid-cycle count
- 2.25 days
- Actual, from the category table
- 4.0 days
- Average daily meat and seafood cost
- $12,600 ÷ 30 = $420
- Stock above what the schedule needs
- 1.75 days ≈ $735
The comparison assumes steady daily use, accurate counts and counts taken at the same point in the cycle. If these counts had been taken just after the truck, 4.0 days would be exactly one cycle plus the buffer — a par set correctly. Check the timing before you cut anything.
With mid-cycle counts, the likely cause is pars set from habit rather than usage. The par level guide rebuilds them from counted usage and the days each order must cover. Dry goods at twelve days is a different story: long shelf life and a low cost to hold can make it a reasonable choice, especially when a case price rewards buying more. What matters is that it is a decision, not an accident.
What high and low numbers usually point to
| Signal | Possible cause | What to check |
|---|---|---|
| Days on hand well above the delivery cycle | Pars copied from habit, bulk buys, slow-moving items | Rebuild pars from counted usage |
| Days on hand rising while sales are flat | Over-ordering, or stock that is spoiling rather than being used | Waste log and date-expired discards |
| Very fast turnover with frequent 86s | Pars too low, or late and short deliveries | Stockout dates against delivery records |
| Turnover jumps with no operational change | A change in how the count was valued, or a price move between counts | Valuation method and the prices used |
| One category drifts while the rest hold | A menu change, a new supplier pack or a portioning problem | The dishes using that category |
FIFO means two different things
In the kitchen, FIFO is rotation. The FDA Food Code 2022 (Annex 4) describes first-in, first-out as "the first batch of product prepared and placed in storage should be the first one sold or used", and notes that the date marking the Code requires for refrigerated, ready-to-eat TCS food facilitates a FIFO procedure. Rotation is what keeps days on hand from turning into discards: new deliveries go behind older stock, and a house rule of dating every container makes the order visible.
In the books, FIFO is a cost assumption. IRS Publication 538 explains that the FIFO method assumes the items purchased first are the first used, so closing inventory is matched with the costs of the most recent purchases. It adds that when prices are rising, FIFO produces a lower cost of goods sold and a higher closing inventory than LIFO. If you value a count at each item's latest invoice price, you are close to FIFO's assumption. Which method you use for tax is a question for your accountant; for weekly food cost, the rule is consistency, because a change in valuation moves turnover and food cost without a single case changing.
Count so the numbers mean something
- Count at the same point each period — after close on the same weekday is the easiest — and use the closing count as the next period's opening. The inventory count guide has the full procedure.
- Count every storage area, and keep bar inventory separate from food so a slow wine list does not hide a fast walk-in.
- Count in the unit you buy in, or one that converts exactly, and value each item at a consistent price basis.
- Leave non-food supplies out of food inventory, or track them in their own category.
- Record purchases by delivery date, so a delivery that arrives after the count is booked as next period's purchase rather than this period's usage.
Marji does not count inventory or calculate turnover; the count, the valuation and the period close stay in your own process. What Marji keeps is the accepted supplier price for each ingredient, which is the evidence a count valuation and a recipe cost both depend on. For the ordering side, the free par level calculator shows current days on hand for any item from its count and daily usage.
What is a good inventory turnover for a restaurant?
There is no single right figure; it depends on menu, storage and how often each supplier delivers. The better test is category by category: compare period-average days on hand with half a delivery cycle plus your buffer, or a shelf count taken just after a delivery with the full cycle plus the buffer, and ask whether the difference is a decision or an accident.
Should I use sales or food cost in the turnover formula?
Food cost. Inventory is valued at cost, so the numerator should be the cost of food used. Dividing sales by inventory multiplies turnover by sales ÷ food cost — 3.125 at a 32% food cost — so a kitchen that turns 5 times would appear to turn about 16.
Is days on hand the same as days of inventory?
Yes. Days on hand, days of inventory and days' sales in inventory all express inventory as days of usage at average daily cost. Use average inventory to describe a period, or today's count to describe the shelf right now.
How often should I calculate it?
At each period close you already count for food cost — weekly or monthly — and on the same basis every time. A single period is one reading; a trend over several is information.
Check days on hand for one item
Enter today's count, daily usage and delivery cycle for a single item. See its days on hand, its par and what to order.
Open the par level calculatorTerms this guide uses
Inventory turnover
How many times you sell through your average inventory in a period — a direct measure of how much cash is sitting on shelves.
Days on hand
How many days of normal usage your current stock represents.
FIFO (first in, first out)
Using oldest stock first — the rotation discipline that prevents most spoilage.
Read next
How to Set Restaurant Par Levels and Turn Them Into a Prep List
Set par levels from counted usage, the days each order must cover and your own busiest cycle, then turn them into a daily prep list capped by date-marking limits.
Ideal vs. Actual Food Cost: Which Inputs Explain the Gap?
Compare reviewed recipe costs and manually supplied dish counts with inventory-adjusted period food cost, then check invoice, unit, portion and timing evidence.
How to Calculate Food Cost Percentage: The Formula, a Worked Month and a Worked Dish
The food cost formula — beginning inventory plus purchases minus ending inventory, divided by food sales — worked for a month and for one dish, with what counts as food and the mistakes that skew it.