1- what moving average or exponential smoothing model would you recommend to forecast demand? clearly show your results using EXCEL and explain your conclusions.

2- what might the economic impact be of over or under forecasting here for this perishable commodity?

United Dairies, Inc. United Dairies, Inc. supplies milk to independent grocers in Collier County, Florida. Milk is perishable so forecast accuracy is critical in predicting the number of gallons of milk sold per month. Sales data in gallons for the past twelve months is shown in the table below. The demand indicates a seasonal pattern because in the winter months (months 1 to 3 and 12) the county's population increases dramatically as people from the northern United States, Canada, and Europe spend their winters there to avoid the harsh weather. IS) The 4-period moving average forecast for period 5= the average of milk gallons from period 1 to period 4 , 2 period Weighted moving average for period 3=(0.4+ milk gallons for period 2)+(0.6 milk gallon =(0.43,480)+(0.63,750)=3,642