Homework: Bonus Assignment 2 (copy data into Excel to calcul Score: 0.2 of 1 pt 1 of 1 (1 complete) % Problem 4.61 Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 9 10 12 Week Actual Passenger Miles (in thousands) 1 2 18 23 3 19 4 24 5 6 19 18 7 7 20 8 19 11 14 24 20 25 a) Assuming an initial forecast for week 1 of 18,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use a=0.22 (round your responses to two decimal places). 1 2 3 4 5 6 7 8 9 10 11 12 Week Forecasted Passenger Miles (in thousands) 18.00 18.00 19.10 19.08 20.16 19.90 19.48 19.59 19.46 20.46 20.36 18.96 b) The MAD for this model = 2.63 thousand (round your response to two decimal places). c) Compute the Cumulative Forecast Errors, cumulative MAD in thousands, and tracking signals (round your responses to two decimal places). Cumulative Forecast Errors Week MAD Tracking Signal Week Cumulative Forecast Errors 7.28 MAD Tracking Signal 3.75 1 0.00 7 1.94 0.00 2.50 2 5.00 2.00 8 1.77 3.77 3 4.90 1.70 2.88 9 6.69 11.23 10.77 2.08 5.40 4 9.82 3.92 10 1.92 5.61 2.51 2.24 5 8.66 3.87 11 6 6.76 2.18 3.10 12