Name: Score: Management Science Do Not Use Excel Software EXAMINATION 2 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 22 21 25 27 35 29 33 37 41 37 Forecast registration for weeks 510 using a twoweek moving average. Forecast registrations for weeks 510 using a fourweek moving average. Which forecasts are more accurate using the concept of MAD? 2. Given the following data, use exponential smoothing ( = 0.2) to develop a demand forecast for period 7. Assume that the forecast for week 1 = 7 Period 1 2 3 4 5 6 Demand 7 9 5 9 13 8 3. Develop a tracking signal for the forecasts shown below: Actual Demand 140 Forecast Demand 150 160 140 190 200 200 190 210 200 4 . Given the following data use least squares regression to develop a 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