Preview File Edit View Go Tools Window Help BI Fri Oct 15 12:52 PM - SCMN-3320 - Homework-1 (+ Practice Problems) Fall... Q Search Page 11 of 51 PDF SCMN-3320 - Homework-1... 12.9. Mary Hernandez has invested in a stock mutual fund. She is considering liquidating and investing in a bond fund. She would like to forecast the price of the stock fund for the next month before making a decision. She has collected the following data on the average price of the fund during the past 20 months. ROTECTED EN C...I-B.pdf 9 DUCK 10 EMPLOYEE FORMATION ERMS AND ONDITIONS ..... webpage 10 " FE webpage Month Fund Price Month Fund Price Month Fund Price 1 63 1/4 8 65 1/8 15 70 1/8 2 60 1/8 9 9 68 1/4 16 72 3/4 3 61 3/4 10 65 1/2 17 74 1/8 4 64 1/4 11 68 1/8 18 71 3/4 5 59 3/8 12 63 1/4 19 75 1/2 6 57 7/8 13 64 3/8 20 76 3/4 7 62 1/4 14 68 5/8 a. Using a three-month moving average, forecast the fund price for month 21. b. Using a three-month weighted average with the most recent month weighted 0.60, the next most recent month weighted 0.30, and the third month weighted 0.10, forecast the fund price for month 21. c. Calculate an exponentially smoothed forecast using a=0.40 and forecast the fund price for month 21. d. Compare the forecasts in (a), (b), and (c) using MAD and indicate the most accurate. e. Compare the forecasts in (a), (b), and (c) using MSE and indicate the most accurate. "" 45 ''' '' wenty and investing in a bond fund. She would like to forecast the price of the stock fund for the corses 11 clocated Items OCT 40 15 W DO