Forecasting Formulas

# Forecasting Formulas - Moving Average This worksheet has...

This preview shows pages 1–4. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Moving Average This worksheet has been set up to show moving average calculations for 3 periods. This is a protected worksheet. Only the values of the demand can be changed to try diff Weighted Moving Average This worksheet has been set up to show weighted moving average calculations for 3 pe This is a protected worksheet. Only the values of the demand and the weights can be ch Exponential Smoothing This worksheet has been set up to show calculations for exponential smoothing metho This is a protected worksheet. Only the values of the demand and alpha ( ) can be cha α Error Analysis The error analysis spreadsheet has been set up to show the effect of changing the valu The graph shows the variability of forecast for different values of alpha( ). α The effect of changing the value of alpha ( ) on MAD and MSE can also be studied. α MAD: Mean Absolute Deviation MSE: Mean Squared Error Trend Analysis In trend analysis, the time period is used as the independent variable (x). The worksheet has been set up to take up to 10 data values. The values of the slope (b) and intercept (a) may be calculated either by using Excel's b This is a protected worksheet. Only the values of the independent variable can be chan Forecast can be made by entering the value of x (X) for which the forecast is to be mad Regression Analysis In regression analysis, the paired values of the independent (x) and dependent (y) varia The worksheet has been set up to take up to 10 values of the paired data. The values of the slope (b) and intercept (a) may be calculated either by using Excel's b It may be noted that capital X is being used as the value of x for which the forecast is t as a symbol to give the forecasted value. This is a protected worksheet. Only the values of the paired-data can be changed to try Forecast can be made by entering the value of the independent variable (X) for which th Seasonality This spreadsheet shows the calculations for seasonal forecasting. The worksheet uses two years data. Each year is divided into four quarters. Step 1: Find Average Demand for each quarter. Step 2: Compute Seasonal Index (SI). Step 3: Calculate the Average SI for each season. Step 4: Forecast demand for next year and calculate the average demand for each quar Step 5: Seasonal forecats is obtained by multiplying the avearge demand by SI for each It may be noted that capital X is being used as the value of x for which the forecast is t as a symbol to give the forecasted value. fferent problems. eriods. hanged to try different problems. d. anged to try different problems. lues of ( ). α built-in functions or by using statistical formulas. ged to try different problems. de. ables are to be used....
View Full Document

{[ snackBarMessage ]}

### Page1 / 38

Forecasting Formulas - Moving Average This worksheet has...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online