Treasury Management Best Practices

Objective:

• Implement advanced planning and control techniques into your budgeting process
• Integrate the budgeting process with the development of the company’s long-term strategic vision
• Provide a decision support structure that provides timely and useful information to decision makers
• Successfully build an integrated planning, budgeting and reporting process
• Forecast costs and revenues with greater confidence
• Apply management tools to the budgeting process that contribute to strategic goals
• Effectively manage the budgeting process
• Identify key performance indicators for effective and focused decision making
• Increase profitability and performance through streamlined planning and reporting

Budgets in Today’s International Environment

• Organizational Planning and Control Framework
• The Product / Information / Decision Support Cycle
• Strategic, Tactical, and Operational Forecasts
• The recognition of risk in Models
• Using Budget Models for Simulation Purposes
• The Drive toward Shareholder Value (EVA®)

The Strategic Plan

• The purpose of planning and budgeting in business
• Defining the strategic approach to business planning
• Defining strategic assumptions
• Building the strategic planning model using financial data
• Various strategic and tactical approaches to business planning
• Defining the Decision-Support model: Assumptions/Goals and Key Success Factors

Analyzing the Historical Data Using Excel®

• Recognizing the Basic Patterns Inherent in Historical Data
• Using the Exploratory Data Analysis Tools Available in Excel®
• Development of Time Series Models using histograms, moving averages, exponential smoothing, and regression analysis
• Using Regression Analysis as a predictor and estimator
• Mastering the use of Exponential Smoothing as a Data Analysis tool
• Single Regression vs. Multiple Regression
• Validation of Time Series Analysis

Approaches to Budget Development

• Zero Base Budgeting
• Activity-based Budgeting
• Rolling Budgets
• Operational Unit Budgeting
• Programme budgeting
• Developing the Cash Budget

Using Activity-Based Budgeting

• Developing the ABB application model
• Budgeting for Processes rather than Departments
• Defining Key Cost Drivers
• Defining Key Activities
• Development of ABB Cost Standards
• Developing the Activity-Based Budget

Strategic and Operational Cost Analysis Techniques

• Identifying fixed, variable, and semi-variable costs
• Application of Regression in the development of budgets
• Building the financial simulation model using articulated financial statements
• Building the financial simulation model using deterministic simulation
• Building the financial simulation model using probabilistic (Monte Carlo) simulation

Developing Manufacturing Standards

• Material Standard Development
• Labour Standard Development
• Factory and Corporate Overhead Standard Development
• Variance Analysis

Defining and Testing Optimization Techniques in Models Using Excel®

• Basic Structure of All Optimization Models
• Different Forms and Applications of Optimization Models
• Developing a Financial Optimization Model
• Performing Sensitivity Analysis of an Optimization Model
• Interpreting the Solution of an Optimization Model to a Non-technical Manager
• Lessons Learned and Lessons to be Learned