Question: 100 points total. Show work for partial credit. Use this table to answer the following. Use a linear regression forecast and a double exponential smoothing

100 points total. Show work for partial credit.

  1. Use this table to answer the following. Use a linear regression forecast and a double exponential smoothing forecast (alpha = 0.3, beta = 0.6, F(1) = 250, T(1) = 0). (6+6 = 12)

Period

Demand

LR Forecast

DES Forecast

F(t)

T(t)

1

260

2

255

3

273

4

260

5

259

6

283

7

286

8

271

9

299

10

307

11

303

12

296

13

295

14

315

15

326

16

332

17

337

18

345

19

323

20

335

21

320

22

315

23

322

24

312

25

  1. Calculate the Mean Forecast Error for the 24 periods. (2)

MFE(LR) = _________, MFE(DES) = _________

  1. Calculate the Mean Absolute Deviation for the 24 periods. (2)

MAD(LR) = _________, MAD(DES) = _________

  1. Calculate the Mean Absolute Percent Error for the 24 periods. (2)

MAPE(LR) = _________, MAPE(DES) = _________

  1. Which forecast is better? (1) Why? (1)

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!