Question: Problem 3-11 (Algo) Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to
Problem 3-11 (Algo) 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 Week 2 Week 3 Week 4. 325 420 620 720 a. Using a three-week moving average, what would you forecast week 5 to be? Note: Round your answer to the nearest whole number. Forecast for the week 5 b. Using exponential smoothing with a = 0.10, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(325 +420)/2 = 373], what would you forecast week 5 to be? Note: Round your interim calculations and answer to the nearest whole number. Forecast for the week 5
Not all the ltems 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 yollow tablets for the month of August are. a. Using a three-week moving averege, what would you forecast week 5 to be? Note: Round your answer to the nearest whole number. b. Using exponential smoothing with a=0.10, if the exponential forecast for week 3 was estimated as the overage of the first two weeks ( (325+420)/2=373), what would you forecast week 5 to be? Note: Round your interim calculations and answer to the nearest whole number
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
