SOLVE IT CORRECTLY.........READ QS CAREFULLY AS IT IS VERY BIG

The manager of a company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 weeks: \begin{tabular}{l} V \\ \hline O \\ \hline \end{tabular} I. Compute the weekly demand forecast for 4is week through 11th week using a 3-week moving average. II. Compute the weekly demand forecast for 6th through 11th using a 5 -week moving average. Ill. Compute the weekly demand forecast for 4th through 11th a 3week weighted moving average. Use weights of 0.5,0.3, and 0.2, with the heavier weights on the more recent week. IV. Compute the mean absolute deviation for 6 through 10th for each of the methods used. Which method would you use to forecast demand for 11th ? V. Use exponential smoothing with smoothing parameter = 0.3 to compute the demand forecast for 11th week VI. Use exponential smoothing with smoothing parameter = 0.5 to compute the demand forecast for 11th week. VII. Use trend-adjusted exponential smoothing with smoothing parameter =0.5 and trend parameter =0.3 to compute the demand forecast for 11th week. Compute the mean squared error for each of the methods used