Tweet

Retail Metrics: KPI’s – Stock to Sales Ratio

Guest post by: Scott Kreisberg

Article Overview: Retail Metrics and Key Performance Indicators for the Retail Industry.

Retail Metrics: KPI’s – Stock to Sales Ratio

Alright, so in my last two articles, (links) I've covered the first two KPI's, Days of Supply and Turn. Now it's time to get into the third one, Stock to Sales Ratio.

When getting into inventory, Stock to Sales Ratio is a key statistic for measuring whether or not you are overstocked. You can see when someone has too much inventory because their inventory is all over the place. Look in your stock room. Do you have a bunch of merchandise that's been sitting there for a while or even been sitting there for years? If you said "yes" to that question, that is the sign that you've got too much inventory! And when you've got too much inventory in the store, sitting around not doing anything but collecting dust, your money is tied up in that inventory not able to be reinvested. It's time to move that stuff because you need to purchase other inventory that will actually turn. How does Stock to Sales Ratio work? Stock to Sales Ratio is the ratio of the inventory available for sale versus the quantity actually sold. For every unit sold, how many units were on hand? For every single sale I made of that particular item, how many did I have in stock at that time? Stock to Sales Ratio is the exact inverse of Sell Thru Percentage which will be covered in its own article. Simplified, this means that if I had 30 dress shirts in the store room when I sold 10 out of the 30, then I know that in order to sell 10 dress shirts, I would always have to have 30 of those dress shirts in the store room. You've got to have a certain amount of an item in inventory in order to sell a certain amount of that item. Knowing this about each inventory item keeps your inventory at the right level, not too high and not too low.

If the Stock to Sales Ratio rises, with and increase in inventory and there isn't an accompanying rise in sales, then you are adding more stock without increasing sales. It's kind of interesting how that can happen. Obviously increased stock with out the accompanying increase in sales will reduce your profitability. If this happens, that is the time to hold off on purchasing any more of that item and work on selling down the quantity on that item until it's time to reorder based on the Turn report and lead time to restock it.

Use the Turn report to help you keep the proper balance of inventory to sales when both of the above scenarios happen. It's all pretty simple, really. Don't over complicate it. It's really that simple, I promise you.

Now, you can have a situation where your inventory went too low and there is a scarcity of that item out on the floor because you just don't have enough to put out. This can happen if you don't monitor your Turn on that particular item and what the restock lag is. Now that item isn't available to be sold because you don't have enough on the floor to sell. This seems like a backwards way of thinking because if an item sells normally and you start to run out, you'd think it would just keep selling. Well... in retail, it doesn't work that way. If you have a shortage of an item, the backwards rule comes in and that item will stop selling. It's funny, but this situation makes customers less willing to buy that item for the seemingly obvious reason that it's just not there in enough quantity to be sold. Weird, I know, but I'm sure you've seen this happen. Consumers walk into a store, see there is a scarcity of merchandise because your stocks are low and they think you don't know the business you're in.

For instance, if you sell women's apparel and you only have medium shirts in one color, the customers coming into the store are gonna think you don't know anything about women's apparel. There just isn't enough of a choice and variety to entice the customer to buy from you. It comes down to not enough inventory to make any sales. People don't want to buy anything if there isn't enough of it left on the shelf or enough options to choose from. And if you lower the price too much, it won't sell either. This goes the other way, too. If you price it too high, it won't sell either. It's a balancing act to keep the prices within the range that will sell as well as keeping the inventory just right.

This is also important because it is your check and balance. How do you know if you have too much inventory? Or too little inventory? You can't walk into the stock room and look at your shelves of merchandise that can be put out on the floor and guess whether or not you have enough inventory. The Stock to Sales Ratio report from your POS will tell you where you stand regarding too much or too little. Keep an eye on the Turn of your inventory, then cross check it with Stock to Sales Ratio and the lead time to restock. Balance those things and you will keep the right amount of inventory on hand.

You can use this formula to calculate and manage your stock accordingly: Averaged Units of Inventory Available ÷ Units Sold. This will reduce your Stock to Sales Ratio as low as possible, without losing sales.

Keeping an eye on this report will help keep your money out of slow turning stock and into merchandise that will turn over quickly. The best way to get this information is from your POS. Having the right kind of POS will only return dollars back into the store and your pocket because you get the information you need to keep profits high and costs down. I can't stress this enough.

In the next article I'm going to cover Sell Through Percentage. Good stuff to know so you can make good business decisions.

Related Articles
  Key Performance Indicators for Retail (KPI)
  Retail Matrix - Part II
  Standardized Marketing Metrics and Organizational Singularity
  An Obsession That Will Hurt Your Stock Market Results
  Understanding Retail Metrics
  5 reasons to automate your Retail
  Retail Metrics: Key Performance Indicators ( KPI’s) – Turn
  Marketing - Organizational and Employee
  Web Analytics - Make the Switch to Performance-Driven Design
  4 Steps to Guarantee Business Survival
  Retail Metrics: Key Performance Indicators (KPI’s) – Days of Supply
  Buying a Business Without the Emotion
  …but what do I do?
  Different Types of Stock
  Business ratios
  “Riding the Rails on Other Peoples Money”
  Who Cares More-Sales or Marketing?
  Twitter Metrics
  V. STOCK MARKETS AND ECONOMIC GROWTH: THE MACRO CHANNEL
  Monitoring Inside Sales Productivity

Article Tags: key performance indicators, KPIs, point of sale, POS, POS systems, retail, retail metrics



Related Forum Posts
Happy Worker as of Dec 31 2007 - Here's mine... I'm now off to make an offering to the business planning gods for their help in getting to these goals & beyond. To the combined success of Prophets 2 Profits! ----------------------------------------- 1) Corporate a) Retail - Sales reps covering all major markets (1M or more) - Retail product launch plan - 1 more retail release (TBD) b) The Toy Agency - Systems for: o Creative process o Pricing o Manufacturing o Logistics - Marketing agency strategy in place - 1 new customer every 2nd month (5 new customers); 1 of which will be rev of >= 500K/year c) Business - Creative talent pool management strategy & process - Outsourced and/or weekly bookkeeping - Monthly budgeting & forecasting - Better banking organization (Line of Credit, CCs, automate billing for appropriate vendors) - Team total of 5 - Larger office d) Web site - Daily updates - Start of separation of Blog/TTA/Retail 2) Personal - Most weekends “off”! - Entirely separate personal finances; basic personal financing plan - Family….?
Online Sales and Marketing vs Traditional - Hi Evan, I am noticing that many of the posts in the Sales/Marketing section deal with online marketing, SEM and and SEO and Affiliates. I was wondering if it might be a good idea to separate that section into two; 1) Online Sales and Marketing; 2) Traditional Sales and Marketing
Re: Do Women Play the Stock Market? - I also play Stock Market.....
Re: Online Sales and Marketing vs Traditional - [quote="ltrahan":31w9r2iz]Hi Evan, I am noticing that many of the posts in the Sales/Marketing section deal with online marketing, SEM and and SEO and Affiliates. I was wondering if it might be a good idea to separate that section into two; 1) Online Sales and Marketing; 2) Traditional Sales and Marketing[/quote:31w9r2iz] I second the request...
Seek Venture Capital & Funding - Hello, Greetings from India. I am Seeking Venture Capital for Offshore Software Company Start-up. Need advise along with Business Model Sample. I have a basic outline for an offshore company. 1. Technology - like Microsoft Dot Net, Java, LAMP 2. Talent Team - Found Good Technology Developers. 3. Where I can get the leads/potential customers - Leads have been identified who are willing to move forward offshore projects. 4. I do not have resources like funding. It is a very critical factor to me Industries: Manufacturing, Real Estate, Retail, Insurance, Distribution & Logistics, Healthcare, Industry Associations and Software Product Development, Agricultural Industries and Etc. Services: Offshore Software Development Company. Offices to be located: Hyderabad, Andhra Pradesh, India and USA. Products/Services/Applications in areas like POS & Billing, Sales & Distribution, Production Planning, Material Management, Inventory Control, Plant Maintenance, Purchasing, Accounting and Logistics. Dynamic Web Programming with Database Driven Content Management Systems, Online Stores for E-Commerce, B2B Solutions, Community Portals, Website Redesign and Development, Custom ERP with Enterprise Wide Functional Modules such as Marketing, CRM, Accounting, Inventory Control, Sales & Distribution, Production Planning, Purchase & Stores, Logistics and Supply Chain. Seek your further questions and help. Thank you, Best Regards, Jayapratap.


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

What is Discretionary Cash Flow

Soda Vending Machine = Energy Hog

Hypotheticals, Scenarios and Foresight

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.