St.Gallen Seasonality Monitor (SSM) : On-shelf availability as required by your customers
Type
case study
Date Issued
2011
Author(s)
Ehrenthal, Joachim C.F.
Abstract
As a retail customer, you walk into a store one evening and find your favorite brand of bread out of stock. For you, that just causes the hassle of having to walk across the street to buy the same bread at a competitor's store. For retailers, this is a huge problem. They must get the timing right of when to hold items available. Otherwise, retailers lose big money.
Replenishing a brand of bread that is not sold in the following hours means wasting labor resources that could be put to better use elsewhere. If the bread does not sell, it may have to be marked down, or worse, thrown away. Both is very costly to the retailer and not sustainable. The question therefore is: At what time of the day do the products have to be on the shelves?
This is where the St.Gallen Seasonality Monitor (SSM) helps. Using readily available sales data, this easy-to-use MS Excel tool visualizes patterns and trends in your sales by month, week, day, and hour of the day. To immediately view your results, follow these three steps:
1) Download the latest version of SSM from this website.
2) Input your sales data as shown in the file.
3) Select the item or category of interest and view the results.
You can use the results to adjust instore logistics to match customer demand: Replenish in times of low sales to be prepared for the upcoming sales peak. In doing so, you ensure availability when it is required by your customers. Implementation will simplify store workload scheduling and improve handling efficiency.
The St.Gallen Seasonality Monitor (SSM) is tried and tested in retailing. However, it can be used in other service environments where demand exhibits intraday fluctuations. These areas include call centers, shared service centers (e.g. accounting services), and hospital emergency departments.
The St.Gallen Seasonality Monitor (SSM) is available under the creative commons license CC [http://creativecommons.org/licenses/by-nc/3.0/ BY-NC]
Replenishing a brand of bread that is not sold in the following hours means wasting labor resources that could be put to better use elsewhere. If the bread does not sell, it may have to be marked down, or worse, thrown away. Both is very costly to the retailer and not sustainable. The question therefore is: At what time of the day do the products have to be on the shelves?
This is where the St.Gallen Seasonality Monitor (SSM) helps. Using readily available sales data, this easy-to-use MS Excel tool visualizes patterns and trends in your sales by month, week, day, and hour of the day. To immediately view your results, follow these three steps:
1) Download the latest version of SSM from this website.
2) Input your sales data as shown in the file.
3) Select the item or category of interest and view the results.
You can use the results to adjust instore logistics to match customer demand: Replenish in times of low sales to be prepared for the upcoming sales peak. In doing so, you ensure availability when it is required by your customers. Implementation will simplify store workload scheduling and improve handling efficiency.
The St.Gallen Seasonality Monitor (SSM) is tried and tested in retailing. However, it can be used in other service environments where demand exhibits intraday fluctuations. These areas include call centers, shared service centers (e.g. accounting services), and hospital emergency departments.
The St.Gallen Seasonality Monitor (SSM) is available under the creative commons license CC [http://creativecommons.org/licenses/by-nc/3.0/ BY-NC]
Language
English
Keywords
On-shelf availability
intraday sales patterns
HSG Classification
contribution to practical use / society
Refereed
Yes
Publisher
LOG-HSG
Publisher place
St.Gallen
Subject(s)
Eprints ID
78436
File(s)![Thumbnail Image]()
open.access
Name
St.Gallen Seasonality Monitor (SSM) Version 1.0.xlsx
Size
14.09 MB
Format
Microsoft Excel XML
Checksum (MD5)
88d21fcf15734dc1174af8ac662ff589