using Excel

HKUST Business School Thompson Center EXHIBIT 2: SALES AND FORECAST DATA Note: The alpha value =0.4 and initial forecast F2=S1=3,303 units. Source: Disguised data provided by Chinese Pharmaceuticals (HK) Limited. In the same case study, use the sales data in the table and apply the same forecast method when =0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9, and 1 . What is the best value for ? What does the best value of indicate or show in regards to the forecast model? (Hint: Use Microsoft Excel to solve the question) HKUST Business School Thompson Center EXHIBIT 2: SALES AND FORECAST DATA Note: The alpha value =0.4 and initial forecast F2=S1=3,303 units. Source: Disguised data provided by Chinese Pharmaceuticals (HK) Limited. HKUST Business School Thompson Center for Business Case EXHIBIT 3: SALES AND FORECAST DATA IN GRAPHICAL DISPLAY Note: St and Ft are the actual sales and forecast, respectively, for the time period t. Source: Disguised data provided by Chinese Pharmaceuticals (HK) Limited