Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing. A B C D E F 1 Number of Exp Smoothing 2 Time Period Cars Sold Prediction 3 1 70 70.00 alpha 0.346 4 2 80 70.00 5 3 66 73.46 6 4 74 70.88 7 5 64 71.96 8 6 76 69.20 9 7 72 71.56 10 8 82 71.71 11 9 82 75.27 12 10 76 77.60 13 11 84 77.05 14 12 80 79.45 15 16 MSE 39.79 Refer to Exhibit 11.3. Assume the forecasted value for month 13 is 79.64. What is the forecasted value for month 16? a. 83.64. b. 79.64. c. 82.00. d. 85.54

Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing. A B C D E F 1...

Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing.

	A	B	C	D	E	F
1		Number of	Exp Smoothing
2	Time Period	Cars Sold	Prediction
3	1	70	70.00		alpha	0.346
4	2	80	70.00
5	3	66	73.46
6	4	74	70.88
7	5	64	71.96
8	6	76	69.20
9	7	72	71.56
10	8	82	71.71
11	9	82	75.27
12	10	76	77.60
13	11	84	77.05
14	12	80	79.45
15
16		MSE	39.79

Refer to Exhibit 11.3. Assume the forecasted value for month 13 is 79.64. What is the forecasted value for month 16?

a. 83.64.

b. 79.64.

c. 82.00.

d. 85.54

Jun 09, 2022

SOLUTION.PDF

Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing. A B C D E F 1...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment