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 (α) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Year 2005 2006 2007 2008 2009 The MAD for a forecast developed using exponential smoothing with a = 0.30 is response to two decimal places). 2005 2006 415.00 Sales 455 502 518 563 584 Forecasted Sales 415.00 427.00 449.50 470.05 497.94 Forecasted sales for years 2006 through 2010 using exponential smoothing with α = 0.60 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2007 Forecasted Sales 2005 2006 The MAD for a forecast developed using exponential smoothing with α = 0.60 is response to two decimal places). Forecasted Sales 415.00 2008 2009 sales (round your Forecasted sales for years 2006 through 2010 using exponential smoothing with α = 0.90 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2007 2008 2009 The MAD for a forecast developed using exponential smoothing with a = 0.90 is response to two decimal places). 2010 sales (round your 2010 sales (round your

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

The MAD for a forecast developed using exponential smoothing with

0.30

enter your response here

sales (round your response to two decimal places).

Forecasted sales for years 2006 through 2010 using exponential smoothing with

0.60

and a starting forecast of

415.00

are (round your responses to two decimal

places):

Year	2005	2006	2007	2008	2009	2010
Forecasted Sales	415.00	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here