Operations Management using Excel: Forecasting Video 1/4 Moving Averages

preview_player
Показать описание
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.

Download the worksheets as an Excel file (or save a copy) from:
  1. Excel@Analytics - Dr. Canbolat
  2. operations management
  3. forecasting
  4. simple moving average
  5. moving averages
  6. mad
Рекомендации по теме
Operations Management using 0:08:43

Operations Management using Excel: Forecasting Video 1/4 Moving Averages

Operations Management using 0:07:35

Operations Management using Excel: Forecasting Introduction

Operations Management using 0:13:32

Operations Management using Excel: Seasonality and Trend Forecasting

Forecasting in Excel 0:05:42

Forecasting in Excel Made SIMPLE (include seasonality & make predictions)

The Excel FORECAST 0:05:31

The Excel FORECAST Function

Operations & Supply 0:11:12

Operations & Supply Chain Management: Forecasting & Demand Planning

Operations Management using 0:06:12

Operations Management using Excel: Forecasting Video 4/4 Linear Trend Model

Operations Management: Forecast 0:08:43

Operations Management: Forecast Errors (MSE, MAD, MAPE)

5 Excel Hacks 0:10:44

5 Excel Hacks Every Supply Chain and Operations Pro Should know

Operations Management using 0:06:24

Operations Management using Excel: Forecasting Video 3/4 Exponential Smoothing

Operations Management using 0:08:51

Operations Management using Excel: Forecasting Video 2/4 Weighted Moving Averages

Forecasting: Exponential Smoothing, 0:04:59

Forecasting: Exponential Smoothing, MSE

Forecasting in Excel 0:14:58

Forecasting in Excel - Must Skill for Data Analyst | Excel Tutorial

Demand Planning S&OP 0:08:16

Demand Planning S&OP and Inventory Controlling Model Created by Kunal Jethwa

MOVING AVERAGES AND 0:06:02

MOVING AVERAGES AND MEAN ABSOLUTE DEVIATION in EXCEL | OPERATIONS MANAGEMENT | FORECASTING

Forecasting: Moving Averages, 0:04:52

Forecasting: Moving Averages, MAD, MSE, MAPE

Operation Management Using 0:10:53

Operation Management Using Excel : Seasonality and Trend Forecasting

Exponential Smoothing Forecasting 0:02:39

Exponential Smoothing Forecasting Using Microsoft Excel

Use Excel to 0:00:22

Use Excel to Forecast.

Operations Management using 0:15:02

Operations Management using Excel: Project Management Video 1/3

Exponential Smoothing Method 0:07:02

Exponential Smoothing Method in Forecasting | Forecasting Techniques - Exponential smoothing method

Naive Forecasting - 0:04:53

Naive Forecasting - Forecasting Methods

Measuring Forecast Error 0:25:27

Measuring Forecast Error in Time Series Forecasting using MSE, MAD, and MAPE techniques

Sales Forecasting in 0:18:01

Sales Forecasting in Excel - 3 Ways!

Комментарии
Автор

So, which method should one use check the accuracy of the forecast? MAD, MAPD or MSE?

fsociety_
Автор

Hej Mustafa, thanks for the video
What to do when the sales demand for a month is "zero", my data set has zero sales at some months. So My MAPD goes into error since ABSDEV is divided by zero.

ronyjoseph
Автор

I hope you will still respond. I want to ask, can this method forecast for all the way 2-3 years ahead?

ValkyrieRnGris