X AutoSave Off Ch18_6v2_18e - Protected View - Search (Alt+Q) 1485493 - X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X J17 vix fx A B C D E F G H J K L M N O P Q Period Demand W N - 1 130 124 W N 121 4 112 5 141 6 105 7 116 118 LD 00 10 142 11 10 125 12 13 14 15 16 17 18 19 20 21 22 23 Ch18_6v2_18e + Ready + 100% Type here to search 1:55 PM O W O X 48.F DI ENG 12/8/2021Question 1 - Unit 8 Assignment - X Course Hero X Dashboard X + V X A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%2... @ @ * * . .. Unit 8 Assignment Saved Help Save & Exit Submit Check my work Using simple moving averages and the following time series data, respond to each of the items. Period Demand 5 138 194 points 121 117 Skipped 141 185 116 118 142 125 Book Click here for the Excel Data File Print b. Compute all possible forecasts using a six-period simple moving average model. (Round your answers to 1 decimal place.) References Period Demand 6-Period SMA Absolute Error 130 2 124 121 112 141 6 105 7 116 8 118 142 10 25 11 Mc Graw Type here to search O W X 1:56 PM 480F ~ 9 ENG 12/8/2021Question 1 - Unit 8 Assignment - X Course Hero X Dashboard X + V X A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%2... Q @ * * . .. Unit 8 Assignment Saved Help Save & Exit Submit Check my work 11 5 points Skipped c. Compute the MAD. (Round your answer to 1 decimal place.) MAD Book Print References d. What is the forecast demand for period 11? (Round your answer to 1 decimal place.) The forecast demand for period 11 is e. What is the error associated with the eleventh-period forecast? (Round your answer to 1 decimal place.) Error associated with the eleventh-period forecast Mc Graw Type here to search O O W X 1:56 PM 480F ~ 9 ENG 12/8/2021