BI-40 · Regulatory Defense, REA Quantum, USDA & Utility Rate-Design Suite

Municipal Water & Electric Utility Cost-of-Service, Rate-Design & Bond Coverage Schedule — Calculator, Excel Workpaper & API (BI-40)

Evaluates AWWA Manual M1 Cash-Needs & Utility-Basis Annual Rate Revenue Requirement; AWWA Manual M1 Base-Extra Capacity Peaking & Fire-Protection Functionalization; NARUC Customer-Class Cost-of-Service Allocation & Volumetric Rate Design; Senior Revenue-Bond Master Ordinance DSCR Covenant & Days Cash on Hand. Submit: Allowable Om Expense, Bond Covenant DSCR. Excel Tabs: Table1 Revenue Requirements, Table2 Base Extra Capacity Functionalization, Table3 Customer Units Of Service, Table4 Cost Of Service Allocation Matrix. 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: AWWA Manual M1 Base-Extra Capacity Functionalization, NARUC Class Allocation & Bond Ordinance DSCR Filing

Official Agency Form / Workpaper Standard: AWWA Manual M1 (7th Ed.) / NARUC Cost-of-Service & Revenue-Bond Coverage

Governing Accounting, Tax & Statutory Authorities: American Water Works Association (AWWA) Manual M1 (Principles of Water Rates, Fees, and Charges, 7th Ed.); NARUC Electric Utility Cost Allocation Manual; Governmental Accounting Standards Board (GASB 34 / GASB 62)

Common Practitioner & Search Aliases: AWWA M1 Water Rate Design Calculator, Base-Extra Capacity Peaking Allocation, NARUC Utility Cost of Service Study, Municipal Revenue Bond DSCR Test, Utility Days Cash on Hand

Live Zero-Code Statutory Calculator & .xlsx Builder

Interactive Municipal Water & Electric Utility Cost-of-Service, Rate-Design & Bond Coverage Schedule Calculator (BI-40)

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-40
Adopted Annual Revenue Requirement (USD)
$75,200,000.00
Residential Unit Rate Per Ccf (USD)
$4.30
Revenue Bond DSCR
1.68x
Days Cash On Hand
$288.90

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-40 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-136-Month Utility Fund Trial Balance, GASB 34/62 Annual Financial Report & Test-Year Operating & Maintenance (O&M) BudgetStructured JSON object/array or CSV text
FILE-2Utility Fixed-Asset Register (Original Cost, Accumulated Depreciation, CWIP) & 5-Year Capital Improvement Plan (CIP) + Bond SchedulesStructured JSON object/array or CSV text
FILE-324-Month Customer Billing & Metered Consumption Database by Rate Class, Meter Size (AWWA Equivalent Meter Ratios) & Peaking TierStructured JSON object/array or CSV text
FILE-4Current Approved Tariff Schedule, System Peaking-Factor Engineering Logs (Max-Day / Max-Hour) & Non-Rate Revenue LedgerStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 1Table1 Revenue Requirements
Schedule 2Table2 Base Extra Capacity Functionalization
Schedule 3Table3 Customer Units of Service
Schedule 4Table4 Cost of Service Allocation Matrix
Schedule 5Table5 Inclining Block Tariff Design
Schedule 6Table6 Indenture DSCR Reserve Test

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-40/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-40",
  "jurisdiction": "DE",
  "naics_or_sic": "541211",
  "structured_inputs": {}
})

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