Line plan template
A ready-to-use Excel line plan that sets the shape of the season by category before any styles exist — option count, carryover vs newness, average price, buy units, and planned sales. Newness and sales roll up automatically so you can balance the assortment in minutes.
- Category rows — Tops, Bottoms, Dresses, Outerwear, Knitwear, Accessories
- Total options auto-summed from carryover + new
- Auto % newness — new options ÷ total options
- Planned sales $ auto from buy units × average retail price
- Total-line roll-up with blended newness %
- Editable inputs in blue, auto-calculated columns shaded grey
Once the line is shaped, build the buy budget with the open-to-buy calculator or the OTB template.
Built for merchandisers and merchandise planners who shape the assortment by category, and for buyers who turn that shape into a buy. If you set option counts, newness, and price architecture before styles exist, this is for you.
Taking the line into a full assortment? See the assortment planning template or read line plan vs assortment plan.
This template is useful when the workflow is owned by one person or one small team. It starts to break when multiple teams need the same version of the plan, when inputs change frequently, or when decisions need to flow into assortment, buying, purchase orders, production, and allocation.
- Flows the line plan into the actual assortment and buy instead of a static spreadsheet.
- Keeps option counts, newness, and planned sales reconciled to styles end to end.
- Re-rolls the line shape automatically as styles, prices, and buy units move.
- Connects the line plan to OTB and the buy so the season stays balanced as it evolves.
Use the spreadsheet to get started. When the process becomes too manual, RetailNorthstar connects the plan, assortment, buy, PO, and production workflow.
A spreadsheet line plan captures the shape, but it goes stale the moment styles, prices, and buys start moving. RetailNorthstar keeps the line plan connected to the actual assortment and buy so option counts, newness, and sales stay reconciled end to end.
Book a Demo →See it on RetailNorthstar →