Mobile Edition

Financial Modeling and Driver-Based Planning (4172588B)

Date:Friday, March 23, 2018
Time:11:30AM - 7:00 PM
(Registration at 11:00AM)
Facility:Webcast or Webinar, Online
CPE Credit:8.0 Accounting and Auditing
Instructor: Dennis Geyer
Vendor:California CPA Education Foundation
Course Level:Intermediate
Early Bird Price:$245.00 FICPA Members, $365.00 Non-Members


The importance of cost management tools able to yield a competitive advantage is no secret. Various financial modeling tools—including Excel's Regression and Solver tools are being used in financial planning and analysis, as these new tools allow managers to better manage costs by revealing the drivers affecting costs. Learn the basic concepts and principles necessary to build driver-based financial models and use them to improve cost management.

Formerly titled: Activity-Based Costing: A Resource Consumption Approach

  • Recognize the limitations of traditional cost accounting
  • Identify and validate cost drivers using regression analysis
  • Determine the impact of these drivers using multi-driver cost-volume-profit analysis
  • Uncover hidden profits using a resource-consumption-based approach to ABC
  • Develop driver-based planning systems to enhance cost reduction efforts
  • Show why resource consumption-based cost measurement, not GAAP costing, is essential for success

Major Topics:
  • Key features of Driver-Based Planning
  • Cost decomposition analysis using REGRESSION tool
  • Driver-based modeling using SOLVER tool
  • Multi-driver budgeting for more accurate planning
  • The importance of managing idle capacity
  • Cycle-time reduction and process value analysis

Who Should Attend:

CPAs, CFOs, controllers, financial analysts and accountants who want to offer value-added services for their clients or employers.

Basic knowledge of Excel.

Advanced Preparation:


If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.