Home » Procurement Cost Control » Inventory Turnover Ratio: Formula, Example and Real Targets

Inventory Turnover Ratio: Formula, Example and Real Targets

The inventory turnover ratio is your Cost of Goods Sold (COGS) divided by your average inventory for the same period. It tells you how many times you sold and replaced your stock.

What makes the answer vary is not the maths. It is what you are storing. A hardware shop and a kitchen can run the same ratio and one of them is throwing food away.

This post covers the formula, a worked example in rupees, and the one conversion that makes the number useful in a kitchen.

Key Takeaways

  • The ratio alone tells you little. Divide your days in the period by it and you get days on hand, which you can hold against how long the food keeps.
  • One kitchen-wide figure hides the problem. Produce and dry goods need separate numbers.
  • Measure it weekly. An annual figure is an accounting exercise, not an operating one.

What Is the Inventory Turnover Ratio?

The inventory turnover ratio counts how many times you cleared and rebuilt your stock in a period. This section covers what it measures and why two businesses with the same figure can be in very different health.

A ratio of 12 over a year means you sold through your average stock twelve times. Roughly once a month.

The number is a speed, not a score. Faster is usually better. Stock on a shelf is money you have already spent and cannot use.

But faster is not always better. Past a point it means you run out of things mid-service.

For anyone selling goods that do not spoil, that is the whole story. For a kitchen it is the start of one.

How Do You Calculate the Inventory Turnover Ratio?

The formula needs two numbers, and both come off reports you already produce. Here is where each one comes from.

Cost of goods sold ÷ Average inventory Turnover ratio Days in period ÷ ratio Days on hand
The second step is the one most guides leave out, and it is the one that makes the figure readable.

Both numbers come off reports you already run. Here is where each one sits.

Working Out Cost of Goods Sold

Cost of goods sold is what the stock you actually used cost you. Not what you bought, what you consumed.

The calculation is opening stock, plus everything you purchased, minus closing stock. Purchases alone will overstate it every time, because some of what you bought is still sitting on the shelf.

Our food cost calculator takes those same three figures if you would rather not do it by hand.

Working Out Average Inventory

Average inventory is your opening and closing stock values added together and halved. Our stock inventory template lays the two counts out side by side.

Use a real count, not a system figure, at least once. The two rarely match exactly. The gap is usually wastage nobody logged.

What Does the Inventory Turnover Ratio Look Like on Real Numbers?

Numbers make this quicker to follow than a formula does. Here is one quarter at a single outlet, worked from end to end.

Take a 60-cover restaurant in Aundh, Pune, looking at the July to September quarter (an example).

LineAmount
Opening stock, 1 July₹3,10,000
Purchases in the quarter₹18,00,000
Closing stock, 30 September₹2,70,000
Cost of goods sold₹18,40,000
Average inventory₹2,90,000

The turnover ratio is ₹18,40,000 divided by ₹2,90,000, which is 6.3.

Now the step that matters. The quarter is 92 days, so 92 divided by 6.3 gives just over 14 days on hand.

Fourteen days is the number to react to, not 6.3. It says the kitchen is holding a fortnight of stock on average. For rice and oil that is ordinary. For anything in the cold room it is a problem you can smell coming.

Petpooja is India’s biggest and most price effective restaurant POS, behind the success of 1,00,000+ outlets. It has run restaurant billing in India for over a decade, and processes 60 lakh bills a day at 0% error.

What Is a Good Inventory Turnover Ratio?

We could not find a published Indian benchmark for restaurants. Even Corporate Finance Institute, which ranks for this term, says only that benchmarks vary by industry and gives no figure. What you can do instead is work backwards from shelf life, which is a fact rather than an opinion.

Convert your ratio to days on hand, then hold it against how long the item actually keeps. If you are carrying more days of stock than the food has left in it, the ratio is too low whatever a benchmark says.

What Good Looks Like by Category

  • Fresh produce and dairy should be measured against a shelf life in days, not weeks
  • Meat and fish follow the storage temperature they are held at, and our guide to food storage temperature rules covers those bands
  • Dry goods can sit far longer, so a slow figure here costs you cash but not spoilage
  • Bar stock keeps almost indefinitely, so judge it on money tied up rather than waste

That is why a single kitchen-wide ratio is close to useless. It averages a tomato and a bottle of rum into one number.

Why the Inventory Turnover Ratio Breaks on Perishable Stock

A low ratio means two different things depending on the category, and only one of them is recoverable. Every general guide to this ratio was written for businesses selling things that keep.

For a warehouse, a low turnover ratio means money is tied up. Annoying, recoverable. You sell the stock eventually.

For a kitchen, a low ratio on the wrong category means the stock will never be sold at all. It will be binned. The money is not tied up, it is gone, and it takes your food cost up with it. A food waste cost calculator puts a number on that half.

RECOMMENDED READ  How to Switch a Restaurant POS in the UAE Without Downtime
One figure: 14 days on hand Fresh produce Dry goods Spoils before it sells Only cash tied up The same number means two different things.
Split the figure by category and the half that needs fixing separates itself out.

Go back to the Pune restaurant and split its stock. If produce carries ₹42,000 of average stock against ₹6,30,000 of produce COGS, that category turns 15 times, which is about 6 days on hand. Healthier than 14, and still too slow for leaf vegetables.

Our take, and it is a preference rather than a rule: run the ratio on produce and dairy alone first. It is the smallest slice of stock value and the largest slice of waste. A week of attention pays back fastest there. The kitchen-wide figure can wait.

What a High or Low Inventory Turnover Ratio Tells You

A number on its own is not a diagnosis. Each direction points at something different, and each has something worth ruling out before you act.

A low ratio normally means one of three things. You order more than you sell. You hold lines that barely move. Or your counts are wrong, and stock has left without being recorded.

The third is the easiest to dismiss and the most worth ruling out, and an inventory audit checklist is the quickest way to do it.

A high ratio looks like efficiency and sometimes is. It can also mean you are running too lean. Dishes come off the menu mid-service, and that costs you a sale and a customer at once.

The honest read is that the ratio flags where to look. What it never does is tell you why, and the restaurant inventory management guide covers the counting routine that answers that.

How Often Should You Measure the Inventory Turnover Ratio?

Most accounting guides assume you calculate this once a year with the annual accounts. For a restaurant that is far too late to act on.

A yearly figure tells you what already happened across twelve months of menu changes, festival weeks and supplier switches. By the time you see it, nothing about it is fixable.

Do it weekly, on the same day. A Monday morning count before deliveries land gives you a clean closing figure, and it stops being a chore once it is a habit.

The order matters more than the day you pick:

  1. Count what is on the shelves before the first delivery arrives
  2. Pull the purchase total since your last count
  3. Add last week’s closing figure to this week’s and halve it
  4. Divide, then turn the answer into days on hand

Restaurant owners using Petpooja tell us the weekly version changes the conversation with suppliers more than the annual one ever did. You stop negotiating on price alone and start negotiating on delivery frequency, which is usually the cheaper win.

Which Reports Give You COGS and Average Inventory?

Both figures already exist somewhere in your system. Knowing which screens hold them saves rebuilding either one in a spreadsheet.

Cost of goods sold comes from your purchase entries and your stock values. Average inventory comes from a closing stock report at each end of the period.

Once those are in one system, the ratio is a division rather than a project. Which system you use decides that, and our inventory management software comparison covers the options.

Where the two live in different places, or on paper, the weekly habit dies within a month. The counting ends up costing more than the answer is worth.

Stock records kept apart from purchase records are also how the figure drifts without anybody changing a menu price.

Conclusion

The inventory turnover ratio is cost of goods sold divided by average inventory. That part is simple, and every guide agrees on it.

The part that matters for a kitchen is what you do next. Convert it to days on hand, split it by category, and hold each one against how long that food actually keeps.

Start with produce this week. It is the fastest category to fix, and the one where a slow figure turns into waste rather than idle cash. Our restaurant waste management guide works through that side.

Those stock and purchase figures live in your restaurant POS, which is where the weekly count becomes quick enough to actually keep doing.

Frequently Asked Questions

1. Does wastage count inside cost of goods sold?

Yes, and that catches people out. COGS is opening stock plus purchases minus closing stock. Anything that left without being sold is already inside it. Spoilage, staff meals and theft all land in the same figure. A healthy ratio can sit on top of a waste problem.

2. Should I use sales instead of cost of goods sold in the formula?

No. Sales include your margin, so the ratio comes out inflated and cannot be compared with anyone else’s. Both halves of the division have to be at cost.

3. Does the ratio work for a cloud kitchen with no dine-in?

It works the same way, and the days on hand figure matters more, not less. A cloud kitchen usually carries a narrower menu, so a single slow-moving ingredient is a larger share of total stock value.

4. Should a group with several outlets run one ratio or one per outlet?

One per outlet. Menus and footfall differ enough that a group figure hides the site with the problem. A central kitchen changes the sum again, because stock moves between sites without being sold. Our multi-outlet stock guide covers that case.

5. What if my opening and closing stock are wildly different?

Then the two-point average hides more than it shows. Take a weekly count and average across all the weeks in the period instead, which is another argument for measuring weekly rather than annually.

Shaival Desai
Shaival Desaihttp://blogpetpooja.wordpress.com
Shaival is the Chief of Growth at Petpooja. Apart from jumping from one corridor conversation to another, you will always find curiously wandering about SaaS products, technology & food trends. Reach him at shaival.desai@petpooja.com.

RELATED UPDATES

LEAVE A REPLY

Take a free demo