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

  1. 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?

  1. 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)?

  1. Calculate MAD for both methods by using weeks 4 through 6 data. Which method is more accurate?

Please show all work. Week 1 2 3 4 5 6 Sales ($)

Please show all work. 2 3 5 6 Week Sales (5) 1 16 18 14 10 20 22 1. 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? 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)? 3. 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 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!