Merchandise Planner

A Merchandise Planner's job is to make the financial case for merchandise decisions — and to flag, in advance, when those decisions are likely to produce inventory problems or margin shortfalls. While buyers decide what to carry and at what cost, planners answer the harder quantitative questions: How much should we buy? What's the risk if sales come in 10% below forecast? When do we need to mark this down before it becomes a clearance problem?

Pre-season planning starts months before merchandise arrives. Planners build sales, inventory, and margin plans by week using historical sales data, trend analysis, and input from the buying team on planned assortment changes. These plans set the OTB budget — the constraint on how much a buyer can commit to purchase — and the inventory targets that drive replenishment decisions through the season.

In-season, the planner's attention shifts to tracking actuals against plan and adjusting. Sales running above plan in a category create an opportunity to buy more — but only if vendor capacity, OTB, and lead times support it. Sales running below plan create inventory risk: goods arriving in volume into a category that isn't selling requires markdown action sooner than planned, which erodes margin. Spotting these divergences early and recommending action before the problem grows is where planners add real value.

The relationship with buyers is central to the role. Planners and buyers should be working from the same understanding of the category's financial position — but they don't always naturally agree on what that means for action. A buyer who wants to buy aggressively into a trend needs a planner who can model the downside scenario honestly, not just validate the optimistic case. The productive tension in that relationship is part of what makes the planning function valuable to the organization.

Detail orientation and comfort with large data sets in Excel and planning systems are baseline requirements. So is the ability to communicate financial analysis clearly to people — including buyers and senior executives — who may not share the same quantitative comfort level.

Education:

• Bachelor's degree in retail management, business, finance, mathematics, statistics, or supply chain (standard requirement)
• MBA valued for director-track planning roles; not required at entry or mid-level

Experience:

• 2–4 years in merchandise planning, financial analysis, supply chain, or retail operations for entry-to-mid level roles
• Prior OTB management experience (even at a small scale) is highly valued
• Store-level merchandise management experience provides operational context that strengthens planning credibility

Technical skills:

• Excel: advanced proficiency is a baseline requirement — pivot tables, VLOOKUP/XLOOKUP, IF/SUMIF formulas, scenario modeling
• Planning systems: JDA/Blue Yonder, Oracle Retail Planning, Anaplan, or retailer-specific tools
• Allocation systems: familiarity with size/store allocation logic
• Basic data visualization: Tableau, Power BI, or similar for performance dashboards

Analytical skills:

• Retail financial metrics: margin %, GMROII, inventory turn, weeks of supply, sell-through rate
• Variance analysis: identifying what drove deviation from plan (mix, volume, price)
• Forecasting: understanding statistical demand forecasting concepts and how to challenge model assumptions

Soft skills:

• Comfort presenting to senior leadership with numbers under pressure
• Influencing buyers: making a financial case clearly without creating adversarial dynamics
• Managing ambiguity: planning is always working from incomplete information

Merchandise planning is one of the more analytically demanding roles in retail, and that has made it relatively resilient to the automation trends that have affected more routine retail jobs. Planning systems have become more sophisticated, but the judgment calls that drive good planning — how aggressively to plan a new category, when to recommend a markdown, how to balance inventory investment across a portfolio — remain human decisions.

Demand is stable across the retail sector, with growth areas in digital-native retailers building out planning functions for the first time and in retailers expanding omnichannel operations that add planning complexity. The NRF and Retail Industry Leaders Association consistently report that experienced planners are in short supply relative to demand, particularly at the senior and manager levels.

The integration of AI demand forecasting into planning workflows is the most significant structural change affecting the role. Systems like Blue Yonder and Oracle are incorporating machine learning models that generate more accurate baseline forecasts than traditional statistical methods. This shifts the planner's time from forecast construction toward forecast review, exception management, and strategic override decisions — work that requires understanding both the business and the data, not just one or the other.

Compensation at the senior planning level is competitive with other corporate functions. Senior planners and planning managers at major specialty retailers earn $80K–$110K, and director-level planning roles at large companies reach $130K–$170K. The career provides genuine financial upside relative to other corporate retail functions, and the skills — financial analysis, data work, business acumen — transfer well outside of retail into corporate FP&A, supply chain management, and consulting.

For analytically oriented people who want a career in retail without working on the store floor, merchandise planning is one of the strongest paths available.

Dear Hiring Manager,

I'm applying for the Merchandise Planner position at [Company]. I have three years of experience in retail financial analysis, the past year and a half in a planning support role at [Retailer] where I've been building and tracking weekly OTB reports for [category] buyers.

In that role I've taken over the weekly sell-through analysis for our top 50 SKUs, built the seasonal plan templates we use for each category, and been the person who investigates when actuals diverge significantly from the plan. Last fall I flagged an inventory build in the outerwear category six weeks before markdown season based on a consistent 12% sales shortfall against plan — the buyer was able to cancel one purchase order before it shipped, which avoided approximately $180K in excess inventory.

I'm advanced in Excel for planning work — I build the OTB models and scenario sheets from scratch rather than relying on inherited templates. I'm also learning [Planning System], though I've primarily worked with Excel-based tools so far.

I'm looking for a role where I have direct ownership of a category's plan rather than supporting someone else's, and [Company]'s [category/division] looks like the right fit for that step. I'm drawn to [Company]'s scale and the opportunity to work with a full planning system.

I'd welcome the chance to discuss what you're looking for.

Thank you,

[Your Name]