(833) 272-6221

Overview

Client: Large technical engineering services provider with long-term fixed-price contracts recognizing revenue via the percentage-of-completion (POC) method. The cornerstone input-Estimate-to-Complete (ETC) varied widely in quality and process across programs.

Situation

Programs used inconsistent methods and tools to calculate ETC. Manual processes led to delays and inaccuracies, making it difficult to evaluate performance against budgets and determine the correct monthly revenue/profit recognition.

Objectives
  • Standardize ETC calculation across all programs and hierarchy levels.
  • Reduce manual effort and error risk; enable quick quality checks.
  • Support POC revenue recognition with timely, accurate inputs.
Approach
  • Data Access: SQL + ODBC connections to Deltek Costpoint to pull actuals by project/WBS level.
  • Excel UX (VBA): One-click selection of any project/hierarchy; renders a monthly trend matrix by major Revenue and Cost elements.
  • Drill-Through: Double-click any cell to auto-generate a Pivot Table with transaction-level detail for that number.
  • Budget Option: Incorporate calendarized budget for the selected level to support forecast validation and variance analysis.
Standardized

Company-wide ETC process

| Manual Work

Automation + drill-through

Faster Close

Timely POC revenue inputs

Tech stack: SQL + ODBC to Deltek Costpoint, Excel (VBA, Pivot), calendarized budgets, monthly trend matrices by revenue/cost elements.

Process Flow

From Costpoint actuals to standardized ETC and POC revenue inputs.

Source System

Transform & Prepare
Analyze & Validate

Outputs

  • Costpoint Extracts →Actuals by project/WBS & elements
  • Trend Matrix → Monthly revenue/cost by element
  • Drill-Through Pivot → Transaction-level validation
  • Budget Overlay → Calendarized plan for variance checks
  • Standardized ETC → Inputs to POC revenue recognition
Highlights
  • Single, consistent ETC methodology used across programs and levels.
  • Quality checks built into the drill-through to spot errors/omissions.
  • Improves accuracy of monthly revenue and margin recognition.

Implementation Notes

  • Parameterized pulls by Project/WBS.
  • Month-by-Month Trend.
  • One-Click Drilldown.
Contact