Inventory Days on Hand: Formula and Benchmarks
By mise · Updated October 7, 2026
Quick answer: days on hand = average inventory ÷ COGS × days in period (or 365 ÷ turnover). It shows how many days your current stock would last. Restaurants typically hold 4–8 days of food and 2–4 weeks of liquor.
Days on hand turns inventory into time: how long your money sits on the shelf.
Days on hand: —
Step by step
- Average inventory = (beginning inventory + ending inventory) ÷ 2, at cost.
- COGS for the same period = beginning + purchases − ending.
- Days on hand = average inventory ÷ COGS × number of days in the period.
Use the same period for both numbers (a week, a month or a year) and the matching number of days.
Calculate it by category
| Category | Average inventory | Monthly COGS | Days on hand |
|---|---|---|---|
| Fresh food | $1,800 | $13,500 | 4.0 |
| Dry goods | $2,200 | $5,500 | 12.0 |
| Beer | $1,100 | $3,300 | 10.0 |
| Liquor and wine | $6,400 | $7,200 | 26.7 |
| Total | $11,500 | $29,500 | 11.7 |
The total (11.7 days) mixes very different categories. Fresh food at 4 days is moving; liquor and wine at almost 27 days is where most of the money sits. Days on hand by item, after each count, shows which bottles or products to stop re-ordering.
What to do with the number
- Too many days: lower par levels, order smaller and more often, and look for dead stock.
- Too few days: you are close to running out; check safety stock on best sellers.
- Compare with the delivery cycle: if a supplier delivers twice a week, holding three weeks of that supplier's products is cash on the shelf.
Days on hand per item after a count
For a single item, days on hand = quantity on hand ÷ average daily usage. Average daily usage comes from two counts: (last count + received − this count) ÷ days between counts.
Sorting items by days on hand after every count is a quick way to see where money is sitting and which pars to lower.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.
Start freeFrequently asked questions
Days on hand vs turnover?
Two views of the same thing: DOH = days ÷ turnover.
What is a good days on hand for a restaurant?
About a week for food; liquor is often 2–4 weeks.
Is lower always better?
No: too low means stockouts.
How do days on hand and turnover relate?
Days on hand = days in the period ÷ turnover. A monthly turnover of 5 means about 6 days on hand in a 30-day month.
Should days on hand use cost or retail values?
Cost. Inventory and COGS are both at cost; mixing in selling prices distorts the result.
What is the difference between days on hand and days of cover?
They are the same idea: how many days current stock would last at the usual rate of use.
Can I try mise for free?
Yes. You get a free trial, with no card needed.
