Question

Instructions |
The Data contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods. |
---|

**Data**

The actual values for 12 periods (shown in order) are:

(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 58 (9) 67 (10) 66 (11) 70 (12) 76

**Questions**

a) Using a 5 period simple moving average, the forecast for period 13 will be:

b) Using the 4 period weighted moving average, the forecast for period 13 will be:

c) With exponential smoothing, the forecast for period 13 will be:

d) With linear regression, the forecast for period 13 will be:

e) With quadratic regression, the forecast for period 13 will be:

f) Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Answer #1

Instructions
The Data contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods. Round all numerical answers to two...

The actual values for 12 periods (listed in order, 1-12). In
Excel, create forecasts for periods 6-13 using each of the
following methods: 5 period simple moving average; 4 period
weighted moving average (0.63, 0.26, 0.08, 0.03); exponential
smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear
regression with the equation based on all 12 periods; and quadratic
regression with the equation based on all 12
periods. Round all numerical answers to two
decimal places.
A. The...

Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12 periods.
Round all numerical answers to two...

Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods. Round all numerical answers to two
decimal...

In Excel, create forecasts for periods 6-13 using each of the
following methods: 5 period simple moving average; 4 period
weighted moving average (0.63, 0.26, 0.08, 0.03); exponential
smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear
regression with the equation based on all 12 periods; and quadratic
regression with the equation based on all 12
periods. Round all numerical answers to two
decimal places.
The actual values for 12 periods (shown in order) are:
(1) 45 (2)...

Can you please answer number 6! Its the only one i need
thanks!!!
The actual values for 12 periods (shown in order) are:
(1) 45 (2) 52 (3) 48 (4) 59 (5)
55 (6) 55 (7) 64 (8)
58 (9) 73 (10) 66 (11)
69 (12) 74
Using a 5 period simple moving average, the forecast for period
13 will be:
QUESTION 2
Using the 4 period weighted moving average, the forecast for
period 13 will be:
QUESTION 3
With exponential smoothing, the forecast for period 13 will
be:...

In Excel, create a forecast for periods 6-13 using the following
method:
Quadratic regression with the equation based on all 12
periods.
With quadratic regression, the forecast for period 13 will be:
_____
Period
Data
1
45
2
52
3
48
4
59
5
55
6
55
7
64
8
58
9
73
10
66
11
69
12
74

In Excel, create a forecast for periods 6-13 using the following
method:
4 period weighted moving average. Weights: (0.63, 0.26, 0.08,
0.03)
Using the 4 period weighted moving average, the forecast for
period 13 will be:
Period
Data
1
45
2
52
3
48
4
59
5
55
6
55
7
64
8
58
9
73
10
66
11
69
12
74

Consider the following time series data.
Week
1
2
3
4
5
6
Value
19
12
16
11
18
13
(b)
Develop the three-week moving average forecasts for this time
series. (Round your answers to two decimal places.)
Week
Time Series
Value
Forecast
1
19
2
12
3
16
4
11
5
18
6
13
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(c)
Use α = 0.2 to compute...

The CEO requested forecasts based on the given historical
data. Put your final answers in the table.
Round answers to 3 decimals for each method. Show work for full
credit.
Period
Actual Demand
3 Month Moving Average
Moving Average Tracking Signal
3 Month Weighted Average
Weighted Average Tracking Signal
1
62
X
X
X
X
2
59
X
X
X
X
3
48
X
X
X
X
4
57
56.33
59.4
5
60
54.66
54.4
6
56
55
52.83
MAD
X...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 9 minutes ago

asked 38 minutes ago

asked 44 minutes ago

asked 47 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago