Edge Retail Academy Blog

Begin with the End in Mind, part 4 The ‘Inventory GAP’, cont.


by David Brown

Let’s recap what we have covered in the previous three articles:

Step 1                       –           The ‘GAP’ Analysis

Step 2                       –           The Gross Profit ‘GAP’

Step 3                       –           The Inventory ‘GAP’ – Part 1

Step 4                       –           The Inventory ‘GAP’ – Part 2

If you are serious about achieving your future wealth and retirement goals then please complete these steps before continuing with Step 4, Part 2.

Now that you understand how much inventory you need overall, i.e. across all categories it is time to calculate the inventory requirements in each category.

In order to understand how this works, you first need to understand GROI.


Understanding Gross Return on Investment (GROI)

GROI is a formula whereby Markup multiplied by Stockturn equals GROI. For example if your markup is 100% and your stockturn is 0.8 then your GROI is 80 (100 x 0.8).

What this means in real terms is that for every $100 you have invested in inventory, you are generating $80 of gross profit per annum.

Here’s how GROI works in other retail sectors.

Retail Sector Stockturn x Markup % = GROI
Music 5 x 30 = 150
Clothing 2 x 100 = 200
Groceries 12 x 14 = 168
Jewelry 1 x 110 = 110


Important: We are not recommending the Jewelry figures above … they are however typical of what we see when making these sorts of comparisons. As you can see, it is the combination of both stockturn and markup that is important. Groceries have by far the best stockturn and Jewelry has the best markup but overall, Clothing has the best GROI with $200 of gross profit from every $100 invested in inventory.


Here’s how GROI works within a Jewelry store.


Category Stockturn x Markup % = GROI
Diamond Rings 0.5 x 90 = 45
Gold Chain 0.7 x 145 = 105
Watches 1.4 x 70 = 97
Silver Jewelry 1.1 x 150 = 165


Important: Again, these are not recommended figures nor are we suggesting you throw out your Diamond Rings and replace them with Silver because we also need to consider your Return on Effort (ROE) … more on that later.

So in real terms, your GROI is the only way to genuinely compare the performance of one category with another. We often hear retailers complaining about markup and threatening to drop a product line that in reality has a better GROI than other products with a higher markup.

So how does this help you calculate the OIL for an individual category?

Well, following our example of ‘GAP’ Sales of $1,062,265, let’s say 10% of your sales are currently coming from Diamond Rings and you want this to increase to 12% this year. 12% of $1,062,265 equals $127,472 of Diamond Ring sales.

Let’s also say that you intend to increase your markup on Diamond Rings to 100% and achieve a stockturn of 0.8 (meaning on average you expect them to take 15 months to sell). The OIL calculation would look like this. (Please note we can quickly, easily and affordably help you setup a Sales and Inventory Plan if required.)

Optimum Inventory All Categories Diamond Rings
Sales Budget (based on 12% of total) $1,062,265 $127,472
Budgeted Markup % 112% 100%
Budgeted Gross Profit (GP) $561,195 $63,736
Budgeted Cost of Sales (COS) (Sales less GP) $501,070 $63,736
Budgeted Stockturn 1.2 0.8
Budgeted Inventory (COS ÷ by Stockturn) $417,600 $79,670
Current Inventory $591,050 $68,545


So as you can see, in this example you would have $11,125 to invest in Diamond Rings … but alas there is a little more to it than that because you are already arguably over stocked by $173,450 overall.

Action Steps:

  1. Decide what your business is going to look like in the next 12 months. For example, decide which categories you are going to build and which ones you are going to reduce (if any).
  2. Take each Category and determine what GROI you expect (remember this is a combination of your markup and stockturn in each category)
  3. Using these figures, calculate your Optimum Inventory Level (OIL) in each Category. Important: Do one at a time and start with the Categories that can make the greatest amount of difference in the shortest amount of time.
  4. If you are already over stocked in a Category, decide whether you will increase your sales budget to match your inventory or reduce your inventory.
  5. If you are under stocked in a Category, look at other Categories that may be over stocked and work out how you can redeploy the investment where it’s needed.
  6. Before rushing out and buying blindly, think carefully about the price points and margin you want to achieve, the image you want to create and the vendors you want to partner.

This concludes our 4-part series on knowing what you need to have in place, to retire successfully and with ease. Please reach out if you would like more personalized advice on your retirement plans.

Leave a Reply

Your email address will not be published. Required fields are marked *



Follow us on LinkedIn