Question: Given the attached data. Answer the following questions using an initial alpha value of 0.2. 1. Compute your forecast for period 51. The potential answers

Given the attached data. Answer the following questions using an initial alpha value of 0.2.

1. Compute your forecast for period 51.

The potential answers are:

A: 5901.35 units.

B: 5663.93 units.

C: 6462.49 units.

D: 7204.02 units.

E: 10407.5 units.

2. Compute the MAD value for period 50.

The potential answers are:

A: 3523.23 units.

B: 2127.42 units.

C: 3292.58 units.

D: 4026.28 units.

E: 4811.36 units.

3. Compute standard deviation of forecast for period 51.

The potential answers are:

A: 2659.28 units.

B: 3404.66 units.

C: 4115.73 units.

D: 5032.85 units.

E: 6014.2 units.

4. Compute the best alpha value to three decimal points.

The potential answers are:

A: 0.001.

B: 0.217.

C: 0.068.

D: 0.261.

E: 0.185.

(Excel attached data below)

t At
1 1592
2 5478
3 5555
4 7672
5 5309
6 6409
7 8722
8 5285
9 3773
10 3800
11 9565
12 3904
13 4229
14 3798
15 7997
16 2352
17 7059
18 5040
19 4440
20 3864
21 7228
22 4681
23 5951
24 5561
25 7538
26 3407
27 9060
28 5079
29 9079
30 2240
31 2066
32 6838
33 8252
34 6069
35 1791
36 3169
37 4269
38 3040
39 4067
40 3032
41 5004
42 5953
43 8731
44 5218
45 8368
46 10285
47 3430
48 6658
49 8713
50 2538

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!