Not all the items in your office supply store are evenly distributed as far as d
ID: 400188 • Letter: N
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.
a. Using a three-week moving average, what would you forecast week 5 to be? (Round your answer to the nearest whole number.)
Forecast for the week 5
b. Using exponential smoothing with = 0.20, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(290 + 390)/2 = 340], what would you forecast week 5 to be? (Round your answer to the nearest whole number.)
Forecast for the week 5
Week 1 290 Week 2 390 Week 3 590 Week 4 690Explanation / Answer
A. Three week movie average forecast average of the previous three months.
Forecast for week 5 = (390+590+690)/3 = 556.66
B. Forecast for week 4
= 590*(0.2) + 340*(0.8)
= 390
Forecast for week 5
= 690(0.2) + 390(0.8)
= 450
Do give a positive rating if you think this answer helped
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.