Tweet

Retail Metrics: Key Performance Indicators (KPI’s) – Days of Supply

Guest post by: Scott Kreisberg

Article Overview: This is part one of a five part article series detailing out Key Performance Indicators (KPI’s) in running retail businesses. This article covers the first of the KPI's, Days of Supply.

Retail Metrics: Key Performance Indicators (KPI’s) – Days of Supply

Previously, I've talked about Retail Metrics and the importance of Key Performance Indicators (KPI's) in running your business. What does that really mean anyway? Some of you new to the retail business might not have a clue as to what constitutes a "Key Performance Indicator". Some of us old timers who've been around the block a few times, might not know what they are either or may just need to brush up on retailer lingo. Either way, I want to really delve into what things you can look at to help navigate your aircraft, so to speak, like an airplane pilot would. Flying a plane is a good parallel to managing a store. How does a pilot know what to do when? What tells him when it's time to raise the plane to a higher altitude? What gauges tell him to lower her down a bit? How do they know when it's okay to add on more cargo? What tells the pilot to toss some cargo overboard? When do they know to just keep flying along and not change a thing?

A retailer makes decisions all the time to best navigate the constant change of consumer buying habits. Doing this actually consists of five critical decisions on any given item in stock in order to keep costs down and profits high. These are:

• Mark the item up?

• Mark it down?

• Buy more of it?

• Buy less?

• Don't change anything about it?

Well, the answer to these million dollar questions lies in the treasure trove of information provided by your store's KPI's. Just like a pilot, a retailer must know his KPI's and how to address them, as well or better than a pilot needs to know how to read and interpret the gauges that indicate what should be done next. As a retailer, your KPI's will tell you what to do next; it's just a matter of being able to read what those indicators are trying to tell you and put that information into practical use in the store.

Let's take a look at what I consider to be the five most important retail KPI's that you can get from your point of sale (POS) software program. We're talking about Days of Supply, Turn, Stock to Sales Ratio, Sell Through Percentage and Gross Margin Return on Investment. The last one is the most important indicator. We all want to know how much money a particular item will bring back in revenue. But, the Gross Margin Return on Investment is also the most tricky one to manage and know how to use in managing inventory.

In this article we are going to start with Days of Supply... What does that really mean anyway? We hear this term thrown around all the time, but not all of us really know what this actually is or what it means. Simply put, Days of Supply means how long it will take you to sell out of your present stock, assuming that sales continue at the same rate as recent sales have been. This is weighed against a time frame, like 30, 60 or 90 days. Days of Supply is a great statistic to use for predicting the future. It's kind of like having a real crystal ball right on your desk. The information contained in this report/statistic lays it all out in a clean and concise way of telling you how much longer it will take to sell a particular piece of merchandise based on what's been happening sales-wise in your store. It's like a sign post that points you in the exact direction you need to go in.

For example, you have 1000 t-shirts and over the last 30 days you've sold 250 of them. Based on how many have been sold over the last 30 days, it will take another 90 days to sell the remaining 750 t-shirts. So, for these 1000 pieces of inventory, the Days of Supply equals 120 days.

In essence, Days of Supply analyzes the last period of sales and based upon that rate, gives you the amount of days left to sell off the remaining merchandise. But how far back do you go? Let's take non-seasonal merchandise which sells at a relatively steady rate; for this you could use a longer basis period, such as 30 or 60 days. Then for seasonal merchandise, the rate of sale changes rapidly, and you would want to use a shorter period, a week or even a day in some cases. Interestingly enough, different parts of the country have different length seasons. For instance, New York has really short bathing suit season, about two months and that's it.

Putting this information into practical use, you would then want to make sure Days of Supply on a certain item matches up with the lead time to restock it. You don't ever want to run into the problem of having Days of Supply be less than the time it will take to get the items in. In that case, you would miss out on sales because the sell-out and restock time frames did not overlap. Instead, you ran out of an item before the shipment came in to restock it. This can have bad effects on overall sales in the store, too, if the item you are out of stock on is a hot seller at a critical time of year or you lose customer loyalty because you're out of stock on something. Your goal here is to reduce your Days of Supply to match the lead times without losing sales, plain and simple.

And your point of sale system is where you should be able to get this information and statistical data to manage your inventory. Make sure your POS is giving you this information so you actually can better manage Days of Supply. If your POS isn't giving you that information, you should think about investing in a system that will give you the information you need to better manage your inventory because in retail, profit is all about inventory and the expert management of it.

In my next article I'm going to cover inventory and lots of little tidbits about it, what you can do with it when it's not selling and how to increase profits by better managing your inventory.

Related Articles
  Key Performance Indicators for Retail (KPI)
  Standardized Marketing Metrics and Organizational Singularity
  Map Strategy with Balanced Scorecard
  What to measure to be phenomenally successful in business
  Web Analytics - Make the Switch to Performance-Driven Design
  Aligning minds and what that means
  Implementing a Results Only Work Environment
  Retail Matrix - Part II
  Retail Metrics: Key Performance Indicators ( KPI’s) – Turn
  Baseball's General Managers versus Business' Sales Managers
  Measuring Results: Key performance indicators can help set better goals for sales reps
  What are the 3 biggest challenges faced by supply chain/purchasing professionals today? (Survey Result 15)
  4 Steps to Guarantee Business Survival
  Do You Need Your Salespeople to Love and Respect You?
  Understanding Retail Metrics
  Successful Succession Planning - Driven By Managing Performance
  Lead versus Lag; Future versus Past
  Performance Metrics
  Toward a better understanding and application of engagement
  What are the 3 biggest challenges faced by supply chain/purchasing professionals today? (Survey Result 14)

Article Tags: Days of Supply, key performance indicators, metrics, point of sale, POS, retail business



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….?
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.
An "Easy Button" - In the US, Staples Office Supply company has a commercial that features an easy button. The idea is that when you have a difficult task, you hit the easy button and the task is easier. Staples is saying that they make it easier. But, my question is, what would you use an "easy button" for?? Chris
ARTICLE: Performance coaching in the workplace - To create lasting performance change it is necessary to first understand the positive and negative influence that a person’s personal behaviors has on their execution and what impact these have on their ability to achieve success. Only when we fully understand a person’s behavioral patterns and create positive self-managing coaching strategies can we assist a person to create lasting performance change. The vast majority of employers believe coaching can deliver significant benefits to both individuals and organizations. The majority of employers plan to increase the use of coaching over the next few years, according to a new survey by the Institute of Personnel and Development. Nearly nine out of ten interviewed companies expect their managers and supervisors to deliver performance coaching as part of their day-to-day work. In another large industry-wide study it was found that most managers reported that they were confident in their ability to coach. However, the study also showed that the managers’ actual skills levels as coaches were typically poor. As a consequence they were not nearly as effective in their coaching as they believe themselves to be. Often times, they believed that coaching consisted of just providing 1-to-1 instructional feedback to their staff members on what to do in a given situation to perform better. Many recent studies have shown that technical skills only represent at best 20% of the contribution into our performance. The remaining 80% comes from our ability to choose or make a decision, assertiveness, commitment to grow, ability to concentrate, honesty, optimism, persistence, ability to perform well under stress and so on. These traits are commonly called our soft skills or attitude. Few managers understand just how deeply rooted their own behavior patterns are, let alone how to positively change them in other people. Performance coaching is frequently confused with other types of coaching, such as Executive coaching and Life coaching. Performance coaching is a form of Directive coaching. Executive coaching and Life coaching are both forms of Non-directive coaching. Directive coaching is usually more suitable for a manager who sometimes acts as a coach. Performance coaching in the workplace has developed immensely from what it was only 4 years ago. To choose the right coach will make a huge difference. You also better make sure to know what you want. If your coach knows what (s)he is doing – you will get on your way to get it! [i:38tu5pgr]- Peter J Karlsson[/i:38tu5pgr]
Re: We all embellish, so are we all liars? - [quote="BuzzAroundBooks":3chumhxz]For instance, what if a customer asks you where a specific sales representative is but you don't know where he/she is? Retail expert Doug Fleener says "Rather than appearing not to know what's going on, it's safer to go with the standard reply: 'Dan's (i.e. sales reps' name) not available right now. My name is... May I help you?'" ("The Profitable Retailer" 216).[/quote:3chumhxz] Hi Kevin There have been a couple of businesses in my local area who have done this only to become unstuck when we found out that Dan (or who ever we were after) had not worked there for months and the business (a one man band) was only trying to cover it up to appear larger than it was in reality. My honest opinion was that the business went through a few employees quitting and they didn't want us to think they were an unstable company.


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

The True Cost of Employee Turnover

Business Coach Explains To You How To Add Value

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.