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:

Serotonin

A neurotransmitter involved in many functions, including mood regulation, digestion, and sleep.

Deoxyribonucleic Acid

A molecule that carries the genetic instructions used in the growth, development, functioning, and reproduction of all known living organisms.

Chromosomes

Thread-like structures in cells made of DNA and proteins that carry genetic information.

Behavior Geneticists

Behavior geneticists are scientists who study the role of genetics in human behavior, including how genetic and environmental factors influence individual differences.