DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for customers while they are in transit to local retailers. DistCo can store a maximum of 294,000 cases of products at its present facility. Because their business has been growing, the companys management wonders if they should acquire other warehouses in 2019. The materials specialist has accumulated historical inventory data for 2014-2018 presented in HW4_dataset.xlsx.

1. Utilize Excel to identify the best forecast based on MAD and MAPE. Create a table with forecasting results . Apply the best forecast to estimate inventory in 4 quarters of 2019.

2. Answer the question of the case study: should DistCo acquire more warehouse capacity in 2019 (Hint: will the forecasted number of cases in the 4^th quarter of 2019 be close to or greater than 290,000cases)?
4. 

Period Year 2014 Quarter Q1 Q2 Q3 Q4 Q1 2015 Q2 2016 Q4 Q1 Q2 Q3 Inventory (thousand of cases) 176 134 186 195 189 157 195 211 205 180 212 229 223 192 234 248 239 217 271 284 Q4 Q1 2017 Q2 Q3 Q4 2018 Q1 Q2 Q3 Q4 Period Year 2014 Quarter Q1 Q2 Q3 Q4 Q1 2015 Q2 2016 Q4 Q1 Q2 Q3 Inventory (thousand of cases) 176 134 186 195 189 157 195 211 205 180 212 229 223 192 234 248 239 217 271 284 Q4 Q1 2017 Q2 Q3 Q4 2018 Q1 Q2 Q3 Q4