5. Problem 12-5 (Algo) 113 points You have become concerned about the amount of copier paper used in your office after repeatedly running out of supplies. Your assistant keeps track of the number of reams (packages of 500 sheets) for 24 weeks: 4 10 eBook Week Reans of paper Week Reams of paper 1 251 13 280 2 280 14 265 3 276 15 268 227 312 5 239 17 249 6 268 18 290 7 229 19 249 8 240 20 255 9 245 21 316 16 246 22 266 256 23 275 12 268 24 251 Prim References D.nictureClick here for the Excel Data File a-1. Beginning with the errors calculated in week 7. calculate MFE and MAD for two week, four-week, and six-week moving averages. (Negative answers should be indicated by a minus sign. Round your intermediate calculations and final answers to 1 decimal place.) Moving Average Forecast 2-Week 4-Week 5-Week MFE MAD a-2. Compare the effectiveness of two week, four-week, and six week moving averages with respect to MAD Which should you use to forecast copier paper use during the next week? . Mc GROW HMI 5 a-2. Compare the effectiveness of two-week, four-week, and six week moving averages with respect to MAD Which should you use to forecast copler paper use during the next week? 113 points O2-week moving average O 6-week moving average 4 week moving average look b-1. Using errors from all 24 weeks, calculate MFE and MAD for exponential smoothing forecast model with smoothing constants of 0.01. 0.05, and 0.25. Assume a forecast for week 1 of 230 reams. (Round your intermediate calculations and final answers to 1 decimal place.) Exponential Smoothing Forecast = 0.01 -0.05 0.25 References MFE MAD b-2. Compare the performance of the simple exponential smoothing model with smoothing constants of 0.01 0.05, and 0.25. Assume a forecast for week 1 of 230 reams. Which constant worked best with respect to MAD? Exponential smoothing model with alpha of 0.05 Exponential smoothing model with alpha of 0.25 Exponential smoothing model with alpha of 0.01 Me Graw