Question: 2 ) ( 3 5 points ) - build a model Sales of tablet computers at Ted Glickman s electronics store in Washington, D

"2)(35 points)- build a model
Sales of tablet computers at Ted Glickmans electronics store in Washington, D.C., over the past 12 weeks are shown in the table.
a)(15 pts) Select any 3 values for a to Forecast the demand for each week, including week 13, using exponential Smoothing and determine which of the 3 a is the best alpha based on MAD
b)(8 pts) Using the best alpha found in a) and an initial trend of 2 and b=0.4, forecast the demand for each week, including week 13, using the trend-adjusted exponential smoothing method.
c)(8 pts) is it appropritate to use a line to forecast for week 13? Show all your work (calculations, graphs, etc.) and fully justify your answer.
d)(4 pts) assuming that using a line is appropriate, use the linear regression line found in c) to determine the forecast for week 13.
Be organized in your calculations.
Use appropriate Labels."
Values
week 1=18
week 2=23
week 3=25
week 4=31
week 5=25
week 6=32
week 7=36
week 8=28
week 9=33
week 10=35
week 11=38
week 12=41
The Initial Forecast is 20

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!