Merchandise, Assortment and Lifecycle Planning

Introduction

Inventory management in retail is not limited to deciding how much stock to hold. It also concerns deciding what to stock, when to introduce it, where to place it, how deeply to stock it, and when to replace, replenish, transfer, discount or discontinue it. These decisions connect inventory control with category management, merchandising strategy, customer experience and financial performance.

Merchandise planning translates corporate strategy and customer insight into a structured range of products. A sound plan balances customer choice against inventory risk. Excessive assortment creates duplication, operational complexity and markdown exposure; insufficient assortment causes lost sales, substitution, dissatisfaction and weaker store productivity.

This chapter examines assortment architecture, breadth and depth, seasonal buying, open-to-buy, allocation, substitution, markdowns and product lifecycle management. It treats these activities as an integrated system rather than as isolated buying decisions.

Learning objectives

After studying this chapter, the learner should be able to:

1. Explain the relationship between category management, merchandise planning and inventory auditing.
2. Distinguish assortment breadth, depth, range architecture and product roles.
3. Apply open-to-buy and basic inventory planning calculations.
4. Analyse seasonal buying, allocation, replenishment, substitution and markdown decisions.
5. Evaluate merchandise through its product lifecycle and recommend managerial action.
6. Critically assess the use of data, AI and governance in assortment planning.

1. Merchandise planning as an integrated decision system

Merchandise planning is the process of converting commercial objectives into product, quantity, timing and location decisions. It normally operates across several levels:

• Corporate level: growth, profitability, market positioning and capital constraints.
• Category level: role of the category, target customer, price architecture and competitive proposition.
• Subcategory and product level: styles, sizes, colours, brands, pack sizes and variants.
• Location and channel level: store clusters, e-commerce, marketplaces and fulfilment nodes.
• Time level: season, launch window, promotional period and lifecycle stage.

Category management views a category as a strategic business unit whose products are managed collectively to satisfy a shopper mission. Typical category roles include:

These roles influence service levels, space allocation, price policy and markdown tolerance. A destination category may justify wider choice, while an image category may require frequent newness even when individual products have short selling lives.

An inventory audit should therefore ask more than whether physical quantities match the system. It should examine whether inventory is strategically appropriate: Is capital concentrated in the right categories? Are discontinued products still being replenished? Are slow-moving variants masking strong category-level performance? Are allocations consistent with local demand?

2. Assortment architecture

An assortment is the set of products offered to a defined customer group through a particular channel, location and period. Its architecture describes how that set is organised.

2.1 Breadth and depth

Breadth is the number of distinct product categories or subcategories offered. A department store has greater breadth than a specialist running shop. Depth is the number of alternatives within a category, such as brands, styles, colours, sizes or pack formats.

A broad and deep assortment can satisfy diverse needs, but it increases purchase commitments, handling complexity and the probability of obsolete stock. A narrow and shallow assortment lowers complexity but may reduce traffic and conversion.

The appropriate balance depends on customer heterogeneity, store size, channel economics, demand uncertainty, lead time and the retailer’s positioning. Online retail can display extensive breadth, but physical and financial capacity still constrain depth because every listed product requires procurement, data maintenance, fulfilment and potentially returns management.

2.2 Range architecture

Range architecture structures products by customer need, price and value proposition. A common price ladder contains:

• entry or opening price point;
• core or mainstream products;
• premium products; and
• exclusive, luxury or innovation products.

Architecture should be based on meaningful consumer choice, not merely a large number of stock-keeping units (SKUs). Variants that customers cannot distinguish, or that compete for the same demand, create cannibalisation.

Product roles also matter. A product may be a traffic generator, margin generator, basket builder, complementary item, halo product, innovation, or clearance candidate. These roles should be documented because the most profitable product is not always the one with the highest unit margin. A low-margin staple may attract visits and generate sales of complementary products.

2.3 SKU productivity

Retailers commonly assess SKU productivity using sales, gross margin, inventory turns, sell-through and return on inventory investment. A basic gross margin return on inventory investment (GMROII) measure is:

Gross margin and average inventory must use the same currency and valuation basis. If gross margin is measured at retail selling value while inventory is measured at cost, the ratio is invalid. The measure is useful for comparison, but it should not be used alone: a high ratio may conceal poor availability, low strategic importance or inadequate customer choice.

Inventory turnover is commonly expressed as:

Average inventory is often approximated as beginning inventory plus ending inventory divided by two, although more frequent observations are preferable where sales are highly seasonal. Turnover comparisons require consistent periods, valuation methods and treatment of returns, markdowns and stock in transit.

3. Demand planning and seasonal buying

Seasonal merchandise creates a timing problem. A retailer commits to stock before demand is fully known, often because suppliers require long lead times. The buying decision must balance the cost of lost sales against the cost of residual inventory.

A seasonal plan generally includes:

1. historical and comparable-product analysis;
2. trend, weather, event and macroeconomic assumptions;
3. category sales and margin targets;
4. launch, in-season and exit dates;
5. initial purchase, replenishment and reserve quantities;
6. allocation rules and transfer capacity; and
7. markdown and liquidation triggers.

For a single seasonal product with uncertain demand, the classical newsvendor framework identifies a target service fractile:

Here, D is demand, Q* is the optimal initial quantity, Cu is the underage cost per unit, and Co is the overage cost per unit. The formula assumes one principal buying decision, uncertain demand with a known or estimated distribution, and clearly defined costs. Underage cost represents the economic consequence of ordering too little; overage cost represents the consequence of ordering too much, including markdown, holding and disposal costs.

For example, suppose a seasonal item sells for ₹1,000, costs ₹600, and can be cleared at ₹400. Ignoring other costs, the underage cost is ₹400 because one missed sale sacrifices ₹1,000 − ₹600. The overage cost is ₹200 because an unsold unit costs ₹600 but recovers ₹400. Therefore:

The buyer should select the quantity corresponding to the 66.7th percentile of the demand forecast, subject to supplier minimums, capacity, service objectives and strategic considerations. This is not a guarantee of profit; it is a decision rule under stated assumptions.

In practice, fashion and seasonal planning often uses multiple buys, supplier flexibility and option contracts. A smaller initial commitment followed by rapid replenishment reduces risk when lead times permit it. Conversely, long lead times and constrained production may justify earlier commitment.

4. Open-to-buy and inventory financial control

Open-to-buy (OTB) is the remaining purchasing capacity available for a category or period. It links merchandise plans to financial control and prevents buyers from committing more inventory than the plan can support.

A basic end-of-period OTB equation is:

All variables must be measured on the same basis, usually retail value for a retail OTB or cost value for a cost OTB. Planned sales and markdowns are positive uses of inventory; beginning inventory and on-order receipts are existing sources. The formula assumes that purchases are the balancing item and that transfers, returns and other adjustments are either immaterial or separately included.

Illustrative example: a category begins with inventory of ₹8 million. The plan requires ending inventory of ₹10 million, sales of ₹24 million and markdowns of ₹2 million. Confirmed on-order receipts equal ₹7 million.

The buyer may commit up to ₹21 million under the stated plan. If expected sales decline, or if on-order receipts increase, OTB should be recalculated. OTB is not a licence to spend automatically; it is a controlled capacity that must be adjusted for forecast risk, supplier reliability, margin and cash flow.

A useful governance practice is to separate:

• committed inventory: physically held or contractually ordered;
• planned inventory: required by the merchandise plan; and
• open capacity: available for additional commitments.

Auditors should reconcile OTB reports to purchase orders, goods received, cancellations, supplier claims, returns and inventory ledgers.

5. Allocation, replenishment and substitution

Allocation determines how central inventory is distributed across stores, regions, channels or customer segments. It is not simply an equal division. Allocation should consider forecast demand, store capacity, local demographics, historical sell-through, inventory already on hand, display requirements and transfer feasibility.

A practical allocation sequence is:

1. reserve quantities for e-commerce, key accounts or contractual obligations;
2. establish minimum presentation or display quantities;
3. allocate according to location-level demand and service objectives;
4. protect size and colour balance where relevant;
5. monitor early sales and rebalance through transfers or replenishment.

For a replenishable product, the order-up-to level can be represented as:

Here, S is the target inventory position, μL is expected demand during lead time, z is the standard-normal service factor, and σL is the standard deviation of demand during lead time. The equation assumes that demand uncertainty can be estimated and that a service-level approach is appropriate. If demand and lead time are independent, lead-time variance may be approximated by:

where L is average lead time, σD is the standard deviation of period demand, μD is average period demand and σLtime is lead-time standard deviation. Notation must distinguish the lead-time variable from its standard deviation. In highly intermittent or seasonal demand, empirical or probabilistic methods may be more suitable than a normal approximation.

Substitution occurs when the preferred product is unavailable and the customer chooses an alternative. Retailers can plan substitution through similar attributes, price bands, compatibility, brand rules and digital recommendations. However, substitution is not always beneficial. A substitute may have lower margin, higher return probability or regulatory restrictions. In pharmaceuticals, food allergens, electrical components and safety products, substitution requires particular governance.

The economic value of availability should therefore include not only the sale of the missing SKU but also the probability of substitution, basket effects and customer retention. Availability metrics should distinguish true lost sales from substituted sales.

6. Markdown and exit management

Markdowns are deliberate price reductions used to accelerate sales, release working capital, clear seasonal goods or correct an earlier pricing decision. They should be planned before the buying decision, not treated solely as a last-minute reaction.

Markdown decisions consider:

• weeks of supply and sales velocity;
• remaining selling window;
• inventory age and obsolescence risk;
• price elasticity and competitor pricing;
• gross margin recovery;
• store and channel differences; and
• alternative actions such as transfers, bundling or supplier returns.

A simplified sell-through rate is:

This definition applies when the denominator represents the original available units and excludes replenishment distortions. If additional stock is received during the period, the retailer must state whether receipts are included, otherwise comparisons are misleading.

Markdown evaluation should use incremental economics. If a ₹1,000 product costing ₹600 is reduced to ₹800, unit gross margin becomes ₹200 rather than ₹400. A deeper reduction may improve sell-through but destroy margin. The correct decision depends on expected future recovery, holding cost, selling-window constraints and the opportunity cost of occupied space.

Common exit routes include store transfer, online clearance, outlet channels, bundling, supplier return, donation and recycling. Disposal must comply with product safety, environmental, tax and consumer-protection requirements.

7. Product lifecycle management

The retail product lifecycle is a managerial framework rather than a universal law. A product commonly passes through introduction, growth, maturity and decline, but the duration and shape of stages differ by category.

Lifecycle management should integrate product, category and technology perspectives. A product may decline while the category grows, or a category may decline while a niche product remains profitable. Therefore, decisions should use cohort and SKU evidence rather than stage labels alone.

Useful lifecycle indicators include sales growth, repeat purchase, new-customer acquisition, gross margin, inventory age, return rate, search activity, conversion, review sentiment and substitution rate. An innovation portfolio should also distinguish experimental products from core products so that temporary low volume is not automatically interpreted as failure.

8. Technology, analytics and AI

Modern planning systems combine point-of-sale data, inventory records, product attributes, customer behaviour, weather, promotions and supplier information. Machine-learning models can improve demand forecasts, recommend substitutes, identify anomalous stock records and prioritise markdowns.

Technology does not remove managerial responsibility. Forecast models may reproduce historical bias, overreact to promotions, fail during structural breaks or treat stockouts as low demand. Product data may also be incomplete or inconsistent across channels. AI-generated recommendations should therefore include confidence intervals or uncertainty indicators where possible, human review for exceptional decisions, and audit trails showing the data and rules used.

A robust governance framework includes:

• clear ownership of master data and SKU definitions;
• version-controlled forecasts and assumptions;
• segregation of buying approval from receipt and payment processing;
• access controls and change logs;
• monitoring for forecast bias and disparate customer effects; and
• periodic post-season review of recommendations and outcomes.

Privacy law is relevant where customer-level data informs assortment or personalisation. Competition law may also matter when pricing and inventory systems use competitor data. Sustainability considerations include overproduction, returns, unsold disposal, packaging, supplier labour conditions and product traceability.

9. Integrated illustrative case: UrbanTrail outdoor retail

Background

UrbanTrail is a fictional mid-sized retailer selling outdoor apparel through 20 stores and an online channel. Its winter jacket category has wide colour and size variety. Historically, buyers committed to large quantities six months before winter, producing high availability in popular styles but substantial end-of-season markdowns.

Problem

The category manager observed that total sales were growing, while GMROII was declining. A store-level review found that central inventory was sufficient, but several high-demand stores were out of core sizes. Slow colours and fringe sizes occupied warehouse capacity. The OTB report also overstated available capacity because cancelled purchase orders remained in the system.

Analysis

The team segmented the range into three roles:

• core waterproof jackets: routine and destination products;
• fashion colours: image and seasonal products; and
• technical expedition jackets: premium specialist products.

It calculated SKU-level sell-through, inventory age, size availability, store demand and margin. The analysis showed that core products had predictable demand and could be replenished, whereas fashion colours had high forecast error and long residual-stock risk. The technical range had low volume but strong margin and strategic value.

Approach

UrbanTrail adopted the following plan:

1. reduce the initial buy for fashion colours and reserve supplier capacity for repeat orders;
2. maintain deeper size coverage in core waterproof jackets;
3. allocate initial stock by store cluster rather than equally;
4. create a weekly exception report for lost availability and aged inventory;
5. correct OTB by removing cancelled orders and reconciling receipts;
6. introduce an early markdown trigger for fashion colours when sell-through fell below plan; and
7. recommend technically compatible substitutes online when core sizes were unavailable.

The company also introduced a lifecycle review at weeks 4, 8 and 12 after launch. The review assessed sales velocity, margin, stock age and forecast revision rather than relying on a single end-season decision.

Outcome

In the following season, the retailer reduced residual fashion inventory and improved core-size availability. The technical range remained broad but was concentrated in stores with relevant customer demand. Although fashion-colour unit sales were lower initially, the option to reorder successful colours reduced total commitment risk. The outcome illustrates that lower initial breadth in uncertain products can coexist with greater effective customer choice when replenishment and substitution work well.

Learning points

The case demonstrates five principles: category roles should guide inventory policy; allocation must reflect local demand; OTB depends on data integrity; lifecycle decisions should occur throughout the season; and assortment productivity must be evaluated alongside customer availability.

10. Challenges and limitations

Merchandise planning is affected by structural uncertainty. Historical data may not represent new stores, new competitors, climate change, viral trends or economic shocks. Forecast accuracy can deteriorate when stockouts suppress observed sales. Aggregated category performance can also conceal failures in particular sizes, colours, regions or customer segments.

Financial metrics create trade-offs. Maximising turnover may encourage under-stocking; maximising gross margin may favour high prices and reduce conversion; maximising availability may increase obsolescence. Balanced scorecards should combine sales, margin, availability, inventory age, working capital, markdown rate, customer satisfaction and sustainability.

Ethically, retailers should avoid discriminatory assortment or allocation practices, misleading scarcity claims and irresponsible disposal. Supplier pressure should not transfer unreasonable forecast risk or payment delays to smaller producers. Governance must ensure that commercial urgency does not override safety, traceability or labour standards.

Best-practice framework

A disciplined merchandise process can be organised into an eight-step cycle:

1. define customer and category roles;
2. design breadth, depth and price architecture;
3. estimate demand and uncertainty;
4. set financial, service and sustainability constraints;
5. buy and allocate using differentiated rules;
6. monitor availability, productivity and lifecycle signals;
7. rebalance through replenishment, transfer, substitution or markdown; and
8. audit outcomes, assumptions, data quality and decision rights.

This cycle should be cross-functional. Buyers, planners, supply-chain managers, store teams, finance, marketing, technology and compliance functions each hold information necessary for sound decisions.

Chapter Summary

Merchandise planning integrates customer strategy with inventory investment. Assortment breadth concerns the number of categories, while depth concerns the alternatives within them. Range architecture uses product roles, price ladders and customer missions to create meaningful choice without unnecessary duplication.

Seasonal buying requires explicit treatment of demand uncertainty, lead times and exit risk. The newsvendor critical-ratio model can support a single seasonal commitment when its assumptions are satisfied. Open-to-buy connects planned sales, markdowns, beginning inventory, ending inventory and on-order receipts to purchasing capacity. Allocation should reflect location-level demand, presentation needs and channel priorities rather than equal division.

Substitution protects sales but requires compatibility, margin and safety controls. Markdowns release capital and manage obsolescence, but should be evaluated using incremental economics. Lifecycle management requires continuous review of introduction, growth, maturity and decline signals. Technology and AI can improve forecasting and recommendations, but data quality, bias, privacy, explainability and human governance remain essential.

Key Terms

Merchandise planning: The process of planning products, quantities, timing, locations and financial outcomes.

Category management: Managing a group of related products as a strategic business unit.

Assortment: The products offered to a defined customer, channel, location and period.

Breadth: The number of categories or subcategories offered.

Depth: The number of alternatives within a category.

Range architecture: The organisation of products by role, price, value and customer need.

SKU: A uniquely managed stock-keeping unit.

Destination category: A category intended to attract customers and visits.

Open-to-buy: Remaining purchasing capacity under a merchandise plan.

Sell-through: The proportion of available units sold during a defined period.

Allocation: Distribution of inventory among stores, channels or locations.

Replenishment: Restocking inventory in response to demand or inventory position.

Substitution: Replacing an unavailable product with an acceptable alternative.

Markdown: A deliberate reduction in selling price to accelerate sales or clear stock.

Lifecycle management: Managing a product from introduction through exit.

GMROII: Gross margin earned relative to average inventory investment at cost.

Inventory turnover: Cost of goods sold divided by average inventory at cost.

Critical ratio: The target demand percentile in a single-period inventory decision.

Inventory age: The length of time stock has remained unsold or held.

Range rationalisation: Removing low-value, duplicative or strategically unsuitable products.

Multiple Choice Questions with Answers

Question 1

Which statement best distinguishes assortment breadth from assortment depth?

A. Breadth concerns price, while depth concerns margin.

B. Breadth concerns the number of categories, while depth concerns alternatives within a category.

C. Breadth concerns inventory age, while depth concerns lead time.

D. Breadth concerns allocation, while depth concerns markdowns.

Correct Answer: B. Breadth concerns the number of categories, while depth concerns alternatives within a category.

Question 2

A category managed as a destination category is primarily intended to:

A. Minimise all product variety

B. Attract customers and drive visits

C. Clear discontinued inventory

D. Serve only internal procurement needs

Correct Answer: B. Attract customers and drive visits

Question 3

A category has planned ending inventory of ₹10 million, sales of ₹24 million, markdowns of ₹2 million, beginning inventory of ₹8 million and on-order receipts of ₹7 million. What is its OTB?

A. ₹17 million

B. ₹19 million

C. ₹21 million

D. ₹29 million

Correct Answer: C. ₹21 million

Question 4

In the seasonal critical-ratio model, the underage cost represents:

A. The cost of ordering too many units

B. The economic consequence of ordering too few units

C. The supplier’s fixed production cost

D. The retailer’s annual rent

Correct Answer: B. The economic consequence of ordering too few units

Question 5

Which action most directly improves allocation quality?

A. Dividing all inventory equally among stores

B. Allocating according to local demand, capacity and inventory already held

C. Sending all premium products to the smallest stores

D. Ignoring store-level sales until season end

Correct Answer: B. Allocating according to local demand, capacity and inventory already held

Question 6

If units sold are 600 and units remaining are 400, the sell-through rate is:

A. 40%

B. 50%

C. 60%

D. 67%

Correct Answer: C. 60%

Question 7

Why can stockouts distort demand forecasts?

A. They make observed sales higher than unconstrained demand

B. They can make observed sales lower because demand cannot be fulfilled

C. They eliminate all demand uncertainty

D. They automatically increase inventory turnover accuracy

Correct Answer: B. They can make observed sales lower because demand cannot be fulfilled

Question 8

Which is an appropriate governance control for AI-supported assortment planning?

A. Allowing recommendations without an audit trail

B. Deleting historical forecasts after each season

C. Maintaining version-controlled assumptions and decision logs

D. Removing all human review from exceptional decisions

Correct Answer: C. Maintaining version-controlled assumptions and decision logs

Question 9

A markdown decision should primarily be evaluated using:

A. Only the original ticket price

B. Incremental margin, future recovery, holding cost and selling-window constraints

C. Only the number of product variants

D. The supplier’s advertising budget alone

Correct Answer: B. Incremental margin, future recovery, holding cost and selling-window constraints

Question 10

Which product lifecycle response is generally most appropriate for a declining product?

A. Increase commitments without reviewing demand

B. Reduce commitments and consider transfer, markdown or exit

C. Remove all availability controls

D. Treat it as a new product automatically

Correct Answer: B. Reduce commitments and consider transfer, markdown or exit