As a first step in the teams decision making, they want to forecast quarterly demand for each of the two types of containers for the years 6 to 8. Based on historical trends, demand is expected to continue to grow until year 8, after which it is expected to plateau. Jilly must select the appropriate forecasting method and estimate the likely forecast error.

1. Use the static method to forecast demand for years 6 to 8. (PLEASE ANSWER USING EXCEL, A SCREENSHOT OF YOUR EXCEL IS PREFERRED)

\begin{tabular}{|cccc|} \hline year & Quarter & Black Plastic Demand(1000lb) & Clear Plastic Demand(1000lb) \\ \hline 1 & I & 1625 & 2100 \\ \hline & II & 1368.5 & 4329 \\ \hline & III & 1706 & 2710 \\ \hline & IV & 4134.5 & 1692 \\ \hline 2 & I & 2257 & 2327 \\ \hline & II & 1571.5 & 4840 \\ \hline & III & 2229.5 & 3347.5 \\ \hline & IV & 4028 & 1476.5 \\ \hline 3 & I & 2560 & 2871 \\ \hline & II & 1883 & 7336.5 \\ \hline & III & 1778 & 3820 \\ \hline & IV & 4626.5 & 1868.5 \\ \hline 4 & I & 3245.5 & 2243 \\ \hline & II & 2691 & 7093 \\ \hline & III & 2657.5 & 3224 \\ \hline & IV & 6517.5 & 2242.5 \\ \hline 5 & I & 3324 & 4364 \\ \hline & II & 2348 & 8795.5 \\ \hline & III & 2921.5 & 4618 \\ \hline & IV & 7048.5 & 2158 \\ \hline \end{tabular}