Please show how to do in Excel.

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 2021. The materials specialist has accumulated historical inventory data for 2016-2020 presented.

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 2021.

Year	Quarter	Period	Inventory (thousand of cases)
2016	Q1	1	176
	Q2	2	134
	Q3	3	186
	Q4	4	195
2017	Q1	5	189
	Q2	6	157
	Q3	7	195
	Q4	8	211
2018	Q1	9	205
	Q2	10	180
	Q3	11	212
	Q4	12	229
2019	Q1	13	223
	Q2	14	192
	Q3	15	234
	Q4	16	248
2020	Q1	17	239
	Q2	18	217
	Q3	19	271
	Q4	20	284