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

question 222

Short Answer

SCENARIO 16-15-A
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-A.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 & 172719 & 171357 & 157121 & 155727 & 152974 & 153443 & 158548 & 162614 & 164210 \\\text { Prod } & & & & & & & & & \\& 159127 & 153866 & 165992 & 177843 & 167477 & 163821 & 161700 & 170348 & 174105 & 185103 \\& 184670 & 173385 & 159695 & 173641 & 165706 & 171164 & 168706 & 150684 & 179314 & 163802\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-A, what is the exponentially smoothed value for 1986 using a
smoothing coefficient of W = 0.5?

Understand how changes in income affect demand for different types of goods.

Understand the relationship between quantity demanded and quantity supplied and how it affects market equilibrium.

Identify the factors that cause shifts in demand and supply.

Analyze the impact of technological advances on supply.

---

Definitions:

Tax Revenues

Tax revenues are the income that governments collect from individuals, corporations, sales, and other sources, used to fund public services and operations.

Tax Increases

Government actions that raise the amount of taxes levied on individuals, businesses, or transactions, affecting income, purchasing power, and investment.

Price Elasticity

A measure of how much the quantity demanded of a good responds to a change in the price of that good, indicating the sensitivity of consumers to price changes.

Economic Well-being

The state in which individuals or societies can satisfy their needs and desires, often measured by income, employment, and access to resources.