Loading...
05-E Campbell Soup Contract DRAFT F:\Attorney\ALICE\RESWORK\CURRENT\Campbell Soup Contract - Draft 1.wpd April 8, 2004 RESOLUTION NO. _______________ A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PARIS, PARIS, TEXAS, APPROVING AND AUTHORIZING THE MAYOR TO EXECUTE AND THE CITY CLERK TO ATTEST TO A WATER PURCHASE CONTRACT WITH CAMPBELL SOUP COMPANY; MAKING OTHER FINDINGS AND PROVISIONS RELATED TO THE SUBJECT; AND DECLARING AN EFFECTIVE DATE. WHEREAS, Section 34-22(a) of Chapter 34 of the Code of Ordinances of the City of Paris, Texas, specifies that charges for water furnished by the City to certain high volume water users pursuant to a written contract shall be as established in said contract rather than as established in the City’s Code of Ordinances; and, WHEREAS, Campbell Soup Company has, for an extensive number of years, purchased the high volumes of water necessary to run its processes by and through a written water contract with the City of Paris; and, WHEREAS, the City and Campbell Soup Company have completed negotiation of a new water contract to establish the rates, terms, and conditions for the future sale of water to Campbell Soup Company; and, WHEREAS, the proposed new water purchase contract allows Campbell Soup Company to establish its anticipated maximum daily demand for water use, thereby affording the company the opportunity to establish its water demands in a manner best suiting the operations of its facility in Paris, Texas; and, WHEREAS, the City Council of the City of Paris and Campbell Soup Company desire to establish methodology in the new water purchase contract that would allow the company to maximize the efficient use of water relative to the rate charged for such water; and WHEREAS, the City Council finds and determines that the proposed new water purchase NOW, THEREFORE, contract is in the best interest of the City of Paris; BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PARIS, PARIS, TEXAS: Section 1. That the findings set out in the preamble to this resolution are hereby in all things approved. Section 2. That the Mayor shall be and is hereby authorized to execute and the City Clerk to attest to a new water purchase contract by and between the City of Paris and Campbell Soup Company, a copy of which is attached hereto and for all purposes incorporated herein as Exhibit A. Section 3. That this resolution shall be effective from and after its date of passage. PASSED AND APPROVED this 12th day of April, 2004. ____________________________________ Curtis Fendley, Mayor ATTEST: ____________________________________ Mattie Cunningham, City Clerk APPROVED AS TO FORM: ____________________________________ Larry W. Schenk, City Attorney WATER PURCHASE CONTRACT STATE OF TEXAS § KNOW ALL MEN BY THESE PRESENTS: COUNTY OF LAMAR § This Agreement, made and entered into this - day of , 2004, and executed in quintuple originals, each executed copy constituting an original, by and between the City of Paris, a municipal corporation of Lamar County, Texas, hereinafter referred to as CITY, and Campbell Soup Company, a New Jersey corporation, with a plant located in Paris, Lamar County, Texas, hereinafter called CAMPBELL. WITNESSETH: I. Service To Be Furnished 1.1 The CITY agrees to furnish and CAMPBELL agrees to purchase and take a supply of water in accordance with the terms and conditions hereof. Said supply of water shall be taken through the existing service by means of an 18 inch Foxboro magnetic flow tube 8300 Series, Model No. 8318-SEBA-ASJ- GCGZ, Reference No. 94281312 (or such other similar metering device as shall be appropriate for accurate measurement of the flow), and an 18 inch Foxboro magnetic flow tube M/2800 Series, Model No. 2818 SEA- TSA-G STB, Reference No. 5498649 CS-2/FN-F (or such other similar metering device as shall be appropriate for accurate measurement of the flow), connected to the CITY's 30 inch potable water transmission line approximately I mile North of CITY's Ground Storage and Booster pumping facility. Should the need arise to replace either meter herein described, it is agreed that such may be so replaced without amendment to this Agreement by giving notice of the name and number ofthe new meter as herein provided. Water Purchase Contract - Page I 1.2 The potable water furnished shall be used exclusively for the operation of CAMPBELL's manufacturing plant on the North side of Loop 286 N.W. within the corporate limits of the City of Paris. II. Quantities To Be Furnished 2.1 The average daily supply of water furnished shall meet all reasonable requirements of CAMPBELL, subject to such limitations and rates as are stated herein. The average monthly consumption, at this time, is in excess of eleven (II) million cubic feet. The water delivered to CAMPBELL shall be at a minimum pressure of seventy-five (75) pounds per square inch; the cost of delivering such pressure is included in the rate established in Article VII. In no instance shall CAMPBELL require delivery of water under this Agreement in an amount exceeding 8 million gallons per day, or at a rate exceeding 6000 gallons per minute. 2.2 CAMPBELL will advise the CITY in advance in writing a minimum of sixty (60) days prior to the implementation of any planned changes that would significantly affect the amount of water used by CAMPBELL for any extended period of time. For the purpose ofthis Agreement, a significant effect would be a change that would cause or contribute to Campbell's water consumption varying by 10% or more on an average daily basis. For any changes such as these, the CITY will maintain the right to limit any increase in water sold to CAMPBELL if it would adversely impact the integrity of the CITY's water system. The CITY would then work with CAMPBELL, in good faith, to meet CAMPBELL's water needs. III. Rel!ulations 3.1 CAMPBELL may not permit any water furnished hereunder to be used to supply any other party without specific written approval of the City Council of the CITY. This shall not apply to emergency service provided to other CITY water users. IV. Ril!hts 4.1 The CITY reserves the right to inspect, test, repair and replace the water meter( s) used to measure Water Purchase Contract - Page 2 CAMPBELL's water consumption as required. Such replacement, calibration or repair shall be paid one half by CITY and one half by CAMPBELL. 4.2 The CITY and CAMPBELL each reserve the right, either in law or in equity, by suits, mandamus or other proceeding, to enforce or eompel performance of any or aH covenants herein contained. V. Water aualitv 5.1 The CITY shaH supply CAMPBELL with water of quality equal to or exceeding the State of Texas drinking water quality requirements for drinking water supplied for pu(blic areas. 5.2 The CITY shaH supply monthly, if requested by CAMPBELL, a wat+r quality analysis report of the water supplied to CAMPBELL. CAMPBELL may request the report moreiJTequently, but will pay the cost of analysis for any additional reports generated in excess of one per motith. 5.3 The CITY bears no degree of responsibility for the water quality at anr point beyond the meter( s) used to register CAMPBELL's water consumption. CAMPBELL bears the re ponsibility for maintaining the water quality at any point beyond the meter( s) vault and within CAMPB LL's distribution system. 5.4 CAMPBELL shaH notify and keep the CITY informed of persons r sponsible for the integrity of CAMPBELL's distribution system. 5.5 Each ofthe parties shall immediately notify the other party's CityM ager or Plant Manager, or such manager's designee, as the case may be, of any emergency or condition vvjhich may affeet the quality or quantity of water in either party's system. 5.6 The CITY reserves the right to make inspections ofthose facilities îhiCh may affect the quality of the water supplied to CAMPBELL and perform required tests. VI. Equipment and Operation , 6.1 CAMPBELL shaH provide and maintain aHlines and valves on C~PBELL's side ofthe water meter(s) used to register CAMPBELL's water consumption, which meter(s) mFks the limit ofthe CITY's Water Purchase Contract - Page 3 responsibility for maintenance. CAMPBELL shall maintain at all times, in working order, a valve immediately upon CAMPBELL's side of the meter(s), which valve can be usfjd for protecting the CITY's system trom contamination in the event of CAMPBELL's system becoming cqntaminated, or in the event the integrity of CAMPBELL's system is violated. CAMPBELL's valve may be used by the CITY to proteet CAMPBELL's system or to facilitate repair of CITY's system. 6.2 The CITY's representative will inspect monthly the meter(s) measuring the supply of water furnished to CAMPBELL, and will report when the same is known or suspected to be registering incorrectly. The meter(s) shall be repaired by a service representative certified to work on the meter(s) being repaired. In the event the meter(s) must be replaced, CITY and CAMPBELL will agree upon a (the) replacement meter(s) and the method ofreplacement. 6.3 The CITY's representative assisted by a service representative certified to work on the meter(s) being repaired, will during each calendar year, and at least quarterly, (with Jarruary, February and March comprising the first quarter, and every three months thereafter comprising a qu¡uter), test the accuracy and performance of each meter and will calibrate the meters measuring CAMPBEtL's consumption, to verify I their accuracy. The trequency oftesting may be reduced by mutual agreeme,* if meter aecuracy appears to be constant. The CITY may, at its discretion, choose to calibrate the m~ter(s) more frequently, if conditions so warrant. The cost ofthe calibration will be distributed in accordtnce with paragraph 4.1. A representative of CAMPBELL will be notified in advance of any testing andlot calibration and shall have the right to witness any such testing. All testing will be performed by a factory representative or mutually agreed upon testing service. 6.4 When it is determined that a water meter has registered incorrectly, am estimate of the amount of water furnished through the faulty meter shall be prepared by CITY's Director IOfFinance for the purpose of billing or crediting CAMPBELL. The estimate shall be based upon the ave~age of correct readings for Water Purchase Contract - Page 4 the same or equivalent months in the preceding three (3) years, or if available and in lieu of said three (3) year average, based on such other method which would more accurately reflect the actual consumption for the period in which the meter failure occurred as mutually agreed upon by the City Manager and Plant Manager of the respective parties. 6.5 For the meter(s) to be determined as "registering incorrectly," the meter(s) must be found to be in error by plus or minus 2.5%, or greater. If the degree of error is plus or minus 2.5%, or greater, then the estimated amount of water furnished to CAMPBELL will be calculated as, stated in the immediately preceding paragraph. VII. Rates 7.1 For purposes of billing under this Agreement, a day shall be that period of time beginning at 12:00 midnight and continuing through II :59 p.m. 7.2 CAMPBELL will be charged a two-part rate based on CAMPBELL's¡treated water consumption and Maximum Day Demand. 7.3 Charges for treated water furnished to CAMPBELL during the Initial Period of this Agreement shall be ftom the date of execution through May 31, 2004 and have been computed as follows: 7.3. I An annual demand charge per million gallons per day (MGD) of Maximum Day Demand of water delivered to CAMPBELL shall be $72,000 per MGD. 7.3.2 The volumetric charge shall be $0.45 per 100 cubic foot of trfated water withdrawn by CAMPBELL ftom the CITY's water utility system. 7.4 For the Initial Period, CAMBELL's Maximum Day Demand shall b~ established at 6.0 MGD. 7.5 Each twelve (12) month period following the Initial Period, beginning June I and ending May 31 of the following year, shall be defined as a "Rate Year." 7.6 For cost of service studies following the Initial Period, and except for data associated with the Water Purchase Contract - Page 5 Maximum Day Demand, historical data accumulated during each twelve-month period ending September 30 of the prior year, hereafter referred to as the "Test Year," shall be used. 7.7 Prior to the end ofthe Initial Period, a detailed Cost of Service Stupy will be perfonned by an independent utility rate consultant chosen by the CITY, such study to be perfortned in accordance with the methodology described in that excerpted portion of the Reed, Stowe & Yank~, LLC study, March, 2003, attached as Exhibit I. The Cost of Service Study shall be developed on an aclual historical cost test year basis (for the Test Year) allowing for reasonable and necessary expenses ofp~oviding such water service and allowing for known and measurable adjustments, including satisfying tire City's obligations under current and future bond covenants. Thereafter, on an annual cycle, a detailed çost of Service Study shall be perfonned by an independent rate consultant chosen by the CITY, again u$ing the same methodology as the excerpted portion of the Study in Exhibit I, unless and until a differe~ methodology is mutually agreed upon in writing by CAMPBELL and the CITY. CAMPBELL shall pay ~e cost of each annual Cost of Service Study, payable within thirty (30) days of CAMPBELL's receipt offnvoice from the CITY. 7.8 During the Initial Period and any given Rate Year, should CAMPB~LL's actual Maximum Day i Demand exceed the Maximum Day Demand used in the most recent Cost oflservice Study, Campbell's will be assessed an excess demand charge ofl.5 times the Annual Demand C~arge (per MGD) times the Excess Demand. Payment of the Excess Demand Charge shall be due thirty PO) days within receipt of I invoice from the CITY. Beginning the month after this event, this event Wil~ also immediately change CAMPBELL's current Maximum Day Demand and Monthly Demand Charg9 for this Agreement to the new actual Maximum Day Demand and adjusted Monthly Demand Cha~e. AS AN EXAMPLE, ADJUSTMENTS FOR AN INCREASE FROM A MAXIMUM DAY DEM ND OF 6.0 MGD TO A MAXIMUM DA YDEMAND OF 6.5 MGD ARE CALCULATED IN THE EX PLE GIVEN BELOW. Example: Water Purchase Contract - Page 6 Maximum Day Demand Annual Demand Charge (per MGD) Total Initial Annual Demand Charge ($72,000 x 6 MGD) Monthly Demand Charge ($432,000/12 months) 6MGD $ 72,000 $432,000 $ 36,000 Actual demand recorded Excess Demand (6.5 MGD - 6 MGD) 6.S MGD MGD Excess Demand Charge ($72,000 x 1.5 x 0.5 MGD Excess Demand) Additional amount due CITY in thirty (30) days $ 54.000 $ 54,000 Annual Demand Charge (Per MGD) Adjusted Total Annual Demand Charge ($72,000 x 6.5 MGD) Adjusted Monthly Demand Charge ($468,000/12 months) $ 72,000 $468,000 $ 39,000 Should the new Maximum Day Demand again be exceeded durin a given Rate Year, similar calculations and a designation of a new Maximum Day Demand for the Rat Year shall be made. The highest Maximum Day Demand in a given Rate Year that exceeds he current Maximum Day Demand shall be used as the Maximum Day Demand in the subsequent year's ost of service study, unless a higher Maximum Day Demand is requested by CAMPBELL and accepted y the CITY. Example: Maximum Day Demand (initial estimate) 6. MGD Maximum Day Demand (Actual) 6. MGD Maximum Day Demand for subsequent cost of service study 6.5 MGD If a higher Maximum Day Demand than actually experienced is requ ted by CAMPBELL, and accepted by the CITY, CAMPBELL's Total Annual Demand Charge will be t e Annual Demand Charge (per MGD), calculated using the actual Maximum Day Demand for the subse uent cost of service study, times the requested Maximum Day Demand. 7.9 CAMPBELL's volumetric rate shall be based on CAMPBELL's t eated water consumption during the twelve-month prior Billing Year, adjusted for any known and mea urable changes. Water Purchase Contract - Page 7 7.10 The following example illustrates the calculation of CAMP BEL 's Annual Demand Charge (per MGD) and volumetric rate under this Agreement. Example: CAMPBELL's Extra Capacity costs CAMPBELL's Maximwn Day Demand (MGD) CAMPBELL's Annual Demand Charge (per MGD) $ 432,000 -;- 6.0 $ 72,000 CAMPBELL's Base and Customer costs CAMPBELL's water consumption (CCF) CAMPBELL's volumetric rate (per CCF) $ 540,000 -;-1 00 000 $ 0.45 VIII, Payment of Chan!es 8.1 Rates under Article VII of this Agreement, for CAMPBELL's treate water consumption, shall be billed by the CITY on a monthly basis with such billing being rendered on r about the same day each month. CAMPBELL's monthly payment shall consist ofthe volwnetric charg for actual water taken plus one-twelfth ofthe Annual Demand Charge, plus any additional amount due as alculated under Article VII of this Agreement for an adjustment to the Maximwn Day Demand. In the e ent CAMPBELL sha1l fail to make any payment required by this Agreement within twenty-one (21) day fo1lowing the bi1ling date, the CITY may suspend water service authorized by the Agreement after prov ding CAMPBELL five (5) working days written notice of its intention to suspend service. It is agree that this paragraph sha1l supersede Sections 34-29 and 34-30 ofthe Code of Ordinances of the City of aris, to the extent that they concern water service, as we1l as any other Code of Ordinance provisions wi h which it may conflict. IX. Force Ma'eure and Contract Administrati n 9.1 It is agreed that in the event and to the extent that fire, explosion, ac ident, war, act of God or the public enemy or any natural disaster prevents the performance of either p y hereto, such party shall be relieved of the consequence thereof, and there sha1l be no liability fì r payment on the part of CAMPBELL or for failure to deliver potable water on the part of the CITY, otwithstanding any other Water Purchase Contract - Page 8 provision of the Agreement, so long as and to the extent that perfonnance s prevented by such cause; provided, however, that the parties shaU use aU due diligence in their efforts t resume perfonuance at the earliest practical time. 9.2 This Agreement shan be subject to and in an things governed by icle Y, Chapter 34 of the Code of Ordinances of the City of Paris, dealing with Drought Continge cies, or any other similar provisions as the same shan be adopted by the City dealing with water cons rvation, water curtailment, or drought contingencies. 9.3 This Water Purchase Contract win replace in its entirety the Wate Purchase Contract dated October I, 1993, entered into between the CITY and CAMPBELL, and this greement shan be in force and effect for a period of three (3) years in addition to the Initial Period as def¡ ed in Paragraph 7.3 hereof, ending May 31, 2007. Thereafter such Agreement shall be automaticany rene able for additional one (1) year tenus, unless either party provides written notice to the other party 0 intent to negotiate a new contract, such notice to be given at least ninety (90) days prior to the end da e of the then current tenu. Thereafter, a new service contract will be negotiated, provided this Agreeme t shall remain in full force and effect for a period not to exceed twelve (12) months or until a new contra t is negotiated, whichever event occurs first. If a new contract is not negotiated as provided herein, the te charged for water shall be as established in the CITY's current rate ordinance for non-residential cust mers. 9.4 No officer, official or agent ofthe CITY or CAMPBELL, has the p wer to amend, modify or alter this Agreement or waive any of its conditions or to bind the CITY, or C MPBELL, by making any promise or representation not contained herein. 9.5 This Agreement, except by operation of law, shall not be assigned or ransferred by either party, without the prior written consent of the other party. 9.6 The CITY win not be responsible in damages for any interruption or tailure to supply water and Water Purchase Contract - Page 9 I shall be saved and held hannless from all damage of any kind, nature and destriPtion which may arise as a result of making this Agreement and furnishing water hereunder, except Wh¡' re the CITY has the ability to supply the water and refuses to do so or where the CITY has failed to abi e by any of its obligations under this Agreement. 9.7 Any written notice required or pennitted under the tenus of the A~eement shall be given and be deemed to have been duly served if either (I) delivered in person (including ~eputable overnight courier service), or (2) deposited certified mail, return receipt requested, postage preP1d in the United States mail, addressed to the designated representative of the respective parties which ar designated as follows: Water Purchase Contract - Page 10 CAMPBELL Vice President, Southwest Region Campbell Soup Company P. O. Box 116 Paris, IX 75461-0116 CITY City Manager City of Paris P.O. Box 9037 Paris, IX 75461-9037 With a copy to: Secretary Campbell Soup Company P. O. Box 391 Camden, New Jersey 08101 With a copy to: City Clerk City of Paris P.O. Box 9037 Paris, TX 75461-9037 9.8 If any term or provision ofthis Agreement shall be declared unconsti tional or void by any court of competent jurisdiction, the constitutionality and validity of the remainder f said Agreement shall not be affected hereby, and to this end the terms and provisions of said Agreement re declared to be severable. 9.9 Nothing contained in this Agreement shall be deemed or construed 0 create the relationship of principal and agent, partnership, joint venture, landlord and tenant, or any elationship or association whatsoever between CITY and CAMPBELL, other than as expressly set fort herein. 9.10 This Agreement sets forth the entire understanding between he parties, and any other understandings or agreements shall be cancelled and superseded by this A eement upon the date of execution hereof. None of the terms of this Agreement shall be waived, disc arged, altered or modified in any respect, except by an agreement in writing signed by both parties and s ecifically referring to this Agreement The captions in this Agreement are included for convenience onl and shall not be taken into consideration in any construction or interpretation of this Agreement or an of its provisions. This Agreement shall be governed by, construed and enforced in accordance with th laws of the State of Texas. The provisions of this Agreement shall apply to, bind and inure to the benefit of the CITY and CAMPBELL, and their respective successors, legal representatives and perm'tted assigns, if any. Water Purchase Contract - Page 11 X. Authority to Contract 10.1 The parties recognize and agree that Section 34-2 of the Code of Or inances ofthe City of Paris requires that consumers or purchasers desiring water at minimum delivery pr ssure, particular flow rate, volume in excess of 1.5 million cubic feet per month, or which require constru tion of oversized additions to the CITY's system, be delivered water pursuant to a written contract upon uch terms, conditions and at such rate as may be fixed by the City Council of the City of Paris. This greement is such a written CITY OF PARIS, PA ,2004. contract. EXECUTED by the City of Paris, Texas this - day of Curtis Fendley, Mayor ATTEST: Mattie Cunningham, City Clerk EXECUTED by Campbell Soup Company this ;).S day of /YJ C- f- ,2004. ~ C"".'BELL SOUP C MPANY ~ -i ¡:,. Ì)... - . , Vice Pr sident - Mfg., Paris Operations ATTEST: , Secretary Water Purchase Contract - Page 12 CITY OF PARIS, TEXAS -0 WATER AND W ASTEW A TER COST OF SERVICE AND RATE DESIGN REVISED DRAFT MARCH 2003 EXHIBIT J:. March II, 2003 Mr. Mike Malone City Manager City of Paris 135 First Street, S.E. Paris, Texas 75460 Dear Mr. Malone: The City of Paris ("City") engaged the services of Reed, Sto e & Yanke, LLC to conduct a Cost of Service and Rate Design Study for the water and wastewater operations of the City. The attached revised draft report presents our finding and recommendations from the Cost of Service and Rate Design Study. We appreciate the opportunity to provide our professional serviceJto the City and would like to express our sincere appreciation to you and your staff me bers for supplying the needed infonnation and data to conduct the Cost of Service and ReDesign Study. Should you, your staff, or council members require additional info ation or clarification regarding the Cost of Service and Rate Design Study, please do not hesitate to contact Mr. Jack E. Stowe, Jr. (512) 450-0991 or Mr. Darrell Cline at (214 448-9443. Very truly yours, Reed, Stowe & Yanke, LLC Table of Contents CITY OF PARIS, TEXAS WATER AND WASTEWATER COST OF SERVICE STUDY I . I EXECUTIVE SUMMARy............................................................j........................1 CHOICE OF TEST YEAR AND ALLOCATION METHODOLOGy....J.,......................7 ANALYSIS OF TEST YEAR DATA .............................................j......................l1 CUSTOMER CLASS DISTRIBUTION FACTORS """""""""""""~1......................16 W ATERAND WASTEWATER UTILITY FINANCIAL OPERATIONi"....................l7 WATER UTILITY SYSTEM- FINANCIAL DATA ........................1......................20 REvIEW OF W ASTEWA TER SYSTEM DATA ..............................1......................22 I VIII. DETERMINATION OF TEST YEAR REVENUE REQUIREMENT.....¡......................25 IX. RATE DESIGN.....................................................................""'1......................28 I I I I I APPENDICIES I APPENDIX A OPERATING CHARACTERISTICCS OF UTILI Iy SYSTEM APPENDIX B CONTRACT CUSTOMERS ~ APPENDIXC DETERMINATION OF RETAIL WATERANDtASTEWATER RATES I I. II. III. IV. V. VI. VII. REVISED DRAFT I. EXECUTIVE SUMMARY A. Introduction The City of Paris ("City") authorized Reed, Stowe & Yanke, LLC to perform a water and wastewater cost of service study. This report describes the study performed for the City and makes recommenda~ions with respect to rates to be charged to the City's water and wastewater customers. The report consists of nine sections, including the Exttcutive Summary section. Also attached are three appendices to supplement the findings ofthe report. Following the Executive Summary, Sections II through VI develop the methodology, assumptions and the revenue requirement for the water utility portion of the City's Water and Wastewater Utility. Sections VII and VIII develop the methodology, assumptions and the revenue requirement for the wastewater utility portion of the City1s Water and Wastewater Utility. Finally, Section IX of the report develops the rate schedules; for water and wastewater services provided by the City. The three appendices following the report consist of Appendix A, ope~ating characteristics of the system, Appendix B, contract customers, and Appendix C the determination of the retail water and wastewater rates. B. Findin!!s aeRate Study a. The total revenue requirement for the Water Utility portion of the test year for the retail rate determination is estimated to be $6,451,618. City of Paris. Te,as Water and Wastewater Cas' of Service Study Ma,.h 2003 REVISED DRAFT b. The total revenue requirement for the Wastewater Utility portion of the test year is estimated to be $4,372,792. c. Since the 1999 study, total water consumption has fallen from 546 million cubic feet to 498 million cubic feet in 2001, a 9% decrease. This decline is primarily a result of a reduction in water purchases by Campbell Soup, as well as a decline in wateryurchases by the Residential customer class. d. In 1998, the Residential wastewater winter average was 675 cubic feet. The winter average for 2001 declined to 651 cubic feet, a 4% decrease. e. There appears to be a discrepancy between the City's residential water billings and wastewater billings. The City uses the months of November, January and February to calculate the residential wastewater winter average, which is used as the maximum monthly volume ("cap") that can be billed a customer during the following year. Generally, wastewater billings remain slightly below the winter average during winter and spring months, however, as water consumption increases during the summer and fall months, the wastewater billings approach the winter average cap. The City's wastewater billing infonnation shows that the wastewater billings have stayed well below the winter average (approximately 100 cubic feet on average). In fact, June 2001 had the lowest wastewater billings for FY 2000/2001, even though it was the third highest month in water consumption. f. Contract customers are estimated to produce the following revenues: . Campbell Soup $1,211,691 . Lamar County Water Supply District $668,320 CityolParis. Texas Waltr and Wastewater Cast olSe"ice Study March 2003 2 REVISED DRAFT . Tenaska III $364,286 . Lamar Power $275,791 . Marvin-Jennings Clardy WSC $45,842 g. Under the proposed rate structure, the water monthly base charge for a 5/8" or 3/4" meter residential customer will increase from $5.91 to $7.00, while water rates (or all residential customers in excess of base volumes will increase from $2.15 to $2.45 per hundred cubic feet (CCF). h. Under the proposed rate structure, the wastewater monthly base charge for a 5/8" or 3/4" meter residential customer will increase from $6.31 to $7.50, while wastewater rates for all residential customers in excess of base volumes will increase from $3.10 to $3.25 per CCF. 1. The combined water and wastewater monthly charge for the average residential customer will increase from $36.45 to $40.98. j. The following provides examples of the rate increases on average customer consumption for various meter sizes: RESIDENTIAL Billing Units Water / Current Proposed Percent / Dollar Meter Size Wastewater (CCF) Monthlv Bill Monthlv Bill Increase 5/8" and 3/4" 750/600 $36.45 $40.98 12.4% / $4.53 1" 2,000/1,600 $104.56 $114.00 9.0% / $9.44 I Yz" 2,700/2,000 $132.01 $144.15 9.2%/$12.14 2" 6,500/6,000 $337.71 $367.25 8.7% / $29.54 City of Paris. Teeas Water and Wastewater Cost ofServiceSwdy March 2003 3 REVISED DRAFT COMMERCIAL Billing Units Current Proposed Percent / Dollar Meter Size (CCF) Monthly Bill Monthly Bill Increase 5/8" and 3/4" 1,000 $59.74 $65.80 10.1 % / $6.06 I" 2,800 $148.10 $167.20 12.9% / $19.10 I W' 5,500 $282.29 $313.00 10.9% / $30.71 2" 14,000 $704.74 $772.00 9.5% / $67.26 3" 34,000 $1,735.05 $1,890.00 8.9% / $154.95 k. The unaccounted for treated water loss is approximately 18 percent. This may be due to under-registration by meters and/or losses in the distribution system. C. Recommendations a. It is recommended that the new water and wastewater rates proposed in Section IX of this report be adopted. b. The City should continue its rehabilitation program of the water and wastewater systems in order to reduce lost and unaccounted for water and meet mandatory improvements required by federal and state agencies. c. As recommended in the 1999 Rate Study, we once again recommend that in order to stabilize wastewater revenues, the City should move from billing at a maximum winter average, to a flat winter average. The City is currently experiencing notable revenue fluctuation and underperformance from the maximum winter average method. Moving to a flat winter average will help to CilyofPo,is. T~'as Wot., and Wastewo/" Cost ofSenlice Study Ma"h 2003 4 REVISED DRAFT alleviate revenue fluctuation and improve revenue performance through more reliable projections. A flat winter average is used under the assumption that on average throughout the year, customers will contribute water volumes to the City's wastewater system equivalent to the winter average. From a billing standpoint, the flat winter avera~e means that once a customer's winter average is determined, that customer will be charged that winter average volume every month (revenue stability and predictability). In addition, because of consistent volumes charged each month, it will be easier for City staff to determine and track whether the billing system is accurately capturing and billing the appropriate volumes. d. Due to the declining water volumes purchased by the City's largest customer, Campbell's Soup, as well as declining water volumes purchased by the Residential customer class, we recommend that the City begin reviewing their water and wastewater rates on an annual basis to ensure that the rates are sufficient to meet cost demands. e. In August 1999, Lamar County Water Supply District (LCWSD) purchased 38.7 million gallons of treated water through the City's distribution system. The City's contract with LCWSD states that LCWSD can not purchase more than 1.4 million gallons of water per day through the City's distribution system. The average daily water purchased by LCWSD in August 1999 was 1.25 million gallons. It is highly unlikely that LCWSD was able to maintain a steady rate of 1.25 MGD. We recommend that the City closely monitor LCWSD's distribution City o¡ Paris. Texas Waler and Wastewater Casl o¡Service Swdy March ZO03 5 REVISED DRAFT consumption, in order to ensure compliance with the contract and limit undue demand on the City's water distribution system. City of Paris. Texas Water and Wos/ewaterCos/ of Sendee Study Mareh 1003 6 REVISED DRAFT II. CHOICE OF TEST YEAR AND ALLOCATION METHODOLOGY FOR WATER RATE STUDY A. Test Year Based on the revie)V of the water production and consumption data of the City's water utility system, the twelve-month period of October 2000 through September 2001 was chosen as the "test year" for the water rate study. B. Allocation The purpose of the cost allocation is to express the utility's total cost of service in terms of costs associated with the various components of that service. This approach allows the costs to be recovered from the customers of the system in accordance with their use of the various components. Allocation allows the utility to achieve equity in water and wastewater rates, assuring that the customers pay for service on the basis of their use of the system. Typically, the allocation process is handled in steps - first, allocating costs to the various service functions and then distributing them to customers according to their use of each function. In general, the service costs are associated with supplying both the customer's average and peak rates of use and with customer meter reading, accounting, billing administration and fire service. C. Cost Functionalization. Allocation and Distribution Method The base-extra capacity method of functionalizing, allocating cost to service functions, and distributing costs to customer classes is commonly used in the water utility industry. This Cityol?or;s. Tems Waler and Wastewater Cost olService Study March 2003 7 REVISED DRAFT method recognizes the differences in the cost of providing service due to variations in average rate of use and peak rate of use by a customer class. The method also recognizes the effects of system diversity on costs. Costs are generally divided into three components: (a) base costs, (b) extra capacity costs and (c) customer costs. Base costs are those that tend to vary with the total quantity of water used plus capital costs and operation and maintenance costs needed to provide service to customers, under average load conditions. Extra capacity costs are those costs incurred above the average operating conditions, and are necessary to support peaking conditions. Customer costs are those associated with serving customers regardless of the amount of water used, i.e., meter reading, accounting, billing, etc. The allocation of cost between base and extra capacity components depends upon the design and use of the particular portion of the water system being analyzed. If an asset of the water system is designed to meet only the average demand on the system - a raw water supply reservoir for instance - the capital costs and operation and maintenance costs for that asset are totally allocated to the base component. If the asset is designed to provide additional capacity which is needed to provide peak demand on the system, the capital and operating costs associated with the asset are allocated to base and extra capacity components in the same proportion that the capacity of the asset is used for average and peak use. The appropriate allocation factors between base and extra capacity usually vary from system to system. Therefore, they should be determined from actual operating history or design criteria of the system. The other important consideration for setting equitable rates for utility service is the establishment of customer classes for cost distribution after costs are allocated to service City of Paris. Texas Water and Wastewater Cost of Sendee Study March 2003 8 REVISED DRAFT functions. A customer class should include only those customers who; (a) are in similar location in relation to the utility, (b) use the same or similar facilities of the utility, (c) receive similar service from the utility, and (d) place similar demands of the utility. It is important to note that makeup of the customer class can change depending upon the particular asset that is being allocated. A customer class that is appropriate for allocation of one type of cost, e.g., water treatment costs, max include customers that would not be appropriate to the class when another type of cost of assets is allocated, e.g., treated water distribution costs. The objective of cost allocation and ultimate distribution to customer groups is to avoid cross-subsidization, and it is important with that objective in view, differences in service commitment and service requirement be given full consideration in determining customer classes. D. Determination of Customer Classes The City's water utility serves residential, commercial and industrial customers. Besides these customers, the City has four treated water contract customers, Campbell Soup, Tenaska III, LCWSD, a municipal utility district that retails to its own customers, and Marvin-Jennings Clardy WSC, a water supply corporation that retails to its own customers. In addition, the City has a contract to provide raw water to Lamar Power Partners. Small industrial customers have been grouped with commercial customers to correspond to the City's current rate structure. The following lists the treated water customer classes isolated in the report. a. Residential customers b. Commercial customers (including small industry) c. Campbell Soup d. Tenaska III Cityo/Paris. Texas Water and Wastewater Cost D/Service Study March ZO03 9 REVISED DRAFT e. Lamar County Water Supply District Marvin-Jennings Clardy WSC was not isolated as a customer class for rate determination due to the nature oftheir contract, which determines the rate from a previously agreed upon volumetric rate adjusted annually for inflation. Certain adjustments must be made in the cost of service and rate design study ,to recognize Marvin-Jennings Clardy WSC's contract. The adjustments included, removing Marvin-Jennings Clardy WSC's consumption from the rate calculation and recognizing their estimated revenues from the contract rate charge as a revenue offset in the cost of service determination. Lamar Power Partners was isolated as a customer class, however, its raw water rate was calculated separately and the revenues associated with the raw water purchases were used as an offset to calculate the treated water rates. These adjustments help to prevent an overestimate of consumption and an underestimate of revenues. Cityo/Poris. Tems Water oed Wastewater Cost a/Service SIIIdy Morch 2003 10 REVISED DRAFT 1lI. ANALYSIS OF TEST YEAR DATA A. Water Utility System Data The City maintains daily treated water production data at the treatment plant. The system peak pumpage of treated :vater recorded on July 25, 2001 was 20.428 million gallons with a peak to average day ratio of 1.66 (20.428 MGD/ 12.322 MGD). Table A-I in Appendix A shows the system demand and capacity factors for the test year. B. Allocation Operation and Maintenance Expenses to Functional Cost Components In order to recognize that certain facilities of the City's water utility system are used in common by two, three, four or all five of the customer classes identified in Section II, five customer groups have been formed for system cost allocation purposes. These cost factors have also been separated into three principal components of Base, Extra Capacity, and Customer costs to provide a means of further distributing functionalized costs to the various customer classes on the basis of the respective responsibilities of each group for each particular cost function. Each element of cost is allocated to functional cost components of the system on the basis of the parameter or parameters having the most significant influence on the magnitude of the element of cost. Operation and maintenance expenses are allocated directly to appropriate cost components. Similarly, debt service costs are allocated to the appropriate cost functions. CityolParis, Te,as Water and Wastewater Cost olService Study March 2003 11 REVISED DRAFT c. Distribution of Functionalized Cost Components to Customer Groups This is the final step in determining the revenue requirement of each individual group of customers from the total revenue requirement of the water system as a whole. The functionalized cost factors are determined for each individual customer group on the basis of each group's annual usage characteristics. Due to the point-of-take of water for three of the four contract customers, transmission and distribution costs were isolated. While the water treatment plant is used and useful in providing service to all customers of the City, the same does not hold true for the treated water transmission and distribution system. Campbell Soup and Tenaska III currently receive treated water directly from transmission lines from the treatment plant, not from the City's distribution system. LCWSD receives the bulk of their water purchases through the City's transmission lines. In the absence of detailed distribution system analysis during peak hour flow conditions, the treated water transmission and distribution system has been segregated by inch-feet into three groups - lines less than 8 inches in diameter, lines between 8 inches and 24 inches in diameter, and lines greater than 24 inches in diameter - for cost allocation purposes between the classes of treated water customers. Table A-2 in Appendix A shows the percentages of inch-feet of treated water transmission lines separated into the three pipe size groups. D. Treated Water Loss Allocation No treated water loss has been prorated to water received by Campbell Soup, Tenaska III and LCWSD. Table A-3 in Appendix A shows treated water allocation percentages to City's retail Cif)! of Paris. Texas Woterand Wastewaler Cost of Service Study March 2003 12 REVISED DRAFT customers, Campbell Soup, LCWSD and Tenaska III, including treated water losses allocated to the retail customers of the City. E. Treated Water Use and Capacity ReQuirements of Customer Classes To distribute functionalized system component costs to customer classes - residential class, commercial class, Çampbell Soup, LCWSD and Tenaska III, assumptions had to be made as to peak-day demands of residential and commercial classes of customers. The actual test year average-day demands and peak-day demands were used for Campbell Soup, LCWSD and Tenaska III. Table A-I in Appendix A shows the individual customer classes' average and peak- day demands. Campbell Soup's water purchases from the City has declined over the past two fiscal years (FY 1999/2000 and FY 2000/2001) and is continuing that trend this fiscal year (FY 2001/2002). In order to recognize the decrease in water purchases by Campbell Soup, the latest available water purchases (October 2001 through January 2002) were combined with February 2001 through September 2001 as an estimate for FY 2001/2002 water consumption. It was estimated that Campbell Soup would experience the same peak day volumes as incurred in FY 2000/2001. The table also shows the capacity factors for the classes as well as their relative percentages of base and extra capacity components of the system used and useful in providing service to the five customer classes during the test year. City of Paris. Tems Water and Wa.Slewaler Cast oflk",;ce Study March 2003 13 REVISED DRAFT F. Treated Water System Allocation Distribution Lines Since the entire treated water transmission and distribution system is not allocable to all of the five customer classes, system cost allocation percentages of the distribution system not common to all are determine~ separately. All lines larger than 24 inches in diameter are assumed to be common to all treated water customers. Hydrants Fire protection service is not common to all five customer classes of the City's water system. Therefore, operating and maintenance costs associated with fire service are distributed to the residential and commercial customers of the City on the basis of their meter equivalency demands. Meters Meter costs are distributed on the basis of equivalent 5/8" meters. Table A-4 in Appendix A shows the number of equivalent meters in the City's water system. Costs are distributed on the basis of the number of equivalent meters. Warehouse Warehouse costs are allocated to the customer classes based upon the functionalized component allocation factors as shown on Table A-6 in Appendix A. Hillin!!: and Collectin!!: Other billing and collecting costs are allocated to all five customer classes based upon the number of test year bills sent to each customer class. CllyofPar;., Te<as Water aad Wastewaler Cost of Service Study March 2003 14 REVISED DRAFT Administrative Fees Administrative fees cover the expenses of the general government in connection with administering the Utility Fund. Such costs vary by customer class depending on the demands and requirements placed on the system by each class and are appropriately allocated among classes based upon the relative total revenue requirements of each class. Ciryo/Paris, Te:<as Water and Wastewater Cost a/Service Study March 2003 15 REVISED DRAFT IV. CUSTOMER CLASS DISTRIBUTION FACTORS A. Distribution Factors for Operation and Maintenance Expenses All system operation and maintenance expenses are functionalized and allocated according to the allocation units shgwn in Table A-6 in Appendix A. These functionalized costs should be distributed to the five customer classes based upon the system base, base/max day, except for meters, hydrants, billing/collecting and administrative fees. Operating and maintenance expense for the exceptions are allocated as described in detail in the previous section. Table A-6 in Appendix A gives the cost distribution units for the total test year operation and maintenance expenses ofthe City's water utility system allocable to each of the customer classes. B. Debt Service Cost Distribution All debt service and other capital expenditures should be allocated to the customers on the basis of distribution factors for plant responsibility as well as specific usage of the proceeds of each bond issue. City of Paris. rexas Waler and Wastewat., Cost afService Study March 2003 16 REVISED DRAFT v. WATER AND WASTEWATER UTILITY FINANCIAL OPERATIONS A. Determination of Test Year Revenue ReQuirements To recognize the City's contract customers' contractual terms two test year revenue requirements were developed, on¡:: for the contract customers, and one for the retail customers. Table B-1 in Appendix B shows the revenue requirement, as adjusted, for the test year for the contract customers. Table C-l in Appendix C shows the revenue requirement, as adjusted, for the test year for the retail customers. The revenue requirement for the contract customers was developed on the fiscal year ended September 30, 2001 actual expenses, while the retail customer revenue requirement was based on the City's FY 2001/2002 budget. Adjustments and reclassifications to the revenue requirements are as follows: Raw Water Supply Since the City budgets both raw water supply and water treatment O&M expenses in Water Production, it is necessary to separate raw water supply costs into their own separately-allocable cost section. Production electricity is allocated between supply and treatment based upon the ratio of supply and treatment electricity expense to production electricity expense. Water Distribution and Transmission Water distribution and transmission costs must be reclassified from expense type to cost- causal categories. Personnel, supplies, contractual, building maintenance, equipment maintenance, sundry costs, and equipment capital outlay are classified into the three categories of distribution and transmission (less than 8", 8" to 24", and greater than 24") City of Paris. rems Walerand Was/ewaler Cos/af&rviceSllldy March 2001 17 REVISED DRAFT based upon the test year water system inch-feet percentages calculated on Table A-2 in Appendix A. Hydrants/valves and meters/meter boxes remain separate categories for cost allocation purposes. Debt Service The contracts for Campbell Soup and Tenaska III allow for adjustments in known and measurable c:hanges from the end of the fiscal year to the cost of service determination. Debt Service is based on the projected principal and interest payments for FY 2002/2003 of the City's Current outstanding debt issues. B. Allocation of Revenue Requirements to Water and Wastewater Table B-1 in Appendix B and Table C-l in Appendix C present the allocation of the total utility revenue requirement to water and wastewater for applicable treated water contract customers and retail customers, respectively. Raw water supply, water production, water distribution and transmission, wastewater maintenance, wastewater treatment, and lift stations costs are directly assigned to their respective function. Other operations and maintenance costs are allocated between water and wastewater as follows; 'Varehouse Warehouse costs are allocated 50/50 between water and wastewater under the assumption that it services the water and wastewater system equally. Hillin!! and Collectin!! The billing and collecting function has been allocated 50/50 between water and wastewater under the assumption that it services the water and wastewater system equally. City a/Paris. Tems Water and Wastewater Cost a/Service Study March 1003 18 REVISED DRAFT Administrative Fees Administrative fees are allocated between water and wastewater based upon the ratio of operations and maintenance expenses assigned to each. Debt Service Debt servic~ costs for outstanding debt issues are allocated based upon historical records of assets, capital improvement plans and discussions with City staff. City 01 Paris- rexas Waler and Wastewater Cost olService Study March 1003 19 REVISED DRAFT VI. WATER UTILITY SYSTEM - FINANCIAL DATA A. Functionalization of Revenue Requirement Table C-2 in Appendix C details the functionalization of adjusted expense levels into the various Base-Extra Capacity and Customer Components ofthe System on the basis of factors previously discussed in Section II of this report. The components and related expenses are as follows: Base Extra Capacity Customer Costs Revenue Requirement $4,353,520 1,750,820 347,277 Total Revenue Requirement $6,451,618 B. Allocation of Revenue Requirements to Customer Classes Based upon the customer class allocation percentages developed in Section III of this report, the Water Utility's revenue requirement has been allocated to the various customer classes (before adjusting for contract customers' terms) as follows: Campbell Soup LCWSD Revenue Requirement $2,174,171 1,690,964 1,277,184 924,105 385,193 Residential Commercial Tenaska III Total Revenue Requirement $6,451,618 CiryolParis. Texas Water aad Wastewater Cost alService Study March 2003 20 REVISED DRAFT Table C-3 in Appendix C presents a detailed description of the various components of costs assigned to each customer class. CiryolPoris. Texas Walerand WastewolerCost olService Study March 2003 21 REVISED DRAFT VII. REVIEW OF W ASTEW A TER SYSTEM DATA A. Review of Historical Wastewater Data To determine a comparison of wastewater production to water consumption by the City's water utility customers, av:ailable test year data was analyzed for the purpose of this study. From the test year residential water consumption, water-only (customers with sprinkler meters and septic tanks) consumption was removed. Commercial contribution to the wastewater system is estimated from the commercial and retail industrial water consumption after eliminating the consumption of the water-only accounts. Since the commercial and industrial water consumption exhibits minimal seasonal variation, nearly 100 percent of the water consumption of these customers contribute to the wastewater system. B. Svstem Wastewater Loadiol! Data A review of the data on wastewater treatment obtained from the City indicates that the facilities have performed well under normal loading conditions. The following table shows the range of flow and wastewater influent strengths for the test year. Cityo/Paris. Tetas Water and Wastewater Cost o/Service Study March 2003 22 REVISED DRAFT \Vastewater Inlluent Characteristics Flow in Period MGD BOD TSS NH3 mgL! Ibs. mgL! Ibs. mgL! Ibs. Test Period 4.73 113.19 1.63M 120.11 1.73M 6.59 .10M Average The average flow, BOD, TSS and NH3 of the wastewater system are well within the design parameters of the City's wastewater treatment facilities. c. Determination of Customer Classes The City has a special contract with Earthgrains with respect to wastewater discharge. Earthgrains wastewater rate is not based on the total cost of service for the wastewater utility since Earthgrains contributed up-front capital to reserve a certain capacity in the wastewater treatment plant for future use. In order to recognize Earthgrains' contract with regard to the cost of service and rate design study, Earthgrains' wastewater volumes were removed from the rate calculation and their revenues were recognized as revenue offsets. These adjustments help to prevent an overestimate of wastewater billing units and an underestimate ofrevenues. For the purpose of distributing the total revenue requirement for the system, the wastewater utility customers are divided into two classes: residential and commercial. For rate design purposes, residential customers are assumed to discharge wastewater of normal system strength, while commercial customers are assumed to discharge at slightly higher strengths based upon industry standards. Any metered commercial customer that discharges wastewater of strength Ciry of Paris. Te.tas Water and Wastewater Cast afService Study March 2003 23 REVISED DRAFT greater than these criteria set for residential and commercial customers pays for the added cost of treatment required. D. Allocation Factors for Customer Class Revenue Requirements For cost allocation purposes, conditions corresponding to an average flow of 4.73 MGD with BOD of 113 mg/I or.1,628,146Ibs., TSS of120 mg/I or 1,727,729Ibs. and ammonia loading of7 mg/I or 94,728Ibs. are assumed. (Table C-6, Appendix C) CityojPads, Texas Waterand Wastewater Cost ajService Swdy March 2003 24 REVISED DRAFT VIII. DETERMINATION OF TEST YEAR REVENUE REOUIREMENT Table C-l in Appendix C shows the revenue requirement, as adjusted for the test year. As shown in this exhibit, the total revenue requirement for the City's Wastewater Utility is estimated to be $4,372,792. The initial beginning point in developing the total wastewater utility revenue requirement was the City's FY 2001/2002 budget adjusted to incorporate the projected FY 2002/2003 debt service. A. Functionalization of Revenue ReQuirement Unlike the water utility system, where separate consideration of extra capacity components of plants and facilities is crucial to equitable allocation and cost distribution among customer classes, it is not necessary to account for extra capacity in the allocation and distribution of costs among wastewater utility customers unless there is large reserve capacity in the system. The City's wastewater operation and maintenance expenses can be functionalized into the following service cost functions: a. Warehouse b. Billing and Collecting c. Sewer Maintenance (Wastewater Collection) d. Wastewater Treatment e. Lift Station CityojP.,;s, Texas Wolerand Wastewaler Cost ojServiceS/lldy March 2003 25 REVISED DRAFT Warehouse Since wastewater warehouse operations serve both treatment and collection, warehouse costs are functionalized based upon composite allocation factors. Billint! and Collectint! These are costs ass~ciated with meter reading, billing, administration and other functions of the wastewater utility that are independent of quantity and quality of the wastewater contribution by a customer. Sewer Maintenance Since wastewater flows do not vary significantly except due to infiltration/inflow, which must be shared by all customers of the system, allocation and distribution of all costs for wastewater collection may be made among customer classes on the basis of average annual wastewater flow contribution to the system. All capital costs and operation and maintenance costs associated with the wastewater collection system should be allocated on the basis of relative percentages of wastewater flow during the test period. Wastewater Treatment Factors affecting wastewater treatment are different and many. Not only the volume of wastewater contribution by a class of customer is relevant, but also the quality of the wastewater is important. Treatment facilities must be designed to meet both the hydraulic loading and the biochemical loading. Historically, the City's wastewater utility has measured wastewater strength in tenDS of three parameters: a. BOD (Biological Oxygen Demand) b. TSS (Total Suspended Solids) City of Paris. Te,as Water and WaSlewa/er COSI of Service Study March ZO03 26 REVISED DRAFT c. Ammonia (NH3) Costs of operating and maintaining the treatment plant, therefore, must be allocated and functionalized by these parameters, BOD, TSS and NH3, so that revenues may be collected from the customer on the basis of not only quantity of wastewater, but also quality of the wastewater. Lift Station Lift stations are Ui~ed to elevate waste along the wastewater collection system or into to the treatment plant. Since the costs associated with lift stations depend on the quantity of wastewater and not the quality of wastewater, lift station costs were functionalized to flow. Employing the appropriate factors, the test year wastewater revenue requirement has been allocated to the functions of Flow, BOD, TSS, Ammonia, and Customer Costs. The results of this allocation are shown on Table C-5 in Appendix C and are summarized as follows: Customer Costs $2,455,548 1,058,362 580,098 44,736 234,047 Flow BOD TSS Ammonia Total $4,372,792 City of Poris. re.ms Water and Wastewater Cost ofSe",;ce Stlldy March 2003 27 REVISED DRAFT IX. RATE DESIGN A. Water Rates Consultant Recommended Water Rate Schedule RESIDENTIAL CLASS Base Cost Excess of Base Meter Size (Inches) (Cubic Foot) (Per CCF) 5/8 and 3/4 $7.00 for first 200 $2.45 for each add. 100 I and larger $34.00 for first 1,000 $2.45 for each add. 100 COMMERCIAL CLASS 8 and larger Base Cost Excess of Base (Cubic Foot) (Per CCF) $8.50 for first 200 $2.45 for each add. 100 $34.00 for first 1,000 $2.00 for each add. 100 $120.00 for first 3,000 $2.00 for each add. 100 $2,000 for first 100,000 $2.00 for each add. 100 $3,000 for first 150,000 $2.00 for each add. 100 $4,000 for first 200,000 $2.00 for each add. 100 Meter Size (Inches) 5/8 and 3/4 I and 2 Larger than 2 4 6 Citya[Paris. Texas Water and Wastewater Cost a[ServleeStudy Mareh 1003 28 REVISED DRAFT B. Analysis of Campbell Soup Company Contract Based on Campbell Soup's current contract rate and estimated volumes, Campbell Soup will provide $1,211,691 in revenue, as shown in Table B-2 in Appendix B. C. Analysis of Lamar County 'Vater Supply District Contract Under the current c°.ntractual agreement with LCWSD, it is estimated that the City of Paris will recover $668,320 from LCWSD water purchases through the City's transmission system. Due to the unpredictability of LCWSD's water purchases through the City's distribution system, estimated water distribution revenues were not detennined, however, a rate is provided based on FY 2000/2001 data. LCWSD revenues derived by the contract billing method and the distribution rate are shown in Table B-2 in Appendix B. D. Analvsis of Ten ask a III Contract Based on Tenaska III's current rate and estimated volumes, Tenaska III will provide $364,286 in revenue as shown in Table B-2 in Appendix B. E. Analysis of Marvin-Jenninl!s Clardy WSC Contract Based on the cpr increased allowed per the Marvin-Jennings Clardy contract, it is estimated that Marvin-Jennings Clardy WSC will provide $45,842 in revenue as shown in Table B-2 in Appendix B. Cilya/Paris. Tetas Water and Wastewater Cast a/Service Sludy March 2003 29 REVISED DRAFT F. Lamar Power Partners Per the contractual terms with Lamar Power Partners, it is estimated that Lamar Power Partners will provide $275,791 in revenue from raw water purchases to the City as shown in Table B-2 in Appendix B. G. Wastewater Rates Consultant Recommended Wastewater Rate Schedule RESIDENTIAL CLASS Meter Size (Inches) Base Cost (Cubic Foot) Excess of Base (Per CCF) 5/8 and 3/4 $7.50 for first 200 $3.25 for each add. 100 I and larger $36.00 for first 1,000 $3.25 for each add. 100 COMMERCIAL CLASS Meter Size (Inches) Base Cost (Cubic Foot) Excess of Base (Per CCF) 5/8 and 3/4 $10.50 for first 200 $3.40 for each add. 100 I and 2 $36.00 for first 1,000 $3.40 for each add. 100 Larger than 2 $62.00 for first 2,000 $3.40 for each add. 100 CityofPa,is. Texas Wat"aad Wastewat" Cost ojSe/'ViceStudy Ma,.h ZO03 30 REVISED DRAFT Excess Strength Charge BOD $0.65/lb above 250 my I TSS $0.34/1b above 250 mg/I NH3 $0.47/lb above 30 mg/I Residential wastew~ter customers are currently billed on a maximum winter average, which places a cap on the monthly wastewater volumes that are billed. The use of a maximum winter average results in irregular monthly billings, placing increased risk on the City. To mitigate the risk associated with the maximum winter average, the City should implement a flat winter average for determining residential wastewater volumes. The flat winter average assumes that a residential customer's monthly wastewater volumes on average will reflect the winter average, that is, some months the residential customer will contribute more to the wastewater system and some months will contribute less. However, the maximum winter average assumes that the residential customer will not exceed the winter average. The proposed residential wastewater rates were calculated using a flat winter average, assuming 625 cubic on average per residential wastewater customer. For wastewater service to customers who do not receive water service from the City, monthly billings should be based upon consumption information obtained from the water supplier. If the City experiences additional costs in obtaining the wastewater data, these costs should be included in billing the wastewater customers. CityalParis. Texas Water and Wastewater Cast alService Study March 2003 31 REVISED DRAFT Commercial and industrial customers should be billed on the basis of 100 percent of the actual metered water consumption except those customers whose wastewater is metered. The latter should be billed for 100 percent of the metered wastewater. Unit charges for BOD, TSS and ammonia are computed so that individual customers that exceed the limits adopted <;10 the basis of domestic wastewater can be charged for excess strength according to the unit charges in the rate schedule on Table C-6 in Appendix C. City 01 Paris. Texas Water and Wastewater Cost olService Study March 2003 32 TABLE A-I CITY OF PARIS WATER UTILITY CUSTOMER USE AND CAPACITY REQUIREMENTS BASE-EXTRA CAPACITY METHOD TEST YEAR ENDING SEPTEMBER 31, 2001 CAPACITY TOTAL AVERAGE DAY FACTOR CAPACITY EXTRA CAPACITY (000', (000', CUSTOMER CLASS GALLONS) % PEAK DAY % PEAK DAY GALLONS) % RESIDENTIAL 2.689 21.82% 139% 3.745 1.055 13.02% COMMERCIAL 3.257 26.43% 109% 3.554 297 3.67% CAMPBELL'S SOUP 2,893 23.48% 231% 6,694 3.801 46.90% TENASKA 11I 1.032 8.38% 183% 1,887 855 10.54% LAMAR COUNTY 2,451 19.89% 186% 4.548 2,097 25.87% TOTAL SYSTEM 12,322 100.00% 166% 20,428 8,106 100.00% Page I of I TABLE A-2 CITY OF PARIS WATER UTILITY WATER AND W ASTEW ATER COST OF SERVICE STUDY TREATED WATER DISTRIBUTION AND TRANSMISSION LINES SIZE INCHES LENGTH FEET INCH-FEET PERCENT CLASS 0.75 1,356 1,017 1.00 1,054 1,054 L50 585 878 2.00 102,064 204,128 3.00 351 1.053 4.00 113,t53 452,6t2 6.00 297,777 1,786,662 SUBTOTAL 516,340 2,447,404 25.72% <8" 8.00 t39,449 1,1l5,592 10.00 75,557 755,570 12.00 114,935 1,379,220 14.00 1l,555 161,770 16.00 9,343 149,488 t8.00 6,000 t08,000 20.00 26,182 523,640 24.00 t4,954 358,896 SUBTOTAL 397,975 4,552,176 47.84% 8" - 24" 30.00 t5,293 458,790 33.00 12,062 398,046 36.00 46,060 1,658,160 SUBTOTAL 73,415 2,514,996 26.43% >24" TOTAL 987,730 9,514,576 100% Pagetofl TABLE A-3 CITY OF PARIS WATER UTILITY TREATED WATER LOSS ALLOCATION YEAR ENDING SEPTEMBER 31, 2001 TOTAL TREATED WATERALLOCATlON TREATED WATER SOLD TOTAL INCLUDING LOSS VIA VIA TRANSMISSION DISTRIBUTION CUSTOMER CLASS (Cuft.) (CuR) PERCENT LOSS (Cu ft.) (Cu ft.) PERCENT RESIDENTIAL 77,000,132 15.45% 48,236,965 125.237,097 20.74% COMMERCIAL 94,187,763 18.90% 57.475.006 151,662,769 25.11% CAMPBELL SOUP 154,405,054 30.99% 154,405,054 25.56% TENASKA 111 50,381,822 10.11% 50.381,822 8.34% LAMAR COUNTY WSD 113,772,777 5,838.743 24.01% 119.611,520 19.80% MJCWSD 2.688,010 0.54% 2.688,010 0.45% TOTAL SYSTEM 318.559.653 179,714,648 498.274,301 105.711.971 603.986,272 100.00% ¡PERCENT 52.74% 29.75% 17.50% 100.00%1 Pagel of! TABLE A-4 CITY OF PARIS WATER UTILITY WATER AND WASTEWATER COST OF SERVICE STUDY EQUIVALENT METERS BY CUSTOMER CLASS 3/4" or CUSTOMER ClASS less 1" t1/2" 2" 3" 4" 6" 8" 10" 20" TOTAL RESIDENTIAL NUM8ER 8,403 32 34 7 8,476 EQUIVALENTS 8,403 53 114 37 8,607 COMMERCIAL NUM8ER 1,169 138 161 154 14 9 1 1 1 t,64B EQUIVALENTS 1,169 231 536 B21 140 ISO 33 S3 314 3,447 CAMP8ELL SOUP NUMBER 1 1 EQUIVALENTS 314 314 TENASKA III NUMBER 1 1 2 EQUIVALENTS 17 53 70 LAMAR COUNTY WSD NUMBER 2 t 3 EQUIVALENTS 107 77 183 TOTAL SYSTEM NUMBER 9,572 170 19S 161 14 10 1 4 1 2 10,130 EQUIVALENTS 9,S72 2B4 650 BS8 140 167 33 213 77 62B 12,621 Page 1 ofl TABLEA-5 CITY OF PARIS WASTEWATER UTILITY WATER AND WASTEWATER COST OF SERVICE STUDY EQUIVALENT METERS BY CUSTOMER CLASS 3/4" or CUSTOMER CLASS less 1" 11/2" 2" 3" 4" 6" 8" 10" 20" TOTAL RESIDENTIAL NUMBER 8,lS4 31 33 7 0 0 0 8,22S EQUIVALENTS 8,154 51 111 36 0 0 0 8,352 COMMERCIAL NUMBER 1,038 123 143 137 12 8 1 1 0 0 1,463 EQUIVALENTS 1,038 205 476 729 124 133 30 47 0 0 2,783 CAMPBELL SOUP NUMBER 1 1 EQUIVALENTS 0 0 0 0 0 314 314 TOTAL SYSTEM NUMBER 9,192 154 176 144 12 8 1 1 0 1 9,689 EQUIVALENTS 9,192 256 587 765 124 133 30 47 0 314 11,449 Page I oft TABLE A-6 CITY OF PARIS WATER UTILITY WATER AND WASTEWATER COST OF SERVICE STUDY CUSTOMER CLASS ALLOCATION UNITS Item Total Residential Commercial Campbell Soup Tenaska III LCWSD O&M Exuenses Supply 12,322 2,689 3,257 2,893 1,032 2,451 Treatment Base 12.322 2.689 3,257 2,893 1,032 2,451 Max Day 8.106 1,055 297 3.801 855 2,097 Trans. & Dist. Dist. < 8" Base 5,946 2,689 3,257 Max Day 1,353 1,055 297 Trans. 8" to 24" Base 5,946 2,689 3.257 Max Day 1.353 1.055 297 Trans. > 24" Base 12,322 2.689 3,257 2,893 1.032 2,451 Max Day 8,106 1,055 297 3.801 855 2,097 Meters 12,621 8,607 3,447 314 70 183 Hydrants 12.054 8,607 3,447 0 0 0 Warehouse 12.322 2,689 3,257 2,893 1,032 2,451 Billing & Collecting 121,555 IOt,712 19,771 12 24 36 Admioistration Fees Allocated based on revenue requirement Debt Service Supply 12,322 2,689 3,257 2,893 1,032 2,451 Treatment Base 12,322 2,689 3.257 2.893 1,032 2,451 Max Day 8.106 1,055 297 3,801 855 2.097 Dist.<8" Base 5,946 2,689 3.257 Max Day 1,353 1,055 297 Trans. 8" to 24" Base 5,946 2.689 3.257 0 0 Max Day 1,353 1,055 297 0 0 Trans. > 24" Base 12,322 2,689 3,257 2,893 1.032 2,451 Max Day 8.106 1,055 297 3,801 855 2,097 Billin8 & Collection 121.555 101,712 19,771 12 24 36 Page 1 ofl B TABLE B-1 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description FY 100/ Actuals Allocated to Water Allocated to Wastewater Warehouse Personnel Cost Salories & Wages Social Security TMRS & Pension Employee Hospitalizations Ins Worke(s Compensation Ins Unemployment Compensation Stability Pay SUBTOTAL ~ Office Supplies Postage Wearing Apparel Motor Vehicles - Gasoline Motor Vehicles - Oil & lubricant MotorVehicles-Tires Laundry Cleaning Etc SUBTOTAL ~ Communications - Telephone Insurance & Bonds Travel Expenses Utilities - Electricity Utilities - Water and Gas Training - Tuition SUBTOTAL Maintenance, Buildin.s Buildings & Grounds SUBTOTAL Maintenance Furniture & Fixtures Machinery Tools Equipment Motor Vehicles Electronic Data Processing SUBTOTAL Pagel of 14 63,3/1 31,656 31,656 4,897 2.449 2.449 5,/09 2,555 2,555 7,9/1 3.956 3,956 1,704 1,352 1.352 708 354 354 84,643 42.321 42,321 407 204 204 311 161 161 111 III III 350 175 175 /5 8 8 41 21 21 /,357 679 679 1,059 1,029 1,029 /,910 960 960 569 285 285 518 264 264 5,075 2,538 2.538 /34 67 67 /34 67 67 689 689 /,378 692 /,385 692 CrTYOFPARlS WATER AND WASTEWATER COST OF SERVICE STUDY FV 2001 ACTUALS Account Description FY 200/ Actual< Allocated to Wate< Allocated to Wastewater Sund", Charm Auditing SUBTOTAL Eauioment Machinery-Tools-Equipment Motor Vehicles SUBTOTAL TOTAL WAREHOUSE I Personnel Cost Salaries & Wages Social Security TMRS & Pension Employee Hospitalizations Ins Worke<'s Compensation Ins Unemployment Compensation Overtime Stability Pay SUBTOTAL ~ Office SuppHes Postage Wearing Apparel Motor Vehicles - Gasoline Motor Vehicles - Oil & Lubricant MotorVehicles-Tires Motor Vehicles - Batteries Laundry Cleaning Etc Mechanical SUBTOTAL Contractual Communications - Telephone Car Allowance Insurance & Bonds Travel Expenses Utilities, Electricity Associations Utilities - Water and Gas Training - Tuition, Etc. Consultants SUBTOTAL Billing & Collection Page2afl4 /35 68 68 /35 68 68 92,729 46,365 46,365 272,5/7 136,258 136.258 22,500 11,250 11.250 27.46/ 13,731 13.731 39.043 19.521 19.521 4.089 2.044 2.044 74 37 37 4.722 2,361 2,361 370.405 t85,202 185.202 28.909 14,454 14.454 42.8/0 21,405 21.405 2.830 1.415 1,415 2.937 1,469 1.469 92 46 46 29/ 145 145 65 32 32 /9 10 10 77.952 38.976 38.976 2.188 1,094 1.094 /6.800 8,400 8,400 4./88 2.094 2.094 3.801 1,901 1,901 /.399 700 700 28.377 14.189 14.189 CITY OF PARIS WATER AND WASTEWATER COST OF SERYlCE STUDY FY 2001 ACTUALS Account Description FY 1001 Actuals Al1ocated to Water Al1ocated to Wastewater Maintenance - Buildin.s Buildings & Grounds SUBTOTAL Maintenance MachineryTools Equipment Instruments Etc. Radio Maint Motor Yehicles Electronic Data Processing- Maintenance Agreement Tire Repair SUBTOTAL SundrY Charm Auditing Safekeeping Fees Medical Expenses SUBTOTAL Buildin.s Structures Buildings SUBTOTAL ~ Furniture & Fixtures Machinery-Tools-Equipmcnt Motor Yehicles Communi"tion System Miscel1aneous SUBTOTAL TOTAL BILLING & COLLECTION Pagd of 14 9,488 4,744 4,744 9,488 4,744 4,744 1,710 1,355 1.355 /.656 828 828 /35 67 67 /7,758 8,879 8,879 22,159 1 t.129 11,129 1,000 1,000 1,000 625 313 313 1,615 1.313 1,313 1,578 7,359 1,289 3,679 1,289 3,679 4,968 4,968 9,937 52/,041 260,521 260,521 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description Allocated to Wastewater Water Production Personnel Costs Salaries & Wages Social Security TMRS & Pension Employee Hospitalization Ins Worker's Compensation Ins Unemployment Compensation Overtime Stability Pay SUBTOTAL ~ Office Supplies Postage Food Wearing Apparel Motor Vehictes. Gasoline Motor Vehicles. Oil & Lubricant MotorVehicles-Tires Motor Vehicles - Batteries Minor Apparatus Laundry Cleaning Ele Chemical Medical Ele Mechanical Botanical Seeds Etc Other Supplies Photographic Supplies Furniture & Fi",ures - Minor SUBTOTAL Contractual Communications - Telephone Car Allowance Insurance & Bonds Court Cost - Special Service Fees Travel Expenses Publications Utilities. Electricity Freight & Express Miscellaneous Associations Utilities - Water & Gas Training-Tuition Building Rental & Maintenance Testing, Analysis SUBTOTAL Page 4 of 14 FY 200/ Actua/, Allocated to Water 454.528 454.528 36.88/ 36.881 45.0/4 45.014 6/.275 61,275 /2.480 12,480 23.0/5 23.015 4.554 4.554 637.745 637.745 5.895 5,895 3.392 3.392 300 300 5.94/ 5.941 4.946 4,946 598 598 /.772 1.772 205 205 3./0/ 3.101 /.958 1,958 354.993 354.993 /83 183 /58 158 99 99 383.54/ 383.541 /1./35 11.135 29.395 29.395 3.026 3.026 389 389 49.876 49,876 /26 126 /3.4/9 13.419 3./17 3,117 673 673 3.446 3,446 6.688 6.688 /2/.289 121.289 crTY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Aocount Description Allocatod to Wastewat" FY 200/ Ac/uals Allocalod to Walor Mainlonance - Buildinas Buildings & Grounds Bridges & Cutverts Fillor Beds & Valves Sidewalks & Curbs Stonn Sewers Street & Alley Repairs Manholes Lampholes Etc Plant Towers Etc Meters & Meter Boxes Service Lines Hydrnnts & Valves Oth" - Studge Removal Screening-Landfill Fees SUBTOTAL Maintenance - Eouioment Furniture & Fixtures Machinery Tools Equipment Instruments Etc - Radio Maint Motor Vehicles Lease & Rental - Equipment Pumps & Motors Electronic Data Processing Mainlonance Agreement Tire Repair SUBTOTAL Sund" Char... Judgements Damages Etc Auditing Medical Expenses SUBTOTAL Buildin.. Structures Buildings SUBTOTAL ~ Furniture & Fixtures Machinery.Tools-Equipment Instruments & Apparntus Motor Vehictes Communication Syslom SUBTOTAL TOTAL WATER PRODUCTION PageS of 14 9.189 9.1&9 844 844 85.266 85,266 2/7 211 453 453 66,956 66,956 6.80/ 6,801 2.530 2,530 10.665 10,665 8.683 8,683 /91.603 191,603 445 445 31,957 31,951 3.465 3,465 2.823 2,823 705 105 /5.837 15,831 785 185 794 194 151 151 56.961 56,96t 7.500 1.500 85 85 7.585 1,585 3,044 3.044 3,535 3,535 6,579 6,519 1,405,303 $ 1,405,303 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Desoription Raw Water Supply Utilities - Electricity Spe<:ial Project - lake Crook Dam Operation & Maintenance - Pat Mayes Water Stor>ge Rights TOTAL RAW WATER SUPPLY Water Transmission, DIstribution Distribution <8" Transmission 8- to 24- Transmission >24- Meters and Meter Boxes Hydr>nts and Valves TOTAL WATER TRANSMISSION -DISTRIBUTION Sewer Maintenance Personnel Cost Salaries & Wages Sociat Security TMRS & Pension Employee Hospitalization Ins Worke~s Compensation rns Unemployment Compensation Overtime Stability Pay SUBTOTAL ~ Office Supplies Postage Food Wearing Apparel Motor Vehicles - Gasoline Motor Vehicles, Oil & Lubricant Motor Vehicles - Tires Motor Vehicles - Batteries Laundry Cleaning Etc Chemicat Medical Etc Photographic Supplies SUBTOTAL, Page 6 of 14 FY 200/ Actuals Allocated to Allocated to Water Wastewater 458.089 458,089 38.702 38,702 34.356 34,356 49,826 49,826 580,973 580.973 308.038 308,038 675,664 675,664 373.292 373.292 /6/,028 161,028 8,933 8,933 1,526,956 5 1,526,956 /59.975 159,975 /5.198 15,198 /8,550 18,550 25,/60 25,160 3.743 3,743 36,409 36,409 2.283 2,283 261,3/8 261,318 676 676 362 362 258 258 3,365 3.365 /4,967 14.967 1,109 1,109 3.733 3,733 172 172 399 399 6.093 6,093 3/,/36 31,136 CITY OF PARIS WATER AND W ASTEW A TER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description FY 200/ Actual< Allocated to Water Allocated to Wastewater Contractual Communications, Telephone Insurance & Bonds Court Costs - Special Service Fees Travel E<penscs Utilities - Electricity Freight & E<prcss Miscellaneous Associations Utilities-Water&Gas Training-Tuition SUBTOTAL: Maintenance, Buildin.s Buildings & Grounds Sanitary Sewer Street & Alley Repairs Manholes Lampholes Etc Service Unes Service Force Main Bridges & Culverts SUBTOTAL Maintenance - Eouioment Furniture & Fi<turcs Machinery Tools Equipment Instruments Etc - Radio Maint Motor Vehicles Lease & Rental Equipment Electronic Data Processing Tire Repair SUBTOTAL Sundrv Charm Judgments Damages Etc Auditing Medical Expenses SUBTOTAL: Buildin.s - Structures Sanitary Sewer Manholes Lampholes Etc Service Unes Sewer Mains SUBTOTAL Page7ofl4 2.2/3 2.213 3.647 3.647 2.420 2,420 95 95 298 298 2.100 2,100 8/0 810 /1.58/ 11.581 73/ 731 23.378 23.378 171.751 171,751 8.606 8,606 6.392 6,392 1.284 1,284 /96 196 212.337 212,337 27,911 27,911 59/ 591 17.7/3 17,713 2/.095 21,095 344 344 67.654 67,654 500 500 2.000 2.000 306 306 2,806 2.806 2.033 2,033 595 595 4,035 4,035 6.663 6,663 CrTYOFPARlS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description Allocated to Wastewater ~ Machine'Y-Tools-Equipment Motor Vehicles SUBTOTAL: Force Account Proiect Public Works Miscellaneous r & r SUBTOTAL: TOTAL SEWER MAINTENANCE FY 100/ Actuals 1.194 /.194 594,789 Wastewater Treatment Personnel Cost Salaries & Wages Social Sccurity TMRS & Pension Employee Hospitalization Ins Worke~s Compensation rns Unemployment Compensation Overtime Stability Pay SUBTOTAL Pagegofl4 616.13/ 5/.405 61.716 8/.166 9.753 /.653 40.509 5.110 877.761 Allocated to Water 1.294 1,294 594,789 626,231 51.405 61,726 81.266 9.753 r,653 40,509 5,220 877,762 CrTYOFPARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description FY 200/ Actuals Allocated to Water Allocated to Wastewater ~ Office Supplies Postage Food Wearing Apparel Motor Vehicles - Gasoline Motor Vehicles, Oil & Lubricant Motor Vehicles - Tires Motor Vehictes - Batteries Minor Apparatus Laundry Cleaning Etc Chemical Medical Etc Mechanical Botanical Seeds Etc Other Supplies Photographic Supplies SUBTOTAL ~ Communications - Telephone Insurance & Bonds Court Cost - Special Se",ice Fees Travel Expenses Publications Utilities - Electricity Freight & Express Miscellaneous Associations Utilities-Water&Gas Training-Tuition Testing-Analysis Contractual SUBTOTAL: Maintenance - Buildin.s Buildings & Grounds Bridges & Culverts Filter Beds & Valves Sidewalks & Curbs Street & Alley Repairs Manholes Lampholes Etc Meters & Meter Boxes Sc<vice Lines Hydrants & Valves Other - Sludge Removal Screening - Landfill Fees SUBTOTAL Page90fl4 3.796 3.796 723 723 42/ 421 8.359 8.359 7.693 7.693 609 609 /.354 1.354 /93 193 3.530 3,530 2,744 2.744 94.8/3 94.g13 3.364 3.364 53/ 531 /63 163 /28.292 128.292 2.466 2,466 9.904 9,904 /.744 1.744 284 284 274.289 274.289 167 167 3/.686 31.686 2.557 2.557 1.245 1.245 5.574 5.574 15.996 15,996 345.913 345.913 9.119 9.119 81 81 956 956 210 210 1.448 1.448 220 220 11.356 11.356 8.853 8.853 3,72/ 3,721 35.964 35,964 crTY OF PARIS WATER Ai'iD WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Desoriptian FY 200/ Actua/, Allocated to Water Allocated to Wastewater Maintenan" ' Eauioment Furniture & Fi.tures Machinery Tools Equipment Instruments Etc ' Radio Maint Motor Vehicles Miscellaneous Repair Lease & Rental, Equipment Pumps & Motors Electronic Data Processing Maintenan" Agreement Tire Repair SUBTOTAL: SundrY Char... Auditing Judgement. Damages. Etc. Medical E.penses SUBTOTAL: Eauioment Machinery-Tools-Equipment rnstruments & Apparatus Motor Vehicles Communication System Buildings SUBTOTAL Total Wastewater Treatment LIft Station Personnel Cost Salaries & Wages Sociat Security TMRS & Pension Employee Hospitalization Ins Worke~sCompensation Ins Unemployment Compensation Overtime Stability Pay SUBTOTAL Page lOafl4 283 283 63.010 63,020 29./84 29.t84 3.993 3.993 154 254 /.635 1.635 /74.3/0 174.310 550 550 540 540 9 9 273.779 273.779 8.500 8.500 295 295 335 335 9./30 9.130 /.27/ 1,271 3.688 3.688 /.503 1,503 6.46/ 6,461 /,677,302 1,677,302 1/8./08 118.108 9.77/ 9,771 1/.926 11.926 /6.649 16,649 /.833 1.833 8.563 8,563 /.056 1,056 /67.906 167.906 crTY OF PARJS WATER AND WASTEWATER COST OF SERVICE STUDY FY 200t ACTUALS Account Description FY 200/ Actuals Allocated to Water Allocated to Wastewater Suoolies Office Supplies Postage Food Wearing Apparel Motor Vehicles - Gasoline Motor Vehicles - Oil & Lubricant Motor Vehicles - Tires Motor Vehicles - Baneries Minor Apparotus Laundry Cleaning Ele Chemical Medical Etc Mechanical Botanical Seeds Ele Other Supplies Photographic Supplies SUBTOTAL Contractual Communications - Telephone Car Allowance Insurance & Bonds Trove! Expenses Publications Utilities-Electricity Freight & Express Miscellaneous Associations Utilities - Water & Gas Troining - Tuition Testing-Analysis SUBTOTAL Page 11 ofl4 7 7 33/ 331 960 960 3.83/ 3.831 208 208 47 47 6 6 /5 IS /8 18 15./75 15,175 24 24 20.620 20,620 8.02/ 8,021 (66) (66) 3.460 3.460 237 237 24 24 81.37/ 81,371 676 676 400 400 /.489 1,489 95.6/2 95,612 CtTYOFPARlS WATER ANI> W ASTEW ATER COST OF SERVICE STUI>Y FY 2001 ACTUALS Aeoount Description FY 2001 Actuals Alto"ted to Wot" Altoc"ed to W"tew"" Mointenonce - Buildin.. Buildings & Grounds Bridges & Culverts Filter Beds & Vatves Sidewalks & Curbs Storm Sewers Street & Alter Repoirs Meters & Meter Boxes Hydronts & Valves Screening. Landfilt Fees SUBTOTAL Mointenonce . Eouioment Furniture & Fixtures Machinery Tools Equipment Instruments Elc - Rodio Maint Motor Vehicles Leue & Rental, Equipment Pumps & Motors Electronic Dolo Processing Tire Repoir SUBTOTAL, Sundrv Chorm Auditing SUBTOTAL, EouiDment MoIor Vehicles Instruments & App"""s Communic"ion System Buildings Standpipes & Reservoirs SUBTOTAL TOTAL LIFT STATION Page 120fl4 1.708 1.708 1.394 1.394 50 50 3.153 3,153 2.124 2,124 363 363 425 425 395 395 16.705 16.705 51 51 20,062 20,062 2.000 2,000 2.000 2,000 1.986 1,986 1.986 1,986 3/1,339 311,339 crTY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY FY 2001 ACTUALS Account Description FY 2001 Actuals Allocated to Wate< Allocatcd to Wastcwate< Debt Service Debt Service Wate<works and Sewer System Revenue Bonds Series 1992 Waterworks and Sewe< System Reven", Bonds Series 1994 Waterworks and Sewe< System Revenue Bonds Sedes 1997 Waterworks and Sewe< Sy¡tem Revenue Refunding Bonds Series 1998 Waterworks and Sewer System Revenue Bonds Series 1998 Waterworks and Sewer System Revenue Bonds Series 2000 Waterworks and Sewer System Revenue Refunding Bonds Series 2001 Debt or Contingency SUBTOTAL TOTAL DEBT SERVrCE Utility Franchise Fee Administrative Fees TOTAL EXPENSES Revenue Offsets Sewe<Taps Water Taps Misc. Wate< and Sewe< Sanitation Billing Fee Service Charges Bulk Wate< Sales Sewer Dumping Fees Wate< and Sewe< Charge Offs Water and Sewer Returned Checks Water and Sewe<Copies Interest Earned Contract Custome< Billing SUBTOTAL: Total Revenue Offsets Page 130f14 464,220 437,025 711.630 845,679 739.653 554,739 184,913 613,441 3,811.648 $ 2,349.920 1,461,727 3,811,648 2,349,920 t,461,727 345,535 202,914 142,621 750,000 440,435 309.565 11,617,616 6,813,387 4,804,229 13.990 13,990 19.834 19,834 (33,893) (t6,947) (16.947) 75,286 37,643 37,643 76.492 76,492 14.634 7,317 7.317 46,037 46.037 (71.796) (35,898) (35,898) 5,850 2.925 2,925 119 60 60 164.814 82.407 82,407 311,366 173.833 137,533 3/1,366 173,833 \37,533 CITY OF PARIS WATER AND WASTEWATER COST OF SERYICE STUDY FY 2001 ACTUALS Account Description FY 200/ Acluals Allocated to Water Allocated to Wastewater Other Conlractual Reveoue Offsets Lamar Power Partners Surcharge Mcrico Flow Merico Sampling & Auditing Merico Administrative Total Olher Contraclual Revenue orrsets Tolal Revenue Requlrem~nt Pagel40rl4 275,79/ 275,791 208,997 208,997 220,23/ 220,231 14,425 14.425 13,230 13,230 732,674 275,79/ 456,884 /0,573,576 S 6,363,764 S 4,209,8r2 Tenaska III TABLE B-2 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE MODEL CONTRACT CUSTOMER BILLING CALCULA nONS Tenaska Revenue Requirement Test Year Consumption Volumetric Rate Total Revenue Page2of6 364,286 50,381,822 0.72 PerCCF 364,286 TABLE B-2 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE MODEL CONTRACT CUSTOMER BILLING CALCULATIONS Lamar Countv WSD - Transmission Deoreeiation Water Treatment Plant in Place at 10/01/84 Assets Placed in Service After 10/1184 Capital Outlays Since 10/1/84 Total Depreeiation Bond Interest and A2Cnt Fe<:s (Production Related) 1992 WW/SS 1994 CO. 1997 CO. 1998 Tax & Revenue 1998WW/SS 2000 WW/SS 2001 Refunding Total Bond Interest and Agent Fees Total Capital Costs Contractual Amount of Capital Costs Production O&M Less Lamar Power Offset Production O&M Applicable to LCWSD LCWSD Test Year Sales Total System Production Contractual Amount ofO&M Administrative Charge Subtotal Profit Revenue Requirement Volumetric Rate Total Revenue $ 21.0% $ 19.9% $ 6.5% $ 10.0% $ Page30f6 92,418 310.574 15,332 418,324 32,963 117.900 243.430 86,451 480,743 899,067 188,804 1,986,276 67.545 1,918,731 894,694,170 Gallons 4,497,711,000 Gallons 381,678 37,081 607,563 60,756 668,320 0.56 PerCCF 668,320 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE MODEL CONTRACT CUSTOMER BILLING CALCULA nONS Lamar Countv WSD - Distributiou DistributionO&M Distribution O&M Less: MeIer & Meter Boxes Service Lines Fire Hydranls & Valves Total DistribulionO&M Debt Service (Distribution-Relaled) 1992 WW/SS 1994 c.o. 1997 CO. 1998 Tax & Revenue 1998 WW/SS 2000 WW/SS 2001 Refunding Total Debt Service Subtotal Administrative Charge Subtotal Profit Total Applicable COSls LCWSD Distribulion Sales Total System Distribution Sales Contractual Amount ofO&M Distribution Rale per CCF 1,526,956 206,269 5.080 23,369 234,719 1,292,237 85,092 90,071 115,222 16t,Ol7 554,739 116.799 1.122,940 2.415,177 6.5% $ 156.987 2,572,164 10.0% $ 257,216 2,829,380 5,838,743 172.935,698 3.4% $ 95,527 1.64 Page4of6 TABLE B-2 TABLE B-2 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE MODEL CONTRACT CUSTOMER BILLING CALCULATIONS MJC-WSC MJC,WSC Test Year Sales Volumetric Rate Total Revenue Page50f6 20,106,315 2.28 PerlOOOGallons 45,842 TABLE B-2 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE MODEL CONTRACT CUSTOMER BILLING CALCULA nONS Total Raw Water Cost or Service LPP Cost or Service Lamar Power Partners O&M Expense" Warehouse Billing & Collecting Raw Water Production Electricity O&M - Pat Mayse Other Raw Water O&M Water Transmission O&!Io1 Water Transmission Capital Outlay Water Storage Rights Spare Parts Cost Directly Related to FP&L Pipeline O&M Costs Directly Related to FP&L Pipeline Electricity Costs Directly Related to FP&L Pipeline Total O&M Expenses Debt: Debt Service 10% Debt Service Coverage Total Debt Service 198,357 4t,707 75,000 15,770 25,000 5,257 288,052 60,567 60,000 12,616 646,409 135,916 33,008 6,940 70.731 14,872 83,744 17.608 187,482 39.421 325,925 68.530 32,592 6,853 358,517 75,383 1,192,409 250,719 5,752.029 1,209,435 0.20730 Per 1,000 Gallons 0.20730 Per 1,000 Gallons 0.02073 Per 1,000 Gallons 0.22803 Per 1,000 Gallons 275,791 Non-Operating Expenses: PILOT Administrative Transrer to General Fund Working Capital- 30 Days Total Non-Operating Expenses Total Cost orService Test Year Raw Water Sales (Ooo's Gallons) Raw Water Rate 10% Mark-up FP&L Raw Water Rate Total Revenue Page6of6 c TABLEC-I CITY OF PARIS WATER AND WASTEWATER COST OFSERvrCE STUDY 1001.1001 BUDGET A"ou", D=ripriou BudS" 2001 - All","" 10 AII"",.dto 2002 W"" W""w"" Wmho... ~ S,I,ri,,&W,g" 71,8PO 35.945 35,945 S",i,1 Suourity MP9 2,750 2.750 TMRS & P.o,ioo 7,088 3.544 3.544 EmploY" Ho'Pitoli"rio., r., 8.400 4.200 4.200 Wolk.(, Comp..".o. I., 3./11 1,561 1.561 U..mploym..t Comp.....o. StobiHtyP'y TBO 390 390 SUBTOTAL 96.779 48.390 48.390 - om" Suppli" 1.000 500 500 Po,tog. 200 roo 100 W..ri.gApp",1 300 ISO ISO Moto,V.hic1"-G",,Ii.. 400 200 200 Molor V.hic1,,-Oil& Lubrieon' 90 45 45 MoloIV.bic1"-Ti,,, 250 125 125 Lou.d", C¡.oni.g Etc 50 25 25 SUBTOTAL 2.290 1.145 1.145 ~ Communi...o., - T.I'Pho.. 2.240 1.120 1.120 I.'un.." & Bo",b 1.920 960 960 T,...I Eop..." 300 150 ISO Uriliri".EI"uidty 750 375 375 Utiliri"-W..",.dG,, 500 250 250 T"i.i.g-Tui.o. 300 150 IW SUBTOTAL 6,010 3,005 3.005 M,i.".,... - Buildi... Buildi... & Groun'" 500 250 250 SUBTOTAL 500 250 250 ~ Fumilu" & Fiolu'" 75 3g 38 M..hi..",TooI, ,",uipm..t 300 150 ISO MolulV.hiel" 400 200 200 Eluotro.ie [Jato Proemi.g 5.000 2.500 2.500 SUBTOTAL 5.77J 2.gg8 2,888 P'gol of 12 CITY OF PARr5 WATER AND WASTEWATER COST OF SERvrCE STUDY 1001-1001 BUDGET Aeoount "',.,;p"on Bud." 200/- 2002 AII""todto W"" AII"""dto W,",w"" ~ Audl'ng SUBTOTAL ~ Moohin",,-Toolo-Equlpm,nt Moto,V,hid" SUBTOTAL TOTAL WAREHOUSE Blliiog & ColI,,"on I ~ S,lorie, & W'g" S",i,IS"urity TMRS & P"",loo Emplo)", H°'l'i..Ii,,"on' In' Wolk,'" Compen,,"on rn, Unemployment Compo",'on Overtime S..biJity P'y SUBTOTAL ~ Office Suppll" Po,..ge W"riug App",1 MotolV,hid"-G",,lIn, Moto' V,hkl" - Oil & Lubri"n' MototV,hi'I"-TI",, MotolV,hid"-B,..ri,, Lound", Cleaning Ele M"hank,1 SUBTOTAL ~ Communi"rion, - Tel,phone COt Allowance I..utance & Bond, T,ml Exp""'" Urillri" - EI"tridty Aosoe"rion' Urillri,,- W'to,andG" Ttainlng - Tulrion. Ele. Consultan.. SUBTOTAL p,..10r12 200 100 100 200 100 100 5,000 2,500 2.500 5,000 2,500 2,500 1/6,554 5g,171 58,277 2B7,560 143,780 143.780 2/,99B 10.999 10.999 28,345 14.173 14,173 46,200 23,100 23.100 3,500 1.750 1.750 5,1/8 2.559 2.559 392,72/ 196,361 196,361 25,000 12.500 r2,500 48,000 24.000 24,000 /.800 900 900 3,000 1,500 1,500 150 75 75 500 250 250 /25 63 63 75 38 38 78,650 39,325 39.325 2,500 1.250 1,250 /6,800 8,400 8.400 4,500 2,250 2.250 500 250 250 4,500 2,250 2.250 250 125 125 /,300 650 650 200 100 100 30.000 15.000 15.000 60,550 30,275 30.275 CITY OF PARrs WATER AND WASTEWATER COST OF SERVICE STIJDY 2001,2002 BUDGET A"aun' o."riprian Bud", 2001 . 2002 Allocat,dto W.", Allocat,dto W""wat,, M.;n"n.." - BuHd;n" Building. & Ground. SUBTOTAL ~ M"hin"Y Toob Equ;pmoo' I..trum"," E". "'dia M.in' MatotV,hid.. E!,,""ni, D... Proc,..;ng M.in"n"" A_moo, SUBTOTAL ~ Audiring S.r,k'cp;ng Fm SUBTOTAL BuHd;n"Stru,tu". Buildings SUBTOTAL ~ Furni"", & Fix"".. M"hin"Y.Toob-Equipmoo' MntotV,hi"" Cammuni"rian S>,,"rn Mi",II..,aus SUBTOTAL TOTAL BrLLING & COLLECTrON p...3arI2 15,000 7.500 7.500 15,000 7.500 7,500 5,000 2,500 2,500 600 300 300 1,000 500 500 15,000 7.500 7.500 700 350 350 22,300 11,150 11,150 2,000 1,000 1,000 1,200 600 600 3,200 1,600 1.600 572.421 286,211 286,211 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY 2001-2002 BUDGET Aoooo", D=riprion AII",a"dto W..I,wa", Budg" 1001- 1001 AII",a"dto Wal" Wal" P,odu,don ~ Salaries & Wages S",iaIS",.m'Y TMRS & P,n,ion Employ.. Ho'pitaU"oon rn, Wolk,', Comp,nsaoon rn, Un,mploym,nl Comp,nsation O"rtime StabiUty Pay SUBTOTAL ~ om" SoppUes Po,tag, Food Wearing Appml Motol VeUie!es - GasoUne MotorVehloles,OIl&Luhricanl Motor Vehicles - Ti", MotorV,hie!es-Battories Minol Appm"" loondry Cleaning Eto Ch,mica! Modical Eto M",hanical Botanical S.."' Eto Oth" SoppUes Photogtaphi, SoppUes Fomitute&Flx....s-Minol SUBTOTAL ~ Commonicaoons - T,lephooe Car Allow.." lusomo" & Boo", CoortCost - Spedal Servlo, Fm Tmvel Eap..ses Poblloaoous UoUoes - EI"tridty ...ighl & Eap"ss Mis"I1..".. Ass",iaoous UoUoes-Wa",&G.. Ttainiog - Toiooo Bollding R..tal & Maio"n.." Tesliog-Analysis SUBTOTAL Page 4 orr2 480,171 480,271 38,718 38,718 49,901 49.902 71,400 71,400 /3,855 13,855 1,000 2.000 10,000 10,000 5.165 5,165 671,3/1 671.311 5.500 5,500 5.500 5.500 100 100 7,000 7,000 5,000 5,000 700 700 1,000 1.000 500 500 7,000 7,000 1,500 2,500 400,000 400,000 100 100 150 250 700 700 300 300 500 500 436,650 436.650 11.000 12,000 19,000 29.000 1,500 2,500 1,000 1.000 73,731 73,732 250 250 IJ,ooo 15,000 1,500 2.500 6,000 6,000 7,000 7,000 10,000 10.000 158,981 158,982 CITY OF PARrs WATER AND W ASTEW A TER COST OF SERVICE STUDY 1001,1001 BUDGET A"oont D,"riptlo. Alloc"od 10 W","'.." M,'.".'." - Bulldi... Bulldi.g, & Grou.d, Bridg.. & Cui..", Fil",¡¡'<h & V,I", Sld,w,lb & Curb, Slonn S,w,," S.....&AII'yR'p,in M,.hol.. lomphol.. Ele P¡,.tTowmE" M,"n&M.."Bom S""k, li... Hyd"... & V,lv" 0"" - Siudg' R,mova' Smonl.g-lo.dfill Fm SUBTOTAL M,I.lon,." - Eoulom'.1 Fuml.." & Fl...", M"hl."" Tool, £qulpmont r.,trum'." Ele - Radio M,i.t Motor V,hid.. [,em & R,...I- Equipm,.t Pump, & MaIO" EI"oo.k D,.. P,ocmi.g M,'.".'." Agro,m'.t T'"R,p'" SUBTOTAL ~ ludg,m,... D","g" Ele Auditi.g SUBTOTAL Bulldl... Stru,..", Bulldi.g, SUBTOTAL ~ Fumi.." & Fi,"r.. Ma,hi."y'Tool,-Equipm'.t r.strum.u.. & App","" Molo,V,hid" Commu.i"tlo. S>,,"m SUBTOTAL TOTAL WATER PRODucrroN P'g. 5 of11 Bud", 2001- 2002 Alloc",dlO W"" 15,000 500 25,000 1,000 250 5,000 /,000 40,000 7,000 5,000 10,000 15.000 500 25,000 1,000 250 5.000 1,000 40.000 7.000 5,000 10.000 109,750 109,750 600 600 30,000 30,000 5,000 5.000 3,000 3,000 500 500 30,000 30,000 1.500 2.500 1,000 1.000 500 500 73,/00 73.100 7.500 7.500 7.500 7,500 70,000 70.000 70,000 70.000 12,750 12.750 2,500 2.500 58,000 58,000 73,250 73,250 1.600,541 S 1,600,543 CITY OF PARIS WATER AND W ASTEW A TER COST OF SERvrCE STUDV 2001,2002 BUDGET Aocoon' !)osorip.on B"dget 1001- 1001 All"""", 10 W"" AlIoco"" 10 Wo"ewo'" Row Wo'" S"pply u,m,ies - Electridty Spedol Proj,,'- uke C",k Dom 00"'.0' & Moint,""" ' Pot Moyes W"" SIO"gelUgh~ TOTAL RAW WATER SUPPLY Wo'" T,mmt..to', m,t,tb"tio' Di,trih",io' <goo T"n,mi..io, goo 10 24" T"..mi"io, >24" Mele" ..d Met" 80m Hyd",~..d Volm TOTAL WATER TRANSMrSSION "DISTRIBUTION Sewer Moln',","" ~ So'ories & Woges SocioIS",rity TMRS & Pe"ion Employee Ho'pi"liu.o, r.. Wo,ke~' Comp,"".on ¡.. Unemployment Comp,"".o, O".ome S"hmtypoy SUBTOTAL ~ om" S'pplies Po"'ge Food W"ri'g App"el MolO,Vehicles-G""line MolO' Vehicles - Oil & Lobri",' Motee Vehicles - Tim MOIO,Vchicles-&tteries uond'Y Cl",i'g Ele Chemi,,1 M",I,,¡ Etc Photognphlc S'pplies SUBTOTM,., pogc60rl2 458,089 458,089 15,000 25.000 75,000 75,000 60,000 60,000 618,089 618,089 280,310 280.310 585,79/ 585,791 323,639 323,639 100,000 100,000 1.289.741 S 1.289.74! 186,282 186,2'2 16.806 '6.'06 21,665 21,665 29,400 29,400 3,600 3,600 2,000 2.000 40,000 40,000 1,535 2,535 302,288 302,288 700 700 200 200 250 250 3,000 3,000 15,000 15,000 1,500 1,500 J,j00 1.500 400 400 1,000 1,000 5,000 5.000 500 500 29.050 29,050 CITYOFPARrS WATER AND WASTEWATER COST OF SERvrCE STUDY 2001,2002 BUDGET A"ount "',,"prion Budg" 1001 - . 1001 An",a"dto Wa'" An",a"dto W.."w,", ~ Communioario", - T,I,phono I",~'n" & Bood, Court Co," - Sp,dal S",,;o, F", T,,!Vet E.peos" VriHri"-EI,,tri,ity F«lght & E.p"" Mi"etlan<ous Ass",iarion' VriHri".Wa",&G.. T",inin, - Tuirion SUBTOTAL, Main'","" - Bundin.. Bundin.. & Grounds Sanitary Sew" Stt<et & An,y R",ai" Manhol" umphol" Ele S'M" Lio" SeM" Fo"" Main SUBTOTAL M,in"n"'" - Eouiom'n' Furni""" & Fi""'" M"hin,ry Tool, Equipm'n' rn"rum,n" Ele - Radio M,in' Moto,V,hic1" U.., & R,ota! Equipm,", E!"ttool, D'ta Proc",io, Ti«R'p,l, SUBTOTAL ~ ludgm,n" D'm'", Ele Audirin, M,dioal ""p,n", SUBTOTAL, Bundin.. - Stru,to", S,nitaryS,w" M'nhol" umphol" Ele S""I"Liri" S,w"M,in, SVBTOTAL ~ M"hin"Y-Toob-Equipm'nt Mo,..v.hic1" SUBTOTAL, rag' 7 om 1,000 2,000 5,000 5,000 400 400 1,500 2.500 400 400 1,400 1.400 1,000 1.000 /1,700 12.700 800 800 10,000 20,000 50,OIJ{) 50.000 5,000 5.000 5,000 5,000 6.0IJ{) 6,000 86,800 86,800 100 100 30,500 30,500 I,OIJ{) 1,000 20,000 20.000 30,000 30.000 100 100 600 600 81,300 82,300 1,000 1,000 1,000 2,000 2,000 2.000 5,000 5.000 10,000 10,000 10.000 10.000 20,OIJ{) 20,000 78,500 78,500 78,500 78,500 crTYOFPARlS WATER AND WASTEWATER COST OF SERvrCE STUDY 2001-2002 BUDGET A"o,"' [)eseriprion Budge/2oo1 - 2002 Allo""d te W..~ AII",..odte W.."w..~ Fol" A"o,"' Prol«, PubHe Wo"" Mlse,II,"eou' r & r SUBTOTAL, TOTAL SEWER MArNTENANCE W,stew.... T/,,'m,"' ~ S,I,ries&W'ges S",I,IS"urity TMRS & Pe",lo" Employee Hospl"ll"rio" I", Wolk,'s Comp,...rio" I", U",mpIo,,"e"' Comp,""rio" O",um, S"b;!;tyP,y SUBTOTAL - om" SuppHes Po,"ge Food W"ri"g AppmI Mo",Vehkles-O,soH", Mote/V,hlcles -Oil & Lubri,,"' Mote/V,hlcles-Tlte, Moto/V,hlcles-s.",ries MI"ol Appmtu' Lau"dry CI,,"I"g Eto Chemk,1 Medl,,1 Eto M"h"I,,1 Bo""I,,1 Seeds Eto Oth~ Supplies Phote""phk SuppII" SUBTOTAL ~ Commu"k,rio", - Tel'pho", I"su"",, & Bo"ds Court Cost - Speel,1 S",i" F'" T""I Exp'"se, Publl"rio"s UriHri"-EI,,oieity Ftelgb' & Expte" Mlse,II,",o", Assocl,rio", Urillri,,-W....&O.. T"I"I"g - Tulrio" Tesri"g-Ao"Y'I, SUBTOTAL, p,.. 8 ofI2 616,638 616.638 688,727 688.727 55,525 55,525 7U67 71.567 105,000 105.000 10,285 10.285 3,000 3,000 16,000 16.000 6,120 6.120 956,224 956,224 J,JOO 5,500 1,050 1,050 500 500 8,200 8,200 11,000 11.000 500 SOD 1,500 1.500 140 240 9,000 9,000 3,650 3,650 80,000 80,000 2,000 2,000 750 750 750 750 550 550 125,190 125.190 3,000 3.000 9,900 9.900 2,000 2,000 500 500 235.000 255.000 250 250 36,000 36,000 3,000 3,000 2,800 2.800 5,500 5,500 20,000 20,000 337,950 337.950 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY 2001-2002 BUDGET A"ounl De","ption Budget 2001 - 2002 Allocotedto W"u Alloc"edto W"tew"u Mo;ntenonce - BuHdin.. BuHdings & Grounds Bridges & Culverts FHtu Beds & Vol", Sidewolks & Cu,bs SUeel & Alley Repoi" Manboles Lompholes Ete Met'" & Metu 80", Semce Unes Hyd"n~ & Volves Oth" - Sludge Removol S",ening - Londfill Fees SUBTOTAL Mointenonce - Eouiome", Furo;tu..&Fixtu..s Maeh;nery Tools Equipment Instrumen~ Ete - Radio Mainl Moto,Yehicles Miscelloneous Repoi, Le... & Rental - Equipmeol Pumps & Moto" Electronic Dota !'roo",ing Mointenon« A",ement Ti..Repoi, SUBTOTAL, ~ Auditing SUBTOTAL, ~ M"hinery.Tools.Equipment Instrumen~ & App",tus Moto,Yehicles Communkotion S>"lem BuHdings SUBTOTAL Totol Wo.tewote, T,..lmeot Pogo 9 or 12 31,000 31,000 225 m 7,500 7,500 500 500 7,gOO 7,gOO 250 250 250 250 1,250 1.250 16,000 16.000 12,000 12,000 8,500 8.500 85,275 g5,275 2,000 2.000 50,500 50.500 32,500 32.500 6,500 6,500 500 500 3,300 3,300 72,000 72.000 1,500 1.500 800 gOO 100 100 169,700 169,700 8,500 g,500 8,500 8,500 24,000 24,000 6,800 6,800 8,000 8,000 40,000 40,000 78,800 78,800 1,761,639 S 1,'61,6J9 CITYOFPARrS WATER AND W ASTEW A TER COST OF SERVICE STUDY 2MI.2002 BUDGET A«ount De~riprion Budget 2001 - 2002 AII",a"dto Wat" AII",a"dto W,,"wa", UftSlltion ~ Salari" & Wag" S",'oIS"urity TMRS & Pension Employ" Hospitan"rion rns Wo,kds Comp'nsarion rns Un,mploym,nl Comp,nsarion Ovo<rim, StabilIty Pay SUBTOTAL ~ om" suppn" Postag, Food Wonring Appuel Motot V,hid" - Gnsonn' MototV,hld" -Oil & Lubri"nt Moto,V,hid,,-TI«s MoIO.V,hld"-Bo.,ri,, MInot AppOto"" (aundry Clon.'.g [to Ch,ml,,1 M,d"ol [to M"hon"ol Botani,,1 S"d> [to Oth" SUPPn" Photognphio suppn" SUBTOTAL Connaoluo! Communi"rions - ToI",hon, COt Allowon.. rnSUtOn" & Bonds T.ml Exp"", Pubn"rions Urinri"-E!,,tri"ty F«lght & E,p«.. Mlsu,IJanuous Assouiorions Urinri,,-w..,,&Gns TtOlning - Tuirion T"ring - Anolysls SUBTOTAL Page 10 of12 103,711 103,721 8,8/6 8.816 11,364 11,364 16.800 16.8M /.JJj 1.555 I,OGO 1,000 10,000 10,000 J.200 1,200 154,457 154,457 400 400 /50 150 50 50 J.200 1.2M 3,000 3,000 400 400 600 600 /50 150 250 250 200 200 15,750 15,750 100 1M 100 100 100 100 100 100 22,550 22,550 7,250 7,250 3.500 3,500 500 5M 300 300 80,000 80,000 /50 150 /.JOO r.500 300 300 1,500 1,500 750 750 500 500 '0,250 '6,250 CrTYOFPARlS WATER AND WASTEWATER COST OF SERVICE STUDY 2001-2002 BUDGET Account De",rip"on Budget 200/- 2002 Allneatedto W"" Allne"ed 10 W"tew"" Ma;ntenance - Build;n.. Buildings & Grounds Bridgos & Culve'" Fillet Be"'& Valvos Sidewalks & Curbs Stonn Sew", S..er & Aney Repa;rs MeretS & Mer" Bom Hydrsnu & Valves Smen;ng - Landfill Fees SUBTOTAL Maintenance - Fouloment Fumitute&FõxlUtes Moohi",')' Too~ Equipme" rnslrumenU Ele - Radio Maint MotorVehides Le"e & Rental- Equipment Pumps & Motors EI"lruni, Da.. ",neessing TiteRepair SUBTOTAL ~ Audi"ng SUBTOTAL ~ Molot Veh;des InslrumenU & Appa"tns Comm""i,,"on System Buildings Standpipes & ResetVo;rs SUBTOTAL TOTAL LIFT STATION Debt Sm"" Debt Servi" Wale<works and Sew" System Revenue Bonds Series 1992 W"....otks ond Sew" System Revenue Bonds Series 1994 Wate<wotks and Sew" System Revenue Bonds Series 1997 W"e<works and Sew" System Revenue Refund;ng Bonds Series 1999 W"....orks and Sew" System Revenue Bonds Series r998 Wate<wotks and Sew" System Revenue Bonds Series 2000 Wate<wotks and Sew" System Revenue Refund;ng Bonds Series 200 I Debt 0' Con"ngen,y SUBTOTAL TOTAL DEBT SERVICE U"Hey F"""hise Fee Adm;n;s"'"ve Fees TOTAL EXPENSES Page II ofl2 /0.000 10.000 500 500 500 500 500 500 500 500 500 500 500 500 3,000 3,000 5,000 5,000 1/,000 21,000 250 250 9,000 9,000 3,000 3,000 2,000 2,000 350 350 /7.500 17.500 250 250 75 75 32,'25 32.425 2,000 2,000 2,000 2.000 ',000 4,000 8.000 8,000 /2,000 12,000 340,682 340.682 '6',no 437,025 7/1,630 845,679 739,653 6/3,4</ 554.739 184,913 S 2.349.920 S 1.461,727 2.349,920 t,46t,n7 203,736 146,264 436,577 m.423 6,843,094 4,9S4,861 3,BII,6'8 J.811,648 350.000 750,000 11,827.955 crTY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY 2001-2002 BUDGET A"ountDm"p"on An",a"dto Wa",w"" Rev,"ue Off.." S,w" Tap, Wa'"Tap, Mi". Wa""nd S'w" Sanimrion Billing Fe< S""k,Ch"g" BulkWa",Sal" S,w" Dumping Fm Wa",and 5<w"Ch"go Off, Wa", and S,w" a'tuoi,d Ch"k, Wa",and5<w"Copi" rnt"", "rn,d Con"" Custom" BiIHng SUBTOTAL Total ReveD", Off.." Oth.. Contm'u,1 Rmnue Off.." Lam" Pow" Pann", Su.ch"g" M,",o Aow Mo",o Sampling & Audiring Mori,o Admini,..ôvo Total Olh.. CDntmtu,1 Rmn", Off"" Tot,1 Rovenu, Roqu¡"m,"t PagoI2of" Budget 200/- 2002 An",a"dto Wa", /4.500 14.500 20,000 20,000 74,385 37,193 37,193 70,000 35,000 35,000 10,000 10,000 55,000 55,000 (60.0001 (30,000) (30.000) 6,900 3.450 3,450 85 43 43 80,000 40,000 40,000 270,870 115,685 155,185 270,870 115.685 l55,t85 275,791 275,791 208,997 208,997 220,231 220.231 14.425 14,425 13.230 13.230 732,674 27S,79r 456.884 S 10,8U.410 $ 6.4Sr.6r8 $ 4,372.792 TABLEC-2 crTYOF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY BASE-EXTRA CAPACITY METHOD - BUDGET "'0 Cop,,;', E...-Cop Cooto"", COOlom~ A"o~ID, . lIon Bnd " Buo% Bu, AlI",orion % AlI",orion C"'"% COO" W",hoo", ~ Solori" & Wog" 35,945 100.00% 35,945 0.00% 0.000/. S",~IS_1y 2,750 100.00% 2.750 0.00% 0.00% TMRS & P=loo 3,544 100.00% 3,544 0.00% 0.00% Emplo", Ho",ial;,.rio", 1m 4,200 100.00% 4,200 0.00% 0.00% W".",.Cornp""oriooln> 1.561 100.00% 1,561 0.00% 0.000/. UoornployrnoolCOrnpOO..rioo 100.00% 0.00% 0.00% SabililyPs, 390 100.00% 390 0.00% 0.000/. 100.00% 0.00% 0.00% 100.00% O,()O% 0.00% SUBTOTAL ",3'" ",390 s..m Offi"Snppll" 500 100.000/. 500 0.00% 0.00% P","g' 100 100.00% 100 0.00% 0.00% W,uingApp=' ISO lOO.OO'~ ISO 0.00% 0.000/. Moto.V,hld,,-Guolin, 200 100.00% 200 O.OO'~ O.OO'~ Mnto. V,hld,,-Q;I & Lohri"'1 05 100.00% 05 0.00% 0.00% Moto<V,hid,,-T... 125 100.00% 125 O.OO'~ O.OO'~ '-'~""CI,..ing Efc 25 100.00% 25 0.00% 0.00% 100.00% 0.00% O.OO'~ 100.00% 0.00% 0.000/. SUBTOTAL 1.105 1,145 ~ Co~~i"rio",-T"nphooo 1,120 100.000/. 1,120 0.000/. 0.00% 10.-,,& Boo'" 960 100.000/. 960 0.00'/. 0.00% Tlml E.,.....> ISO loo.OO'~ ISO 0.00% 0.00% Urillri"-EI,,tridly J7S 100.00% J7S 0.000/. 0.00% Uriliri"-W",,..dGu 250 100.000/. 250 O.OO'~ 0.00% Tnining - Tnirion ISO 100.00'~ ISO 0.00% 0.00% 100.00% 0.00% 0.00'/. 100.00% 0.00% 0.00% SUBTOTAL 3,005 3,005 Msin"".."-Bnildin,, Bnilding,&GIO~'" 250 100.000/. 250 0.00% 0.000/. 100.00% 0.000/. 0.00% 100.00% 0.00'/. 0.00% SUBTOTAL 250 250 ~ F=i..' & Pi..." " 100.00'~ " 0.00% 0.00'/. M"hin",Too"Eqnip~1 ISO 100.00% ISO 0.00% 0.00% M""V,hid" 200 100.00% 200 O.OO'~ 0.00% EI"noni, Doa ""...ing 2,500 100.000/. 2,500 0.00% 0.00% 100.00% 0.00% 0.000/. 100.00% 0.00% O.OO'~ SUBTOTAL 2",g 2",g ~ Anditing 100 100.00% 100 0.00% 0.00% 100.00% 0.00% 0.00% 100.00'~ 0.00% 0.000/. SUBTOTAL 100 100 -.- M"hin",-TooI~Eqnip~1 2,500 100.000/. 2~00 0.000/. 0.00% Mot"V,hid" 100.00% 0.00% 0.00% 100.00% 0.00% O.OO'~ 100.00% 0.00% 0.000/. SUBTOTAL 2,500 2,500 TOTAL WAREHOUSE ",217 ".217 P,g" or5 A"o~' D""'o.oo CrTYOFPARJS WATER AND WASTEWATER COST OF SERyrCE STUDY BASE-EXTRA CAPACITY METHOD- BUDGET Em C..."'" .....C., C...."'" C"'o"", B,d", B~% B~Allo"'o, % AII",..oo CO"' % CO"' 143,780 0.00% 0.00% 100.00% 143,780 10,999 0.00% 0.00% 100.00% 10,999 14,173 0.00% 0.00% 100.00% 14,173 23,100 0.00% 0.00% 100.00% 23,100 1,730 0.00% 0.00% 100.00% 1,730 0.00% 0.000/0 100.00% 0.00% 0.00% 100.00% 2,559 0.00% 0.00% 100.00% 2,559 0.00% 0.000/0 100.00% 0.00% 0.00% 100.00% 196,361 I96~6I 12,500 0.00% 0.00% 100.00% 12.500 24,000 0.00% 0.00% 100.00% 24,000 900 0.00% 0.00% 100.00% 900 1,500 0.00% 0.00% 100.00% 1.500 73 0.00% 0.00% 100.00% 75 2SO 0.00% 0.00% 100.00% 2SO 63 0.00% 0.00% 100.00% 63 " 0.00% 0.00% 100.000/. " 0.00% 0.00% 100.00% 0.000/. 0.00% 100.00% 39,325 39.325 1,2SO 0.00% 0.00"10 100.00% 1,2SO 8,400 0.00% 0.00"10 100.00% 8,400 2,2SO 0.00% 0.00% 100.00% 2,2SO 2SO 0.00% 0.00% 100.00% 2SO 2,2SO 0.00% 0.00% 100.00% 2,2SO 12S 0.000/. 0.00% 100.00% 125 650 0.00% 0.00% 100.00% 650 100 0.00% 0.000/. 100.00% 100 ",000 0.000/. 0.00% 100.00% ",000 30,275 30,275 7,'00 0.00% 0.00% 100.00% 7.500 0.00% 0.00% 100.00% 0.00% 0.00% 100.00% 7,500 7,SOO 2,500 0.00% 0.000/. 100.00% 2~00 300 0.00% 0.00% 100.00% 300 500 0.00% 0.00% 100.00% 500 7,500 0.00% 0.000/. 100.00% 7.500 350 0.00% 0.00% 100.00% 350 0.00% 0.00% 100.00% 0.00% 0.00% 100.00% II,ISO II,ISO 1,000 0.00% 0.00% 100.00% 1.000 600 0.000/. 0.00% 100.00% 600 0.00% 0.00% 100.00% 1,600 1,600 0.00% 0.00% 100.00% 0.000/. 0.00% 100.00% 0.00% 0.00% 100.00% I ~ S,',,;,,&.W'8" Sod,IS<=ri", TMRS &. P,",lo, Emplo,.. H...i"lIn'o.. In, W""..., Com....,.o, In, U""'PI,Y"""' Comp,"y'O' O""'m, S"bill",P,y BIIII,< &. ColI,ctlo, SUBTOTAL S!oRJilig om"S'ppll" Po"'g' WooringApl"'ol Mo..,Y,lrid"-G",,,1in, Mo..,Y,bld"-Q;I&.L,bri",,, Mo",Y,lrid,,-T... Mo""Y,bld"-B,.ori,, L."'dryClomingEk M"iw>i", SUBTOTAL ~ Co=",I"'o..-T",,,b,", CM Allow""" 1m_" &. Boo'" T""I Ex"",,, U'II'"-EI".;",,, ""0""00' U'II'".W.""..dGu T"ining. T,I.o" Ek. Co",I",," SUBTOTAL M,in."..".8";ld;,,, B,lIdin..&.Grooo'" SUBTOTAL ~ M"bin"" Too' E,,;pm,"' In"""",",, Ek. R,di. M,in. M.""Y,bld" EI,,"",I, D," ,,",,'ning M,in...""'A""",,", SUBTOTAL ~ A,dlring s,r"""ing"" SUBTOTAL B,ildin"S""""", B,lIding' SUBTOTAL P'g' 2 0" CITY OF PARIS WATER AND WASTEWATER COST OF SERyrCE STUDY BASE.EXTRA CAPACITY METHOD, BUDGET E,'" c,p",,>, E,"'.cop C~to~ C~'om~ A",,~,D, .... Bod" B~% B~AII~.aon % AII~.ann C..u% c..u WiRmm! F=i..,"-Fix""" 0.00% 0.00% 100.00% M"hm"Y.TooI~Eqo;pm"" 0.00"1. 0.00% 100.00"/. MoI..V,hid" 0.00% 0.00% 100.00% Comm~k'a.. S,.."," 0.00"1. 0.00% 100.00% MiK,lIm"'~ 0.00% 0.00% 100.00% 0.00% 0.00% 100.00"1. 0.00% 0.00% 100.00"/. SUBTOTAL TOTAL BILLlNG"- COLLECTION 286,211 286,211 W.." Prod,,"on ~ S.I.,;",,- W'S" 480;11 60.32% 289,707 ".6S% 190,"" 0.00% S~i.IS"uri,>, 3&,718 60.32% 2),'" )9.6S% 1S,36) 0.00% TMRS "- p",.lnn 49,902 60.)2% )0,102 )9.6S% 19,800 0.00% EmploY" Ho'Piul",ann I.. 11,400 60.32% 4).070 )9."% 28,330 0.00% W..k,ÒCo"""""aon In. \3,'" 60.32% 8.'" )9.68% ',497 0.00% U~mploym"" Cnmp<nya.. 2,000 60.32% 1,206 )9."% 794 0.00"1. O-m' 10,000 60.32% 6,032 )9."% ),9" 0.00% Subili,>, P.y ',16S 60.32% ),116 )9."% 2,049 0.00% 60.32% ".6S% 0.00"/. 60.32% ".6S% 0.00"1. SUBTOTAL 611,)11 404.946 266~6S ~ om" Suppli" ','OIl 60.32% ),31S ".68% 2,182 0.00% P..US' '.'00 60.32% )~18 )9.68% 2,182 0.00% Food lOll 60.32% 60 ".,,% 40 0.00% W_SApp"'l 7,000 60.32% 4;23 ".,,% 2,777 0.00"1. Mnto,Vdud".G...lm, ',000 60.32% ),016 ".68% 1,984 0.00% Mnto' V ,hid". Oil "-Lobri'ml 700 60.32% 422 ".68% '" 0.00% Moto,V,hid".T1= 1.000 60.32% 60) ".,,% )97 0.00% Mo...V,hid".B'"m" SOO 60.32% )02 ".,,% 198 0.00% Mm..App""" 7,000 60.32% 4,223 ".,,% 2,777 0.00"/. '-'~dry CI=mS EI< 2,'00 60.32% 1.'08 ".,,% "2 0.00% Ch<mi"IM,di"IEI< 400,000 100.00% 400.000 0.00"1. 0.00% M"hmi,,1 100 60.32% 60 ".,,% 40 0.00% Bo...i"IS,,"'EI< 2SO 60.32% ISI 39."% " 0.00% Oth~Suppli" 700 60.32% 422 ".,,% 278 0.00"/. Photosnph;, Suppli" )00 60.32% 181 ".,,% 119 0.00"/. F=i.., "-Fix..",. Mm.. '00 60.32% "2 ".6S% 198 0.00% 60.32% ".,,% 0.00% SUBTOTAL 436,6SO 422,108 14,'42 ~ Comm~i"ao",' T'I<ph.., 12,000 60.32% 7.2" ".,,% 4,761 0.00% C~ Allowm" 60.32% ".,,% 0.00% In""m" "- B..", 29,000 60.32% 17,493 ".,,% II,SO7 0.00% Court C..,. Sp"i.1 S""i" F= 60.32% ".,,% 0.00% T.."IE,p"'~ 2,'00 60.32% I,'OS ".,,% "2 0.00% Publi"a.., 1,000 60.32% 603 ".,,% "7 0.00% Ualia".EI"tri"'>' 73,732 60.32% 44.477 ".68% 29,'" 0.00% F";Sh' "- Exp"" 2SO 60.32% .,1 ".,,% " 0.00% M",dlm..~ IS.OOO 60.32% 9,048 ".,,% ','" 0.00"1. A..od.ao.. 2,'00 60.32% I.SO8 ".,,% "2 0.00"/. Ualia".W."",-G" 60.32% ".,,% 0.00% T..mmS' Toia.. 6,000 60.32% ),619 )9.6S% 2,)81 0.00% BoildmS R",ul "- M.m'",.." 7.000 60.32% 4,223 ".,,% 2,777 0.00% T"rinS.An.I,..;, 10,000 60,32% 6,032 ".6S% )."S 0.00% 60.32% ".68% 0.00% SUBTOTAL 1S8,982 ",901 63,OS2 P'S"of' CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDV BASE-EXTRA CAPACITY METHOD. BUDGET E,u. C.p.dty Em,C'F Cw'o~ Cw'om~ A"~tD"," rioo BwI" B~% B~ AII".rioo % AII".rioo Co.. % Co.. M.iolm~'" Bu;ldio.. Buildiog.&G,o~'" 1S.000 60.32% "t).!g ".68% '.952 0.000/. Bridg" & CuI"", '00 60.32% 302 ".6g% 198 0.00% F;It~ B"" & V.I". 2',000 60.32% 1S,080 3'.6g% ','20 0.00% S;d<w.lk> & Cmb. 1.000 60.32% 603 ".68% 397 0.00% SIo~S~~ 250 60.32% ISI ".68% 99 0.00% So", & All" R'P'" ',000 60.32% 3.016 3'.6'% 1,984 0.00% M~hol" '-'mpOOI" Eœ 1,000 60.32% 603 ".6'% "7 0.00% FI~tTo"",Eœ 40,000 60.32% 24.12' ".68% 1S,'7I 0.00% M"~& M,"'Bo,," 7,000 60.32% 4,223 ".68% 2,777 0.00% S.m"Lio" ',000 60.32% 3.016 ".6'% 1.984 0.00% H,""".&V.I", 10,000 60.32% 6,032 ".6'% 3,'68 0.000/. Oth~. Siudg' R,m.,.1 60.32% ".68% 0.00% S=io,.Laudfill F", 60.32% ".68% 0.00% 60.32% 39.68% 0.00% 60.32% ".6'% 0.00% SUBTOTAL 109.750 66.203 43,'47 M.;o'm~,,-Eoulomml Furnl"",&Fi"""" 600 60.32% 362 ".6'% 238 0.00% M"hio"" Tool. Equ;pmm' 30,000 60.32% IS,O'6 ".6'% 11,'04 0.00% In.""""". Eœ. R.d;oM.iol '.000 60.32% 3,016 39.68% 1,984 0.00% Molo,V,hld" 3.000 60.32% 1,810 ".6'% 1,190 0.00% L_&Rm.I-Equ;F~1 '00 60.32% 302 ".68% 198 0.00% Pump, & Molon 30,000 60.32% 1S,O96 ".6'% 11,'04 0.00% EI~""u;, D.. ,,",...iog 2,'00 60.32% 1,'0' ".6'% 992 0.00% M.io"'~"A"""", 1,000 60.32% 603 ".6'% "7 0.00% T"'R'P" '00 60.32% 302 ".6'% 19' 0.00% 60.32% ".6'% 0.00% 60.32% ".6'% 0.00% SUBTOTAL 73,100 44.095 29,00' ~ Judg,mm. Domag" Eo< 60.32% ".6'% 0.00% AwI;,iog 7,'00 60.32% 4,>24 39.68% 2,976 0.00% 60.32% ".6'% 0.00% 60.32% ".6'% 0.00% SUBTOTAL 7,'00 4,>24 2.976 Buildio..S""""", Buildio" 70,000 60.32% 42.22> ".68% 27,775 0.000/. 60.32% 39.6'% 0.00% 60.32% ".68% 0.00% SUBTOTAL 70,000 42,225 27,775 ~ Furnl... & F;xna" 60.32% ".6'% 0.00% M"hio"".Tool~Equ;Fmm' 12,750 60.32% 7,691 ".6'% ',0" 0.000/. In.uumm. & AppM"" 2.'00 60.32% 1,'0' ".6'% 992 0.00% Molo,V,hld" 58,000 60.32% 34.987 ".68% 23,013 0.00% Co~~I",rioo S",= 60.32% ".6'% 0.00% 60.32% ".6'% 0.00% SUBTOTAL 73~'0 44,1S6 29,064 TOTAL WATER PRODUCTION 1.600,543 1,12',187 476~'6 Row W.." Supply Uriltri".EI"uidty '58,0"' 100.000/. '58,0"' 0.00% 0.00% Sp«i.IP,oj",-L.k,C=kD.m 25,000 100.000/. 25,000 0.00';" 0.00% Op=rioo&M.io...~".P..M.", 75,000 100.000/. 75,000 0.00% 0.000/. W.'" S'~g' Righ. 60,000 100.00% 60,000 0.00% 0.00% 100.00% 0.000/. 0.00% 100.00% 0.00% 0.00% TOTAL RAW WATER SUPPLY 61S,'" 618,0" F.g,'of> CITY OF PARIS WATER AND WASTEWATER COST OF SERyrCE STUDY BASE-EXTRA CAPACITY METHOD, BUDGET E,.. Copooily E,tto.Cop C~toma C~toma Bod" B~% B~AII~orio. % Allo"ri.. CO," % Co," 2S0,310 60.32% 169,OSS 39.6S% 111,223 0.00% 5S5,791 60.32% m,m 39.6S% 232,433 0.00% 323,639 60.32% I9S~24 39.68% 128.41S 0.00% 100,000 0.00% 0.00% 100.00% 100,000 0.00% 100.00% 0.00% '~89.741 117.671 472,070 100,000 2,349.920 ".78% 1,54S,174 J4.IS% 802,394 0.07% 1,752 203,136 100.00% 203,136 0.00% 0.00% 436,577 100.00% 436,577 0.000/. 0.00% 6.543,094 4.704,311 1.750,820 387,962 20,000 100.00% 20,000 0.00% 0.00% 100.00% 0.000/. 0.00% 37,193 0.00% 0.00% 100.00% 37,193 35.000 100.00% 35,000 0.00% 0.000/. 10,000 100.00% 10,000 0.00% 0.00% (30,000) 100.00% (30,000) 0.00% 0.000/. 3,4SO 0.00% 0.00% 100.000/. 3.450 4J 0.00% 0.00% 100.00% 4J 40,000 100.00% 40,000 0.00% 0.00% 0.00% 0.00% 100.00% I IS,"S 75,000 40.685 115,685 75.000 40.685 27S.791 100.00% 27S,791 0.00% 0.00% 27S,791 27S.791 6.451.618 4,353,520 1,750,820 341,277 A=""' D..m ri.. W.", T"..ml,,'oo - O"'nbolloo Oi'lnòunoo <S' Tlm'mi"i..S'",,' T'm=i"ioo>24' M"",md M"a Bo", Hy",,""mdVo"" TOTAL WATER TRANSMISSION - DISTRIBUTION O,b,S""I<, TOTAL DEBT SERVICE U",ilyF"",bi",F~ Admini,..ri" Fon TOTAL EXPENSES Rmou, OIr.." W"aT.p' Mi".Wo"'mdS~a Smimri.. Billin8 F~ S~i~ C""S" BolkW.."S.I" Wo",..dS~aC"""OfT, W.",..dS~aR'Iurn"'Cb~ks W.",..dS~aCop;" 1n1"",E~'" Co."" C~tom« Billin, SUBTOTAL, To"l Rmou, OfT.." Olb" Coolml..1 Rmo.. OfT.... um.. Powa p"""" Tot,1 Olb" Cool""..1 Rmou, OfT.." To'" Rmou, R'qol~m'ol Po," of! Item Total Residential Comme'cial Campbell Soup Tenaska 111 LCWSD O&M E.oenses Supply 618,089 \34,889 163,35\ 145,109 51,789 122,952 Production Base 1,\24,187 245,337 297,105 263,926 94,\94 223.626 M.. Day 476,356 62,027 \7,480 223,403 50,220 \23,227 Trans. & Dis!. Di5l.<8" Base 169,088 76,476 92,6\2 Max Day 111,223 86,770 24,453 Trans.8"to24" Base 353,359 159.818 193,540 M.. Day 232,433 181,33\ 51,101 Trans. > 24" Base \95,224 42,605 5\,595 45.833 16.358 38,834 Max Day 128,4\5 \6,721 4.7t2 60.224 13.538 33.219 Meters 100,000 68,\95 27.309 2,489 555 1,453 Hydrants Wacehouse 58,277 12,718 15,402 13,682 4,883 11.593 Billing & Colle<:ting 286,211 239,488 46,553 28 57 85 Debt Service Supply 325,925 71,128 86,137 76,517 27,309 64.834 Production Base 567,939 \23,944 150,097 133,335 47.587 112,976 Max Day 373,579 48,644 13,709 \75,203 39,384 96,640 Dis!.<8" Base 401,754 181,706 220.047 M..Day 264,266 206,166 58,100 Trans. 8"t024" B,.. 103,309 46,725 56,584 M.. Day 67,955 53,015 \4.940 Trans. > 24" Base \46,848 32,047 38,8\0 34,476 12,304 29,21 t Max Day 96,594 12,578 3,545 45,301 10,183 24,988 Billing & Collection 1,752 \,466 285 0 0 \ Subtotal 6,202,781 2,103.793 1,627,466 1.219,526 368,359 883,636 Administration Fees 640,3\3 217,\75 \68,003 125.892 38.026 9\,2\8 Total Revenue Requirement 6,843,094 2.320,968 \.795,470 \,345,417 406,385 974,854 Page \ of2 Total Residential Commercial Campbell Soup Tenaska 111 LCWSD Base 4.704,311 1,344,568 1.533,283 838.769 292,448 695.243 Max Day 1,750,820 667.251 188,039 504,131 113,325 278.073 Customer 387,962 309.148 74,147 2,518 611 1,538 6,843.094 2,320.968 1,795,470 1.345,417 406,385 974.854 Base Revenue OtTsets Water Taps 20,000 5,716 6,519 3.566 1,243 2,956 Misc. Water & Sewer Bulk Water Sales 10,000 2,858 3,259 1,783 622 1,478 Service Charges 35.000 10,004 11,408 6,240 2,176 5,173 Water and Sewer Charge OtTs (30,000) (8,574) (9,778) (5,349) (1,865) (4,434) rnterest Earned 40,000 11,433 13.037 7,132 2,487 5,912 75,000 21,436 24,445 13.372 4,662 11,084 Customer Revenue OtTsets Sanitation Billing Fee 37,193 29.637 7,108 241 59 147 Water and Sewer Returned Checks 3.450 2,749 659 22 5 14 Water and Sewer Copies 43 34 8 0 0 0 Contract Customer Billing 40,685 32,420 7.776 264 64 161 Florida Power & Lieht Base 189,779 54,242 61.855 33,837 11,798 28,047 Extra 71,775 27,354 7.709 20,667 4,646 11,400 Customer 14,237 11,345 2,721 92 22 56 275,791 92.940 72,285 54,596 16,466 39.503 Total Residential Commmial Campbell Soup Tenaska 111 LCWSD Base 4,439,532 1,268,890 1,446,983 791.559 275,988 656.111 Max Day 1,679.045 639.897 180,331 483,464 108,680 266,674 Customer 333,041 265,384 63.651 2,161 525 r,320 6,451,618 2,174,171 1,690,964 1,277,184 385,193 924.105 Contract Revenue OtTsets Residential Commercial MJC,WSC $ 25,787 $ 20,056 Campbell Soup (36,841) (28,653) Tenaska 111 (11,760) (9,147) Lamar County (143,881) (111.904) Total Contract Revenue OtTsets (166,696) $ (129,648) Total Residential Comme.-cial Base 2.941,967 1.379,703 1,562,264 Max Day 890,477 695,780 194.698 Customer 329.035 265,384 63,651 4,161,479 2,340,867 1,820,612 Page20f2 TABLE C-4 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY PROPOSED WATER RATES PROPOSED WATER RATES RESIDEI'òTlAL RATES Base Charge (Cubic Foot) Residential 3/4" Meter or Less Residential I" Meter or Greater COMMERCIAL RATES $7.00 for firs! 200 34.00 for first 1,000 Base Charge (Cubic Foot) Commercial 3/4" Meter or Less Commercial I" to 2" Meter Commercial 3" Meter Commercial 4" Meter Commercial 6" Meter CommercialS" Meter or Greater $8.50 34.00 120.00 2.000.00 3,000.00 4,000.00 for flfs! 200 for first 1,000 for flfSt 3,000 for flfs! 100,000 forflfSt 150,000 for first 200,000 CURRENT WATER RATES RESIDEI'òTIAL RATES Base Charge (Cubic Foot) Residential 3/4" Meter or Less Residential I" Meter or Greater COMMERCIAL RATES $5.9t for firs! 200 29.57 for first t.OOo Base Charge (Cubic Foot) Commercial 3/4" Meter or Less Commercial r" to 2" Meter Commercial 3" Meter Commercial 4" Meter Commercial 6" Meter CommercialS" Meter or Greater 56.99 29.57 106.91 1,600.00 2.375.00 3,150.00 for flfs! 200 for first 1,000 for first 3,000 for firs! 100,000 for first 150,000 for first 200,000 Page I of I Volumetric Rate (Cubic Foot) $2.45 perCCFaboveBaseVolume $2.45 per CCF above Base Volume Volumetric Rate (Cubic Foot) $2.45 per CCF above Base Volume $2.00 per CCF above Base Volume $2.00 per CCF above Base Volume $2.00 perCCFaboveBaseVolume $2.00 per CCF above Base Volume $2.00 per CCF above Base Volume Volumetric Rate (Cubic Foot) $2.15 per CCF above Base Volume $2.15 per CCF above Base Volume Volumetric Rate (Cubic Foot) $2.15 per CCF above Base Volume $\.70 per CCF above Base Volume $\.70 perCCF above Base Volume $\.70 per CCF above Base Volume $\.70 per CCF above Base Volume $1.70 perCCF above Base Volume c",yom,"s WATER ANI) WASTEWATER COST 0' SERVlC' ST1Jt)Y FlOW.OOO TSS """"" COST A1.LOCATION "~AI""", 000' OODA"œ"" "" TSSAllœ"'" NIDAI'œ"'" 0._. C~~.C C~, ".", "'" "~,, "'" ,.", U", ,.,,' "" '" '.00% "'" 'U" I.'" "'" "" U", 'OS "" " '00% ,.'" ".," '.1" ""'ó "" u,,~ ,.. I."~ " '.00% '.'00 "'" ",.. "",. ,-'" U.,,~ "" "" " '00% I.'" "'" '" """. .00 U.,,~ '" I."~ " '00% """ "'" U.,,~ "'~ "'" "" ".," '" "'" 100 u,,~ ..,,~ , '00% "'" "'" u,,~ "'~ '00% """ "'" U"., .."" '.00% ".3'" ,",,"' '.'" ,., "'" '" "'" '" u,,~ " "'" , "'" 100 """ " ",,~ " u,,~ " ",.. , '00% '" "'" .. ""~ '" ""~ " "" , '00% '00 "'" "9 "'" " U.,,' '" "" , '00% " "'" " "", " "'" " '" , '.00% '" ".," " """. 32 "'" " ,.," , '.00% " """ U "'" , u.,,' " .'" , '.00% "'" ""., u,,~ I.'" '.00% "'" "'" U", I.'" "'" I.'" "'" ... "'" '" u", '" "" " "'" "" "'" SO, "'" ". u", '" "" " "'" '" """ .. "'" " u", " ..", , "'" m "'" '" "'" .. u", " "" , "'" ,so "'" '" "'" .. u.,,' " ,."" 3 '00% '" ,W" .. "'" " u", " "'" , '00% "'" "",. u", "" "'" "'" "'" U", I.'" '.00% 3.00' ..", ,SO "'" '" "'" .. u", "" 3 '.00% "",. ""., U".. "" "'" """ """. u", "" "'" " "'" " ".",. " u,,~ " '" , '.00% '" "'" .. "."", " "'" " "" , "'" 200 "'" '" "", " "'" '" "" , '.00% '.'00 """ ,.m ".".. .., u", '" "" " '.00% ,U" "'" u.,,~ "" '.00% "'" "'" U"., I.'" '.00% ',m 100 ,w" " ",,~ " u", "" I "'" """ ""~ u,,~ "" '00% "'" "",. "'" "" "'" '.'00 "'" I,m "'" ... u,,~ ..", " ,."" "'" "'" u"., "" "'" """ "'" u", ,."" ,."" "'" "'" u", "" "'" "'" "'.'" '.00% "'" "'" "'" 100"" ",.'" ..... '00% '.000'. '00% "'" 100"" "'" U"" '.00% '000' "'" "'" 100.00% 1<173 23.100 "'" '.00% '.00% "'" 100."" ",100 I.'" "'" '00% "'" ,."" 100."" I.'" ,."" '00% '00% '.00% 100"" ,."" "'" "'" "'" 100."" ,.", ,."" "'" '00% '.00% 100"" ,.", '.00% '00% "'" "'" 100"" '00% '.00% '00% "'" 100.00% ",3" ".'" "'" '.00% "'" ,."" 100"" ".'00 ".000 "'" '.00% "'" '.00% 100"" 2<000 .. "'" ,."" '00% "'" 100.00% " 1.'00 '00% '.00% '.00% '.00% 100.00% 1.'00 " '.00% '00% '00% "'" 100.00% " '" '00% '.00% '00% "'" '00,"" '" " '.00% '00% '00% "'" 100.00% " " "'" '.00% '00% '00% 100"" " "'" '00% '00% ,."" 10000% "'" "'" '00% "'" 10000% ".m 39.m """""",,"'" w...o... """"""'" ",.,.nos. "".....ri. ""......,.. Empl"" """..",,,.., I.. W.k.., c.m""",.. I.. "=..,.,w'C~.....,.. S..""",., SUBTOTAL """" o...S."". =S"'.d _V".I..O_"" _V"'d..o;l A '._.m' ,.... V"'d.. TO. ","""O_'s'" - c.mmu."'~.Td"'", """,_.A"'" T.."".",,- """.."",,",. ""',....W_..«. T"".S.T."'" SUBTOTAL ~;;::.;.=... SUBTOTAL .......... ,_"..AFlow, M....,T'......"",,, M_V"'d. """",.o.ohœ..., SUBTOTAL """"""" A","., SUBTOTAL """"" """..,.TooI."","", _V".I. SUBTOTAL TOTAL WARENO",' I """""--'" S.orion... ""d ,".n. TM".."'" Em,-"""""",~,,, Wœ"',C-""...... Uo=,..,...,c.m"".... "'~Im. S""".", ""'..ACd",'n SUBTOTAL """" O"'S."". -,. W",",_d _V".'œ.O""'" _V"'<I..Oi'A""".., _V".I..". _V".,..""" ......,O_.S'" M.O...d SUBTOTAL ",."" """""" c.,.ml",,",.Td_, c..",......., ,__,....", T,""'."",- ""'a."","';, ...,.;"... ",m"a,W"."'Oa T"".,.T.I,".'" C~.I~m SUBTOTAl ~,~:~;'~'¿,'::::"" ..". 0- I.'" 0.- 2."0 0.- 2" 0.- 2."0 0.- m 0- "'0 0.- 100 0.- ".000 0- ".m '.500 0.- . 000". . 0- . 0- . 0- . 0.- . 0.00% . 000% . 0.00% . 000% . 0.00% . 0- . 0.- . 0.- . 0- . 0.00% . 0.00% . 000% . 000% . 0.- . 000% 0.00% 000% 000% 000% 000% 000% 000% 0.00% 0.00% 100.00% 1.2" 100.00% I.'" 100.00% .", 100.00% 2" 100.00% ,",,0 '00.00% m '00.00% '" '00.00% 100 '0000% ".000 ".m 100- 1.500 '0000% 10000% '.500 100.00% 2.500 100- 200 100.00% 500 '00.00% 2.200 100.00% 2" '00.00% '00.00% '0000% '.000 '00.00% '" '00.00% ,.'" '0000% '00.00% '00.00% '0000% 100.00% 10000% 100- 10000% 10000% 10000% ""211 . 000% . 0.00% . 000% . 000% . 000% . 0.00". 000% 0.00% 000'. """""'" M..,..,T~'."",.~, "_.m '" ""0 M,. _V"",.a ".~.Dmh._I", M"._"A._.' """"""" ~:~~,,'- 2.500 000% 200 000". 500 0.00% 7.'00 000% 2" 0.00% . 000% . 000% "."0 '.000 0.00% '" 0.00% . 000% . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% . 0.- . 0.- . 0.00% . 000% . 0.00" . 000% 0.00% 0.00% 000% 0.00". 0.00% 000% 0.00% SUBTOTAL . 0.00% . 0.00% 0- 000% 0.00% . 000% 000% 000% 0.00% -- ".-p . 0.00" . 000% . 000% . 0.00% . 0.00% . 000% . 0.00% . 0.00". . 000% 0.00% 000% 0.00% """"'" '~loo,'T-a "",_.,.TooI..Eq",.- _V""'a c.,.ml"'~S,.- M',"m- TOTAL BlLLlNO. COLUmON """""-"" "',""W.... """"',,", TM"'_;~ 'm,'"",,_'",I~'~'.. W.'o'.C'"'_'~I.. "'-".,..., c.""".,.. D,,"w, Sm"',", ""'" om"s,..'. -" ,... W_,_d M_V"""a.O-'" M.. V"'.la.OII' "'bri,m' _V"'.la."a _V"'.la."'.la um""a..._". Cb_I,,'M""""" -"".'"..'. """""" C_u."',.Td_, "oom,,""" C_C_.S",I"""",,- T,..",."",- """a."""",, 'nI"'U,,- M'."",_. ",,",I...... ","".W_oa. T,.._,.T.".. SUBTOTAL' . 0.00% . 000% . 0.00% . 0.00% . 0.00% . 0.00% . 000% ""211 ",m 10000% ".,,' 10000% ".", 10000" ".'" 10000% 2.'" '0000'. 2.000 '00.00% "'.000 '0000" 2.'" '0000% . '0000% . '0000% '" 10000% 200 10000% "0 10000% 2.000 10000% ".000 '0000% 1.'00 '0000% 1.'00 '0000% '" 100.00% '.000 10000% '.000 10000% '00 10000% 10000% ".0" '000 '0000% '.000 '0000% . 10000% '" 10000% 2.'00 10000% 10000% 10000% '" 10000". I.'" '0000% 1.000 '0000% . '0000% 10000% "'00 . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% 0.00% 0.00% 000% 000% . 0.- . 0.00% . 0- 0"" 0.00% 000% 0.- 0.00% 0.00% 0.00% 000% 000" "'.m 0.00% ".,.. 000% ".", 000% ".'" 000% "'00 0.00% 2.000 000% ".000 000% 2.'" 000% . 000% 000% 000% . 000% . 0- 0.00% . 0.00'. . 000% . 000'. 000% 000% 0"" 0.00% 0.00% 0.00% 0.00% 000% 000% 0.00% 0.00% 0.00% 000'. 000% 000% . 0.00% . 0.00% . 0.00% 0.00% . 0.00% . 0.00% . 0.00% . 0.00% '" 0.00% 200 000% 2" 0.00% 2.000 000% ".000 000% 1.500 000% 1.300 0.00% 000 0.00% '.000 000% ',000 0.00% '00 0.00% . 000% "."0 0.00% 0.- . 0.00% . 000% . 000% . 0.00% . 000% . 0.00% . 000% . 0.00% . 0.- 0.00% 0.00% 0.00% 0.00% 0.00% 000% 0.00% 0.00% 000% 0.00% 000% 0.00% 0.00% . 0.00% . 0.00% . 0- . 0.00% . 0.00% . 000% . 0.00% . 0.00% . 000% . 0.00% . 0.00% . 0.00% 2.000 000% '.000 0.00% . 000% '" 0.00% 2.300 0.00% . 000% 0.00% '" 0.00% '-'" 0.00% 1.000 000% . 0.00% 000% . 000% 0.00% . 0- . 0- 0.- 0- 0.00% 000% 000% 000% 000% 0.00% 0.00% 000% 0.00% 0.00% 000% 0.- 0.00% 000% 000% 000% 000% 0.00% . 0.00% . 000% . 0.00% . 0.00% . 0.00% . 0.00% . 0.00% . 0.- . 0.00% . 0.00% . 0.00% . 000% ".'" ".."" M,"'m_,,""',n ""'p"""'" ...,..,- S,w""'""",. ""........,....,- ..... u.. ,,",,"M"". SU1ITOTAL ~.::':':',;::;~~mo M.hi,.,T,,"""..m' 1._no'.""",M"" """'V~"'. L_"""'Eq.'..n' EI.'n" Do" ""M., Ti....... """'-"I.Iwo l.d"noO~".,. ."'"", M",," '0"'" ~ Sn'..,- Mnh.. "",.... ,. ",""L.. S_MoO. ....... M.h...,.T,"",""..n' """'V~,.. SUBTOT"" ~ ....",W."""",n_'" TOTAL SlWER M'>NT'NANC' Ww.~,.. T'n'M" '""""'-Om ",.'dW... """S...- TMRS "."'n ,,",""'_"""""," W.....C~""W'n", Uow_noCom""..... "'...., S"hm_,., ""'" om",""". ""'" '"" W...,-" """'v~"'..o...,.. ",,",V",,',.O"""'.n' M_V~"'.",. M_V~',......... M'_App~.. "'_0""',,,. Ch""""M"",". M.On",' -,......,. ""..."',. Ph-"'.S."". ~ Com.u""n, ' T"_' I.M_""" c..n""",S.."""",'~ T.."""...~ "........ """""""'- """"""M M""""-. "'-i""'" """"'.W..'O. T".',.,T."'" T""'""""" SURTorAL. 100 '0000% 100 000% 0.00% 000% 0.00% ".000 10000% ".000 000% 000% 0.00% 000% "... 100.00% ,... 000% 0.00% 0.00% 000% ,... 100.00% '.000 0.00% 0.00% 0.00% 0.00% ,... 10000% ,... 0.00% 000% 000% 0."'" ... '00.00% ... '00% ,~. '00% '.00% '00.00% '00% 0.00% 0.00% 0.00% 100.00% 0.00% 000% 0.00% 0.00% ..."" ""00 000 10000% 100 0.00% 000% 0.00% 0.00% ".'00 100"'" ".'00 0.00% 0.00% 0.00% 0"'" '." ,OO~. "000 0.00% 000% 0.00% 000% ".. '00.00% ".000 """ o.~. 0.00% 0.00% "... '00.00% ".000 0.00% 0.00% 0.00% 0.00% '00 10000% '00 0.00% 000% 0.00% 0"'" '" 10000% '" 0.00% o~. 000% 0.00% '00.00% 000% 0.00% O.~, 000% ,,-'00 ..000 '0000% I." 0.00% 000% 000% 000% ,... '00.00% 2." 0.00% 0"". 0."'" 0.00% 2." 000.00% ,... 000% 000% 0.00% 0.00% '0000% 0.00% ,~. '00% 0"'" "... '0000% "... 0.00% ,."". '00% 0.00% ".000 100.00% "." 0.00% '00% 0."'" 000% 100.00% 0"'" 0"'" 000% 000% 10000% 0.00% '00% 0.00% 000% 10000% 0.00% 000% 0"'" 0.00% ".'00 100.00% ""'" 0.00% 0.00% 0.00% 000% '00.00% 0.00% 0.00% 000% 0.00% 10000% 0.00% 0.00% 000% 0.00% '00.00% 0.00% 000% 000% 0.00% "'00 ".'00 '0000% 000% o.~. '.00% 000% '0000% 000% 0.00% '.00% 0.00% 00000% 0.00% '00% o~. 0.00% ",.'" """ ",.,,' "..... ",.,,' "'" ",."" """ ".'" """ ".m """ ".'" "..... ".," """ ".," """ I.'" 000% """ """ ".m ".,," ".", """ ".'" "'" ,.," '.00% ",... """ ".'" """ 'W. ".,," ".'" "'" ,.," 0.00% ".m """ ,.,,' """ '."0 ""'" ,.," "'" '" 0"'" ,... """ "0 ".,," '.'" ""'" '" "'" " 0.00% "... """ '.m """ ,.", ""'" "" ,.,ow. '" 0"'" ,.," """ ,.m ".,," '.'" """ I.'" ,.,'" '" 0"'" """ """ """ "'" 000% ,,"" """ """ "'" 000% ","" '00.'" "'.,,' '.'00 """ '.0" ...... '.m """ ..,.. "'" 0" 000% ,.'" "."" '" ...... '" """ '" "'" " """ ". "."" 0" ...... '" """ D' "'" " 0.00% .,00 """ ,.m ".... ,.,,' """ '.m "'" m 000% "." """ '.'" ....... '.'" ""'" ,.", "'" m 0"'" '00 """ '" ....... '"~ """ '" "'" " 0.00% "'00 """ '" ".,," '" """ ... "'" " 0"'" ,.. """ " ".,'" ", "'" " "'" , 0"'" '." """ ..... ".,'" ,.m ""'" 2.'" ,.,'" ,.. '00% '."0 """ ,.. "."" I.'" "'" ... '.1'" " 000% ".000 """ ".", ...... ".", """ "".. "'" ,.," 000% ,... "."" "0 ..,'" ... "'" '" "'" " 0."'" "0 """ '" ".... '" """ ,~ ,.,'" " 000% "0 """ '" ...... '" """ ,~ "'" " 0"'" '" """ lIS ...... m """ "0 "'" " 0"'" """ ...... """ '.1'" 0.00% """ ".,," """ "'" 000% "'.,.. '2.1" >.000 """ '" ".,'" '.'" """ '" ,.,'" " 000% '."" """ ,.". ".... .", """ ,.," "'" '" 0."'" "."" ".... ""'" "'" 0."'" ,... """ "0 ...... ... """ '" ,.,'" " 000% '00 """ '" ...... '" ""'" D' "'" " 0.00% m." """ ".m """ """ ,,"" ".m "'" ,.'" 0."" '" """ " ...... '" ".,," " '.'.'. , 0."'" ,... """ 7.'" ...... ",m """ '.'" ,.,'" '" 000% J." ""'" "0 ....... I.'" """, '" "'" " 0"" '."" "'."" >T' ".,'" I.m ""'" 702 "'" " 000% """ """ ,.,,' ".11" '.m ",,% I.'" "'" '" 0.00% "000 """ '.'" .."" '.'" ",,% J.'" "'" '" 0.00% """ "."" """ '.1'" 000% """ ".,'" """ "'" 000% ".", "'.'" 7,œ' "ph" ~t:~;;o~:'n "",.AC,I- FI".""AV".. S"~.lbA"""" S"~A""n_. """"'........."." ".., A "-.... ..... u.. H"'~.AV,,- ""'..SI",o"'~" ",_.,.LM4fi"F~ JI.OOO "... "01 49.61% ".201 ""'4 1.441 21~' '" 0.00% m """ " ..."" '" 2"", .. 2.1'" S 000% ",., """ I.'" .."" S."" "'.. 2.M' "'" '" 0.00% .., """ "s ..."" '" """ D' 2'"" II 0.00% 0.0" """ I.'" ..."" '.m ",m U" "'" '" 0.00% "0 "."" " ..."" '" ",.. .. ,."". S 000% 210 """ " """ '" 2"", .. 21'" S 000% 1.210 """ 2" 49."" 621 "'.. '" U.' 26 0.00% 11000 """ ,.'" 49."" ,.", 2"" .'" 2.1.' ". 0.00% ".000 """ 2.S" 49.'" S."2 2",' "'" 21'" 2S2 0.00% ,.soo """ I.'" ".'1% ,.m 21'" '-'IS U"" '" 0.00% """ ...., 212S' 2.'.. 000% 20"" ...." 2"", 21"" 000% '.000 """ 020 ....." '" 2"" S" "., 02 000'4 'o.soo 20"" 1M" ....." 21.'" 21"" D.'" 21.. 1.001 000'4 moo 20."" .,n ....." ".1" 2"", .,SO U.' .., 0.00'4 "00 20"'4 I.'" ...,'" W. "", I.no '.'.4 '" 000% SOO """ '" ..,'" ,SO "", D' ".. II 000% '.'00 20."" OS, ....., I.OS' 212S' '~ U"" " 0.00% 12.000 20"" ".IIS ..."" ".no 212S' "... U.' I.'" 0.00% 1.100 20"" '" ..,'" 70S 2"" '" 2.1.' " 000% '00 20."" "S ...S'" '" 212S' '" U.' D 000% 100 "... " "'1% " "'S% 21 '.10'. , 0.00% """ ....., "',., '.1.. 0.00% "... ..,'" 212S' ".. 000% ".", '.soo """ I.'" ,"'" '.m "", "" 2.10', '" 000% "... ...,'" "'S% 2.1"" 000% "."'. ..,'" 212S' ".. 0.00% '.m "IS ".000 "... ..." ..,'" II.'" """ "SS 2'"" '" 000% ..... ".... I.'" ....., ,.", 2",,' I.'" 2.'"" '" 0.00% '.000 ".... I.'" ...., ,.'" 2",' W' '.1"" '" 0.00% ".... ..,'" "'S% U'" 000% ,".000 """ ,.," ....., ".on 2S2S' 21'" ... 0.00% ""'4 "'1% 212S' """ 000% ,...., 21.'" "'.'" m.II' "'.'" """ ",.", 100.00" ",.", 0.00% MOO'. 0.""". 0.00% ,.'" 100.0000 ,.'" 000% 0.00'4 0.00% 0.00% II.'" '00.00'4 II.'" 000% 0.00% 000% 0.00% "'00 100.00% "'00 000% 0.00% 000'4 0.00% I.SSS 100.00% ,.m 000% 0.00% 0.00% 0.00% '.000 100.00% 1.000 000% 0.00% 000% 0.00% ".000 10000'4 ".000 0.00% 000% 0.00% 000% 1.'00 100""". ,",00 0.00% 000% 0.00'4 000% 100.00% 000% 0.00% 000% 0.00% '0000% 0.00% 0.00% 000% IS'.'" '" 100""". '00 0.00% 000% 0.00% 0.00% ISO 10000% ISO 0.00% 000% 0.00% 0.00% " 100.00% " 000% 0.00% 0.00% 0.00% 1.'00 10000% 1.'00 0.00% 0.00% 000% 0.00% '.000 10000% '.000 000% 0.00% 000'4 000% '" 10000% '" 0.00% 000% 0.00% 0.00% 000 10000% 000 000% 0.00% 000% 000% ISO 10000% ISO 0.00% 000% 0.00% 0.00% 210 100.00% 210 000% 0.00% 0.00% 000% '00 10000% '00 0.00% 0.00% 000% 000% IS.'SO 10000% IS."O 0.00% 000% 0.00% 0.00% 100 10000% 100 0.00% 0.00% 000% 0.00% '00 10000% 100 0.00% 000% 000% 000% 100 10000% 100 0.00% 0.00% 000% 000% 100 100.00% 100 000% 0.00% 0.00% 0.00% '00.00% 0.00% 000% 0.00% 0.00% '00.00' 0.00% 000% 0.00'4 0.00% '.2" 10000% ,.", 0.00% 0.00% 0.00% 0.00% 10000% 0.00% 0.00% 0.00% 000% ,.soo 10000% ,.soo 000% 0.00% 0.00% 0.00% SOO 10000% soo 000% 0.00% 0.00% 000% soo 100.00% SOO 0.00% 000% 0.00% 0.00% 10.000 100.00% 10,000 000% 0.00% 0.00% 000% ISO 10000% ISO 0.00% 000% 000% 0.00% I.SOO 10000% I.SOO 0.00% 000% 000% 0.00% '00 100.00% '00 000% 0.00% 0.00% 0.00% "'" 100.00% I.SOO 000% 0.00% 000% 0.00% 'SO 100.00% "0 0.00% 0.00% 0.00% 0.00% '00 10000% '00 0.00% 000% 0.00% 0.00% 100.00% 000% 0.00% 000% 0.00% 10000% 0.00% 000% 000% 0.00% 96,2SO ~:::,::~~O~:;~=D' ".'."'~.""pmD' I,_DO '0. "'. ",I", """""kl. "'.dl~_,.""" '~o""ol.".lpmD' .......,....... EI._Io "'" ,.~I" ",'"'n~"^,,~D' TO._, ~ "",,, ....... ""'.""".","nl ._moA_~ ","",V"'<I. Cpm.dl..,.. S,.= M"p '",'W~o."""n'_.' """"""" """nOW... Sod.._. '""Um,'" Em,_"""""""~",, W«"",C~........., U"~p"'m' Com........ 00-'.. So,;""" """" om.. So,,". ::;,. w~,.,_. """,V~"'n.e...... """'V~"'m.O"""';~' """,V"""m.TO" """,V~"'m"",.I. "--,,. "_a_I,,,. a.~InI""""m ""'~k,I "'.'o.S"",'m "".S.,,"n _...ks.ppJlm .....- Commuk""",,_, c.",....... '.Md'" ...... """-~ ".kod~, "mlln.EI""',;" F"""',.- ",.dl~- "-,...., W""m.W...e. ,....,.T."... '~""'.'" ......rs "."a..~."i.i.n """.p""""'" '"...,c...... fil~"'OV..- .....,..,.,... -...... "'~U,.,..,... "..., ".. .... .,.,....>v..- SO_-,. uod'" F- lo.cOO 100.00% .... 000% 0.00% 0.00% 000% '" 100.00% '00 0"'" 0.00% 000% 0.00% '" '00.00% '00 000% 0.00% 000% 000% ,.. 10000% '00 0"'" 0.00% 0.00% 0.00% '00 10000% '" 000% 0.00% 000% 0"'" '00 100.00% '" 000% 0.00% """ 0"'" '00 100.00% '" 0"'" 0.00% '00% 0.00% ,... 10000% ,,"00 0."'" 0.00% 000% 0."'" '." 10000% ,... 000% 0."'" 0"'" 000% 10000% 0.00% 0"'" 000% 0.00% '00.00% 0.00% 0."'" 000% 000% "0 100"'" '" 0.00% 000% 0"'" 0"'" 9.000 10000% ,... 0."'" 000% 0.... O- J." 100."'" ,... 0"'" 0.00% 0"'" 0."', 2." 100"'" 2." 0."'" 0 OW. 0.00% 0"'" '50 100"'" no 0."'" 0.00% 0"'" 0.00% ".'00 100."'" ".'" 0"'" 000% 0.00% 0.00% '50 '0000% "0 0."'" 0.00% 0"'" " '0000% " 0.... 0.00% 000% 000% '00"'" 0."'" """ 000% 000% 100"'" 0.00% 0000. 0"'" 0"'" 32.'" ,.~ '0000% ,~ 000% 0."'" 'ow. 0."'" 10000% 000% 0"'" """ 0."'" 10000% 0.000. 0.00% 'ow. 0.00% .~ 100.00% '.~ 0.00% 000% 000% 0."'" 10000% 000% 000% 000% 0.00% 10000% 0.00% 0."'" 0.00% '.00% ,.~ 10000% ,.~ 000% 0.00% 0.00% 0.00% 100"'" 000% 0.00% 0.00% 0.00% ~:i:~'F¡:;~_m' ".a..,Too. ""i",a' _~ma."'."'_M,"" _V".I. """""".".¡",a' """n""" "=ooi. Do. h__'" "...,.. SUBTOTAl.. """"""'" A.""" ""- ,,_V".,- .._a.'A_"u c...moo""",S,,,- """'p Swo4pi",......... SUBTOTAl. TOTAl. U""TATOON O........~ 0"" Ca",..."'"., 0..... ........ M."'fI- """""""""'" "."'Adm",..",.. T...O....Ca",.,.."""""". I.",.m ".'0% '.""'" ".,.. m.m """ "'.'" II.'" 0"" J.'" ""'" 10000% ""'" 000% 0.00% 0.00% 000% m.", 10000% m.", 0."'" 0"'" 000% 0.00% I."'~" ....." ...." 11.'00 '00"'" II.'" 000% 000% 0.00% 0"'" '0000% 0.00% 0.00% 000% 000% ".", 000% 0.00% 0.00% 0.00% '00"'" ".1" ".~ '0000% ".~ 000% 0.00% 0.00% 0.00% ".~ '0000% ".~ 000% 0.00% 000% 0.00% "O.~' 10000% (,.~) 000% 000% 0.... 0.00% '"'" 000% 0"'" 0"'" 0."'" 10000% '.'" " 000% 0."'" 0."'" 0.00% 100.00% " ".~ 100.00% ".~ 0.00% 0.00% 000% 0.00% 10000% 0"'" 0.00% 000% 000% "'.'00 ".'" ",.," "... ".,oo .."" ",.," ,1.33" ""0 210% ".. 000% nom 10000% "'.m 0"'" 0.00% 000% 0.00% II.m "... ,.m ,..", '.1" """ '.m >.10% ,OJ 000% ,WO 000% 000% 000% '.00% 100.00% 13.2" "..... "'.UT 110.'" "-'" .""" ."'.... I.""'" "'.'" ...'" ""0" TOTAl..EaTS"',C, "",F__a"F' Adm.,..",..F- ....T'n Mi.. W"""dS~. Smi.;oo~",",F~ _.aw.. .... """.'S F- W".mdS~.Cb...O'" W".""".""odCb." W"""dS_C"i. "'.~E_od Cooo., C_. ~"" SUBTOTAl.. T.""""""'~' T..............I,,_" ....'", TABLE C-6 CITY OF PARIS WATER AND WASTEWATER COST OF SERVICE STUDY PROPOSED WASTEWATER RATES EXCESS CHARGE BOD Revenue Requirement BODtbs. BOD Rate $ 1,058,362 1,628,146 0.65 Per lb. above 250 mWl 580,098 1.727.729 0.34 Per lb. above 250 mWl 44,736 94,728 0.47 Per lb. above 30 mWl TSS Revenue Requirement TSStbs. TSS Rate NH3 Revenue Requirement NH31bs. NH3 Rate PROPOSED WASTEWATER RATES RESIDENTIAL RATES Base Charge (Cubic Foot) Volumetric Rate (Cubic Foot) Residential 3/4" Meter or Less Residential I" Meter or Greater $7.50 for first 200 36.00 for first 1,000 $3.25 per CCF above Base Volume $3.25 per CCF above Base Volume COMMERCIAL RATES Base Charge (Cubic Foot) Volumetric Rate (Cubic Foot) Commercial 3/4" Meter or Less Commercial I" to 2" Meter Commercial Larger than 2" Meter $10.50 forfirst200 36.00 for first 1,000 62.00 for first 2,000 $3.40 per CCF above Base Volume $3.40 per CCF above Base Volume $3.40 per CCF above Base Volume CURRENT WASTEWATER RATES RESIDENTIAL RATES Base Charge (Cubic Foot) Volumetric Rate (Cubic Foot) Residential 3/4" Meter or Less Residential I" Meter or Greater $6.31 forfirst200 34.89 for first 1,000 $3.10 perCCFaboveBaseVolume $3.10 perCCFaboveBaseVolume COMMERCIAL RATES Base Charge (Cubic Foot) Volumetric Rate (Cubic Foot) Commercial 3/4" Meter or Less Commercial I" to 2" Meter Commercial Larger than 2" Meter $9.39 for first 200 29.07 for first 1,000 54.74 forfirst2,ooO $3.27 per CCF above Base Volume $3.27 per CCF above Base Volume $3.27 per CCF above Base Volume Page lofl