Question: Q1: Given the data below, what is the forecast using a 4-period moving average? Day Actual Demand Forecasted Demand Monday 75 X Tuesday 55 X
| Q1: Given the data below, what is the forecast using a 4-period moving average?
| ||||||||||||||||||||||||||||||||||||||||||||||
|
|
| |||||||||||||||||||||||||||||||||||||||||||||
|
|
|
| Q2: Using the same data from Question 1, what is the forecast for Monday if you use a weighted moving average given the following weights (note: w1 corresponds to the most recent data followed by w2 and so on).
| |||||||||
|
|
| ||||||||
|
|
|
| Question | Q3: Again, using the data from Question 1, calculate the forecast for the coming Monday using the simple exponential smoothing technique. The relevant parameters are: Sunday forecast = 72 alpha = 0.1 |
|
|
|
|
|
|
| What effect on Monday's forecast would increasing the alpha value have? | |
|
| The forecast would remain constant The forecast would increase The forecast would decrease Alpha does not affect the forecast |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help