Question: Please help, will thumbs up! Problem 12-5 (Algo) You have become concerned about the amount of copier paper used in your office after repeatedly running

Please help, will thumbs up!
Please help, will thumbs up! Problem 12-5 (Algo)
Please help, will thumbs up! Problem 12-5 (Algo)
Problem 12-5 (Algo) 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: 3 7 Week Reams of paper Week Reams of paper 2. 260 14 272 262 1 242 13 247 4 238 16 261 5 226 12 232 6 254 18 239 15 246 19 234 8 258 20 247 9 229 21 282 10 294 22 232 11 241 28 283 12 260 24 236 308 PictureClick here for the Excel Date 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 6-Week MFE MAD 3-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? 4-week moving average 6-week moving average O2-week moving average 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 a 0.01 -0.05 -0.25 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 teams. Which constant worked best with respect to MAD? Exponential smoothing model with alpha of 0.05 Exponential smoothing model with alpha of 0.01 Exponential smoothing model with alpha of 0.25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!