Skip to main content

Inventory Woes

In my opinion, the number one problem facing most music retailers today is inventory.  They have too much of the things that aren’t moving and not enough of the things that are.  In this brief article, I’ll try to explain how I look at inventory, some key pitfalls to avoid, and how to identify the winners and losers in your inventory.

First thing, if you are serious about being in the music business, you’ve GOT to have a quality POS (a point of sale, not the other POS - you probably have too much of that - which is why you’re reading this article!).  You can do everything I’m going to share with you without a POS, but the amount of time you’d spend compiling data would EASILY pay for a POS! I recommend Tri Technical System’s AIMsi. In fact, I have no idea why you’d use anything else - almost everything I’m going to show you is just a click away in AIMsi...

We are going to look at a few stats to determine our inventory position: GMROI, Average Inventory, and Inventory Turns.

GMROI: An inventory profitability evaluation ratio that analyzes a store's ability to turn inventory into cash above the cost of the inventory.
  • It is calculated by dividing the gross margin by the average inventory cost.
  • A ratio higher than 1 means the firm is selling the merchandise for more than what it costs the store to acquire it. The opposite is true for a ratio below 1.

Average Inventory: You're average inventory on hand for any given period.  Measured monthly is the best.
  • Calculation: Beginning Inventory + Ending Inventory / 2 = Average Inventory

Inventory Turnover:   A ratio showing how many times a store's inventory is sold and replaced over a period (usually one year)
  • Inventory Turns = COGS / Average Inventory

Knowing these terms, run or create an Inventory Analysis report, it should have the following columns:

Most retailers will immediately look at the Gross Profit % and think this business is doing well.  But while they have a healthy gross profit, I would surmise that this business is actually enduring extreme cash flow pressures, and is probably on it’s way out of business if it doesn’t get it under control!

The metrics that reveal this are GMROI and Inventory Turns.

The GMROI shows that for every dollar they’ve invested in inventory over the last year, they only received $.65 cents in return - a net cash OUTFLOW of $.35 cents!

The Inventory Turns shows they have over ONE YEAR’S worth of inventory on hand right now (Inventory Turn of 1.0 = 1 year’s worth of inventory, Inventory Turn of 2 = 6 months of inventory, etc).  In terms of total dollars, they could go for over a year without ordering ANY product!

To fix these issues, they need to do some combination of the following:
  • Increase sales/turns of the inventory they already have on hand
  • Reduce overall inventory

To find the inventory that is producing well for them (the winners), they need to use their POS to determine the Top 20 SKUS per department based on units sold, and also what the Top 20 are based on dollars sold.

To find the losers, they need to run a report to find the WORST performing inventory - the inventory that hasn’t turned over the least year.

Once we have this information, we first must put a system in place that insures we NEVER run out of our best inventory.  No matter what, we ALWAYS have those SKUS in stock.

For the losers - we can try re-merchandising them to a better location, providing product training for our staff so they are more comfortable selling it (adding a SPIFF to this is a great way to increase staff participation on moving this inventory), and finally, putting it on sale or clearance.

Putting this concepts into effect can drastically change the financial picture for this store.  If we can reduce the overall inventory while maintaining sales, see how it changes our GMROI and Inventory Turns:

You now see that for every dollar invested in inventory over the course of the year, they receive $1.54 in positive cash flow - a vast (and sustainable) improvement.  Plus, they are now turning their inventory twice per year - meaning they only have about 6 months of inventory on hand, which is a much healthier position.

While digging out of this hole will likely take a while, setting a goal and devising a plan and acting on it is a must if you wish to be healthy, happy and successful in retail.

Remember, if you need my help, I'm only an email away.


Popular posts from this blog

Now Through Midnight on 12/2 Save Up to 70% On These WhizBang Favorites!

I've been in retail for over 25 years and I wondered if I would learn anything to justify the expense of attending the WhizBang Retail Success Summit . Let me tell you, not only was it worth the price, I'm taking my leadership team this year! Now you can go too for only $297! Would you like to get some great marketing ideas and also ask questions to build out your monthly marketing calendar? For only $297 per year you can join the WhizBang Marketing Club and talk with other smart retailers about marketing promotions that are making the register ring! Are you running your business with a plan, or just a hope and a prayer? Want a store that serves your life rather than runs you ragged? Whether you feel overworked and overwhelmed almost all the time, hardly ever out of control, or fall anywhere in between, The Master Plan Advantage will help you become a happier, more confident business owner. Normally $997, get your plan together NOW for only $297!

MI SalesTrak is one of the best, easiest, quickest things you can do. And it’s FREE!

Jim Hirschberg explains what MI SalesTrak does, how it works, what benefits you get from participating in the program, and how to get started. Listen by searching for Music Retail Podcast on your favorite podcast app, or you can listen on the web. Remember, if you need my help, I'm only an email away.

What You'll Learn LIVE At The [VIRTUAL] Retail Success Summit! (And SAVE $700!)

There’s no doubt that 2020 has been crazy. Actually, beyond crazy. Each and every one of us has been tested in many, many ways. Life is different. BUSINESS IS DIFFERENT… are you? Has your store made the breakthroughs necessary to excel – or are you hoping that things will go back to the way they were pre-pandemic? If you are, you’re dreaming – and it’s about to turn into a nightmare. Because don’t kid yourself, this thing isn’t done yet. Not by a long shot… If there is one thing we learned through this whole s%#t show, It’s that we can’t control what’s happening. The only thing we can control is how we react. And how you react is determined by what you know. It’s that simple. When you know what to do you make good decisions quickly. You act with confidence. You need… New insights  into how retail is changing so you can be ahead of the curve, not caught helplessly behind it. New skills and strategies  that are going to work NOW and keep working no matter what new craziness is in our fut