Davis-Bacon Certified Payroll (Form WH-347), Prevailing Fringe & Local-Hire Compliance Audit — Calculator, Excel Workpaper & API (BI-47)
Evaluates D.C. First Source 51% Resident New-Hire & 60% Apprentice Hours Thresholds; 29 CFR Sec. 5.25 Bona Fide Fringe Annualization & Prevailing Wage Restitution; D.C. First Source 5% Covered-Labor Penalty & DOES Good-Faith Waiver Offset; DOL Form WH-347 Certified Payroll to IRS Form 941 Line 5c Reconciliation. Submit: Hires Dc, Hires Total, Hrs Appr Dc, Hrs Appr Total. Excel Tabs: Summary Budget Bridge, DOES First Source 51Pct Test, WH347 Prevailing Wage Grid, DC Living Wage 2 220 03 Test. 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: 40 U.S.C. Sec. 3142 Davis-Bacon DOL Form WH-347 Wage/Fringe Restitution & Local-Hire Penalty Schedule
Official Agency Form / Workpaper Standard: U.S. DOL Form WH-347 Certified Payroll & Prevailing-Wage Fringe Schedule
Governing Accounting, Tax & Statutory Authorities: D.C. Official Code § 2-219.03 (First-Source Employment Agreement); D.C. Official Code § 2-220.03 (Living Wage Act); 40 U.S.C. § 3142 & 29 CFR Part 5 (Davis-Bacon WH-347)
Common Practitioner & Search Aliases: Davis-Bacon WH-347 Payroll Calculator, Prevailing Wage Cash-in-Lieu of Fringe, Certified Payroll Restitution Back-Pay, 51% First-Source Local Hire Audit, Living Wage Contract Compliance
Interactive Davis-Bacon Certified Payroll (Form WH-347), Prevailing Fringe & Local-Hire Compliance Audit Calculator (BI-47)
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-47 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) D.C. First Source 51% Resident New-Hire & 60% Apprentice Hours Thresholds [D.C. Official Code Sec. 2-219.03(e)(1) & (1A)]
- (2) 29 CFR Sec. 5.25 Bona Fide Fringe Annualization & Prevailing Wage Restitution [40 U.S.C. Sec. 3142 & 29 CFR Secs. 5.5, 5.25-5.31]
- (3) D.C. First Source 5% Covered-Labor Penalty & DOES Good-Faith Waiver Offset [D.C. Official Code Sec. 2-219.03(e)(4) & Living Wage Sec. 2-220.03]
- (4) DOL Form WH-347 Certified Payroll to IRS Form 941 Line 5c Reconciliation [29 CFR Sec. 5.5(a)(3)(ii), DOL Form WH-347 & IRS Form 941 Line 5c]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Executed D.C. First-Source Employment Agreement, Prime/Sub Contracts & Applicable SAM.gov Wage Determinations | Structured JSON object/array or CSV text |
FILE-2 | Weekly Certified Payroll Reports (DOL Form WH-347 / LCPtracker Exports) for Prime & Covered Subcontractors | Structured JSON object/array or CSV text |
FILE-3 | Bi-Weekly ADP/Paychex Payroll Registers, Quarterly IRS Form 941s & ERISA Benefit Plan Contribution Invoices | Structured JSON object/array or CSV text |
FILE-4 | DOES Job Bank Requisitions, Union Hall Referral Logs & OAIT Registered Apprenticeship Certificates | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Summary Budget Bridge |
| Schedule 2 | DOES FirstSource 51Pct Test |
| Schedule 3 | WH347 Prevailing Wage Grid |
| Schedule 4 | DC Living Wage 2 220 03 Test |
| Schedule 5 | Sec2 219 5Pct Penalty Waiver |
| Schedule 6 | LCPtracker Form941 GL 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-47/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-47",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})