Thank you so much for your video. Really appreciate your efforts. One clarification, in vedio 8:57 Formula in Excel says Previous quarter level Plus Previous quarter Trend, where as in screen shot of formula it says Current quarter level plus current quarter trend. which is correct. Can you please confirm.
Sorry i was wrong, i interpreted wrongly, After looking closely i notice the F is F(t+1). its not F... you can ignore my request for clarification. Thanks again for your effort. I will recommend your channel to all my colleagues.
In this, multiplicative method has been used then why trend has been computed using additive method. The equation used here is beta*((l(t)-l(t-1)) rather than beta*((l(t)/l(t-1)) Please suggest?
ok may be this is Trend additive and seasonality multiplicative methods. Thanks Also one more question please, how to compute initial values of 12 and 13 months in excel?
Thank you so much for your video. Really appreciate your efforts. One clarification, in vedio 8:57 Formula in Excel says Previous quarter level Plus Previous quarter Trend, where as in screen shot of formula it says Current quarter level plus current quarter trend. which is correct. Can you please confirm.
Sorry i was wrong, i interpreted wrongly, After looking closely i notice the F is F(t+1). its not F... you can ignore my request for clarification. Thanks again for your effort. I will recommend your channel to all my colleagues.
@@abdulrahaman6424 Thank you Abdul for your interest in this video. I am very glad that you have found it useful and that you recommend it. 🙏
Great tutorial. Could I have possibly stupid question please? How do I utilize this method for multiple items within single supplier?
Can you share the excel file with us please?
In this, multiplicative method has been used then why trend has been computed using additive method. The equation used here is beta*((l(t)-l(t-1)) rather than beta*((l(t)/l(t-1))
Please suggest?
ok may be this is Trend additive and seasonality multiplicative methods.
Thanks
Also one more question please, how to compute initial values of 12 and 13 months in excel?
Or initial values of 4 quarters predictions in your example