Merchandise Planning in Value Terms: A Retailer’s Guide

Behind every well-stocked shelf and every timely “back in stock” notification sits a quiet financial document doing the heavy lifting: the merchandise plan. It is the bridge between what a retailer hopes to sell and what it actually buys. Get it right, and money flows smoothly into the right stock at the right time. Get it wrong, and you either drown in unsold goods or watch customers walk away from empty racks. This guide breaks down merchandise planning in value terms-how retailers translate sales ambitions into rupee figures for stock, purchases, and cash commitments.

What is a merchandise plan? 🔗

A merchandise plan is a detailed statement that lays out how purchases will be made for a product category over a coming period, usually a six-month selling season. Instead of buying on instinct, the category manager works from a structured budget that links four moving parts: sales, stock, reductions, and purchases. The plan is expressed in money, not units, which is why it is called planning “in value terms.”

The plan acts as a working document. It tells the buyer how much merchandise, in value, is needed each month to hit the sales target while keeping inventory and markdowns under control. As one detailed industry walkthrough by a National Institute of Fashion Technology faculty member explains, the six-month buy plan relates sales, inventory levels, purchases, and reductions so that a buyer can run a more profitable operation and adjust monthly activity as the season unfolds.

Why a retailer needs a merchandise plan 🔗

The core purpose of a merchandise plan is financial control. A category manager needs to know three things before committing funds: how much stock to hold, how much to buy, and how much cash the buying will tie up. Without a plan, these decisions become guesswork, and guesswork in retail is expensive.

The plan also helps strategise for better sales and stock turnover. A retailer wants its average inventory to sell and replenish as many times as possible during the year, because faster turnover means money is not sitting idle on shelves. Lower inventory levels reduce holding costs and lift net income, so the plan is really a tool for improving the sales-to-stock relationship and meeting profit goals. It tells the manager exactly when funds will be committed and how much room is left to respond to field-generated requests from stores.

The building blocks you must know 🔗

Before working through the process, four terms need to be clear, because every calculation rests on them.

Beginning and end of month stock (BOM and EOM) 🔗

BOM stock is the value of inventory on hand at the start of a month. EOM stock is the value on hand at the close of that month. The two are linked in a simple but important way: one month’s EOM stock is the next month’s BOM stock. If a store closes August with stock worth a certain value, the very same figure becomes September’s opening stock. This carry-over is what allows the plan to flow month to month without gaps.

Stock-to-sales ratio 🔗

The stock-to-sales ratio (SSR) is the engine that sets BOM stock for each month. It is calculated as BOM stock divided by sales for that same month, and it answers a planning question: how much inventory should I open the month with to support the sales I expect? According to inventory planning specialists, the stock-to-sales ratio forecasts how much inventory is required to achieve projected sales and is the most logical measure for building month-level plans. Multiply a month’s planned sales by its SSR and you get that month’s BOM stock.

Reductions 🔗

Reductions are anything that lowers the retail value of inventory without producing a normal sale. They include markdowns, employee and customer discounts, and stock shortages (shrinkage). Reductions matter because the retailer must buy enough merchandise to cover not just sales but also this leakage. Ignoring them leaves the plan short.

Initial markup 🔗

Initial markup (IMU) is the difference between an item’s cost and its first retail price, expressed as a percentage of that retail price. It is the cushion that has to cover operating expenses, planned reductions, and profit. The initial markup percentage is built from operating expenses, the net profit goal, and planned reductions, divided by net sales plus reductions. Once known, IMU is the tool that converts retail values into cost values.

The merchandise planning process step by step 🔗

Drawing on the structured method described in retail merchandising mathematics, the planning process moves through a logical sequence. First, enter the planned percentages for the season-initial markup, profit, expenses, and the reduction rate. Second, determine total planned sales for the season and break them into monthly figures. Third, calculate BOM stock for each month using the stock-to-sales ratios, then set EOM stock by remembering that each EOM equals the next month’s BOM. Fourth, plan reductions and distribute them across the months. Finally, apply the purchase formula to find monthly planned purchases at retail, and convert those to cost using the initial markup.

The reduction step is easy to underrate. Indian academic teaching material on the dollar merchandise plan notes that planned markdowns are estimated reductions in monetary value from the retail price, and they feed directly into how much new stock must be purchased.

A step-by-step numerical example for the fall season 🔗

Let us work through a simplified plan for a Fall season running August through January.

Set the season targets. Suppose planned net sales are Rs. 3,50,000, the desired stock turnover is 3.8, and reductions are planned at 10% of net sales, which equals Rs. 35,000.

Find the initial markup. Assume operating expenses of Rs. 1,05,000 and a net profit goal of Rs. 35,000. Using the standard formula, IMU% = (Operating expenses + Net profit + Reductions) ÷ (Net sales + Reductions) = (1,05,000 + 35,000 + 35,000) ÷ (3,50,000 + 35,000) = 1,75,000 ÷ 3,85,000, which is roughly 45%. So purchases at cost will be about 55% of their retail value.

Find average inventory. Average inventory = Net sales ÷ turnover = 3,50,000 ÷ 3.8 = about Rs. 92,105. This figure also becomes the final month’s EOM stock, since the plan must end the season at the season’s average stock level.

Calculate BOM stock for a month. Take August. Say August’s planned sales are Rs. 52,500 and its stock-to-sales ratio is 2.5. Then August BOM stock = 2.5 × 52,500 = Rs. 1,31,250. If September’s planned sales are Rs. 58,000 with an SSR of 2.4, September BOM = Rs. 1,39,200-and that same Rs. 1,39,200 is August’s EOM stock.

Distribute reductions. The total Rs. 35,000 in reductions is spread across the months, usually heavier in December and January when clearance activity peaks. Suppose August carries Rs. 4,000 of reductions.

Apply the purchase formula. The central equation is:

Planned purchases at retail = Sales + EOM stock + Reductions − BOM stock. For August: 52,500 + 1,39,200 + 4,000 − 1,31,250 = Rs. 64,450. This is the retail value of new merchandise to buy in August. To get the cash outlay, convert at cost: Planned purchases at cost = 64,450 × (1 − 0.45) = about Rs. 35,448.

Repeating this for each month produces a complete financial roadmap: how much to spend, when to spend it, and the total investment the buyer must make across the season. This stock-to-sales approach is widely taught because, as detailed in the worked NIFT example, monthly purchases at retail equal sales plus reductions plus EOM minus BOM, then converted to cost using the markup complement.

An interactive, living process 🔗

No plan survives contact with real customers untouched. Actual sales rarely match the forecast exactly, and reductions can run higher or lower than budgeted. This is why merchandise planning is interactive, not a document you write once and forget.

When actual figures come in, the buyer recalculates. The achieved EOM for a month can be found as BOM stock minus actual sales minus actual reductions plus actual purchases. If sales fall short, the closing stock will be higher than planned, which inflates the next month’s opening position and reduces how much new stock is needed. If sales overshoot, the opposite happens and the buyer may need to bring in more. This is the logic behind the open-to-buy figure, which is the amount left to spend after accounting for orders already committed. Good open-to-buy discipline helps a retailer avoid getting stuck over-using markdowns to clear excess merchandise while still controlling cash flow.

By recalculating EOM and subsequent BOM figures against live data, the plan keeps adapting. The retailer revises purchase plans month by month, steering clear of both dead inventory that ties up cash and stock-outs that lose sales. The merchandise plan, in other words, is less a prediction and more a steering wheel.

What do you think? If your actual sales in the first month of a season came in 20% below plan, would you cut your next purchase to protect cash flow, or hold your buying steady and bet on a rebound? And how would you decide which months should carry the heaviest share of planned reductions for a category you know well?

References

1. https://www.fibre2fashion.com/industry-article/9354/six-months-buy-plan-for-fashion-merchandising
2. https://www.netsuite.com/portal/resource/articles/inventory-management/inventory-turnover-primer-with-examples.shtml
3. https://parkeravery.com/industry-experience/inventory-planning-methods/
4. https://study.com/academy/lesson/initial-maintained-retail-markup-definition-calculation.html
5. https://vidyamitra.inflibnet.ac.in/data-server/eacharya-documents/56b0853a8ae36ca7bfe81449_INFIEP_79/50/ET/79-50-ET-V1-S1__unit_4.pdf
6. https://www.management-one.com/retail-definitions