From Dates to Dollars: Advanced Cost Modeling in MS Project

Content Restricted

Sign up for MPUG Membership to view this on-demand webinar and get unlimited access to our Webinars

Event Description:

Microsoft Project is great for managing timelines—but what about real cost? If you’re still exporting to Excel or struggling with cost reconciliations, this session is for you.

Join Eric and Jeff Christoph for the next webinar in their advanced project controls series, where they’ll show you how to turn MS Project into a dynamic cost modeling platform. You’ll learn how to model direct, burdened, and fully loaded costs using cost rate tables, Excel imports, and VBA automation—all inside your schedule. This technique solves the classic “penny problem” and eliminates the frustrating gap between what your schedule shows and what your pricing system or EVM tool expects.

Whether you’re preparing proposals, building baselines, or managing real-time forecasts, this webinar will give you the tools to model accurate labor and material costs directly in Microsoft Project—no workarounds, no external systems, no surprises.

Learning Objectives:

  • Understand how to model direct, burdened, and fee-inclusive labor rates in Microsoft Project
  • Learn how fringe, overhead, G&A, and fee are calculated and why precision matters
  • Discover how to use MS Project cost rate tables (A–E) for real-time cost scenario modeling
  • Identify the pitfalls of fixed cost entries and how to avoid breaking your cost logic
  • Use VBA automation to import precision rates from Excel directly into MS Project
  • Model non-labor costs like materials and subcontractors using material resources and cost tables
  • Compare and reconcile your schedule costs with proposals, EV systems, and financial models
  • Streamline baseline creation, change management, and cost forecasting without leaving MS Project

PMI PDUs: 1 Ways of Working, 0 Business Acumen, 0 Power Skills

Presentation Materials

Written by Jeffrey Christoph
Jeffrey Christoph is a subject matter expert in project management, project controls, Earned Value Management Systems (EVMS), and business process optimization. He specializes in delivering practical, scalable solutions that integrate advanced technology with robust management practices. As co-founder and technical lead at Transformative Management Solutions, Jeff continues to lead development efforts on modern, scalable project control solutions including the TMS Project Foundational Framework and Djobu EVMS. His approach combines hands-on technical expertise with strategic process improvement. Previously, Jeff served as Corporate Senior Director of Business Operations at Leonardo DRS, where he led the design and deployment of a corporate-wide EVMS across eight business units. His work culminated in a successful DCMA-compliant EVMS rating for the Naval Electronics business unit—a first for the company’s ~$3 billion defense sector. Jeff’s background includes consulting for large-scale PMOs and EVMS implementations and executive roles at L-3 Communications, where he focused on international program development and integrated project control systems. Technical Expertise MS Project (Online, Server, Professional) Microsoft Power Platform (Power BI, PowerApps, Dataverse) Software Development and Design (VBA, Power Query, DAX, C#)
Share This Post
Have your say!
40

Leave a Reply