Boondocks in Phoenix, Arizona, is one of the biggest water amusement parks in the country.

The park has numerous water slides and a variety of other water related play areas for children

and adults. While people are at the park, they buy food and drinks. In order for the catering

manager at Boondocks to determine how much food to have on hand, she needs a forecast of

the number of people who will be at the park each week. Attendance data for the past $16$

weeks are shown at $$Boondocks$$ worksheet.

a$)$ Develop an exponential smoothing model to predict the attendance in week $17.$ Please

decide the smoothing constant to minimize MSE based on a Non$-$linear optimization

model. What is the prediction for week $17?$ Use the actual attendance in week $1$ for the

$$forecast$$ of week $1.$

b$)$ Develop a forecast for Week $17$ using a simple $3-$week moving average.

c$)$ Which one of the above forecasts would you recommend based on MSE, and why? Week Attendance

$114560$

$218655$

$315987$

$413689$

$515332$

$616345$

$717456$

$816334$

$914745$

$1016778$

$1119456$

$1215789$

$1315602$

$1414556$

$1516344$

$1615617$

$17$

Please walk me through excel step by step and when you get to the solver in excel explain what the referenced cells and constraint are also di I use simple lp solver basically your dealing with a lost person so please I need your help Basically I need to see an excel file this not for a test or an exam its to see visually how things go step by step dont just right go through it with me How do I in solver Add a constraint to ensure $0<=$ E$1<=1$ because the smoothing constant must be between $0$ and $1.$ so under referenced tab what do I do and under contraint tab what do I do