# GMROII

﻿
GMROII

Gross Margin Return on Inventory Investment (GMROII) is a ratio in microeconomics that describes a seller's income on every dollar spent on inventory. It is one way to determine how valuable the seller's inventory is, and describes the relationship between total sales, total profit from total sales, and the amount of resources invested in the inventory sold. A seller will aim for a high GMROII.Since the inventory is a very widely-ranging factor in a seller's investment, it is important for the seller to know how much she might expect to gain from it. The GMROII answers the question "for each dollar at cost, how many dollars of gross profit will I generate in one year?" GMROII is traditionally calculated by using one year's gross profit against the average of 12 or 13 units of inventory at cost. A rule of thumb is that a GMROII of at least 3.2 is the breakeven for a business.

GMROII in the Retail Industry

GMROII is particularly important in the retail industry where stock turn (i.e. sales units divided by average inventory units) and Gross Margin Percent (simply called margin) can vary heavily by item, location, and week. GMROII can act as the main driver for retailers to analyze their product and store offering. This metric does not suffer from the major disadvantages some of the other main performance metrics do.

For example:
*Products or stores with high sales often have lower margin or excessive inventory
*Products with a high stock turn often have a low margin
*High margin items are often slow sellers and thus produce low profits
*High profit products often have low margin, high volume sales but also high inventory levels that prevent other products from being displayed and sold

Retailers usually drive their business based on sales or margin. In a retailer where budgets and bonuses are based on sales, employees often achieve that by lowering the margin or putting too much stock in their stores. A high GMROII indicates a good balance of sales, margin, and inventory cost.

Average GMROII

Financial textbooks often show a formula with a yearly or monthly calculation. When tactical decisions are required for variable time periods, it is helpful for systems to be set up so that GMROII can be analyzed at either the yearly, monthly, or weekly level. Due to the textbook GMROII formula, depending on the time period, a different result would occur.

For example:
*(\$100,000 annual profit) / (\$25,000 average inventory cost) = GMROII of 4.0
*(\$8,000 July profit) / (\$25,000 average inventory cost) = GMROII of 0.32
*(\$4,000 first two weeks of July profit) / (\$25,000 average inventory cost) = GMROII of 0.16

Therefore it is advantageous to use Average Weekly GMROII which takes time out of the picture. That way, the retailer looks at similar types of numbers regardless of how many weeks are being looked at. The formula is:Average Weekly GMROII = (Profits for the total time period) / (Sum of each week ending inventory cost value)

Alternative Formulas for GMROII

Other formulas that are often given for GMROII are the following (note that all of these are mathematically equivalent because all can be reduced down to Margin/Avg_Inventory_cost):
$\left(Margin % / \left(100% - Margin %\right) \right) * Annual Inventory Turns$
$\left(Margin/COGS\right) * Annual Inventory Turns$
$Margin % * \left(Sales / Avg Inventory Cost\right)$

In the formulas above, "Margin %" refers to margin as a percent of sales, "Annual Inventory Turns" refers to COGS / Avg Inventory Cost.

hort-coming of GMROII

A short-coming of GMROII driven analysis is that items with high sell-offs (i.e. the final stock level falls towards zero) appear better than items with constant inventory supplies. Fashionable items that totally sold off will appear better than basic items such as black socks that are replenished by reorders. This is particularly evident when analyzing shorter time periods or item level information rather than higher level (department) information.