Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help ASAPpppp please please (Forecasting Problem) Not all the items in your office supply store are evenly distributed as far as demand is concerned, so
help ASAPpppp please please
(Forecasting Problem) 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 5-week data for legal-sized yellow tablets is shown in the table below. (round your answer to integer) 20 pts 300 Week 1 Week 2 Week 3 Week 4 Week 5 400 500 700 800 (a) Using a 3-week simple moving average, what would you forecast the week 6 to be? (5 points) (b) Calculate the weighted 3-week moving average using weights of 0.5, 0.3, and 0.2, what would you forecast the week 6 to be? (5 points) (c) Using simple exponential smoothing with a = 0.20, if the exponential forecast for week 5 was estimated as 750, that is F5 = 750, what would you forecast week 6 to be? (5 points) (d) Using exponential smoothing with trend to forecast week 6. Given a=0.20, 8 = 0.30, the exponential forecast for week 5 (F5) was estimated as 750, trend forecast for week 5 (T5) as 200. (5 points) Edit View Insert Format Tools Table Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started