GMROI for furniture stores: which vendors earn their floor space

Vendor A earns a 52% margin, and the floor team loves the range. Vendor B earns 41%, and you have been considering giving its space to someone else. Then you account for the money tied up in each program, and the ranking changes.

In this illustrative comparison, A turns 1.2 times annually and produces GMROI of 1.30. B turns 3.0 times and produces about 2.08. GMROI helps explain why: the measure combines gross-profit generation with the inventory investment required to produce it.

Calculate gross-profit dollars per inventory dollar

GMROI is gross margin return on inventory investment. Divide gross-profit dollars by average inventory at cost, using the same time period and product scope. Intuit’s GMROI guide gives that basic formula.

For this article, gross profit means net merchandise sales less the matching cost of goods sold, before commission and general operating expenses. Inventory is valued at cost, not at its ticket price.

The formula is:

GMROI = gross profit ÷ average inventory at cost

A result of 2.5 over a year means $2.50 of gross profit for each $1 of average inventory investment during that year. It does not mean $2.50 of net profit after the store’s expenses.

Keep the period attached. A quarter’s GMROI and a full year’s GMROI are not comparable merely because they use the same formula.

Work the store-level example

Say a defined stock program produces $2 million in annual net sales, with $1 million of cost of goods sold and $400,000 of average inventory at cost. The resulting gross profit is $1 million.

At a 50% gross margin, gross-profit dollars equal cost of goods sold, so GMROI equals cost-based inventory turns. That equality is a feature of the arithmetic, not a rule that holds at every margin.

The inventory-turns guide explains how to keep the stock population consistent when the store also sells made-to-order furniture.

See why the vendor ranking flips

When turns use cost of goods sold, GMROI can also be calculated from the gross-margin percentage:

GMROI = turns × gross-margin rate ÷ (1 − gross-margin rate)

Use the margin as a decimal. The formula works because gross profit is sales times the margin, while COGS is sales times one minus the margin.

Vendor B generates more gross profit per dollar of average stock investment in this comparison. That gives the buyer a reason to reconsider the proposed floor-space change.

It does not settle the decision alone. Vendor A might be an important display program that generates substantial special orders. Measure that contribution separately and explicitly. Otherwise, the store either over-rewards the stock range or overlooks what the display is doing.

Match the sales and inventory populations

A stock-program GMROI should include the gross profit from that stock program and the inventory investment supporting it. Exclude the special-order program from both sides when the purpose is to judge speculative stock.

Do not add special-order gross profit to the numerator while leaving the corresponding inventory investment outside the denominator. That makes a slow stock program look productive because other business is carrying its result.

Special orders are not literally inventory-free in every situation. The store may own goods during transit or while awaiting customer delivery. Keep that activity in its defined segment and review its margin and cash commitments separately.

A zero or near-zero average inventory balance also needs care. GMROI may be undefined or extremely sensitive to small timing changes. Such a result is a reason to use a more suitable measure for that business, not a sign of unlimited performance.

Include floor samples and handle reserved stock consistently

Owned floor samples count as inventory while they remain inventory under the store’s accounting policy. Their display purpose does not erase the money tied up in them.

Keep sample cost, age, condition, and sale history visible. A program can deserve a place on the floor while still needing a planned sample replacement or markdown. The aged-inventory guide helps make that decision before a sample becomes a permanent fixture.

Stock reserved for a customer who paid a deposit also needs consistent treatment. The reservation changes availability; it does not by itself remove owned inventory from the financial calculation. Keep it in the stock-program denominator until the matching sale and cost are recognized under the chosen basis.

Units bought specifically for a customer can be tracked in the special-order segment instead. The rule is to match the population throughout, rather than exclude every held unit while retaining its eventual stock-sale profit.

Average actual inventory values through the period

Use recorded inventory-at-cost balances across the year rather than choosing the month-end that gives the most flattering result. Averaging the 12 month-end balances is a practical starting method; more frequent snapshots help when inventory changes sharply within a month.

Include landed cost consistently. Factory-only inventory values paired with gross profit based on landed COGS put the two sides on different bases.

If the costing method changed during the year, have the bookkeeper produce a consistent comparison or clearly separate the periods. Do not combine historical balances from one method with COGS from another without explaining and reconciling the change.

Keep the underlying snapshots. A current cost field cannot reconstruct every past month’s inventory value. Shopify describes Cost per item as a single static value, which is why dated records and the selected costing method matter.

Gather the inputs with OrderPilot

OrderPilot supplies purchasing charges, receipt landed costs, and configuration-level stock records. The chosen costing method supports the cost allocations behind sales, while Shopify’s current cost field is kept up to date. Analytics › Profit can group results by vendor for staff with View costs and View all commission and profit. Its Net figure is after commission, so it is not the gross-profit numerator for GMROI. Reconcile selling less cost and freight before commission, then restrict the worksheet to the matching stock sales and recognition period. Take average inventory from dated Shopify reports or the books, reconciled to the same scope and cost basis. Calculate GMROI in the worksheet; OrderPilot does not supply a native GMROI or turns report. Its linked purchasing and stock records help explain the inputs and the exceptions.

The gross-margin benchmark guide is useful here because a consistent gross-profit definition matters more than an attractive percentage.

Use a low result to ask the next buying question

A GMROI below 1 means the period’s gross profit was less than average inventory at cost. It does not mean that the store lost the difference as capital, because the inventory investment and the gross profit are different measures. Whether the program is satisfactory depends on the period, costs, risks, and its purpose.

Review vendors quarterly as a proposed routine, using a consistent trailing annual period where possible. Look at stock age, markdowns, stockouts, damage, and delivery reliability alongside the ranking.

Suggested age buckets such as up to 90 days, 91–180, 181–365, and over 365 make the review easier to organize. They are working categories, not furniture-industry deadlines. A display commitment and a slow speculative purchase may need different decisions.

Use the vendor scorecard to add service and buying context. A range with strong GMROI but persistent damage can still create work the ratio does not capture.

Fill in the vendor review sheet

Bring the inputs and decision together so the analysis ends in an action.

The largest chair in the gallery does not automatically deserve the largest share of the buying budget. Use the inventory dollars, the gross profit, and the program’s purpose together. Add the resulting decisions to the owner’s dashboard review.

Sources

1. What is GMROI? — Intuit QuickBooks; formula and definition.
2. Migrating from Stocky to Shopify inventory management: inventory costs — Shopify Help Center.