What is merchandise financial planning?
Merchandise financial planning (MFP) is the process of setting and managing a retailer's or brand's sales, inventory, receipt, markdown and gross margin targets in dollars, by period and by level of the merchandise hierarchy, before those dollars are committed to specific products. It produces the financial envelope that assortment planning, buying and allocation then work inside — and the running balance against which the season is managed.
This guide covers the planning hierarchy, the five plan lines and the inventory identity that binds them, the seasonal calendar and reforecast cadence, a nine-step build process, how MFP differs from assortment planning and open-to-buy, the seven ways plans fail in practice, and a four-stage maturity model. Written for apparel and adjacent merchandise categories, where seasonality and size complexity make the discipline unavoidable.
Key takeaways
- Merchandise financial planning (MFP) sets the dollar envelope — sales, inventory, receipts, markdowns and margin — that every product decision downstream has to fit inside.
- The whole discipline rests on one identity: BOP + Receipts − Sales − Markdowns − Shrink = EOP. Every MFP number is a consequence of that equation being made to balance.
- MFP is not assortment planning and not open-to-buy. It is the layer above both: assortment spends the plan, and OTB is the running balance of what remains unspent.
- A plan that is never reconciled to actuals is a forecast, not a plan. The reforecast cadence — not the original numbers — is what separates a working MFP from a spreadsheet nobody reopens.
Inventory is a decision made before the information arrives
Merchandising is unusual among commercial functions in that almost all of its money is committed before almost any of its information exists. An apparel brand places the majority of a season's buy months before the first unit sells, against a demand estimate built from a previous season that will not repeat exactly. The decision cannot be deferred until the data is better, because by then the factory capacity is gone and the season is over.
Merchandise financial planning exists to make that commitment deliberate rather than accumulated. Without it, the inventory position is simply the sum of every individual buying decision, each of which was locally reasonable. The total is nobody's decision. With it, the total is set first and the individual decisions are made to fit — which is the only arrangement in which the word “plan” is doing any work.
The second thing MFP provides is a reference point for the rest of the season. A variance is only meaningful against something that was stated in advance. Teams without a financial plan do not have smaller variances; they have variances they cannot name, and they discover them in the margin report rather than in the receipt plan where something could still be done.
This matters more in apparel and adjacent seasonal categories than in most of retail. Unsold seasonal product does not wait for next year at full price, size curves mean the plan has to be right at a level below the style, and lead times put the commitment four to six months ahead of the sale. Each of those pushes the consequences of a bad plan further from the point at which it can be corrected.
Five levels, and where each number actually comes from
A merchandise financial plan is the same five lines restated at progressively finer levels. What changes down the hierarchy is not the arithmetic but who owns the judgement and how much of it is a target versus an estimate.
Company
Finance / CFO · Annual, by seasonTotal net sales, gross margin rate, inventory investment ceiling and turn target for the year.
This is the only level where the number is genuinely a business target rather than a merchandising judgement. Everything below it is an allocation of this number.
Channel
Merchandising leadership · SeasonSales and margin split across DTC, wholesale, retail doors, marketplace and outlet.
Channels behave differently enough that a blended plan hides both problems. Wholesale is committed early and rarely reforecast; DTC is reforecast weekly. Planning them together averages away the signal.
Department / division
Planning director · Season, phased monthlySales, BOP/EOP inventory, receipts, markdown dollars and margin by department.
This is the level most mid-market brands actually plan at, and the level at which the retail-method identity is first made to balance.
Class / category
Merchandise planner · Monthly, sometimes weeklyThe same five lines, one level finer — plus the first appearance of an option-count and average-unit-retail assumption.
Where financial planning starts to touch product. The class plan is the handoff point to assortment planning.
Subclass / style-colour
Buyer with planner · Buy milestoneUnit buys, depth, size distribution and cost.
Strictly this is assortment and buy planning, not MFP — but it is where the MFP either holds or quietly stops being true.
The reconciliation between levels is the part most processes get wrong. A top-down plan pushed down without challenge produces targets the team does not believe and will not defend. A bottom-up plan rolled up without a target produces a number with no ambition in it and no relationship to what the business needs. The value of running both is the gap between them — a quantified statement of what has to change for the target to be reachable, arrived at before the season rather than after it.
There is a related trap in the hierarchy itself. If the plan is maintained at department level but the buy is committed at class level, there is a translation step in between that no system performs and no person owns. The plan is met in aggregate and missed in every class, and nothing in the process can say which class caused the miss. Planning at the level you buy at is more work; it is also the difference between a plan and a summary. See aligning top-down and bottom-up planning for the reconciliation mechanics.
What a merchandise financial plan actually contains
Every merchandise financial plan, at every level and in every format, is five lines phased across periods. The formats differ; the lines do not.
BOP + Receipts − Sales − Markdowns − Shrink = EOP
Beginning-of-period inventory, plus what arrives, less what leaves through sales, markdowns and shrink, equals end-of-period inventory. It is an accounting identity under the retail method, not a model — it is true whether or not anyone plans it.
Its practical use is that it can be rearranged to solve for receipts: Receipts = EOP + Sales + Markdowns + Shrink − BOP. Because ending inventory is itself set from a stock-to-sales or weeks-of-supply target, the receipt plan falls out of the sales and inventory plans rather than being estimated separately. Any plan in which receipts were typed in directly has an unstated assumption hidden somewhere in it.
| Line | Unit | What it plans | Where it goes wrong |
|---|---|---|---|
| Sales | Retail dollars | Planned demand at full price and on markdown, phased by week or month. | Planned as a single blended number. Full-price sales and markdown sales behave differently and are driven by different levers — planning them as one figure makes the margin plan unauditable. |
| BOP / EOP inventory | Retail dollars (or cost) | Beginning- and end-of-period owned inventory. EOP of one period is BOP of the next, by definition. | Planned as an average rather than a beginning balance. Weeks of supply and stock-to-sales are both ratios against a point-in-time balance; an average silently changes what they mean. |
| Receipts | Retail and cost dollars | Inventory landing in the period. This is the only line the business can still change once the season starts. | Planned on order date rather than in-store date. A receipt that lands three weeks late is not the receipt that was planned — it is a markdown with a later date on it. |
| Markdowns | Retail dollars and % of sales | Permanent and promotional reductions taken to move inventory. | Treated as a residual — whatever it turns out to be. Markdowns planned to zero are markdowns planned to surprise you, and they are the single largest swing factor in the margin plan. |
| Gross margin | Dollars and rate | The output line. Initial markup less markdowns, shrink and any vendor allowances. | Planned directly instead of derived. If margin is typed in rather than calculated from IMU, markdowns and shrink, the plan can balance on paper while being arithmetically impossible. |
Two supporting figures sit underneath these lines and are worth planning explicitly rather than leaving implicit. The first is initial markup (IMU), the margin built in at the point of costing, which sets the ceiling on everything the season can earn. The second is average unit retail and the implied unit count, which is the bridge between a dollar plan and a buy. A sales plan in dollars with no AUR assumption cannot be handed to a buyer, because it does not yet say how many things to buy.
Shrink is the line most often ignored in brand-side planning, on the reasonable grounds that it is small. It is small and it is also non-zero, and leaving it out means the identity does not close — so the receipt solve is systematically light by exactly the amount of shrink, every period, forever.
When the plan is built, and when it is allowed to change
A merchandise financial plan lives on the retail calendar, normally 4-5-4 or 4-4-5, which groups weeks into months of consistent length so that periods are comparable year over year. The choice between them matters far less than being consistent about it — and about restating prior year onto the current calendar before comparing anything. The three conventions, the 53rd week and what calendar shift does to a plan are covered in the retail calendar guide.
The years the calendar bites are the ones it moves in. A shifted holiday week, a different Easter, or a 53-week fiscal year will misalign every week-over-week comparison in the plan. Phasing this year on last year's shape without restating first produces a plan that is wrong in exactly the weeks that carry the most volume.
The build cycle for a seasonal apparel brand typically runs pre-season strategy and top-line targets first, then the department and class plan, then reconciliation against the line plan and the buy, then release of open-to-buy to buying at the point the buy is committed. What happens after that point is what distinguishes a plan from a document: the plan is reforecast on a fixed cadence, with actuals replacing estimates period by period and receipts re-solved each time.
The right cadence is set by the last point at which a decision can still change. Monthly is the minimum for any seasonal business. Weekly is appropriate in season for direct-to-consumer channels, where sales data arrives continuously and chase or cancellation is still available. Reforecasting more often than decisions can be made produces meetings, not control; reforecasting less often produces reports about a season that is already decided. How to derive the cadence from decision deadlines, and what a reforecast has to re-solve, is set out in how often to reforecast.
How to build a merchandise financial plan, in nine steps
The order matters. Each step consumes the output of the one before it, and the two steps most often skipped — restating last year, and solving receipts rather than typing them — are the two that determine whether the finished plan is internally consistent.
- 1
Fix the top-line envelope
Start from the finance-owned annual net sales, gross margin rate and inventory investment ceiling. Write them down before opening any historical data — the point of a top-down number is that it is not derived from last year.
- 2
Rebuild last year clean
Restate prior-year sales, inventory, receipts and markdowns on the current department structure, with one-offs identified and flagged rather than removed. A reorganised hierarchy makes last year incomparable unless it is restated first.
- 3
Phase the sales plan
Spread the season across weeks or months using a demand shape, not an even split. Anchor to the retail calendar (4-5-4 or 4-4-5), and move the peaks to where they actually fall this year — holiday shift and week-53 years break any plan that assumes last year phasing.
- 4
Set the inventory plan
Work back to BOP inventory from a stock-to-sales ratio or weeks-of-supply target for each period. This is the step that converts a sales opinion into an inventory commitment.
- 5
Solve receipts from the identity
Receipts are never guessed. Rearrange BOP + Receipts − Sales − Markdowns − Shrink = EOP to give Receipts = EOP + Sales + Markdowns + Shrink − BOP. Anything else is a wish.
- 6
Plan the markdowns explicitly
Assign markdown dollars by period from a rate assumption per class, informed by prior-season clearance behaviour and the exit date for the season. Markdown timing is a plan input, not an outcome.
- 7
Derive margin and test the plan
Calculate gross margin from IMU less markdowns and shrink, then check it against the finance target. If it misses, change an input — the sales shape, the IMU, the markdown rate — never the margin cell itself.
- 8
Reconcile to open-to-buy and release
Convert the receipt plan into an open-to-buy position by period, then hand it to buying as the spend authority. From this point the MFP is a live balance rather than a document.
- 9
Reforecast on a fixed cadence
Reforecast monthly at minimum, weekly in season for fast channels. Update actuals, re-solve receipts from the same identity, and record what changed and why — the variance narrative is what makes the next plan better.
Step seven deserves emphasis because it is where plans quietly become fiction. When the derived margin misses the finance target, there is always a temptation to adjust the margin cell and move on. Doing so severs margin from its own inputs, and the plan is then internally inconsistent in a way no review will catch — the numbers all still appear. A margin figure that was typed rather than derived is not a plan; it is a hope with a format applied.
Working calculators for the individual components — open-to-buy, sell-through, weeks of supply, stock-to-sales, GMROI and size curves — are published on retail-plan.com/tools. The two steps that carry the most judgement have their own guides — phasing the sales plan (step three) and setting the stock-to-sales ratio (step four). A starting workbook structure is available as the merchandise financial plan template.
What MFP is not: six adjacent disciplines
Most confusion about merchandise financial planning comes from conflating it with something next to it. Each of these answers a different question and produces a different artefact.
| Discipline | Question it answers | Output | Typical owner |
|---|---|---|---|
| Merchandise financial planning | How many dollars, and when? | Sales, inventory, receipt, markdown and margin plan by period and hierarchy level. | Merchandise planner / planning director |
| Assortment planning | Which products, how wide and how deep? | Option counts, style-colour lineup, depth and size distribution — spending the MFP receipt plan. | Planner with buyer and merchant |
| Open-to-buy | How much is left to commit? | A running balance of planned receipts less on-order and received, by period. | Planner and buyer jointly |
| Line planning | What is the shape of the line? | Category, price tier and delivery structure for the season, upstream of costing. | Design and merchandising |
| Allocation | Where does the inventory go? | Store, door or channel-level distribution of units already bought. | Allocator |
| Integrated business planning | Do the commercial, supply and financial plans agree? | A single reconciled company view across functions, of which MFP is the merchandising input. | Finance and operations |
The clearest way to hold the distinction: merchandise financial planning is the budget, assortment planning is the shopping list, and open-to-buy is the balance remaining on the card. All three describe the same money at different moments, which is exactly why keeping them in separate, unlinked workbooks is so expensive.
Seven ways a merchandise financial plan fails in practice
None of these are arithmetic errors. Every one of them produces a plan that balances, reviews cleanly, and is wrong.
The plan is a forecast in disguise
Last year plus a growth percentage is not a plan — it is an extrapolation with a target taped to the front. A plan states what has to be true and what will be done differently; a forecast states what is likely if nothing changes. Teams that skip that distinction spend the season explaining variance instead of managing it.
Receipts are typed, not solved
The moment a receipt figure is entered directly rather than derived from the inventory identity, the plan stops being internally consistent. It will still balance visually, because the spreadsheet balances whatever it is told to.
The hierarchy does not match the buy
Planning at department level while buying at class level leaves a translation layer that nobody owns. The plan is met in aggregate and missed everywhere that matters, and no one can say which class caused it.
Markdowns are planned at zero
A season planned with no markdown dollars produces a margin plan the business will not hit, and removes the only mechanism for planning the season exit. The markdown line is where optimism is stored.
Wholesale and DTC share one plan
Wholesale is largely committed at market and rarely reforecast; DTC is reforecast continuously. A blended plan averages a fixed commitment with a live one and produces a number that describes neither.
Version drift
Multiple workbook copies with different receipt assumptions, reconciled by whoever speaks last in the meeting. This is the failure mode that scales worst — it costs nothing at four classes and becomes unmanageable at forty.
No reforecast cadence
A plan built in June and reopened in October was never a control. The reforecast is not administration around the plan; it is the plan doing its job.
Four stages of merchandise financial planning maturity
Most mid-market apparel brands sit between stage two and stage three. The move that consistently pays is not adding detail to the plan — it is shortening the loop between the plan changing and the buy changing.
Stage 1 — Retrospective
Sales and margin are reviewed after the fact. The inventory plan, if it exists, is a single seasonal number. Receipts are set by what buyers negotiated.
Stage 2 — Departmental
A department-level plan exists with all five lines and phases monthly. It balances to the identity. It is rebuilt each season from a template and reconciled to actuals a few times a year.
Stage 3 — Class-level and reconciled
Planning runs at class level, reconciles top-down targets against bottom-up buys, and reforecasts monthly. Open-to-buy is live and buyers work against it rather than around it.
Stage 4 — Connected
The financial plan, the assortment and the buy share one data model. Changing a receipt date changes the OTB, the inventory plan and the margin projection in the same action, and the variance narrative is captured against the plan rather than reconstructed afterwards.
If you want a structured read on where a team currently sits, the apparel planning maturity assessment covers the same ground across the wider planning process.
Where spreadsheets stop being the right tool
Spreadsheets are excellent at merchandise financial planning arithmetic. They are a poor fit for three specific things, and it is worth being precise about which, because the honest answer for a small single-channel brand is that a spreadsheet is entirely sufficient.
The first is concurrency. A plan maintained by one person is fine. A plan maintained by a planner, a buyer and a finance partner in the same week becomes a reconciliation exercise, and the reconciliation is manual, unlogged and performed under time pressure.
The second is the link between the financial plan and the assortment underneath it. When a delivery slips or a style is cut, the financial plan does not know. The gap between what the plan says and what has actually been bought opens silently and is normally discovered at month end.
The third is auditability. Reforecast history — what changed, when, and why — is the raw material for planning better next season. In a workbook that history is a folder of files with dates in the names, and the reasoning lives in email.
The trigger point is rarely revenue. It is the number of concurrent editors and the number of levels in the hierarchy: roughly, when more than two people maintain the plan and it runs below department level, the reconciliation cost starts to exceed the planning cost. The spreadsheet risks guide covers the failure modes in detail, and spreadsheets vs RetailNorthstar sets out the trade-off honestly, including where the spreadsheet still wins.
Merchandise financial planning — common questions
What is merchandise financial planning in simple terms?
Merchandise financial planning is the process of deciding, in dollars, how much a retailer or brand will sell, how much inventory it will own, how much it will receive and how much margin it will make in each period of a season — before any of that money is committed to specific products. It produces the financial envelope that assortment planning, buying and allocation then have to work inside.
What is the difference between merchandise financial planning and assortment planning?
Merchandise financial planning answers how many dollars are available and when they can be spent. Assortment planning answers which products those dollars buy, at what width and depth. MFP comes first and sets the constraint; assortment planning allocates within it. A brand can have a technically correct MFP and still fail commercially if the assortment is wrong, and a brilliant assortment will still lose money if it breaches the receipt plan.
Is merchandise financial planning the same as open-to-buy?
No. Open-to-buy is one output of the merchandise financial plan, not a substitute for it. The MFP sets planned receipts by period; open-to-buy is the running balance of those planned receipts less what has already been ordered and received. Put simply, MFP is the budget and OTB is the remaining balance on it.
What are the five core lines of a merchandise financial plan?
Sales, beginning and ending inventory, receipts, markdowns, and gross margin. They are bound together by the retail-method inventory identity: beginning inventory plus receipts, less sales, markdowns and shrink, equals ending inventory. Every valid merchandise financial plan is a set of numbers that makes that equation balance in every period.
How is a receipt plan calculated?
Receipts are solved from the inventory identity rather than estimated. Rearranged, receipts for a period equal planned ending inventory plus planned sales plus planned markdowns plus shrink, less beginning inventory. Because ending inventory is itself set from a stock-to-sales or weeks-of-supply target, the receipt plan is a consequence of the sales and inventory plans — which is why changing either one has to flow through to receipts automatically.
Should a merchandise financial plan be top-down or bottom-up?
Both, reconciled. The top-down plan carries the company target down through channel, department and class. The bottom-up plan builds up from what the assortment and the buy can realistically deliver. The value is in the gap between them: it is a specific, quantified statement of what has to change for the target to be reachable. A process that runs only top-down produces targets nobody believes; one that runs only bottom-up produces a plan with no ambition in it.
How often should the merchandise financial plan be reforecast?
Monthly is the minimum for any brand with a seasonal calendar, and weekly in season for direct-to-consumer channels where the data arrives continuously. The test is not the interval but whether a reforecast can change a decision: if receipts for the next period are already locked, a reforecast at that point is a report rather than a control.
What does merchandise financial planning look like for a wholesale apparel brand?
The structure is the same but the timing inverts. Wholesale demand is largely known at market through booked orders, so the sales plan firms up early and the risk moves to production, delivery timing and order cancellation rather than to demand. The reforecast question shifts from how much will sell to how much of what was booked will actually ship on time and at full price. Brands running both wholesale and DTC should plan them separately and consolidate, not plan the blend.
Can merchandise financial planning be done in a spreadsheet?
Yes, and most mid-market brands still do. Spreadsheets handle the arithmetic perfectly well. What they handle badly is concurrency, version control and the link between the financial plan and the assortment underneath it — so the cost shows up not in the calculation but in reconciliation time and in the gap that opens between what the plan says and what has actually been bought.
What is the role of the retail calendar in merchandise financial planning?
The retail calendar, usually 4-5-4 or 4-4-5, defines the periods the plan is phased into and keeps week-over-week comparisons aligned year to year. It matters most in the years it moves: a shifted holiday week or a 53-week year will break any plan that phases this year on last year shape without restating the calendar first.
See a merchandise financial plan that stays connected to the buy.
In RetailNorthstar the financial plan, the assortment and the open-to-buy share one data model — change a receipt date and the inventory plan, the OTB position and the margin projection move with it. Thirty minutes shows you what that removes from the month-end.
Connected merchandise planning — live in weeks, not quarters.