Question: Western Provincials Savings and Loan is proud of its long tradition in Winter Park, Florida. Begun by Michelle Western Provincial 22 years after World War

Western Provincial’s Savings and Loan is proud of its long tradition in Winter Park, Florida. Begun by Michelle Western Provincial 22 years after World War II, the S& L has bucked the trend of financial and liquidity problems that has repeatedly plagued the industry. Deposits have increased slowly but surely over the years, despite recessions in 1983, 1988, 1991, 2001, and 2010. Ms. Western Provincial believes it is necessary to have a long- range strategic plan for her firm, including a 1- year forecast and preferably even a 5- year forecast of deposits. She examines the past deposit data and also peruses Florida€™s gross state product ( GSP) over the same 44 years. ( GSP is analogous to gross national product [ GNP] but on the state level.) The resulting data are in the following table.
YEAR DEPOSITS GSP YEAR DEPOSITS GSP 25 23 6.2 2.5 2 24 

a In $ millions.
b In $ billions.
a) Using exponential smoothing, with a=.6, then trend analysis, and finally linear regression, discuss which forecasting model fits best for Western Provincial’s strategic plan. Justify the selection of one model over another.
b) Carefully examine the data. Can you make a case for excluding a portion of the information? Why? Would that change your choice of model?

YEAR DEPOSITS GSP YEAR DEPOSITS GSP 25 23 6.2 2.5 2 24 24 4.1 2.8 3 24 25 4.5 2.9 26 26 6.1 3.4 25 27 7.7 38 30 1.0 28 10.1 4.1 31 1.4 29 15.2 4.0 8 32 1.7 30 18.1 4.0 9. 24 13 31 24.1 3.9 10 26 1.2 32 25.6 3B 11 25 1.1 33 30.3 3.8 12 33 34 36.0 3.7 13 50 1.2 35 31.1 4.1 14 95 1.2 36 31.7 4.1 15 1.70 1.2 37 38.5 4.0 16 23 16 38 47.9 4.5 17 2.8 1.5 39 49.1 4.5 18 2.8 1.6 40 55.8 4.5 19 2.7 1.7 41 70.1 4.5 20 3.9 1.9 42 70.9 4.6 21 4.9 1.9 43 79.1 4.7 22 5.3 2.3 44 94.0 5.0

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The exponential smoothening method is the best which can be done through follow up of the below equa... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!