Use Excel to create the plot and make Excel do the calculations

Use the following data to calculate the forecasts as indicated below.

Period	Actual sales
1	46
2	55
3	51
4	44
5	49
6

a. Determine forecasts for Period 5 and Period 6 sales volume using each of the following methods:

i. Simple Nave forecast

ii. Four period moving average forecast

iii. A three-period weighted moving average using the following weights:

w_t-1 = .45, w_t-2 = .35, w_t-3 = .20

iv. Exponential smoothing with a smoothing constant of .70, assuming the Period 4 forecast was 48