Mon 1:06 AM E Excel File Edit View Insert Format Tools Data Window Help HES AutoSave OFF Lastname_ISE350FINAL-2 Home Insert Draw Page Layout Formulas Data Review View Tell me Share X Calibri (Body) 12 Insert v ab = = General 28- O 5 OM Paste GO BI DA C.A. = = .00 0 Ideas $ % ) 2. Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? D10 A B C D E F G H T J K L M N 1 Partial demand and forecast data for a particular phone is given on Table 1. a)(3 points) Estimate a 3-quarter simple moving average forecast for quarter 6. b)(5 points) The actual demand for quarter 6 turned out to be 1150. Compute an exponentially smoothed forecast for quarter 7 with a=0.20. Use the forecast from quarter 6 from part a. c)(3 points) Observing the actual demands for quarters 3 through 6, you are considering updating the value of a in part b. Would you choose a smaller or larger value than 0.20. Briefly explain why. d)(4 points) Calculate the cumulative error for quarters 3 to 6. What does the cumulative error for quarters 3 to 6 tell you about the forecasts. 2 3 Table 1 Table 1 4 Quarter (t) 3 4 5 Quarter (t) 3 4 5 5 Forecast(Ft) 422 408 603 Forecast(Ft) 6 Demand (Dt) 421 380 685 Demand (Dt) 7 8 a 0.2 9 D6 1150 10 11 Parta) 12 13 14 Part b) 15 Instructions Problem 1 Problem 2 Problem 3 Problem 4 Prolem 5 + 3 53,221 14 A P W WW