GMROI Calculator - Gross Margin Return on Investment
Find out how many dollars of gross profit your inventory investment generates. Enter net sales, COGS, and average inventory cost to benchmark inventory efficiency instantly.
📦 What is GMROI (Gross Margin Return on Investment)?
GMROI (Gross Margin Return on Investment), also written as GMROII (Gross Margin Return on Inventory Investment), is a retail performance metric that measures how many dollars of gross profit a business generates for every dollar invested in inventory. The formula is simple: GMROI = Gross Profit divided by Average Inventory Cost. A GMROI of 2.50 means that for every dollar tied up in stock, the business earns $2.50 in gross profit before operating expenses are deducted.
GMROI is used heavily in retail, wholesale distribution, and any inventory-heavy business. Merchandise planners use it to rank product categories and decide where to allocate open-to-buy budget. Buyers compare supplier proposals using GMROI to ensure margin and turn targets are both achievable. Category managers use it to identify underperforming SKUs that hold too much inventory relative to the profit they generate. Finance teams track GMROI as a capital efficiency indicator because inventory is a use of working capital: a higher GMROI means each dollar of working capital is doing more work.
A critical distinction: GMROI is not the same as inventory turnover, and neither replaces the other. Turnover (COGS divided by Average Inventory) tells you how fast stock is sold but ignores margin completely. A product can turn 12 times a year at a 10% gross margin and still have a poor GMROI of 1.2x. A slower-moving luxury item turning 3 times at 60% margin achieves a GMROI of 1.8x, which is substantially better. GMROI captures both dimensions simultaneously, making it a more complete picture of inventory productivity than turnover alone. Similarly, gross margin percentage tells you nothing about how efficiently inventory is deployed, while GMROI connects margin directly to the investment required to support it.
This calculator offers two modes. Compute GMROI takes your net sales, cost of goods sold, and average inventory cost and returns GMROI alongside gross profit, gross margin percentage, inventory turnover, days in inventory, and net sales per dollar of inventory. Target GMROI works in reverse: you set a GMROI goal, enter the average inventory you plan to hold, and specify your expected gross margin percentage. The calculator then tells you exactly what net sales and COGS you must achieve to hit that target, along with the inventory turnover rate and days-in-inventory implied by those numbers.
📐 Formula
GMROI = Gross Profit ÷ Average Inventory Cost
Gross Profit = Net Sales − Cost of Goods Sold (COGS)
Average Inventory Cost = (Opening Inventory Cost + Closing Inventory Cost) ÷ 2
Gross Margin % = (Gross Profit ÷ Net Sales) × 100
Inventory Turnover = COGS ÷ Average Inventory Cost
Days in Inventory = Average Inventory Cost ÷ COGS × 365
Target Net Sales = (Target GMROI × Avg Inventory) ÷ (Gross Margin % ÷ 100)
Example: Net Sales $500,000, COGS $300,000, Avg Inventory $100,000. Gross Profit = $200,000. GMROI = $200,000 ÷ $100,000 = 2.00x
📖 How to Use This Calculator
Steps
1
Enter net sales - Type the total net revenue for the period. Use the same period length (monthly, quarterly, or annual) for all inputs so the ratios are consistent.
2
Enter cost of goods sold - Enter the direct cost of all goods sold in the same period. This must be less than net sales. Do not include operating expenses such as rent or labour, only the direct cost of merchandise.
3
Enter average inventory cost - Enter the average inventory value at cost (what you paid suppliers), not at retail price. Use (Opening Stock plus Closing Stock) divided by 2 for the period, or the average of monthly closing stocks for an annual figure.
4
Read GMROI and supporting metrics - The calculator returns GMROI, gross profit, gross margin percentage, inventory turnover, days in inventory, and net sales per dollar of inventory. Switch to Target GMROI mode to find the net sales you must hit to achieve a specific GMROI goal given a planned average inventory and gross margin.
💡 Example Calculations
Example 1 - Apparel Retailer (Annual Performance Review)
Net Sales $800,000, COGS $480,000, Average Inventory $160,000
1
Gross Profit = $800,000 minus $480,000 = $320,000. Gross Margin = $320,000 divided by $800,000 = 40%.
2
GMROI = $320,000 divided by $160,000 = 2.00x. This means every dollar of inventory generates $2.00 of gross profit. For apparel, 2.0x is the minimum acceptable benchmark. The buyer should aim to push this above 2.5x through tighter inventory management or margin improvement.
3
Inventory Turnover = $480,000 divided by $160,000 = 3.0x. Days in Inventory = $160,000 divided by $480,000 times 365 = 122 days. This is on the high side for apparel, suggesting an opportunity to reduce safety stock or increase sell-through rates.
GMROI = 2.00x | Gross Margin = 40% | Days in Inventory = 122 days
Try this example →Example 2 - Grocery Category (High Turn, Thin Margin)
Net Sales $2,000,000, COGS $1,700,000, Average Inventory $200,000
1
Gross Profit = $2,000,000 minus $1,700,000 = $300,000. Gross Margin = $300,000 divided by $2,000,000 = 15%.
2
GMROI = $300,000 divided by $200,000 = 1.50x. The 15% gross margin is thin, but very high inventory turns compensate. Inventory Turnover = $1,700,000 divided by $200,000 = 8.5x. Days in Inventory = $200,000 divided by $1,700,000 times 365 = 43 days.
3
A GMROI of 1.50x would be unacceptable in apparel, but in grocery it is close to benchmark. The category manager may focus on reducing average inventory further or negotiating better supplier terms to push GMROI toward 2.0x.
GMROI = 1.50x | Inventory Turnover = 8.5x | Days in Inventory = 43 days
Try this example →Example 3 - Target GMROI Planning (Open-to-Buy)
Target GMROI 3.0x, Average Inventory $75,000, Gross Margin 45%
1
Required Gross Profit = 3.0 times $75,000 = $225,000. This is the minimum gross profit the category must generate to justify the planned inventory investment.
2
Required Net Sales = $225,000 divided by 0.45 = $500,000. Required COGS = $500,000 minus $225,000 = $275,000.
3
Implied Inventory Turnover = $275,000 divided by $75,000 = 3.67x. Days in Inventory target = $75,000 divided by $275,000 times 365 = 100 days. These become the operational targets for the buying season.
Required Net Sales = $500,000 | Inventory Turnover needed = 3.67x
Try this example →❓ Frequently Asked Questions
What does GMROI stand for and how is it used in retail?
GMROI stands for Gross Margin Return on Investment (sometimes written GMROII for Gross Margin Return on Inventory Investment). It measures how many dollars of gross profit a retailer earns per dollar of inventory. GMROI = Gross Profit divided by Average Inventory Cost. Retailers use it to rank product categories, evaluate buying decisions, set open-to-buy budgets, and identify stock that is tying up working capital without generating enough gross profit.
What is a good GMROI for a retailer?
A GMROI above 1.0 means gross profit exceeds inventory cost, which is the minimum threshold. Most general merchandise retailers target 2.0x or above. Grocery and fast-moving consumer goods often reach 3.0x to 5.0x because of rapid inventory turns. Apparel typically targets 2.0x to 3.5x. Specialty or luxury retailers may accept 1.5x to 2.5x. Always benchmark against your specific sector because acceptable GMROI varies significantly by category and turn rate.
How do I calculate GMROI from gross margin percentage and inventory turnover?
GMROI can be approximated as (Gross Margin % divided by 100) times (Net Sales divided by Average Inventory Cost). Since Net Sales divided by Average Inventory Cost equals sales-to-stock ratio, GMROI roughly equals Gross Margin % times sales-to-stock ratio divided by 100. For exact results enter net sales, COGS, and average inventory directly into this calculator rather than using approximations. The approximation is useful for quick benchmarking when you know margin and turns but not exact inventory figures.
Should I use retail or cost value for average inventory in GMROI?
Always use cost value (what you paid suppliers) for average inventory in the GMROI formula. Using retail value inflates the denominator and produces a lower GMROI than the true economic ratio. The cost method is the standard used by NRF (National Retail Federation) and retail finance benchmarking firms. If your inventory system tracks stock at retail (the retail inventory method), convert to cost by multiplying by (1 minus your average cost complement, which equals 1 minus gross margin ratio).
What is the difference between GMROI and inventory turnover?
Inventory turnover = COGS divided by Average Inventory. It measures how fast inventory is replaced, with no regard for margin. GMROI = Gross Profit divided by Average Inventory. It combines margin and turn into one metric. A high-turn, low-margin product may have a poor GMROI. A low-turn, high-margin product may have an acceptable GMROI. GMROI rewards both efficiency and profitability together, making it more useful than turnover alone when comparing categories with different margin structures.
Can GMROI be above 100% and what does that mean?
GMROI is typically expressed as a ratio (e.g. 2.5x) rather than a percentage, but multiplying by 100 gives 250%, which means gross profit is 2.5 times the inventory investment. A GMROI above 1.0x (or 100%) is standard for healthy retailers. Very high GMROI values (5x or above) are normal in categories with thin inventory requirements relative to sales volume, such as digital downloads, perishable goods with rapid turns, or drop-shipped products where you hold almost no physical stock.
How does GMROI help with inventory reduction decisions?
By calculating GMROI for individual SKUs or categories, you can rank them from highest to lowest GMROI. SKUs with low GMROI consume working capital without generating proportionate gross profit. The action is either to improve their margin (renegotiate cost or raise price), increase their turn (better promotions, tighter reorder quantities), or rationalize them from the assortment entirely. Liquidating low-GMROI stock frees capital to invest in high-GMROI lines, raising overall portfolio efficiency.
What time period should I use for GMROI calculations?
GMROI is most commonly calculated annually, matching the fiscal year for benchmark comparison. You can calculate it quarterly or monthly for operational monitoring, but all three inputs (net sales, COGS, average inventory) must use the same time period. For a monthly GMROI, use monthly net sales, monthly COGS, and average inventory for that month. Annualise by multiplying the monthly GMROI by 12 only if you are comparing against annual benchmarks.
How does GMROI relate to open-to-buy budget planning?
Open-to-buy (OTB) is the dollar amount a buyer is authorised to spend on new inventory in a period. To use GMROI in OTB planning: decide the target GMROI for the category, set the planned average inventory (the OTB ceiling), and determine the gross margin target. Required gross profit = Target GMROI times average inventory. Required net sales = gross profit divided by gross margin ratio. These become the sales plan targets that justify the OTB budget. Use the Target GMROI mode in this calculator to run these scenarios instantly.
What is days in inventory and how does it connect to GMROI?
Days in Inventory (DSI) = Average Inventory Cost divided by COGS times 365. It shows how many days it takes to sell through the average inventory on hand. A lower DSI means faster turns, which tends to raise GMROI when margin is held constant. GMROI and DSI move in opposite directions: halving DSI (selling twice as fast) roughly doubles GMROI assuming the same gross margin. Retailers use DSI to set maximum acceptable stock levels and trigger reorder or markdown decisions before stock ages.
Is GMROI used outside of retail?
Yes. Wholesale distributors use GMROI to rank product lines and supplier relationships. Manufacturers use it to evaluate finished goods inventory versus raw materials. Pharmacies track GMROI by therapeutic category to manage tight working capital. Any business that holds physical inventory and generates gross margin can use GMROI as a capital efficiency metric. Outside inventory-heavy businesses, a related metric called Return on Assets (ROA) serves a similar purpose across a broader asset base.
How does product mix affect GMROI?
When you blend high-GMROI and low-GMROI products in a category, the overall GMROI is the weighted average of each product's gross profit relative to its share of average inventory. Shifting the product mix toward high-GMROI items, even without changing total inventory or total sales, raises the blended category GMROI. Assortment decisions and planogram allocation should consider GMROI per square foot of shelf space, which adds the space constraint and gives the most complete picture of floor productivity.