Please help with ONLY question 6,7 and 8 with excel only and using excel formulas only.Round all forecasts and your Accuracy measures to one decimal place

Insert answer here: Q4. In a brief sentence, explain 1 disadvantage of using the simple moving average over the weighted moving average. Insert answer here: Q5. Insert answer here: Q6. Determine the forecasted demand based on a 3 point simple moving average for weeks 4-10. NOTE: You will fill in the only the cells in grey. \begin{tabular}{|c|c|c|} \hline Week & Actual Demand & 3 Period \\ \hline 1 & 789 & \multirow{}{*}{} \\ \hline 2 & 872 & \\ \hline 3 & 983 & \\ \hline 4 & 382 & \\ \hline 5 & 661 & \\ \hline \end{tabular} What is the Nave forecast for period 5 based on the table below? NOTE: You will fill in the only the cell in grey. The Actual demand for Snow boards from a large GTA retail chain is shown below for 2022. Calculate the Seasonal Index (factor) for last year for each of the four seasons. Use the seasonal Index (factor) to calculate the demand for each of the seasons for 2023 ( Table \#2) based on a new ANNUAL demand of 12,000 snowboards. NOTE: You will fill in the only the cells in grey