(833) 272-6221

Overview

Client: A leading federal defense contractor within a publicly traded company. The engagement supported a must-win recompete valued at a multi-year, high-value recompete representing a significant share of the unit’s business.

Situation

The RFP spanned multiple years, hundreds of labor categories, three contract types (e.g., FFP/T&M/CPFF), and several performance locations. The client served as prime with over 70 subcontractors, each submitting Excel-based pricing with different CLIN structures and rates. The bid also required meeting strict workshare targets across SBA classifications (large, small, minority-owned, women-owned, etc.).

Objectives
  • Consolidate 75 sub-proposals with prime pricing into a single normalized model.
  • Run scenario analyses to optimize price while meeting SBA workshare
    targets. 
  • Produce a government-specified Excel template as the final submission package.
Approach
  • Data Intake & Standardization: Ingested each subcontractor Excel into SQL via Power Query; harmonized labor categories, indirects, and
    CLIN mappings.
  • Scenario Engine (SQL + Excel/VBA): Parameterized knobs for labor
    mix, location mix, fee structures, and workshare allocations; automated sweeps to identify a compliant low-price solution.
  • Compliance Layer: Embedded checks for SBA targets, contract-type
    rules, and rounding/tolerance per RFP.
  • Assembly & Output: Generated the official Excel pricing template (tabs, formulas, named ranges), ready for red-team review and
    submission.
Lowest
Compliant Bid

Optimized within RFP
constraints

75-1

Unified SQL pricing model

Win

Awarded; recognition for
impactful contribution

Tech stack: SQL SQL (schema + stored procedures), Excel (Power Query + VBA), optimization scenarios, validation rules, and automated export to Gov template.

Process Flow

From 75 disparate Excel files to a compliant, lowest-price submission.

Source Inputs

Transform & Normalize
Optimize & Validate
Submission Output
  • Sub Proposals (75) → Excel pricing, rate tables, CLINs
  • Power Query Intake → Load to SQL; standardize schemas
  • SQL Consolidation → Harmonize labor cats, indirects, fees
  • Scenario Engine → Labor/location mix, fee, workshare
  • Compliance → SBA targets, FAR, CAS and RFP
  • Final Assembly → Gov Excel template (formulas & links)
  • Submission → Red-team review & delivery
Highlights
  • Parametric pricing model delivered optimized workshare-
    compliant price.
  • Fully compliant with FAR, CAS and RFP requirements.
  • DCAA Audit-ready traceability.
Implementation Notes
  • Supports three contract types (FFP/T&M/CPFF) and multi-location burdens.
  • Supported over 18 months and three bid rounds.
Contact