•..• 4.34 Boulanger Savings and Loan is proud of its long tra-dition in Winter Park, Florida. Begun by Michelle Boulanger22 years after World War II, the S&L has bucked the trend offinancial and liquidity problems that has repeatedly plaguedthe industry. Deposits have increased slowly but surely over theyears, despite recessions in 1983, 1988, 1991, 2001, and 2010. Ms.Boulanger believes it is necessary to have a long-range strategicplan for her firm, including a 1-year forecast and preferably evena 5-year forecast of deposits. She examines the past deposit dataand also peruses Florida's gross state product (GSP) over the same44 years. (GSP is analogous to gross national product [GNP] buton the state level.) The resulting data are in the following table.YEARDEPOSITS?GSPbYEARDEPOSITS?GSpb1.25.413.501.2.24.414.951.2.24.5151.701.24.26.7162.31.6.25.9172.81.5.301.0182.81.67.311.4192.71.78.321.7203.91.99..241.3214.91.910.261.2225.32.311.251.1236.22.512.33.9244.12.8(continued)io io YEARDEPOSITSGSP6YEARDEPOSITSaGSP6254.52.93531.14.1266.13.43631.74.1277.73.83738.54.02810.14.13847.94.52915.24.03949.14.63018.14.04055.84.53124.13.94170.14.63225.63.84270.94.63330.33.84379.14.73436.03.74494.05.0a In $ millions.b In $ billions.a) Using exponential smoothing, with a = .6, then trend analysis,and finally linear regression, discuss which forecasting modelfits best for Boulanger's strategic plan. Justify the selection ofone model over another.b) Carefully examine the data. Can you make a case for exclud-ing a portion of the information? Why? Would that changeyour choice of model? PX

a) Using exponential smoothing, with a = .6, then trend analysis, and finally linear regression, discuss which forecasting model fits best for Boulanger's strategic plan. Justify the selection of one model over another. b) Carefully examine the data. Can you make a case for exclud- ing a portion of the information? Why? Would that change your choice of model? PX

a) Using exponential smoothing, with a = .6, then trend analysis, and finally linear regression, discuss which forecasting model fits best for Boulanger's strategic plan. Justify the selection of one model over another. b) Carefully examine the data. Can you make a case for exclud- ing a portion of the information? Why? Would that change your choice of model? PX

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Using the photo attached, answer the following questions. 1. using the manual trend projection method of forecasting, show how Mr John can forecast demand for tyres for the next two years. SHOW ALL WORKING NO EXCEL SHEETS NO HAND WRITTEN ANSWERS, TYPE IT!
Which type of forecasting approach, qualitative or quantitative, is better?
Hi, I need help with solving for the following values (boxed). Thank you.
MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15
(Use excel to show formulas used) Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. Year Sales 1 290 2 340 3 400 4 410 5 400 Forecast Year 6 sales. Compute MAD.
Better if you use excel in the computations. Thank you.
What are the advantages and disadvantages of aggregating deman from a forecasting view? Are there other things that should be considered when going from multiple DC (Distribution Centers) to a DC?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Heres a zoom in photo of of the problem/ Please solve
Operation managememt
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
K 2. Setting an advertising budget is a forecasting exercise. What are the fundamental principles that should be adhered to when undertaking forecasting? Be conservative and use the best evidence-based technique available Be innovative and use multiple methods and choose the optimal one Be conservative and use multiple evidence-based techniques, taking the average result Be innovative and use multiple evidence-based techniques, taking the average result