Tag Archives: Retail Math Equations

Inventory Turnover: Retail, Cost, or Unit?

Periodically I have students who are confused by the idea that there is not one, but three different ways to calculate inventory turnover.  What really confuses them is that when using all three formulas to calculate inventory turnover (turn) for a retailer, each formula provides a different answer.  And, that this happens even though each formula has the same two basic components:  Sales and Average Inventory.

Let’s start with the formulas:
Retail Turnover = Annual Retail Sales/Average Retail Inventory
Cost Turnover = Cost of Goods Sold/ Average Cost Inventory
Unit Turnover = Unit Sales/ Average Unit Inventory

Example:

Retailer Z’s Financials Show:

Total Retail Sales $2,000,000
Cost of Goods Sold $1,200,000
Unit Sales 180,000
Avg. Inventory at Retail $400,000
Avg. Inventory at Cost $220,000
Avg. Inventory in Units 30,000

Let’s Calculate!
Retail Turnover = Average Retail Sales/Average Retail Inventory
= $2,000,000/$400,000  = 5.0

Cost Turnover = Cost of Goods Sold/ Average Cost Inventory
= $1,200,000/$220,000 = 5.5

Unit Turnover = Unit Sales / Average Unit Inventory
= 90,000/ 15,000 = 6.0

While the inputs are similar, they are not identical, due to each one utilizing a different method of measurement.  Typically Retail Turnover will provide you with the most conservative estimate of your turn rate out of the three calculations.  This is due to the fact that the Retail Sales and Average Retail Inventory numbers both have initial margin (or markups) built into them.

Next time we’ll look at interpreting and using these numbers.

Measuring & Analyzing Sales

Sales are the lifeblood of retail.  Perhaps that is why we have so many different ways to measure, report and analyze sales.  I thought I would use today’s post to do a brief rundown of some of the different types of sales measurements that are used by retailers.  (Please note that because I am a marketer – I am not looking at these from the perspective of an accountant, rather I’m coming at them from the perspective of a merchant or a buyer.)

  • Gross sales– all sales on all merchandise and services during the given time period.  This one is the grand-daddy of all sales measures, since it is the only one to include everything.  Gross sales is an important measure because of its ease of comparability across different retailers.
    Formula = Average price * units sold
  • Net sales– gross sales less returns and allowances.
    Formula = Gross sales – (returns + allowances)
  • Overall sales– a retailer’s total sales.  Typically reported in percentage form.  Overall sales are used to measure a retailer’s growth.
    Formula = (TY Sales – LY Sales)/LY Sales  (Note:  for overall sales, include all sales from all stores.)
  • Comparable sales– also known as same store sales, are a measure of sales for all stores that have been open at least one year.
    Formula = (TY Sales – LY Sales)/LY Sales  (Note:  only include sales from stores open at least 12 months.)
  • Sales per square foot– average amount of sales generated per square foot of selling space in the retailer’s stores.  Sales per square foot is a popular measurement for determining how efficiently the retailer is using their sales space.  According to RetailSails.com, Apple has the highest sales per square foot of any U.S. retailer at $6,123.  If you would like more information concerning U.S. retailers performance in this area, check out RetailSails.com’s chart for all retailers or their listing for the grocery industry(Update 9/19:  RetailSails.com’s website is temporarily down.  Some of the same information can be found in an April post by ASYMCO.)
    Formula = Sales/Total square ft. selling space
  • Stock-sales ratio– the ratio between the amount of inventory (stock) you have available and the amount you are making in sales.  This measurement helps retailers determine if they are carrying too much or too little inventory.  If you would like to learn more about how to interpret this ratio, I recommend Rick Segal’s analysis at The Retailer’s Advantage.  And, if you would like some ratios to compare your numbers to, the U.S. Census releases reports for U.S. manufacturing and sales inventories/sales ratios every month.  (http://www.census.gov/mtis/)
    Formula = Beginning of month inventory/Sales for the month
  • Online sales ratio – the ratio between a retailer’s online sales and their total sales.  The online sales ratio was developed by Investopedia.  It is further explained in their article “Online Sales Ratio Key to Retail Success”.
    Formula = Online sales/total sales
  • Sales per transaction – this ratio can be calculated in either units or dollars.  Many retailers choose to calculate and track both.
    Formula = Sales/# of transactions

There are many more sales measurements than those listed.  For example, many retailers calculate sales per linear foot of shelf space, sales per department, sales per hour, or even sales per labor hour.  All are good measurements for determining base efficiency levels and the health of a retailer’s sales.  If you have a favorite that I haven’t mentioned, please let me know about it.

 

A beginner’s guide to sell-thru (sell-through)

Sell-thru is one measurement that seems to cause a lot of confusion.  And, it is probably the one I get the most questions about.  Much like GMROII, I can’t give comprehensive coverage to it in a blog post, but I can give you a start to understanding it.

Is it sell-thru or sell-through?  And what exactly is it?

Either sell-thru or sell-through is correct.  Sell-thru is the percent of a product’s (or category’s or department’s) inventory that sells during a particular period of time.

How do I calculate it?

Formula:  Units Sold/ (Units on Hand + Units Sold)  or  Units Sold/Total Units Received

Example:  A store received 100 units of a promotional cereal in a special display unit on the 1st of the month.  Because the product is a one-time buy, they would like to be sold out by the end of the month.  The buyer believes the product should sell evenly throughout the month.   Two weeks into the promotion 30 units have been sold.

Calculation:  30/100 = 30% sell-thru

To achieve the buyer’s goal, the store needed to sell half of their inventory by this date.  They are behind and need to find a way to increase their sales rate.

NOTE:  I have greatly simplified the example given here.  In the real world, there are always complications.

What do I use it for?

Buyers often use sell thru to determine whether a product that is purchased with a finite amount of inventory will be sold by a pre-determined date.  Sell-thru can also be used to monitor inventory levels for regular products by using beginning of month inventory instead of total units received.

If you have questions concerning sell-thru, or would like to see a similar beginner’s guide for a different measurement, please let me know via a comment or an email.

Note:  Other retail math formulas may be found on the Three Buckets CheatsheetBeginner’s Guides on other retail math topics are also available.

Introducing… Sales!

23997574130_589b5c5632_m(1)While I cover most retail math measures toward the end of the semester, this isn’t true of sales. In my Retail Strategy courses, we begin looking at sales on the second day of class. After all, what is more fundamental to retailing than sales?

Typically I begin with the most recent data from both the U.S. Economic Census and the NRF to give an overall perspective on the total industry numbers. Then, the fun part begins. (Ok – fun for retail nerds like me.) The remainder of the class period is devoted to analyzing three lists: STORES Top 100 Retailers, STORES Hot 100 Retailers, and the Top 250 Global Retailers (as compiled by STORES and Deloitte). These lists contain each retailers’ annual sales data along with other pertinent data, and are a fun way to teach students a basic retail concept.

The lists also introduce them to many retailers they are unfamiliar with, while giving them an idea of just how massive (and global) these companies are.

photo credit: <a href=”http://www.flickr.com/photos/135810221@N02/23997574130″>Sem 01 – Soldes – Marco.DCN</a> via <a href=”http://photopin.com”>photopin</a> <a href=”https://creativecommons.org/licenses/by-nc-sa/2.0/”>(license)</a>

Helpful Links

Several of these links are math related, but some are just great general retail industry information.  At the bottom you will find teaching related blogs that I enjoy. View each by selecting ‘here’ next to the desired article/site.

Retail related:

Teaching related:

  • Joe Hoyle: Teaching – Getting the Most from Your Students: here

  • Teaching College English – the glory and the challenges: here

  • James M. Lang – Occasional reflections on higher education, religion, literature, and music. View here

  • Busynessgirl – What are you learning?: here