Public-Sector Union Step-and-Lane Bargaining Cost, FLSA 207(k) OT & GASB 68/75 Schedule — Calculator, Excel Workpaper & API (BI-41)
Evaluates Collective-Bargaining Compounded COLA & Step-and-Lane Longevity Progression; FLSA 29 U.S.C. Sec. 207(k) Public-Safety 28-Day Tour Overtime & Regular-Rate Inclusion; GASB Statement No. 68 Net Pension Liability & +/-100 bps Discount-Rate Sensitivity; GASB Statement No. 75 OPEB Healthcare-Trend & 4-Year Fully Fringed Budget Impact. Submit: Bargaining Unit Headcount, Current Avg Base Salary, Proposed Annual Cola (%), Step Increment (%). Excel Tabs: CBA Arbitration Exec Sum, Step And Lane Transition Grid, FLSA 207k Overtime Roll Up, GASB68 75 Actuarial Bridge. 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: Multi-Year Collective-Bargaining COLA/Step Roll-Up, FLSA 29 U.S.C. 207(k) & GASB 68/75 Actuarial Filing
Official Agency Form / Workpaper Standard: CBA Step-and-Lane Costing / FLSA Sec. 207(k) / GASB 68 & 75 Fiscal Schedule
Governing Accounting, Tax & Statutory Authorities: D.C. Official Code §§ 1-617.01 to 1-617.17 (D.C. Comprehensive Merit Personnel Act — CMPA Collective Bargaining & Arbitration Factors); GASB Statements No. 68 & No. 75 (Pension & OPEB Actuarial Liability Accounting); FLSA 29 U.S.C. § 207(k) (Public Safety Overtime)
Common Practitioner & Search Aliases: CBA Step and Lane Cost Calculator, FLSA 207(k) Fire and Police Overtime, GASB 68 Pension Discount Sensitivity, GASB 75 OPEB Liability Roll-Up, Union Contract 4-Year Budget Costing
Interactive Public-Sector Union Step-and-Lane Bargaining Cost, FLSA 207(k) OT & GASB 68/75 Schedule Calculator (BI-41)
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 (4 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (2 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-41 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) Collective-Bargaining Compounded COLA & Step-and-Lane Longevity Progression [Public-Sector Collective Bargaining Financial-Plan Certification Statute]
- (2) FLSA 29 U.S.C. Sec. 207(k) Public-Safety 28-Day Tour Overtime & Regular-Rate Inclusion [29 U.S.C. Sec. 207(k) & 29 CFR Sec. 553.230 (171 Hrs Police / 212 Hrs Fire per 28 Days)]
- (3) GASB Statement No. 68 Net Pension Liability & +/-100 bps Discount-Rate Sensitivity [GASB Statement No. 68 Par. 42 & 78(g) Entry-Age Normal NPL Sensitivity Disclosure]
- (4) GASB Statement No. 75 OPEB Healthcare-Trend & 4-Year Fully Fringed Budget Impact [GASB Statement No. 75 OPEB Valuation & 4-Year Financial-Plan Certification]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Complete Bargaining-Unit Employee Census (Step, Grade/Lane, Hire Date, Longevity Date, Base Salary, Overtime & Shift Differential) | Structured JSON object/array or CSV text |
FILE-2 | Expired / Current Collective Bargaining Agreement (CBA), Union Cost Proposals & Management Counter-Proposals | Structured JSON object/array or CSV text |
FILE-3 | Latest GASB 68 Pension & GASB 75 OPEB Actuarial Valuation Reports + Healthcare Plan Premium & Claims Renewal Schedules | Structured JSON object/array or CSV text |
FILE-4 | Agency / Municipal 4-Year Financial Plan Budget, Vacancy/Turnover History & Peer-Jurisdiction Comparable Wage Survey | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 CBA Arbitration Exec Sum |
| Schedule 2 | 02 Step and Lane Transition Grid |
| Schedule 3 | 03 FLSA 207k Overtime RollUp |
| Schedule 4 | 04 GASB68 75 Actuarial Bridge |
| Schedule 5 | 05 CMPA 1 617 17 Peer Bench |
| Schedule 6 | 06 Position Roster OCFO 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-41/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-41",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})