Question

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) 52 (3) 48 (4) 59 (5) 55 (6) 57 (7) 64 (8) 63 (9) 72 (10) 66 (11) 73 (12) 73

**1. Using a 5 period simple moving average, the forecast
for period 13 will be:**

**2. Using the 4 period weighted moving average, the
forecast for period 13 will be:**

**3. With exponential smoothing, the forecast for period
13 will be:**

**4. With linear regression, the forecast for period 13
will be:**

**5. With quadratic regression, the forecast for period 13
will be:**

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

Answer #1

1. Enter data in EXCEL-Data-Data Analysis-Moving average-enter range in the Input range (A1:A12)-type 5 in Interval-type C1 as output range. Click OK. The forecast for period 13 is 67.2.

2. Using the weighetd moving average, type theweights in cell E1, E2, E3, and E4 respectively. For forecast of period 13, type formula: =SUMPRODUCT(A9:A12, E1:E4). result is:67.773.

3. Using Exponential smoothing, select Exponential smoothing from Data Analysis-select input range (A1:A12)-enter Dumping factor-0.23-input output range G1-click OK.

The forecast for period 13 is 68.30617

4. Using regression [Data analysis-Regression-select Input X range (periods), and Y range (actual values)-type output range, I1-click OK.

Value=44.439+2.343 Period

Substitute Period with 13 and compute predicted value: 74.898.

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

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

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

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

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

For the data given below, forecast period 17 using following
methods and suggest the best forecasting model
1. Simple Moving Average (Three Period)
2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3)
3. Exponential Smoothing (α=.1), F1= y intercept from
regression)
4. Exponential Smoothing (α=.3), F1= y intercept from
regression)
5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y
intercept from regression)**
5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y
intercept from regression)**
6....

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 10 minutes ago

asked 12 minutes ago

asked 15 minutes ago

asked 17 minutes ago

asked 39 minutes ago

asked 39 minutes ago

asked 41 minutes ago

asked 50 minutes ago

asked 50 minutes ago

asked 54 minutes ago

asked 55 minutes ago