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
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)
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-40 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) AWWA Manual M1 Cash-Needs & Utility-Basis Annual Rate Revenue Requirement [AWWA Manual M1 Principles of Water Rates, Fees & Charges (7th Ed.) Ch. II]
- (2) AWWA Manual M1 Base-Extra Capacity Peaking & Fire-Protection Functionalization [AWWA Manual M1 Ch. III.4 Base-Extra Capacity Cost Functionalization Method]
- (3) NARUC Customer-Class Cost-of-Service Allocation & Volumetric Rate Design [NARUC Electric & Water Utility Cost Allocation Manuals — Class Equitability Standard]
- (4) Senior Revenue-Bond Master Ordinance DSCR Covenant & Days Cash on Hand [Municipal Utility Revenue-Bond Trust Indenture Rate Covenant & Rating-Agency Liquidity Test]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 36-Month Utility Fund Trial Balance, GASB 34/62 Annual Financial Report & Test-Year Operating & Maintenance (O&M) Budget | Structured JSON object/array or CSV text |
FILE-2 | Utility Fixed-Asset Register (Original Cost, Accumulated Depreciation, CWIP) & 5-Year Capital Improvement Plan (CIP) + Bond Schedules | Structured JSON object/array or CSV text |
FILE-3 | 24-Month Customer Billing & Metered Consumption Database by Rate Class, Meter Size (AWWA Equivalent Meter Ratios) & Peaking Tier | Structured JSON object/array or CSV text |
FILE-4 | Current Approved Tariff Schedule, System Peaking-Factor Engineering Logs (Max-Day / Max-Hour) & Non-Rate Revenue Ledger | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Table1 Revenue Requirements |
| Schedule 2 | Table2 Base Extra Capacity Functionalization |
| Schedule 3 | Table3 Customer Units of Service |
| Schedule 4 | Table4 Cost of Service Allocation Matrix |
| Schedule 5 | Table5 Inclining Block Tariff Design |
| Schedule 6 | Table6 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": {}
})