3. Utilize Excel to identify the best forecasting model among the four models discussed in question 2 based on MAE and MAPE. Create a table with forecast accuracy measures MAE and MAPE for each of the four forecasting models. Apply the best forecasting model to forecast inventory in all 4 quarters of 2020. (2+2 +2 +2 +4 = 12 points) 4. Answer the question from the case study: should DistCo acquire more warehouse capacity in 2020? (Hint: will the forecasted number of cases in the 4th quarter of 2020 be close to or greater than 292,000-294,000 cases) (8 points) D52 A Inventory (thousand 1 Year Quarter Period of cases) 2 2015 Q1 1 176 3 Q2 2 134 4 Q3 3 186 5 Q4 4 195 6 2016 Q1 5 189 7 Q2 6 157 8 Q3 7 195 9 Q4 8 211 10 2017 Q1 9 205 11 Q2 10 180 12 Q3 11 212 13 Q4 12 229 14 2018 Q1 13 223 15 Q2 14 192 16 Q3 15 234 17 Q4 16 248 18 2019 Q1 17 239 19 Q2 18 217 20 Q3 19 271 21 Q4 20 284 3. Utilize Excel to identify the best forecasting model among the four models discussed in question 2 based on MAE and MAPE. Create a table with forecast accuracy measures MAE and MAPE for each of the four forecasting models. Apply the best forecasting model to forecast inventory in all 4 quarters of 2020. (2+2 +2 +2 +4 = 12 points) 4. Answer the question from the case study: should DistCo acquire more warehouse capacity in 2020? (Hint: will the forecasted number of cases in the 4th quarter of 2020 be close to or greater than 292,000-294,000 cases) (8 points) D52 A Inventory (thousand 1 Year Quarter Period of cases) 2 2015 Q1 1 176 3 Q2 2 134 4 Q3 3 186 5 Q4 4 195 6 2016 Q1 5 189 7 Q2 6 157 8 Q3 7 195 9 Q4 8 211 10 2017 Q1 9 205 11 Q2 10 180 12 Q3 11 212 13 Q4 12 229 14 2018 Q1 13 223 15 Q2 14 192 16 Q3 15 234 17 Q4 16 248 18 2019 Q1 17 239 19 Q2 18 217 20 Q3 19 271 21 Q4 20 284