Question: 3. Consider the sales given in Excel for Question 3. a. Apply moving average (MA), weighted moving average (WMA), exponential smoothing (ES). Have a sheet

3. Consider the sales given in Excel for Question 3. a. Apply moving average (MA), weighted moving average (WMA), exponential smoothing (ES). Have a sheet for each method and show your calculations in detail. Make sure you label your Excel sheets for each method such as "Question3_MA", "Question3_WMA" and "Question3_ES". Note you can use k and weights from the class notes. b. Compute the forecast accuracy using MAE, MSE, MAPE in Excel for each method. Make sure to report your results in Word using the following table format. Activity Moving Weighted Exponential Average Moving Smoothing Average MAE MSE MAPE c. Report your prediction for the next time period for each forecasting method. Moving Average Weighted Moving Average Exponential Smoothing Prediction Week Hamron TimeSeries Value 238 294 266 322 252 224 280 252 308 10 280 11 210 12 308

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please use data given Question 3 Week TimeSeries Value 1 2 3 4 5 6 238 294 266 322 252 224 280 252 308 280 210 308 7 8 9 10 11 12 3. Consider the sales given in Excel for Question 3. a. Apply moving...

VThe Karrie Restaurant is located in Portland Oregon. The restaurant has just completed its third year of operation. During this time, the owner sought to establish a reputation for the restaurant as...

Please answer the following questions in Excel and show work. I will positive rate! Scenario The last 30 weeks of demand is given in the table below for a 3 1/2 horsepower replacement motor that is...

Please show work in Excel. I will rate! Scenario The last 30 weeks of demand is given in the table below for a 3 1/2 horsepower replacement motor that is carried in stock at a distribution warehouse....

QUESTION 1 : Use the time series data in the Excel template file EXCEL PICTURE file to test three forecast techniques: 3 - period moving average, 2 - period weighted moving average, and exponential...

Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various locations in Philadelphia, Monday-Friday. The lunch...

Question in need for help ! OM MBA Ch4 ( 12 Edition Heizer-Jay ) Full details if possible , With best regard) Rules Nave Approach Demand in the next period is equal to demand in the most recent...

How can these retailers improve productivity? a. Travel agency. b. Neighborhood restaurant. c. College bookstore. d. Upscale luggage store.

fill the blocks 1 NL 2 3 4 5 6 A What is the target stock price in five years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Target stock p R What...

Question 1 : Scenario: You are employed as an insurance broker at Aotearoa Insurance, where all brokers are registered financial advisers. a . A potential client contacts you with two questions: I...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...