Loading...
HomeMy Public PortalAboutExhibit MSD 4 - Rate Model TablesExhibit MSD 4 L Metropolitan St Louis Sewer District 2010/2011 Rate Change Proceedings FINAL REPORT TABLES Black & Veatch Enterprise Management Solutions Thursday, May 05, 2011 Table 2-1 Historical and Projected Wastewater and Stormwater Operating Costs Line Historical Projected No Departmen t 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ $ $ $ $ $ 1 Bo ard of Trustees 6,761 5,617 5,298 1,908 2,210 2,800 2,900 3,000 3,100 3,200 3,300 2 Rate Commissio n (a) 47,287 288,269 202,300 0 0 461,100 9,400 9,700 10,100 610,600 11,100 3 Civil Service Commission 1,297 833 80 720 4,874 8,700 8,700 8,700 8,700 8,700 8,700 4 Secretary - Treasurer 1,433,320 1,450,035 1,659,105 1,765,161 1,321,436 1,806,200 1,875,100 1,941,500 2,031,700 2,119,800 2,209,200 5 Execu tive D irector 669,301 698,123 828 ,392 830,546 815,651 832,500 864,400 897,600 936,400 971,600 1,006,800 6 General Coun sel 1,486,452 1,979,490 2,558,656 3,171,606 3,572,890 4,548,800 4,713,300 4,866,300 5,085,600 5,307,100 5,535,700 7 Office of Human Resources 8,093,929 9,424,411 10,402,905 10,734,282 10,155,972 11,304,200 11,831,800 12,371,000 13,023,600 13,697,000 14,289,800 8 Engineering 18,687,163 19,670,310 21,408,451 23,247,149 22,986,895 21,681,200 22,437,400 23,180,900 24,025,900 24,729,400 25,370,600 Operation s 9 Collectio n System (b) 18,610,464 20,247,562 21,624,448 25,608,969 27,855,739 27,940,200 28,575,400 29,479,300 30,630,400 31,544,300 32,476,500 10 Pu mp Statio ns 6,966,237 7,039,838 7,906,556 8,141,303 9,027,409 8,662,600 8,969,300 9,282,900 9,718,100 10,143,900 10,572,700 11 Wastewater Treatment (c) 27,602,538 29,967,415 30,580,839 31,408,004 34,081,127 35,427,500 36,664,600 37,941,900 39,675,900 41,366,200 43,068,600 12 Su pport (d) 6,078,589 7,353,417 8,826,265 8,122,756 9,185,706 8,655,000 8,977,200 9,315,700 9,691,400 10,044,700 10,391,200 13 Total Operation s 59,257,827 64,608,231 68,938,108 73,281,033 80,149,981 80,685,300 83,186,500 86,019,800 89,715,800 93,099,100 96,509,000 14 Fin ance 14,161,194 15,118,859 15,910,647 16,327,007 14,788,793 15,885,700 15,985,700 16,144,500 16,590,800 17,114,800 17,738,000 15 In formation Systems 6,063,356 6,333,702 7,428,031 8,579,784 10,524,829 9,835,600 10,195,900 11,766,400 12,598,400 11,406,300 11,815,400 16 Su btotal (General Fu nd) 109,907,887 119,577,880 129,341,973 137,939,196 144,323,531 147,052,100 151,111,100 157,209,400 164,030,100 169,067,600 174,497,600 17 Water Backup Program 4,858,510 3,608,165 7,439,436 6,817,000 4,500,000 4,000,000 4,300,000 5,000,000 5,000,000 5,000,000 5,000,000 18 Rea l Property Fun d (e) 1,380,134 2,683,682 987,728 836,749 702,612 1,081,000 1,113,400 1,146,800 1,181,200 1,216,700 1,253,200 19 Su btotal O&M 116,146,531 125,869,727 137,769,137 145,592,945 149,526,143 152,133,100 156,524,500 163,356,200 170,211,300 175,284,300 180,750,800 20 Additional O&M NA NA NA NA NA 0 0 112,400 2,159,800 7,484,100 7,942,500 21 Total O&M 116,146,531 125,869,727 137,769,137 145,592,945 149,526,143 152,133 ,100 156,524,500 163,468,600 172,371,100 182,768,400 188,693,300 22 Capital Outla y 3,991,300 4,927,857 7,178,561 4,686,456 3,016,623 2,904,900 3,006,600 3,096,700 3,189,600 3,285,300 3,383,900 23 Total Operating Expen se 120,137,831 130,797,584 144,947,698 150,279,401 152,542,766 155,038,000 159,531,100 166,565,300 175,560,700 186,053,700 192,077,200 (a) Rate proceedings are anticipated to take place once every fo ur years. (b) Includes Mintert, Su lphu r, an d Grand Glaize main tenance yards and technical services. (c) Includes Lemay, Bissell, and coun ty treatment plants which inclu des Coldwater Creek, Missouri River, Lower Meramec River, Grand Glai ze, and Fenton . (d) Includes costs related to the cu stomer care grou p, administrative support and materials management. (e) Expen ditu res are partia lly o ffset by rental in co me. Table 2-2 Allocation of Direct Operating Costs Between Wastewater and Stormwater Wastewater Stormwater Direct Direct Indirect Personnel Services Administration and Management Board of Trustees 0.0% 100.0% Rate Commission 0.0% 100.0% Civil Service Commission 0.0% 100.0% Office of Secretary - Treasurer 0.0% 100.0% Executive Director 0.0% 100.0% Office of General Counsel 0.0% 100.0% Office of Human Resources 0.0% 100.0% Engineering 83.9% 16.1% 0.0% Operations Collection System 70.0% 30.0% 0.0% Pump Stations 90.0% 10.0% 0.0% Wastewater Treatment 100.0% 0.0% 0.0% Support 73.0% 15.0% 12.0% Finance 48.6% 0.0% 51.4% Information Systems 0.0% 0.0% 100.0% All Other Administration and Management Board of Trustees 0.0% 100.0% Rate Commission 0.0% 100.0% Civil Service Commission 0.0% 100.0% Office of Secretary -Treasurer 0.0% 100.0% Executive Director 0.0% 100.0% Office of General Counsel 0.0% 100.0% Office of Human Resources 0.0% 100.0% Engineering 85.0% 15.0% 0.0% Operations Collection System 70.0% 30.0% 0.0% Pump Stations 90.0% 10.0% 0.0% Wastewater Treatment 100.0% 0.0% 0.0% Support 84.0% 15.0% 1.0% Finance 95.9% 0.0% 4.1% Information Systems 0.0% 0.0% 100.0% Utilities Operations Pump Stations 95.0% 5.0% 0.0% Wastewater Treatment 100.0% 0.0% 0.0% Table 2-3 Hist orical and Pr ojected Other Operating Revenue Line Historical Projected No. D escription 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ $ $ $ $ $ 1 Billing A dju stment (a) 5,266,793 5,497,203 7,122,194 8,226,882 4,725,609 4,597,600 4,579,400 4,576,000 4,586,000 4,599,400 4,615,500 2 Bad D ebt Prov ision (3,160,972) (4,193,703) (5,161,982) (9,678,495) (10,187,508) (10,910,900) (6,820,800) (8,998,500) (10,055,400) (11,262,000) (12,613,400) Other Fees 3 Construction In spection Fees 548,146 714,673 519,654 288,991 233,812 200,000 206,000 212,200 218,600 225,200 232,000 4 Waste H auler Permits 1,080,132 1,092,556 1,174,653 1,274,743 1,460,349 1,450,000 1,457,300 1,464,600 1,471,900 1,479,300 1,486,700 5 A ll OtherFees(b) 490,171 544,570 697,236 771,495 705,833 630,000 649,000 668,600 688,700 709,400 730,600 6 Subtotal 2,118,449 2,351,799 2,391,543 2,335,229 2,399,994 2,280,000 2,312,300 2,345,400 2,379,200 2 ,413,900 2,449,300 7 Miscellaneous Revenue (c) 2, 097, 809 5,739,495 10,636,801 1,887,856 2,500,311 3,752,200 3,792,800 3,842,400 3,893,500 3,946,100 4,000,300 8 Total Other Operatin g Revenue 6,322,079 9,394,794 14,988,556 2,771,472 (561,594) (281,100) 3,863,700 1,765,300 803,300 (302,600) (1,548,300) 9 Co nnection Fee R ev en ue (d) 3,096,339 3,906,218 2,021,472 1,144,092 1,035,016 1,250,000 1,288,000 1,327,000 1,367,000 1,408,000 1,450,000 10 Total Other Reven ue 9,418,418 13,301,012 17,010,028 3,915,564 473,422 968,900 5,151,700 3,092,300 2,170,300 1,105,400 (98,300) (a) Includes Late Cha rges, Billed Accou nt Refun ds, A dju stments, Wastewater Lien Interest a nd Fees, and Other Adjustments i ncluding revenue from Arnold . (b) In clu des Plan Rev iew Fees, Su bmitta l Fees, Wastewater Mon itoring Cost Fees, Pretreatment Discharge Permits, and all other fees . (c) Includes Reimbursemen ts, Sale of Fixed A ssets, Reimbursable Engin eerin g & Maintenance, re ntal i ncome and all other miscellaneous reve nue. (d) Revenue available for improvements financed out of the Improvement Fund. Table 2-4 Allocation of Other Operating Revenue Between Wastewater and Stormwater Wastewater Stormwater Allocation Allocation Connection and Other Fees Construction Inspection Fees 50.0% 50.0% Plan Review Fees 50.0% 50.0% Submittal Fees 50.0% 50.0% Waste Hauler Permits 100.0% 0.0% Wastewater Monitoring Costs Fees 100.0% 0.0% Pretreatment Discharge Permits 100.0% 0.0% All Other Machine Tap Fees 100.0% 0.0% Conn Permits and Insp. 50.0% 50.0% Construction Permits Fees 50.0% 50.0% Miscellaneous Revenue Reimbursements Reimbursement of District Costs 100.0% 0.0% Other Reimbursements 100.0% 0.0% Reimbursement of Engr., Survey, Inspection, and Other Engr. Costs 90.0% 10.0% Sale of Fixed Assets 100.0% 0.0% Rental Income 80.0% 20.0% All Other Sale of Scrap (Metal, Paper) 90.0% 10.0% Provision for Doubtful Misc. Receivables 90.0% 10.0% Engineering Prints and Specifications 90.0% 10.0% Refund of Court Cts & Attorney fees 90.0% 10.0% Liquidation of Contractual Encumbrances 90.0% 10.0% NSF Fees 90.0% 10.0% Miscellaneous Income 90.0% 10.0% Forfeited Deposits 90.0% 10.0% Project Bid Fees 90.0% 10.0% Wastewater Revenue Adjustments Late Charges 99.0% 1.0% Billed Account Refunds 99.0% 1.0% Adjustments 99.0% 1.0% Bad Debt Provision 100.0% 0.0% City of Arnold WWT 100.0% 0.0% NSF Fees 99.0% 1.0% Wastewater Lien Interest and Fees 99.0% 1.0% Other (Includes revenue from Arnold) 99.0% 1.0% Capital Improvement Related Miscellaneous Revenue Connection and Other Fees Construction Funds Caulks Creek Surcharge 100.0% 0.0% Williams Creek 100.0% 0.0% Improvement Fund Connection Fees 100.0% 0.0% Miscellaneous Revenue Construction Funds 100.0% 0.0% Liquidation of Contractual Encumbrances 100.0% 0.0% Special Funds (Except WBU Fund) 100.0% 0.0% Table 3-1 Historical and Pr ojected Wastewater Cust omer Acc ounts Line No. Customer Class Historical Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Metered Customers 1 Sin gle Family 301,122 302,582 302,694 302,843 303,096 302,300 302,100 302,100 302,100 302,100 302,100 2 Multifamily 20,825 20,816 20,824 20,862 20,787 20,800 20,700 20,700 20,700 20,700 20,800 3 N on -R esidentia l 25,712 25,620 25,583 25,387 25,165 25,100 24,900 24,800 24,800 24,700 24,700 4 T otal 347,659 349,018 349,102 349,092 349,048 348,200 347,700 347,600 347,600 347,500 347,600 U nmetered Cu stomers 5 Sin gle Family 60,010 59,977 59,733 58,757 58,034 57,400 56,800 56,400 56,200 56,200 56,200 6 Multifamily 23,757 23,818 23,780 20,437 19,938 20,000 19,700 19,500 19,400 19,400 19,400 7 Total 83,767 83,795 83,513 79,194 77,972 77,400 76,500 75,900 75,600 75,600 75,600 Total Custo mer Accounts 8 Single Family 361,132 362,559 362,427 361,601 361,130 359,700 358,900 358,500 358,300 358,300 358,300 9 Mu ltifamily 44,582 44,634 44,605 41,299 40,725 40,800 40,400 40,200 40,100 40,100 40,200 10 Non -Residential 25,712 25,620 25,583 25,387 25,165 25,100 24,900 24,800 24,800 24,700 24,700 11 Total 12 An nual Percentage Increa se 431,426 432,813 432,616 428,287 427,020 425,600 424,200 423,500 423,200 423,100 423,200 0.4% 0. 3% 0. 0% -1 .0% -0.3% -0 .3% -0.3% -0 .2% -0.1% 0.0% 0.0% Table 3-2 Historical and Projected Contributed Wastewater V olume Lin e N o. Customer Class Historical Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Ccf Ccf Ccf Ccf Ccf Ccf Ccf Ccf Ccf Ccf Ccf Metered Cu stomers 1 Single Family 27,437,644 26,166,748 26,229,750 25,672,899 24,884,791 24,820,900 24,646,300 24,458,200 24,457,100 24,458,100 24,460,800 2 Multifamily 9,763,965 9,625,609 9,419,644 9,160,576 8,904,095 8,839,200 8,667,400 8,639,400 8,607,900 8,572,900 8,558,900 3 N on -R esidential 31,600,536 30,567,364 30,117,889 26,940,750 25,006,893 23,370,600 23,224,200 23,136,100 23,092,100 23,077,500 23,077,500 4 Total 68,802,145 66,359,721 65,767,283 61,774,225 58,795,779 57,030,700 56,537,900 56,233,700 56,157,100 56,108,500 56,097,200 Unmetered Cu stomers (a) 5 Sin gle Family 7,068,871 7,112,387 7,105,847 7,076,700 7,215,245 7,442,300 7,291,000 7,234,100 7,213,400 7,215,400 7,218,200 6 Multifamily 5,044,805 5,038,213 5,008,881 4,928,578 4,823,684 4,829,900 4,744,500 4,700,200 4,687,700 4,689,300 4,688,600 7 Total 12,113,676 12,150,600 12,114,727 12,005,278 12,038,928 12,272,200 12,035,500 11,934,300 11,901,100 11,904,700 11,906,800 Total Con tributed Wastewater Vo lume 8 Single Family 34,506,515 33,279,135 33,335,597 32,749,599 32,100,036 32,263,200 31,937,300 31,692,300 31,670,500 31,673,500 31,679,000 9 Multifamily 14,808,770 14,663,822 14,428,525 14,089,154 13,727,779 13,669,100 13,411,900 13,339,600 13,295,600 13,262,200 13,247,500 10 Non -R esiden tial 31,600,536 30,567,364 30,117,889 26,940,750 25,006,893 23,370,600 23,224,200 23,136,100 23,092,100 23,077,500 23,077,500 11 To ta l 12 Annual Percentage Increase 80,915,821 78,510,321 77,882,010 73,779,503 70,834,707 69,302,900 68,573,400 68,168,000 68,058,200 68,013,200 68,004,000 8. 7% -3.0% -0. 8% -5 .3% -4.0% -2.2% -1 .1% -0.6% -0 .2% -0 .1% 0 .0% Ccf = H undred Cubic Feet (748 gallon s) (a) Unmetered wastewater volume is determin ed by multiplying the number of fix tures by their respective unit usage values. Unit usage values are 16 gallo ns per day (gpd) per roo m, 60 gpd per water closet, and 50 gpd per bath or separate shower. Table 3-3 Historical Wastewater Charge s Line No. Type of Mo nthly Charge Fiscal Year Ending Ju ne 30, 1994 1998 2004 2005 2006 2008 2010 2011 (a) (c) Ordina nce 9029 10177 11553 11692 12019 12561 12754 13021 Adopted Date 06/16/93 09/11/97 07/24/03 03/11/04 07/14/05 12/13/07 10/07/08 01/14/10 Effective Date 07/01/93 10/01/97 08/01/03 07/01/04 07/01/05 01/01/08 07/01/09 07/01/10 Base Charge - $/Bill 1 Billing & Collection Charge 2 System Availability Charge 3 To tal Base (Residential) Service Charge 4 Co mplian ce Charge - $Bil1(b) 5 Total N on residential Service Charge Volu me Charge 6 Metered - $/Ccf U nmetered - $Bill 7 Each Roo m 8 Each Water Closet 9 Each Bath 10 Each Separate Shower 0 .37 0.74 0 .85 0.85 0.85 2 .30 2.30 2 .60 3.72 4.83 5.30 6.45 7 .05 8 .40 8 .60 8 .80 4.09 5 .57 6 .15 7.30 7 .90 10 .70 10 .90 11.40 7 .40 8 .56 11.80 12.15 12 .55 27 .40 29 .65 30.85 11 .49 14.13 17 .95 19 .45 20 .45 38.10 40 .55 42 .25 0 .99 1 .05 1 .34 1.66 1 .81 1 .88 1 .92 2 .02 0 .64 0 .69 0 .88 1 .08 1 .18 1.23 1.25 1.32 2 .41 2 .58 3.28 4 .04 4 .42 4.59 4 .69 4 .93 2.01 2.15 2.74 3 .37 3 .69 3 .83 3 .91 4 .11 2.01 2.15 2 .74 3 .37 3 .69 3.83 3 .91 4.11 Extra Strength Surcharges - $/ton (b) 11 Suspended Solids ov er 350 mg/I 127. 40 87.20 12 Suspended So lids over 300 mg/I 162 .88 200.15 218 .90 218 .90 218 .90 222.62 13 Bio chemica l Oxygen Demand over 300 mg/1 244. 10 217.90 319 .24 412 .58 461 .44 529 .56 551 .52 596.72 14 Chemical Ox ygen Demand ov er 600 mg/1 122.05 108.95 159 .62 206 .29 230 .72 264.78 275 .76 298.36 Ccf - Hu ndred Cubic Feet mg/1 - milligram per liter (a) These rates were judged by courts to be user charges that are not subject to the requirements of the Hancock A mendmen t. Rates for qualified low-inco me custo mers were established at 50 percent of the general service charges . (b) Applicable only to n on-residential cu stomers. (c) Current rates as recommended by the Rate Commissio n an d adopted by the Board of Trustees. These rates were previously adopted by Ordinan ce 12754 and reaffirmed by Ordinances 12905 and 13021. Table 3-4 Existing Wastewater Rates (Effective July 1, 2010) Metered Line Unmetered Non - No. Type of Monthly Charge Residential Residential Residential $ $ $ 1 Billing and Collection Charge 2.60 2.60 2.60 2 System Availability Charge 8.80 8.80 8.80 3 Compliance Charge 30.85 Volume Charge 4 per Ccf 2.02 2.02 5 per room 1.32 6 per water closet 4.93 7 per bath 4.11 8 per separate shower 4.11 Extra Strength Surcharge - $/ton 9 Suspended Solids over 300 mg/1 10 BOD over 300 mg/1 11 COD over 600 mg/I Ccf - Hundred Cubic Feet mg/1 - milligrams per liter Note: Rates for qualified low income residential users are 50 percent of the rates shown above. 222.62 596.72 298.36 Table 3-5 Historical and Projected Billed Wastewat er Service Revenue Under Existing R at es Lin e N o. Cu stomer Class Metered Custo mers 1 Single Family 2 Multifamily Non -Residential 3 Normal Stren gth 4 Excess Strength 5 Total U nmetered Custo mers 6 Single Family 7 Multifamily 8 Total Historical 2006 $ 2007 $ 2008 $ 2009 $ 2010 $ Pr ojected 2011 $ 2012 $ 2013 2014 $ $ 2015 $ 2016 $ 77,985,843 76,252,800 82,111,500 87,057,200 86,945,800 91,333,800 90,945,900 90,536,400 90,505,900 90,471,600 90,452,700 19,646,971 19,238,700 19,693,800 19,900,500 19,815,100 20,696,500 20,338,100 20,275,800 20,206,700 20,131,400 20,103,700 63,506,777 61,644,900 64,381,700 62,255,400 60,182,084 59,920,000 59,539,800 59,311,100 59,196,900 59,158,900 59,158,900 6,782,384 5,924,400 5,789,800 6,136,700 5,772,600 6,524,900 6,524,900 6,524,900 6,524,900 6,524,900 6,524,900 167,921,974 163,060,800 171,976,800 175,349,800 172,715,584 178,475,200 177,348,700 176,648,200 176,434,400 176,286,800 176,240,200 18,282,428 18,485,900 19,745,100 20,808,800 21,152,600 22,804,300 22,403,200 22,215,800 22,133,900 22,112,100 22,101,400 11,399,822 11, 510,000 11,912,900 11,916,200 11,879,600 12,516,100 12,278,100 12,155,700 12,113,500 12,102,900 12,090,200 29,682,249 29,995,900 31,658,000 32,725,000 33,032,200 35,320,400 34,681,300 34,371,500 34,247,400 34,215,000 34,191,600 Total Wastewater Service R evenu e 9 Single Family 96,268,271 10 Multifamily 31,046,793 11 Non -R esidential 70,289,161 94,738,700 30,748,700 67,569,300 101,856,600 31,606,700 70,171,500 107,866,000 31,816,700 68,392,100 108,098,400 31,694 ,700 65,954,684 114,138,100 33,212,600 66,444,900 113,349,100 32,616,200 66,064,700 112,752,200 32,431,500 65,836,000 112,639,800 32,320,200 65,721,800 112,583,700 32,234,300 65,683,800 112,554,100 32,193,900 65,683,800 12 Total Wastewater 197,604,224 193,056,700 203,634,800 208,074,800 205,747,784 213,795,600 212,030,000 211,019,700 210,681,800 210,501,800 210,431,800 13 Ann ual Percentage Increase 16.1% -2. 3% 5. 5% 2.2% -1 .1% 3 .9% -0 .8% -0 .5% -0.2% -0 .1% 0 .0% Table 3-6 Projected Wastewater Other Operating Revenue Line Fiscal Year Ending June 30, No. Description 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ 1 Billing Adjustment (a) 4,556,700 4,538,700 4,535,500 4,545,600 4,559,000 4,575,100 2 Bad Debt Provision (10,910,900) (6,820,800) (8,998,500) (10,055,400) (11,262,000) (12,613,400) Other Fees 3 Construction Inspection Fees 100,000 103,000 106,100 109,300 112,600 116,000 4 Waste Hauler Permits 1,450,000 1,457,300 1,464,600 1,471,900 1,479,300 1,486,700 5 All Other Fees (b) 482,500 497,100 512,100 527,500 543,300 559,600 6 Subtotal 2,032,500 2,057,400 2,082,800 2,108,700 2,135,200 2,162,300 7 Miscellaneous Revenue (c) 8 Total Other Operating Revenue 9 Connection Fee Revenue (d) 3,571,200 3,607,100 3,651,300 3,696,500 3,743,300 3,791,300 (750,500) 3,382,400 1,271,100 295,400 (824,500) (2,084,700) 1,250,000 1,288,000 1,327,000 1,367,000 1,408,000 1,450,000 10 Total Other Revenue 499,500 4,670,400 2,598,100 1,662,400 583,500 (634,700) (a) Includes Late Charges, Refunds, Adjustments, Wastewater Lien Interest and fees, and Other Adjustments including revenue from Arnold. (b) Includes Plan Review Fees, Submittal Fees, Wastewater Monitoring Cost Fees, Pretreatment Discharge Permits, and all other fees. (c) Includes Reimbursements, Sale of Fixed Assets, Reimbursable Engineering & Maintenance, and all other miscellaneous revenue. (d) Revenue available for improvements financed out of Improvement Fund. Table 3-7 Projected Wastewater Operating Costs Line Fiscal Year Ending June 30, No Department 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ 1 Board of Trustees 2,400 2,500 2,600 2,700 2,800 2,900 2 Rate Commission (a) 423,800 9,400 9,700 10,100 485,600 11,100 3 Civil Service Commission 7,800 7,800 7,800 7,800 7,800 7,800 4 Secretary - Treasurer 1,613,700 1,674,900 1,733,600 1,813,900 1,892,700 1,972,800 5 Executive Director 712,400 739,600 767,900 801,100 831,400 861,600 6 General Counsel 4,116,800 4,265,300 4,402,900 4,601,200 4,801,900 5,009,400 7 Office of Human Resources 9,847,600 10,303,000 10,766,400 11,330,900 11,913,800 12,430,100 8 Engineering 18,206,400 18,992,300 19,841,100 20,786,700 21,616,800 22,403,100 Operations 9 Collection System (b) 19,579,200 20,401,200 21,278,200 22,262,700 23,159,500 24,007,200 10 Pump Stations 7,931,300 8,210,800 8,496,800 8,896,900 9,289,200 9,684,900 11 Wastewater Treatment (c) 35,427,500 36,664,600 37,941,900 39,675,900 41,366,200 43,068,600 12 Support (d) 7,265,000 7,534,800 7,818,200 8,132,700 8,428,700 8,719,200 13 Total Operations 70,203,000 72,811,400 75,535,100 78,968,200 82,243,600 85,479,900 14 Finance 15,885,700 15,985,700 16,144,500 16,590,800 17,114,800 17,738,000 15 Information Systems 8,470,500 8,780,100 10,297,600 11,069,700 9,822,200 10,176,100 16 Subtotal (General Fund) 129,490,100 133,572,000 139,509,200 145,983,100 150,733,400 156,092,800 17 Water Backup Program 4,000,000 4,300,000 5,000,000 5,000,000 5,000,000 5,000,000 18 Real Property Fund (e) 904,700 931,800 959,800 988,600 1,018,300 1,048,800 19 Subtotal O&M 134,394,800 138,803,800 145,469,000 151,971,700 156,751,700 162,141,600 20 Additional O&M (1) 0 0 112,400 2,159,800 7,484,100 7,942,500 21 Total O&M 134,394,800 138,803,800 145,581,400 154,131,500 164,235,800 170,084,100 22 Capital Outlay 2,378,600 2,461,900 2,535,700 2,611,800 2,690,100 2,770,900 23 Total Operating Expense 136,773,400 141,265,700 148,117,100 156,743,300 166,925,900 172,855,000 (a) It is assumed that the Rate Commission will review proposed changes in wastewater rates every four years. (b) Includes Mintert, Sulphur, and Grand Glaize maintenance yards and technical services (c) Includes Lemay, Bissell, and county treatment plants. (d) Includes costs related to the customer care group,administrative support and materials management. (e) Expenditures offset by rental income. (f) O&M costs related to anticipated regulatory projects. These projects include improved disinfection at the Missouri River WWTP in 2013 and 2014; expansion of the Missouri River WWTP in 2015; and Capacity, Management, Operation, and Maintenance (CMOM) program activities related to anticipated Consent Decree requirements in 2016. Table 3-8 Wastewater Capital Improvement and Replacement Program Line No. D escription 2011 2012 San itary Sewer Overflow Contr ol 1 D esign 2 Constructio n Fiscal Year Endi ng J une 30, $ $ 2013 - 2016 2011 - 2016 2013 2014 2015 2016 4 - Year Total 6 - Year Total $ $ 12,410,000 728,000 54,224,000 71,025,000 54,931,000 18,093,000 69,963,000 40,856,000 3 Su btotal 67,341,000 18,821,000 Combined Sewer Overflo w Contr ol 4 Design 13,415,000 5,284,000 5 Construction 0 2,206,000 6 Subtotal 13,415,000 7,490,000 System Projects 7 Cityshed Improvemen ts 6,283,000 0 8 Asset Man agement 15,697,000 23,234,000 9 B&C System 0 0 10 Subtotal 21,980,000 23,234,000 83,499,000 66,874,000 11 Wastewater Treatment 55,487,000 81,558,000 32,290,000 281,000 51,240,000 11,636,000 188,125,000 108,201,000 148,245,000 367,265,000 124,187,000 111,881,000 159,441,000 159,881,000 555,390,000 24,860,000 11,298,000 12,993,000 22,941,000 72,092,000 8,971,000 47,094,000 54,708,000 7,865,000 118,638,000 33,831,000 58,392,000 67,701,000 30,806,000 190,730,000 20,536,000 59,029,000 3,934,000 11,818,000 50,667,000 4,389,000 12 Total 158,223,000 131,103,000 273,807,000 237,428,000 7,303,000 25,446,000 0 7,761,000 35,565,000 0 47,418,000 170,707,000 8,323,000 32,749,000 43,326,000 226,448,000 1,739,000 0 34,310,000 261,630,000 234,013,000 1,006,878,000 201,263,000 440,289,000 641,552,000 90,791,000 120, 844,000 211,635,000 53,701,000 209,638,000 8,323,000 271,662,000 171,355,000 1,296,204,000 Table 3-9 Wastewater Capital Improvement Program Financing Lin e No Description So urce of Funds 1 Begin nin g of Year Balance 2 Reven ue Bond Proceeds 3 State Revolv in g Loan Proceeds 4 Commercial Paper 5 Cash Fin ancin g of Construction 6 Gran ts & Contribu tion s (a) 7 Interest Income (b) 8 Total Fu nds A vailable Fiscal Year E nding J une 30, 2013 - 2016 2011 - 2016 2011 2012 2013 2014 2015 2016 4 -Year Total 6 - Year Total $ $ $ $ $ $ 92,977,300 0 37,000,000 0 37,250,000 454,800 2,768,900 8,668,600 4,050,600 28,221,700 56,955,900 52,588,000 52,020,000 250,000,000 215,000,000 200,000,000 140,000,000 39,999,300 35,000,000 35,000,000 35,000,000 35,000,000 0 0 0 0 0 38,438,000 31,677,000 33,267,000 38,308,000 55,850,000 474,500 1,494,900 516,300 538,600 561,900 2,120,800 2,735,000 2,409,600 2,204,100 1,832,000 170,451,000 141,721,200 324,957,500 314,414,600 Application of Funds 9 Major Capital Improvemen ts 158,223,000 131,103,000 273,807,000 237,428,000 10 Improvemen t Fu nd Projects 1,265,000 2,000,000 2,000,000 2,000,000 11 Issu ance Co sts (c) 552,200 988,300 3,727,500 3,237,500 12 Revenue Bon d R eserve Fund (d) 1,742,200 3,579,300 17,201,300 14,793,200 13 Total A pplication of Funds 161,782,400 137,670,600 296,735,800 257,458,700 14 End of Y ear Fund Balance 15 Cu mu lative Percentage Debt Finan ced 8,668,600 4,050,600 28,221,700 56,955,900 46. 7% 48.5% 55.9% 60.8% 333,006,600 261,630,000 2,000,000 3,027,500 13,761,100 $ 4,050,600 805,000,000 140,000,000 0 159,102,000 3,111,700 9,180,700 285,831,900 1,120,445,000 234,013,000 1,006, 878,000 2,000,000 8,000,000 2,187,500 12,180,000 9,632,800 55,388,400 280,418,600 247,833,300 1,082,446,400 52,588,000 37,998,600 37,998,600 63 .5% 64.1% (a ) In clu des anticipated con tributions from the City of A rn old to reserve capacity in the Lower Meramec River Wastewater Treatment Plant. (b) In terest Inco me is estimated at 1% of the av erage of the beginn ing and en d of year balances. (c) Issuance Costs are estimated at 1.40% of the issu e amount for R even ue Bonds, 0.65% of the issue amou nt for SRF Loans, a nd $25,000 per issue for commercial paper. (d) The requ ired balance in the Revenu e Bond R eserve Fun d is determin ed to be the max imu m principal and interest payment on senior debt. $ 92,977,300 857,020,000 216,999,300 0 234,790,000 4,041,000 14,070,400 1,419,898,000 1,296,204,000 11,265,000 13,720,500 60,709,900 1,381,899,400 37,998,600 Table 3-10 Projected Wastewater Debt Service Requirements Existing Proposed Existing Proposed Commercial Fiscal Revenue Revenue SRF SRF Paper Year Bonds Bonds Loans Loans Notes $ $ $ Total $ $ $ Payments to Sinking Fund 2011 19,290,600 0 19,113,700 0 0 38,404,300 2012 19,415,200 3,281,000 21,311,100 1,711,000 0 45,718,300 2013 19,550,800 20,780,600 21,401,300 4,062,800 0 65,795,500 2014 19,686,000 35,573,800 21,483,500 6,307,900 0 83,051,200 2015 19,834,400 49,334,900 21,355,600 8,553,000 0 99,077,900 2016 19,973,200 58,967,700 21,728,600 10,797,800 0 111,467,300 Payments to Bondholders 2011 19,270,300 0 18,292,600 0 0 37,562,900 2012 19,392,400 1,430,600 20,232,600 500,000 0 41,555,600 2013 19,528,800 10,454,300 21,395,200 3,003,300 0 54,381,600 2014 19,660,900 26,693,100 21,345,500 5,248,400 0 72,947,900 2015 19,811,800 41,073,800 21,545,900 7,493,500 0 89,925,000 2016 19,947,200 53,184,900 21,324,600 9,738,600 0 104,195,300 Table 3-11 Comparison of Projected Wastewater Revenue Under Existing Rates With Projected Revenue Requirements Line Fiscal Year Ending June 30, 2013 - 2016 2011 - 2016 No. Description 2011 2012 2013 2014 2015 2016 4 -Year Total 6 -Year Total 1 Revenue Under Existing Rates (a) Additional Revenue Required Fiscal Revenue Months Year Increase Effective $ $ $ $ $ $ $ $ 213,795,600 212,030,000 211,019,700 210,681,800 210,501,800 210,431,800 842,635,100 1,268,460,700 2 2012 4.3% 12 8,357,500 9,073,800 9,059,300 9,051,600 9,048,600 36,233,300 44,590,800 3 2013 11.0% 12 22,192,800 24,171,500 24,150,900 24,142,800 94,658,000 94,658,000 4 2014 12.0% 12 26,830,400 29,244,500 29,234,800 85,309,700 85,309,700 5 2015 12.0% 12 30,024,400 32,743,000 62,767,400 62,767,400 6 2016 12.0% 12 33,616,100 33,616,100 33,616,100 7 Total Additional Revenue 0 8,357,500 31,266,600 60,061,200 92,471,400 128,785,300 312,584,500 320,942,000 8 Total Service Charge Revenue 213,795,600 220,387,500 242,286,300 270,743,000 302,973,200 339,217,100 1,155,219,600 1,589,402,700 9 Other Operating Revenue (750,500) 3,382,400 1,271,100 295,400 (824,500) (2,084,700) (1,342,700) 1,289,200 10 Connection Fee Revenue 1,250,000 1,288,000 1,327,000 1,367,000 1,408,000 1,450,000 5,552,000 8,090,000 11 Interest Income - Reserve Funds 888,800 964,300 1,196,600 1,486,600 1,753,500 1,969,100 6,405,800 8,258,900 12 Interest Income - Operations 30,800 47,300 50,100 50,500 50,500 50,200 201,300 279,400 13 Interest Income - Arnold 650,700 631,000 610,500 589,100 566,800 543,600 2,310,000 3,591,700 14 Subtotal Other Revenue 2,069,800 6,313,000 4,455,300 3,788,600 2,954,300 1,928,200 13,126,400 21,509,200 15 Total Revenue 215,865,400 226,700,500 246,741,600 274,531,600 305,927,500 341,145,300 1,168,346,000 1,610,911,900 16 Operation and Maintenance Expense 134,394,800 138,803,800 145,469,000 151,971,700 156,751,700 162,141,600 616,334,000 889,532,600 17 Additional O&M (b) 0 0 112,400 2,159,800 7,484,100 7,942,500 17,698,800 17,698,800 18 Net Revenue 81,470,600 87,896,700 101,160,200 120,400,100 141,691,700 171,061,200 534,313,200 703,680,500 Debt Service 19 Existing Senior Revenue Bonds 19,290,600 19,415,200 19,550,800 19,686,000 19,834,400 19,973,200 79,044,400 117,750,200 20 Proposed Senior Revenue Bonds 0 3,281,000 20,780,600 35,573,800 49,334,900 58,967,700 164,657,000 167,938,000 21 Total Senior Revenue Bonds 19,290,600 22,696,200 40,331,400 55,259,800 69,169,300 78,940,900 243,701,400 285,688,200 22 Existing State Revolving Fund Loans (c) 19,113,700 21,311,100 21,401,300 21,483,500 21,355,600 21,728,600 85,969,000 126,393,800 23 Proposed State Revolving Fund Loans (c) 0 1,711,000 4,062,800 6,307,900 8,553,000 10,797,800 29,721,500 31,432,500 24 Total State Revolving Fund Loans 19,113,700 23,022,100 25,464,100 27,791,400 29,908,600 32,526,400 115,690,500 157,826,300 25 Commercial Paper 0 0 0 0 0 0 0 0 26 Total Debt Service 38,404,300 45,718,300 65,795,500 83,051,200 99,077,900 111,467,300 359,391,900 443,514,500 27 Routine Annual Improvements 2,378,600 2,461,900 2,535,700 2,611,800 2,690,100 2,770,900 10,608,500 15,449,000 28 Cash Financing of Major Improvements 37,250,000 38,438,000 31,677,000 33,267,000 38,308,000 55,850,000 159,102,000 234,790,000 29 Additions to Operating Reserve 674,500 738,500 1,126,200 1,418,000 1,673,900 974,600 5,192,700 6,605,700 30 Net Annual Balance (d) 2,763,200 540,000 25,800 52,100 (58,200) (1,600) 18,100 3,321,300 31 Beginning of Year Balance (e) 32 End of Year Balance (e) Actual Debt Service (f) 33 Senior Bonds 34 SRF Loans Debt Service Coverage 35 Revenue Bonds (g) 36 Total Debt (h) 1,696,900 4,460,100 5,000,100 5,025,900 5,078,000 5,019,800 5,000,100 1,696,900 4,460,100 5,000,100 5,025,900 5,078,000 5,019,800 5,018,200 5,018,200 5,018,200 19,270,300 20,823,000 29,983,100 46,354,000 60,885,600 73,132,100 210,354,800 250,448,100 18,292,600 20,732,600 24,398,500 26,593,900 29,039,400 31,063,200 111,095,000 150,120,200 4.23 x 4.22 x 3.37 x 2.60 x 2.33 x 2.34 x 2.54 x 2.81 x 2.17 x 2.12 x 1.86 x 1.65 x 1.58 x 1.64 x 1.66 x 1.76 x (a) Revenue under existing wastewater rates effective July 1, 2010. (b) O&M costs related to anticipated regulatory projects. These projects include improved disinfection at the Missouri River WWTP in 2013 and 2014; expansion of the Missouri River WWTP in 2015; and Capacity, Management, Operation, and Maintenance (CMOM) program activities related to anticipated Consent Decree requirements in 2016. (c) Debt service on State Revolving Fund (SRF) Loans are net of the state's interest subsidy. (d) Negative balances indicate need to drawdown available fund balance. (e) Does not include funds set aside for a minimum operating reserve equal to 60 days of operating expenses. (f) Payment to Bondholders per Table 3-10, paid through Sinking Fund. (g) The Bond Ordinance requires net revenue to equal or exceed 1.25x actual senior lien debt service. (h) The Bond Ordinance requires net revenue to equal or exceed 1.15x total actual debt service. Table 3-12 Wastewater Cost of Service Test Year 2013 Line No. Description Revenue Requirements 1 Operation & Maintenance Expense 2 Debt Service 3 Routine Capital Improvements 4 Cash Financing of Major Improvements 5 Additions to Operating Reserve 6 Total Revenue Requirements met from Other Operating Revenue 7 Wastewater Billing Adjustments 8 Inspection and Other Fees 9 Miscellaneous Revenue 10 Subtotal 11 Interest Income 12 Connection Fee Revenue 13 Change in Available Fund Balances 14 Full Year Rate Adjustment (a) 15 Total 16 Net Costs to be met from Charges Operating Capital $ 145,581,400 1,126,200 $ 65,795,500 2,535,700 31,677,000 Total $ 145,581,400 65,795,500 2,535,700 31,677,000 1,126,200 146,707,600 100,008,200 246,715,800 Other Sources (4,463,000) 2,082,800 3,651,300 1,271,100 1,857,200 (2,017,500) 1,110,800 (4,463,000) 2,082,800 3,651,300 0 1,271,100 1,857,200 1,327,000 1,327,000 (25,800) (25,800) (2,017,500) 1,301,200 2,412,000 145,596,800 98,707,000 244,303,800 Total Cost of Service Net Cash Capital 13.5% Debt Service 26.9% Net Operating Cost 59.6% (a) Required to adjust for normal billing lag and any partial year implementation of increased wastewater rates. Table 3-13 Allocation of Estimated Wastewater Plant Investment and Other Capital Costs to Functional Cost Components Test Year 2013 Line No. Description Collection System 1 Sanitary Sewers 2 Combined Sewers 3 Pumping Stations 4 Total Collection System Treatment Facilities 5 Raw Wastewater Pumping 6 Preliminary Treatment 7 Primary Sedimentation 8 Aeration/Reaeration/Nitrification 9 Secondary Sedimentation 10 Recirculation Pumping 11 Chlorination 12 Lagoons & Aeration Equipment 13 Sludge Treatment 14 Dewatering 15 Incineration 16 By Pass & Outfall Works 17 Administrative & General (b) 18 Total Treatment Facilities 19 Subtotal Estimated Plant Investment 20 Land & General Plant (c) 21 Total Estimated Plant Investment 22 Routine Capital Improvements (d) Cash Financing of Improvements 23 Collection System 24 Wastewater Treatment (e) 25 Land & General Plant (c) 26 Less: Connection Fee Revenue (d) 27 Change in Funds Available (d) 28 Net Cash Financed Capital Costs 29 Debt Service (d) 30 Total Net Capital Costs 31 Estimated Replacements (c) 32 Net Other Capital Cost (1) (2) (3) Total (a) 892,994,000 210,735,000 109,740,000 1,213,469,000 7,710,000 63,103,000 187,329,000 96,360,000 118,480,000 3,078,000 13,816,000 3,192,000 76,711,000 16,500,000 56,729,000 8,467,000 95,305,000 Volume Capacity $ $ 892,994,000 210,735,000 109,740,000 1,213,469,000 7,710,000 63,103,000 187,329,000 118,480,000 3,078,000 13,816,000 (4) (5) Suspended Solids BOD $ $ 38,356,000 8,250,000 28,365,000 96,360,000 3,192,000 38,355,000 8,250,000 28,364,000 8,467,000 47,208,000 11,598,000 10,968,000 25,531,000 746,780,000 369,911,000 1,960,249,000 3 72,087,000 90,878,000 85,939,000 200,052,000 69,911,000 1,304,347,000 85,939,000 200,052,000 13,603,000 47,967,000 3,160,000 7,357,000 2,032,336,000 3 2,535,700 24,965,200 1,079,400 5,632,400 1,327,000 (25,800) 32,911,500 65,795,500 83,514,000 1,352,314,000 89,099,000 207,409,000 478,400 1,687,300 111,200 258,800 534,600 1,062,900 250,400 (4,900) 24,965,200 131,400 124,200 289,200 3,747,800 246,900 574,800 883,000 58,200 135,400 (17,200) (1,100) (2,600) 1,830,400 29,665,900 425,200 990,000 12,416,100 43,780,200 2,884,500 6,714,700 98,707,000 14,246,500 64,366,600 12,146,400 34,340,400 73,446,100 3,309,700 7,704,700 42,829,400 2,821,900 6,568,900 2,100,100 30,616,700 487,800 1,135,800 (a) Excludes $470,725,000 of investment related to the stormwater system. (b) Allocated based on all other treatment facilities (Lines 5 through 16). (c) Allocated based on Line 19. (d) Allocated based on Line 21. (e) Allocated based on Line 18. Table 3-14 Percentage of Wastewater Operation and Maintenance Expense by Functional Cost Components Test Year 2013 Direct Non - Line Suspended All Residential No. Description Total Indirect Total Volume Capacity Solids BOD Customers Customers $ $ $ $ $ $ $ $ $ Personnel Services 1 Administration and Management (a) 0.0% 100.0% 0.0% 2 Engineering 100.0% 0.0% 100.0% 5.4% 77.6% 2.5% 2.7% 3.5% 8.3% Operations 3 Collection System 100.0% 0.0% 100.0% 100.0% 4 Pump Stations 100.0% 0.0% 100.0% 100.0% 5 Wastewater Treatment 100.0% 0.0% 100.0% 23.5% 16.7% 25.5% 34.1% 0.2% 6 Support 100.0% 12.0% 88.0% 8.7% 53.2% 9.4% 12.6% 16.1% 7 Finance 100.0% 51.4% 48.6% 100.0% 8 Information Systems 0.0% 100.0% 0.0% 9 Average 100.0% 8.4% 64.6% 8.0% 10.6% 5.9% 2.6% All Other 10 Administration and Management (a) 0.0% 100.0% 0.0% 11 Engineering 100.0% 0.0% 100.0% 4.6% 81.3% 2.1% 2.3% 2.8% 6.9% Operations 12 Collection System 100.0% 0.0% 100.0% 100.0% 13 Pump Stations 100.0% 0.0% 100.0% 100.0% 14 Wastewater Treatment 100.0% 0.0% 100.0% 19.1% 18.2% 30.3% 32.1% 0.3% 15 Support 100.0% 1.0% 99.0% 11.6% 46.7% 18.4% 19.4% 3.9% 16 Finance 100.0% 4.1% 95.9% 100.0% 17 Information Systems 0.0% 100.0% 0.0% 18 Average 100.0% 7.8% 33.8% 12.2% 12.9% 33.0% 0.4% Utilities Operations 19 Pump Stations 100.0% 0.0% 100.0% 56.0% 44.0% 20 Wastewater Treatment 100.0% 0.0% 100.0% 34.7% 12.6% 19.7% 32.5% 0.5% 21 Average 100.0% 38.9% 18.8% 15.8% 26.0% 0.0% 0.4% 22 Water Backup Program 100.0% 0.0% 100.0% 100% 0.0% 23 Headquarters Building 100.0% 0.0% 100.0% 100.0% 24 Total O&M Expense 100.0% 0.0% 100.0% 14.1% 48.7% 9.6% 12.3% 13.7% 1.6% 25 Allocations to Operating Reserve 100.0% 0.0% 100.0% 14.1% 48.6% 9.7% 12.3% 13.7% 1.6% Less Costs Met From Other Revenue Other Revenue 26 Wastewater Revenue Adjustments 100.0% 90.0% 0.0% 0.0% 0.0% 10.0% 0.0% 27 Connection and Other Fees 100.0% 15.4% 10.5% 34.5% 28.8% 0.0% 10.8% 28 Miscellaneous Revenue 100.0% 25.0% 0.0% 0.0% 0.0% 75.0% 0.0% 29 Interest Income 100.0% 11.6% 40.0% 7.9% 10.1% 29.0% 1.3% 30 Full Year Rate Adjustment 100.0% 16.7% 57.5% 11.4% 14.5% 0.0% 0.0% 31 Average 100.0% -261.4% -17.7% 57.2% 44.6% 254.8% 22.4% 32 Net O&M Expense 100.0% 16.2% 49.1% 9.3% 12.0% 11.8% 1.5% (a) Includes Board of Trustees, Rate Commission, Civil Service Commission, Office of Secretary - Treasurer, Executive Director, Office of General Counsel, and Office of Human Resources. Table 3-15 Allocation of Wastewater Operation and Maintenance Expense to Functional Cost Components Test Year 2013 Direct Non - Line Suspended All Residential No. Description Total Indirect Total Volume Capacity Solids BOD Customers Customers $ $ $ $ $ $ $ $ $ Personnel Services 1 Administration and Management (a) 4,579,600 4,579,600 0 2 Engineering 19,477,100 0 19,477,100 1,051,800 15,114,200 486,900 525,900 681,700 1,616,600 Operations 3 Collection System 17,898,500 0 17,898,500 17,898,500 4 Pump Stations 3,895,500 0 3,895,500 3,895,500 5 Wastewater Treatment 17,125,300 0 17,125,300 4,024,400 2,859,900 4,367,000 5,839,700 34,300 6 Support 3,947,100 473,700 3,473,400 301,300 1,848,600 327,000 437,300 559,200 7 Finance 5,199,600 2,672,800 2,526,800 2,526,800 8 Information Systems 6,445,600 6,445,600 0 9 Total 78,568,300 14,171,700 64,396,600 5,377,500 41,616,700 5,180,900 6,802,900 3,767,700 1,650,900 All Other 10 Administration and Management (a) 9,713,200 9,713,200 0 11 Engineering 1,305,600 0 1,305,600 60,000 1,061,500 27,400 30,000 36,600 90,100 Operations 12 Collection System 4,214,400 0 4,214,400 4,214,400 13 Pump Stations 2,091,600 0 2,091,600 2,091,600 14 Wastewater Treatment 10,754,600 0 10,754,600 2,054,200 1,957,300 3,258,600 3,452,200 32,300 15 Support 4,060,600 40,600 4,020,000 465,200 1,878,400 737,900 781,700 156,800 16 Finance 11,184,200 460,500 10,723,700 10,723,700 17 Information Systems 4,043,900 4,043,900 0 18 Total 47,368,100 14,258,200 33,109,900 2,579,400 11,203,200 4,023,900 4,263,900 10,917,100 122,400 19 Subtotal Direct Expenses 97,506,500 7,956,900 52,819,900 9,204,800 11,066,800 14,684,800 1,773,300 20 Total Indirect (b) 28,429,900 28,429,900 2,320,100 15,400,700 2,683,800 3,226,700 4,281,600 517,000 Utilities Operations 21 Pump Stations 2,695,200 2,695,200 1,509,300 1,185,900 22 Wastewater Treatment 10,877,600 10,877,600 3,774,500 1,370,600 2,142,900 3,535,200 54,400 23 Subtotal 13,572,800 13,572,800 5,283,800 2,556,500 2,142,900 3,535,200 54,400 24 Water Backup Program 5,000,000 5,000,000 5,000,000 25 Headquarters Building 959,800 959,800 959,800 26 Total O&M Expense 145,469,000 145,469,000 20,560,800 70,777,100 14,031,500 17,828,700 19,926,200 2,344,700 27 Additional O&M (c) 112,400 112,400 26,600 18,800 28,700 38,300 28 Add't to Operating Reserve (d) 1,126,200 1,126,200 159,300 547,700 108,800 138,200 154,100 18,100 Less Costs Met From Other Revenue Other Revenue 29 Wastewater Revenue Adjustments (4,463,000) (4,463,000) (4,016,700) 0 0 0 (446,300) 0 30 Connection and Other Fees 2,082,800 2,082,800 321,300 219,000 717,700 600,500 0 224,300 31 Miscellaneous Revenue 3,651,300 3,651,300 912,800 0 0 0 2,738,500 0 32 Interest Income (e) 1,857,200 1,857,200 215,900 743,400 147,400 187,300 538,600 24,600 33 Full Year Rate Adjustment (f) (2,017,500) (2,017,500) (336,600) (1,159,100) (229,800) (292,000) 34 Total 1,110,800 1,110,800 (2,903,300) (196,700) 635,300 495,800 2,830,800 248,900 35 Net O&M Expense 145,596,800 145,596,800 23,650,000 71,540,300 13,533,700 17,509,400 17,249,500 2,113,900 (a) Includes Board of Trustees, Rate Commission, Civil Service Commission, Office of Secretary - Treasurer, Executive Director, Office of General Counsel, and Office of Human Resources. (b) Allocated based on Line 19. (c) Additional costs due to anticipated regulatory related projects. Personnel services costs are allocated based on Line 5, utilities are allocated based on Line 22, and all other costs are allocated based on Line 14. (d) Allocated based on Lines 26 and 27. (e) Allocated 29.0% of interest income directly to All Customers based on relative revenue receipts with remainder allocated based on Line 26 less All Customer costs. (f) Allocated based on Line 26 less All Customers, and Non-residential Customers costs. Table 3-16 Wastewater Units of Service Test Year 2013 (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Vol ume Capacity Wastewater Strength N on - Lin e I nfiltration Total I nfiltratio n Total S uspe nded All Reside ntial No. Customer Class Contributed I nflow Treated Co ntributed I nflow Treated Solids BOD Customers Customers Ccf Ccf Ccf Ccf/day Ccf/day Ccf/day Po unds Po unds Bills Eq ui v. Bills (1) + (2) (4) + (5) Metere d Custo mers 1 Single Family 24,458,200 41,709,800 66,168,000 115,925 478,806 594,731 59,603,100 29,311,100 3,624,610 2 Multifamily 8,639,400 7,966,400 16,605,800 40,948 91,450 132,398 16,831,200 9,931,300 248,640 3 Non -Residential 23,136,100 18,918,800 42,054,900 109,659 217,177 326,836 43,566,600 26,445,100 297,662 1,023,422 4 Total 56,233,700 68,595,000 124,828,700 266,532 787,433 1,053,965 120,000,900 65,687,500 4,170,912 1,023,422 Unmetered Customers 5 Single Family 7,234,100 9,740,900 16,975,000 34,288 111,820 146,108 16,009,300 8,507,400 676,300 6 Mu ltifamily 4,700,200 4,980,500 9,680,700 22,278 57,173 79,451 9,560,200 5,443,400 233,830 7 Total 11,934,300 14,721,400 26,655,700 56,565 168,994 225,559 25,569,500 13,950,800 910,130 8 Surcharge 16,000,000 16,000,000 To tal System 9 Sin gle Family 31,692,300 51,450,700 83,143,000 150,213 590,626 740,839 75,612,400 37,818,500 4,300,910 10 Multifamily 13,339,600 12,946,900 26,286,500 63,226 148,623 211,849 26,391,400 15,374,700 482,470 11 Non -Residential 23,136,100 18,918,800 42,054,900 109,659 217,177 326,836 43,566,600 26,445,100 297,662 1,023,422 12 Su rcharge 16,000,000 16,000,000 13 Total 68,168,000 83,316,400 151,484,400 323,098 956,427 1,279,524 161,570,400 95,638,300 5,081,042 1,023,422 Ccf - H un dred Cubic Feet Table 3-17 Allocation of Wastewater Cost of Service to Customer Classes Test Year 2013 (1) (2) (3) (4) (5) (6) (7) Non - Line Wastewater Strength All Residential No. Description Total Volume Capacity TSS BOD Customers Customers Costs of Service 1 Net O&M Expense 145,596,800 23,650,000 71,540,300 13,533,700 17,509,400 17,249,500 2,113,900 2 Estimated Replacements 64,366,600 12,146,400 42,829,400 2,821,900 6,568,900 3 Total OM&R 209,963,400 35,796,400 114,369,700 16,355,600 24,078,300 17,249,500 2,113,900 4 Net Capital Costs 34,340,400 2,100,100 30,616,700 487,800 1,135,800 5 Total 244,303,800 37,896,500 144,986,400 16,843,400 25,214,100 17,249,500 2,113,900 Number of Units 6 Units of Service Unit Costs - $/unit 7 OM&R Line 3 / Line 6 8 Total Line 5 / Line 6 151,484,400 1,279,524 161,570,400 95,638,300 5,081,042 1,023,422 Ccf Ccf/day Pounds Pounds Bills Equiv. Bills 0.23630 89.38455 0.10123 0.25176 3.39487 2.06552 0.25017 113.31274 0.10425 0.26364 3.39487 2.06552 Single Family Metered 9 Units of Service 66,168,000 594,731 59,603,100 29,311,100 3,624,610 10 Cost - $ Line 9 x Line 8 110,189,900 16,553,100 67,390,600 6,213,500 7,727,600 12,305,100 Unmetered 11 Units of Service 16,975,000 146,108 16,009,300 8,507,400 676,300 12 Cost - $ Line 11 x Line 8 27,010,300 4,246,600 16,555,900 1,668,900 2,242,900 2,296,000 Multi Family Metered 13 Units of Service 16,605,800 132,398 16,831,200 9,931,300 248,640 14 Cost - $ Line 13 x Line 8 24,373,600 4,154,200 15,002,400 1,754,600 2,618,300 844,100 Unmetered 15 Units of Service 9,680,700 79,451 9,560,200 5,443,400 233,830 16 Cost - $ Line 15 x Line 8 14,650,100 2,421,800 9,002,800 996,600 1,435,100 793,800 Non -Residential 17 Units of Service 42,054,900 326,836 43,566,600 26,445,100 297,662 1,023,422 18 Cost - $ Line 17 x Line 8 62,193,800 10,520,800 37,034,700 4,541,900 6,972,000 1,010,500 2,113,900 Surcharge 19 Units of Service 16,000,000 16,000,000 20 Cost - $ Line 19 x Line 8 5,886,100 1,667,900 4,218,200 21 Total Cost - $ 244,303,800 37,896,500 144,986,400 16,843,400 25,214,100 17,249,500 2,113,900 Ccf - Hundred Cubic feet Table 3-18 Comparison of Wastewater Cost of Service With Revenue Under Existing and Approved Rates Test Year 2013 Line No. Customer Class (1) (2) (3) (4) Revenue Revenue Allocated Under Under Indicated Cost of Existing Approved Revenue Service Rates (a) Rates (b) Increase $ $ $ % Metered Customers (1) / (3) 1 Single Family 110,189,900 90,536,400 94,405,800 16.7 2 Multifamily 24,373,600 20,275,800 21,046,400 15.8 3 Non -Residential (c) 68,079,900 65,836,000 68,693,700 (0.9) 4 Total 202,643,400 176,648,200 184,145,900 10.0 Unmetered Customers 5 Single Family 27,010,300 22,215,800 23,276,900 16.0 6 Multifamily 14,650,100 12,155,700 12,670,700 15.6 7 Total 41,660,400 34,371,500 35,947,600 15.9 Total System 8 Single Family 9 Multifamily 10 Non -Residential 11 Total 13 7,200,200 112, 752,200 117, 682,700 16.6 39,023,700 32,431,500 33,717,100 15.7 68,079,900 65,836,000 68,693,700 (0.9) 244,303,800 211,019,700 220,093,500 11.0 (a) Existing Rates effective July 1, 2010. Does not include customer class impact of approved user charges that will be effective on July 1, 2011. (b) Rates approved by the Board to be effective July 1, 2011. (c) Includes cost of service associated with surcharges and impact of shifting part of Environmental Compliance costs to all customer classes. Table 3-19 Proposed Wastewater Rates User/Capital Charge Breakdown (Rates Effective July 1, 2012) Line No. Type of Monthly Charge Base Charge - $Bill 1 Billing & Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge Compliance Charge - $/Bill (a) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 Total User Capital Wastewater Charge Charge Charge 3.25 0.00 3.25 8.08 1.92 10.00 11.33 1.92 13.25 23.00 0.00 23.00 40.25 0.00 40.25 85.70 0.00 85.70 125.65 0.00 125.65 165.60 0.00 165.60 Volume Charge 9 Metered - $/Ccf 2.03 0.36 2.39 Unmetered - $Bill 10 Each Room 1.34 0.21 1.55 11 Each Water Closet 5.03 0.80 5.83 12 Each Bath 4.19 0.67 4.86 13 Each Separate Shower 4.19 0.67 4.86 Extra Strength Surcharges - $/ton (a) 14 Suspended Solids over 300 mg/1 15 BOD over 300 mg/I 16 COD over 600 mg/1 Ccf - Hundred Cubic Feet mg/I - milligram per liter 202.46 503.53 251.77 28.89 116.61 58.31 231.35 620.14 310.07 Table 3-20 Proposed Wastewater Rates by Customer Class (Rates Effective July 1, 2012) Metered Line Unmetered Non - No Type of Monthly Charge Residential Residential Residential Base Charge - $/Bill 1 Billing and Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge Compliance Charge (a) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 $ $ $ 3.25 3.25 3.25 10.00 10.00 10.00 13.25 13.25 13.25 23.00 40.25 85.70 125.65 165.60 Volume Charge 9 per Ccf 2.39 2.39 10 per room 1.55 11 per water closet 5.83 12 per bath 4.86 13 per separate shower 4.86 Extra Strength Surcharge - $/ton (a) 14 Suspended Solids over 300mg/1 15 BOD over 300 mg/1 16 COD over 600 mg/1 Ccf - Hundred Cubic Feet mg/1 - milligram per liter (a) Applicable only to non-residential customers. Note: Rates for qualified low income residential users are 50 percent of the regular rates above. 231.35 620.14 310.07 Table 3-21 Comparison of Existing and Proposed Wastewater Rates Line No. Type of Monthly Charge FY 2011 FY 2012 Existing Approved Proposed Wastewater Charges 2011 2012 (a) 2013 2014 2015 2016 Base Charge - $Bill 1 Billing & Collection Charge 2.60 2.65 3.25 3.45 3.60 3.70 2 System Availability Charge 8.80 9.20 10.00 11.50 13.40 15.75 3 Total Base (Residential) Service Charge 11.40 11.85 13.25 14.95 17.00 19.45 Compliance Charge - $Bill (b) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 30.85 31.95 23.00 16.00 9.00 2.35 30.85 31.95 40.25 42.60 44.05 45.35 30.85 31.95 85.70 90.65 93.80 96.55 30.85 31.95 125.65 132.95 137.50 141.55 30.85 31.95 165.60 175.20 181.20 186.55 Volume Charge 9 Metered - $/Ccf 2.02 2.11 2.39 2.72 3.07 3.45 Unmetered - $/Bill 10 Each Room 1.32 1.38 1.55 1.77 2.00 2.24 11 Each Water Closet 4.93 5.15 5.83 6.64 7.49 8.42 12 Each Bath 4.11 4.30 4.86 5.53 6.24 7.01 13 Each Separate Shower 4.11 4.30 4.86 5.53 6.24 7.01 Extra Strength Surcharges - $/ton (b) 14 Suspended Solids over 300 mg/1 15 BOD over 300 mg/1 16 COD over 600 mg/1 Typical Residential Bill - $/Bill (c) 17 User Charge Portion 18 Capital Charge Portion 222.62 231.35 231.35 231.68 257.18 265.68 596.72 620.14 620.14 620.14 652.14 673.30 298.36 310.07 310.07 310.07 326.07 336.65 24.28 26.19 27.56 29.87 32.75 34.76 1.26 2.54 4.81 6.84 8.81 12.29 19 Total 27.56 28.73 32.37 36.71 41.56 47.05 Ccf - Hundred Cubic Feet mg/1- milligram per liter (a) 2012 approved rates to be effective July 1, 2011. (b) Applicable only to non-residential customers. (c) Based on contributed wastewater volume of 8 Ccf per month. Table 3-22 Non -Residential Equivalent Bills (1) (2) (3) (4) (5) (6) 2010 Percentage Monthly Rate Allocated 2010 Distribution Unit Cost Equivalent Block Cost Customers of Customers Cost Ratio Bills $ $/Customer Tier 1 514,800 23,665 94.04% 1.81 1.000 284,000 Tier 2 186,500 440 1.75% 35.32 19.485 102,900 Tier 3 613,800 680 2.70% 75.22 41.494 338,600 Tier 4 304,400 230 0.91% 110.29 60.839 167,900 Tier 5 261,600 150 0.60% 145.33 80.170 144,300 Total 1,881,100 25,165 100.00% 1,037,700 Table 3-23 Comparison of Wastewater Cost of Service With Revenue Under Proposed Rates Test Year 2013 Line No. Customer Class Metered Customers 1 Single Family 2 Multifamily 3 Non -Residential (a) 4 Total Unmetered Customers 5 Single Family 6 Multifamily 7 Total Total System 8 Single Family 9 Multifamily 10 Non -Residential (a) 11 Total (a) Includes revenue and allocated surcharge customers. (1) (2) Revenue Under Allocated Proposed Cost of Rates Service $ $ 106,259,200 23,930,700 73,993,900 110,189,900 24,373,600 68,079,900 204,183,800 202,643,400 26,066,100 27,010,300 14,291,400 14,650,100 40,357,500 41,660,400 132,325,300 38,222,100 73,993,900 137,200,200 39,023,700 68,079,900 244,541,300 244,303,800 cost of service associated with (3) Revenue As a Percent of Cost of Service % (1) / (2) 96.4 98.2 108.7 100.8 96.5 97.6 96.9 96.4 97.9 108.7 100.1 Table 3-24 Alternative Wastewater Rates Line No. Type of Monthly Charge Base Charge - $Bill 1 Billing & Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge Compliance Charge - $Bill (b) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 Alternative Wastewater Charges 2012 (a) 2013 2014 2015 2016 2.65 3.25 3.45 3.60 3.70 9.20 26.50 26.60 26.80 27.10 11.85 29.75 30.05 30.40 30.80 31.95 23.00 16.00 9.00 2.35 31.95 40.25 42.60 44.05 45.35 31.95 85.70 90.65 93.80 96.55 31.95 125.65 132.95 137.50 141.55 31.95 165.60 175.20 181.20 186.55 Volume Charge 9 Metered - $/Ccf 2.11 5.45 5.45 5.45 5.45 Unmetered - $Bill 10 Each Room 1.38 3.55 3.55 3.55 3.55 11 Each Water Closet 5.15 13.30 13.30 13.30 13.30 12 Each Bath 4.30 11.08 11.08 11.08 11.08 13 Each Separate Shower 4.30 11.08 11.08 11.08 11.08 Extra Strength Surcharges - $/ton (b) 14 Suspended Solids over 300 mg/1 15 BOD over 300 mg/1 16 COD over 600 mg/1 Typical Residential Bill - $Bill (c) 17 User Charge Portion 18 Capital Charge Portion 231.35 267.35 267.35 267.35 267.35 620.14 685.94 685.94 685.94 685.94 310.07 342.97 342.97 342.97 342.97 26.19 37.29 30.71 33.41 35.31 2.54 36.06 42.94 40.59 39.09 19 Total 28.73 73.35 73.65 74.00 74.40 20 Total Bill with Bond Financing 28.73 32.37 36.71 41.56 47.05 Ccf - Hundred Cubic Feet mg/1 - milligram per liter (a) 2012 approved rates to be effective July 1, 2011. (b) Applicable only to non-residential customers. (c) Based on contributed wastewater volume of 8 Ccf per month. Table 3-25 Proposed and Alternative Wastewater Rates Comparison Line No. Type of Monthly Charge Base Charge - $/Bill 1 Billing & Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge Compliance Charge - $/Bill (a) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 Fiscal Year 2013 Fiscal Year 2016 Proposed Alternative Proposed Alternative 3.25 10.00 13.25 23.00 40.25 85.70 125.65 165.60 3.25 26.50 29.75 23.00 40.25 85.70 125.65 165.60 3.70 3.70 15.75 27.10 19.45 30.80 2.35 2.35 45.35 45.35 96.55 96.55 141.55 141.55 186.55 186.55 Volume Charge 9 Metered - $/Ccf 2.39 5.45 3.45 5.45 Unmetered - $/Bill 10 Each Room 1.55 3.55 2.24 3.55 11 Each Water Closet 5.83 13.30 8.42 13.30 12 Each Bath 4.86 11.08 7.01 11.08 13 Each Separate Shower 4.86 11.08 7.01 11.08 Extra Strength Surcharges - $/ton (a) 14 Suspended Solids over 300 mg/1 15 BOD over 300 mg/1 16 COD over 600 mg/1 Typical Residential Bill - $/Bill (b) 17 User Charge Portion 18 Capital Charge Portion 231.35 620.14 310.07 27.56 4.81 267.35 685.94 342.97 37.29 36.06 265.68 267.35 673.30 685.94 336.65 342.97 34.76 35.31 12.29 39.09 19 Total 32.37 73.35 47.05 74.40 Ccf - Hundred Cubic Feet mg/1 - milligram per liter (a) Applicable only to non-residential customers. (b) Based on contributed wastewater volume of 8 Ccf per month. Table 4-1 Existing Stormwater Rates and Taxes (Effective August 1, 2010) Type of Monthly Charge Original Co. County City Boundary Annexed $ $ $ Monthly Charge Multifamily Residential - $/Unit 0.18 0.18 0.18 Single Family Res. & Non -Res- $/Account 0.24 0.24 0.24 District -Wide Tax per $100 Assessed Value 0.018 0.018 0.018 Stormwater O&M Tax per $100 Assessed Value 0.061 0.061 Subdistrict Specific Taxes NA (a) NA (a) Subdistrict specific tax levies range from $0.00 to $0.10 per $100 of assessed valuation. NA - Not Applicable Table 4-2 Historical and Pr ojected Billed Stormw ater User Charge Re venue Under Existing Rates Line No. Cu stomer Class 1 Flat Rate (a) 2 Impervious Area Charges (b) 3 Total Historical Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ $ $ $ $ $ 1,237,938 1,237,938 832,100 0 0 1,181,900 1,356,100 1,353,600 1,352,200 1,351,100 1,350,300 0 0 12,286,700 41,580,100 43,416,128 3,625,300 0 0 0 0 0 1,237,938 1,237,938 13,118,800 41,580,100 43,416,128 4,807,200 1,356,100 1,353,600 1,352,200 1,351,100 1,350,300 (a) Flat rate charge were reinstated on August 1, 2010 with m ultifamily customers charged on a per unit basis effective February 1, 2011. (b) Fiscal Year 2011 in cludes on e month of impervious area charge re ven ue. T able 4-3 Hi st orical and Pr ojected St ormwater OMCI Re venue Under E xisting Tax Rates Line Historical Projected No. Su bdistrict 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ $ $ $ $ $ 1 District -Wide 4,601,860 5,147,691 3,500,000 0 0 4,903,100 4,948,100 4,993,100 5,038,100 5,083,100 5,128,100 2 Stormwater O&M 6,749,957 7,568,117 5,146,000 0 0 9,911,700 10,003,200 10,094,700 10,186,200 10,277,700 10,369,200 Subdistricts 3 Coldwater Creek 1,525,934 1,596,366 1,804,734 46,906 24,061 2,187,000 1,972,000 1,992,000 2,032,000 2,037,000 2,042,000 4 Wedgewood 28,330 29,216 33,941 1,694 221 0 0 0 0 0 0 5 Upper Paddock Creek 20,831 21,576 26,183 1,505 1,051 0 0 0 0 0 0 6 Paddock Creek 92,257 94,261 114,392 5,999 2,276 0 0 0 0 0 0 7 Fountain Creek 131,107 133,613 160,773 7,818 3,225 0 0 0 0 0 0 8 Maline Creek 445,722 464,539 534,392 51,374 14,309 855,000 630,000 636,000 650,000 652,000 654,000 9 Black Jack-Dellwood 146,409 152,499 170,735 17,349 4,370 0 0 0 0 0 0 10 Watkins Creek 94,877 97,808 120,549 7,393 4,389 161,000 161,000 163,000 166,000 166,000 166,000 11 Su gar Creek 216,404 222,032 232,155 3,094 0 219,000 219,000 221,000 226,000 227,000 228,000 12 D eer Creek 2,101,960 2,184,423 2,606,879 43,043 12,196 3,250,000 3,250,000 3,283,000 3,350,000 3,358,000 3,366,000 13 Clayto n Central 184,064 210,675 240,130 5,368 0 0 0 0 0 0 0 14 Creve Coeur/Fronten ac 252,882 270,459 328,795 2,848 0 0 0 0 0 0 0 15 Bla ck Creek 788,464 836,478 978,195 17,403 2,840 1,304,000 1,304,000 1,317,000 1,343,000 1,346,000 1,349,000 16 Univ ersity City RD P 651,082 680,193 790,879 32,700 11,633 789,000 789,000 797,000 813,000 815,000 817,000 17 Gravo is Creek 958,305 1,001,334 1,169,848 14,336 1,923 1,268,000 1,268,000 1,280,000 1,305,000 1,308,000 1,311,000 18 Loretta -Joplin 15,337 15,265 18,420 1,104 576 20,000 20,000 20,000 21,000 21,000 21,000 19 N. Affton Area 43,800 44,364 52,607 1,334 547 56,000 56,000 57,000 58,000 58,000 58,000 20 Wellston 35,677 38,147 40,923 5,022 1,277 35,000 35,000 35,000 36,000 36,000 36,000 21 Seminary Branch-RDP 183,575 184,977 211,438 3,535 709 248,000 214,000 216,000 220,000 221,000 222,000 22 Marlborou gh 24,025 24,700 29,001 552 174 0 0 0 0 0 0 23 Shrewsbury-RD P 16,893 17,231 18,123 464 48 18,000 18,000 18,000 19,000 19,000 19,000 24 Total Subdistrict Revenue 7,957,935 8,320,156 9,683,092 270,841 85,825 10,410,000 9,936,000 10,035,000 10,239,000 10,264,000 10,289,000 25 Total OMCI Revenu e 19,309,752 21,035,965 18,329,092 270,841 85,825 25,224,800 24,887,300 25,122,800 25,463,300 25,624,800 25,786,300 (a) Ad V alorem Taxes were reinstated on Augu st 1, 2010 and c ertified by the Missouri State Au ditor on October 1, 2010. Table 4-4 Projected Stormwater Other Operating Revenue Line Fiscal Year Ending June 30, No. Description 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ Stormwater Billing Adjustment 1 Late Charges 40,000 39,700 39,500 39,400 39,400 39,400 2 Billed Account Refunds 0 0 0 0 0 0 3 Adjustments 100 100 100 100 100 100 4 Bad Debt Provision 0 0 0 0 0 0 5 City of Arnold WWT 0 0 0 0 0 0 6 NSF Fees 100 200 200 200 200 200 7 Stormwater Lien Interest and Fees 700 700 700 700 700 700 8 Other 0 0 0 0 0 0 9 Subtotal 40,900 40,700 40,500 40,400 40,400 40,400 Other Fees 10 Construction Inspection Fees 100,000 103,000 106,100 109,300 112,600 116,000 11 Plan Review Fees 62,500 64,400 66,300 68,300 70,400 72,500 12 Submittal Fees 85,000 87,500 90,200 92,900 95,700 98,500 13 Waste Hauler Permits 0 0 0 0 0 0 14 Stormwater Monitoring Costs Fees 0 0 0 0 0 0 15 Pretreatment Discharge Permits 0 0 0 0 0 0 16 All Other 0 0 0 0 0 0 17 Subtotal 247,500 254,900 262,600 270,500 278,700 287,000 Miscellaneous Revenue 18 Reimbursements 0 0 0 0 0 0 19 Sale of Fixed Assets 0 0 0 0 0 0 20 Reimbursable Engr. & Maint. 32,000 33,000 33,900 35,000 36,000 37,100 21 Rental Income 40,000 41,200 42,400 43,700 45,000 46,400 22 Build America Bond Credits 0 0 0 0 0 0 23 All Other 109,000 111,500 114,800 118,300 121,800 125,500 24 Subtotal 181,000 185,700 191,100 197,000 202,800 209,000 25 Total Other Operating Revenue 469,400 481,300 494,200 507,900 521,900 536,400 26 Connection Fee Revenue 0 0 0 0 0 0 Table 4-5 Projected Stormwater Operating Costs Line Fiscal Year Ending June 30, No Department 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ 1 Board of Trustees 400 400 400 400 400 400 2 Rate Commission 37,300 0 0 0 125,000 0 3 Civil Service Commission 900 900 900 900 900 900 4 Secretary - Treasurer 192,500 200,200 207,900 217,800 227,100 236,400 5 Executive Director 120,100 124,800 129,700 135,300 140,200 145,200 6 General Counsel 432,000 448,000 463,400 484,400 505,200 526,300 7 Office of Human Resources 1,456,600 1,528,800 1,604,600 1,692,700 1,783,200 1,859,700 8 Engineering 3,474,800 3,445,100 3,339,800 3,239,200 3,112,600 2,967,500 Operations 9 Collection System (a) 8,361,000 8,174,200 8,201,100 8,367,700 8,384,800 8,469,300 10 Pump Stations 731,300 758,500 786,100 821,200 854,700 887,800 11 Wastewater Treatment (b) 0 0 0 0 0 0 12 Support (c) 1,390,000 1,442,400 1,497,500 1,558,700 1,616,000 1,672,000 13 Total Operations 10,482,300 10,375,100 10,484,700 10,747,600 10,855,500 11,029,100 14 Finance 0 0 0 0 0 0 15 Information Systems 1,365,100 1,415,800 1,468,800 1,528,700 1,584,100 1,639,300 16 Subtotal (General Fund) 17,562,000 17,539,100 17,700,200 18,047,000 18,334,200 18,404,800 17 Water Backup Program 0 0 0 0 0 0 18 Real Property Fund 176,300 181,600 187,000 192,600 198,400 204,400 19 Total O&M 17,738,300 17,720,700 17,887,200 18,239,600 18,532,600 18,609,200 20 Capital Outlay 21 Total Operating Expense 526,300 544,700 561,000 577,800 595,200 613,000 18,264, 600 18,265,400 18,44 8,200 18, 817,400 19,127,800 19,222,200 (a) Includes Mintert, Sulphur, and Grand Glaize maintenance yards and technical services. (b) Includes Lemay, Bissell, and county treatment plants. (c) Includes costs related to the customer care group, administrative support and materials management. Table 4-6 Comparison of Projected Stormwater Revenue Under Existing Rates and Taxes With Projected Revenue Requirements Line Fiscal Year Ending June 30, No. 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ Stormwater Operations Stormwater User Charge Revenue 1 Flat Rate 1,181,900 1,356,100 1,353,600 1,352,200 1,351,100 1,350,300 2 Impervious Area Charges 3,625,300 0 0 0 0 0 Ad Valorem Taxes 3 District -Wide 4,903,100 4,948,100 4,993,100 5,038,100 5,083,100 5,128,100 4 Stormwater O&M 9,911,700 10,003,200 10,094,700 10,186,200 10,277,700 10,369,200 5 Other Revenue 469,400 481,300 494,200 507,900 521,900 536,400 6 Interest Income - Reserve Funds 41,500 45,000 45,200 45,800 46,400 46,800 7 Interest Income -Operations 93,100 94,500 79,500 64,000 46,300 28,200 8 Total Stormwater Operating Revenue 20,226,000 16,928,200 17,060,300 17,194,200 17,326,500 17,459,000 9 Operation and Maintenance Expense 17,738,300 17,720,700 17,887,200 18,239,600 18,532,600 18,609,200 10 Routine Annual Improvements 526,300 544,700 561,000 577,800 595,200 613,000 11 Cash Financing of Major Improvements 0 0 0 0 0 0 12 Additions to Operating Reserve 90,100 100 30,100 60,700 51,000 15,500 13 Transfer to Stormwater Emergency Fund 250,000 14 Total Revenue Requirements 18,354,700 18,515,500 18,478,300 18,878,100 19,178,800 19,237,700 15 Net Annual Balance 16 Beginning of Year Balance 17 End of Year Balance 1,871,300 (1,587,300) (1,418,000) (1,683,900) (1,852,300) (1,778,700) 8,376,800 10,248,100 8,660,800 7,242,800 5,558,900 3,706,600 10,248,100 8,660,800 7,242,800 5,558,900 3,706,600 1,927,900 OMCI Subdistricts 18 OMCI Revenue Under Existing Rates 10,410,000 9,936,000 10,035,000 10,239,000 10,264,000 10,289,000 19 Interest Income 425,300 427,800 456,900 544,600 653,100 762,900 20 OMCI Existing Major Improvements 9,400,000 11,308,000 3,730,000 0 0 0 21 Net Annual Balance 22 Beginning of Year Balance 23 End of Year Balance 1,435,300 (944,200) 6,761,900 10,783,600 10,917,100 11,051,900 41,814,100 43,249,400 42,305,200 49,067,100 59,850,700 70,767,800 43,249,400 42,305,200 49,067,100 59,850,700 70,767,800 81,819,700 Table 5-1 Projected Wastewater and Stormwater Revenue Line No. Revenue Source Wastewater Utility 1 Service Charge Revenue 2 Other Operating Revenue 3 Connection Fee Revenue 4 Interest Income - Reserve Funds 5 Interest Income - Operations 6 Interest Income - Arnold 7 Total Wastewater Revenue Stormwater Utility (a) 8 Service Charge Revenue Ad Valorem Taxes 9 District -Wide 10 Stormwater O&M 11 Other Revenue 12 Interest Income - Reserve Funds 13 Interest Income - Operations 14 Subtotal Stormwater Revenue 15 Subdistrict OMCI Taxes 16 Interest Income - OMCI 17 Total Stormwater Revenue Combined Utility 18 Total Revenue Fiscal Year Ending June 30, 2011 2012 2013 2014 2015 213,795,600 220,387,500 242,286,300 270,743,000 302,973,200 (750,500) 3,382,400 1,250,000 1,288,000 888,800 964,300 30,800 47,300 650,700 631,000 215,865,400 2 4,807,200 4,903,100 9,911,700 469,400 41,500 93,100 20,226,000 10,410,000 425,300 31,061,300 1,271,100 1,327,000 1,196,600 50,100 610,500 295,400 1,367,000 1,486,600 50,500 589,100 (824,500) 1,408,000 1,753,500 50,500 566,800 2016 339,217,100 (2,084,700) 1,450,000 1,969,100 50,200 543,600 26,700,500 246,741,600 274,531,600 305,927,500 341,145,300 1,356,100 1,353,600 1,352,200 1,351,100 4,948,100 10,003,200 481,300 45,000 94,500 4,993,100 10,094,700 494,200 45,200 79,500 5,038,100 10,186,200 507,900 45,800 64,000 5,083,100 10,277,700 521,900 46,400 46,300 1,350,300 5,128,100 10,369,200 536,400 46,800 28,200 16,928,200 17, 060,3 00 17,194,200 17, 326,500 17,459,000 9,936,000 10,03 5,000 10,239,000 10,264,000 10,289,000 427,800 456,900 544,600 653,100 762,900 27,292,000 27,552,200 27,977,800 28,243,600 28,510,900 246,926,700 253,992,500 274,293,800 302,509,400 334,171,100 369,656,200 Table 5-2 Projected Wastewater and Stormwater Revenue Requirements Line No. Revenue Requirement Fiscal Year Ending June 30, 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ Wastewater Utility 1 Operation and Maintenance Expense 134,394,800 138,803,800 145,581,400 154,131,500 164,235,800 170,084,100 2 Routine Annual Improvements 2,378,600 2,461,900 2,535,700 2,611,800 2,690,100 2,770,900 3 Debt Service 38,404,300 45,718,300 65,795,500 83,051,200 99,077,900 111,467,300 4 Cash Financing of Improvements 37,250,000 38,438,000 31,677,000 33,267,000 38,308,000 55,850,000 5 Addition to Operating Reserve 674,500 738,500 1,126,200 1,418,000 1,673,900 974,600 6 Total Wastewater 213,102,200 226,160,500 246,715,800 274,479,500 305,985,700 341,146,900 Stormwater Utility 7 Operation and Maintenance Expense 17,738,300 17,720,700 17,887,200 18,239,600 18,532,600 18,609,200 8 Routine Annual Improvements 526,300 544,700 561,000 577,800 595,200 613,000 9 Cash Financing of Improvements 0 0 0 0 0 0 10 Additions to Operating Reserve 90,100 100 30,100 60,700 51,000 15,500 11 Subtotal Stormwater 18,354,700 18,265,500 18,478,300 18,878,100 19,178,800 19,237,700 12 OMCI Existing Major Improvements 9,400,000 11,308,000 3,730,000 0 0 0 13 Total Stormwater 27,754,700 29,573,500 22,208,300 18,878,100 19,178,800 19,237,700 Combined Utility 14 Total Combined Utility 240,856,900 255,734,000 268,924,100 293,357,600 325,164,500 360,384,600 Table 5-3 Comparison of Combined Revenue Under Projected Rates and Taxes with Total Revenue Requirements Line Fiscal Year Ending June 30, No. Description 2011 2012 2013 2014 2015 2016 $ $ $ $ $ $ Combined Wastewater & Stormwater Operations Revenue 1 Wastewater Service Charge Revenue 213,795,600 220,387,500 242,286,300 270,743,000 302,973,200 339,217,100 2 Wastewater Connection Fee Revenue 1,250,000 1,288,000 1,327,000 1,367,000 1,408,000 1,450,000 3 Stormwater User Charge Revenue 4,807,200 1,356,100 1,353,600 1,352,200 1,351,100 1,350,300 4 Stormwater Ad Valorem Taxes 14,814,800 14,951,300 15,087,800 15,224,300 15,360,800 15,497,300 5 Other Revenue (281,100) 3,863,700 1,765,300 803,300 (302,600) (1,548,300) 6 Interest Income - Reserve Funds 930,300 1,009,300 1,241,800 1,532,400 1,799,900 2,015,900 7 Interest Income - Operations 123,900 141,800 129,600 114,500 96,800 78,400 8 Interest Income - Arnold 650,700 631,000 610,500 589,100 566,800 543,600 9 Total Revenue 236,091,400 243,628,700 263,801,900 291,725,800 323,254,000 358,604,300 Revenue Requirements 10 Operation and Maintenance Expense 152,133,100 156,524,500 163,468,600 172,371,100 182,768,400 188,693,300 11 Routine Annual Improvements 2,904,900 3,006,600 3,096,700 3,189,600 3,285,300 3,383,900 12 Debt Service 38,404,300 45,718,300 65,795,500 83,051,200 99,077,900 111,467,300 13 Cash Financing of Major Improvements 37,250,000 38,438,000 31,677,000 33,267,000 38,308,000 55,850,000 14 Additions to Operating Reserve 764,600 738,600 1,156,300 1,478,700 1,724,900 990,100 15 Total Revenue Requirements 231,456,900 244,426,000 265,194,100 293,357,600 325,164,500 360,384,600 16 Surplus (Deficit) Revenue 17 Beginning of Year Balance 18 End of Year Balance 4,634,500 (797,300) (1,392,200) (1,631,800) (1,910,500) (1,780,300) 10,073,700 14,708,200 13,910,900 12,518,700 10,886,900 8,976,400 14,708,200 13,910,900 12,518,700 10,886,900 8,976,400 7,196,100 Dediicated Stormwater OMCI Subdistrict Funds 19 OMCI Taxes 10,410,000 9,936,000 10,035,000 10,239,000 10,264,000 10,289,000 20 Interest Income 425,300 427,800 456,900 544,600 653,100 762,900 21 OMCI Major Improvements 9,400,000 11,308,000 3,730,000 0 0 0 22 Surplus (Deficit) Stormwater OMCI Fund 1,435,300 (944,200) 6,761,900 10,783,600 10,917,100 11,051,900 23 Beginning of Year Balance 41,814,100 43,249,400 42,305,200 49,067,100 59,850,700 70,767,800 24 End of Year Balance 43,249,400 42,305,200 49,067,100 59,850,700 70,767,800 81,819,700 Table 5-4 Proposed Wastewater Rates And Existing Stormwater Charges (Rates Effective July 1, 2012) Metered Line Unmetered Non - No Type of Monthly Charge Residential Residential Residential $ $ $ Proposed Wastewater Rates Base Charge - $/Bill 1 Billing and Collection Charge 3.25 3.25 3.25 2 System Availability Charge 10.00 10.00 10.00 3 Total Base (Residential) Service Charge 13.25 13.25 13.25 Compliance Charge 4 Tier 1 23.00 5 Tier 2 40.25 6 Tier 3 85.70 7 Tier 4 125.65 8 Tier 5 165.60 Volume Charge 9 per Ccf 2.39 2.39 10 per room 1.55 11 per water closet 5.83 12 per bath 4.86 13 per separate shower 4.86 Extra Strength Surcharge - $/ton 14 Suspended Solids over 300mg/1 231.35 15 BOD over 300 mg/1 620.14 16 COD over 600 mg/1 310.07 Existing Stormwater Rates and Taxes Monthly Charge 17 Single Family Residential - $/Account 0.24 0.24 18 Multifamily Residential - $/Unit 0.18 0.18 19 Non-Residentialr - $/Account 0.24 20 District -Wide Tax (a) 0.018 0.018 0.018 Stormwater O&M Tax (a) 21 City and Original County Boundary 0.061 0.061 0.061 22 County Annexed Area NA NA NA Ccf - Hundred Cubic Feet mg/1 - milligram per liter (a) Per $100 of assessed value. Note: Rates for qualified low income residential users are 50 percent of the above rates. Table 5-5 Typical Single Family Residential Wastewater Bill Comparison (Rates Effective July 1, 2012) FY 2011 FY 2012 FY 2013 Housing Attributes Billable Existing Approved Proposed Percent R WC B S Volume Rates Rates Rates Increase Increase Ccf $ $ $ $ Over Unmetered (Eff. 7/1/10) (Eff. 7/1/11) (Eff. 7/1/12) 2012 Rates 3 1 1 0 6.4 24.40 25.44 28.59 3.15 12.4% 4 1 1 0 7.1 25.72 26.82 30.14 3.32 12.4% 5 1 1 0 Avg. 7.7 27.04 28.20 31.69 3.49 12.4% 6 1 1 0 8.4 28.36 29.58 33.24 3.66 12.4% 7 1 1 0 9.0 29.68 30.96 34.79 3.83 12.4% 6 1 1 1 10.4 32.47 33.88 38.10 4.22 12.5% 6 2 1 0 10.8 33.29 34.73 39.07 4.34 12.5% 7 2 1 0 11.5 34.61 36.11 40.62 4.51 12.5% 7 2 2 0 13.5 38.72 40.41 45.48 5.07 12.5% 8 2 2 0 14.2 40.04 41.79 47.03 5.24 12.5% 16 4 4 0 28.3 68.68 71.73 80.81 9.08 12.7% Metered Average Bill» 0 11.40 11.85 13.25 1.40 11.8% 2 15.44 16.07 18.03 1.96 12.2% 3 17.46 18.18 20.42 2.24 12.3% 4 19.48 20.29 22.81 2.52 12.4% 5 21.50 22.40 25.20 2.80 12.5% 6 23.52 24.51 27.59 3.08 12.6% 8 27.56 28.73 32.37 3.64 12.7% 10 31.60 32.95 37.15 4.20 12.7% 12 35.64 37.17 41.93 4.76 12.8% 15 41.70 43.50 49.10 5.60 12.9% 20 51.80 54.05 61.05 7.00 13.0% 40 92.20 96.25 108.85 12.60 13.1% 60 132.60 138.45 156.65 18.20 13.1% 100 213.40 222.85 252.25 29.40 13.2% Ccf - Hundred Cubic Feet R - Number of Rooms at 16 gallons per day (gpd). WC - Number of Water Closets at 60 gpd. B - Number of Baths at 50 gpd. S - Number of Separate Showers at 50 gpd Table 5-6 Typical Wastewater Bill Comparison Line No. 1 2 3 4 5 6 7 8 9 10 11 Billed Wastewater Vol ume A verage 50 Cities FY 2011 Existing Rates Ccf $/mo nth $/m onth (Eff. 7/1/09) (Eff. 7/1/10) Single Family Residential 0 5 (a) 8 Avg. 8 A vg. % Increase 10 (a) 15 (a) 20 Mu ltifamily R esidential 20 40 60 20 .03 33 .80 63.28 FY 2012 Appro ved Rates $/month (Eff. 7/1/11) FY 2013 FY 2014 FY 2015 Proposed Proposed Pr oposed Rates Rates Rates $/month $/month $/mo nth (Eff. 7/1/12) (Eff . 7/1/13) (Eff . 7/1/14) 11.40 11 .85 13 .25 14.95 17 .00 21 .50 22.40 25.20 28.55 32 .35 27.56 28 .73 32.37 36.71 41.56 4.2% 12.7% 13.4% 13 .2% 31.60 32.95 37.15 42 .15 47 .70 41.70 43.50 49.10 55 .75 63.05 51.80 54.05 61.05 69 .35 78.40 51.80 92.20 132.60 54.05 96.25 138.45 61 .05 108.85 156 .65 N on -R esiden tial - Normal Strength Wastewater, Tier 2 Compliance Charge 12 70 183. 65 191.50 220 .80 13 100 244. 25 254.80 292.50 14 160 365.45 381.40 435 .90 Non -R esiden tial 15 70 16 100 17 160 - Excess Stren gth Wastewater, Tier 2 Complian ce Charge (b) Ccf - H un dred Cu bic feet 210.49 282. 60 426. 80 219. 39 248.69 294. 65 332.35 445.16 499. 66 69 .35 78.40 123.75 139.80 178 .15 201 .20 247 .95 275.95 329.55 368.05 492.75 552 .25 275 .86 305.74 369.42 410 .61 556 .53 620 .34 (a) R esidential billed wastewater volu me presented in 2009/2010 Black & Veatch Survey of 50 Largest Cities . (b) Assumes wastewater strength is 150 mg/1 in ex cess of normal strength limits for both strength parameters . FY 2016 Proposed Rates $/mo nth (Eff . 7/1/15) 19.45 36.70 47.05 13.2% 53 .95 71 .20 88.45 88.45 157.45 226.45 306.30 409.80 616.80 337 .06 453 .74 687 .11 Table 5-7 Typical Stormwater Bill Comparison (Effective August 1, 2010) Taxes Total Inside Outside Inside Outside Average Original Original Flat Rate Original Original Line Assessed Units per District District User District District No. Value Account Boundary Boundary Fees Boundary Boundary $/month $/month $/month $/month $/month Single Family Residential (a) (b) 1 50,000 1 3.29 0.75 0.24 3.53 0.99 2 100,000 1 6.58 1.50 0.24 6.82 1.74 3 150,000 1 9.88 2.25 0.24 10.12 2.49 4 200,000 1 13.17 3.00 0.24 13.41 3.24 5 250,000 1 16.46 3.75 0.24 16.70 3.99 Multifamily Residential 6 200,000 2 13.17 3.00 0.36 13.53 3.36 7 400,000 4 26.33 6.00 0.72 27.05 6.72 8 600,000 6 39.50 9.00 1.08 40.58 10.08 Non -Residential 9 Tax Exempt 1 0.24 0.24 0.24 10 1,000,000 1 65.83 15.00 0.24 66.07 15.24 11 2,000,000 1 131.67 30.00 0.24 131.91 30.24 (a) Original District boundaries include the City of St. Louis and a portion of St. Louis County. Customers in this service area are charged a $0.018 per $100 of assessed value for District administration plus $0.061 per $100 of assessed value for general stormwater services. Part of this service area also pays OMCI taxes for local subdistrict capital improvements and additional stormwater related services. Other OMCI taxes are not reflected in this table. (b) Customers in this service area are only charged for District administration. Monies collected from this tax are used to meet regulatory and data collection needs and address emergency situations as they may arise. Table 5-8 Typical Wastewater Bills Under Pr op osed and Alternati ve Wastewater Rates Lin e No. Billed Wastewater Volume FY 2012 Appro ved Rates Fiscal Year 2013 Fiscal Year 2014 Fiscal Year 2015 Proposed Alternati ve Pr oposed Rates Rates Rates Ccf $/month $/mo nth $/month (Eff. 7/1/11) (Eff . 7/1/12) Sin gle Family Residential 1 0 11.85 2 5 22.40 3 8 28.73 4 8 4.2% 5 10 32.95 6 15 43.50 7 20 54. 05 8 9 10 11 12 13 14 Multifamily Residential 20 40 60 13.25 29 .75 25 .20 57 .00 32.37 73.35 12.7% 155 .3% 37. 15 84 .25 49.10 111.50 61.05 138.75 Alter native Proposed Alternative Rates Rates Rates Fiscal Year 2016 Proposed Alternati ve Rates Rates $/month $/month $/month $/month $/mo nth $/month (E ff. 7/1/13) (Eff. 7/1/14) (Eff. 7/1/15) 14.95 30.05 17.00 30.40 19.45 28.55 57 .30 32 .35 57.65 36 .70 36 .71 73 .65 41.56 74.00 47 .05 13 .4% 0.4% 13 .2% 0.5% 13.2% 42.15 84.55 47.70 84.90 53 .95 55 .75 111.80 63.05 112.15 71 .20 69 .35 139 .05 78 .40 139.40 88 .45 54.05 61.05 138. 75 69.35 96.25 108. 85 247. 75 123.75 138.45 156. 65 356.75 178.15 N on -R esidential - Normal Strength Wastewater, Tier 2 Compliance Charge 70 100 160 191.50 254. 80 381. 40 220.80 292.50 435.90 451. 50 247.95 615.00 329.55 942. 00 492. 75 N on -Residential - Ex cess Strength Wastewater, Tier 2 Compliance Charge (a) 15 70 219.39 248. 69 482. 73 275. 86 16 100 294.65 332.35 659.61 369.42 17 160 445.16 499.66 1,013.38 556. 53 Ccf - H un dred Cubic feet 30 .80 58 .05 74 .40 0.5% 85.30 112 .55 139 .80 139.05 78.40 139.40 88 .45 139.80 248.05 139 .80 248 .40 157 .45 248 .80 357 .05 201 .20 357.40 226 .45 357 .80 454.15 275 .95 455.95 306 .30 457 .65 617 .65 368.05 619 .45 409.80 621.15 944.65 552 .25 946.45 616.80 948 .15 485.38 305.74 487.18 337.06 488 .88 662. 26 410.61 664 .06 453 .74 665.76 1,016.03 620.34 1,017 .83 687.11 1,019 .53 (a) Assumes wastewater stren gth is 150 mg/1 in ex cess of normal strength limits fo r both strength parameters. Table 5-8A Typical Wastewater Bills Under Alternative Wastewater Rates Line No. 1 2 3 4 5 6 7 8 9 10 11 Billed Wastewater Volume FY 2012 Approved Rates FY 2013 FY 2014 FY 2015 FY 2016 Alternative Alternative Alternative Alternative Rates Rates Rates Rates Ccf $/month $/month $/month $/month $/month (Eff. 7/1/11) (Eff. 7/1/12) (Eff. 7/1/13) (Eff. 7/1/14) (Eff. 7/1/15) Single Family Residential 0 11.85 29.75 30.05 30.40 30.80 5 22.40 57.00 57.30 57.65 58.05 8 28.73 73.35 73.65 74.00 74.40 8 4.2% 155.3% 0.4% 0.5% 0.5% 10 32.95 84.25 84.55 84.90 85.30 15 43.50 111.50 111.80 112.15 112.55 20 54.05 138.75 139.05 139.40 139.80 Multifamily Residential 20 40 60 54.05 138.75 139.05 139.40 139.80 96.25 247.75 248.05 248.40 248.80 138.45 356.75 357.05 357.40 357.80 Non -Residential - Normal Strength Wastewater, Tier 2 Compliance Charge 12 70 191.50 451.50 454.15 13 100 254.80 615.00 617.65 14 160 381.40 942.00 944.65 Non -Residential 15 70 16 100 17 160 455.95 619.45 946.45 - Excess Strength Wastewater, Tier 2 Compliance Charge (a) 219.39 482.73 485.38 487.18 294.65 659.61 662.26 664.06 445.16 1,013.38 1,016.03 1,017.83 Ccf - Hundred Cubic feet (a) Assumes wastewater strength is 150 mg/1 in excess of normal strength limits for both strength parameters. 457.65 621.15 948.15 488.88 665.76 1,019.53