Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please solve in excel with detail please. a. (Worth 11 points) Forecast demand with a 3-year weighted moving average in which demand in the most
please solve in excel with detail please.
a. (Worth 11 points) Forecast demand with a 3-year weighted moving average in which demand in the most recent year is given a weight of 2 and demands in the other two years are given a weight of 1. b. (Worth 11 points) Forecast demand by using exponential smoothing with a smoothing constant of 0.4. Assume the forecast for year 1 is 6000 bags to begin the procedure. c. (Worth 2 points) Which of these two methods would you use based on MAPE comparisons? Please show Excel computation for 2a and 2b on separate Excel Worksheets (2 files or two tabs/one file) and please use a format similar to the one used in the Textbook and class videos and examples. Highlight the important outcomes. Your presentation to Dropbox of your results will be worth 2 points for a total of 40Step 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