Budgeting, Forecasting and the Planning Process

 Jadwal training 2015 | Jadwal training 2016 | Jadwal training 2017 | Jadwal training 2018 | Jadwal training 2019 | Jadwal training 2020

Budgeting, Forecasting and the Planning Process


A budget is a road map of the journey a company is planning to take. It is a quantification of the activities the company must perform to arrive at its destination as specific in its Strategic Plan. Excel?? is the toolbox of choice for model development. Put these two concepts together, and you have THE leading-edge budgeting and forecasting course available. This program explains the budgeting process from beginning to end. It looks at budget development, how decisions affect the “bottom line,” and what budget variances are saying. At the same time, you will learn how to use the leading-edge tools available on Excel??.


You will learn the importance of incorporating the mission and goals of the company into departmental budget development. Using a wide array of budgeting techniques, you will leave this program with the tools, techniques and confidence to develop budget models that not only reflect the true cost of the resources required, but also give you the ability to explore alternatives using tools as Solver, Scenario, Goal Seek, Regression, and other statistical techniques. You will explore the issues relating to capital budgeting. Budgeting manufacturing as well as other expenses, identifying profit objectives, budgeting cash requirements and building the financial statements is also covered.


  • Budgets in Today’s International Business Environment
  • Overview of the strategic, tactical, and operational aspects of today’s global business entity
  • The Organizational Planning Model
  • The Product/Decision/Information Cycle
  • The objectives of Financial Analysis
  • The Strategic Vision as a Budgeting Tool
  • Development of the long-range vision
  • Focusing the Vision
  • Creation of Definable, Measurable Objectives
  • Development of the Key Performance Indicator Matrix
  • Identification of required activities, resources, and consumption rates

Case Exercise – Part I

In order to enhance the learning process, and to provide a structured environment to reinforce the skills learned in each section, you will work as part of an management team, developing a real budget of a real process.

  • The Budgeting Process – The Nine-Step Budgeting Model??
  • The Nine-Step Budgeting Model
  • The principles of Activity-Based Budgeting
  • The role of assumptions in the budget model
  • Projecting Headcount
  • Projecting the cost of Employee Benefits
  • Accounting for Depreciation in the Budget Model
  • Fixed, Variable and Mixed Expenses
  • Discretionary Expenses
  • Projecting Revenues – The Sales Budget
  • Projecting Revenues
  • Using Excel?? to project optimum product mix
  • Projecting sales volume
  • Projecting new product introduction and speed to market
  • Developing the bases for cost projections using revenue assumptions

Case Exercise – Part II

  • The Nature and Behavior of Costs
  • The behavior of costs
  • Fixed Costs
  • Variable Costs
  • Mixed Costs
  • Non-Cash Expenses
  • Cost / Volume / Profit Analysis
  • Projecting Expenses
  • Projecting costs in unique cost categories including ; travel, outside services, and communication costs
  • Using Activity-Based Budgeting to project expenses
  • Applying the Key Performance Indicator Matrix to the Budget Development Model
  • Identification of activities critical to objective achievement
  • Determining resources requirements
  • The Time Value of Money
  • The impact time has on the value of money.
  • Understand the various interest calculations
  • Using WACC and ROIC as benchmarks
  • Use Excel??, to determine Present Value, Future Value, Net Present Value, Internal Rate of -Return, Modified Internal Rate of Return
  • Using MIRR and a basis for capital project evaluation

Case Exercise – Part III


Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta (jogja, Solo, Semarang) Quota minimum Running 3 peserta ( Jakarta & Bandung) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

Lokasi Training (Tentative) dengan harga yang berbeda

  • Hotel Santika Kuta, Bali
  • Hotel Nagoya Plaza, Batam
  • Hotel Fave, Balikpapan
  • Hotel Aston, Manado
  • The Santosa Villas and Resort, Lombok
  • Hotel Gino Ferucci, Bandung
  • Hotel Santika Pandegiling, Surabaya
  • Hotel Fave Pasar baru Jakarta, Jakarta
  • Hotel Ibis Solo
  • Hotel Aston, Pontianak
  • Hotel Ibis Simpang Lima, Semarang
  • Hotel Ibis Malioboro, Yogyakarta



Permintaan Brosur penawaran Training silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Blog : https://informasitrainingdanseminar.wordpress.com

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id

Powered byEMF Free Form Builder