Category Archives: Teaching

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.

 

Retail Math & the Class Syllabus

It’s getting closer to the start of the Fall semester, and I’ve begun thinking about classes again.  For me, that means putting together my syllabi and class calendars.  Since I don’t make homework assignments part of my syllabi and I keep the class points fairly vague, my various syllabi don’t change too much from semester to semester.  The fact is, most of my changes revolve around my class calendar.

When it comes to adding retail math into a traditional Retail Strategy class calendar, I’ve found that there are two typical approaches.  The first is to approach retail math as a separate module, covering all of the topics in a 2-3 week span.  This is the approach I tend to use, and I fit the retail math topics into my class calendar right after merchandising.  I find that it works best for me to cover all of the math at once, allowing me to more easily explanation the inter-connectedness of the different measurements.

Excerpt from my class calendar:
Week 9
Customer Relationship Management
Private Labels
Week 10
Merchandise Management
Week 11
Category Management
Exam 3
Week 12
Retail Math – Volume Bucket
Retail Math – Profit Bucket
Week 13
Retail Math – Profit Bucket continued
Retail Math – Asset Efficiency Bucket
Week 14
Retail Math – Scorecards

My co-author, Charles Halliburton, favors the second approach.  He prefers spreading the retail math measurements throughout the semester utilizing them to illustrate how different marketing and merchandising decisions impact the company in a financial way.  With his background in retail merchandising and finance, he is able to use multiple real life examples to tie the topics together.

Both approaches are equally valid, and valuable.  If you’re willing to share, I would love to hear how you approach fitting this information into your semester.

 

Retail Math Books

Over the years I have had to do some real digging to come up with good retail math books.  There are several out there, and I thought I’d list a few of my favorites.  Some of them are out of print now, but the mathematical information in them is as good as ever.   This is by no means a comprehensive list, rather it is a listing of those books I tend to use for reference purposes in teaching my classes.  (The below are in no particular order.)

1.  Retail Merchandise Management by Wingate, Schaller & Miller – This is my all-time favorite.  The version I use was given to me by one of my professors (thank you Dr. Ashton!)  It never wanders too far from my desk.  While many parts of the book are dated, the math concepts are as solid as ever.  And, the many examples it offers are extremely valuable.  The best part of this book is the extreme breadth and depth of coverage it gives to retail math concepts and formulas.   (Note:  this book is out of print, but can be found on www.amazon.com.)    Wingate, J.W., Schaller, E.O., & Miller, F.L.  (1972).  Retail Merchandise Management.  Englewood Cliffs, N.J.:  Prentice-Hall, Inc.

2.  Problems in Retail Merchandising, 6th edition by Wingate, Schaller & Bell – Dr. Ashton gave this workbook to me also.  It was written as a compliment to Retail Merchandise Management, covering the same concepts but giving many more examples and homework problems.  I have found these problems and examples to be very helpful when I need to go deeper into retail math for my graduate level classes.  (Note:  this book is out of print, but can be found on www.amazon.com)    Wingate, J.W., Schaller, E.O., & Bell, R.W.  (1973).  Problems in Retail Merchandising, 6th Edition.  Englewood Cliffs, NJ:  Prentice-Hall, Inc.

3.  The Buyer’s Manual by the Merchandising Division of the National Retail Merchants Association – There are many versions of this particular book.  The one I use is from 1965.  I have tried some of the later versions and have not found them to be as helpful in their coverage of math concepts.   Much like Retail Merchandise Management, this book is dated concerning other concepts, but I have found many parts of it to be helpful in understanding how math principles and formulas apply to analyzing a retail operation.    National Retail Merchants Association.  (1965).  The Buyer’s Manual, Revised Edition.  New York, NY:  The Merchandising Division of the National Retail Merchants Association.

4.  Math for Merchandising by Moore – I really like the way Moore takes a section of each chapter to explain industry jargon to students.  This is something that I often overlook doing in class.  This text also does a very nice job explaining profit measures.  However, I feel it lacks in the areas of asset efficiency.    Moore, E.  (2005).  Math for Merchandising, Third Edition.  Upper Saddle River, NJ:  Pearson Education, Inc.

5.  Merchandising Math by Kincade, Gibson & Woodard – Like most books about retail math, this one has a distinct fashion orientation.  The book includes an interesting chapter on fashion forecasting where it looks at some of the more qualitative aspects of this task.  From a math perspective, I found the book to have good coverage of pricing and P&L statements.    Kincade, D.H., Gibson, F.Y., Woodard, G.A.  (2004).  Merchandising Math:  a managerial approach.  Upper Saddle River, NJ:  Pearson Education, Inc.

6.  Mathematics for Retail Buying by Tepper – This book has been around for some time and has gone through many editions.  It is a favorite in many apparel studies programs.  I appreciate the author’s simple explanations and many examples throughout the book.    Tepper, B.K.  (2008).  Mathematics for Retail Buying, 6th Edition.  New York, NY:  Fairchild Books, Inc.

7. & 8.  I really can’t end up this post without mentioning Retailing Management by Levy & Weitz  and Retail Management by Berman & Evans.  Both of these books are good general retailing texts and have begun to include more and more retail math with each edition.  I have used each as the main retail textbook for my classes at different points in time.

**Please note that I have cited the edition of each book that I have on my shelves, newer editions may be available in several cases.

Topshop Brings Fast Fashion to Nordstrom

The idea of combining fast fashion with traditional department stores has intrigued me ever since JCPenney went into partnership with Mango few years ago.  I can’t help but be fascinated by the concept of fashion clothing that is meant to be frequently replaced by consumers, and therefore must be updated weekly in stores (just think of the supply chain implications, not to mention the labor involved in changing a sales floor weekly.)  Bringing this high-turnover merchandising concept to stores known for carrying high margin/low turn merchandise is, well, fascinating.

It seems that the latest duet to try this concept is Nordstrom and Topshop, and this particular combination looks like a winner to me.  Whether it will be successful in the long run is always a matter of debate, but it’s an interesting concept from a three bucket perspective.  After all, Nordstrom is gaining not only the Topshop brand image, but also a fashion oriented product with a high turn rate (and great asset efficiency.)  On Topshop’s side of the table, they gain a large increase in distribution and an accompanying increase in volume.  (Sources:  Nordstrom Dresses British With Topshop to Win Back Women: RetailTopshop is Coming to Nordstrom)

Speaking of interesting partnerships, I’ve been reading several articles about how Neiman Marcus and Target are teaming up to create a limited edition of holiday merchandise (designed by top names such as Oscar de la Renta and Tory Burch) to be sold in both of their stores this coming December.  The partnership even has its own logo – an exclamation point with a Target’s bulls eye as the dot.  I understand what Target is getting out of this, but can anyone explain to me the benefit to Neiman Marcus???  (Sources:  Neiman Marcus and Target join forces to create holiday gifts; Retail’s New Odd Couple)

Credit Card Swipe Fees and the Profit Equation

While I don’t typically cover P&L statements in my classes, I do feel it is important that students have a basic understanding of how various costs and expenses (i.e. labor, taxes, utilities) can impact a retailer’s net profit.  Credit card swipe fees are one of the expenses that should be included in that list.

Some interesting classroom discussions can be held concerning credit card fees.  Most of my students seem to realize that they exist, but don’t realize exactly how much money retailers have to pay credit card companies monthly.  Once we start messing around with dollar figures, the situation becomes much more concrete and interesting for them.

An article by Emily Maltby appeared in the Wall Street Journal on July 11 that gave an excellent explanation of the credit card fee situation. (see “Bank Fees Squeeze Retailers,” Wall Street Journal, July 11, 2012.)

The article also reported that there might be a settlement reached in the lawsuits between retailers and banks and credit card networks this fall.  Whatever comes from this settlement could have some interesting implications for retailers.  This is especially true when you consider how the changes resulting from this settlement might impact both small and large retailers approaches to setting prices.