Overstock is stock beyond what can be expected to sell within a reasonable period. It ties up money and space, and the longer the products sit, the harder they are to sell at full price. Many webshops know they have too much stock, but not how much or on which products.
Overstock per product
First choose a limit for how many days of sales it is reasonable to hold. 180 days is a common starting point, but products with a long lead time or strong seasonality may need more.
Overstock = stock + incoming goods − (sales per day × limit in days) − safety stock
A product sells 2 units a day and has a safety stock of 20 units. There are 600 units in stock and none incoming:
600 − (2 × 180) − 20 = 220 units
With a cost price of 80 DKK, there is 17,600 DKK in overstock on that product. With a holding cost of 25% of the cost price per year, the 220 units cost about 4,400 DKK a year to hold.
Use the forecast and not just the last few months’ sales. A Christmas product in September has a lot of stock compared with sales right now, but not compared with sales in December.
Dead stock
A dead product has stock but has not sold anything for a long time, typically 180 days or more. Here it makes no sense to calculate days of cover, because sales are zero. The product could easily sit in stock for years.
First check whether the product is actually visible in the webshop. Products that are deactivated, missing an image or placed in a category without traffic look dead, but have never had a chance.
What can be done
There are roughly four options, and the order depends on the product:
- Stop purchasing. If the product is still on automatic reordering, turn that off first.
- Lower the price. A discount on overstocked products costs margin, but frees up money and space.
- Return or exchange with the supplier. Some suppliers take goods back for a fee or exchange them for products that sell.
- Sell it as a lot. Remaining stock can be sold to an outlet or a stock buyer, typically far below cost price.
It is probably best to start with the products where the most money is tied up. Ten products often hold most of the overstock.
How much to lower the price
If a product has 300 units in stock and sells 1 unit a day, it takes 300 days to sell the stock. If it has to be sold within 100 days, sales have to triple. How large a discount that requires depends on the product, but you can test a discount for a couple of weeks and see how sales per day change before lowering the price further.
Overstock and dead stock in lesslater
The analysis shows overstock in DKK for the whole range and per product, calculated as stock and incoming goods beyond a number of days of expected sales plus safety stock. The limit is 180 days and can be changed. Products with stock and no sales for 180 days are shown as dead stock with the date of the last sale. If you set a phase-out date on a product, lesslater calculates how much will be left on that date at the current price, and what price is needed to sell the stock before then.