Use This Information to Answer the Following Questions -Refer to the Table Above

question 48

Essay

Use this information to answer the following questions.
Joe Smith operates an ice cream shop and works only three days a week.The number of ice cream cones that he sells is shown as follows.
$$\begin{array} { | l | c | c | c | c | c | } \hline \text { Friday } & 100 & 114 & 110 & 115 & 112 \\\hline \text { Saturday } & 130 & 135 & 140 & 145 & 142 \\\hline \text { Suraday } & 60 & 65 & 55 & 50 & 63 \\\hline\end{array}$$
-Refer to the table above.
a.Use exponential smoothing with an alpha value of 0.5 to forecast next day's sales.
b.Use Solver to determine the optimal alpha value that minimizes MSE.Forecast next day's sales using this optimal alpha value.

---

Definitions:

James II

King of England, Scotland (as James VII), and Ireland from 1685 until he was deposed in 1688, known for his attempts to re-establish Catholicism in Britain.

William and Mary

The monarchs of England, Scotland, and Ireland from 1689 to 1694, who came to power during the Glorious Revolution and jointly ruled as king and queen.

Amsterdam

The capital city of the Netherlands, known for its historic canals, art museums, and as a major hub of finance and culture.

Catholic Reformation

A period of Catholic revival and reformation in the 16th century, partly in response to the Protestant Reformation, aiming to reform the Church from within.