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

question 52

Essay

Use this information to answer the following questions.
A hot dog stand owner has collected the following time series data on the number of hot dogs sold over the last 12 quarters.
$$\begin{array} { | c | c | c | } \hline \text { Year } & \text { Quarter } & \text { Demand } \\\hline 1 & \text { Winter } & 29 \\\hline 1 & \text { Spring } & 65 \\\hline 1 & \text { Summer } & 56 \\\hline 1 & \text { Fall } & 45 \\\hline 2 & \text { Winter } & 23 \\\hline 2 & \text { Spring } & 57 \\\hline 2 & \text { Summer } & 48 \\\hline 2 & \text { Fall } & 32 \\\hline 3 & \text { Winter } & 14 \\\hline 3 & \text { Spring } & 55 \\\hline 3 & \text { Summer } & 52 \\\hline 3 & \text { Fall } & 25 \\\hline\end{array}$$
-Refer to the table above.Forecast next quarterly sales using a 3-period weighted moving average.Use Solver to determine the optimal weights that minimize MSE.

---

Definitions:

Depression

A mental health disorder characterized by persistently depressed mood or loss of interest in activities, causing significant impairment in daily life.

Passive

Involves not actively participating or engaging in an action or process, often implying a lack of response or initiative.

Post-Traumatic Stress Disorder

A mental health condition triggered by experiencing or witnessing a traumatic event, characterized by flashbacks, nightmares, and severe anxiety.

Generalized Anxiety Disorder

A mental health condition characterized by persistent and excessive worry about various aspects of life.