a. Use the Mocing Aernege Eurel template to develop thiroe- and foar-period mening ancrage forceasts, and comperte MSE for eacla. Which prowides the better forcas? what would he your forceast for work II? b. Use the Eqponential Smoothing Eucl ternpilate to devetop an expoocatial suocellaing fonceat using the smosthing constaent value deternatined by Equation 96. c. Cocmpute the traclang sigaid for a three- and four-period maning anvrage axolit cen a specal. shoct. Is there any cridence of lins? duction of a competerized erpoential smoothing system, claiming that their judgrevental forvensts ane much better than any compinter could din. Their past rocood of prodictions is as follows: Thow data ane wailable in the Fucel workshect C9 Fucel P4s in Miraltap. Compare the manuger's juxlgrocatal forecaids to thrse cobtained ming time series moulek. Are the managor's jalgoncutal forcessts performing satisfactority? (Use appropinite Fivel tereplates and onergnte errur metrics for the manager is forecists ce a specarblicet) United Dairies, Inc. cers in Collier Cosinty. Flonda. Mblk is peristahliet so forecist accuracy is critical in predicting the number of gallons of milk sold per month. Sales data is gallons for the past twelve months is shown in Exhibit 9.17 (these data ane avalable in the workdaret Crited Doiries Case Date in MindTlap). The demand indicates a seasonal puttern because in the winter months (months 1 to 3 ard 12 ) the popolation of the county increases iframatically as people from the morthem Unitud States, Carnhla, and Eurupe spend their winten thene to novil the lanh weuther. Case Questions for Discussion: 1. What moowing inemge or exponential smoothing model wonlid you necommend to forecist demand? Chatly ahen your rosults and eyplais your conctucons: 2. What inight the exonomic impuct be of over or under frorocanting here for this perishahk commodity