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" an "Question3 ES". a b. Compute the forecast accuracy using MAE, MSE, MAPE in Excel for each method. Mak sure to report your results in Word using the following table format. Activity Moving Average Weighted Moving Average Exponentia I Smoothing MAE I MSE MAPE c. Report your prediction for the next time period for each forecasting method. TimeSeries Value Week 1 119 2 147 3 133 4 161 5 mon 000 6 126 112 140 7. 8 126 154 9 10 140 11 105 154 12

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 Finance 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...

Suppose two batteries, with unequal emfs of 2.00 V and 3.00 V, are connected as shown in Fig. 19-51. If each internal resistance is r = 0.100 , and R = 4.00, what is the voltage across the resistor...

Wigs Plus Company supplies wigs and hair care products to beauty salons throughout California and the Pacific Northwest. The accounts receivable clerk for Wigs Plus prepared the following partially...

Paul Dirac begins operating his Anti - Matter Bar and Grill on \ ( 1 / 1 / 1 9 \ ) with an equity investment of \ ( \ $ 1 0 0 , 0 0 0 \ ) . Dirac assumes that he will earn \ ( \ $ 6 3 , 0 0 0 \ ) in...

PB5-4 1.) Seat Covers Produced & Sold 1,500 units 1,700 units 2,100 units Total Costs: Variable Costs 15,750 Fixed Costs per year TOTAL Costs Per Unit Variable Costs per unit Fixed Costs per unit...