Not all the items in your office supply store are evenly distributed as far as d
ID: 450836 • 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
Using a three-week moving average, what would you forecast the next week to be? (Round your answer to the nearest whole number.)
Using exponential smoothing with = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(350 + 450)/2 = 400], what would you forecast week 5 to be? (Round your answer to the nearest whole number.)
Week 1 350 Week 2 450 Week 3 650 Week 4 750Explanation / Answer
DEMAND FORECAST (3 MA) Exponential Smoothing = Forecast for previous period + (Alpha * Error) Error = (Demand - Exponential Smoothing) WEEK 1 350 400.00 -50.00 WEEK 2 450 385.00 65.00 WEEK 3 650 404.50 245.50 WEEK 4 750 483.33 478.15 271.85 WEEK 5 616.67 559.71
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.