1 / 56

TM 745 Forecasting for Business & Technology Paula Jensen

TM 745 Forecasting for Business & Technology Paula Jensen. 1st Session 1/11/2012: Chapter 1 Introduction to Business Forecasting. South Dakota School of Mines and Technology, Rapid City. Agenda. Class Overview/Syllabus highlights Assignment Chapter 1 by Guest Lecturer Dr. Stuart Kellogg

tanika
Download Presentation

TM 745 Forecasting for Business & Technology Paula Jensen

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. TM 745 Forecasting for Business & TechnologyPaula Jensen 1st Session 1/11/2012: Chapter 1 Introduction to Business Forecasting South Dakota School of Mines and Technology, Rapid City

  2. Agenda • Class Overview/Syllabus highlights • Assignment • Chapter 1 by Guest Lecturer Dr. Stuart Kellogg • Business Forecasting 6th Edition J. Holton Wilson & Barry KeatingMcGraw-Hill

  3. Course Materials • Powerpoints & Class Information • Website: pjensen.sdsmt.edu via the ENGM 745 • Engineering Notebook – 9-3/4" x 7-1/2", 5x5 quad-ruled, 80-100 pp. (approx.) • Engineering/Scientific calculator • Book: Business Forecasting 6th Edition J. Holton Wilson & Barry KeatingMcGraw-Hill • One case from Harvard Business Review

  4. Prerequisites • Probability and Statistics • Understanding of Excel/Spreadsheet software. • It is expected that students will be able to access and download internet files.

  5. Course Objective • to educate prospective managers about the philosophies and tools of sound forecasting principles • to provide technical managers with a theoretical basis for statistical forecasting • to provide technical managers with the fundamentals methods available for technological and qualitative forecasts

  6. Evaluation Procedures

  7. Exams • Students signed up for the on-campus section are required to take the test at the given time. • Make-up Exams available for University-Approved reasons. • All exams are open engineering notebook, and use of a scientific calculator is encouraged. • Distance Students need proctors- See Syllabus for further details

  8. Project & Interaction Grades • Project Criteria to be discussed through Class • Interaction Assignments will include discussions, quizzes, and other assignments

  9. Email Policy: • If you are writing about issues relating to the class, make sure the subject line reads ENGM 745: (subject info) so I can sort my e-mails and answer accordingly. • Please be professional in your e-mails. (no texting lingo!)

  10. Academic Honesty • Cheating: use or attempted use of unauthorized materials, information or study aids • Tampering: altering or interfering with evaluation instruments and documents • Fabrication: falsification or invention of any information • Assisting: helping another commit an act of academic dishonesty • Plagiarism: representing the words or ideas of another as one's own

  11. ADA Students with special needs or requiring special accommodations should contact the instructor and/or the campus ADA coordinator, Jolie McCoy, at 394-1924 at the earliest opportunity.

  12. First Assignment • Send me a contact info e-mail. Include all important contact information phones, e-mail, and mail addresses. Preferred mode. • Send via e-mail a Current Resume • Problems 1,4, & 8 in chapter 1 – I don’t need these sent. I will post solutions.

  13. Introduction to Business Forecasting

  14. Quantitative Forecasting Has Become Widely Accepted • Intuition alone no longer acceptable. • Used in • Future Sales • Inventory needs • Personnel requirements • Judgment still is needed

  15. Forecasting in Business Today • Two Professional Societies • Accountants: costs, revenues (tax plans) • Personnel: recruitment, changes in workforce • Finance: cash flows • Production: raw-material needs & finished goods inventory • Marketing: sales

  16. Forecasting in Business Today • mid-80’s 94% large American firmsused sales forecasts • Krispy Kreme • New stores model with errors of < 1% • Bell Atlantic • Data warehouse (shared) of monthly history • Subjective, regression, time series, • Forecasts monitored & compared

  17. Forecasting in Business Today • Columbia Gas (natural gas company) • Design Day Forecast (supply) • Gas supply, transportation capacity, storage capacity, & related • Daily Operational (demand) • Regression on temperatures, wind speed, day of the week, etc.

  18. Forecasting in Business Today • Segix Italia (Pharmaceutical company) • Marketing forecasts for seven main drugs • Targets for sales representatives • Pharmaceuticals in Singapore • Glaxo-Wellcome, Bayer, Pfizer, Bristol-Myers Squibb • HR, Strategic planning, sales • Quantitative & judgments

  19. Forecasting in Business Today • Fiat Auto (2 million vehicles annually) • All areas use centrally prepared forecasts • Use macro-economic data as inputs • From totals sales to SKU’s • Douglas Aircraft • Top down (miles flown in 32 areas) • Bottom up (160 Airlines studied)

  20. Forecasting in Business Today • Trans World Airlines • Uses a top down (from total market) approach for sales • Regression & Trend models • Brake Parts Inc. • 250,000 SKU’s • Forecast system saves $6M/mo. • 19 time series methods

  21. Forecasting in the Public and Not-for-Profit Sectors • Police calls for service by cruiser district • State government • Texas: Personal income, electricity sales, employment, tax revenues • California: national economic models, state submodel, tax revenues, cash flow models • Hospitals: staff, procedures,

  22. Collaborative Forecasting • Manufacturer’s forecast > RetailersRetailer’s extra info > Manufacturers • Lower Inventory • Fewer unplanned shipments or runs • Reduced Stockouts • Increase customer satisfaction • Better sales promotions • Better new product intros • Respond to Market changes

  23. Computer Use and Quantitative Forecasting • Computer use common by mid 80’s • Packages run from $100 to thousands • PC systems generally have replaced mainframes for state government work • PC’s dominant at conferences • Chase of Johnson & Johnson • Forecasting 80% math, 20% judgment

  24. Subjective Forecasting Methods • Only way to forecast 40 years out • Sale-Force Composite • Inform sales staff of data • Bonus for beating the forecast ?? • Surveys of Customers/Population • Jury of Executive Opinion • The Delphi Method (Experts)

  25. New-Product Forecasting • A special consideration • Surveys • Test marketing ( Indy, K-zoo, not KC) • Analog Forecasts: movie toys

  26. New Product Short Life Cycle

  27. New Product Short Life Cycle

  28. New Product Short Life Cycle

  29. Product Life Cycle

  30. Bass Model

  31. Two Simple Naive Models (4th)

  32. Two Simple Naive Models (4th)

  33. Evaluating Forecasts

  34. Evaluating Forecasts

  35. Evaluating Forecasts

  36. Measurement Errors Standard Deviation

  37. Measurement Errors Standard Deviation

  38. Measurement Errors MAE

  39. Measurement Errors MAE In general, 0.8(.193) = 0.154

  40. Measurement Errors Mean Error

  41. Measurement Errors

  42. Using Multiple Forecasts • Use judgment • Reference:Combining Subjective andObjective Forecasts.

  43. Sources of Data • Internal records • Timeliness & formatting problems • Government & syndicated services (good) • Web • Used by gov’t & syndicated • Sites changes

  44. Domestic Car Sales (4th ed ex.)

  45. Domestic Car Sales (4th ed ex)

  46. Domestic Car Sales (4th ed ex)

  47. Forecasting Fundamentals Consider the following sales data over a 12 month period.

  48. Summary Statistics Mean

More Related