Restaurant Inventory Turnover: Formula, Count Routine, and Warning Signals

The Restaurant Inventory Turnover Formula

The basic formula is: Cost of Goods Sold (COGS) ÷ Average Inventory Value. For restaurants, COGS is your total food cost over a period (usually a month). Average inventory is (beginning inventory + ending inventory) ÷ 2. The result is a ratio—higher is better, but too high can mean stockouts.

Example: If your monthly COGS is $30,000 and average inventory is $10,000, your turnover is 3.0. That means you cycle through inventory three times per month, or about every 10 days.

• COGS = beginning inventory + purchases – ending inventory
• Average inventory = (beginning + ending) ÷ 2
• Turnover = COGS ÷ average inventory
• Days on hand = 30 ÷ turnover (or 365 ÷ annual turnover)

Why Turnover Matters for Cash Flow and Spoilage

Every dollar in inventory is a dollar not in your bank account. Low turnover ties up cash and increases the risk of spoilage, theft, or obsolescence. High turnover (relative to your concept) means fresher ingredients and less waste. The sweet spot varies by cuisine—fine dining may target 2-4 turns per month, while fast casual might aim for 4-6.

Tracking turnover by category (produce, dairy, dry goods, protein) reveals which areas need attention. A sudden drop in a category’s turnover often signals over-ordering, a menu item decline, or a supplier issue.

Weekly Count Routine for Accurate Data

Accurate turnover starts with consistent counts. A weekly partial count of high-value or high-spoilage items is more practical than a full monthly inventory. Here’s a simple workflow:

1. Choose a consistent day and time (e.g., Monday morning before deliveries). 2. Count every item in your walk-in, freezer, and dry storage. 3. Record quantities and unit costs. 4. Calculate category-level inventory value. 5. Update your inventory system immediately.

• Use a standardized count sheet or inventory app
• Train one person to count to reduce variation
• Spot-check high-cost items (proteins, seafood) weekly
• Reconcile counts with purchase orders to catch theft or waste

Category-Level Diagnosis: Where Is Your Cash Stuck?

Calculate turnover separately for each category: proteins, produce, dairy, dry goods, and frozen. A protein turnover of 2.0 (15 days on hand) might be fine for aged beef but terrible for fresh fish. Compare your numbers to industry benchmarks: produce should turn 4-6 times per month, dry goods 1-2 times.

If a category’s days on hand exceeds your typical shelf life, you’re over-ordering. Reduce order quantities, adjust par levels, or run a special to move slow stock.

• Produce: 4-6 turns/month (5-7 days on hand)
• Protein: 3-5 turns/month (6-10 days on hand)
• Dairy: 3-4 turns/month (7-10 days on hand)
• Dry goods: 1-2 turns/month (15-30 days on hand)

Warning Signals That Your Inventory Is Out of Control

Watch for these red flags: turnover dropping month-over-month, days on hand exceeding shelf life, frequent stockouts of key items, or a rising COGS percentage without a menu price change. Another signal is a high number of credit memos or waste logs—these indicate over-ordering or poor rotation.

If you see any of these, drill into the category. Check if a menu item’s popularity has changed, if a supplier changed pack sizes, or if your par levels are outdated.

How to Improve Your Inventory Turnover

Start by tightening your ordering process. Use par levels based on actual usage, not guesses. Implement FIFO (first in, first out) strictly. Cross-utilize ingredients across multiple menu items to reduce variety. Run daily specials to move surplus stock. And review your menu engineering—items with low contribution margin and low popularity may be dragging down turnover.

Also, negotiate with suppliers for smaller, more frequent deliveries if you have limited storage. This reduces average inventory without risking stockouts.

• Set par levels from 4 weeks of usage data
• Use FIFO labeling and train staff on rotation
• Create a ‘use first’ list for near-expiry items
• Review menu item popularity quarterly

Use RestaurantMargin Tools to Track and Improve

Manually tracking turnover is time-consuming and error-prone. RestaurantMargin’s free calculators help you compute your food cost, plate cost, and inventory turnover automatically. Our paid playbooks provide step-by-step systems to reduce prime cost and increase cash flow. Start with the free tools, then upgrade when you’re ready to scale.

Check out our food cost formula guide and plate cost calculator to get started. For deeper margin improvement, explore the restaurant margin playbooks.