Excellence Center — When The Excellence Is Must Request a proposal
Finance, Banking & Risk

Budgeting, Forecasting, Planning & Control

Plan, budget and control business performance. Participants build business and financial plans, forecast with qualitative and quantitative methods, prepare master budgets and responsibility centres, and control with variance analysis and rolling forecasts.

Tabby Lean Six Sigma group photo — Excellence Center training

At a glance

Catalog codeM02
Duration
  • 3 days
LevelPractitioner
Program typeProfessional Course
LanguageEnglish / Arabic
DeliveryIn-house · Public · Online

Who it's for

  • Directors
  • Department managers
  • Top management
  • Budget owners & finance staff

Learning objectives

  • Build business and financial plans
  • Forecast with qualitative and quantitative techniques and measure accuracy
  • Prepare a master budget and use responsibility centres
  • Control performance with budget-vs-actual variance analysis and rolling forecasts
  • Understand financial statements, ratios, CVP and capital budgeting

Detailed content

01Planning & Forecasting
  • Business plan & financial plans
  • Purpose of the forecast; analysing data
  • Qualitative & quantitative forecasting
  • Time series: moving averages, exponential smoothing, trend
  • Causal models: regression
  • Demand management
  • Forecast accuracy
02Financial Management Essentials
  • Role of financial management
  • Risk & return; CAPM
  • Time value of money (FV, PV)
  • Capital budgeting: payback, NPV, IRR
  • Capital structure
  • Working capital & cash conversion cycle
03Financial Statements & Analysis
  • Balance sheet, income statement, EBITDA
  • Cash flow statement
  • Ratio analysis: liquidity, asset management, debt, profitability
  • Cost-volume-profit & breakeven
04Budgeting & Control
  • Purpose of budgets & budgetary control cycle
  • Master budget
  • Responsibility centres
  • Variance analysis (budget vs actual)
  • Rolling forecasts & continuous planning
  • Workshop

Day-by-day agenda

A typical schedule. In-company versions are tailored to your processes, data and timing.

01Day 1
  • Planning & Forecasting
  • Financial Management Essentials
02Day 2
  • Financial Statements & Analysis
03Day 3
  • Budgeting & Control
  • Case study, action plans and course assessment

Practice, tools and assessment

Hands-on practice

  • Supply-chain mapping of one product family
  • ABC/XYZ inventory analysis and safety-stock calculation
  • Supplier evaluation and negotiation role play
  • Analyse a real set of financial statements with ratios

Tools and templates you keep

  • Inventory policy and safety-stock calculator (Excel)
  • Supplier scorecard template
  • S&OP meeting pack
  • Ratio-analysis and budgeting workbook

How learning is assessed

  • Pre- and post-course knowledge check
  • Assessment of practical exercises by the trainer
  • Action plan reviewed at the end of the course

Built on these standards and bodies of knowledge

  • ASCM (APICS) CPIM / CSCP Body of Knowledge
  • SCOR Digital Standard
  • CIPS procurement framework

Certificate

Excellence Center Certificate of Attendance

Verify a certificate

How it is delivered

  • Public courses in Cairo, in-company programs and live online training
  • Practical exercises, case studies and examples from your sector
  • Can also run as Train & Stay in Sharm El Sheikh, Hurghada or Cairo

Part of these career paths

FAQ

Frequently asked questions

How long is Budgeting, Forecasting, Planning & Control?

The program runs 3 days. In-company versions can be adapted to your needs.

Is the course taught in Arabic or English?

Sessions are usually delivered in Arabic with English technical terms and materials. Full English delivery is available for in-company groups.

Can you run it inside our company?

Yes. In-company programs use exercises built on your own processes. Tell us the group size and preferred timing and we will send a proposal.

Will I receive a certificate?

Participants who complete the program and its assessment receive a certificate from The Excellence Center, which can be verified online.

Get dates, fees and the full outline.

Tell us whether you are joining as an individual or planning a program for your team.