Season target
$84,500
Planned growth on last year
17%
Sales so far
$5,120
Holiday Season Retail Planner
Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.
4 free inventory planner template templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Pricing & Merchandising and Reordering & Stock Planning. Start with Holiday Season Retail Planner, Demand Forecast Planner and Open-to-Buy Plan: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Season target
$84,500
Planned growth on last year
17%
Sales so far
$5,120
Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.
Forecast units next month
2,189
Units short
1,089
Products growing
4
Forecast next month for each product from the last six months, with a trend and seasonal adjustment.
Planned purchases
$235,600
Already on order
$145,000
Open to buy
$90,600
Plan purchases by department and month from sales, markdowns and target stock, and see what is left to spend.
Yearly cost today
$8,466
Yearly cost at EOQ
$6,799
Possible saving
$1,667
Find the order size that keeps ordering and holding costs lowest for each item.