Forecasting Methods made simple - Seasonal Indices

  Рет қаралды 172,053

Piyush Shah

Piyush Shah

11 жыл бұрын

The video describes using MS Excel to calculate seasonal indices for a very simple set of data that has seasonal fluctuations.

Пікірлер: 82
@wowwhydopplhavemyid
@wowwhydopplhavemyid 8 ай бұрын
Watching your vids again! 10 years working in supply chain, but your videos always give a great reminder!
@piyushashah1
@piyushashah1 8 ай бұрын
Thanks for writing this comment Bryce.
@Narduath
@Narduath 10 жыл бұрын
This was extremely helpful, and served to clear up my confusions ahead of my Operations Management final. Thank you!
@piyushashah1
@piyushashah1 10 жыл бұрын
Am happy that the video helped you. Thanks for leaving this comment.
@aaronhei311
@aaronhei311 9 жыл бұрын
Thank you for your wonderful and clear explanation!
@asitkumarsadangi1295
@asitkumarsadangi1295 5 жыл бұрын
Thank you so much. It helped me analyse data for my PG Thesis.
@AndyRyanTX
@AndyRyanTX 8 жыл бұрын
Thank you!!! You explain things so well and make it easy.
@piyushashah1
@piyushashah1 8 жыл бұрын
+Andy Ryan Thanks for leaving the comment. All good things are always simple!!
@afhdaily66
@afhdaily66 5 жыл бұрын
Thank you for very nice video. I am a beginner and autodidactive learner. It is very helpful
@jeddturcotte5184
@jeddturcotte5184 9 жыл бұрын
Thank you for your help! Was very informative.
@rakschanna
@rakschanna 8 жыл бұрын
Excellent !!!! Thank you so much
@Sgenea
@Sgenea 8 жыл бұрын
Thank you for your video!
@sbhanuprakash9
@sbhanuprakash9 3 жыл бұрын
Thanks for detail explanation. But may I know how we got the 4th year # as 570.(@5:00 min)
@jumanjned5812
@jumanjned5812 4 жыл бұрын
really thank you so much it helped me a lot for my MGT 300 final project, however i have a question that do we have to use a forecasting technique to get the predicted total demand for 2020?
@chatwithvarun
@chatwithvarun 4 жыл бұрын
Thanks so much. Very easily illustrated
@fernandesc23
@fernandesc23 5 жыл бұрын
Thank you! this was tremendously helpful :)
@piyushashah1
@piyushashah1 5 жыл бұрын
Do look at the other videos on forecasting as well.
@suraj123ification
@suraj123ification 8 жыл бұрын
Hello Mr. Piyush, Very nice video! I just have one question, though.. How will I calculate my seasonal indices when I do not have a complete set of data points? For example, if I am using monthly sales data for forecasting, and I have only 30 months of previous sales data, how will I calculate the seasonal indices? My data starts in Feb,2014 and ends in July,2017.
@marieelaineechano9085
@marieelaineechano9085 8 жыл бұрын
thank you. this video is very helpful
@prgoddess
@prgoddess 9 жыл бұрын
Thank you! Very helpful!
@mushroomsavvy
@mushroomsavvy 3 жыл бұрын
Thank you for your video. Can we first deseasonalize the demand data and do the forecast based on any of the forecasting methods such as exponential smoothing etc and then apply the seasonality index?
@nidhichowdhary1473
@nidhichowdhary1473 2 жыл бұрын
Hi Piyush, can please calculate the fitted values using the model to calculate variance analysis and also how did you get total of 570 for year 4?
@Wachuka
@Wachuka 7 жыл бұрын
Very helpful. Thank you so much
@abhishekarya009
@abhishekarya009 7 жыл бұрын
Nice video, Sir please make videos using same example for weighted moving average and exponential smoothing.
@agnesmo8524
@agnesmo8524 8 жыл бұрын
Mr. Piyush can I ask what book or theory references you used for this method?
@svenskfox
@svenskfox 9 жыл бұрын
Really helpful, thanks a lot!
@piyushashah1
@piyushashah1 9 жыл бұрын
Thanks for leaving this comment. Happy that the video was useful to you. Do also check the video on Measuring Forecasting Accuracy.
@sfpodcastedge7430
@sfpodcastedge7430 Жыл бұрын
Is it possible to use the demand figures for year 3 multiplied by the seasonal indices to predict year 4 instead of assuming 570 as you did? I actually did use the excel triple smoothing model and got slightly higher forecast figure than these values..Thanks!
@mayasilver6535
@mayasilver6535 3 жыл бұрын
Do i have to predict year 4 or there is some calculation to get it ?
@sgteamx
@sgteamx 8 жыл бұрын
Hi jus wanna say thank you!
@lawrencenanagyan489
@lawrencenanagyan489 10 жыл бұрын
where do you get the 570 from around the 5min mark?
@piyushashah1
@piyushashah1 10 жыл бұрын
Sorry for the late reply. I somehow missed your message. The 570 is a number I have assumed here. The yearly sale could have been obtained by any time series method. The yearly demand is not affected by seasons as all versions of seasons are inside the year and hence calculating that is easier.
@theknowledgekart
@theknowledgekart 4 жыл бұрын
he had made mistake..instead of 570 , 143.34 average of 1st quarter of all 4 years need to be taken and multiply it by seasonality factor of 1.0305 to get forecast of quarter 1 and so on for quarter 2, 3,4 .
@jackthebeanstalkdelohio5146
@jackthebeanstalkdelohio5146 3 жыл бұрын
For monthly seasonal pattern, how do an analyst calculate the average price change? Do they total all the gains, and get the average from that? Or do they total all the losses....... I am not sure. What is it if u don't mind me asking? Thx.
@josephnukonze3970
@josephnukonze3970 4 жыл бұрын
What would be the best method if the data does not show seasonality?
@DianitaAB
@DianitaAB 9 жыл бұрын
thanks!
@rosariodizon1753
@rosariodizon1753 8 жыл бұрын
hello Mister Pitush .. where did you get the 570 demand for year 4?
@piyushashah1
@piyushashah1 8 жыл бұрын
+Rosario Dizon That is assumed to be given. Maybe some other method was used to derive it.
@ricardoguzman7518
@ricardoguzman7518 Жыл бұрын
@@piyushashah1 Why would someone try to figure out the forecast if that amount was already given?
@piyushashah1
@piyushashah1 Жыл бұрын
@@ricardoguzman7518 You would need monthly or quarterly demand forecasts for production or fullfilment. it is a normal process to disaggregate forecasts like this from some aggregate forecast.
@maryjohannaespera5643
@maryjohannaespera5643 7 жыл бұрын
i'm wondering how you can forecast daily volumes for christmas, using trends from past 3 years, as christmas day varies per year
@piyushashah1
@piyushashah1 7 жыл бұрын
I am not sure if you can use these methods to directly predict the demand for next Christmas. While you could use the Holt-Winter's model as a base, you would have to add contextual factors to account for current year.
@ciai7317
@ciai7317 5 ай бұрын
Where that 570 for year 4th come from?
@sanketnaikhe5819
@sanketnaikhe5819 2 жыл бұрын
Thank you sir
@keranevelyne4987
@keranevelyne4987 2 жыл бұрын
How did you find the total for the fourth year (570)
@swatikanchan8650
@swatikanchan8650 9 жыл бұрын
Hi Piyush, can you also show us how to deseasonalize the seasonality trends. Thanks
@piyushashah1
@piyushashah1 9 жыл бұрын
HI Swati, I'll try. Thanks a lot for the suggestion.
@akshitagulati9790
@akshitagulati9790 7 жыл бұрын
How would calculate seasonal indices using average percentage method?
@piyushashah1
@piyushashah1 7 жыл бұрын
Do you mean percentage of sales method? Why do you need to do that? Can you give me details please?
@last123login
@last123login 9 жыл бұрын
Thanks for sharing
@piyushashah1
@piyushashah1 9 жыл бұрын
Thanks for leaving the comment Aay...there are other forecasting videos as well, do have a look.
@tinatse1998
@tinatse1998 9 жыл бұрын
Many thanks for this video! Just dropped an email =)
@anshulagarwal8831
@anshulagarwal8831 4 жыл бұрын
Hi piyush, how you get the value of 570?
@piyushashah1
@piyushashah1 4 жыл бұрын
That is an assumed number Anshul. Typically we could use some form of time series of regression to arrive at it. I have a video on that.
@IAKhan-km4ph
@IAKhan-km4ph 4 жыл бұрын
nice
@theknowledgekart
@theknowledgekart 4 жыл бұрын
dear sir, thank u for the video..there is need of little correction in the tutorial.. instead of 570 , 143.34 average of 1st quarter of all 4 years need to be taken and multiply it by seasonality factor of 1.0305 to get forecast of quarter 1 and so on for quarter 2, 3,4 .
@piyushashah1
@piyushashah1 4 жыл бұрын
hello Rishu, thank you for this comment. The actual demand numbers already have the influence of seasons. So, averaging them and adding the effect of seasons again on them would not be valid. The ideal way is to use some method to find deseasonalized demand forecast and then add the effect of the season. I have used aggregate demand forecast from an unmentioned method as the deseasonalized demand. There can be many other ways to arrive at the deasonalized demand other than what I have done. Hope this helps.
@ankushzap
@ankushzap 8 жыл бұрын
what if I donot have 4th year total data 570. How to forecast then?
@piyushashah1
@piyushashah1 8 жыл бұрын
+ankushzap With this method you need that '570'. We can use some other method, maybe regression to get that.
@agroasesor1
@agroasesor1 7 жыл бұрын
A big H E L L O from COLOMBIA. I do something like you.....related to milking production, but using percentage....I know you are laughing now but, is my way...and it works with cow´s milk production. I will use your method. G R A C I A S M I L !!!!
@smaranrai4898
@smaranrai4898 2 жыл бұрын
Hi! can we find the seasonal indices for data that only have 1-year of data?
@piyushashah1
@piyushashah1 2 жыл бұрын
You can... But I won't trust the accuracy of such one year based indices.
@smaranrai4898
@smaranrai4898 2 жыл бұрын
@@piyushashah1 Thank you for responding, but can you please tell me why wont you trust its accuracy? You see I am new to forecasting, and I wanted to know if a company only has past data for 1 year, how should it go about forecasting for future months mitigating the seasonal effects?
@piyushashah1
@piyushashah1 2 жыл бұрын
@@smaranrai4898 There could have been some random variation in a specific period. If you just have one year data, you will assume that the random variation is a part of seasonality. However, if you have multi-period data, such random variations tend to average out and we get more accurate seasonality indices.
@smaranrai4898
@smaranrai4898 2 жыл бұрын
@@piyushashah1 Thank you so muchh piyush!! This makes things much clearer!!!
@yanuaranabawahyuesa9049
@yanuaranabawahyuesa9049 9 жыл бұрын
Why not test the data from forecast eror ? How we know that forecast is well ?
@piyushashah1
@piyushashah1 9 жыл бұрын
Yanuar Anaba Wahyuesa We should check the Forecast for errrors. There is a separate video on the different ways to calculate the errors.
@asimashahzadi9851
@asimashahzadi9851 7 жыл бұрын
what is solution? when Anova result is not significant .
@piyushashah1
@piyushashah1 7 жыл бұрын
Asima Shahzadi sorry, can you elaborate on your question?
@swapnildambhare
@swapnildambhare Жыл бұрын
570 year 4 it is immaginary?
@piyushashah1
@piyushashah1 Жыл бұрын
As mentioned in the video, you can use some other method to forecast that.
@vaiataleone1752
@vaiataleone1752 4 жыл бұрын
how do we get the 570
@piyushashah1
@piyushashah1 4 жыл бұрын
That is an assumption for this video. In actual scenario we can get it from linear regression or some mechanics performed on yearly demand data.
@priyankakumarisinha5997
@priyankakumarisinha5997 2 жыл бұрын
How this 570 came?
@piyushashah1
@piyushashah1 2 жыл бұрын
I have assumed that number for this video. We can get it from moving average, regression or any of the other methods explained in other videos.
@ricardoguzman7518
@ricardoguzman7518 Жыл бұрын
This video was so good up until the 5 min mark. Year 4 being introduced with no explanation for the 570 demand......
@piyushashah1
@piyushashah1 Жыл бұрын
It is an assumed number that we could have obtained from regression or any other method.
@gorecki4612
@gorecki4612 9 жыл бұрын
Great click noise
@piyushashah1
@piyushashah1 9 жыл бұрын
Daniel Burke Yes, and sorry. But the free tool I have has this limitation. I hope I can get a better method or a tool.
@razenndrajoshi4103
@razenndrajoshi4103 2 жыл бұрын
How to choose the correct forecast and do accuracy for retail? & How to do SKU level forecasting for the short term which includes seasonal items? I have sent mail. please check
@deepsammanna
@deepsammanna 6 жыл бұрын
Sir how do you model the croston method for intermittent demands?
@piyushashah1
@piyushashah1 6 жыл бұрын
There are pdfs online that discuss Croston method. For example this: courses.edx.org/asset-v1:MITx+CTL.SC1x_1+2T2015+type@asset+block/w4l2_NewIntermittentProducts_ANNOTATED_FINAL.pdf. I have never used this method am not sure how exactly to use this.
Forecasting Methods made simple - Trends and Moving Average
5:15
- А что в креме? - Это кАкАооо! #КондитерДети
00:24
Телеканал ПЯТНИЦА
Рет қаралды 7 МЛН
Clowns abuse children#Short #Officer Rabbit #angel
00:51
兔子警官
Рет қаралды 57 МЛН
Operations Management using Excel: Seasonality and Trend Forecasting
13:32
Excel@Analytics - Dr. Canbolat
Рет қаралды 412 М.
Seasonal indices: calculating SI and deseasonalising data
13:31
Australian Mathematics Curriculum Videos
Рет қаралды 77 М.
Maths Tutorial: Seasonal Indices (Seasonal Index)
19:50
Further Maths
Рет қаралды 149 М.
How to perform Holt Winter's Method on Monthly Data (in Excel)
13:21
Multiplicative Seasonal Forecasting
6:09
The Business Doctor
Рет қаралды 8 М.
Forecasting Techniques: Trend and Seasonality-Corrected (Winter's Method)
18:26
Supply Chain Tutorials
Рет қаралды 108 М.
Forecasting Methods made simple - Trend Lines
9:59
Piyush Shah
Рет қаралды 42 М.
Forecasting Methods made simple - Moving averages
6:29
Piyush Shah
Рет қаралды 68 М.
Forecasting Seasonal index for seasonal variation in data
16:22
Business Analytics
Рет қаралды 31 М.