19 June, 2024.
21 June, 2024.
This course will introduce practical analytical methods for forecasting revenues..
Participants will be guided to apply forecasting techniques on their own laptop computers individually and group exercises. The course shall cover public and private sector entities
The course will provide hands-on instruction on how to use specific qualitative and quantitative forecasting techniques and highlight the advantages and disadvantages of each technique. Instructors will show how to use Excel spreadsheet software as a tool for revenue forecasting and analysis
The course covers the fundamentals of revenue forecasting, including:
âÂÂÂÂÂÂ€¢ Best practices in revenue forecasting
âÂÂÂÂÂÂ€¢ Qualitative revenue forecasting methods
âÂÂÂÂÂÂ€¢ Quantitative revenue forecasting methods
âÂÂÂÂÂÂ€¢ Preparing data for quantitative analysis (deflating, differencing, smoothing, normalizing)
âÂÂÂÂÂÂ€¢ Trend analysis and moving averages
âÂÂÂÂÂÂ€¢ Fundamentals of regression analysis
âÂÂÂÂÂÂ€¢ Being a âÂÂÂÂÂÂ€ÂÂÂÂÂÂœsmart consumerâÂÂÂÂÂÂ€ÂÂÂÂÂÂ of regression output
âÂÂÂÂÂÂ€¢ Identify historic revenue patterns
âÂÂÂÂÂÂ€¢ Identify factors that affect revenue patterns
âÂÂÂÂÂÂ€¢ Specify assumptions about factors that affect revenues
âÂÂÂÂÂÂ€¢ Choose and apply appropriate forecasting method
âÂÂÂÂÂÂ€¢ Gauge the accuracy of the forecast