Free Template.xlsx
Open-to-Buy (OTB) Template
A monthly OTB workbook covering planned sales, receipt flow, beginning/ending inventory, and open-to-buy dollars — ready to fill in for any season.
PlannersBuyers
Download the OTB Template →// Planning Intelligence Center
Resources that move your
planning forward.
A decision center for apparel merchandise planners, buyers, and planning leaders. Start with your intent, find what fits your role, or browse the full library below.
11free resources
102planning guides
12research reports
84glossary terms
// Start Here
What brings you here today?
Pick your context and we'll surface the most useful resources.
Planning in spreadsheets has a ceiling. Here's how to see it clearly.
Most mid-market apparel brands don't outgrow spreadsheets — they just stop noticing the cost. The OTB errors, the reconciliation time, the carry-over that persists because nobody ran the analysis. These resources help you quantify the real cost and build the case for a better system.
See the comparison →// Most Valuable First
Start with the assessment.
Before downloading templates or reading guides, know where your planning actually stands. The assessment takes 5–8 minutes and tells you exactly where to focus.
// Templates
Plug-and-play planning templates.
Open and fill in your numbers. Formula logic and seasonal structure already built.
Free Template.xlsx
Assortment Planning Template
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
PlannersBuyers
Download the Template →Free Template.xlsx
Merchandise Financial Plan (MFP) Template
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
PlannersDirectors
Download the MFP Template →// By Role
Resources by who you are.
Different roles need different resources. Find yours.
Merchandise Planner
OTB accuracy, assortment structure, and planning cycle benchmarks.
Templates, process guides, and benchmark data for the people who own the financial plan.
Top resources
Apparel Buyer
Assortment practices, buying team structure, and range review process guides.
Research and templates for buyers who need to move faster and buy smarter.
Top resources
Merchandising Leader
Planning maturity, ROI modelling, and strategic comparisons.
Assessment tools, benchmark data, and evaluation resources for planning leaders making infrastructure decisions.
Top resources
COO / Operations
Markdown risk, inventory exposure, and the operational cost of spreadsheet planning.
Financial and operational analysis for leaders making the case for planning infrastructure investment.
Top resources
// Research & Benchmark Reports
Industry data for planning decisions.
Benchmarks, analysis, and findings from mid-market apparel planning operations.
ResearchApr 2026· 17 min read
Replenishment Readiness Playbook
An operator playbook for size-level replenishment: the masking diagnostic, the allocation decision matrix by fleet profile, and the signal-hygiene rules.
Read the report →ResearchApr 2026· 8 min read
The Modern Apparel Planning Stack
A technology landscape for mid-market apparel brands: what the modern planning stack looks like, how the tools fit together, and where the gaps still are.
Read the report →ResearchMar 2026· 9 min read
Spreadsheet Dependency in Apparel Planning
The operational, financial and strategic risks of running apparel planning in spreadsheets, and the threshold where the risk exceeds the cost of migrating.
Read the report →ResearchMar 2026· 7 min read
The State of Apparel Planning
How mid-market apparel brands plan today: the tools they use, where planning breaks down, and what separates the high-performing operations from the rest.
Read the report →ResearchMar 2026· 8 min read
Why Apparel Brands Overbuy
The five structural drivers behind chronic overbuying — asymmetric penalties, cascading buffers, MOQ capitulation and optimism bias — and how to break them.
Read the report →ResearchMar 2026· 10 min read
Apparel Buying Team Structure
How apparel buying teams are organized at $10M–$200M brands — roles, handoffs, tools, and what high-performing teams do differently across the planning-to-buy workflow.
Read the report →// Planning Guides
In-depth guides for planning teams.
OTB, assortment planning, buying strategy, and AI in apparel — written for practitioners.
Guide38 min read
Markup and Pricing by Vertical
Initial markup is the margin built into the first ticket and maintained markup is what the season keeps. How the IMU target, the price ladder, landed cost and the bridge between them change across ten retail verticals.
initial markupimu retail
Guide30 min read
Supply Chain Software vs. Merchandise Planning Software
Merchandise planning software decides what an apparel or footwear brand will own; supply chain software develops, sources, makes, moves, stores and records it. The category map: what the planning layer, PLM, ERP, sourcing, logistics and the WMS each own, where the handoffs between them break, and how to tell which class you are shopping for.
supply chain management softwaremerchandise planning software
Guide30 min read
Core and NOOS Replenishment Programs
A never-out-of-stock program is a standing stock position on a replenishment rule, not a season's buy. What qualifies a style for core, the review cadence that admits and exits it, how the trigger and safety stock are re-set, and how core and seasonal split the same open-to-buy.
never out of stocknoos
Guide38 min read
Store Clustering and Localization by Vertical
Store clustering groups selling locations that behave alike so one plan can serve many doors. How the clustering dimension, the cluster count and the re-clustering cadence change across ten retail verticals.
store clusteringstore clustering assortment planning
Guide30 min read
Demand Forecasting by Vertical
Demand forecasting sizes a season before it is committed. How analog selection, lead time and censored history change across ten retail verticals.
demand forecastingdemand forecasting by vertical
Guide24 min read
Retail Math for Merchandise Planners
Retail math is the arithmetic that links a merchandise plan's sales, margin, inventory and receipts so a change in one is visible in the others. The working reference: the four families of formulas, grouped by the decision each one supports, with worked examples, what each number hides, and how it reads by vertical.
retail mathretail formulas
// Calculators & Tools
Run the numbers on your planning operation.
Free interactive tools. Enter your numbers, get instant output — no software required.
Free ToolInteractive
SKU Productivity Calculator
Enter units, sales, markdown spend, and weeks active per SKU to identify which options are earning their space — and which are deadweight.
Open the Calculator →Free ToolInteractive
Merchandising ROI Calculator
Model the financial impact of improving OTB accuracy, reducing markdown spend, and tightening inventory turns — with numbers from your own business.
Calculate Your ROI →// Your Path Forward
What happens after the resources?
Most teams download a template, then stop. The ones that improve their planning follow through on all four steps below.
1
Explore resources
Templates, guides, and research to understand the problem and the options.
Browse resources2Recommended next
Assess your maturity
Score your planning operation across 5 dimensions. Takes 5–8 minutes.
Take the assessment →3
Compare your options
See how RetailNorthstar compares to spreadsheets and enterprise platforms.
See comparisons →4
Start a free trial
A 30-minute live walkthrough built around your planning workflow.
Start a free trial →// Full Library
Browse everything.
All templates, assessments, calculators, and whitepapers — filter by type or audience.
// Featured Resources
Start here
Evidence Review
★ FeaturedApparel Planning: What the Published Research Actually Says
A sourced review of the published research on apparel merchandising planning — every figure attributed to a named primary, with its population and its limits stated.
PlannersDirectors
Awareness
Executive Guide
★ FeaturedAI in Apparel Merchandising: An Executive Guide
What AI actually does — and does not do — in apparel planning today. A practical primer for merchandising executives evaluating AI planning tools.
VPsFounders
Awareness
Free Calculator
★ FeaturedMerchandising ROI Calculator
Model the financial impact of improving OTB accuracy, reducing markdown spend, and tightening inventory turns — with numbers from your own business.
DirectorsVPs
Conversion
Free Assessment
★ FeaturedApparel Planning Maturity Assessment
Answer 15 questions about your current planning process and get a scored maturity profile — with specific next steps for each gap.
PlannersDirectors
Evaluation
Free Template
★ FeaturedMerchandise Financial Plan (MFP) Template
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
PlannersDirectors
Consideration
Free Template
★ FeaturedAssortment Planning Template
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
PlannersBuyers
Consideration
// Full Library
All 11 resources
Evidence Review
Apparel Planning: What the Published Research Actually Says
A sourced review of the published research on apparel merchandising planning — every figure attributed to a named primary, with its population and its limits stated.
PlannersDirectors
Awareness
Executive Guide
AI in Apparel Merchandising: An Executive Guide
What AI actually does — and does not do — in apparel planning today. A practical primer for merchandising executives evaluating AI planning tools.
VPsFounders
Awareness
Free Calculator
Merchandising ROI Calculator
Model the financial impact of improving OTB accuracy, reducing markdown spend, and tightening inventory turns — with numbers from your own business.
DirectorsVPs
Conversion
Free Assessment
Apparel Planning Maturity Assessment
Answer 15 questions about your current planning process and get a scored maturity profile — with specific next steps for each gap.
PlannersDirectors
Evaluation
Free Template
Merchandise Financial Plan (MFP) Template
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
PlannersDirectors
Consideration
Free Template
Assortment Planning Template
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
PlannersBuyers
Consideration
Free Template
Size Curve Template
A working size-curve worksheet — enter a size percentage row per style/color and the unit split calculates itself, with a built-in 100% reconciliation check.
PlannersBuyers
Consideration
Free Calculator
SKU Productivity Calculator
Enter units, sales, markdown spend, and weeks active per SKU to identify which options are earning their space — and which are deadweight.
PlannersBuyers
Evaluation
Free Guide
How to Choose Apparel Planning Software
A structured evaluation guide for mid-market apparel brands assessing planning software — covering selection criteria, red flags, and a step-by-step RFP process.
PlannersDirectors
Evaluation
Whitepaper
Spreadsheet Risk in Apparel Merchandising
A quantified analysis of how spreadsheet-based planning drives margin erosion, excess inventory, and planning cycle time — with cost benchmarks for mid-market apparel brands.
PlannersDirectors
Awareness
Free Template
Open-to-Buy (OTB) Template
A monthly OTB workbook covering planned sales, receipt flow, beginning/ending inventory, and open-to-buy dollars — ready to fill in for any season.
PlannersBuyers
Consideration
// Knowledge Base
Planning knowledge base
Planning Guides102 guides
In-depth articles on OTB, assortment planning, buy planning, allocation, and the modern planning stack.
Browse Planning Guides →Glossary84 terms
Practitioner-level definitions for apparel planning terminology — built for AI citation and search authority.
Browse Glossary →Research12 reports
Data and analysis on apparel planning practices, spreadsheet risk, and the modern planning technology stack.
Browse Research →// Why This Resource Library Exists
Most apparel margin problems have a planning root cause. These resources help you trace them.
Excess inventory, missed margin targets, buy reviews that take hours instead of minutes — these aren't isolated events. They trace back to disconnected planning workflows, where OTB, assortment, and buy plan live in separate files that no one fully trusts. Understanding the structural causes is the first step to fixing them.
Everybuy is a margin decision
4–6 buy decision points per season · exposure compounds across the full season calendar
// Symptoms in practice
- Post-season review reveals margin was lost, but the root cause isn't traceable to a single decision
- Markdown budget is consumed earlier each season without clear attribution
- Finance and merchandising regularly reconcile to different margin numbers at the same meeting
// What connected planning recovers
OTB, assortment, and buy plan share one data model — margin impact is visible at every decision point, not reconstructed after the season closes.
// FAQ
Common questions
Are the templates and calculators really free?
Yes. All templates, calculators, and the planning maturity assessment are free. We ask for your work email to deliver your download — no sales calls are triggered by a download.
Who are these resources built for?
Merchandise planners, apparel buyers, merchandising directors, and planning leaders at startup to mid-sized apparel brands. The content is written by planners, for planners — not by marketing teams.
What is the Apparel Planning Maturity Assessment?
A 15-question diagnostic that scores your planning operation across five dimensions: planning infrastructure, in-season responsiveness, cross-functional alignment, data and forecasting, and process and workflow. Takes 5–8 minutes. Results are instant.
How do I know which resource to start with?
Use the 'Start Here' section at the top of this page — select what brings you here and we'll surface the most relevant resources. If you're unsure where your planning stands, start with the Apparel Planning Maturity Assessment.
Also see
Across the cluster
More free resources across the RetailNorthstar cluster
RetailNorthstar runs three companion properties — practitioner tools on retail-plan.com, visual line planning on line-board.com, and the apparel-operating-system category on theapparelos.com. All free, all vendor-neutral.
retail-plan.com ↗
Free planning calculators
Open-to-buy, sell-through, GMROI, WSSI, lead-time, and an ROI estimator — interactive, no sign-up.
line-board.com ↗
Visual line planning
What a line board is, how to build one, and how the tools compare — from mood board to a sign-off-ready assortment.
retail-plan.com ↗
Planning benchmarks
Directional healthy ranges by channel for sell-through, GMROI, markdown %, turns, and more.
theapparelos.com ↗
Category perspectives
Points of view on the apparel operating system — why connected planning changes the economics.
// Free Trial
See the platform behind the resources.
RetailNorthstar is the connected planning platform for apparel brands — OTB, assortment, buy planning, and allocation in one workflow. The resources show you what's possible. The platform makes it real.
No credit card. No commitments.
Connected merchandise planning — live in weeks, not quarters.