Question: WEEK 1 2 3 4 5 6 7 8 9 10 11 12 Demand 90 80 90 120 90 120 110 70 130 90 110
| WEEK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Demand | 90 | 80 | 90 | 120 | 90 | 120 | 110 | 70 | 130 | 90 | 110 | 100 |
| MA (3) | XXX | XXX | XXX |
|
|
|
|
|
|
|
|
|
| MA (4) | XXX | XXX | XXX | XXX |
|
|
|
|
|
|
|
|
| WMA (3) | XXX | XXX | XXX |
|
|
|
|
|
|
|
|
|
| WMA (4) | XXX | XXX | XXX | XXX |
|
|
|
|
|
|
|
|
1. MA (3) = Moving Average 3 weeks starting week 4, provide the 3 week moving average forecast for weeks 4 12 in the above chart
2. MA (4) = Moving Average 4 weeks starting week 5, provide the 4 week moving average forecast for weeks 5 12 in the above chart
3. WMA (3) = Weighted Moving Average 3 weeks starting week 4, provide the 3 week moving average forecast for weeks 4 12, using 50%, 30% and 20% weighting from most recent to oldest prior weeks, in the above chart
4. WMA (4) = Weighted Moving Average 4 weeks starting week 5, provide the 4 week moving average forecast for weeks 5 12, using 40%, 30%, 20% and 10% weighting from most recent to oldest prior weeks, in the above chart
5. Which forecast do you like best, and why?
Subject: pricing and demand management
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
