Question: Complete the forecasting worksheets for: Nave Average Moving Average Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most

Complete the forecasting worksheets for:

Nave

Average

Moving Average

Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05

ExponA using and alpha level of .75

ExponB will automatically be .25 when A is .75

Exponential Solver

What is the best alpha level as determined by the Exponential Solver?

Which is the best forecasting option for MAE? What is the MAE?

Which is the best forecasting option for MAPE? What is the MAPE?

Period

Sales

1

115

2

118

3

128

4

122

5

135

6

128

7

135

8

132

9

132

10

135

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!