Stock comes in, goes out, prices and margins change all the time and its very hard to determine by gut feel what is working and what is not. This is what Gross Margin Return on Stock (GMROI) does, it measure your actual stock items and gives you a feel of what is the best financial return on your stock? It is generally but not always measured by department or supplier. It allows you to ask yourself, where is my money going to produce the best profit, I can get as what it tells you is that for every dollar you invest in stock, what items give you the best return?
Here is how it is calculated manually.
Step #1: Gross Margin in Dollars= Sales x Margin%
So say you sold $1000 last year of an item, your margin was 30%, so your profit is $300.
Step #2: Average stock holding = ((Stock at start of the year) + (Stock at the end of year))/2
You started the year with $1600 of stock and ended the year with $100 so your Average stock holding = (1600+100)/2 = $850.
Step #3: GMROI = (Gross Margin in Dollars )/(Average stock holding)
GMROI = ($300)/($850) = 0.35
What it tells you is that for every dollar you have invested in stock, you are getting a dollar back to pay all your expenses and buy new stock.
What it tells you is that for every dollar, you invested in that item, you made 35 cents. Of course, no one can maintain a business at that level; I just made a simple example to explain the concept.
If you notice, the calculation itself is almost manually impossible to do for each item. Here are some immediate problem points, items often do not have a steady margin; the 30% is often an ideal that a supplier provides and my stock holding obviously, here varied a lot during the year. Say, for example, my Margin was closer to 25%, so I made $250 and my average stock holding over the year was $100,
My GMROI = ($250)/($100) = 2.5, so I made for every dollar on that item $2.5 which is much better.
A computer can of course overcome all these problems.
GMROI for dummies
Go to register reports
Select GMROI marked in green
Now select the date you require. I suggest looking at the latest three months and the last year, although many do find a three-year period useful too.
I selected in this shop confectionery.
Out pops a report that looks like this among other items.
Now in green the On-Hand figure is zero; the stock ran out, that would be definitely one to look at what happened there and the one marked in red; it has a negative result; this is almost certainly due to data errors which I will discuss in another post.
As these two items show, to get any use from GMROI you need to export the data into excel or openoffice (openoffice is free and well worth getting if you do not have excel) where you can edit and remove if necessary bad data.
So on the top left-hand side, click export (where the green arrow is), and click excel where it's marked in purple.
Now you have a list to review and edit. That is why it must in my view be in excel otherwise you cannot really do GMROI.
High turnover, high GM% and low stock holding are perfect while low turnover, low GM% and high stock holding are terrible.
However high number do not necessarily indicate that all is good, it often means you are under ordering and do not have enough stock, although sometimes it means that the item does really well but only very few people come into your shop to get it. So you are not going to sell much more if you bring in more stock. Maybe look at add on sales for that item instead. Low numbers tend to indicate that you are over ordering.
Only you know the retail dynamics of your shop and it can help and a detailed system of stock control like ours, can keep the customer satisfied and you in business.
