Start free

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.

Example: average inventory $6,000, monthly COGS $24,000 → 6,000 ÷ 24,000 × 30 = 7.5 days.
Days on hand calculator

Days on hand: —

Step by step

  1. Average inventory = (beginning inventory + ending inventory) ÷ 2, at cost.
  2. COGS for the same period = beginning + purchases − ending.
  3. 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

CategoryAverage inventoryMonthly COGSDays on hand
Fresh food$1,800$13,5004.0
Dry goods$2,200$5,50012.0
Beer$1,100$3,30010.0
Liquor and wine$6,400$7,20026.7
Total$11,500$29,50011.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

Worked example: a bar brings liquor and wine from 26.7 to 18 days on hand by cutting pars on slow bottles. Average inventory drops from $6,400 to about $4,320: roughly $2,000 freed in cash, with the same sales.

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.

Worked example: a bar has 9 bottles of a gin, received 6 last week and has 9 now after starting with 7: usage = 7 + 6 − 9 = 4 bottles in 7 days, about 0.57 a day. Days on hand = 9 ÷ 0.57 ≈ 16 days. With a weekly delivery, a par of about 6 bottles would be enough.

Sorting items by days on hand after every count is a quick way to see where money is sitting and which pars to lower.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Restaurant inventory turnover: formula and industry average Par level: meaning, formula and calculator Safety Stock Formula: Calculation and Example Dead Stock: Meaning, Cost and What to Do All guides

Frequently 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.