Inventory Management and Warehouse Operations.

# Calculating and Using a Seasonality Index

Seasonality Indexes are an important part of inventory forecasts in businesses that have repeated variable demand patterns that are based on time. The calculations for seasonality indexes are relatively simple, but you need to understand seasonality and forecasting to use them correctly.
Let's start with defining seasonality. Everyone understands a holiday peak for consumer goods that could be gifts, or a summer peak for sunscreen or beach gear. But any variability that repeats based on time should be considered as part of your seasonality index. For example, a lot of businesses have a surge at the end of each month, each quarter, or the end of the year. I call this self-induced seasonality because it is the result of internal policies—typically policies that involve bonuses or incentives that are based on months, quarters, or years.

I would prefer businesses find other ways for these types of incentives. But this is the way it is and has been for many years.

Back to seasonality indexes, the math to calculate and index is not all that complicated, but preparing the data takes some work and some thought. The main problem with seasonality indexes is that for decades people have been taught they can calculate the index against a single item, then apply it to the forecast for that same item. I have spent a lot of time working with demand history, and I can tell you that there is too much other variability in demand for this to work. To attempt to eliminate this variability means we need more demand. This means we need more items with similar seasonality patterns, AND we need to use more years of demand.

This is where you get to see how much you know about your sales. You need a group of items with similar seasonal demand patterns. If you sell snow shovels, and only snow shovels, all your items may have the same seasonal demand patterns. However, if you know that some of your models of snow shovels are also frequently used by industrial customers to clean up stuff in their facilities, those are going to be in a different group. In theory, you could figure this all out mathematically, but that is very challenging, and this is one of those times when human input is a better way to get started.

Once you have your seasonal groups, you need to look at other things that can impact your calculation. One issue is what to use as the unit of measure to consolidate your demand data. If your items are all similar, you should be able to use units sold, or dollars sold, and get similar results. But if you have significantly different items, such as sheet metal and sheet metal screws, the larger quantities likely sold of sheet metal screws sold will probably skew the results if you use units sold. In that case, you may try dollars sold, or just exclude the sheet metal screws in the calculation. Also, slow movers tend to have a lot of demand variability that is unrelated to seasonality, so I will usually only use fast-to-moderate movers to calculate the indexes.

Next, how much time (demand history) should you use? As much as you can get, provided nothing funky happened during the previous years that significantly affected demand. What are "funky" things? Let's say you purchased a competitor to get their customers, that should have dramatically affected your demand. Or, a new competitor entered the market, and that cut into your sales. Or, a pandemic hits, and you sell something that everyone thought they needed in a pandemic. Or, you ran a one-time promotion that temporarily increased demand. So these are all things that likely suddenly changed your demand, but not because of seasonality. As to the promotion, if you ran it every year at the same time, you may choose to just incorporate that demand into your seasonality index.

So we're going to start with three years of demand history and use units sold as the unit of measure. We're going to aggregate the demand for all items in each seasonal group by month and year. Then, we add all demand for January (all three years), then for February, etc.
To get our index, we divide each month's total demand by the average demand of all months. The index for each month is relative to 1 (one). So if you get an index of 0.90 for a month, it means that month's demand should be 9/10 or 90% of an average month's demand. Therefore to apply a seasonality index, you simply multiply your deseasonalized forecast for that month by the index for that month. So if you have a deseasonalized forecast of 1,000 units for a month with a seasonality index of 0.90, you will get a seasonally adjusted forecast of 900 units for that month.
The image below shows an example of a seasonality index calculated over three years. I also included a line chart to better help visualize the seasonal pattern. You want to look for any unusual peak or valley, especially one that does not align with what you thought you knew about your seasonal patterns. This one looks pretty good, with a peak in summer and another just before Christmas.

The following image shows each year independently calculated and put on a line chart. Here you would check to see if each year follows a similar pattern to the three-year calculation. June of 2016 had a little higher demand than expected, so it would be worth looking at that detail to see if it can be explained, but overall this looks consistent enough.

Another good check would be to go back a few more years and calculate an index to see if it matches. In addition, you can calculate an index against individual items to make sure they also fit the same pattern. Be aware that your individual items will probably show greater variability, which is why we are calculating against a group. If you find an item that is dramatically different over multiple years, you may need a separate index for that and any similar items.

The process of going back and checking other years and individual items is a bit tedious, but the effort is worth it. The good news with seasonality indexes is that once you get a good index, you can keep using it for many years because seasonality doesn't usually change all that much. While you should go back and review it occasionally, once it's done, it's done.

## Removing Seasonality from Demand.

In the process of forecasting demand, you will generally want to first remove any seasonal effects. To do this, you just divide the demand for a month by the seasonality index for that month. Now you have deseasonalized demand, and you can proceed to apply a smoothing calculation to it to start putting together your forecast. Later, after you produce a deseasonalized forecast, you will multiply each month's forecast by the index to get a seasonalized forecast. In the image below, you can see the results of deseasonalizing the demand.  You'll notice that there is not as much variability from month to month with the deseasonalized demand.

In the image above, we deseasonalized demand and got an average demand per month of 297 units. We chose to simply add 5% to this for our monthly forecast for the next year resulting in a monthly forecast of 312 units. We then multiplied each month's forecast by the corresponding seasonality index to get the Seasonalized Forecast shown. That's all there is to it.

## Calculating Seasonality Index for a Single Item.

Previously, I recommended not doing this. However, under certain conditions, you may have no choice. For example, what if you only sell one item? If you only sell one item, or only have one item that would be subject to certain seasonal characteristics, you may be able to calculate an effective index from just that one item.  This assumes that item is a fast mover and you have multiple years of sales history.