GMROII is one of those terms that is bandied about a lot, but yet is surprisingly poorly understood. The reason it is referred to regularly is because if well integrated into the thinking process, it is one of the most powerful KPIs by which to manage a retail business. However, the fact that there are so many different definitions of GMROII has contributed to a general confusion about how to measure it and use it as a tool for driving value.

So why is it that one of the most useful metrics is hardly used?  It is frankly rare, both in this country and abroad, to find a retailer actively and regularly using it as a KPI.

Fundamentally GMROII (Gross Margin Return on Inventory Investment) is a measure of how efficiently you manage your stock and your markdowns. While there are many variations on the theme, it basically tells you what return you are receiving (in each category) for every dollar you have invested in stock. It does not measure volume – just efficiency.

The most common formula used is: Gross Profit after markdowns divided by Average Monthly Stock at Cost. The period used is usually 12 months which can be a rolling 12 months.

Let’s see how this translates to other metrics that we are more familiar with.

If you plan an input margin of 80% and you plan markdowns at 20% and you are working on say 3 months stock, your GMROII is 12. In other words you are planning on returning $12 per annum for every dollar invested in stock. Not a bad result!!

If you plan an input margin of 50% and plan on no markdowns and you are working on say 4 months stock, your GMROII is 3.   Or $3 returned for every dollar invested in stock. Not a great result.

Therefore to calculate your planned GMROII you only require three numbers:

• Input margin %
• Stockturn
• Markdown %

(To calculate actual GMROII you will need actual GP after markdowns and actual average stock at cost).

And of course you can work it backwards. Calculate how much gross profit you want or need to make and what you want or need to invest in stock.

Probably one of the reasons that this metric is not widely used is simply that it is not really understood.

Here is an example of a GMROII calculation

Input margin 80%
Markdowns 40%
Stockturn 5
GMROII 10


Try out the GMROII calculator by clicking on the link below:

krunchbox GMROII Calculator

Alternatively, click on the link below to request a copy of the worksheet.

Email krunchbox Enquiries

Inculcate GMROII into the company, and your buying and inventory control will take on a new dimension.

 

Posted
AuthorAndrew Johnston