Question: Please complete each section (A, B, and C). The owner of an equipment rental service has recorded the following rentals each week: Week: 1 2

The owner of an equipment rental service has recorded the following rentals each week: Week: 1 2 3 4 5 6 7 Rentals: 1303 1245 1229 1409 1229 1249 1338 1408 pictureClick here for the Excel Data File a. Use a three-week moving average to forecast sales for each of the weeks 4 through 9. (Round your answers to 2 decimal places.) Wook Forecast 4 5 6 7 8 9 b. Use a four-week moving average to forecast sales for each of the weeks 5 through 9. (Round your answers to 2 decimal places.) Week Forecast 5 6 7 8 9 c. Using error data from only Periods 5-8 for both forecast methods, which forecast method would you recommend based on the MAD measure? 4 week moving average 3 week moving average
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
