Skip to content
Inventory

Restaurant Inventory Turnover Calculator

Measure how efficiently restaurant inventory turns over using COGS or food usage, average inventory, and days of inventory on hand.

Inventory turnover

Formula
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
Inventory Turnover = COGS (or Food Usage) ÷ Average Inventory
Days of Inventory = Period Days ÷ Inventory Turnover

What it means

Average the stock you started and ended with. Divide period usage (COGS or food usage) by that average to get turns. Divide the period length by turns to see how many days of stock you typically hold.

Good to know

  • Beginning and ending values use the same costing method (FIFO, weighted average, etc.).
  • COGS or food usage covers the same period as the inventory counts.
  • Period lengths: weekly 7, monthly 30, quarterly 90, yearly 365 days.

Ideal range

  • Does not separate categories (produce vs dry goods) — overall figures can hide slow movers.
  • One snapshot pair cannot show mid-period spikes; use consistent count cadence.

Variables

Average InventoryMean stock value
Simple average of beginning and ending inventory dollars.
Inventory TurnoverTurns in the period
How many times you sold or used through your average stock during the period.
Days of InventoryDays on hand
Approximate days of stock at the current turn rate. Lower is usually better for perishables.

Worked examples

Real numbers through the same formula this tool uses.

  1. 1
    Restaurant scenarioExample 1

    Monthly COGS turnover

    Begin $8,000, end $6,000 → average $7,000. COGS $28,000 → 4.0 turns and 7.5 days on hand (excellent).

  2. 2
    Restaurant scenarioExample 2

    Weekly food usage

    Flat $5,000 stock with $5,000 weekly usage → 1.0 turn and 7 days on hand.

  3. 3
    Restaurant scenarioExample 3

    Slow annual turns

    Average $20,000 with $80,000 annual COGS → 4.0 turns and ~91 days on hand (critical).

How to use this calculator

Turn two inventory counts and period usage into turnover and days on hand.

  1. Choose COGS or food usage

    Use COGS when you have a P&L figure; use food usage when you track beginning + purchases − ending.

  2. Enter beginning and ending inventory

    Use the same valuation method for both counts in the period.

  3. Enter COGS or food usage for that period

    Match the period length (week, month, quarter, or year).

  4. Read turnover, days on hand, and the benchmark

    Faster turns and fewer days on hand usually mean healthier restaurant stock.

What is inventory turnover?

Inventory turnover shows how many times you move through average stock in a period — and how many days that stock typically lasts.

  • Turns and days on hand

    Turnover = usage ÷ average inventory. Days of inventory = period days ÷ turnover. Faster turns usually mean fresher food and less cash on shelves.

  • Why inventory turnover matters

    Slow stock raises spoilage and storage cost. Overly aggressive turns can cause stockouts. The goal is a healthy middle for your concept.

  • Restaurant inventory benchmarks

    Many operators aim for roughly 7–14 days of overall food inventory. Produce turns faster; dry goods and liquor slower. Compare to your own history first.

  • Formula in plain language

    Average your beginning and ending counts. Divide period COGS or food usage by that average. Then convert turns into days using the period length.

Best practices

Habits that keep turnover numbers trustworthy.

  • Use one costing method

    Beginning and ending values must share FIFO, weighted average, or another consistent method.

  • Match usage to the count period

    Weekly counts need weekly usage. Mixing a month of COGS with a week of counts invents false turns.

  • Review slow categories separately

    Overall turns can look fine while produce or specialty items age. Break out high-spoilage groups.

  • Pair with food cost %

    Turnover shows velocity; food cost % shows margin. Use both after each inventory period.

Common mistakes

Errors that distort inventory turnover.

  • Using purchases instead of usage

    Purchases ignore stock still on the shelf. Prefer COGS or beginning + purchases − ending.

  • Inconsistent count cadence

    Irregular snapshots make trends noisy. Count on a fixed weekly or period-end schedule.

  • Wrong period length

    Selecting yearly while entering monthly COGS understates days on hand dramatically.

  • Ignoring shrink and waste

    Turns look healthier when waste is not recorded. Track waste so usage reflects reality.

Related tools and guides

Connect turnover to food cost, plate cost, and prime cost. Future inventory tools will deepen this cluster.

  • Food Cost Percentage Calculator

    Measure food cost ÷ food sales for the period.

  • Recipe Cost Calculator

    Build recipe cost from ingredients and yield.

  • Plate Cost Calculator

    Roll portion and accompaniments into plate cost.

  • Prime Cost Calculator

    Combine food and labor into one controllable-cost view.

  • Gross Profit Calculator

    See gross profit and food cost from revenue and cost.

  • Restaurant Inventory Days Calculator

    Estimate days on hand from current stock and daily usage, or from COGS-period counts.

  • Restaurant Food Waste Calculator

    Estimate waste %, period cost, and annual losses from purchases or inventory loss.

  • Restaurant Reorder Point Calculator

    Calculate when to reorder from daily usage, lead time, and safety stock.

  • Restaurant Safety Stock Calculator

    Size buffers from max-min demand or demand variability and service level.

  • Coming in this cluster

    EOQ, Inventory Valuation, Stock Usage, and Purchase Order calculators are planned next.

Frequently asked questions

You may also need

Complementary calculators that often pair with this workflow.

Continue exploring

More tools to browse after you finish this calculation.

Guides from the Learning Center that explain this topic.

Browse all guides in the Learning Center.