Apparel Search › Downloadable Templates › Free Collection Range Plan Template (Excel)
Apparel Search Templates
Plan your collection style by style, and see the margin, revenue and mix across categories and deliveries.
A range plan lists every style in a collection with its category, delivery, cost, prices and planned units, so you can judge the whole collection before you place orders. This free Excel template calculates the wholesale margin, wholesale revenue and gross profit for each style, and a Summary tab shows styles, units, revenue, profit, margin and share of units by category and by delivery month. Category and month lists are editable on a Lists tab, so the plan fits your brand.
The plan assumes every planned unit sells at wholesale. It does not model markdowns, returns or unsold stock.
On the Lists tab, edit the categories (such as tops, bottoms and dresses) and the delivery months or drops. You can rename the months, for example Drop 1 and Drop 2. These lists feed the dropdowns and the Summary tab.
On the Range Plan tab, add one row per style: style number and name, category, delivery month, number of colors, landed cost, wholesale price, retail price and planned units. Use your real landed costs, so the margin results are honest.
Find landed cost with the Garment Cost Sheet and the Landed Cost Calculator.
For each style the sheet shows the wholesale margin, the wholesale revenue and the gross profit. The totals row adds up units, revenue, profit and the overall margin.
See how your units, revenue and profit are spread across categories and delivery months. Look for gaps and overloads: a heavy delivery that strains your cash, or a category carrying too little or too much of the plan.
Change planned units, prices or styles and watch the results update. Then turn each style's units into sizes and colors, and test the plan against your cash and break-even.
Split units with the Size Curve & Order Splitter, check cash with the Import Cash Flow Planner and test break-even with the Collection Break-Even Planner.
Yes. It is free to use in your own business. Please do not sell or republish the file as your own.
Wholesale margin is (wholesale price minus landed cost) divided by the wholesale price.
No. It assumes every planned unit sells at the wholesale price, so treat the profit as a best case. Use the Collection Break-Even Planner to test lower sell-through.
Yes. Edit them on the Lists tab. The dropdowns and the Summary tab update.
The template holds up to 40 styles, 20 categories and 12 delivery months.