Question

Data given below the questions:

Estimate demand for the next month using Holt’s model with alpha = 0.05 and beta = 0.1. For this model use the level at Period 0 to be Lo=948 and the trend at Period 0 to be To=109 (both are obtained through regression).

h.    Evaluate the MAD at n=12.

i.    Evaluate the MAPE at n=12.

j.    Evaluate the MSE at n=12.

k.    Evaluate the bias at n=12.

l.    Evaluate the TS at n=12. Copy and paste table(s) from Excel.

m. Which of the two methods do you prefer? Why?

Use the data below to answer the above questions:

Monthly demand at G&B Electronics for TVs are as follows: This is the only data available. Please put this data in excel sheet and calculate. Show all work clearly. Thanks.

Period	Demand (units)
1	1000
2	1113
3	1271
4	1445
5	1558
6	1648
7	1724
8	1850
9	1864
10	2076
11	2167
12	2191

Answer 1

Level =

Trend=

1)

=43.33

2)

=

=2.80%

3)   

= 2443.30

4)   

=

= -2.08

  

  

=-0.048

Please refer below fig for calculation