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

question 41

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 a 3-period moving average to forecast next day's sales.
b.Use a 3-period weighted moving average to forecast next day's sales.Use Solver to determine the optimal weights.
c.Which one of the above forecasting techniques provides a lower MSE?

---

Definitions:

Processing

The act or series of operations performed by a computer or other device on data according to programmed instructions.

Memory Strategies

Techniques used to enhance memory, including methods like visualization, chunking, and the use of mnemonic devices.

Working Memory

A cognitive system with a limited capacity that is responsible for temporarily holding information available for processing.

Selective Attention

The focusing of conscious awareness on a particular stimulus while ignoring others, an important aspect of cognitive processing.