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.
// Planning Intelligence Center
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.
// Start Here
Pick your context and we'll surface the most useful resources.
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
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
Open and fill in your numbers. Formula logic and seasonal structure already built.
A monthly OTB workbook covering planned sales, receipt flow, beginning/ending inventory, and open-to-buy dollars — ready to fill in for any season.
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
// By Role
Different roles need different resources. Find yours.
Templates, process guides, and benchmark data for the people who own the financial plan.
Top resources
Research and templates for buyers who need to move faster and buy smarter.
Top resources
Assessment tools, benchmark data, and evaluation resources for planning leaders making infrastructure decisions.
Top resources
Financial and operational analysis for leaders making the case for planning infrastructure investment.
Top resources
// Research & Benchmark Reports
Benchmarks, analysis, and findings from mid-market apparel planning operations.
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 →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 →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 →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 →The five structural drivers behind chronic overbuying — asymmetric penalties, cascading buffers, MOQ capitulation and optimism bias — and how to break them.
Read the report →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
OTB, assortment planning, buying strategy, and AI in apparel — written for practitioners.
Merchandise planning sets the financial envelope for a season: sales, margin, inventory and receipts by category and month. Assortment planning decides which options, how many, how deep and at what price fill it. How the two connect, who owns each, and a knits category worked end to end.
Markdown optimization software is the system that decides when, how deep and where to reduce the price of each product so that it sells through by its exit date at the highest achievable margin, by forecasting price response per style and location, scheduling the markdown cadence and sizing the markdown budget against the plan's reductions.
Retail allocation software is the system that decides how many units of each product, by size and pack, go to each store, channel or fulfilment node and when, distributing planned receipts and replenishment against store grades, size profiles, presentation minimums, capacity and current inventory so the plan's depth lands where it will sell.
Retail merchandising software is the set of systems a retailer or brand's merchandising organisation uses to decide what to sell, how much to buy, at what price, where to place it and when to mark it down, spanning merchandise financial planning, assortment planning, allocation and replenishment, pricing and markdown, and the product and space data those decisions run on.
Supply planning is the process of deciding how, when and from where the quantities in a demand or merchandise plan will be supplied: converting planned receipts into purchase orders, production bookings, raw-material commitments and inventory targets against lead times, capacity and minimums, so stock arrives where and when the plan needs it.
Assortment planning software is the system a brand or retailer uses to decide which options to carry in a season, for which channels and store clusters, and how deep to buy each one by size and pack, inside the open-to-buy that funds them.
// Calculators & Tools
Free interactive tools. Enter your numbers, get instant output — no software required.
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 →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
Most teams download a template, then stop. The ones that improve their planning follow through on all four steps below.
Templates, guides, and research to understand the problem and the options.
Browse resourcesScore your planning operation across 5 dimensions. Takes 5–8 minutes.
Take the assessment →See how RetailNorthstar compares to spreadsheets and enterprise platforms.
See comparisons →A 30-minute live walkthrough built around your planning workflow.
Start a free trial →// Full Library
All templates, assessments, calculators, and whitepapers — filter by type or audience.
// Featured Resources
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.
What AI actually does — and does not do — in apparel planning today. A practical primer for merchandising executives evaluating AI planning tools.
Model the financial impact of improving OTB accuracy, reducing markdown spend, and tightening inventory turns — with numbers from your own business.
Answer 15 questions about your current planning process and get a scored maturity profile — with specific next steps for each gap.
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
// Full Library
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.
What AI actually does — and does not do — in apparel planning today. A practical primer for merchandising executives evaluating AI planning tools.
Model the financial impact of improving OTB accuracy, reducing markdown spend, and tightening inventory turns — with numbers from your own business.
Answer 15 questions about your current planning process and get a scored maturity profile — with specific next steps for each gap.
A top-down financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for seasonal planning reviews with finance.
A structured spreadsheet for building seasonal assortments — category architecture, option counts, size curves, and margin targets in one file.
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.
Enter units, sales, markdown spend, and weeks active per SKU to identify which options are earning their space — and which are deadweight.
A structured evaluation guide for mid-market apparel brands assessing planning software — covering selection criteria, red flags, and a step-by-step RFP process.
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.
A monthly OTB workbook covering planned sales, receipt flow, beginning/ending inventory, and open-to-buy dollars — ready to fill in for any season.
// Knowledge Base
In-depth articles on OTB, assortment planning, buy planning, allocation, and the modern planning stack.
Browse Planning Guides →Practitioner-level definitions for apparel planning terminology — built for AI citation and search authority.
Browse Glossary →Data and analysis on apparel planning practices, spreadsheet risk, and the modern planning technology stack.
Browse Research →// Why This Resource Library Exists
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.
4–6 buy decision points per season · exposure compounds across the full season calendar
// Symptoms in practice
// 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
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.
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.
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.
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
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.
Open-to-buy, sell-through, GMROI, WSSI, lead-time, and an ROI estimator — interactive, no sign-up.
What a line board is, how to build one, and how the tools compare — from mood board to a sign-off-ready assortment.
Directional healthy ranges by channel for sell-through, GMROI, markdown %, turns, and more.
Points of view on the apparel operating system — why connected planning changes the economics.
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.