Question

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 actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 57 (7) 64 (8) 58 (9) 68 (10) 66 (11) 72 (12) 75

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

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

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

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

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

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

Using ? = 0.5 and the following data, compute exponential
smoothing forecasts for periods 2 through 8. (Round your
intermediate calculations and final answers to 2 decimal places.)
Period: 1 2 3 4 5 6 7 Forecast: 10 Actual demand: 12 15 11 13 11 11
10

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 8 minutes ago

asked 8 minutes ago

asked 22 minutes ago

asked 24 minutes ago

asked 30 minutes ago

asked 33 minutes ago

asked 41 minutes ago

asked 42 minutes ago

asked 50 minutes ago

asked 50 minutes ago

asked 50 minutes ago