Question

Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August are. Week 1 280 Week 2 380 Week 3 580 Week 4 680 a. Using a three-week moving average, what would you forecast week 5 to be

Answer 1

Answer: 547 yellow tablets

Explanation:

The three-week moving average would use the average of the tablets in the last three weeks before the 5th weeks to calculate the average for the 5th week.

= (Week 2 + Week 3 + Week 4) / 3

= (380 + 580 + 680) / 3

= 1,640 / 3

= 546.7

= 547 yellow tablets