Smart In Planning has released a new calendar for merchandise planners.
Of the many moving pieces that make up the “Retail machine”, it might come as a surprise that a simple calendar is the foundation that anchors and unifies everything. We are talking, of course, about the Retail or Trading calendar, AKA the 4-4-5 or 4-5-4 calendar among those in the Retail know.
Wait a minute, the what-what-what calendar?
We know about the regular (Gregorian) calendar – that runs Jan to Dec, and shows weekends and holidays.
We know about a Financial Year calendar – that runs from start July to end June and lines up with tax reporting.
We know about Events and Marketing calendars - that track promotional and market activity.
We especially know about Advent calendars – where we get to eat chocolate every day for a month!
So, what’s this new one, and WIIFM?
Well, it’s actually a little stroke of organisational genius, that many Retail businesses rely heavily upon. In simple terms it standardizes the year. And it’s GOLD for Merchandise Planners!
What does that mean? Let’s consider the Planning dimensions of Location, Product and Time …
We know it’s important to measure comparable sales (like for like) based on store footprint or store count (comparable Location).
We typically compare the product offering with previous ranges, supporting events and marketing activity (comparable Product).
We know in Retail, that there are important trading patterns across the days of the week, and associated consumer behaviour.
But in a regular calendar, time is not standardised. The number of days in the months vary, and every month can actually start on a different day of the week!
This makes it almost impossible to compare performance across time, because there are just too many inconsistencies.
And that’s where the Retail Calendar comes in.
How does it work?
Every week starts with the same day (usually Sunday or Monday), every week is the same length, with the same number of days, in the same pattern.
The months are 'equalised too', being either exactly 4 weeks or 5 weeks long in a consistent and predictable pattern, that is the same as the previous year.
The weeks are 'numbered' 1 to 52, so from year to year, you can just compare the same weeks. Week 32 is always week 32, regardless of the date. So clever!
Why should you adopt a retail calendar?
Apart from the obvious benefits already listed, making like for like comparisons to last year super easy, there are lots of other benefits too:
Equalising the months and weeks makes comparisons from month to month easier too, as performance can be broken down into weekly averages. A 4 week month can be compared to a 5 week month with more context when broken down to an average per week, rather than comparing March (31 days) to February (28 days), for example.
It helps everyone speak a common language – planning, buying, production, marketing, supply chain, finance, operations and VM are all synchronised, which facilitates planning launch dates, critical paths etc
It can have a smoothing effect eg if NOV is the biggest month of the year, making it 4 weeks rather than 5 spreads the load, making steps ups and growths less extreme.
Things to be aware of ...
This is not a ‘real world’ calendar, so we need to do some reality checks:
The initial implementation may be challenging. It's quite an adjustment when all we have ever known is the yearly calendar, so just be patient and persevere.
Alignment to Finance calendars may vary. Often the Finance team will keep working to the yearly calendar, reporting from the 1st until the end of the month. Understanding that variances relate to slight differences in the time periods reported makes for easier resolution. A reconciliation step between the Planning numbers and the Finance numbers at the end of the month is good practice.
The 7 year itch. Every seven years or so, we need add a 53rd week to synch back to reality or things start getting out of alignment. When that time comes there are a few things to consider re: mapping of last year data for reporting. With good understanding and a bit of preparation, the step change is easily applied, with everyone clear on the implications.
Don't let the fear of the unknown hold you back
It may seem complicated and daunting, but it’s actually pretty simple, and very powerful.
Once you’ve tried it, you'll wonder how you ever operated without it, and you’ll never look back (well, you will, but only for comparable purposes )
Get yours now!
Download your Retail Calendar for FY24 - FY25 from The Planning POD, our free resource centre for everything Merchandise Planning.
https://smartschool.smartinplanning.com/retail_calendar_download_Planning_POD