please watch the video to know how to answer the question : https://file.io/6jpJR4YHWEA2 the answer should be in Excel using solver method, and partial written solutions too Sheet 1: Assignment 5 S

please watch the video to know how to answer the question :  https://file.io/6jpJR4YHWEA2 

the answer should be in Excel using solver method, and partial written solutions too 

Sheet 1: Assignment 5

Source of the data: https://www.goodcarbadcar.net/toyota-camry-sales-figures/Part AForecast the monthly demand for Year 2024 using the static method for forecasting. Evaluate the error. Evaluate the quality of the forecast. 

Part BForecast the monthly demand for Year 2024 using moving average, simple exponential smoothing and Holt’s model. In each case, evaluate the MAD and MAPE. Which forecasting method do you prefer? Why?