BI-47 · National IRC Tax Code, Valuation & Municipal Finance Suite

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

Live Zero-Code Statutory Calculator & .xlsx Builder

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)
Showing verified Washington, D.C. baseline — edit any input and click Recalculate.

Computed Headline Statutory & Financial KPIs

Engine Code
BI-47
Dc Resident Hire Ratio
0.55
Dc Apprentice Hour Ratio
0.63
Annualized Fringe Credit Hr
$8.75
Davis Bacon Restitution (USD)
$23,800.00
First Source Net Penalty (USD)
$0.00

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:

2. Input Schema & Workpaper Output Schedules

Structured Input Datasets (structured_inputs)

Input SlotDataset / Trial-Balance ScheduleAccepted Format
FILE-1Executed D.C. First-Source Employment Agreement, Prime/Sub Contracts & Applicable SAM.gov Wage DeterminationsStructured JSON object/array or CSV text
FILE-2Weekly Certified Payroll Reports (DOL Form WH-347 / LCPtracker Exports) for Prime & Covered SubcontractorsStructured JSON object/array or CSV text
FILE-3Bi-Weekly ADP/Paychex Payroll Registers, Quarterly IRS Form 941s & ERISA Benefit Plan Contribution InvoicesStructured JSON object/array or CSV text
FILE-4DOES Job Bank Requisitions, Union Hall Referral Logs & OAIT Registered Apprenticeship CertificatesStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 1Summary Budget Bridge
Schedule 2DOES FirstSource 51Pct Test
Schedule 3WH347 Prevailing Wage Grid
Schedule 4DC Living Wage 2 220 03 Test
Schedule 5Sec2 219 5Pct Penalty Waiver
Schedule 6LCPtracker 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": {}
})

← Back to All 73 QuantLedger Accounting, Tax & SEC Engines