A GMROI calculator works out the gross margin return on inventory investment: how many dollars of gross profit a retailer earns for each dollar it keeps tied up in stock. Enter the gross profit for a year and the average inventory at cost, and the calculator divides one by the other. Add sales to see the gross margin and the number of times the inventory turned over during the year, the two things that together drive GMROI.
The GMROI formula
GMROI = gross profit for the year ÷ average inventory at cost
= gross margin ÷ (100% − gross margin) × inventory turns
Inventory turns = cost of goods sold ÷ average inventory at cost
The GMROI measure answers a simple question: for each unit of average inventory held at cost, how many units of gross profit did the business generate in a year? Average inventory is often taken from twelve or thirteen monthly values. Alternative formulas show that GMROI can be built from the margin percentage and inventory turns, and that every version reduces to gross margin divided by average inventory cost.
How to use the GMROI calculator
- Enter gross profit for the year: sales minus cost of goods sold.
- Enter average inventory at cost over the same year.
- Optionally enter sales to see the margin and inventory turns.
- Press Calculate.
Worked example
A standard example is a business with $100,000 of annual gross profit and an average inventory cost of $25,000, which gives a GMROI of 4.0: every dollar of stock earned four dollars of gross profit over the year. If its sales were $250,000, the gross margin is 40 percent and cost of goods sold is $150,000, so the stock turned over six times. The alternative formula gives the same answer: 40 ÷ 60 × 6 = 4.0.
Shorter periods
GMROI is normally measured over a year. Shorter periods give smaller figures with the same inventory: $8,000 of gross profit in July against $25,000 of average inventory gives 0.32 for the month, and $4,000 in the first two weeks of July gives 0.16. When comparing products or stores, make sure the period is the same for each, or the comparison will mislead.
What is a good GMROI
Generally, the higher the GMROI the better for a seller, and a rule of thumb from a 2013 survey is that a typical retailer's GMROI is above 3.0. A figure below 1 means the stock earned less gross profit in a year than it cost, which is usually a warning sign. Typical values differ widely between kinds of products: fast-moving goods with thin margins can have the same GMROI as slow-moving goods with high margins, because turns and margin work together.
Two ways to raise GMROI
The alternative formula shows the two levers. Raising the gross margin, by buying more cheaply or pricing higher, lifts GMROI if turns stay the same. Raising inventory turns, by holding less stock for the same sales, lifts it too. A product with a 40 percent margin turning six times a year has a GMROI of 4.0; the same product turning eight times would reach 5.3. Cutting the stock of items that rarely sell can raise GMROI without changing prices. For margins, the gross margin calculator helps, and for stock levels the inventory calculator.
Limits of GMROI
GMROI has several shortcomings. GMROI ignores the costs of holding stock, such as storage, handling and spoilage, so two products with the same GMROI can make very different contributions to profit. Sell-off items can look better than replenished basics, and GMROI is one of the few measures for which it is virtually impossible to set a precise goal. Use it to compare products, suppliers or stores alongside other measures, rather than as a single target.
Average inventory at cost
Use the cost of the stock, not its selling price, because GMROI compares profit with the money actually invested. Averaging monthly values smooths out seasonal peaks, such as stock built up before the holidays. Using only the year-end figure can make GMROI look much better or worse than it really is if stock happens to be unusually low or high on that date.
Comparing product lines
GMROI is especially useful for comparing categories within the same store, because they share the same space and staff. Work out the gross profit and average stock for each category over the same year and compare the results. A category with a much lower GMROI than the rest may be overstocked or under-priced, while a category with a very high GMROI may deserve more space or a deeper range.
Common mistakes
- Valuing inventory at selling price. Use cost.
- Using sales instead of gross profit. GMROI uses gross margin dollars.
- Mixing periods. Use a full year of profit with the year's average stock.
- Using a single year-end stock figure for a seasonal business.
A second GMROI example: margin against turns
A furniture line earns $60,000 of gross profit in a year on $200,000 of sales, with an average inventory of $40,000 at cost. The GMROI calculator gives a GMROI of 1.5, a gross margin of 30 percent, cost of goods sold of $140,000 and 3.5 inventory turns.
A fresh food line earns $30,000 of gross profit on $150,000 of sales with only $5,000 of average stock. Its margin is just 20 percent, but its stock turns 24 times a year, so its GMROI is 6. The alternative formula gives the same answers: 30 ÷ 70 × 3.5 = 1.5 and 20 ÷ 80 × 24 = 6. The lower-margin line earns four times as much gross profit for each dollar of stock, because the money tied up in it comes back far more often.
What next
Use this often? Add GMROI to your Home screen.
Frequently asked questions
How does a GMROI calculator work?
It divides a year's gross profit by the average inventory held at cost.
What is the GMROI with $100,000 of gross profit and $25,000 of average inventory?
4.0, as in the standard example.
What is a good GMROI?
A rule of thumb from a 2013 survey is that a typical retailer's GMROI is above 3.0.
How do margin and turns relate to GMROI?
GMROI = margin ÷ (100% − margin) × inventory turns.
What does GMROI leave out?
The costs of holding stock, such as storage and handling.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.