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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!