Question: Given the following weekly demand figures: Week Demand 1 20 2 60 3 30 4 35 5 40 Question 1: Using a 3-week moving average,
Given the following weekly demand figures:
| Week | Demand |
| 1 | 20 |
| 2 | 60 |
| 3 | 30 |
| 4 | 35 |
| 5 | 40 |
Question 1: Using a 3-week moving average, what is your forecast for Week 6?
A) 32.5
B) 35
C) 30
D) 25
Question 2: What is the exponentially smoothed forecast for week 2? Use F1 = 35 and (alpha) = 0.2.
A) 53
B) 32.0
C) 21
D 24
Question 3: Using the following data, what is the mean square error for these forecasts?
| Week | Demand | Forecast |
| 1 | 20 | 33 |
| 2 | 60 | 40 |
| 3 | 30 | 44 |
| 4 | 35 | 39 |
| 5 | 40 | 28 |
A. 254
B. 925
C. 12.6
D. 185
E. 1
Question 4:
The Bakery produces special rolls every day. They have collected sales data for the past week:
| Day | Rolls Sold |
| 1 | 24 |
| 2 | 19 |
| 3 | 30 |
| 4 | 23 |
| 5 | 31 |
Using a simple three-period moving average forecast model, what is the forecast of demand for Week 6?
A. 24.33 units
B. 28.00 units
C. 25.20 units
D. 27.67 units
E. 28.67 units
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
