Tweet

Understanding Retail Metrics

Written by: Scott Kreisberg

Article Overview: Running a successful retail business involves more than buying merchandise, marking it up and selling it. The information you get from your POS software enables you to analyze your operation, identify problem areas, and take immediate corrective action before it costs you a bundle. These reports contain the Key Performance Indicators (KPI) for your business.

Understanding Retail Metrics

I’ve seen many retailers over the years still running their business by the seat of their pants. While this management style may have worked in the past, it is quickly being replaced by more sophisticated operations using advanced technology to squeeze every penny out of the business.

As most of you have come to realize, running a successful retail business involves more than buying merchandise, marking it up and selling it. When you first got started, you probably had a good idea of what your store would look like, how your staff would present itself, how the merchandise would be displayed…and where you’d be opening up your next store! Like most CEOs, you were and probably still are the visionary. But as you later found out, even great visionaries need a little pragmatism to realize their dreams.

The good news is that you don’t have to be a statistician, mathematician or even a rocket scientist to manage your business in both a visionary and more scientific manner.
These days, using specially designed retail software products like Retail Pro and CounterPoint SQL, you can run a few reports on a weekly basis and get an excellent understanding of exactly what is going on with your business.

The information you get enables you to analyze your operation, identify problem areas, and take immediate corrective action before it costs you a bundle. These reports contain the Key Performance Indicators (KPI) for your business.

How important are Key Performance Indicators? Think of yourself as the pilot of an airplane. You decide to take a trip and create a flight plan – when you’re leaving and where you plan to go. You take off with your flight plan in hand. It’s a beautiful day, with no clouds in sight.

But how do you know if you’re flying in the direction you want to go, flying level, high enough not to run into any mountains, have enough fuel and flying fast enough to get to your final destination on time?

Well, a pilot uses instruments to systematically get to his/her final destination safely. A retailer is no different, and must have and use the equivalent instruments in order to fly his or her business on a daily basis in a profitable manner. Those “instruments” are closely monitored by KPI.

So start reading those KPI reports! And don’t forget to set objectives for the merchandise you are buying.
Why is this important? When you run your KPI report you will know if the item is performing according to your expectations. If not, then you can take quick decisive actions to sell off that item before you get stuck with it and have to lose money on a mark down.

Now, let’s take a closer look at how analyzing your inventory performance on a regular basis can keep your business on track.

A retailer has five decisions to make on any given item in stock:
1. Mark up
2. Mark down
3. Buy more
4. Buy less
5. Don’t do anything

How does a retailer know what to do and when to do it? Well the answer to that million dollar question lies in KPI’s.

Let’s take a look at what I consider to be the five most important retail KPI’s that should be easily generated from your software program:

Days of Supply

Definition: Days of Supply is a key statistic which tells you how long it will take you to sell out of your present stock, assuming that sales continue at the same rate as recent past sales.

Days of Supply analyzes the last period of sales, and based upon that rate, gives you the amount of days of supply left on that style. It is based upon the numbers of days of selling that you tell your system to examine.

For non-seasonal merchandise which sells at a relatively steady rate, you could use a longer basis period, such as 30 or 60 days. For seasonal merchandise, the rate of sale changes rapidly, and you would want to use a shorter period.

Merchandising Goal: To reduce your days of supply to match lead times, without losing sales.

Turn

Definition: Turn is a measure of how many times your inventory turns over in the course of a year.

Example: If you have an average inventory of 100 jackets in a year and you sell 100 jackets every 4 months, your inventory "turns over" or is totally replaced, 3 times per year. Therefore, your turn is 3.

Turn is often increased by reducing selling price. However, this obviously reduces profit. A balance needs to be reached between the proper turn, and the proper profit margin.

The formula for turn used by Retail Pro is: Annual Sales divided by Average Inventory

Merchandising Goal: Increase your turn as much as possible, without having to take markdowns.

Stock to Sales Ratio

Definition: The ratio of the inventory available for sale to the quantity sold. For every unit I sold, how many units did I have on hand?

Stock to Sales Ratio is the exact inverse of Sell Thru Percentage.

Stock to Sales Ratio is a key statistic for measuring whether or not you are overstocked. If your Stock to Sales Ratio rises, and there is not an accompanying rise in sales, then you are adding more stock without increasing sales, which will reduce your profitability. If your Stock to Sales Ratio decreases, and your sales do not decrease, then you will have increased profitability.

The formula used for Stock to Sales Ratio is: Averaged Units of Inventory Available divided by Units Sold

Merchandising Goal: To reduce your Stock to Sales Ratio as low as possible, without losing sales.

Sell Thru Percentage

Definition: The percentage of stock you had available for sale which was sold.

Sell Thru Percentage is the exact inverse of Stock to Sales Ratio.

Sell Thru Percentage is especially important for seasonal merchandise, since the goal is to be out of stock of seasonal merchandise by the end of the season. Therefore, you can look at your year-to-date sales of seasonal merchandise, and be sure that you were out of stock by the end of the season.

The formula used to calculate Sell Thru Percentage is: Average Units Sold divided by Averaged Units of Inventory Available

Merchandising Goal: On seasonal merchandise, plan out the percentages to be sold out of by month, so that you can ensure being out of stock by season end.

Gross Margin Return on Investment

Definition: For every dollar invested in this style, how many dollars did I get back? (Abbrev. GMROI).

Gross Margin Return on Investment calculates that return based on the gross margin from sales. For example, if you purchase $2000 of inventory, and sold it all in the same year for $6000, your profit would be $4000. The return on your investment of $2000 was $4000. The GMROI in this example is $4000/$2000 = 2.

GMROI is closely related to turn. If your turn increases, your average inventory cost will be lower (relative to your profit), and thus the greater the return on your investment.

The formula for GMROI is: Sales Margin Dollars divided by Months Passed X 12

Your merchandising goal is to increase the GMROI as high as you can, by keeping turn high, at high margins.

As an additional note, always remember to set objectives for the merchandise you are buying. For example, when buying a new style of jeans, set a target for how many pairs should be sold by some reasonable time frame like, sell 12 pairs in the first week.

This is important so when you run your KPI report you will know if the item is performing according to your expectations. If not, then you can take quick decisive actions to sell off that item before you get stuck with it and have to mark it down in an unprofitable fashion.

Related Articles
  Defining Success Metrics for Corporate Blogs
  PoP (Point of Purchase) Visual Merchandising
  Quality in Marketing: You must start with these 2 definitions
  RETAIL SALE BOOSTER MODEL (RSBM)
  Monitoring Inside Sales Productivity

Article Tags: beautiful day, ceos, corrective action, counterpoint, final destination, flight plan, key performance indicators, management style, mathematician, pragmatism, problem areas, retail pro, retail software, rocket scientist, sophisticated operations, statistician, successful retail business, using advanced technology, visionaries, visionary



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….?
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.
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.
Global Ad Agency Seeks Senior Sales Account Executive - Global Ad Agency -- We are seeking experienced advertising Senior Sales Account Executives to join our growing sales force in New York office. ICMediaDirect.com, Inc is a Full Service Online Advertising Agency driven by a united goal to provide both online as well as offline advertisers with easy and affordable ways to plan and buy media online. We are proud to present an impressive roster of over 300 satisfied clients and a wide reach of billions of visitors each month. With two great locations - N.Y. and D.C. - we know how to PLAN your media, how to BUY your media, how to TRACK your media and how to CAPITALIZE your media. Qualifications • Minimum 2 years of active ONLINE advertising sales experience • Responsible and aggressive attitude • Successful track record with ONLINE sales • Understanding Internet advertising vehicles such as pops, banners, search and lead generation is required • Excellent communication and presentation skills • Strong computer skills are required • Detail oriented and well-organized • Ability to work independently • Enthusiastic team player The Best office location in the city! Competitive salary (plus commission), bonuses and benefits. Please send your resume with salary expectations today at jobs@icmediadirect.com!
Re: Global Ad Agency Seeks Senior Sales Account Executive - [quote="RobertGresch":1lt645d1]Global Ad Agency -- We are seeking experienced advertising Senior Sales Account Executives to join our growing sales force in New York office. ICMediaDirect.com, Inc is a Full Service Online Advertising Agency driven by a united goal to provide both online as well as offline advertisers with easy and affordable ways to plan and buy media online. We are proud to present an impressive roster of over 300 satisfied clients and a wide reach of billions of visitors each month. With two great locations - N.Y. and D.C. - we know how to PLAN your media, how to BUY your media, how to TRACK your media and how to CAPITALIZE your media. Qualifications • Minimum 2 years of active ONLINE advertising sales experience • Responsible and aggressive attitude • Successful track record with ONLINE sales • Understanding Internet advertising vehicles such as pops, banners, search and lead generation is required • Excellent communication and presentation skills • Strong computer skills are required • Detail oriented and well-organized • Ability to work independently • Enthusiastic team player The Best office location in the city! Competitive salary (plus commission), bonuses and benefits. Please send your resume with salary expectations today at jobs@icmediadirect.com![/quote:1lt645d1] Hi Robert, Welcome to our forums! Have you had any luck in your search for this job candidate and can I ask what other sites you've used to advertise this position?


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.

Tweet

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

Work at Home Moms and Their Bad Rap?

••••••>SEO Tip Of The Day: HTML Validation

Small Business Internet Marketing

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.