1. Registration numbers for an accounting seminar over the past 10 weeks are shown below:
Week 1 2 3 4 5 6 7 8 9 10
Registrations 23 22 26 28 35 30 33 37 40 39
Forecast registration for the last six weeks (5-10) using a two-week and a four-week moving average.
Which forecasts are more accurate using the concept of MAD?
2. Given the following data, use exponential smoothing with ? = 0.2 to develop a demand forecast for period 7. (Forecast for Period 1=10). Period 1 2 3 4 5 6
Demand 7 9 5 9 13 8 3.
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks along with demand forecasts:
Week 1 2 3 4 5 6
Actual Passenger Miles in thousands 17 21 19 23 18 16
Demand Forecast in thousands 19 25 20 26 17 14
Week 7 8 9 10 11 12
Actual Passenger Miles in thousands 20 18 22 20 15 22
Demand Forecast in thousands 21 19 19 23 17 24
a) Use the concept of a Tracking Signal to determine whether the demand forecasts are in control.
4. Given the following data, develop a least squares regression equation.
Year 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003
Rainy Days 15 25 10 10 30 20 20 15 10 25
Games Lost 25 20 10 15 20 15 20 10 5 20