Answer Happy

Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Year 2005 2006 2007 2008 2009 Sales 450 510 516 566 584 Forecasted Sales 410.00 422.00 448.40 468.68 497.88 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 75.81 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 410.00 are (round your responses to two decimal places): 2005 Year 2006 2007 2008 2009 Forecasted Sales 410.00 434 479.6 501.44 540.32 2010 566.53 The MAD for a forecast developed using exponential smoothing with a = 0.60 is 46.33 sales (round your response to two decimal places).

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: Month January February March April May June Month Forecast Price Per Chip $1.85 $1.61 $1.60 $1.85 $1.88 $1.89 Month July August September October November December Price Per Chip $2.00 $1.75 $1.65 This exercise contains only parts a, b, and c. a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Aug Sep Oct Nov Dec 1.95 1.88 1.70 1.6 1.58 Mar Apr May Jun Jul $1.73 1.61 1.73 1.87 1.89 $1.55 $1.60 $1.75 b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Apr May Jun Jul Aug Sep Oct Nov Dec Forecast $1.69 1.69 1.78 1.87 1.92 1.88 1.80 1.65 1.60 c) The mean absolute deviation based on a 2-month moving average of March through December is $ (round your response to three decimal places).

Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Guests (in thousands) 63 89 155 75 65 82 Guests (in thousands) Quarter Quarter Summer Year 2 Fall Year 2 Winter Year 3 Winter Year 1 Spring Year 1 Summer Year 1 Fall Year 1 Winter Year 2 Spring Year 2 Spring Year 3 Summer Year 3 205 Fall Year 3 99 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places): Season Index 0.179 Winter 124 54 99 156