2. Monthly demand at A&D Electronics for flat-screen TVs are as shown in the following table....

Transcribed Image Text:

2. Monthly demand at A&D Electronics for flat-screen TVs are as shown in the following table. Estimate demand for the next two months using (a) simple exponential smoothing with a = 0.3 (b) and Holt's model with = 0.05 and = 0.1. For the simple exponential smoothing model, use the level at Period 0 to be Lo = 1,659 (the average demand over the 12 months). For Holt's model, use level at period 0 to be L = 948 and the trend in Period 0 to be To = 109 (both are obtained through regression). Evaluate the MAD, MAPE, MSE, bias, and TS in each case. Which of the two methods do you prefer? Why? Demand Month (units) 1 1,000 2 1,113 3 1,271 4 1,445 5 1,558 6 1,648 7 1,724 8 1,850 9 1,864 10 2,076 11 2,167 12 2,191 123 A B D E F Month Demand (units) 4 8 1234 56700 1000 2 1113 3 1271 4 1445 LO 1558 9 10 67 6 1648 7 1724 11 8 1850 12 9 1864 13 10 2076 14 11 2167 15 12 2191 16 17 18 19 20 21 22 23 2. Monthly demand at A&D Electronics for flat-screen TVs are as shown in the following table. Estimate demand for the next two months using (a) simple exponential smoothing with a = 0.3 (b) and Holt's model with = 0.05 and = 0.1. For the simple exponential smoothing model, use the level at Period 0 to be Lo = 1,659 (the average demand over the 12 months). For Holt's model, use level at period 0 to be L = 948 and the trend in Period 0 to be To = 109 (both are obtained through regression). Evaluate the MAD, MAPE, MSE, bias, and TS in each case. Which of the two methods do you prefer? Why? Demand Month (units) 1 1,000 2 1,113 3 1,271 4 1,445 5 1,558 6 1,648 7 1,724 8 1,850 9 1,864 10 2,076 11 2,167 12 2,191 123 A B D E F Month Demand (units) 4 8 1234 56700 1000 2 1113 3 1271 4 1445 LO 1558 9 10 67 6 1648 7 1724 11 8 1850 12 9 1864 13 10 2076 14 11 2167 15 12 2191 16 17 18 19 20 21 22 23