Please see below the assigned questions for this chapter. Please answer the questions and show all work $($if applicable$).$ You are welcome to use Excel to complete the assignment $($if needed$)$

$1.$ Myron Sheu, the owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table:

Year Demand $($Pounds$)$

$168,800$

$271,000$

$375,500$

$471,200$

Forecast demand for Year $5$ using the following approaches: $($a$)$ a three$-$year moving average; $($b$)$ a three$-$year weighted moving average using $\mathrm{.}40$ for Year $4,\mathrm{.}20$ for Year $3,$ and $\mathrm{.}40$ for Year $2$; $($c$)$ exponential smoothing with $\backslash$alpha $=\mathrm{.}30,$ and assuming the forecast for Year $1=68,000.$

$2.$ Monthly demand for Accugolf$$s top rated golf balls in dozens for the last $12$ months are shown below.

Month Demand Month Demand

January $5,500$ July $7,500$

February $5,700$ August $7,200$

March $6,000$ September $6,800$

April $5,800$ October $6,300$

May $6,300$ November $6,000$

June $7,000$ December $5,800$

a$.$ Develop a simple regression model for sales of golf balls.

b$.$ What is the forecast for sales of golf balls in January of the following year?