Question: Month --> 1 2 3 4 5 6 7 8 9 10 11 12 Demand --> 3,456 3,234 4,321 3,332 4,412 4,780 5,121 5,201 4,438
| Month --> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Demand --> | 3,456 | 3,234 | 4,321 | 3,332 | 4,412 | 4,780 | 5,121 | 5,201 | 4,438 | 3,980 | 3,111 | 3,636 | |
| 3 week weighted moving | |||||||||||||
| average (60%, 30% 10%) | |||||||||||||
| starting from most recent --> | |||||||||||||
| 4 week weighted moving | |||||||||||||
| average (40%, 30% 20%) | |||||||||||||
| starting from most recent --> | |||||||||||||
| Using the above demand data, calculate the 3 & 4 month moving weighted moving averages and populate in the yellow boxes 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
