ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
#REF!
3
4
5
Merchandise Financial Planning & Open-to-Buy (OTB) Management Template
6
7
Welcome to Toolio's Merchandise Financial & Open to Buy (OTB) Planner!
8
This worksheet contains pre-made, user friendly templates for you to monitor and plan your sales, receipts and inventory.
9
10
Overview of Sheets
11
Inputs
The data entry sheet with color coded areas to input your last year's numbers, this year's plan and monthly actualizations.
12
Open-to-Buy
Your command center to review and understand your merchandise plan. This is a locked sheet as all the necessary data is seeded from the Inputs sheet.
13
*Notes*
Both sheets use the 4-5-4 Feb-Jan retail calendar.
14
15
Instructions
16
1. Input Sheet
Fill in last year numbers in the grey section
17
2. Input Sheet
Fill in this year target metrics in the yellow section
18
3. OTB Sheet
Review your full year plan. Make any target metric adjustments as desired.
19
4. Input Sheet
Fill in monthly actual numbers in the red section
20
5. OTB Sheet
Review monthly and consider appropropriate changes to future receipt, marketing and markdown plans.
21
6. Input Sheet
Fill in monthly receipt adjustments based on OTB analysis in the red section
22
23
How to Benefit and Leverage
24
- Have a centralized source of truth for your business.
25
- Review and share the upcoming year's plan before finalizing.
26
- Have a receipt plan to meet desired inventory levels.
27
- Measure actual performance against last year and current year forecasts.
28
- Decide on how to tweak marketing, markdown and inventory purchase adjustments, based on current performance.
29
30
Learn More
31
If you have suggestions on these templates and/or want to learn more about how to improve your merchandise planning, reach out to us at hello@toolio.com
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100