SCENARIO 16-15-B
You Are the CEO of a Diary Company

question 33

Short Answer

SCENARIO 16-15-B
You are the CEO of a diary company. The total milk production (in gallons) from your company
over the past 30 years are presented below and also contained in the Excel file SCENARIO 16-
15-B.XLSX. $$\begin{array} { l r r r r r r r r r r r } \text { Year } & 1986 & 1987 & 1988 & 1989 & 1990 & 1991 & 1992 & 1993 & 1994 & 1995 \\& 1996 & 1997 & 1998 & 1999 & 2000 & 2001 & 2002 & 2003 & 2004 & 2005 \\& 2006 & 2007 & 2008 & 2009 & 2010 & 2011 & 2012 & 2013 & 2014 & 2015 \\\text { Milk } & 150201 & 193718 & 212520 & 214553 & 237507 & 248069 & 241824 & 234627 & 252049 & 252029 \\\text { Prod } & & & & & & & & & \\& 263449 & 260689 & 247900 & 260059 & 268197 & 249477 & 246216 & 265236 & 256364 & 241705 \\& 245932 & 243529 & 241551 & 247697 & 248454 & 241974 & 235823 & 243517 & 238490 & 248606\end{array}$$ You want to predict your company's future total milk production using the linear trend, quadratic
trend, exponential trend, first-order autoregressive, second-order autoregressive and third-order
autoregressive model.
-Referring to Scenario 16-15-B, if a five-year moving average is used to smooth this series,
what would be the moving average for 1988?

---

Definitions:

Mission

The fundamental purpose or goal of an organization, often described in a mission statement.

Tactical Plans

Short-term strategies designed to implement specific aspects of a larger strategic plan.

Strategic Plans

Formalized plans developed by organizations to outline their long-term goals and the strategies they will use to achieve them, guiding decision-making and resource allocation.

Strategic Plans

Long-term roadmaps designed by organizations to guide their overall efforts and achieve specific goals and objectives.