Tel: (01) 901 1310

menu

Is 17% Of Your Stock Slow Moving Or Out Of Date?

Share Post:

Share on linkedin
Share on twitter
Share on facebook
Share on email

When we crunch the data we’ve collected, it shows that the typical value is a minimum of 17% of stock on hand.

We have unearthed many bits of valuable data from working with our clients and one piece that to us is a bit mad, is the level of stock held, that is non-moving, slow moving, or should be written off.

The bottom line is that it is the equivalent of cold hard cash sitting on a pallet in your warehouse. Picture that, a BIG pile of €50 notes all over your warehouse that you can’t make money from.

As an exercise, here are 5 things that you should have one of your employees (probably finance) do, so you can see if you have a problem or not:

  1. Pull a list of all the SKU’s you have from your system at the last stock take
  2. Get the number on hand and the value of each unit
  3. Run a report of the quantity of each SKU that you sold in the previous 12 months
  4. Simple calculation, divide the “number on hand” by “the number sold in the previous 12 months” for each SKU – this simple calculation gives you the Stock Turns
  5. Graph the results, here’s what that should look like

The above example is from one of our clients, their industry average is 8 – 12 turns per year. You can see that from a SKU perspective 56% are 4 turns or lower per year. At the individual item (unit) level, 58% are below 4 turns.

In simple terms if you hold €1m in stock, that equates to €170k, if you hold €500k the value is €85k. The head wreck and frustration is that it’s the equivalent of cash and you are funding it from sales and margin.

Think of it another way, if that €170k was Gross Profit then a sales rep would have to deliver €425k in sales to cover it.

You’ll hear any amount of excuses in a business to justify why “we need to keep the stock”, “We can’t sell it, if we don’t have it”. Very rarely do we find any solid justification, usually it’s because nobody thinks, “it’s their job”.

So in conclusion, that’s cold hard cash sitting on pallets in your warehouse.

The big question is, “Who else in your organisation is worrying about it?”, probably no one, but someone other than YOU should be.

Now could be the time to contact us at 059-91-00440 and we’ll go take care of it. Or Fill In The Form And We Can Schedule A Phone Call.

Quick Contact - Or Call: 01 9011310

Sign Up To Our Latest Transmission

To be sent automatic updates to our latest news articles, please fill in your details.

More News

Leadership

Do You Feel Stuck Trying To Grow Your Company?

Good leadership is vital for organizational success, but even good leadership can be an obstacle. Successful leaders often struggle with a few common issues: difficulty trusting others, identity and worth and self-discipline.

Warehouse Management

12 Tips for Keeping a New Warehouse Organized

If you want to serve your customers quickly and efficiently, you’ll need a good system of organization in place. But with potentially thousands of items to keep track of, dozens of people to hire, entire systems to build from the ground up, how are you supposed to do it?

The Business Troubleshooters Ltd.

Dublin

Carlow

Cork

Ⓒ 2020 - All Rights Are Reserved

Sign Up To Our Latest Transmission

Dublin

3013 Lake Dr,
Citywest Business Campus,
Dublin, D24 PPT3
Tel: (01) 901 1310

Carlow

Enterprise House,
O’Brien Road,
Co. Carlow, R93 YOY3
Tel: (059) 910 0440

Cork

Acorn Business Centre,
Mahon Industrial Estate
Blackrock,
Cork, T12 K7CV
Tel: (021) 2021130

Share on linkedin