Question: Please show all work. Week 1 2 3 4 5 6 Sales ($) 16 18 14 10 20 22 Based on actual data provided above,
Please show all work.
| Week | 1 | 2 | 3 | 4 | 5 | 6 |
| Sales ($) | 16 | 18 | 14 | 10 | 20 | 22 |
- Based on actual data provided above, what are the sales forecast values for weeks 4 through 6, using the simple moving average with averaging period = 2?
|
|
- Based on actual data provided above, what are sales forecast values for weeks 4 through 6, using the weighted moving average method with weights of 0.5 (most recent), 0.4, and, 0.1 (oldest)?
|
|
- Calculate MAD for both methods by using weeks 4 through 6 data. Which method is more accurate?

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
