Advanced Budgeting and Forecasting

Advanced Budgeting and Forecasting


Choose from the following table the course date which you would like to attend the course on :

Sart
End
Fees
Venue
Length
4-Mar-2018
8-Mar-2018
7500$
Istanbul (Turkey)
One Week
Click Here
11-Mar-2018
15-Mar-2018
4700$
Dubai (UAE)
One Week
Click Here
4-Mar-2018
8-Mar-2018
6950$
Paris (France)
One Week
Click Here
15-Apr-2018
19-Apr-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
8-Apr-2018
12-Apr-2018
5700$
London (UK)
One Week
Click Here
20-May-2018
24-May-2018
7500$
Istanbul (Turkey)
One Week
Click Here
6-May-2018
10-May-2018
4700$
Dubai (UAE)
One Week
Click Here
20-May-2018
24-May-2018
6950$
Paris (France)
One Week
Click Here
10-Jun-2018
14-Jun-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
17-Jun-2018
21-Jun-2018
5700$
London (UK)
One Week
Click Here
15-Jul-2018
19-Jul-2018
7500$
Istanbul (Turkey)
One Week
Click Here
8-Jul-2018
12-Jul-2018
4700$
Dubai (UAE)
One Week
Click Here
15-Jul-2018
19-Jul-2018
6950$
Paris (France)
One Week
Click Here
12-Aug-2018
16-Aug-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
26-Aug-2018
30-Aug-2018
5700$
London (UK)
One Week
Click Here
9-Sep-2018
13-Sep-2018
7500$
Istanbul (Turkey)
One Week
Click Here
16-Sep-2018
20-Sep-2018
4700$
Dubai (UAE)
One Week
Click Here
9-Sep-2018
13-Sep-2018
6950$
Paris (France)
One Week
Click Here
28-Oct-2018
1-Nov-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
21-Oct-2018
25-Oct-2018
5700$
London (UK)
One Week
Click Here
4-Nov-2018
8-Nov-2018
7500$
Istanbul (Turkey)
One Week
Click Here
11-Nov-2018
15-Nov-2018
4700$
Dubai (UAE)
One Week
Click Here
4-Nov-2018
8-Nov-2018
6950$
Paris (France)
One Week
Click Here
16-Dec-2018
20-Dec-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
9-Dec-2018
13-Dec-2018
5700$
London (UK)
One Week
Click Here
13-Jan-2019
17-Jan-2019
7500$
Istanbul (Turkey)
One Week
Click Here
20-Jan-2019
24-Jan-2019
4700$
Dubai (UAE)
One Week
Click Here
13-Jan-2019
17-Jan-2019
6950$
Paris (France)
One Week
Click Here
24-Feb-2019
28-Feb-2019
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
17-Feb-2019
21-Feb-2019
5700$
London (UK)
One Week
Click Here

Intorduction

This programme provides an overview of the tools and the skills to build world class standards into your planning, budgeting, performance measurement and reporting system and will discuss new and best practice techniques, explain how they complement the traditional financial planning tools, and introduce new concepts for measuring and reporting performance and shareholder wealth creation. Important elements of this programme include:

  • Making your budgeting process more cost effectively
  • Motivate managers to “buy in” to the budget process
  • Many case studies and illustrations of real companies will be used to help delegates understand how to apply different planning, forecasting and analysis techniques
  • Participants will also be given a detailed set of handouts that will enable them to review the topics covered at a later date

Objectives

  • Implement advanced planning and control techniques into your budgeting process
  • Integrate the budgeting process with the development of the company’s long-term strategic vision
  • Provide a decision support structure that provides timely and useful information to decision makers
  • Successfully build an integrated planning, budgeting and reporting process
  • Forecast costs and revenues with greater confidence
  • Apply management tools to the budgeting process that contribute to strategic goals
  • Effective manage the budgeting process
  • Identify key performance indicators for effective and focused decision making
  • Increase profitability and performance through stream lined planning and reporting

Day One

Budgets in Today’s International environment

  • Organizational Planning and Control Framework
  • The Product / Information / Decision Support Cycle
  • Strategic, Tactical, and Operational Forecasts
  • The recognition of risk in Models
  • Using Budget Models for Simulation Purposes
  • The Drive toward Shareholder Value (EVA®)

The Strategic Plan

  • The purpose of planning and budgeting in business
  • Defining the strategic approach to business planning
  • Defining strategic assumptions
  • Building the strategic planning model using financial data
  • Various strategic and tactical approaches to business planning
  • Defining the Decision-Support model: Assumptions/Goals and Key Success Factors

Day Two

Analysing the Historical Data Using Excel®

  • Recognizing the Basic Patterns Inherent in Historical Data
  • Using the Exploratory Data Analysis Tools Available in Excel®
  • Development of Time Series Models using histograms, moving averages, exponential smoothing and regression analysis
  • Using Regression Analysis as a predictor and estimator
  • Mastering the use of Exponential Smoothing as a Data Analysis tool
  • Single Regression vs. Multiple Regression
  • Validation of Time Series Analysis

Day Three

Approaches to Budget Development

  • Zero Base Budgeting
  • Activity based Budgeting
  • Rolling Budgets
  • Operational Unit Budgeting
  • Programme budgeting
  • Developing the Cash Budget

Using Activity based Budgeting

  • Developing the ABB application model
  • Budgeting for Processes rather than Departments
  • Defining Key Cost Drivers
  • Defining Key Activities
  • Development of ABB Cost Standards
  • Developing the Activity-Based Budget

Day Four

Strategic and Operational Cost Analysis Techniques

  • Identifying fixed, variable and semi-variable costs
  • Application of Regression in the development of budgets
  • Building the financial simulation model using articulated financial statements
  • Building the financial simulation model using deterministic simulation
  • Building the financial simulation model using probabilistic (Monte Carlo) simulation

Developing Manufacturing Standards

  • Material Standard Development
  • Labour Standard Development
  • Factory and Corporate Overhead Standard Development
  • Variance Analysis

Day Five

Defining and Testing Optimisation Techniques in Models Using Excel®

  • Basic Structure of All Optimisation Models
  • Different Forms and Applications of Optimization Models
  • Developing a Financial Optimisation Model
  • Performing Sensitivity Analysis of an Optimisation Model
  • Interpreting the Solution of an Optimisation Model to a Non-technical Manager
  • Lessons Learned and Lessons to be Learned

Get Information / Register