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.
10free resources
79planning guides
12research reports
64glossary 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· 16 min read
Replenishment Readiness Playbook: Size-Level Masking, the 50/50 Allocation Matrix, and the Shared-Ownership Operating Model
An operator-grade playbook for apparel planning leaders deploying AI-assisted size-level replenishment. Covers the 8-point masking diagnostic, the 50/50 allocation decision matrix by fleet profile, the stable-vs-noisy signal hygiene table, the test-and-learn iteration cadence, and the shared-ownership RACI that makes size-level governance stick.
Read the report →ResearchMar 2026· 8 min read
The Modern Apparel Planning Stack
A technology landscape analysis for mid-market apparel brands — what the modern planning stack looks like, how the tools fit together, what each category does well, and where the gaps remain.
Read the report →ResearchMar 2026· 8 min read
Spreadsheet Dependency in Apparel Planning: A Risk Analysis
A structured analysis of the operational, financial, and strategic risks of managing apparel merchandising planning in spreadsheets — quantifying the cost and identifying the threshold at which the risk exceeds the cost of migration.
Read the report →ResearchMar 2026· 7 min read
State of Apparel Merchandising Planning 2026
An analysis of how mid-market apparel brands are currently planning — what tools they use, where planning breaks down, and what separates high-performing planning operations from the rest.
Read the report →ResearchMar 2026· 8 min read
Why Apparel Brands Overbuy: The Structural Causes of Excess Inventory
An analysis of the five structural drivers that cause apparel brands to chronically overbuy — asymmetric penalties, cascading buffers, disconnected carry-forward, MOQ capitulation, and optimism bias — and the system-level changes required to break the cycle.
Read the report →ResearchFeb 2026· 10 min read
Apparel Buying Team Structure at Mid-Market Brands
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.
Guide7 min read
When Dating Rules Cap Your Weeks of Supply
Shelf life, PAO and retailer date-code policy put a hard ceiling on how much cover you can hold. This guide covers computing that ceiling, why it caps safety stock outright, how a wide shade range produced in even batches converts mechanically into expired tail stock, and why the exit trigger is a date rather than a sell-through point.
shelf life planningdate code
Guide7 min read
Planning a Limited Drop: When Sell-Out Is the Target, Not Sell-Through
A limited drop inverts the normal planning objective — the goal is to sell out, and selling out means you under-bought on purpose. This guide covers sizing a buy with no history and no reorder, why residual is more expensive here than anywhere else, how scarcity interacts with size runs, and how to read a drop that sold out in an hour.
limited drop planningdrop model
Guide7 min read
Pre-Order and Made-to-Order: Planning When the Constraint Is Capacity, Not Inventory
When product is cut after the sale, the binding constraint stops being open-to-buy and becomes factory capacity. This guide covers what a pre-order window actually commits you to, why cancellation rate is the number that decides the model, how to plan a capacity ladder instead of a receipt plan, and where the hybrid breaks.
pre-order planningmade to order
Guide7 min read
Planning Against Fabric Minimums, Not Style Minimums
When mill minimums exceed any single style's buy, the planning unit stops being the style and becomes the fabric. This guide covers committing yardage before the assortment locks, allocating one fabric commitment across styles and colours, the residual yardage nobody plans for, and how to phase a buy around a two-stage lead time.
fabric minimumsMOQ planning
Guide7 min read
Extending a Range Into Extended Sizes: What Actually Has to Be Planned
Extended sizes are a second fit block, not extra positions on an existing size curve. This guide covers why the curve cannot be stretched, how to choose which styles extend, how to build depth with no history, the fit and pattern cost that sits upstream of the buy, and how to read the first season honestly.
extended sizesplus size planning
Guide7 min read
Planning an Outlet Channel: Made-for-Outlet vs. Full-Price Residual
An outlet is a channel you buy into, not a place leftovers go. This guide covers the two receipt sources that fund an outlet assortment, how to hold them apart inside open-to-buy, why the made-for-outlet decision is a margin architecture decision rather than a sourcing one, and how to plan the channel so it stops competing with full price.
outlet planningmade-for-outlet
// 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 your total net sales, option count, and sell-through by category to identify which SKUs 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 →// 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-powered 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 10 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-powered 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 Calculator
SKU Productivity Calculator
Enter your total net sales, option count, and sell-through by category to identify which SKUs 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 Guides79 guides
In-depth articles on OTB, assortment planning, buy planning, allocation, and the modern planning stack.
Browse Planning Guides →Glossary64 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.
1–3%margin at risk per buying event
4–6 buying events per season · 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 downloads and send relevant planning content — 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.
// Get Started
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.
Connected merchandise planning — live in weeks, not quarters.