Solve these on excel for me

Problem $1.$ 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.

$1.$ Compute $3$ and $4-$period moving averages for the time series. $1$ pt

$2.$ Use smoothing constant $\backslash (\backslash$alpha $\backslash )$ of $0\mathrm{.}3$ to calculate forecasts for months $2$ to $12$ using exponential smoothing, assuming that the value of forecast for the first month was $3,750$ gallons. $1$ pt $3.$ What model, $4$ period$-$moving average or exponential smoothing model, would you recommend to forecast demand when comparing their MSE? Is there any difference when you calculate their MAD? Clearly show your results in excel and explain your conclusions. $2$ pts

$4.$ What might the economic impact be of over or under$-$forecasting here for this perishable commodity? $1$pt

Problem $2.$ Inventory at Nautique Boat Company: Please watch the video case at the end of Chapter $12,$ Inventory at Nautique Boat Company $($p$\mathrm{.}564),$ and review the text and data table $12\mathrm{.}4,$ Sample of Nautique's Inventory Items, following the video. Answer the following four questions:

$1.$ Conduct in Excel an ABC analysis on the $20$ SKUs $($stock keeping units$)$ listed in Table $12\mathrm{.}4.2$ pts I recommend reading Chapter $11$ before answering Questions $2,3,$ and $4$ of Problem $2.$

$2.$ Why would Nautique use vendor$-$managed inventory for some of its SKUs? $1$ pts

$3.$ Should Nautique consider vertically integrating suppliers of the top annual dollar volume inventory items? What are the advantages and disadvantages of this decision? $($For example, Nautique's parent company has purchased Performance Custom Marine $($PCM$)$ engines. $1$ pts

$4.$How could Nautique reduce the number of SKUs it manages? $1$ pts