GovCon Uncompensated Overtime Dilution, 50% Subcontracting Cap & Pass-Through Audit — Calculator, Excel Workpaper & API (BI-08)
Evaluates DCAA CAM 6-410 Total-Time Accounting Effective Hourly Rate Dilution & Proration; 13 CFR Sec. 125.6 Limitations on Subcontracting (50% Services Cap & SSE Exclusion); FAR 52.215-23 Excessive Pass-Through Charge Audit (>70% Subcontract Threshold); Direct Labor Utilization, Funded Backlog Burn Coverage & Schedule I Billing Reconciliation. Submit: Exempt Ftes, Standard Weekly Hours, Actual Weekly Hours Worked, Avg Annual Salary (USD). Excel Tabs: Exec Labor Workshare, DCAA CAM 6 410 UCOT, FAR 52 215 23 Pass Thru, Cleared Bench Burn Model. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: DCAA CAM 6-410 Total-Time Accounting, 13 CFR Sec. 125.6 Workshare & FAR 52.215-23 Pass-Through Exhibit
Official Agency Form / Workpaper Standard: DCAA CAM 6-410 / 13 CFR Sec. 125.6 / FAR 52.215-23 Compliance Schedule
Governing Accounting, Tax & Statutory Authorities: FAR 52.215-22 / 52.215-23 (Limitations on Pass-Through Charges); DCAA CAM 6-410 (Uncompensated Overtime); 13 CFR § 125.6 (Limitations on Subcontracting / Ostensible Subcontractor)
Common Practitioner & Search Aliases: Uncompensated Overtime Calculator, DCAA Total Time Accounting, Limitations on Subcontracting 50% Rule, Similarly Situated Entity Workshare, FAR 52.215-23 Pass-Through Audit
Interactive GovCon Uncompensated Overtime Dilution, 50% Subcontracting Cap & Pass-Through Audit Calculator (BI-08)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-08 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) DCAA CAM 6-410 Total-Time Accounting Effective Hourly Rate Dilution & Proration [DCAA Contract Audit Manual (CAM) Section 6-410.4 (Method A Pro-Rata Allocation) & FAR 31.201-4]
- (2) 13 CFR Sec. 125.6 Limitations on Subcontracting (50% Services Cap & SSE Exclusion) [13 CFR Sec. 125.6(a)(1), FAR 52.219-14 & 15 U.S.C. Sec. 645(d) Subcontracting Penalties]
- (3) FAR 52.215-23 Excessive Pass-Through Charge Audit (>70% Subcontract Threshold) [FAR 52.215-22 & FAR 52.215-23 (Limitations on Pass-Through Charges — 70% Trigger)]
- (4) Direct Labor Utilization, Funded Backlog Burn Coverage & Schedule I Billing Reconciliation [FAR 52.232-22 (Limitation of Funds), FAR 42.704 Provisional Billing Rates & DCAA ICE Schedule I]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 12-Month Employee Timecard Export (Daily Billable, Indirect, B&P, Bench & Uncompensated OT Hours) | Structured JSON object/array or CSV text |
FILE-2 | Cleared Personnel Roster (Clearance Level: Secret/TS-SCI, Billet Assignment, Base Salary & Labor Category) | Structured JSON object/array or CSV text |
FILE-3 | Prime-to-Subcontractor Billing & Cost-Split Ledger by Task Order and CLIN | Structured JSON object/array or CSV text |
FILE-4 | Executed Subcontract Agreements, Teaming Agreements & Prime Task-Order PWS Documents | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Exec Labor Workshare |
| Schedule 2 | 02 DCAA CAM 6 410 UCOT |
| Schedule 3 | 03 FAR 52 215 23 PassThru |
| Schedule 4 | 04 Cleared Bench Burn Model |
| Schedule 5 | 05 Workshare Rebalance Queue |
| Schedule 6 | 06 Timesheet Payroll TieOut |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-08/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-08",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})