Merchandise Financial Planning

For a fashion retailer, Merchandise Financial Planning is not simply about deciding how much inventory to buy.

The harder problem starts after the buy has been committed.

By the time a seasonal product reaches stores, much of the capital is already locked in. The merchant now has a limited number of weeks to answer a much more difficult set of questions:

• Which stores should receive which colours and sizes?
• How much inventory should remain in the distribution centre?
• Which products should be replenished?
• Which stores should transfer inventory to others?
• When should a price change happen?
• How do you reach the sell-through target without sacrificing gross margin?

This is where in-season merchandise planning becomes the operating layer of Merchandise Financial Planning.

Consider one sweatshirt class.

5 colours × 5 sizes × 25 stores = 625 store-SKU positions.

The collection goes on sale on 1 November and needs to be substantially cleared by 31 January.

The commercial objective is straightforward:

90%+ sell-through while maintaining 75%+ gross margin.

But achieving both simultaneously requires hundreds of connected decisions throughout the season.

The Merchandise Plan Starts Months Before the Customer Sees the Product

In fashion retail, the most important inventory decision is often made long before there is any actual selling data.

Assume the sweatshirt has:

• 5 colours
• 5 sizes
• 25 SKUs
• 25 stores
• $89 regular ticket price
• $19.60 landed cost
• a 13-week selling season

By April, the retailer needs to determine its Open-to-Buy commitment for a season beginning in November.

The initial demand forecast considers signals such as:

• comparable products and historical launches
• colour and size behaviour
• store characteristics
• seasonality
• holiday calendars
• weather
• planned promotions
• category trends

Suppose this results in an initial commitment of:

22,000 units.

At this point, Merchandise Financial Planning establishes the financial guardrails.

But it cannot perfectly predict where every unit will eventually sell.

That is why the objective should not be to make one perfect April forecast.

The objective is to create a plan that can continuously adapt once new information becomes available.

Stage 1: April - Forecast to Open-to-Buy

Traditional merchandise planning can quickly collapse a complex assortment into a single class-level number.

“Last year we sold X units, demand should grow by Y%, so buy Z.”

The problem is that customer demand does not occur at the class level.

It happens at:

Colour × Size × Store × Week.

A strong MFP process therefore uses the long-range forecast to establish the total merchandise commitment while deliberately preserving flexibility.

In this example:

22,000 units are committed through Open-to-Buy.

Rather than pushing every unit immediately into stores, part of the inventory can remain available to respond to what actually sells once the season begins.

This changes the role of the merchandise plan.

Instead of being a static budget that merchants periodically compare against actuals, it becomes a financial framework guiding every downstream inventory decision.

Stage 2: October - Turn the Buy Into an Allocation Plan

By October, the retailer knows considerably more than it did in April.

The merchandise is arriving.

The assortment is finalized.

Store trends are clearer.

Weather and promotional calendars are more reliable.

The question therefore changes from:

“How many sweatshirts should we buy?”

to:

“Where should each sweatshirt go?”

Suppose the retailer places:

12,000 units into stores

while keeping:

10,000 units in the distribution centre.

That 10,000-unit reserve is not unused inventory.

It is in-season optionality.

Instead of predicting every store's demand several months in advance, the retailer allows early-season selling to determine where additional inventory should go.

Allocation should follow demand potential, not simply store size

A common retail planning mistake is allocating proportionally to historical sales volume.

Large stores receive more inventory.

Small stores receive less.

But volume alone does not tell the merchant whether an individual SKU performs well in a particular location.

A better approach evaluates stores based on measures such as:

• expected sell-through
• sales velocity
• colour affinity
• size curves
• local demand patterns
• historical stockouts
• store clusters

A 60-unit store should be evaluated against the opportunity available to that store—not automatically compared with a 400-unit flagship.

This allows inventory to start the season closer to where demand is likely to occur.

Stage 3: Set the Right Base Price

Merchandise Financial Planning is often treated separately from pricing.

In reality, inventory and price are two sides of the same decision.

If inventory is high relative to expected demand, the required selling velocity changes.

If availability is low, discounting may unnecessarily destroy margin.

Therefore, the initial selling price should not simply be:

“Whatever we charged last year.”

The price should consider:

• expected demand
• inventory position
• price elasticity
• competitive context
• promotional plans
• margin requirements
• season length

The merchandise plan provides the financial target.

Price optimization determines how aggressively the business needs to sell to reach it.

Stage 4: November to January - The Merchandise Plan Becomes a Weekly Decision Loop

Once selling begins, the planning problem changes completely.

The retailer now has actual customer behaviour.

Every week provides new information:

• which colours are winning
• which sizes are selling
• which stores are ahead of plan
• where stockouts are emerging
• where inventory is stagnating
• whether markdown risk is rising
• how much inventory remains in the DC
• whether the original financial plan is still achievable

For the sweatshirt example, the retailer is managing:

625 store-SKU positions every week.

Over a 13-week season, that represents more than:

8,000 store-SKU-week decisions for one class alone.

A retailer managing 100+ comparable classes cannot realistically optimize this continuously through spreadsheets and manual planner review.

This is why modern MFP must extend beyond budgeting into continuous in-season decisioning.

The Four Decisions That Determine the Season

1. Replenish the Winners

If a particular colour and size is selling rapidly in a store, the retailer should replenish it before a stockout occurs.

But replenishment should not simply mean:

“Sales are high, therefore send more.”

The decision must also consider:

• remaining selling weeks
• available DC inventory
• expected future demand
• lead time
• upcoming promotion
• current and planned price
• inventory needed elsewhere

For example, replenishing an SKU today makes little sense if pricing is expected to move sharply downward next week.

Inventory and pricing decisions must therefore operate together.

2. Transfer Inventory Before Marking It Down

Consider the following situation.

A medium-size blue sweatshirt is selling slowly in Store A but is close to selling out in Store B.

The traditional answer might be:

• markdown Store A
• replenish Store B from the DC

But that may unnecessarily consume both margin and fresh inventory.

The retailer could instead:

transfer inventory from Store A to Store B.

A transfer might cost a few dollars per unit.

A markdown could cost 20% or more of retail value.

The economic difference becomes significant across thousands of units.

Inventory transfers also help prevent another common fashion-retail problem:

Broken size runs.

A store may technically have inventory remaining but still be commercially ineffective because the key sizes are gone.

Moving inventory before the assortment becomes fragmented helps preserve full-price selling opportunities.

3. Markdown Earlier—but More Precisely

Many retailers still operate on calendar-driven markdown rules.

For example:

“Anything below 60% sell-through at Week 8 goes to 30% off.”

This is simple operationally.

Financially, it can be extremely expensive.

It treats every:

• store
• colour
• size
• demand pattern

as though they were identical.

An intelligent in-season MFP process asks a different question:

What is the smallest price intervention required today to achieve the desired sell-through by the end of the season?

That could mean:

• no discount for a strong colour
• 5% for another
• 10% in selected stores
• deeper markdown only where inventory risk genuinely warrants it

And importantly, price does not always have to move downward.

If demand strengthens and inventory becomes constrained, the system should be able to stop or reverse unnecessary promotional activity.

The objective is not to maximize discounting.

It is to maximize the economic value of the remaining inventory.

4. Continuously Reforecast Open-to-Buy

Open-to-Buy should not become obsolete the moment purchase orders are placed.

Every week, the retailer learns something new about demand.

That information should flow back into the merchandise financial plan.

If one category is materially outperforming while another is weakening, open budget can be shifted toward the better opportunity before the season ends.

This is where AI-powered MFP becomes materially different from spreadsheet-based planning.

The question changes from:

“How are we performing against the original budget?”

to:

“Given everything we know today, what is the best financial decision we can still make?”

What Does Better In-Season Planning Do Financially?

Using the illustrative sweatshirt example, compare two approaches applied to the same original 22,000-unit buy.

The difference is significant.

The retailer sells:

2,860 more units

while simultaneously reducing the average discount by:

12 percentage points.

The result is approximately:

+$361K gross margin on one merchandise class.

And this is before considering secondary benefits such as:

• fewer stockouts
• lower terminal clearance inventory
• reduced working capital
• fewer emergency buys
• lower markdown exposure
• improved full-price sell-through
• less planner effort

Scale the same decision quality across dozens or hundreds of classes, and the value compounds rapidly.

MFP Should Connect the Entire Merchandise Lifecycle

The bigger lesson is that Merchandise Financial Planning should not stop after the budget and Open-to-Buy are approved.

The merchandise lifecycle is one connected loop:

Financial Plan → Forecast → Open-to-Buy → Assortment → Allocation → Pricing → Replenishment → Transfers → Markdown → Sell-Through → Updated Financial Plan

Every decision changes the inputs for the next one.

A markdown changes demand.

Demand changes inventory.

Inventory changes replenishment.

Replenishment changes future availability.

Availability changes the amount of markdown required.

The financial plan must continuously incorporate all of them.

When these functions operate independently, merchants end up optimizing individual decisions rather than the economic outcome of the season.

From Merchandise Planning to Continuous Merchandise Optimization

The role of AI in MFP is therefore not simply to produce a better forecast.

Its real value is connecting thousands of small operational decisions back to the retailer's financial objectives.

For every merchandise class, the system should continuously ask:

Are we still on track to hit our sell-through target?

Are we still protecting our margin target?

Where is revenue at risk because inventory is unavailable?

Where is working capital trapped in inventory unlikely to sell?

Should we replenish, transfer, re-price—or do nothing?

This is ultimately what modern Merchandise Financial Planning should deliver.

Not another dashboard showing merchants that performance has moved away from plan.

But a continuously adapting system that helps them decide what to do about it while there is still time to change the outcome.

At TrueGradient, that means connecting forecasting, Open-to-Buy, assortment, allocation, replenishment, stock transfers and dynamic pricing into one in-season planning loop.

Because in fashion retail, the original buy matters.

But the hundreds of decisions made after the buy often determine whether the season finishes with full-price sales—or a warehouse full of markdowns.