| | CSIS 405 |
|
|
| | Chapter 1: Introduction to Business Forecating |
|
|
| | 1. Certification for professional forecasters: |
| | a. IBF (Institute of Business Forecasting and Planning): |
| | à http://www.ibf.org/ |
| | àCPF and ACPF |
| | àJournal of Business Forecasting |
| | b. IIF(International Institute of Forecasters) |
| | àhttp://www.forecasters.org/ |
| | àForesight |
|
|
| | 2. Homework: |
| | Exercises: 3, 4, 7, 8, 9, and 11 (Use Excel for this exercise) |
|
|
|
|
| | Exercise 8: |
| | | 8a. Naïve forecast (t) = Actual value (t-1) |
| | | Year | Retail Store Sales | Naïve Forecast |
| | | 1 | 1,225 |
| | | 2 | 1,285 | 1,225 |
| | | 3 | 1,359 |
| | | 4 | 1,392 |
| | | 5 | 1,443 |
| | | 6 | 1,474 |
| | | 7 | 1,467 |
| | | 8 | | 1,467 |
|
|
| | | 8b. To prepare a time-series graph |
| | | | Highlight Retail Store Sales and Naïve Forecast data |
| | | | Click "Insert" on the Excel and above "Charts" choose "Line" |