Question: The whistle Stop Cafe in Weems, Georgia, is well known for its popular homemade ice cream, made in a small plant in back of the café. People drive all the way from Atlanta and Macon to buy the ice cream. The two women who own the café want to develop a forecasting model so they can plan their ice cream production operation and determine the number of employees they need to sell ice cream in the café. They have accumulated the following sales records for their ice cream for the past 12 quarters:

Year Quarter Ice Cream Sales (gal.)

2003 1 350

2 510

3 750

4 420

2004 5 370

6 480

7 860

8 500

2005 9 450

10 550

11 820

12 570

Develop an adjusted exponential smoothing model with a=.50 and B=.50 to forecast demand and asses its accuracy using cumulative error (E) and average error (E). Does there appear to be any bias in the forecast?

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document