Workshop Budgeting, Forecasting, and The Planning Process

Kamis – Jumat, 13 – 14 Maret 2008, pukul 09:00 – 09:00 WIB
Ibis Hotel Slipi/Menara Peninsula Hotel

Workshop Description
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
  • 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 Study

Who Should Attend?
Finance Directors, Corporate Finance Managers, Heads Of Finance/Accounting, Kabag Perencanaan & Anggaran, Para Manajer Lini/Madya, dan Staf Operational yang terlibat dalam Perencanaan dan Pengendalian Anggaran/Laba perusahaan

Investasi : Rp 2.500.000,-
Include : Lunch, 2x Coffee Break, Modul, CD Modul, & Certificate Of Accomplishment

Course Leader

Dr. Darsono Prawironegoro, SE., SF., MA, MM.
Educational Background:

  • Doctor (S3) in Management from AIMS Honolulu-Hawaii, USA 2001,
  • Doctor (S3) in Education from State University of Jakarta 1999,
  • Magister (S2) in Antropology from University of Pancasila 1995,
  • S1 in Philosophy from University of Indonesia 1987,
  • S1 in Business Economy from University of Krisnadwipayana 1982,
  • Bachelor of Accountancy from University of Indonesia 1977.


  • Tutor in Magister Management Program in several Institutions 1996-now,
  • Nusantara Consulting Consultant in Financial Management and Human Resource 1993-now,
  • SGV-UTOMO/ Anderson Consulting Consultant in Financial Management and Cost Accounting training 1983-1992,
  • PT Samudra Perdana Financial Manager 1978-1983;
  • PT Intermodule Carriers Accounting Manager (Northwest Orient Airlines and Pakistan International Airlines) 1973-1978

Link lain :
Pendaftaran :


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s