This is all that is provided for the question

MGTS352 Formative Assignment 2 ER Visits A regional hospital is interested in learning more about the pattern of visits to the ER. They have special interest on the first four days. They want to have all the required resources getting ready for the next year. They decided to use the multiplicative seasonality model to do a forecast of the visits for the next year. The data of these visit is shown below. *note - for the following questions, you can use Excel or you can solve manually. It is important that, either way, you understand the manual calculation and the meaning of the numbers and results. 1. Calculate a missing value (A, B, C, or D) in the table, and describe what it means, in your own words (e.g., It is the seasonal factor for..., and the result of ... means that...). Forecasting Understanding Questions 2. We are using a Moving Average Forecast with n=4 and know that F10=50,D10=52, and F11= 51. Find D6. 3. Consider a case where demand increases by 10 units each period like shown in the picture below: If we use a Simple Moving Average (n=2) model to forecast, what will the MAD be? What will the CFE be