Why use this calculator?
GMROI shows how much gross profit you earn for every dollar held in inventory on average. A high-selling category may generate solid gross profit and still tie up a large amount of cash. A smaller category that sells through quickly may earn more on each inventory dollar, even if it contributes fewer gross profit dollars overall.
Use this calculation before you move buying budget, commit to another season of a product, or review the same category across stores. Read the result alongside gross profit and availability. A category that spent much of the quarter out of stock can show a high GMROI on the stock it carried while leaving demand unmet.
How this calculator works
Choose a reporting period and isolate the same merchandise and locations in your sales, cost, and inventory reports. Use net sales after discounts and returns and take cost of goods sold from the same period. For average inventory, use the cost value of regular stock snapshots. Value the stock on the same cost basis you use for the goods sold.
GMROI = (net sales − cost of goods sold) ÷ average inventory at cost
In the example above, a specialty retailer sold $48,000 of running shoes in a quarter and recorded $28,800 in cost of goods sold. Gross profit was $19,200. Dividing that by the $12,000 it held in running shoes on average gives 1.6× GMROI. Gross margin was 40%, and dividing $28,800 in product cost by the same $12,000 inventory balance gives 2.4 inventory turns over the quarter.
The same formula is used for gross margin return in Oracle Retail Insights.
Who this calculator is for
Buyers and merchandise planners can compare similar categories before placing a seasonal buy. Store owners can use it to see which assortments earn their shelf space and working capital. Regional inventory teams can run it for the same category in two stores and investigate how local sales, markdowns, and stock depth explain the difference.
If a category has low GMROI and slow turns, review which styles or sizes account for the stock before deciding whether to reorder, transfer, or mark down. If it turns quickly and shoppers regularly find empty shelves, check what caused those stockouts. Use your demand forecast to set the next order quantity.
Frequently asked questions
What does a GMROI of 1.6× mean?
You earned $1.60 in gross profit during the period for every $1 of inventory you held on average at cost. Gross profit is measured before operating expenses such as rent and payroll.
What is a good GMROI for a retailer?
Set a target for your category and selling season. Compare equivalent products or locations over the same length of time, then look at gross profit dollars and stock availability. A high return on a small stock balance can coincide with missed sales.
How do I calculate average inventory at cost?
Average the cost value of inventory snapshots taken at regular intervals in the period. Use daily or weekly balances when stock changes materially. Averaging opening and closing inventory can give you a rough estimate when stock levels stay fairly steady.
Can GMROI be negative?
Yes. If product costs exceed net sales and you held inventory, the category lost money at the gross profit level. Check markdowns, returns, and whether the cost report matches the products and dates in your sales report.
What if average inventory or net sales are zero?
Average inventory of zero leaves GMROI and inventory turns undefined. Net sales of zero leaves the gross margin percentage undefined. You can still see gross profit in dollars in both cases.
How is GMROI different from gross margin and inventory turns?
Gross margin measures how much of each sales dollar remains after product costs. Inventory turns show how much inventory at cost moved relative to the stock you carried. GMROI ties gross profit dollars to the average inventory dollars invested.
Should I calculate GMROI monthly, quarterly, or annually?
Monthly figures help spot a shift, a full selling season can capture a seasonal buy, and a year covers more of the buying cycle. Compare equal-length periods with a similar selling pattern. A result from this calculator covers the dates you selected.
How do markdowns and returns affect GMROI?
Use net sales after markdowns and returns and use product costs after return adjustments. When net sales are negative, gross margin is unavailable. When costs are negative, inventory turns are unavailable. Check a longer period that captures more of the original sales.
Can I combine GMROI across stores or categories?
Add gross profit dollars across the groups and divide by their combined average inventory at cost for the same dates. Use consistent valuation and avoid counting the same ecommerce or POS sale twice. Averaging the ratios gives small and large assortments equal weight.
Important retail metrics
Review these measures alongside GMROI to see whether a change came from margin, sales, or the amount of stock you carried.
- Gross profit
-
Net sales minus cost of goods sold for the period.
Check the total gross profit dollars before moving buying budget between categories.
- Gross margin
-
Gross profit divided by net sales, expressed as a percentage.
Look for changes caused by pricing, discounts, returns, or product costs.
- Average inventory at cost
-
Average value of stock held during the period using a consistent cost basis.
Find out how much merchandise investment each store or category typically carries.
- Inventory turnover
-
Cost of goods sold divided by average inventory at cost for the same period.
Distinguish slow-moving stock from a margin issue when GMROI falls.
- Sell-through rate
-
Units sold as a share of units available for sale during the period.
Check how much of a seasonal buy sold and how much stock still needs a plan.