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. Attendace to ER per day in the last five years Year 1 Year 2 Year 3 Year 4 Year 5 3,500 Saturday 1,235 1,237 1,099 1,088 1 163 Sunday 2,182 2,349 2,651 2,520 2,608 3,000 Monday 2,703 2,599 2,779 2,885 3,004 Tuesday 2,428 2.485 2,531 2,339 2 249 2.500 TOTAL 8,548 8,670 9,060 8,832 9,024 2,000 Seasonal indexes 1,500 Year 1 Year 2 Year 3 Year 4 Year 5 Saturday 0.58 A 0.49 0.49 3.52 1,000 Sunday 1.02 1 08 B 1.14 1.16 Saturday Sunday Monday Tuesday Monday 1,26 1.20 1.23 C 1.33 Year 1 Year 2 Year 3 Year 4 Year 5 Tuesday 1.14 1.15 1.12 1.06 D *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: O If we use a Simple Moving Average (n=2) model to forecast, what will the MAD be? What will the CFE be