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

question 37

Essay

Use this information to answer the following questions.
The following data,provided by the U.S.Bureau of Citizenship and Immigration Services,represent the number of immigrants admitted to the United States,in thousands,from 1990-2001.
$$\begin{array} { | c | c | } \hline \text { Year } & \begin{array} { c } \text { No. of Immigrants } \\\text { (in 000s) }\end{array} \\\hline 1990 & 1536 \\\hline 1991 & 1827 \\\hline 1992 & 974 \\\hline 1993 & 904 \\\hline 1994 & 804 \\\hline 1995 & 720 \\\hline 1996 & 916 \\\hline 1997 & 798 \\\hline 1998 & 654 \\\hline 1999 & 647 \\\hline 2000 & 850 \\\hline 2001 & 1064 \\\hline\end{array}$$
-Refer to the table above.Using Solver to find the optimal alpha that minimizes MAD,use exponential smoothing to forecast the number of immigrants in 2002.

---

Definitions:

Aging Method

An accounting technique used to estimate the amount of bad debt expense by classifying accounts receivable according to their age.

Credit Sales

Transactions where the buyer is allowed to pay for goods or services at a later date, rather than at the time of purchase.

Interest Rate

A cost, depicted as a percent of the original amount, that a lender demands from a borrower for the right to use resources.

Stated Rate

The interest rate declared on a financial instrument, such as a bond or a loan, which is fixed and does not change over the life of the instrument.