Location

Community Services & Continuing Education - Cairo

Objectives

• This course is prepared to helpintroducing a more objective estimate forthe future activities which may form oneof the major tools for strategic planningfor many levels of management andfunctional planning

Outcomes

-Appreciation of the alternative approaches that may be useful for sales forecasting.-Understanding of the need for the best possible seasonal analysis and some practical ways of dealing with seasonality.-Insights into the challenges of forecasting for new products and for promotions.-Detailed knowledge of a number of the most useful forecasting methods.

Course Contents

 Why forecasting. Route of forecasting. Quantitative vs qualitative forecasting. Effect of misleading quantitative forecasts. When and where to start the forecast. Forecast stages. Factors of limitations. Time series analysis Moving average technique. Regression with related variables. Degree of accuracy (multiple regressions). Time Series forecasting Auto forecast by Excel. Simple exponential forecast. Running means absolute deviation RMAD. Running sum of forecasting errors RSFE. Tracking signal Ts. Graphic forecast. Graphic tracking system. Types of decisions may be takenaccordingly. Application on case study. Demand management Capacity management Capacity and demand matching