Business

How many days of stock does your shop hold? How to work it out

Work out how many days of stock your shop holds by dividing stock value by daily cost of goods sold, with a made-up grocery example by category.

Editorial illustration for How many days of stock does your shop hold? How to work it out

Days of stock tells you how long money stays on your shelves. Divide the value of your stock at cost by your daily cost of goods sold. For a made-up shop with ₹2,70,000 of stock and ₹2,80,000 of goods sold in a 30-day month, the answer is about 29 days. That means the shop holds a month's worth of goods and pays for it before it sells.

  • Daily cost of goods sold = cost of goods sold in the month ÷ days in the month
  • Days of stock = stock value at cost ÷ daily cost of goods sold

Cost of goods sold is what you paid for the goods you sold, not the sales figure. If you work it out as opening stock plus purchases minus closing stock, use the same stock value in the formula. Always use cost, not the selling price.

What does the sum look like?

Daily cost of goods sold is ₹2,80,000 ÷ 30 = ₹9,333. Days of stock is ₹2,70,000 ÷ ₹9,333 = 28.9, or about 29 days. As a shortcut, stock value × days in month ÷ cost of goods sold gives the same answer: 2,70,000 × 30 ÷ 2,80,000 = 28.9.

Why look at it by category?

A single number hides a lot. The same shop broken into three categories tells a different story:

CategoryStock at costGoods sold in the monthDays of stock
Milk, curd, bread₹12,000₹90,0004.0
Atta, rice, dal, oil₹1,20,000₹1,10,00032.7
Packaged snacks and other goods₹1,38,000₹80,00051.8
Whole shop₹2,70,000₹2,80,00028.9

Dairy and bread turn over in four days, which is what you would expect from items that spoil. Staples hold for a little over a month. The last group holds more than 51 days of goods and half the shop's stock money, although it is under a third of what was sold. Check that group first.

Is 29 days good or bad?

There is no universal figure. A shop with milk and fresh produce should hold far fewer days than one selling hardware or school supplies. Instead of comparing yourself with others, compare with your own past months, and with your supplier's credit period. If your supplier gives you 15 days to pay, you hold 28.9 − 15 = 13.9 days of stock that you paid for before it sold. That is ₹9,333 × 15 = ₹1,40,000 funded by the supplier and ₹1,30,000 funded by you.

How do I bring the days down?

  1. Look at the category with the most days and the least sales.
  2. Order smaller lots more often, if your supplier allows.
  3. Stop reordering items that are slow, after checking your bills for slow items.
  4. Negotiate longer credit terms, if you can do so without a price rise.
  5. Check that the stock count is right: an over-counted stock shows too many days.

If you reduce the snack and packaged group from 51.8 to 40 days, the stock value in that group falls from ₹1,38,000 to 40 × ₹2,667 = about ₹1,06,700, freeing about ₹31,000 of cash. The daily cost for the group is ₹80,000 ÷ 30 = ₹2,667.

What is the sheet formula?

Put stock value in B2, the month's cost of goods sold in B3 and days in the month in B4. Then in B5 use =B2/(B3/B4). For several categories, put them in rows and fill the formula down. It is the same in Excel and Google Sheets.

Getting the inputs

Stock value comes from your count. Cost of goods sold comes from purchases and the stock change. Supplier payments are a large part of your bank debits, and if the statement is imported into SpendixAI with a custom category for stock purchases, the monthly purchase total is easy to read. The stock count itself you do on the shelf.

Where to go next

  • Work out the figure for the whole shop and for your three largest categories.
  • Mark the category with the highest days and look at its items.
  • Repeat next month and see whether the days are falling.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports