Operations Management using Excel: Seasonality and Trend Forecasting
In this video I explain how to create a forecasting model in Excel for a data set that involves both trend and seasonality. I chose not to de-seasonalize data set before finding the trend parameters.
Dataset URL: Copy and Paste it into Excel or work in Google Sheets
https://docs.google.com/spreadsheets/d/1BCEwiX4si5Zzkgcc51rkwaAIAOhMpr1V1U7qRaV7C0g/edit?usp=sharing
I posted a follow up video in which you can handle multiple forecasts at the same time for multiple SKUs (Stock Keeping Units).
https://www.youtube.com/watch?v=-WK0Db7hY2U
An alternative method could be to use a multiple linear regression model. And I think the regression model is more practical. Yes, I have recorded a video for that as well. The link for the video is https://youtu.be/KE_mk9wvu6U
These videos are created for the students at The College at Brockport, State University of New York. However anyone can benefit from them as they should work for any Operations Management class.
Видео Operations Management using Excel: Seasonality and Trend Forecasting канала Mustafa Canbolat
Dataset URL: Copy and Paste it into Excel or work in Google Sheets
https://docs.google.com/spreadsheets/d/1BCEwiX4si5Zzkgcc51rkwaAIAOhMpr1V1U7qRaV7C0g/edit?usp=sharing
I posted a follow up video in which you can handle multiple forecasts at the same time for multiple SKUs (Stock Keeping Units).
https://www.youtube.com/watch?v=-WK0Db7hY2U
An alternative method could be to use a multiple linear regression model. And I think the regression model is more practical. Yes, I have recorded a video for that as well. The link for the video is https://youtu.be/KE_mk9wvu6U
These videos are created for the students at The College at Brockport, State University of New York. However anyone can benefit from them as they should work for any Operations Management class.
Видео Operations Management using Excel: Seasonality and Trend Forecasting канала Mustafa Canbolat
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to do forecasting with Excel 2016
Seasonality and Trend Forecasting Video 2: Multiple SKUs
Secrets to Building Excel Dashboards in Under 15 Minutes!
Forecasting Techniques: Trend and Seasonality-Corrected (Winter's Method)
Forecasting: Moving Averages, MAD, MSE, MAPE
Seasonality and Trend Forecasting using Multiple Linear Regression with Dummy Variables as Seasons
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
Inventory Management | Excel Inventory Management (Super Easy)
Demand Planning S&OP and Inventory Controlling Model Created by Kunal Jethwa
Forecasting in Excel Using Simple Linear Regression
Use the TREND Function to Predict Sales Growth
Excel - Time Series Forecasting - Part 1 of 3
Forecasting with Seasonality
Forecasting Methods made simple - Moving averages
Forecasting Methods made simple - Exponential Smoothing
Deseasonalized Data with a Centered Moving Average
Operations Management using Excel: Forecasting Video 1/4 Moving Averages
Demand Forecasting (Using Excel) || Easy to learn with Prof. Sharad Gupta
Forecasting Trend and Seasonality
How to perform Holt Winter's Method on Monthly Data (in Excel)