Problem 5 (20 Points) The ChatCamp Outdoor Company is a catalog sales operation that specializes in outdoor recreational clothing. Demand for its items is very seasonal, peaking during the Christmas season and during the spring. It has accumulated the following data for orders per season (quarter) during the past 5 years: \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{ Quarter } & \multicolumn{5}{|c|}{ Orders (1,000s) Year } & \multirow{2}{*}{\begin{tabular}{c} Average \\ Demad per \\ Quarter \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Seasonal \\ Index \end{tabular}} \\ \hline & 1 & 2 & 3 & 4 & 5 & & \\ \hline Jan-Mar & 27.50 & 28.50 & 37.50 & 42.50 & 49.50 & & \\ \hline Apt -Jun & 26.75 & 31.75 & 34.75 & 42.75 & 44.75 & & \\ \hline Jul.Sep & 29.00 & 32.00 & 41.00 & 44.00 & 48.00 & & \\ \hline Oct-Dec & 27.25 & 32.25 & 42.25 & 47.25 & 53.25 & & \\ \hline \end{tabular} a. Calculate the overall average demad. b. Calculate the average demad per quarter in the space given in the above table. c. Calculate the seasonal index in the space given in the above table. d. Develop a linear trend line (simple linear tegression line) forecast for each of the four seasons season for year 6. (Create a separate table as we did in the Chapter 15 Assessment, then find the intercept and the slope of the trend line.) Draw a time-series plot with original data and the tread line. Calculate he Mean Squared Errot (MSE) for the trend-line-only fore MSE Projection for quarters 1 through 4 of year 6 using trend and seasonal index. (Treod Seasonal Index)