Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Time Management

Authors: Patrick Forsyth

6th Edition

1398606197, 978-1398606197

Students also viewed these General Management questions