Download
northcutt bikes case answers n.
Skip this Video
Loading SlideShow in 5 Seconds..
Northcutt Bikes Case Answers PowerPoint Presentation
Download Presentation
Northcutt Bikes Case Answers

Northcutt Bikes Case Answers

2437 Views Download Presentation
Download Presentation

Northcutt Bikes Case Answers

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Northcutt Bikes CaseAnswers

  2. Q1: Demand Data Plot

  3. Q1: Plot Shows • There is seasonality • There is a trend • Forecast should take into account both

  4. Construction of base indices

  5. Multiple Regression Results:X is Period and Base

  6. Q2: Forecasting Methods • Multiple regression or MR (Y is forecast, X’s are period and base) MAD ≈ 45.096 • Simple regression or SR (deseasonalize demand, seasonalize forecast, X is period) MAD ≈ 32.403 • Exponential Smoothing or ES (adjusted for trend and seasonality) MAD ≈ 13.258

  7. Q2: Forecast for January – April 2012

  8. Q3: Best Forecast: • Exponential smoothing forecast has lowest MAD • Disadvantages: the exponential smoothing forecast should be updated frequently (say once a month).

  9. Q4: Additional Information Jan’s knowledge of market could be used to: - Add additional independent variable to multiple regression - Be used to adjust other forecasts (caution should be used, however) Monthly increments best as forecast can react to latest information, provided this is not costly

  10. Q5: Ways to Improve Operations • Quicker response: reduce manufacturing lead times; possibly implement online ordering • Suppliers: reduce lead times; set contracts • Improve information systems • Work force: increase flexibility; temps

  11. Q6: Recommendations • Operation is likely not too large - Jan can control operation effectively if she: • delegates • improves information system • reduces lead times • implements lean (to be discussed) • uses different modes of operation for different style bikes • Information needed on costs of above

  12. Questions ? ???