. Round all forecasts and your Accuracy measures to one decimal place. Excel formulas must be used for all calculations

NOTE: You will fill in the only the cells in grey. Use formulas for each calculation otherwise you will NOT be graded on those answers. 0 In a few sentences, explain what insights can we learn from tracking the MAD/MSE/MAPE over a prolonged period of time? 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