Planning, Forecasting, What If Analysis and Reporting

Planning, Forecasting, What If Analysis and Reporting

Jadwal Training 2015, Pusat Training, Jadwal Training Bulan Januari, Jadwal Training Bulan februari,jadwal training bulan maret, jadwal training bulan april,jadwal training bulan mei, jadwal training bulan juni, jadwal training bulan juli,jadwal training bulan agustus,jadwal training bulan september,jadwal training bulan oktober,jadwal training bulan desember, Informasi seminar 2015, Informasi jadwal Training 2016, info training 2017, jadwal training 2018 , Informasi Training 2015, Jadwal Training terbaru 2015, info seminar 2015, Info training 2015, Jadwal Seminar 2015, Jadwal training tahun 2015, Jadwal Workshop 2015, Info training indonesia 2015, Seminar Running 2015, Training Running 2015, In-House Training 2015, Pelatihan Running 2015, Provider Training di Yogyakarta, Provider Training di Jakarta, Provider Training di Surabaya, Provider Training di Balikpapan, Provider Training di Pontianak, Provider Training di Solo, Provider Training di Bandung, Provider Training di Bogor, Provider Training di Semarang, Provider Training Indonesia, Jadwal training di Yogyakarta , Jadwal training di Bandung , Jadwal training di Jakarta , Jadwal training di Bali , Jadwal training di Lombok , Jadwal training di Balikpapan , Jadwal training di Batam , Jadwal training di Riau , Jadwal training di Semarang , Jadwal training di Solo , Jadwal training di Pontianak , Jadwal training di Indonesia,info seminar,info training,informasi seminar,informasi training pusat informasi training

Permintaan brosur Lengkap, Harga dan Instruktur Training di Tahun ini, Hubungi kami  :
Via Email : / /
Via Sms atau WA : 0857 2459 5005
Course Description
 What most programs fail to do is link the various segments of the planning and implementation process of business. This program is different. You start with strategic planning to determine what direction the firm should take. Then you will develop a workable forecast based on your assumptions; move onto results focused budgeting from this forecast; then use the “what-if” tools based in Excel© to “test” you budget; and finally develop reports of the results for accountability. This program gives the delegates real tools that value their firm. Aims

  • The objectives of the program are such that on completion, the delegates should be able to:
  • Understand what is included in a solid strategic plan
  • How to develop supportable assumptions
  • Create realistic forecasts from solid assumptions
  • Use the forecasting tools build into Excel©
  • How the forecasting process leads to better budgeting
  • Options for budget development
  • How to run “what-if” scenarios to make better decisions
  • Link responsibility, authority & accountability using reporting
  • Develop needed reports that tell you what you need to know in a timely manner
  • How to use these reports to match strategic goals to actual performance
    Training Methodology

 The program will be conducted along with workshop principles with formal lectures, case studies, interactive worked examples. Relevant case studies will be provided to illustrate the application of each tool in an operations environment. Each learning point will be re-enforced with practical exercises. Difficult mathematical concepts are minimized wherever possible and handled in a visual way that is easy to understand with examples demonstrated. The Excel© tools will be demonstrated in a step-by-step process.

Course Objective
 Learning Outcomes

  • You will be able to further your professional skills
  • You will be able to make more informed and hence better corporate decisions
  • You will walk away with a comprehensive planning to implementation tool
  • You will be better placed to contribute to the overall success of your organization
  • You can teach your peers your new skills
  • The participants will become more aware of the importance of links between these critical areas
  • New skills of integration management will help to make more informed and hence better management decisions
  • Exposure to different techniques will help the company to efficiently collect and use the most critical data
  • Forecasting of cash flows will help the company in its day-to-day and long-range plans
  • The knowledge gained can be shared amongst other departments of the company

Who Should attend?
Everyone who is involved in strategic planning, forecasting, budgeting, reporting & measurements, to include:

  • Senior executives
  • Financial Professionals, Finance Controllers & Treasurers
  • Operating and Inventory Professionals
  • Any Professional, at a medium and senior level, who is a part of the decision making team
  • New interns and trainees with any of the above related responsibilities
Course Outline

  • What is strategic planning & why do it
  • Limitations of strategic planning
  • Specific problems associated with strategic planning
  • Assessment tools including SWOT, Porter’s 5-forces, GE & BCG models
  • Developing the plan & strategic objectives

   Mapping your strategy

  • Strategic Planning Process Flowchart
  • Competitive Analysis
  • SWOT Analysis
  • Strategic Goals
  • Why we have to plan before we forecast
    Introduction to Forecasting
  • What is forecasting?
  • Strategic role of forecasting
  • The forecasting process
  • Forecasting demand
  • Sales forecasting using various methods in Excel

    Qualitative Forecasting models

          Market surveys, Delphi, Life cycle analogy, Expert opinions, Sales force polling

   Quantitative Forecasting models

          How the FORECAST, GROWTH & TREND Functions in Excel© simplify the forecasting process

          The Components of a Time Series

   “What-if” analysis

  • What is Scenario analysis
  • What is Sensitivity analysis
  • What is Simulation analysis
  • What is Optimization

 What-if tools

  • How to develop random numbers using Excel©
  • How to use Goal Seek in Excel©
  • How to use Solver in Excel©

 Budgeting and the Management Process

  • What is a budget
  • Why & how is it different from a forecast
  • Budgets – the financial expression of the operating plan
  • The purpose of budgets – planning & control
  • Advantages and limitations of budgets

   The Framework for Budgeting

  • Elements of the budget framework
  • Types of budgets: flexible, zero-based, static
  • The pro forma financial statements
  • Operating versus non-operating revenue
  • Listing of major budgeting software
  • How to evaluate budgeting software

 Budgeting Costs and Expenses

  • Operating expenses – selling, G&A, R&D
  • Direct variable expenses
  • Indirect Fixed expenses
  • Assignable and non-assignable expenses

   Reporting & Meaningful Measurements

  • Variance analysis
  • Calculating different types of related variances
  • Performance measurement as a linking and integrating tool
  • The Balanced Scorecard
  • Operational
  • Financial
  • Customer
  • Learning & growth


  • Reporting
  • Internal – managerial
  • External – financial & regulatory

Linking it together

  • Linking strategic planning , forecasting budgeting and reporting
  • Reporting and performance analysis