Loading...
HomeMy WebLinkAboutRate & Financing ReportJEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana RATE AND FINANCING REPORT July 23, 2004 Crowe /:/, / "// "' TM JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana TABLE OF CONTENTS PURPOSE OF THE REPORT EXHIBIT A SCHEDULE A-1 SCHEDULE A-2 SCHEDULE A-3 SCHEDULE A-4 EXHIBIT B EXHIBIT C SCHEDULE C-1 EXHIBIT D SCHEDULE D-1 SCHEDULE D-2 SCHEDULE D-3 SCHEDULE D-4 EXHIBIT E EXHIBIT F - Balance Sheets - Sewage Works Revenue Bonds, Series 1998 Amortization Schedule Sewage Works Revenue Bonds, Series 1999 State Revolving Fund (SP~F)Loan Estimated Amortization Schedule - Sewage Works Revenue Bonds, Series 2003 Amortization Schedule - Sewage Works RevenUe Refunding Bonds, Series 2004 Amortization Schedule - Statements of Income - Adjusted Statement of Income - Detail of Adjustments - Statement of Revenue Requirements - Capital Improvement Plan - Estimated Sources and Uses of Ftmds - Estimated Combined Amort2ation Schedule - Proposed Sewage Works Revenue Bonds of 2005 Estimated Amortization Schedule - Schedule of Present and Proposed Rates and Charges - Typical Monthly Bill Analysis Page 1 2 4 7 8 10 11 12 13 16 17 18 19 21 Crowe Crowe Chizek and Company LLC JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana PURPOSE OF THE REPORT I i I I I I I Crowe Chizek and Company LLC has performed a study and analysis of the operating and financial reports, budgets and other data pertaining to the Jeffersonville Mtmicipal Sewage Works (Utility). The results of our analysis are contained in this Rate and Financing Report (Report). The purpose of the Report is to estimate the Utility's cash flow and financial capacity to meet its on-going revenue requirements for operation and maintenance expenses, present and proposed debt service payments, and to make capital improvements to the Utility's system. This Report is based on data for the twelve months ended March 31, 2004. The historical information used in this Report was taken from the books and records of the Utility and was adjusted as necessary for fixed, known and measurable items as disclosed in the Exhibits and Schedules of this Report. In the course of preparing this Report, we have not conducted an audit of any financial or supplemental data used in the accompanying Exhibits and Schedules. We have made certain projections that may vary from actual results because events and circumstances frequently do not occur as estimated and such variances may be material. We have no responsibility to update this Report for events and circumstances occurring after the date of this Report. If you have any questions regarding this Report, please call John Skomp at (317) 269-6699 or Jennifer Wilson at (317) 269-6696. -1- I I I I I I ! I I I ! I I ! ! I I I JEFFERSON¥ILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Balance Sheets as of March 31, 2004, December 31, 2003, and 2002 EXHIBIT A ASSETS AND OTHER DEBITS March 31, December 31, December 2004 2003 2002 Utilitv Plant Utility Plant irt Service Less: Accumulated Depreciation Total Utility Plant in Service Add: Construction Work in Progress Net Utility Plant in Service Restricted Assets Construction Fund - Drainage Cumulative Improvement Ftmd Bond and Interest Ftmd Debt Service Reserve Fund Total Restricted Assets Current and Accrued Assets Operating Fund Operating Fund - Drainage Accounts Receivable - Net Accotmts Receivable - Drainage Inner City Road Loan Prepaid Expenses Total Current and Accrued Assets $ 41,736,498 (15,427,543) 26,308,955 $ 41,494,317 (15,235,917) 26,258,400 $ 42,230,554 (7,056,534) 35,174,020 631,156 26~308,955 26,258,40.~_.0 35,805,176 3,389,025 3,389,025 26%025 79,940 1,005,172 1,094,249 553,223 659,909 644,328 1,360,553 1,464,004 1,452,119 5,382,741' 6,518,110 3,459,721 385,916 (1,257,608) (1,841,672) 856,788 897,280 635,998 1,236,815 1,208,843 1;643;691 120,446 111,532 185,372 20,039 20,039 520,039 52,224 52,224 33,297 2,672,228 1,032,310 1,176,725 Deferred Debits Unamortized Bond Issuance Costs Unamortized Bond Discotmt Deferral of Loss on Reftmding Total Deferred Debits Total Assets and Other Debits 394,882 377,967 327,615 16,819 17,427 21,884 380,532 394,287 495,151 792,233 789,681 844,650 $ 35,156,157 $ 34,598,501 $ 41,286,272 -2- JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville. Indiana Balance Sheets as of March 31. 2004 December 31 2003, and 2002 EXHIBIT A Continued LIABILITIES AND OTHER CREDITS Equity Capital Unappropriated Retained Earnings Current Year Earnings Total Equity Capital Long Term Debt Reftmding Revenue Bonds of 1995 Revenue Bonds of 1998 Revenue Bonds of 1999 Revenue Bonds of 2003 - Drainage Leases Payable Total Long Term Debt Current and Accrued Liabilities Accounts Payable Construction Contracts Payable Accrtted Interest Total Current and Accrued Liabilities Contributions in Aid of Construction Total Liabilities and Other Credits March 31, December 31. December 31 2004 2003 2002 $ 2,051,403 $ 1,138,376 $ 10,044,131 557,657 913,028 1,078,215 2,609,060 2,051,404 11.122.346 4,500,000 4,50C.000 5,020,000 5,350,000 5,350,000 5,463,274 2,982,385 2,982,385 Z663,739 3,200,000 3,200,000 181,146 181.,146 265,949 16,213,531 16,213,531 13,412,962 52,592 52,592 200.082 122,436 147.472 52,592 52,592 469.990 16,280,974 16,280,974 16,280,974 $ 35,156,157 $ 34,598,501 $ 41,286,272 -3- _Date. 1 105 7, 1/05 1/1/06 7/1/06 1 1,07 7/1/07 1/1/08 7/1/08 1/1/09 7/1/09 1/1/10 7/1/10 1/1/11 7/1/11 1/1/12 7/1/12 1/1/13 7/1/13 1/1/14 7/1/14 1Z1/15 7/1/15 1/1/16 7/1/16 1/1/17 7/1/17 1/1/18 7/1/18 1/1/19 Totals jEFFERSON¥ILLE MUNICIPAL SEWAGE woRKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1998 Amortization Schedule Prtncipaj CoupoA I_nteres! 250,000 4.4 % S 119,193 S 113,693 265.000 4.4 113.693 107,863 275.000 4.4 107,863 285,000 4.4 101,813 95,543 30G 000 4.4 95,543 88,943 315,000 4.4 88,943 82,013 330,000 4.4 82,013 74,753 345,000 4.4 74,753 67,163 365,000 4.5 67,163 58,950 385,000 4.5 58,950 50,288 400,000 4.5 50,288 41,288 425,000 4.5 41,288 31,725 445,000 4.5 31,725 21,713 470,000 4.5 21,713 11,138 495,000 4.5 11,138 $ 2,012,965. $ 5,350,000 __ SCHEDULE A-1 Period Fiscal Total T__ota~ 369,193 S 369,193 113 693 378,693 492 386 107,863 382,863 490.726 101.813 386,813 488,626 95,543 395,543 491,086 88,943 402,943 492.886 82,013 412,013 494,026 74,753 419.753 494,506 67,163 432,163 49S326 58,950 443.950 502.900 50,288 450.288 500 576 41,288 466,288 507,576 31,725 476,725 508,450 21,713 491,713 513,426 11,138 506,138 517,276 $ 7,362,965 -4- Da~ 1/1/o5 7/1/o5 1/1/o6 7/1/06 1/1/07 7/1/07 1/1/08 7/1/08 1/1/09 7/1/09 1/1/10 7/1/10 1/1/11 7/1/11 1/1/12 7/1/12 1/1/13 7/1/13 1/1/14 7/1/14 1/1/15 7/1/15 1/1/16 7/1/16 1/1/17 7/1/17 1/1/18 7/1/i8 i/i/J9 7/1/19 1/1/2o Totals JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1999 State Revolving Ftmd (SRF) Loan Estimated Amortization Schedule Principal Coupon Interest SCHEDULE A-2 135,185 2.9 % $ 43,692 41,732 135,105 2.9 41,732 39,773 140,683 2.9 39,773 37,733 146,863 2.9 37,733 35,603 148,662 2.9 35,603 33,448 151,173 2.9 33,448 31,256 154,417 2.9 31,256 29,017 158,415 2.9 29,017 26,720 158,189 2.9 26,720 24,426 159,202 2.9 24,426 22,118 166,t43 2.9 22,118 19,708 163,962 2.9 19,708 17,331 167,842 2.9 17,331 14,897 167,734 2.9 14,897 12,465 168,748 2.9 12,465 10,018 690,917 2.9 !0,018 $ 3,013,240. Period Fiscal Total Total $ 178,877 $ 178~877 41,732 176,837 218,569 39,773 180,456 220,229 37,733 184,596 222,329 35,603 184,265 219,868 33,448 184,621 218,069 31,256 185,673 216,929 29,017 187,432 216;449 26,720 184,909 211,629 24,426 183,628 208,054 22,118 188,261 210,379 19,708 183,670 203,378 17,331 185,173 202,504 14,897 182,631 197,528 12,465 181,213 193,678 10,018 700,935 710,953 $ 836,182 $ 3,849,422 -5- I1 ! ! ! Ii id Da te 1/01/05 7/01/05 1/01/06 7/01/06 1/01/07 7/01/07 1/01/08 7/01/08 1/01/09 7/Ol/O9 1/01/10 7/01/10 1/01/11 7/01/11 1/01/12 7/01/12 1/01/13 7/01/13 1/01/14 7/01/14 1/01/15 7/01/15 1/01/16 7/01/16 1/01/17 7/01/17 1/01/18 7/01/18 1/Ol/19 7/01/19 1/Ol/2O 7/01/20 1/01/21' 7/01/21 1/01/22 7/01/22 1/01/23 7/01/23 1/01/24 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS effersonville, indiana Sewage Works Revmme Bonds, Series 2003 Amortization Schedule To Be Paid with Drah~age Revenues Principal Coupon Jnterest PeriOd Total 90,000 115,000 120~00 120~00 125,000 130,000 135,000 140,000 145,000 150,000 155,000 165,000 170,000 180,000 185,000 195,000 205,000 215,000 225,000 235,000 2.75 % $ 68,024 $ 158,024 66,786 66,786 3.00 66,786 181,786 65,061 65,061 3.25 65,061 185,061 63,111 63,111 3.50 63,111 183,111 61,011 6t,011 3.60 61,011 186,011 58,761 58,761 4.00 58,761 188,761 56,161 56,161 4.10 56,161 191,161 53,394 53,394 4.15 53,394 193,394 50,489 50,489 4.20 50A89 195,489 47,444 47,444 4.25 47,444 197,444 44,9.256 44,256 4.30 44,256 199,256 40,924 40,924 4.35 40,924 205,924 37,335 37,335 4.40 37,335 207,335 33,595 33,595 4.50 33,595 213,595 29,545 29,545 4.55 29,545 2i4,545 25,336 25,336 4.60 25,336 220,336 20,851 20,851 4.70 20,851 225,851 16,034 16,034 4.75 16,034 231,034 10,928 10,928 4.70 10,928 . 235,928 5,640 5,640 4.80 5,640 240,640 SCHEDULE A-3 Fiscal Total 158,024 248,572 250,122 246,222 247,022 247,522 247,322 246,788 245,978 244,888 243,512 246,848 244,670 247,190 244,O90 245,672 246,702 247,068 246,856 246,280 Totals $ 3,200,000 $1,641,348 $ 4,841,348 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Refmnding Bonds, Series 2004 (1) Amortization Schedule SCHEDULE A-4 Period Fiscal Date Principa! Coupon Interest Total Total 1/1/05 $ 360,000 2.00 % $ 70,941 $ 430,941 S 430,941 7/1/05 61,550 61,550 1 / 1 ~ 06 610.000 2.50 61,550 671,550 733.100 7/1 06 53,925 53,925 1/1 07 620,000 2.75 53,925 673~925 727,850 7/1/07 45,400 45,400 t/1/08 65C .000 3.00 45,400 695.400 740.800 7/1/08 35,650 35,650 1/1/09 670,000 3.25 35,650 705,650 741,300 7 / 1 / 09 24,763 24,763 1/1/10 695,000 3.50 24,763 719,763 744,526 12,600 12,600 7/1/10 1 / 1 / 11 720,000 3.50 12,600 732,600 745,200 Totals $4,325,000 $ 538,717 $ 4,863,717 (1) The Series 2004 Bonds was issued in June of 2004 and reftmded the Sewage Works Refunding Revenue Bonds of 1995. EXHIBIT B JEFFERSONVILLE MUNICIPAL SEWAGE WORKS leffersonville. Indiana Statements of Income for the Twelve Months Ended "1 March 31. 2004. December o · 2003 and 2002 Operating Revenues Sewer Customer Sales Drainage Customer Sales Sewer Forfeited Discotmts Drainage Forfeited Discotmts Miscellaneous Revenues Total Operating Revenues March 31, December 31, December 31, 2004 2003 2002 4.162,028 $ 4,094,239 $ 4,399,174 872,127 876,066 910,151 72,276 74,153 62,455 12,468 12,861 4,005 25 5,118,899 5,057,319 5,375,810 Operating Expenses Operation and Maintenance Expenses Sewer Maintenance Labor Materials and Supplies Purchased Power Repairs Other Expenses Plant Management Contract with EMC Purchased Power Materials and Supplies Other Expenses Drainage Salaries and Wages Employee Benefits Contractual Services Materials and Supplies Office Supplies Other Expenses Customer Accounts Contractual Services Materials and Supplies Postage Other Expenses Administrative and General Salaries and Wages Contract-ual Services Materials and Supplies Other Expenses Undistributed Employee Benefits Total Operation and Maintenance Expenses 208,679 250,677 466,536 42,397 50,829 79,442 37,358 40,795 41,818 8,401 7,597 81,219 85,473 44,382 1,260,940 1,368,227 1,350,974 217,377 215,889 225,497 16.012 15,621 28,761 119,160 137,765 160,595 99,710 94,894 11.602 7,693 316,049 273,440 65,641 211,877 234,682 78,483 5,672 12.513 14,837 19,741 7,408 20.809 46,826 14,034 3,103 17,669 37,202 11,013 276,289 288,094 271,131 186,453 55,139 6,047 5,505 5,963 82;012 105,339 674,128 306,777 3,589,949 314,479 233,311 3,641,634 3,746,403 -8- i i l ! i il JEFFERSONVILLE MUNICIPAL SEWAGE WORKS leffersonville Indiana Statements of Income for the TwelYe Months Ended March 31, 2004, December 31 2003 and 2002 Depreciation Expense Total Operating Expenses Net Operating Income Other Income Interest Income Cormection Fees Tap Fees Inspection Fees Miscellaneous Other Income Total Other Income " "1 March 31, December ol, December o , 2004 2003 2002 $ 694,326 $ 702,629 $ 799,71~ 4.284.275 4,344,263 4,546,119 834.624 713,056 829,691 31,220 28,445 129,884 64,997 73,517 28,373 645.372 577,167 595,360 20,100 18,975 11,250 161,534 168,521 138,275 923,223 866,625 903,142 EXHI13IT 13 (Continued) Other Expenses Amortization of Bond Issuance Costs Interest on Long Term Debt Total Other Expenses Net Income 29,649 29,649 32,340 651,366 637,004 622,278 681,015' 666,653 654,618 $ 1,076,832 $ 913,028 $ 1,078,215. -9- EXHIBIT JEFFERSONVILLE MUNICIPAL SEWAGE WORKS e ffersonville, Indiana Adjusted Statement of Income Operatin¢ Revenues Sewer Customer Sales Drainage Customer Sales Sewer Forfeited Discotmts Drainage Forfeited Discotmts Total Operating Revenues March 31, Adiustments 2004 Amotmt Ref.. $ 4,162,028 872,127 $ (872,127) (1) 72,276 12,468 .... (12,468) (2) 5,118,899 (884,595) Operatin~ Expenses Operation and Maintenance Expenses 3,589,949 (651,751) (3) (42,513) (4) Adjusted $ 4;162,028 72,276 4,234,304 2,895,685 Depreciation Expense Total Operating Expenses Net Operating Income ~ 694,326 694,326 4,284,275 (694,264) 3,590,011 $ 834,624 $ (190,331). $ 644,_9o -10- SCHEDULE C-1 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS effersonville, indiana Detail of Adjustments (1) To remove "Drainage Customer Sales." Adjustment - Decrease $(872,127) $ (12,468) $(651,751) (2) To remove "Drainage Forfeited Discotmts.' Adjustment - Decrease (3) To remove expenses related to Drainage. Adjustment - Decrease (4) To adjust "Operation and Maintenance Expenses" for capital and nonrecurring cl~arges. Vendor Dan Cristianai Excav. Co. Inc Indiana Department of Transportation Fifth Third Bank Description Tenth Street Interceptor Sewer Court Avenue from I65 to US31 Bank Fees Amourtt $ 10,228 29,O57 3,228 $ (42,513) Adjustment - Decrease -11 - II Ii ii Il ii II il d d d d d i il d i II II ! JEFFERSONVILLE MUNICIPAL SEWAGE WORKS JefferSonville, Indiana Statement of Revenue Requirements EXHIBIT D Description Operation and Maintenance Expenses Estimated Combined Maximum Armual Debt Service Schedule D-3'~ Ammal Lease Pawnent Extensions and Replacements - Revenue Ftmded (Schedule D-1~ Total Revenue Requirements Less: Total Operating Revenues (Exhibit C Tap In Fees Exhibit B, Required Increase h~ Operating Revenues Divide by: Adjustable Operating Revenues ~ Exhibit C) Percent Rate Increase Required $ 2,895,685 2,668,439 (1) 3%760 700.000 6,303,884 (6d5,372) -'~ 1,424,208 4,162,028 35% (1) Excludes Debt Service on 2003 Bonds since the 2003 Bonds will be paid from Drainage Revenues. -12- i I I I I I I I Ii II II II tl 0 13- SCHEDULE D-1 i I I I I I I ! ! ! II ii 0 CD CZ) -14- SCHEDULE D-1 Continued i I II lB ! II II Ii !i il d ii il d d ii II ti ! 0 0 ,-a ,-a -15- SCHEDULE D-1 (Contirmed) JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Estimated Sources and Uses of Ftmds SCHEDULE D-2 Sources of Ftmds Bond Proceeds Total Sources of Ftmds $21.340.000 $21,340,000 $20,702.000 638,000 $21,340,000 Uses of Ftmds Construction Proceeds Costs of Issuance Total Uses of Ftmds - 16- SCHEDULE D-3 -17- JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Proposed Sewage Works Revenue Bonds of 2005 Estimated Amortization Schedule Date Principal Coupon Interest 7/01/05 1/01/06 7/01/06 1/01/07 7/01/07 1/01/08 7/01/08 1/01/09 7/01/09 1/01/10 7/01/10 1/01/11 7/01/11 1/01/12 7/01/12 1/01/13 7/01/13 1/01/14 7/01/14 1/01/15 7/01/15 1/01/16 7/01/16 1/01/17 7/01/17 1/01/18 7/01/18 1/01/19 7/01/19 1/01/20 7/01/20 1/01/21 7/01/21 1/01/22 7/01/22 1/01/23 7/01/23 1/01/24 7/01/24 1/01/25 Totals Period Total $ 560,603 100,000 2.25 % 560,603 559,478 110,000 2.80 559,478 557,938 100,000 3.30 557,938 556,288 100,000 3.70 556,288 554,438 100,000 4.00 554,438 552,438 105,000 4.30 552,438 550,180 855,000 4.50 550,180 530,943 895,000 4.65 530,943 510,134 935,000 4.80 510,134 487,694 980,000 4.95 487,694 463,439 1,030,000 5.05 463,439 437,431 1,080,000 5.15 437,431 409,621 1,135,000 5.20 409,621 380,111 1,195,000 5.25 380,111 348,743 1,260,000 5.35 348,743 315,038 2,035,000 5.40 315,038 260,093 2,145,000 5.50 260,093 201,105 2,265,000 5.55 201,105 138,251 2,390,000 5.60 138,251 71,331 2,525,000 5.65 71,331 $ 560 603 660 603 559 478 669 478 557 938 657 938 556 288 656 288 554 438 654 438 552,438 657,438 550,180 1,405,180 530,943 1,425,943 510,134 1,445,134 487,694 1,467,694 463,439 1,493,439 437,431 1,517,431 409,621 1,544,621 380,111 1,575,111 348,743 1,608,743 315,038 2,350,038 260,093 2,405,093 201,105 2,466,105 138,251 2,528,251 71,331 2,596,331 $21,340,000 $ 16,890,594 $ 38,230,594 SCHEDULE D-4 Fiscal Total $1,221,206 1,228,956 1,215,876 1,212,576 1,208,876 1,209,876 1,955,360 1,956,886 1,955,268 1,955,388 1,956,878 1,954,862 1,954,242 1,955,222 1,957,486 2,665,076 2,665,186 2,667,210 2,666,502 2,667,662 -18- I JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Schedule of Present and Proposed Rates and Charges SEWER UTILITY RATES AND CHARGES INSIDE CITY LIMITS Present Consumption Per Month - Rate Per 100 Cubic Feet Charge First 1,000 Cubic Feet $ 2.49 Next 10,000 Cubic Feet 2.32 Over 11,000 Cubic Feet 2.14 Minimum Monthly Char.~e Unmetered Users, Rate Per Month $ 8.64 $ 18.04 OUTSIDE CITY LIMITS Consumption Per Month - Rate Per 100 Cubic Feet First 1,000 Cubic Feet Next 10,000 Cubic Feet Over 11,000 Cubic Feet Minimum Monthly Charge Unmetered Users, Rate Per Month $ 3.73 3.49 3.39 $ 12.95 $ 27.02 EXTRA STRENGTH SURCHARGE Proposed Charge $ 3.36 3.13 2.89 $ 11.66 $ 24.35 EXHIBIT E $ 5.04 4.71 4.58 $ 17.48 $ 36.48 Rate per pound in excess of limits BOD $ 0.22 $ 0.30 Suspended Solids 0.22 0.30 Ammonia 0.75 1.01 Sewer Utility Rates and Charges were effective April 20, 1998. -19- I I I ! I I I I ! JEFFERSON¥ILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewer Utility Typical Monthly Bill Analysis 5/8" Meter Customer Cubic Present Proposed Feet Charge Charge Difference 100 $ 8.64 $ 11.66 $ 3.02 200 8.64 11.66 3.02 300 8.64 11.66 3.02 400 9.96 13.44 3.48 500 12.45 16.80 4.35 600 14.94 20.16 5.22 700 17.43 23.52 6.09 800 19.92 26.88 6.96 900 22.41 30.24 7.83 1,000 24.90 33.60 8.70 1,100 27.22 36.73 9.51 1,200 29.54 39.86 10.32 1,300 31.86 42.99 11.13 1,400 34.18 46.12 11.94 1,500 36.50 49.25 12.75 1,600 38.82 52.38 13.56 1,700 41.14 55.51 14.37 1,800 43.46 58.64 15.18 1,900 45.78 61:77 15.99 2,000 48.10 64.90 16.80 EXHIBIT F ! ! ! 1 - 21 - JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Survey of Sewer Rates Selected Cities and Towns in Indiana Municipal City/Town Population County Ownership Georgetown 2,227 Floyd Municipal Hanover 2,834 Jefferson Municipal New Albany 37,603 Floyd Municipal Austin 4,310 Scott Municipal Scottsburg 6,040 Scott Municipal Anderson 59,734 Madison Municipal Salem 5,619 Washington Municipal Sellersburg 6,071 Clark Municipal Fishers 37,835 Hamilton Municipal Charlestown 10,488 Clark Municipal Jeffersonville - Proposed 27,362 Clark Municipal New Pekin 1,334 Washington Municipal Bloomington 69,291 Monroe Municipal Lawrence 38,915 Marion Municipal Elkhart 51,874 Elkhart Municipal Kokomo 46,113 Howard Municipal Michigan City 32,900 LaPorte Municipal Evansville 121,582 Vanderburgh Municipal Gary 102,746 Lake Municipal Clarksville 21,400 Clark Municipal Jeffersonville - Present 27,362 Clark Municipal Lafayette 56,397 Tippecanoe Municipal South Bend 107,789 St. Joseph Municipal Greenwood 36,037 Johnson Municipal Fort Wayne 205,727 Allen Municipal Mishawaka 46,557 St. Joseph Municipal Columbus 39,059 Bartholomew Municipal Richmond 39,124 Wayne Municipal Carmel 37,733 Hamilton Municipal Muncie 67,430 Delaware Municipal Hammond 83,048 Lake Municipal Marion 31,320 Grant Municipal Indianapolis 782,414 Marion Municipal Terre Haute 59,614 Vigo Municipal (1) Subsidized by property tax Re~dential 5/8" Meter Monthly Sewer Effective Date Billing for 6.68 CCF of Sewer Rate or 5,000 Gallons 1998 $ 49.85 2003 37.03 2002 31.20 2001 29.75 2003 29.05 2002 28.78 2004 28.59 2001 27.85 1998 26.00 1995 23.25 2O04 22.44 2001 22.35 2003 22.17 2002 21.39 2003 21.16 2003 20.80 1994 19.22 2004 19.03 2000 17.50 2004 17.37 1998 16.63 2002 16.35 2003 15.95 1998 15.55 2001 15~19 2002 14.76 1992 13.59 1998 12.81 1999 12.73 2002 12.16 1995 11.84 1992 10.51 2001 9.07 (1) 1991 8.02 Prepared by Crowe Chizek and Company LLC Current as of July 2004 JEFFERSONVILLE 20-YEAR SEWER MASTER PLAN EXPAND DOWNTOWN WWTP ALTERNATIVE NO. 1 JULY 26, 2004 TIME ITEM ESTIMATED COST · ADD ANOXIC ZONES TO DOWNTOWN WWTP, MISCELLANEOUS $ 2,313,000 UPGRADES, UV DISINFECT[ON (DWF CAP. FROM 5.2 TO 6.0 MGD). · REHASIEXPAND RIVERPORT 1 PUMP STATION FROM 550 GPM $ 300,000 NOW TO 950 GPM, REHAB/F~XPAND MILLCREEK PUMP STATION TO FROM 2,100 GPM TO $ 1,800,000 BY CREEK PUMP STATION. SUBTOTAL $ 5,250,250 YEAR · EXPAND MILLCREEK PUMP STATION FROM 7,500 GPM $ 1,465,000 TO 10,600 GPM. INSTALL 7800' OF PARALLEL 24" FORCE MAIN. · EXPAND LENTZlER CREEK PUMP STATION FROM 1,250 TO 2,4-00 GPM. $ 300,000 YEAR · F-.XPAND TENTH STREET NORTH PUMP STATION TO FROM 700 TO1,500 GP $ 100,000 · EXPAND DOWNTOWN WWTP TO 12.0 MGB ( 100% EXPANSION) $ 8,500,000 TOTAL ESTIMATES COST OF THIS ALTERNATIVE $ 39,585,500 Estimated cost includes 35% for contingencies and professional services, in 2003 do[Zars. sewer.aM .xls JEFFERSONVILLE 20-YEAR SEWER MASTER PLAN CONSTRUCT NEW NORTH WWTP ALTERNATIVE NO. 2 ~Hi v~ 2004 TIME ITEM ESTIMATED COST ADD ANOXIC ZONES TO DOWNTOWN WWTP, MISCELLANEOUS ; $ 2,313,000 UPGRADES, UV DISINFECTION ( DWF CAP. FROM 5.2 TO 6.0 MGD). · REHABIEXPAND RIVERPORT 1 PUMP STATION FROM 550 GPM $ 300,000 TO 950 GPM. NOW .... OF BY Estimated cost includes 35% for contingencies and professional services, in 2003 doliars. sewer,alt1 .xis/SE%NER.ALT2 -phased 0 o oO o ~ o Or_ 0 ~ 0 Z LI.I LI.I 7 0 m City of Jeffersonville Master Plan Decision Factors for Evaluating Alternatives Decision factor Alternative I - Alternative 2 - Expand Downtown WWTP Build North WWTP Monetary Factors Total Capital Cost Higher Lower initial Capital Cost Lower Higher Total Present Worth Costs Equal Equal Non-Monetary Factors Disruption to Citizens Major construction along 10th Less construction in urbanized Street, Middle Road and areas railroad Environmental Justice Less favorable More favorable Odors More likely an issue due to Less likely to be an issue, long FMs and more population rural setting and shorter forcemains Reliability of treatment More reliable since only one Less reliable since two WWTP to keep running WWTPs to keep running Reliability of pumping Less reliable since double and More reliable since less triple pumpingrequired double and triple pumping required Expandabiiity of WWTP Will build out the existing site Room remains at existing and p'ossible new North site Impact on CSO Less favorable since existing More faVOrable since existing treatment/LTCP land at WWTP would not be land at VV~NTP would be available for CSO available for CSO treatment/storage treatment/storage Effluent Limits More stringent due to Anti- Less stringent due to new degradation and discharge to discharge to Ohio River Falls of Ohio Obtain site for WWTP Easier since W~NTP site is Harder since new site must be facility owned purchased Constructability Harder since existing WWTP Easier since new site and site and developed urban generally rural lands roads S:\@ PEH\901-950\944\015\Wrd~Master Plan Decsison Factors.doc\071204