Calculate Three Forecasts Using the Following Data $\mathrm { F } _ { 3 }$

question 68

Essay

Calculate three forecasts using the following data.First,for periods 4 through 11,develop the exponentially smoothed forecasts using a forecast for period 3 ( $\mathrm { F } _ { 3 }$ )of 120.0 and an alpha of 0.3.Second,calculate the 3-period moving average forecast for periods 4 through 11.Third,calculate the weighted moving average for periods 4 through 11,using weights of .60,.30,and .10.Calculate the mean absolute deviation (MAD)and the cumulative sum of forecast error (CFE)for each forecasting procedure.Which forecasting procedure would you select? Why?
$$\begin{array} { | c | c | } \hline \text { Month } & \text { Demand } \\\hline 1 & 120 \\2 & 115 \\3 & 125 \\4 & 119 \\5 & 127 \\6 & 114 \\7 & 120 \\8 & 124 \\9 & 116 \\10 & 137 \\\hline\end{array}$$

---

Definitions:

Intangible

Refers to something that cannot be touched or physically measured, often associated with non-physical assets such as patents, trademarks, and goodwill.

Intermediation Revenue Model

A business model that generates income by serving as an intermediary in transactions between two or more parties.

Brokers

The people who organize transactions between buyers and sellers.

Money

A medium of exchange in the form of coins and banknotes; used to purchase goods and services or measure value and wealth.