WSSI template
A ready-to-use Excel WSSI — Weekly Sales, Stock & Intake worksheet for apparel and retail planning. Closing stock, carried opening, and forward weeks-of-cover are all formula-driven across a 13-week trading quarter, so changing one intake or sales number re-flows the whole stock position instantly.
- 13-week trading quarter, pre-laid out and ready to fill
- Auto closing stock — Opening + Intake − Sales − Markdowns
- Opening stock carries automatically from the prior week
- Forward weeks-of-cover off the next 4 weeks of planned sales
- Season totals for intake, sales, and markdowns
- Editable inputs in blue, auto-calculated columns shaded grey
New to WSSI? Read what is a WSSI or run the numbers in the WSSI calculator.
Built for merchandise planners and buyers who manage weekly sales, stock, and intake, and for merchandisers balancing the trading position across a season. If you re-forecast cover and chase intake every week, this is for you.
Want to run a single period first? Use the WSSI calculator.
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.
- Keeps the WSSI live for every plan instead of one department’s spreadsheet.
- Keeps WSSI, intake, and open-to-buy connected so a change in one re-flows the others.
- Re-projects stock and forward weeks-of-cover automatically as sales and intake actuals land.
- Surfaces cover running hot or stock building before the position needs a markdown to clear.
Use the spreadsheet to get started. When the process becomes too manual, RetailNorthstar connects the plan, assortment, buy, PO, and production workflow.
A spreadsheet WSSI works for one department. Across a full assortment — every channel, size curve, and option — the re-forecasting becomes the whole job. RetailNorthstar keeps the WSSI live for every plan and re-projects stock and cover automatically as sales and intake actuals land.
Book a Demo →See it on RetailNorthstar →