Question: 1 . Given the HomeImprovemnt.com sales data for 1 0 3 weeks, please generate Moving Average, Exponentially Smoothed ( ES ) , Adjusted Exponentially Smoothed

1. Given the HomeImprovemnt.com sales data for 103 weeks, please generate Moving
Average, Exponentially Smoothed (ES), Adjusted Exponentially Smoothed (AF) and
Simple Linear Regression forecasts (SLR).(80 points)
Forecasting Method Forecasting Criteria Points
Moving Average 5 periods 5
Moving Average Please choose the number of periods for
forecasting model using MA approach.
Briefly explain why you picked this value for a
model parameter.
10
Exponentially Smoothed
(ES)
Alpha=0.85
Exponentially Smoothed
(ES)
Please choose alpha for ES forecasting model.
Briefly explain why you picked this value for a
model parameter.
10
Adjusted Exponentially
Smoothed (AF)
Alpha=0.8
Beta=0.5
10
Adjusted Exponentially
Smoothed (AF)
Please choose beta for AF forecasting model.
Briefly explain why you picked this value for a
model parameter.
10
Simple Linear Regression
forecasts (SLR)
Please develop a forecasting model using Linear
Regression
10
2. Please forecast value for period 107 using ALL forecasting methods (10 points)
3. Please calculate MAD for all forecasting models and select the best performing
forecasting model for HomeImprovement.com. (10 points)

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!