Inventory Turnover Calculator
Enter your cost of goods sold and average inventory value to see how many times your stock turns over — and how many days of stock you are holding.
What inventory turnover measures
Inventory turnover tells you how many times you sell through and replace your entire stock during a period. It is one of the clearest signals of whether your ordering is disciplined, and it connects two things operators usually track separately: food cost and cash flow.
Average inventory is simply opening plus closing divided by two. Using a single point-in-time figure will mislead you, because inventory levels swing sharply around delivery days.
The more intuitive version of the same number is days on hand — how many days of trading your current stock would cover.
A restaurant turning stock 2.5 times in a 30-day month is holding 12 days of inventory. That is money sitting in a walk-in rather than in your bank account, and every day it sits there is a day it can spoil, get damaged, or quietly walk out of the building.
What good looks like
| Category | Typical days on hand | Notes |
|---|---|---|
| Fresh produce | 1–3 days | Daily or alternate-day delivery; spoilage risk dominates. |
| Fresh proteins, dairy | 3–7 days | Highest value at risk; tightest control justified. |
| Frozen items | 10–21 days | Low spoilage risk, but freezer space and cash still cost. |
| Dry goods, tinned | 14–30 days | Cheap to hold; bulk discounts often worth the cash. |
| Wine and spirits | 30–60 days | Deliberately slow. Range breadth matters more than turnover. |
| Whole operation blended | 7–14 days | The figure this calculator returns. |
A blended figure of 7–14 days suits most full-service restaurants. Quick-service operations with narrow menus often run tighter. A bar-led business will look slower purely because of its spirits inventory, and that is not a fault — it is the nature of the stock.
This is why a single blended number is a starting point rather than an answer. If yours looks slow, break it down by category before acting, because the fix for slow produce and the fix for slow spirits are entirely different conversations.
Why turnover that is too high is also a problem
Most guidance treats higher turnover as automatically better. It is not. Below roughly five days on hand, an operation is usually buying trouble.
- Stockouts and 86'd items. Lost sales and disappointed guests cost far more than the cash freed by carrying less stock.
- Emergency purchasing. Buying at retail because you ran out destroys the margin on every dish that ingredient touches.
- Lost bulk pricing. Ordering little and often forfeits volume discounts and increases delivery charges.
- Staff time. More frequent deliveries mean more receiving, checking, and putting away — labor that does not show up in your inventory figure.
The goal is not maximum turnover. It is the lowest stock level that reliably avoids stockouts, which is precisely what a properly calculated par level is designed to find.
Turnover, food cost and cash
Slow turnover shows up in your accounts twice, which is why it deserves more attention than it usually gets.
First, in food cost. Stock held too long spoils, gets damaged, or expires. That loss lands in your food cost percentage as cost with no corresponding sale, indistinguishable from food you actually sold. Operators chase a rising food cost for months without realising the cause is sitting in the store room.
Second, in cash. Inventory is cash you have already spent and cannot spend again. A restaurant carrying $12,000 of stock when $7,000 would do has $5,000 unavailable for rent, wages, or anything else. This is a large part of why profitable restaurants run short of money.
An operation running $1,600 of daily COGS at 14 days on hand, moving to a target of 9 days, releases $8,000 of cash. That is a one-off release rather than an ongoing saving, but it is real money and it requires no additional sales to obtain.
How to improve turnover
- Set par levels from actual usage data rather than instinct. This is the single highest-impact change and it addresses the root cause rather than the symptom.
- Increase delivery frequency on perishables. Two smaller deliveries a week hold roughly half the stock of one large one, with no change in what you sell.
- Count consistently. Same day, same time, same method. Inconsistent counting produces turnover figures that swing for reasons unrelated to your ordering.
- Identify dead stock. Every store room accumulates items bought for a special that never sold. Find them, use them or write them off, and stop the same thing recurring.
- Cross-utilise ingredients. Something used in three dishes turns faster than something used in one.
- Question bulk deals on perishables. A 15% discount is worthless if you discard 20% of the order.
- Review the menu for slow movers. A dish selling twice a week that needs its own dedicated perishable ingredient is a turnover problem disguised as a menu item.
Track turnover monthly alongside food cost. Turnover moves before food cost does, which makes it a useful early warning that your ordering discipline is slipping.
Frequently asked questions
How do you calculate inventory turnover for a restaurant?
Divide cost of goods sold for the period by average inventory value, where average inventory is opening plus closing divided by two.
What is a good inventory turnover for a restaurant?
Most full-service restaurants target a blended 7–14 days on hand, which is roughly 2–4 turns per month. Bar-led operations look slower because spirits deliberately turn slowly.
Can inventory turnover be too high?
Yes. Below about five days on hand you risk stockouts, emergency purchasing at retail prices, lost bulk discounts, and extra receiving labor. The aim is the lowest level that reliably avoids running out.
Should I calculate turnover by category?
Yes, once the blended figure tells you something is wrong. Produce, proteins, frozen, dry goods and alcohol have completely different natural rates, so a blended number hides which category is actually slow.
How does inventory turnover affect food cost?
Slow turnover means stock sits longer and more of it spoils or expires. That loss enters COGS with no matching sale, so it raises food cost percentage without any obvious cause.
How often should inventory turnover be measured?
Monthly is sufficient for the trend, provided you count consistently. Weekly counting for high-value categories gives earlier warning without the effort of a full count.
Does inventory turnover include alcohol?
It can, but mixing it with food distorts the picture badly because spirits turn far more slowly by design. Calculate food and beverage separately.