Budget Management & Control

Break-Even Analysis, Sensitivity Analysis, and What-If Analysis

• Break-Even Analysis, Cost Behaviour, and Sensitivity Analysis

  • Identifying Fixed, Variable and Semi-variable costs

  • Identification of the level of sales/profit in order to break even

  • Identification of critical costs

  • Determining resources requirements

  • What if Analysis using Excel and leading software

• Performing “What If” and Sensitivity Analysis to evaluate the implications of changes in major factors of production and consumption on the Cash Budget and Profit & Loss Account

• Identification of key performance indicators for effective and focused decision making

• Recommend various courses of action to manage the implications of “What If” and Sensitivity Analysis.

• Developing Budget Re-Projection and Best Case / Worst Case Scenario Models

  • Planning for contingencies

  • Developing various scenarios

  • Using the Scenario tool in Excel® to explore the variable sets of assumptions while tracking the impact on the base model.

  • Building the financial simulation model using probabilistic (Monte Carlo) simulation

  • Building the financial simulation model using deterministic simulation

Variance Analysis, Reporting, Control, and Decision Making

• Accounting Systems, Accountability and Responsibility Systems

• Essential Elements of a Costing System

• Establishing and Implementing a Costing System

• Undertaking Variance Analysis and Presenting a Variance Report to decision-makers

• Evaluation of the results

• Making Strategic Decisions based on the Variance Report/Business Planning