Download the seasonal time series and forecasts here: https://abcsupplychain.com/downloads...
Join my Demand Forecasting WORKSHOP (free): https://abcsupplychain.com/demandfor...
How do you deal with monthly, quarterly, or yearly cycles in your business? ♂
Integrating them into your forecasts is essential to allocate the right resources (time, money, people) at the right time
I just made a new stepbystep Excel tutorial to identify, calculate, and integrate seasonality into your forecasts.
In the comments, let me know how you deal with seasonality!
▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬
00:00 Intro
00:32 Why you need to integrate seasonality into your forecasts
01:35 Seasonal Factors
02:30 Temporality
03:46 Seasonality for statistical forecasts
03:53 Amazon example in Excel
04:13 How to detect seasonality
05:18 Seasonality per Quarter
06:41 Base 100 (Normalization)
08:24 Seasonal Forecast (Quarter)
09:02 Bike industry example in Excel
09:42 Seasonality per month
12:35 What to do if you don't have enough historical data
12:54 How to deal with outliers
13:08 Why use demand rather than sales
13:31 Value vs Quantity
13:59 Which level of aggregation? (granularity)
15:01 How to get a more reliable forecast?
►MY BLOG : https://abcsupplychain.com/
#forecasting #seasonality