Product Mix Analysis: Which SKUs Deserve More Capital?

Product mix analysis asks which products deserve the next dollar of inventory, the next hour of capacity and the next slot of shelf space, and the honest answer is almost never the product with the highest margin percentage. What matters is what each product returns on the scarce resource it consumes: cash tied up in inventory, machine time, warehouse space or marketing attention. This guide shows how to rank products by return on inventory and by constrained capacity, how to measure the effect of a change in mix on profit with checked arithmetic, and how to turn the result into capital allocation decisions. It belongs to unit economics and budgeting and forecasting, builds on channel profitability and gross margin, and leads to ten ways to improve margins without raising prices.

The principle: allocate scarce resources to the highest return

Every business has a limiting factor. In a manufacturer it may be machine hours. In a retailer it may be shelf space. In most product companies it is working capital: there is only so much cash to put into inventory. A product with a 40 percent margin that turns twice a year ties up cash for six months. A product with a 25 percent margin that turns ten times a year ties it up for five weeks. Over a year, the second product may earn far more per dollar invested.

Measuring return on inventory

Gross margin return on inventory investment (GMROI) divides annual margin dollars by average inventory at cost. Use contribution in place of gross margin for decisions, since contribution includes freight, fees and returns.

Return on inventory = Annual contribution / Average inventory at cost

A hypothetical range of five products (illustrative):

Check: 300 + 240 + 90 + 150 + 60 = 840 (thousands); 100 + 120 + 150 + 50 + 30 = 450; 840 / 450 = 1.867.

Product P3 holds a third of the inventory (150 / 450) and earns 10.7 percent of contribution (90 / 840). Its return is 0.6, less than one-third of the company average. Products P1 and P4 return 3.0, yet together they hold only $150,000 of inventory.

Reallocating capital: a cautious estimate

Suppose management moves $60,000 of inventory investment from P3 to P1. The naive calculation says P3 loses 60,000 × 0.6 = $36,000 and P1 gains 60,000 × 3.0 = $180,000, a net gain of $144,000. That assumes P1 can sell unlimited extra units at its current return. In practice, returns diminish: the additional stock goes to the demand that was previously unmet, and further stock goes to weaker demand. If the marginal return on P1 is half the average (1.5), the gain is 60,000 × 1.5 = $90,000, and the net is 90,000 - 36,000 = $54,000. Test the marginal assumption by looking at stockout history and lost sales for P1 before acting.

Measuring return on a constrained resource

When capacity is limited, rank by contribution per unit of the constraint. A factory with 10,000 machine hours makes two products:

Product Q has the higher contribution per unit, but P earns more per machine hour. Fill P first: 12,000 units use 6,000 hours. The remaining 4,000 hours make 4,000 units of Q. Total contribution = 12,000 × 30 + 4,000 × 45 = 360,000 + 180,000 = $540,000. If the factory instead concentrated on Q, 10,000 units would use all 10,000 hours and earn 10,000 × 45 = $450,000. Choosing by unit contribution would have cost $90,000.

Measuring a change in mix

Profit changes when the mix shifts, even if prices and costs are constant. A standard way to measure it is the sales mix variance. Suppose the budget assumed 10,000 units, split 5,000 of product A (contribution $10) and 5,000 of product B (contribution $20), for budgeted contribution of 50,000 + 100,000 = $150,000. Actual sales are 10,000 units, split 6,000 of A and 4,000 of B: contribution = 60,000 + 80,000 = $140,000.

Total volume matched the budget, so the whole $10,000 shortfall is mix:

• A: (6,000 - 5,000) × $10 = +$10,000
• B: (4,000 - 5,000) × $20 = -$20,000
• Net mix variance = -$10,000

Customers bought more of the low-contribution product. The reasons could be a promotion on A, a stockout on B or a competitor action on B. Whatever the cause, the finance report should show mix separately from price, cost and volume, so that the right team responds. See budget variance analysis.

Putting the analysis to use

Mix decisions across channels, customers and time

The same logic applies at other levels: which channels get stock, which customers get priority in allocations, and which season to commit to. The best mix also depends on risk. Concentrating all capital on the top performer can leave the company exposed to a single supplier, a trend reversal or a failed quality batch. Keep a portfolio view: a core that generates most contribution, growth products with a defined test budget and a tail that is managed down.

Link to demand planning

Mix analysis informs the demand plan: forecast accuracy matters most where return on inventory is highest and the penalty for a stockout is greatest. Planning teams should set differentiated service levels by product class and review them with finance. See demand planning and inventory optimization.

Common mistakes

• Allocating capital by margin percentage.
• Assuming the average return holds for additional investment.
• Ignoring constraints other than cash.
• Using gross margin rather than contribution.
• Treating mix variance as a sales performance problem when the cause is supply or promotion.
• Cutting products without checking halo effects.
• Concentrating too heavily on a single top performer.

A practical review cycle

Run the mix review monthly for fast-moving ranges and quarterly for slower ones. Each time, produce the same short pack: return on inventory by product and by class, the five largest stockouts with estimated lost contribution, the five largest slow-moving positions with their carrying cost, and the mix variance against the plan. Ask three questions of every product in the bottom third by return: can we sell it faster, can we buy it smaller, or should we stop. Ask two questions of every product in the top third: are we losing sales because it is out of stock, and can we sell more of it through other channels. Decisions made on a regular rhythm are better than occasional clearance campaigns.

Example of a rule of thumb that helps

A useful rule is to set inventory targets in weeks of cover that depend on the return class. A product that returns 3.0 on inventory and is important to customers might hold eight weeks of cover with a high service level, while a product that returns 0.6 might hold only three weeks, bought in smaller lots at a slightly higher unit cost. The extra purchase cost of smaller lots is typically small compared with the carrying cost saved. Confirm with numbers: if the product's annual purchases at cost are $100,000 and buying in lots a third smaller costs 1 percent more per unit, the extra cost is $1,000 a year, while the carrying cost saved on a one-third lower average stock of $150,000 is 150,000 / 3 × 25% = $12,500.

FAQs

What is product mix analysis?

An analysis of how revenue, contribution and resource use are distributed across products, to find the combination that makes the best use of scarce resources.

What is GMROI?

Gross margin return on inventory investment: annual margin dollars divided by average inventory at cost. For decisions, contribution is a better numerator than gross margin.

How does product mix affect profit?

Shifting sales toward higher-contribution products raises profit without any change in price or cost, and the reverse lowers it.

Which product should get priority when capacity is limited?

The one with the highest contribution per unit of the constraint, such as per machine hour, subject to demand.

How often should I review product mix?

Quarterly, and whenever demand, costs or constraints change materially.