Loading...
HomeMy WebLinkAboutPackets - Council Packets (1615) AGENDA ORO VALLEY TOWN COUNCIL AND ORO VALLEY WATER UTILITY COMMISSION JOINT STUDY SESSION JUNE 18, 1998 Oro Valley Town Council Chambers 11,000 N. La Canada Drive STUDY SESSION - At or after 6:00 p.m. CALL TO ORDER ROLL CALL 1. Review and discussion of proposed Development Agreement with Canada Hills Homeowners Association regarding the enforcement of traffic laws on private streets 2. Discussion with Water Utility Commission regarding April 1998 Water Report and associated recommendations Adjournment The Town of Oro Valley complies with the Americans with Disabilities Act (ADA). If any person with a disability needs any type of accommodation, please notify Kathryn Cuvelier, Town Clerk, at 297-2591. Posted: 06/12/98 12:00 noon sr TOWN OF ORO VALLEY COUNCIL COMMUNICATION MEETING DATE: June 18,1998 TO: HONORABLE MAYOR & COUNCIL FROM: David G. Hook, P.E., Town Engineer Werner Wolff, Chief of Police SUBJECT: Proposed Development Agreement With Canada Hills Master Community Association SUMMARY: Over the years, the Oro Valley Police Department (OVPD) has received complaints from citizens of the Canada Hills community regarding traffic violations occurring within the various neighborhoods. Because the streets are `private', not `public', the OVPD has been unable to enforce state and local traffic laws in these neighborhoods with the exception of reckless driving and drunk driving. As a result of the complaints, the OVPD and the Canada Hills Community Association (Association) have researched the nature of the complaints and found that the most numerous problem appears to be speeding. In some areas, it has been confirmed that the 25 MPH speed limit is consistently ignored by the motoring public, with the average speed at approximately 30 MPH and the 85`h percentile at approximately 35 MPH. Recently, the state legislature has passed a law, codified as ARS Section 9-500.05, that would permit the Town to enter into a Development Agreement for the purposes of enforcing traffic laws. Town staff has been approached by agents of the Association regarding the possibility of the Town and the Association entering into such an agreement. Town staff and the Association's agents have discussed the issues on several occasions. Tobin Sidles, Town Attorney, has drafted the attached draft Development Agreement (Agreement) based on those conversations. The essence of the Agreement is as follows: ➢ Regarding the Town: • OVPD will patrol the private streets that are not gated. • OVPD will provide traffic/emergency vehicle enforcement on the private streets that are not gated. • The DPW will evaluate and advise the Town Council on the appropriate traffic issues and regulations. • The Town Council will, upon the advise of the DPW, enact regulations for the OVPD to enforce. • The DPW will install the appropriate traffic control (signage, striping and painting) necessary for the regulations enacted by the Town Council. • The DPW will invoice the Association for the costs (labor, material and equipment) for the traffic control measures referenced above. • The Town will not be responsible for street maintenance of the private streets. TOWN OF ORO VALLEY COUNCIL COMMUNICATION PAGE 2 OF 2 ➢ Regarding the Association: • The Association grants the Town permission to do the above referenced evaluation, enactment, installation and enforcement. • The Association will reimburse the Town for the costs of DPW's traffic control measures. • The Association indemnifies the Town for all liability for the actions of the town when implementing the agreement. ➢ General: • Streets that are currently `private' can become `public' streets if the provisions of the Town Code regarding doing so are followed. • If any streets that are currently `private' become `public', the agreement will not apply to those streets. • The Agreement is for a one year period, automatically renewed upon the adoption of the new FY budget, unless canceled by either the Town and the Association with 90 days notice • The agreement does not change densities and uses from the status quo. • Future rezonings will be considered in light of the policies in force at the time of the rezoning. ATTACHMENTS: Draft Development Agreement FISCAL IMPACT: The fiscal impact to the DPW would be a net of zero since the costs of signage, striping and painting would be reimbursed to the Town by the Association. RECOMMENDATIONS OF STAFF: The staff of both the OVPD and the DPW support the favorable consideration of the Development Agreement as presented. SUGGESTED MOTION: None required. e- Tow Engineer ie/Poli e Town Manag- AFT D:. DEVELOPMENT AGREEMENT This DEVELOPMENT AGREEMENT (the "agreement") dated this day of , 1998, by and between the Town of Oro Valley, Arizona, an Arizona Municipal corporation, and the Canada Hills Master Homeowners Association and all sub-associations of Canada Hills or its successor in interest, located at (Legal description) . This agreement shall cover those areas marked as outlined in the attached Exhibit "B" RECITALS WHEREAS, this agreement shall be adopted by the passage of a resolution at a public meeting of the Mayor and Town Council of the Town of Oro Valley, Arizona, authorizing its designated signatory below to enter into such an agreement on behalf of the Town, consistent with the mutual promises, covenants and acknowledgements agreed to by the Mayor and Town Council: WHEREAS, the master homeowners association would like to permit the Town to enforce traffic and fire laws within their subdivisions and on their private streets; and WHEREAS, the Town has the responsibility of providing for the public health, safety and welfare; and WHEREAS, the Town and Canada Hills areauthorized to enter into this agreement pursuant to the provisions of A.R.S. Section 9-500.05 NOW THEREFORE, in consideration of the promises, mutual covenants and agreements as set forth herein, the parties agree as follows: 1) MUTUAL PROMISES The Town agrees that: The Oro Valley Police Department as part of their normal operations will patrol the property, including private streets. The Town will provide traffic/emergency vehicle enforcement in accordance with established policies and budgetary considerations. The Town will not provide enforcement for gated streets. The Town reserves the right through the Town Engineer to determine the appropriate speed limits and other traffic provisions for this area in accordance with the Town Code and all other applicable laws. The Town will not provide maintenance of the pavement nor deal with other non-traffic issues. D..„ AFT Canada Hills agrees that: The Town may enforce all criminal traffic, civil, Town Code and other statutes or documents relating to the areas of traffic/emergency vehicle enforcement for public safety P rP u oses on the private streets, rights-of-way, etc. in the areas of traffic enforcement and weight restrictions, excluding parking except as it relates to emergency vehicles. The association agrees, on behalf of all the residents, to waive any g Y claims, including claims of jurisdiction, to follow the laws, policies and procedures of the federal government, the State of Arizona and the Town of Oro Valley for these areas. The Master Association, the residents and any sub-associations, either jointly or severally, agree to pay for the costs of purchasing and installing whatever traffic signage, striping and painting is deemed necessary. All appropriate signage is to be determined by the Town Engineer or his/her designee according to generally accepted engineering and traffic standards. The Town agrees to install and maintain all such � g signage e with the costs of installation and replacement to be reimbursed by the � Association(s) to the Town. The Association(s) also agree to assume and indemnify the Town for all liability for the actions of the Town in enforcing these provisions. In the event it is desired that any private roadways become public; the provisions of the Town Code must be followed. Should any private streets become public, the terms of this agreement are declared null and void as to those streets. 2) TERM The parties agree that this agreement shall run in one-year terms, to be automatically continued and renewed every Town fiscal year upon adoption of the Town budget unless cancelled at the behest of either party upon ninety (90) days notice. g Notice shall be given in writing, sent by regular mail with the 90-day period to commence upon the date of the mailing. Notice to the Town shall be sent to the attention of the Town Manager, with a copy to the police department and the public works departments. Notice to the Association shall be sent to the attention of the Master Association. Upon termination, all unreimbursed signage shall become the property of the Town. 3) IMPACT ON DENSITIES AND USES TheP arties acknowledge that this agreement does not create densities and uses greater than those currently enjoyed. kA:, , F 4) FUTURE REZONINGS Anyfuture rezoningwill have to be accomplished according to the existing policies of the Town of Oro Valley at the time the question is raised. 5) SEVERABILITY, INTERPRETATION OF TERMS, CHOICE OF LAW This agreement shall be construed in all instances when possible to do so in such a fashion as will allow thearties to comply with all applicable federal, state, and P local laws and regulations in accomplishing the purposes of this agreement. Should anyportion of this agreement be found to be invalid for whatever reason by a court of jurisdiction,com etent such portion shall be severable and have no effect on the competent remaining piof the agreement. If any matter should end up n court, the winningpartyis entitled to reasonable attorney's fees. This agreement will be enforced under the laws of the State of Arizona. By: , on this day of , 1998; acting on behalf of the Canada Hills Master Homeowners Association and all residents of the sub-associations which have signed the attached request listed as Exhibit "A" (attached hereto). FOR THE TOWN COUNCIL OF THE TOWN OF ORO VALLEY Mayor ATTEST: Kathryn Cuvelier, Town Clerk APPROVED AS TO FORM: Tobin Sidles, Town Attorney . TOWN OF ORO VALLEY COUNCIL COMMUNICATION MEETING DATE: June 18, 1998 TO: HONORABLE MAYOR & COUNCIL FROM: Shirley Seng Utility Administrator SUBJECT: Water Utility Commission 1998 Annual Report SUMMARY: The Oro Valley Water Utility Commission (Commission) was established in 1996. The Commission's function is to act as an official advisory body to the Town Council on the utility's capital improvements program planning and rate structure formulation. Pursuant to the Water Code, the Commission must render its Annual Report to the Town Council with their recommendations for the upcoming year. The 1998 Annual Report contains recommendations for fiscal year 1998/99 on the following topics: • Water Rates • Financial Criteria • Department Structure • Alternative Water Resources • Master Planning Reports • Oro Valley Water Improvement District#1 • Tucson Water system within Oro Valley A copy of the Executive Summary has been attached for quick reference. Greater detail on each recommendation is presented in the body of the Annual Report. In preparation of the Annual Report, the Commission's finance subcommittee spent considerable time analyzing financial scenarios prepared by a rate consultant, Mr. Ron Kozoman. Mr. Kozoman will be present at the study session to explain and answer questions pertaining to the proposed rate structures. The Annual Report contains a "Preferred Financial Scenario" that would increase revenue by 5.50% for fiscal year 98/99. This would be accomplished by increasing the typical residential customer's base rate by 10 cents, increasing the commodity rate by 2 cents per 1,000 gallons and decreasing the amount of water included in the base rate from 2,000 gallons to 1,000 gallons. The Town Manager has proposed a different financial scenario that would provide for a 4.60% increase in both the base rate and the commodity rate leaving the amount of water included in the base rate at 2,000 gallons. Staff's review of the Town Manager's proposal indicates that it meets the same financial criteria as the "Preferred Financial Scenario" recommended in the Annual Report. Tables for both financial scenarios have been attached for quick reference. TOWN OF ORO VALLEY COUNCIL COMMUNICATION PAGE 2 OF 2 ATTACHMENTS: Executive Summary of the 1998 Water Utility Commission Annual Report. Table for "Preferred Financial Scenario" as recommended in the Annual Report. Table for the financial scenario proposed by the Town Manager. FISCAL IMPACT: It is the intent of staff to work toward a budget where revenues and expenses are balanced and meet appropriate financial criteria while maintaining an enterprise fund without receiving outside subsidies. COMMISSION RECOMMENDATION: The Oro Valley Water Utility Commission respectfully recommends approval of the recommendations presented in their 1998 Annual Report. STAFF RECOMMENDATION: Staff concurs with the Commission's recommendation above and further recommends that the Town Council provide staff with direction regarding implement. ion on each recommendation presented in the Annual Report. r II 1\1 \ Utility Administ.ator Utility Director Town Manag-r EXECUTIVE SUMMARY TOWN OF ORO VALLEY WATER UTILITY COMMISSION ANNUAL REPORT APRIL 1998 INTRODUCTION In October, 1996 the Oro Valley Town Council (Council) formed the Oro Valley Water Utility Commission (Commission) to act as the official advisory body to the Council regarding water related issues. The functions and duties of the seven member commission include reviewing and developing recommendations for water revenue requirements, water rate and fee structures, and water system capital improvement planning. The Commission is required to prepare an annual report to the Council regarding its recommendations. This report is the Commission's second Annual Report. It includes recommendations related to financial criteria, revenue requirements, system operations and maintenance requirements, debt service requirements, a five year capital improvements plan, possible rate adjustments, alternative water supply options, system expansion and future organizational structures. This Executive Summary contains a briefing on the implementation of the recommendations presented in the 1997 Annual Report. It also contains a briefing on new recommendations specific to water issues facing the Town in FY 1998/99. Explanations and financial analyses that are more detailed may be found in the body of the report. The main body of the report presents details related to the Commission's preferred scenario. For comparison purposes, a section describing other alternatives is presented at the end of the report. IMPLEMENTATION OF THE 1997 REPORT RECOMMENDATIONS • Water Rates: A 3% across the board rate increase for all customer classes was recommended by the Commission to the Town Council. The Town Council implemented an adjustment to the minimum monthly rates and the commodity rate for the customers of the Rancho Vistoso system, equalizing all rates for customers in both systems, except for the `city' customers whose rates were adjusted with the phase-in formula established by Council at the time of purchasing the two former private utilities. • Consolidation of Water Operations: The Commission recommended that the operations of both systems (CH & RV)be consolidated to take advantage of economies of scale in both - 1 - field operations and administration. The Town Council approved a consolidated budget for p the FY 1997/98. The two billing systems have been consolidated and a new full-page bill format with return envelopes has been implemented. The physical interconnects are scheduled to begin this fiscal year and will be completed in FY 98/99. • Rancho Vistoso Depreciation Expense: The Commission recommended that the Town update and perform long range financial projections to ensure the timely recovery of depreciation and continued system reliability and capacity. Those projections are incorporated into the 1998 Annual Report and allow for the full recovery of depreciation for the entire system. • Alternative Water Resources: The Commission presented three recommendations to the Town Council involving alternative water issues: (1) Phased in use of reclaimed water to irrigate golf courses; (2) continue joint planning with neighboring jurisdictions and other water agencies; and (3) purchase incentive priced CAP water. Efforts to address all three have begun and continued during the year. • Master Planning Reports: The Commission recommended that the Master Planning Reports be updated. A proposal from a consultant has been received and is under evaluation by staff. NEW RECOMMENDATIONS FOR FY 1998/99 • Water Rates: The Commission recommends a 5.50%revenue increase for FY 98/99. The proposed revenue increase would allow the utility enterprise fund to meet sound financial criteria regarding the operations of a municipal utility while costs keep pace with inflation, growth issues are not ignored, infrastructure is replaced as it is worn out and the level of service to the customer improves. The manner in which this revenue increase is proposed to be accomplished includes the following changes for all residential and commercial customers: > The change in the monthly base rate is recommended to increase between $0.10/month and $148/month, depending on the meter size. Most residential customers have a 5/8"X3/4" meter. These customers would realize a $0.10/month change in their monthly billing under this proposal. > The number of gallons included in the base rate is proposed to change to 1000 gallons from 2000 gallons for all customers. > The commodity rate for all customers is recommended to increase $0.02/1000 gallons. More detailed discussion on water rate recommendations are included in the main body of the report and in Appendix D, including residential and commercial customers as well as `city' and `non-city' customers. - 2 - • Financial Criteria: The Commission recommends that the Town Council adopt the following criteria as policy to guide staff in operating the utility using sound business practices that protect the long term interests of the rate payers: ➢ Retained earnings shall never become negative. ➢ The utility shall not operate at a net loss on the income statement for more than two consecutive years. ➢ Cash flow shall be sufficient to pay personnel, O&M and debt service. ➢ Cash reserves for operation shall not normally be less than 15% of the expected cash outlays, excluding capital. Cash reserves may fall below this threshold, but not for more than 2 consecutive years. ➢ Debt service coverage shall not be less than 1.25 times the annual debt service as required in the bond covenants. ➢ Depreciation shall be fully recovered through rates each year for reinvestment in the system,to be verified through an analysis of expected plant life every five years. ➢ In the case of unforeseen circumstances, every effort shall be made to avoid borrowing funds. Instead, deferment of other expenses and use of cash reserves should first be explored before consideration of incurring debt. • Departmental Structure: The Commission recommends that the water utility be established as a separate department. As Oro Valley continues to grow, the separation of the water utility from the Department of Public Works is inevitable. Combined with the unique nature of operating a municipal water utility within the Tucson Active Management Area, there is a need for staff to focus resources on strategic and tactical issues. A separate departmental structure could be more effective in answering the utility's ability to fully participate in regulatory and regional water issues and to provide improved overall service to customers. • Alternative Water Resources: Given the importance to the residents of Oro Valley of addressing alternative water resource issues and the progress made in the last year, the Commission recommends that efforts on the same three points presented in the 1997 Annual Report be continued. To reiterate the three points, they are (1) the phased in use of reclaimed water to irrigate golf courses, (2) the Town continue joint alternative water resource planning with neighboring jurisdictions and other water resource agencies to take advantage of economies of scale; and (3) purchase incentive priced CAP water while it is available for accumulating long term storage credits. • Master Planning Reports: The Commission recommends that the Town create two separate Master Plan Reports. One report would be for the domestic water system, consolidating the two Master Planning Reports currently in place. The new second report would be for alternative water systems, which currently have no master plan in place. • Oro Valley Water Improvement District #1: The Commission recommends that the Council provide proper notice to the Metropolitan Domestic Water Improvement District and incorporate the management of the production and delivery systems within OV #1 into - 3 - the new Utility Department if the Task Force established to study the issue determines that it would be in the best interests of the Town and OV#1 customers to manage that system. • Tucson Water system within Oro Valley: The Commission recommends that the Town Council pursue an analysis of the acquisition of the delivery and production system currently serving residents of the Town who are customers of Tucson Water. The Oro Valley Water Utility Commission is proud to serve the Council and customers of the Town of Oro Valley. We are pleased to present our Annual Report to the Town Council for consideration. While much has been accomplished in the past year, the Commission looks forward to direction from Council regarding those items mentioned in the Executive Summary and detailed in the Report. We thank the Council for their consideration, direction and guidance. - 4 - PREFERRED FINANCIAL SCENARIO PROPOSED RATE SCHEDULE NON-CITY CUSTOMERS , METER CURRENT PROPOSED PROPOSED CURRENT PROPOSED PROPOSED SIZE BASE RATE BASE RATE INCREASE COMMODITY COMMODITY INCREASE PER 1,000 GALS. PER 1,000 GALS. PER 1,000 GALS. 5/8 X 3/4 9.75 9.85 0.10 1.71 1.73 0.02 1 24.38 24.70 0.32 1.71 1.73 0.02 1.5 48.75 49.40 0.65 1.71 1.73 0.02 2 78.00 79.00 1.00 1.71 1.73 0.02 3 156.00 158.00 2.00 1.71 1.73 0.02 4 243.75 250.00 6.25 1.71 1.73 0.02 6 487.50 500.00 12.50 1.71 1.73 0.02 8 702.00 850.00 148.00 1.71 1.73 0.02 THE CURRENT BASE RATE INCLUDES 2,000 GALLONS OF WATER THEPROPOSED BASE RATE INCLUDES 1,000 GALLONS OF WATER PREFERRED FINANCIAL SCENARIO PROPOSED RATE SCHEDULE "CITY" CUSTOMERS METER CURRENT PROPOSED PROPOSED CURRENT PROPOSED PROPOSED SIZE BASE RATE BASE RATE INCREASE COMMODITY COMMODITY INCREASE PER 1,000 GALS. PER 1,000 GALS. PER 1,000 GALS. 5/8 X 3/4 6.75 7.90 1.15 1.71 1.73 0.02 1 16.86 19.70 2.84 1.71 1.73 0.02 1.5 33.71 39.95 6.24 1.71 1.73 0.02 2 53.93 63.00 9.07 1.71 1.73 0.02 3 107.85 127.80 19.95 1.71 1.73 0.02 4 168.53 200.74 32.21 1.71 1.73 0.02 6 337.05 401.48 4 64.43 1.71 1.73 0.02 8 N/A N/A N/A 1.71 1.73 0.02 THE CURRENT BASE RATE INCLUDES 2,000 GALLONS OF WATER THE PROPOSED BASE RATE INCLUDES 1,000 GALLONS OF WATER TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR NON-CITY CUSTOMERS WITH A 5/8 X 3/4" METER % OF USERS GALLONS CURRENT PROPOSED AMOUNT PERCENT DURING YEAR USED RATE RATE INCREASED INCREASED ENDED NOV 97 0 9.75+ 9.85 0.10 1.0 1 1,000 9.75 9.85 0.10 1.0 4 2,000 9.75 11.58 1.83 18.3 4 3,000 11.46 13.31 1.85 16.1 6 4,000 13.17 15.04 1.87 14.2 7 5,000 14.88 16.77 1.89 12.7 9 6,000 16.59 18.50 1.91 11.5 9 7,000 18.30 20.23 1.93 10.5 9 8,000 20.01 21.96 1.95 9.7 8 9,000 21.72 23.69 1.97 9.1 6 10,000 23.43 25.42 1.99 8.5 6 11,000 25.14 - 27.15 2.01 8.0 5 12,000 26.85 28.88 2.03 7.6 4 13,000 28.56 30.61 2.05 7.2 4 14,000 30.27 32.34 2.07 6.8 3 15,000 31.98 34.07' 2.09 6.5 2 16,000 33.69 35.80 r 2.11 6.3 2 17,000 35.40 37.53 2.13 6.0 2 18,000 37.11 39.26 2.15 5.8 2 19,000 38.82 40.99 2.17 5.6 1 20,000 40.53 42.72 2.19 5.4 1 21,000 42.24 44.45 2.21 5.2 1 22,000 43.95 46.18 2.23 5.1 1 23,000 45.66 47.91 2.25 4.9 1 24,000 47.37 49.64 2.27 4.8 1 25,000 49.08 51.37 2.29 4.7 <1 26,000 50.79 53.10' 2.31 4.5 <1 27,000 52.50 54.83 2.33 4.4 <1 28,000 54.21 56.56 2.35 4.3 <1 29,000 55.92 58.29 2.37 4.2 <1 30,000 57.63 60.02 2.39 4.1 <1 31,000 59.34 61.75 2.41 4.1 <1 32,000 61.05 63.48 2.43 4.0 <1 33,000 62.76 65.21 2.45 3.9 <1 34,000 64.47 66.94 2.47 3.8 <1 35,000 66.18 68.67 2.49 3.8 <1 36,000 67.89 70.40 2.51 3.7 <1 , 37,000 69.60 72.13 2.53 3.6 <1 38,000 71.31 73.86 2.55 3.6 <1 39,000 73.02 75.59_ 2.57 3.5 <1 40,000 IP 74.73 77.32 2.59 3.5 <1 0 TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CITY CUSTOMERS WITH A 5/8 X 3/4" METER T % OF USERS GALLONS CURRENT PROPOSED AMOUNT PERCENT DURING YEAR USED RATE RATE INCREASED INCREASED ENDED NOV 97 0 6.75 7.901 1.15 17.0 1 1,000 6.75 7.90 1.15 17.0 4 2,000 6.75 9.63 2.88 42.7 4 3,000 8.46 11.36 2.90 34.3 6 4,000 10.17 13.09 2.92 28.7 7 5,000 11.88 14.82 2.94 24.7 9 6,000 13.59 16.55 2.96 21.8 9 7,000 15.30 18.28 2.98 19.5 8,000 17.01 20.01 3.00 17.6 8 9,000 18.72 21.74 3.02 16.1 6 10,000 20.43 23.47 3.04 14.9 6 11,000 22.14 25.20 3.06 13.8 5 12,000 23.85 26.93 3.08 12.9 4 13,000 25.56 28.66 3.10 12.1 4 14,000 27.27 30.39 3.12 11.4 3 15,000 28.98 32.12 3.14 10.8 2 16,000 30.69 33.85 3.16 10.3 2 17,000 32.40 35.58 3.18 9.8 2 18,000 34.11 37.31 3.20 9.4 2 19,000 35.82 39.04 3.22 9.0 1 20,000 37.53 40.77 3.24 8.6 1 21,000 39.24 42.50 3.26 8.3 1 22,000 40.95 44.23 3.28 8.0 23,000 42.66 45.96 3.30 7.7 1 24,000 44.37 47.69 3.32 7.5 25,000 1 ,_ 46.08 49.42 3.34 7.2 <1 26,000 47.79 51.15 3.36 7.0 <1 27,000 49.50 52.88 3.38 6.8 <1 28,000 51.21 54.61 3.40 6.6 <1 29,000 52.92 56.34 3.42 6.5 <1 30,000 54.63 58.07 3.44 6.3 <1 31,000 56.34 59.80 3.46 6.1 <1 32,000 58.0561.53 3.48 6.0 <1 r 33,000 59.76 63.26 3.50 5.9 <1 34,000 61.47 64.99 3.52 5.7 <1 35,000 63.18 66.72 3.54 5.6 <1 36,000 64.89 68.45 3.56 5.5 <1 37,000 66.60 70.18 3.58 5.4 <1 38,000 68.31 71.91 3.60 5.3 <1 39,000 70.02 73.64 3.62 5.2 <1 40,000 71.73 75.37 3.64 5.1 <1 m m m m H -oo7J0 > 0013 r 0X * i H H -i rn nn m m O --i m > m > m n m _ < Z — Z z--1 rn = O x � ( m m m c m m n cn > 0n -IIM OXZX m m 0 O -I Z 300 0 -1z � � cx ooCA) Cncn Z rn m m O 0 H0H > > 0Zn aiommm. .0 -0 °n in in 00000 0 > X z z -� R1 -1i r- "IO m 70 m � o 0 0 m Z Z - D C� > X OO > -iZOz y Z — 0 0 r n z Z s?° r n C C � Z � ii 0c m Orn K rnOmzcmn m z-n -n -n -n m w sn Sn i m rn 0 D < C 0 -< -< -< --< -< O m a _ m Z Cn Ooo (000 0 z m0 O -Ix Z cm > 1� 1 \ -....°3 N o000co 0 v - < Z ZC D rn co N O CO cc O 71 Z tv 0 G') z Z C Cr) > z o w rn 0 m m 13 O X O Fi z m m m P 3 -< -< g ;o 00 z m (n mm m cn ( o X m 0 z C, 0 E -n m r IV r -a r r 1 N -IV Cn o 01.A W COhCD -A CO CO -A CA N W COO Co CA) C� 000 -I C) W 0) -.1 O O -� 01 -A CO -A -A -� Co -A CO t_O > V � V ,� r ,. r v r Co n .1 .. O r O CJ1 Cn ID Co N . O .1 -.4 a R1 CA O CA 0) Co 0 CO 11 -r1 -A CJ1 a) CO -A 0) 00 -a -L O Co CO N Co N 01 CO N 01 0 -A 0) O rn z . -I n W - .- Cn .4. .< 'o co4. -i - 01 �1 -. W 0) / GJ -� N Co co Xi s CD TT 0 (-4. '^ - Co -� w 4 C) 000 rn CM V/ CO CA) N O (0 V, -A O Co v r r O CO 0o O CO CO O Cn Cn -A W �1 O �1 J1 In 0 m 'tel CJ1 N N -I:=, C7) -A -.4 - O Cn -" O O O CA) m -" W Cil CO O -•• N Cn O CA) CO CO -1 CO N X m CI .A 01 11 0 0 0) -A N - 0) o VA 4 Co �1 oo m --, 0 �1 Cn Co N Z W Cn COO - C OA. COOP Con 01 O CJ) 01 Cn -.4 CO C V V v v r V r .. v .. v CO ,Oo CD W N W O N O1 0 In N -.P.co-1 00 - CO 01 CD O -.J CD -A CO - -A O Co O 7J 41. 0 CA) CA) 01 CO Co Cn W N CO CO O N Cn 0 '11 -A O wy CO 01 W -A - CO CO Co -A �1 -A 01 O O -N1 CO -A CA) 0 CA) .A CA) "N1 CO -A. Co CA) O �I -A -A I V "co V V V VO W 01 4 - CO CO N O ln O CNA) -co01 In O N N O -A C) CO 01 -4. CO co Cn -- �1 -A CD cn -A O an .� .A - - 1 cn -< � -A Cn . Na In In co CO Iv -� CO o co COh -,L N CY) - N CO -A 01 C CO Co CD Co CD N CO -A CA) -A CO -A Cn CO -A O W 7.4 -� -A N) In �1 O W O COao 1 COOo O -4 CA) 4. CA) -.4 -A N 0 --.11 N O 01 N C0 CD Co 0 0 0 Co Co .A O CO 01 N - A CJ1 X rn H0 'v -I > oZ0a v in --12-10 z � > 02Z Um z m rn Z O -02 � 0 -0m-io oo --Imz n -0m --1 O o n q Z > x x — Z -I > J n r x O Z Z rDn r _imnz Cl) rm o > mmn rnO C) r- � nOz m DSD03 0- -�i0 C) > O ? < D m r r D o > cnc > _i � rnp < COm rnHXm � _ = -gym r00 C� C� � � D mp0 � z O z z m rn z m D c -� D r I 0 7o m rn z c ,n � K m oo 0< < zz r.n m r — C) D m C� H --r co O Z 0 3 z A m D D cn o n * D � >rn H = z � co cn > z 0 � O m 73 I n m m C c c (7Oo 0 (I) < - D C Z 7 n � ZOm O -a Z X 11N z Z 7v n z 0r o o 0 O rn r m m m 0 -I co ao -1 m HH H rn rn H 0 0 O 0 n m ao I -I m -n m cn .� _s _ ....% Nv •N -Lw I .< r N .< m - - 73 CO I CO GJ CA) _-L N t0 0 00 .P GJ •P N t0 < 0 CA t0 4= CN11 K3 41, COOCA) CTI 00 N Co 01 0 (00 0) co -CO 03 O -CO CJ1 0) �1 C,J (p H -, .P O w 0) 4 too m ID ""IW GJ 0 W .P 0) C31 N y CO CO 00 CO CC 1 C.O 01 CO0 > ICA) COC O O -1 CO CO 0 W N .p CO CO ... H w ..� --I rn H -n m -n m - - .� w - - .< Z ..a N E V V v COCO CO -0 0)) C.71 " - --L0 ~ co t0 , N -.! 01 t0 -L -4 0 to Z CD C 3 t71 CII 0 CO .P 0 CD CA) CA) 0 W 0 GJ CD C -I V 0 -, V .. V Co t0 o O 0 t0 In .P O CD o 1� -� t0 CO O W . CD O 0 1 0 y 0 0 0 -4 -.1 O N /Vin N N O V1 O N N CO 0 0 0 CO CJI 0) CA) 41, rnCA01 C11 0 0) CA CA) -0 rn m 7o m mm N W _.A. .< rn ,...a -, w -‹ 70 CO 01 co 0) co 01 --P. N C O 0 0 00 GJ •P N 0 7J t -4 WO S 0 rn O O 01 CO CJU) t0 CO 0 N CJI CD 0 CO V0- VoO0 r001iOVCOCO 0 C .s rW -co0 Vt) O VCJ ID .O CA0 . m 0mww01 00 CO 01CA) 000 Z wC) CA 03 0 rn X Z 0 -n 773 �, m - - W -1. w V !`� -CO :P CA) CP 0 O 0• 01 01 CA 01 4=, CO0 CO Co w CP N CO 03 0 W - 0 0 O -" CJ1 01 �► 01 N — I J 0 In 01 �1 :P N CO 4N, 000 4:. 110 -.ICO " -.• 0 too — 11 CO CO 000 CO 01 - 0) 0) w (0 (00 v) -� C00) CA) -< - - w _, _, -< 01 — CO O▪ 0 01 01 O 0) --' N 0 N N O N CO) N - 0 to11 CO (71 01 0 COo .. - W CP 01 N -P 0 N -P .P Ca N I0 7.4. O O O - In - .1 .L W ...3. .P O t0 J - -1 W W CO 0 0 0 CO -.1 N - -P in W GJ 0 O N CEJ .P CO 0J1 0 0 0 a1 01 N.) 0 CO0o CO 0 0 N.) CO 0 , , Oro Valley Water Systems Schedule H-3 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers Change in Gallons Included in Minimum From: 2,000 to: 1,000 Percent Change in Gallons Included in Minimum: -50.00% Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums(Approximate before rounding): 1730% 2 Conservation for Construction, Irrigation and Turf Customers 0451 3 Weather Normalization Percentage/Turf& Irrigation Only 0.00% 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $9.850 1.03% 9.850 7 5/8 x 3/4 Inch-Other (a) $9.750 $9.850 1.03% 9.850 8 5/8 x 3/4 Inch-Residential City $1.03 $6.750 $7.900 17.04% 7.900 9 5/8 x 3/4 Inch-Commercial City $1.03 $6.750 $7.900 17.04% 7.900 10 5/8 x 3/4 Inch-Irrigation City $1.03 $6.750 $7.900 17.04% 7.900 11 5/8 x 3/4 Inch-Other City $1.03 $6.750 $7.900 17.04% 7.900 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch-Res, Com, Irr,Turf $24.380 $24.700 1.31% 24.700 14 1 Inch-Other $24.380 $24.700 1.31% 24.700 15 1 Inch-Residential City $2.61 $16.860 $19.700 16.84% 19.700 16 1 Inch-Commercial City $2.61 $16.860 $19.700 16.84% 19.700 17 1 Inch-Irrigation City $2.61 $16.860 $19.700 16.84% 19.700 18 1 Inch-Other City $2.61 $16.860 $19.700 16.84% 19.700 19 1 1/2 Inch-Res, Com, Irr,Turf $48.750 $49.400 1.33% 49.400 20 1 1/2 Inch-Other $48.750 $49.400 1.33% 49.400 21 2 Inch Res, Corn, Irr,Turf, Res MF $78.000 $79.000 1.28% 79.000 22 2 Inch-Other $78.000 $79.000 1.28% 79.000 23 2 Inch-Residential City $8.36 $53.930 $63.000 16.82% 63.000 24 2 Inch-Irrigation City $8.36 $53.930 $63.000 16.82% 63.000 25 3 Inch-Irr,'Turf $156.000 $158.000 1.28% 158.000 26 3 Inch-Other $156.000 $158.000 1.28% 158.000 27 4 Inch-Res,Turf, Irr, Res MF $243.750 $250.000 2.56% 250.000 28 6 Inch-Corn, Turf $487.500 $500.000 2.56% 500.000 29 8 Inch-Corn, Turf $702.000 $850.000 21.08% 850.000 30 Unmetered, Const, Maint $9.750 $9.850 1.03% 9.850 31 V-Golf Irrigation $702.000 $750.000 6.84% 750.000 (a) One third(1/3) of difference in monthly minimums between"City"and "Non City" customers added to"City"customers to eventually align rates. Gallons included in Monthly Usage Charge 2,000 1,000 -50.00% 1,000 Commodity Rates Residential, Commercial and Resale Customers Charge per 1,000 Gallons in excess of gallons included in Monthly Usage Charge $1.71 $1.730 1.17% 1.730 Up to 10,000 Gallons for 10,000 Residential, Commercial and Resale Customers Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 ( Resale/La Cholla Airpart&Metro Water $1.45 $1.47 1.38% 1.470 Charge per 1,000 Gallons in excess of 10,000 Gallons $1.71 $1.730 1.17% 1.730 t TOWN MANAGER REVIEW PROPOSED RATE SCHEDULE NON-CITY CUSTOMERS METER CURRENT PROPOSED PROPOSED ' CURRENT PROPOSED PROPOSED SIZE BASE RATE BASE RATE INCREASE COMMODITY COMMODITY INCREASE PER 1,000 GALS. PER 1,000 GALS. PER 1,000 GALS. . 5/8 X 3/4 9.75 10.20 0.45 1.71 1.79 0.08 1 24.38 25.50 1.12 1.71 1.79 0.08 1.5 48.75 50.99 2.24 1.71 1.79 0.08 2 78.00 81.59 3.59 1.71 1.79 0.08 3 156.00 163.18 7.18 1.71 _ 1.79 0.08 4 243.75 254.96 11.21 1.71 1.79 0.08 6 487.50 509.93 22.43 1.71 1.79 0.08 8 702.00 734.29 32.29 1.71 1.79 0.08 THE BASE RATE INCLUDES 2,000 GALLONS OF WATER TOWN MANAGER REVIEW PROPOSED RATE SCHEDULE "CITY" CUSTOMERS METER CURRENT PROPOSED PROPOSED CURRENT PROPOSED PROPOSED SIZE BASE RATE BASE RATE INCREASE COMMODITY COMMODITY INCREASE PER 1,000 GALS. PER 1,000 GALS. PER 1,000 GALS. 5/8 X 3/4 6.75 8.21 1.46 1.71 1.79 0.08 1 16.86 20.52 3.66 1.71 1.79 0.08 1.5 33.71 41.02 7.31 1.71 1.79 0.08 2 53.93 65.63 11.70 1.71 1.79 0.08 3 107.85 131.25 23.40 1.71 1.79 0.08 4 168.53 205.09 36.56 1.71 1.79 0.08 6 337.05 410.18 73.13 1.71 1.79 0.08 8 N/A N/A N/A 1.71 1.79 0.08 THE BASE RATE INCLUDES 2,000 GALLONS OF WATER TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON NON-CITY CUSTOMERS WITH A 518 X 3/4" METER PROPOSED BASE RATE 4.6% INCREASE FROM 9.75 TO 10.20 INC. 2000 GALLONS PROPOSED COMMODITY 4.6% INCREASE FROM 1.71 TO 1.79 PER 1000 GALLONS GALLONS CURRENT PROPOSED AMOUNT PERCENT USED RATE RATE INCREASED INCREASED , 0 9.75 10.20 0.45 4.6 1,000 9.75 10.20 0.45 4.6 2,000 9.75 10.20 0.45 4.6 3,000 11.46 11.99 0.53 4.6 4. 4,000 13.17 13.78 0.61 4.6 5,000 14.88 15.57 0.69 4.6 6,000 16.59 17.36 0.77 4.6 7,000 18.30 19.15 0.85 4.6 8,000 20.01 20.94 0.93 4.6 9,000 21.72 22.73 1.01 4.7 10,000 23.43 24.52 1.09 4.7 11,000 25.14 26.31 1.17 4.7 12,000 26.85 28.10 1.25 4.7 13,000 28.56 29.89 1.33 4.7 14,000 ' 30.27 31.68 1.41 4.7 15,000 31.98 33.47 1.49 4.7 16,000 33.69 35.26 1.57 4.7 17,000 35.40 37.05 1.65 4.7 18,000 37.11 38.84 1.73 4.7 19,000 38.82+ 40.63 1.81 4.7 20,000 40.53 42.42 1.89 4.7 21,000 42.24 44.21 ` 1.97 4.7 22,000 43.95 46.00 2.05 4.7 23,000 45.66 47.79 2.13 4.7 24,000 47.37 49.58 2.21 4.7 , 25,000 49.08 51.37 2.29 4.7 26,000 ' 50.79 53.16 2.37 4.7 27,000 52.50 54.95 2.45 4.7 28,000 54.21 56.74 2.53 4.7 29,000 55.92 58.53 2.61 4.7 30,000 57.63 60.32 2.691 4.7 31,000 59.34 62.11 2.77 4.7 32,000 61.05 63.90 2.85 4.7 33,000 62.76 65.69 2.93 4.7 34,000 64.47 67.48' 3.01, 4.7 35,000 66.18 69.27 3.09 4.7 36,000 67.89 71.06 3.17 4.7 37,000 69.60 72.85 3.25 4.7 38,000 71.31 74.64 3.33 4.7 39,000 73.02 76.43 3.41 4.7 40,000 74.73 78.22 3.49 4.7 TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON CITY CUSTOMERS WITH A 5/8 X 3/4" METER PROPOSED BASE RATE 21.6% INCREASE FROM 6.75 TO 8.21 INC. 2000 GALLONS PROPOSED COMMODITY 4.6% INCREASE FROM 1.71 TO 1.79 PER 1000 GALLONS GALLONS CURRENT PROPOSED AMOUNT PERCENT USED RATE RATE INCREASED INCREASED 0 6.75 8.21 1.46 21.6 1,000 6.75 8.21 1.46 21.6 2,000 6.75 8.21 1.46 21.6 3,000 8.46 10.00 1.54 18.2 4,000 10.17 11.79 1.62 15.9 5,000 11.88 13.58 1.70 14.3 6,000 13.59 15.37 1.78 13.1 7,000 15.30 17.16 1.86 12.2 8,000 17.01 18.95 1.94 11.4 9,000 18.72 20.74 2.02 10.8 10,000 20.43 22.53 2.10 10.3 . 11,000 22.14 24.32 2.18 9.8 12,000 23.85 26.11 2.26 9.5 13,000 25.56 27.90 2.34 9.2 14,000 27.27 29.69 2.42 8.9 15,000 28.98 31.48 2.50 8.6 16,000 30.69 33.27 2.58 8.4 17,000 32.40 35.06 2.66 8.2 18,000 34.11 36.85 2.74 8.0 19,000 35.82 38.64 2.82 7.9 20,000 37.53 40.43 2.90 7.7 21,000 39.24 42.22 2.98 7.6 22,000 40.95 44.01 3.06 7.5 23,000 42.66 45.80 3.14 7.4 24,000 ' 44.37 47.59 3.22 7.3 25,000 46.08 49.38 3.30 7.2 26,000 47.79 51.17 3.38 7.1 27,000 49.50 52.96 3.46 7.0 28,000 51.21 54.75 3.54 6.9 29,000 52.92 56.54 3.62 6.8 30,000 54.63 58.33 3.70 6.8 31,000 r 56.34 60.12 3.78 6.7 32,000 58.05 61.91 3.86 6.6 33,000 59.76 63.70 3.94 6.6 34,000 61.47 65.49 4.02 6.5 35,000 63.18 67.28 4.10 6.5 36,000 64.89 69.07 4.18 6.4 37,000 66.60 70.86 4.26 6.4 38,000 68.31 72.65 4.34 6.4 39,000 70.02 74.44 4.42 6.3 40,000 71.73 76.23 4.50 6.3 0 m m rn m z -0 73o > oo -o r' 0X * i • -1 --I --I rn rn rn O rn > m > D _ m 0 U 0 13 m X 0) = C z E. Z m = O u) cnm m m c z m o D 0 m D 0 O x z x m D 0 0 H Z 70w = OHZ -rJ � c � oowcn � Z rn m m 0 0 - 00 --� > DOz -� Omm o oCJ1C11b) y rn z — OMCn --1 -Izm O C - C 0o00o C7 > 3 z --1 _ _ r 'I � m70m ( c) � cs) - D 0 D 00tH D - nZOz a in z Z z 0 0 r0 zzs� r � D z Z '�� 0 m J rn - rn m G) O z c rn D Cn D m 0 z Cn m rn z < c n -n -n -n -n -n w � r � Cn wrn 7J x '< -C -C -C -C 0 rn o3 n 2 G) m z cn 0000 (Do0 o z m O -•iX Z Cr O 0` 00 (0 n 0 G2 m Z zc D m33 Cl) wNr-.• OCD 0 Z N o OZ Z < Cn m 'T1 > -c z o � X o m Z -� J) m 0 z -1 x * C 70 --Ti > 0 m m H rn O m Z rn m rr- 3 -< -< rn x 0 O z cn m m cn 2 73 m 0 •• cn z o 0 E wV) C?1 - GJ -,I 00 w w " CO H CD 0 .-. CO CO WN CO U1 CD N COD 0 0 CNJ1 co—CD D w y 0 .• r v r r r r r r Cn O O -p W O in In O O O CJl 1 O CJ1 CD CO rn 00 0 Ni 0 CO CD CO �1 -1 -� 01 a) -1 0 CD -1 -A --, O 0 O -1 CD Ni C11 CD O Ni -1 0 CO O rn `.. Z --1 m CA) (Y1 •P -< 1.14 (ii -.. 4, Clt -,I -s w w �I w -' N O co 0 W 0 -4 CO w -3, CO --s CO -4 w p) 0) COCCD C71 0) CO w Ni0 CO C11 0 COO ID C y ,� r r r v r r r r r *1,1 r r Z Q! 11 O CO CD O in C11 w �1 O 1 �I •�1 n Q 0 CO Ni Ni 41, C) -P -1 -J 0 C11 -. .p -� W C11 CO 0 .-b. N.) C11 a) C3) w COO -4 COD Ni z D r V r ... V V ) 41. • I. 00 • (4) 011 CD 0 01 J7 CO -1 CA) - 0 -I O CO Ni 0 -1 CA) 01 CO -4 CD CD CII Cn 0 0) CA 01 -I CD - 70 y ,• y r r r r v r r r Vt O CO W r N r w C) N CT1 O Ol N r r r a) 01 tom CW 11 in co 4:::;) co -L (0 U1 a) o -.1 a) 4 a 41. .p 0 Co o < 41. 41. O co w 01 CO CO C11 w Ni CD CO O Ni 01 -•s — - — — •p ...s ...s C11 CA y r r `• r r r •..... -, O CO La 41. -J CO01 CO 00 -i+ CD 0 -4 (+ O .D. CO 0 Ci) . CA) -4 CD CO w 0 -J -4 - y .• y v r r r r In r iv Co Co r r r Q CD CO0 -4 - CO 0) Ni 0 OBJ 0 WC011 O Ni 1 N O 4:- Q) CD CJ1 -P CO CO 01 — - 41, CD C11 -P 0 'T1 .p � - C 1 _ C11 -< -a O -.% -.P. 01 . Ni C?) O1 CO O CD N --, CD O CA --s .A• Ni 0) -� Ni CO 01 0 CD CO 0 CO CO 'i -p CEJ � CO00 .4:- 01co .P► - GJ Ni P CO 0)) 00 CD 1.4 --P, ..-a. .p -s MN in -.J rrw O OCOw 0 0) 4b. w -J Ni 0 �1 Ni a) 011 Ni 00 0 CO 0 0 0 CO co •P 0 CO 01 Ni 4 CJ1 73 rn -I0 -u --I > ozvo v -IZ -o > o2Z rn Z O > J OKmmm omo O0 _17J < mHm 0 v_ D oz DOS IGS � Dmz — � � — III C Z r --in r � mZZ Cn r- rnn � rn Z G7 n � �v - n0z rn c3W conwn m o DO > < yOZ 7o rn -a r5 _i D > cn C n "A --� K ° < w -u .� rn --i m 3 Cn _ - - - rn0 n -4y ,np Z = m Z Z D rn � "< D< 0 13 .- w 0 -< > oo rn K , 71 m 3 > -< r = 0 m m 0 c -nc2 k rn oo < < _iz m m r — n m 0 --I o0 C) Z O � z n mDD D n n C7 � -� C7 V1 u) m I Z G) 00 m 0 = > m rn C c 73 C 0o 0 -^ cn5 < U5 C Z --i j C) J En m -' - m o -o II O q 7] .. z - z x z - N 0 z 0 O` m z m m m m m 0 n °° n m � _103 M rn --I 0 0 0 n rn tn CO I —I u) - NN 46. - w -< r ...% -1. N - - in to 00 131 w w - - o 0 0.0 -� w o CO� w <_ 00 73 0 0 01 01 0 CSD 1 W CO Ni COJ 01 O CD -1 �1 co� C7 '•••.1 V -4. -.P. r Ili -CA -a) V -o.) � -,t. --4 r V -a) --P. r Po~ � o�oo�oo cv'o � � tovcwo �° � -, � � O oo � o rn 0 0 0 Ni -P 0 Ni 0) 0 00 00 O 00 01 CO 0 > O O O t0 CD O O Cl)CD M n E m m W - Z N ., -a "< E o c▪o soC) N -co 00 0 Z-I 004s. w ooC) . o m CD CD cn 01 o .. 0 0 0 Ni w o W O W COo Z � .t� ocDo o � ----- -I ✓ ."--L V r r V r r r r V r V V r r r 00 -� O O O -i 01 -p O �_ O Q - N N 0 (( O N N O - 4. O O O 01 Cr) Ni 0 * sU13 tit 01 O "4 0) Ny W O Z c * z Ni W _s , Q i -a (,) -a - E O t0 D) W 0) � N -CO 0 00 4 C) -). - N O G) c0 .4. cn o � �iw -� 0 � coOCCJ'Do N � � � 0 70 0) O O O 0) CA �1 CD rn -CA) -CA) r V -cc. � O "co o00 � � rnoCDo � ww00 010)- CO rn 01 ui N o 0 o N Cn GJ O .4. rn :-4 W G►) o 0) W Cs) O < c� crt 2 W -a 44. " N ,,,,,< _a � (n) --I � co Vmay� -� VI -.1 co � 0 vs 0 CO --,1 11 W - CO -J of - T 0) 00 0 00101 0 � 00 00) O CO W U1 Ni CO W 0 W N O O O N In In N ..s :1 �1 O Q) U �l Ni OOO � O ~ Q) -1:. 000 . CJ0) Ny CD (0 O 0) OCD 0) W �' O 01 01 IL -a) ) -' W O NiO O1 OW ( WN N N O N - Ni CO 01 CJ1 -15. -P 0 0 Ni 4=, W D W O O O vW Cl r-,1 r-.1 vN EFI) -A O lo --.1 --P. -- 1 (.9 0 Ni 0 0 0 -Na► 01 Ni O - y 000 000 0 O Ni 0 O 4:53MAY1296 TUEPM P. 4 0 Oro Valley Water Systems Schedule 143 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to City equation, 1/3 of differential between regular and Customers Increase • Present Proposed Percent Percent- No.Llna Customer Classification cites �, change age an stet Sly ---� ................. Minimums 1 Percentage Increase in Monthly 4. 0 2 Percentage Increase In Commodity Rates NNS 3 4 Monthly Usage Charge for: entief Commercial,irrigation,Resale and Miscellaneous Customers ° 0,199 5 Resld $9.750 $10.1 g9 4.60/0 1 8 518 x 3/4 Inch Res,Cote,Irr .750 $10.199 4.60% 10.199 7 518x314Inch-Other .tea} $9 �"~ 6116 $6.750 38.210 29.6396 8210 8 5/5 x 3/4 Inch-Residential City 9 5/8 x 3/4 Inch-Commercial City $1.15 36.750 $8210 21.63% 8210 • $1.1 S $Q.750 36.210 21.83% 8.210 10 518 x 3/4 Inch-Irrigation City 11 5/8 x 3/4 Inch-father City $1.15 56.750 $8.210 21,63% 8.2100.000 12 3/4 Inch $0.000 $0.000 NA 324.380 $25,501 4.60% 25.501 13 1 Inch-Res,Com,Irl',Turf380 $25.501 4.60% 25.501 7 4 1 Inch-Other $Z4. 15 1 Inch-Residential City $2.88 316.860 $20.516 21.68°l0 20.516 516 21.889'0 20.516 -Commercial City $2.88 $16.860 $20. 16 11nch 2.86 $16.860 $20.516 Z1.68°Yo 20.516 1 T 1 Inch-Irrigation City = 1 g 21.68% 20.516 Inch-Other City $2.88 $16.860 $20.5 1 g 1 $48.750 $50.953 4.60% 50.993 19 1 1/2 Inch-Res,Com,In.,Turf 20 1 112 inch-Other $48.750 $50.993 4.60% 50.993 21 1 112 inch•City 65.76 $33.710 $41.021 21.69% 41.021- 22 2 Inch Res,Com,Irr,Turf,Res MF 578.000 $61.58$ 4.60% 81.588 23 2 Inch-Other $78.000 $81.588 4.60% 81.588 � 353.930 $65.830 21.69% 65.630 24 2 Inch-Residential City = � 25 2 Inch-Irrigation City ;9.22 $53.930 $85.630 21.69% 85.630 ,175 4.60% 163.176 •Irr,Turf $156.000 $1630 176 Z5 3 Inch $156.000 $163.176 4.60% 163. 27 31nch•Other 25 3 Inch City- $1844 6107.850 $131.253 21.70% 131253 29 4 Inch R , 3 30 4 Inch City i Res,Turf,Irr,Res MF 3243.750 $254 0 ..gg3 4,g0°�, 254.99663 $21.51 $168.530 $205.093 21.70% 205 $487.500 $509.925 4.60% 509.925 31 6 Inch•Cam,Turf 32 6 Inch-City $57.53 $337.050 5410.179 21.70% 410.179 $702.000 3734.292 4.60% 734.292 33 8 Inch-Com,Turf $9.750 510.199 4.60% 10.199 34 Unmetered,Const,Maim 702.100 $734.292 4.60% 734.292 35 V-Golf Irrigation $ difference in monthly minimums between"City"and"Non City" (a) One third(113)of customers added to"City"customers to eventually align rates. Gallons included in Monthly Usage2.000 Charge 2,000 2,000 0.00% Commodity Rates Residential,Commercial and Resale Customers Charge per 1,000 Gallons in excess of 1.790 gallons included In Monthly Usage Charge 31.71 31.7904.68% 11790 Up to 10,000 Gallons for Residential,Commercial and Resale Customers $0.30 0.00% 0.300 Resale!La Cholla Airpart&Metro Vistas,"Golf Course $0.30 0 1.x10 Rancho\ll Water $1.45 $1.52 4.60�6 Charge per 1,000 Gallons in excess of $1.789 8.60% 1.759 10,000 Gallons $1.71 PM P. 3 MAY-12-98 TUE 4:52 Oro Valley Water Systems schedule H-1Summary of Revenues by Meter Site at page 1 Present and Proposed Rates Without Conservation For Year Ended November 30,1997 Ley.Increase In Mojjthly Minimums#Commcgti, Customer Classification andlor Proforma pent Proposed Proforma Dollar Percent Present Revenues RevenUes Present Change Change.,,,. Meter Size ...................... $118,145 4.63% .... ......................... 52,55 d87 X2.868,632 Sl6 Inch Residential 37,551 37,551 39.284 39,244 �,743 4.64% Proforma for actual customer change4,646 79,811 79,811. 83,517 83,517 3,705 4.62% p��for Estimated customer Growth10,361 10,839 478 1 Inch Residential 770 805 36 4.62% 1.5 Inch Residential 55,51 a 58,070 2,556 a.so% 1 lnah Residential 55,514 70,351 885 4.6096 41nch Residential 10,456 3,414 151 4.629'6 5/8 Inch Commercial 17,117 17,906 788 a.61� 1 Inch Commercial 17,117 18,413 811 4.61% 1.6 Inch C 87,242 91,268 4,011 4.60% 2 Inch Commercial 87,242 88,884 3,909 4.6096 s Inch Commercial 32,877 34,390 1,512 4.60% 6 Inch Resale . 18,567 19,414 848 4.57% 8 Inch Commercial0 p 0 0.0096 1.5 Inch Tuff 36,01 p 40,834 1,824 4.68%2 inch TM 30,01 182,330 8,593 4.68% 3 inch Turf 31,402 31►868 1,467 4.67% 4 Inch Turf 794,730 831,374 37,143 4'6896 8 Inch Turf 32,484 33,9981,512 4.dd46 6I8 Inch Irrigation 70,848 73,935 3,287 4.65% 1 inch Irrigation 33,057 34,594 1,536 4.65% 1.5 Inch Irrigation 137,588 143,967 6,401 4.65% 2 Inch Irrigation 137,588 25,140 1,164 4.66% 3 Inch Irrigation 1 x,054 127,661 5,507 4.5996 6 Inch Irrigation 52,925 53,313 388 0.73% 8 Inch 1 Rancho Memo Golf Course 27.693 28,988 1,275 4.8096 518 Inch Other 3, 94 3,446 152 4.6196 1 Inch Other 2,86D 3,000 132 4.609b 1.5 Inch Other 5,948 6,220 274 4.8096 2 inch other 2,41 a 2,527 111 4.60% 3 Inch Other - 1.141 1,194 63 4.4196 Unmetered 1.141 121,745 11,151 10.6896 5/8 Inch Residential City 109,994 4,275 387 9.95%1 Inch Residential City 3,452 3,833 380 11.02% 2 Inch Residential City 0 0 0 0.00% 5/5 Inch Commercial City 589 661 82 10.39% 1 Inch Commercial City 1,pgg 1,162 107 10.10% 51'8 inch'Motion City 610 887 57 x.3896 1 Inch irrigation City x,151 4,456 304 7.33% 2 Inch Irrigation City 73 a7 15 20.43% 5/8 Inch Other City 479 541 -. 62 13.0496 • 7.44°6 ...IN........ .M.. 306�� 1 Inch Other City .. 7...."..- 4,432,575 ._.. ......• � 6 0.00%Total Water Revenues78.x._.. T8,3z5 0 Meter Fee Income 76,329 54,514 0 0.00% Miscellaneous Service Revenue 32,158 32,158 0 0.0091 Establishment Fees 32,150 $,100 0 0.0096 Reconnect Fees Weather Nurmalizatfon Adjustment ._ 0 ... ....."..... ..~ 71496 Turf&irrigation Commodity Revenues Only p78 $4,601,6 _74 122,811 .... 306,596 ....... .�... Proforma. 117,302 $ .8 .N.... .N.... ....... .%• Total Revenue Water Salvo withoutPr �..��.�� •�-::�. : Oro Valley Water Utility Town Council Meeting, June 18 , 1998 Index to Tabs and Schedules Tab Number Schedule 1 Text on Setting Rates and Rate Design Text 2 Cost of Service Study based on Actual Revenues Cost of and Expenses at November 30, 1997 Service 3 Revenues and Expenses for the Twelve Months ended Revenues & November 30, 1997 . Expenses as a percent of Expenses Revenues . 4 Impact of $0 . 10 Increase in Monthly Minimums Schedule A on 5/8 x 3/4 inch meters, and ratioed increases Page 2 of $0 . 10 per month to larger meters Increase = $ 18, 677 Impact of $0. 01 Increase in Commodity Rates Schedule B Increase = $ 22, 772 Page 2 5 Reduce gallons included in Minimum from 2, 000 to Schedule 1 1, 000, and Increase in Monthly Minimums $0 . 34 Page 2 Increase = $ 234, 549 6 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates $0 . 024314 Increase in Commodity Rates, Pages 1-3 Schedule 2 Increase = $ 234, 769 Page 2 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates Schedule 2A $0 . 02 Increase in Commodity Rates, Pages 4-6 Page 5 Increase = $ 226, 945 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates Schedule 2B $0 . 03 Increase in Commodity Rates, Pages 7-9 Page 8 Increase = $ 245, 081 7 Increase in Monthly Minimums of $1 .77, Schedule 3 Increase = $ 234, 293 Page 2 8 Across the Board Increases in monthly minimums Schedule 4 and commodity rates Page 2 Increase = $ 235, 329 Town of Oro Valley Council Oro Valley Water Utility Goals Of Rate Setting Rates should be set that recover all costs and meet debt service requirements. (Debt service is computed as net income plus depreciation divided by interest and principal payments.) Rates should be cost based, that it, the customer causing costs should pay his or her costs via rates charged. Determining whether or not the customer is paying his or her costs is done via a cost of service study. A cost of service study allocates expenses and assets (and the return on the assets, and recovery of the assets via depreciation)to each customer class. The revenues are then compared to the expenses, and the investment to produce the revenues, to determine if the customer is paying his or her cost of service. In the ideal world, all customers would pay exactly the cost to serve them. However, in the real world this rarely occurs. But, rates should be set as close as possible to costs. Rate increases should be as gradual as possible, to avoid rate shock to customers. Frequent small rate increases are preferable to a"one-time catch-up"rate increase. Rates should be easy to understand by the customer, so that they can control their bill. The monthly minimum charged customers should recover the cost of reading the meter, billing and collection costs. The monthly minimum should provide for a return on the investment in meters and service lines, office equipment, and other customer equipment to enable the utility to pay the interest cost associated with these assets. Finally, the rates must provide for depreciation on meters, service lines, office equipment, and other customer equipment to (1)provide funds for replacement of these assets, and (2) provide for repayment of debt incurred to purchase the assets. These costs are called "customer costs". The customer costs continue even when the customer uses no water, as the investment in meters and service lines continues to depreciate, and the interest and principal payments must still be made. 1 The commodity rate, or the rates based on the amount of water used, should recover the cost to provide the water, or all other costs other than customer costs. Please turn to Tab 2 The current rates charged customers result in some classes of customers being subsidized by other classes of customers. The attached cost of service study is based on the actual revenues, expenses, and plant for the twelve months ended November 30, 1997. The rate return at present rates is shown on Schedule 1, line 21. The rate increase needed to achieve a uniform rate of return is shown on Schedule 2, line 18. As can be observed from this schedule, if the goal was to derive a uniform rate of return from each customer class, substantial increases and decreases would be needed. A uniform rate of return would required a rate increase of approximately 24% for customers on 5/8"x 3/4"meters, and a rate decrease of approximately 69% of customers on 6" meters. (These data are summarized on page 3 of the text.) The computed monthly minimums and the commodity rates are shown on Schedule 2, pages 3 and 4. The only way to achieve a uniform rate of return would be to have different commodity rates for each class of customer(meter size). A summary of the cost of service study based on meter size shows the following as to number of customers, gallons sold, earned rate of return at present rates, and rate increase needed for a uniform rate of return based on the revenues and expenses for the twelve months ended November 20, 1997 (numbers in(parentheses) indicate negative numbers): 2 Results of Cost of Service Study Meter Size 5/8 Inch 1 Inch 1 1/2 Inch 2 Inch 3 Inch Number of Customers 10,400 154 43 98 14 Gallons Sold in Thousands 1,167,584 53,338 21,516 146,998 136,026 Earned Rate of Return at Present Rates (1.93%) (0.27%) (0.40%) 8.09% 24.99% Rate Increase (Decrease) Needed for a Uniform Rate of Return $767,592 $16,554 $9.279 ($74,062) ($100,311) Meter Size 4 Inch 6 Inch 6 Inch Resale 8 Inch Vistoso Golf Number of Customers 14 5 2 1 1 Gallons Sold in Thousands 33,507 565,149 17,995 1,029 148,361 Earned Rate of Return at Present Rates (6.71%) 81.18% 1.09% (2.25%) (8.02%) Rate Increase (Decrease) Needed for a Uniform Rate of Return $49,332 ($699,364) $2,170 $6,804 $22,009 3 Water Included In The Monthly Minimums Charged Customers The customer views this water as "free water". However, there is no free water, as the monthly minimum must recover the cost of this water. Arizona Department of Water Resources considers a high amount of water included in the monthly minimum as non-conservation measures. Inclusion of water in the monthly minimum does help to "justify"the monthly minimum to the customer. However, educating the customer on why he or she is paying a monthly minimum bill is preferable to including water in the monthly minimum. Rates Charged Customers Serve Many Purposes Rates charged customer provide the necessary revenues for the water utility to provide service and install plant as needed to provide quality service to customers. Rates provide a message to customers relating to the costs incurred to serve that customer. Rate can act as a conservation measure. The Major Variables In Setting Rates For A Water Utility Projected and estimated expenses must be included in the rates charged customers. The utility cannot charge retroactive rates to make-up for expenses incurred, but not recovered from customers. Thus, every attempt must be made to determine what future plant additions will be needed, and what level of revenues (customer additions) and expenses will be incurred. The amount of plant to be installed and when it will be installed impacts the need for higher rates charged customers (to provide cash flow), the need for a higher hook-up fee or impact fee, and/or borrowing to install plant. At this date, rates cannot pay for the plant to be installed in the near future. Additionally, increased rates will still not be sufficient to pay for the new plant needed. Assumptions regarding customer additions has a major impact on(1)plant to be installed, (2) expenses in the future, and (3) future revenue. The current estimate for customer additions is 780 new customers per year. If the number of new customers is higher or lower than the estimated 780, the need for plant and the level of expenses and revenues will change. 4 A shortfall in customer additions will have a substantial impact on the water utility's net income. The CAP water and recharge costs continue to increase, substantially impacting net income. The costs associated with the CAP water and the recharge will be approximately $176,961 in fiscal year 1998-99. By fiscal year 2002-03,these costs are estimated to be $314,328. Plant Additions And The Hook-Up Or Impact Fee The utility should have as much storage capacity as financially possible, so that it will not be forced into pumping during the daytime, when electric rates after de-regulation may be higher due to pumping during peak periods. Peak periods could be from 7 AM to 7 PM. Increasing the hook-up fee or impact fee will decrease the need to borrow in the future. Hook-up fees or impact fees are a source of cash, but do not impact the net income, nor debt service coverage. When The Golf Courses Leave The Groundwater System, There Will Be A Substantial Impact On Utility's Net Income And Cash Flow When the golf courses leave the system, there will be a major impact on revenues and minor impact on expenses. The expenses that will not be incurred consist of meter reading, billing and collection, and power costs. The power cost is approximately $0.26087 per 1,000 gallons of water sold. Golf courses, with the exception of the Vistoso course, are paying $1.71 per 1,000 gallons, which has a substantial impact on net income, as the incremental revenues exceeds the incremental expenses of serving this customer. Please turn to Tab 3 The Vistoso, Sun City, Canada Upper and Lower Golf courses generated $847,141 of revenue in the twelve months ended November 30, 1997. These revenues represented approximately 26.60% of revenues from water sales. Note on page 1, that the operating and maintenance expenses represent approximately 35.90% of total revenues, while depreciation expense represents approximately 23.50% and interest expense represents approximately 29.40% of revenues. 5 Oro Valley Water Utility compares to the companies followed by the National Association of Water Companies ("NAWC"), in the 1996 Financial Summary for Investor-Owned Water Utilities, Economic Research Program as follows: Expenses as a Percent of Revenues NAWC Oro Valley Operating and maintenance expense 50.10% 35.92% Depreciation expense 9.55% 23.48% Tax expense 17.60% Interest expense is not aggregated,thus no comparison is available for interest expense. The income lost from water sales to golf courses must be reallocated to all other customer classes. The reallocation will result in all other classes of customers rates being increased substantially. Please note that net revenues or net income from the golf courses totaled $689,863 while the total net income of the water utility was only $500,945 for the twelve months ended November 30, 1997. Please see page 2 of the above schedule. Possible Changes In Rates Charged Customers To make it easier to gage the impact of an increase in the monthly minimums or the commodity rates, I have prepared the following schedules. Please Turn to Tab 4 A $0.10 increase in the monthly minimums charged customers results in an increase in revenues of $18,677. The $0.10 in monthly minimums is higher for larger meters. The increase to larger customer is based on potential water flow through the meter, or the demand a meter can put on the system. A 5/8 x 3/4 inch meter can flow 20 gallons per minute, while a 1 inch meter can flow 100 gallons per minute. Thus the increase to a 1 inch meter would be $0.50 ($0.10 x(100 /20 gallons per minute)). The higher increase to the larger meters is due to the demand that a larger meter can place on the system. The monthly minimums for each meter size are shown on Schedule A, Page 3. The $18,677 includes revenues from customers using revenue annualization methods to year end customer levels at present rates to June 30, 1997, and revenues from 780 new customers to June 30, 1998. Because of the three year phase-in rate increases to "City Customers" increasing the monthly minimums by $0.20 will not produce exactly $37,354. 6 A $0.01 increase in commodity rates results in $22,772 in additional revenues. These schedules are labeled as "B". Possible Rate Increase Scenarios (Please be advised that no conservation or weather impacts have be included the in the following rate increase scenarios. Southern Arizona experienced less than normal rainfall during the years 1994-97.) The following schedules result in increases to customers in the amount of approximately $234,766, the rate increase being recommended by the Water Utility Commission. Please refer to Tab 5 This scenario includes an increase of$0.34 in monthly minimums, no increase in the commodity rates, and the 2,000 gallons included in the monthly minimum to all customers is reduced to 1,000 gallons. These schedules are labeled as Schedule 1. The increases rate from this proposal are $234,549. The advantage of this rate design is that conservation efforts are being made via the reduction of water in the monthly minimum. Additionally the future loss of the golf course revenues are starting to be transferred to all customers. Finally, the increase in the monthly minimum adds stability to the water utility's revenues and resulting net income. Please refer to Tab 6 This scenario includes no increase in monthly minimums, an increase in the commodity rate of$0.024314, or $0.02 or $0.03, and the 2,000 gallons included in the monthly minimum to all customers is reduced to 1,000 gallons. These schedules are labeled as Schedule 2. The increased rates from the scenario with an increase in the commodity rate increase of $0.024314 are $234,769. Unless fractions of a cent are used for the commodity rates,the resulting rate increase either exceeds or produces a shortfall from the Water Utility Commission rate increase recommendation. The increased rates from the scenario with an increase in the commodity rate increase of $0.02 are $226,945. The increased rates from the scenario with an increase in the commodity rate increase of $0.03 are $245,081. The advantage of this rate design is that conservation efforts are being made via the reduction in the gallons in the monthly minimums, and the increase in the commodity rate. Additionally the future loss of the golf course revenues are starting to be transferred to all customers. However, an increase in commodity rates means that more revenues from golf courses will have to be transferred in the future to all other classes. Please refer to Tab 7 This scenario only includes a$1.77 increase in monthly minimums. There is no increase in the commodity rate, or change in gallons included in the monthly minimum. The increased rates from the scenario with an increase in the monthly minimum total $234,293. The advantage of this rate design is that the future loss of the golf course revenues are starting to be transferred to all other customers. Additionally revenue stability has been increased via the increase in the monthly minimums. These schedules are labeled as Schedule 3. Please refer to Tab 8 This scenario includes an increase of approximately 6.00% in the monthly minimums, and a 5.26% increase in the commodity rates. This would be an across the board (all customers) rate increase. These schedules are labeled as Schedule 4. The rate increase would be $235,329. Using whole cents for the commodity rate make it impossible to exactly match the Water Utility Commission's recommended rate increase. This scenario does produce some conservation effort. The increases in the monthly minimums increase revenue stability. However, an increase in commodity rates means that more revenues from golf courses will have to be transferred in the future to all other classes. Thank you for your time and patience. 8 Cost of Service Study and Rate Design Rate Base or Investment x Rate of Return = Operating Deprecia- Revenue Operating + and Maint- + tion and = Require- Income enance Taxes ment Costs Steps in Allocation of Costs to Customer Classes Allocate Allocate Functionalize Classify Costs Costs to Costs > Costs > to time > Customer Periods Classes Functionalization or Classification of Costs Demand Commodity Customer Function Function Function Production Production Meter Treatment Treatment Service Transmission Transmission General Storage Storage Transmission Transmission Distribution Distribution Cost to be Cost to be Cost to be Included in Included in Included in Commodity Commodity Monthly Charge Charge Customer or or Charge Customer Customer Charge Charge Page 1 Cost of Service Study and Rate Design ICost Assignment/Allocation to Customer Classes I ICustomer Classification I I I Residential I Commercial I Industrial I Wholesale Public Fire Authority Protection OR ICost Assignment/Allocation to Customer Classes I ICustomer Classification I I Meter Size Meter Size Meter Size Meter Size Meter Size Meter Size Meter Size Meter Size 5/8 x 3/4 Inch 1 inch 1 1/2 inch 2 inch 3 inch 4 inch 5 inch Meter Size Meter Size Meter Size 6 inch 8 inch 12 inch Page 2 .......CO dr ON 10 O l0 in M H l0 In En C1► I.-- H N in O in O r-i in 0D l0 M el O) in M r4 .-1 N l0 N ri l0 dr M d' In H 00 dr l0 N l0 O\ h 0 in I M H, M in b 03 in r M N M H M, 0 M i r !O In N O i Ul in in N! iH er Ulf cr • ! N i i N I V} V}i V} V>I to t ! E i i �p i 1 i Ul r h d' M i Ul N N Ti i 4-1 N H d' O\ CO i CO O 1 r-1 i Ul i i r-1 (11 H MC) in H! dr i 0 i 0 .i i N! i0 N N illi N h ! 00 .1 Ul Ul! h .i O Co i i N 1i V- V?! V} Vl V? • ! i • r H l0 h r-i i to dr ill H i i \C) Q d• l0 00 i 0 N i H dr i i ifl to N M i h M i CO CO i i= 00 r-1 O M rn r N! i r-1 N E N dr H i N i • i • V} V}• • iV? V? I • • • Ol O CO ri 0o: h H i r i in i Ul H h O ,i o, En l0 in! N O d' d' r-1 i rA N s H in i CO .i rn r-1 Ni H O 1 h Hi °= O Hi Ol N CO i !ln Q Oi N h I CO Hi CO I f1 r1 • • • • • Ol CO h l0 Oh h h , H ON N O 'dr 00 i 01 .-1; CO N i : 01 in 01 N lD r-1 til I N Ol I`'i' .-1 to 00! 1.11Wd' i h Ul Ul( 01 rn d' •i t in i t0 i • i •i i.... i • • i or i • 00 H CO H 00 i M in! H : dr I H i N 0 M 0 l0': N C i h i N 4J i H In N it 00 h H U: i 001 i= H qtr • lO i111 O i M i C11! ,� r"i I M ,...i ..-1 i 0 H i ,d• 1 •' 0.) Ql I N N! r/ r-1 i •'r { dr �. tJl i i N I U It 1 in VI! V• VT i tf) ! (C a {• !• i • • 0 i h H 1 h CAcr i M O dr CO! i, h in CO h o,i O O! M I r-i i 00 h N chi H CO d' l0i co . pl i y NH W i M H N 0i i 13r M N: M •h _ • • H r♦ !l0 V} VTi VT' VT . • i N Ul O .r O i CO N r O i 00 O In CO N i h d'! N i N i co H H in hi N cr 1 M I dri i- N M N CD i rr d'i O iO I N M r-1 d'i d' O Ol •i M Mi N r1 N I coi r I ` O, • r1 • O V? (R i V> Vt i VT •• M i i \ _• • ! 0 i H I N co H N 00i N d'i l0 CA`: O\ r-1 l0 in N i 00 to CO N i = N -r V) H -r i h MI in i N! its i Hdr M co Ol r-i l0 i dr! in to i En M •!• b 1 i rl , O b UI :H i i 1 • to 1J i W t (� • • i • • H W JP H Eninl h yr H i dr N• i CO t0 i H 1, Q• 00 w 00 H i l0 in! dr ! N i H 1Oj U) N Q\ rl O N h d' h ! l0 CO i U) J..1 : `: .I N I U) i= l0 l0 H 14 l0 H CO i Ni U 1 0 i H 0 H H i N i •i C4 0 i r-i H H :• l0 ' O! : 1 a i H0, 4) in V? in. in in i • • a -H • M N 01 d' O1 t0 O ri dr Ul r I ---dr I M l0 \ Oro = Cr .-1N EnO I. dr O M'' Ul r-1 co in On i\ O in M H H O\ CO r-1 0! CO 00 dr 0 i CQ• H 'r1 M l0 dr W N l0 r-1 O\ co Ul•• O in cr CO a J-1 x i N to h M co N .-1 i l0 w 1 •-i (n id i x h r-1 H: w M I • m ra (n O u i. N M{ M i I-- , ! 1 v u i\ ,-+ i v !Ul , G v i V} yri V? .i v� i, O N if., i ii i w Ca X cn i • i i 0 dP i 0 O W i o0 d' Q\ MD O W L11M .i l0 to i to i V Ol,H 4-1 h r-1 N to O Ul O H Ul i 00 1p M i Z frl i cn ,O O i C71 Ul M r-1 r 1 N lD N : l0 r1, M :H dr:.� U1 ! U O r" JJ . co dr l0 N l0 01 h O U1i M HM !H M H ro N CO to h M N M r i M i O el i h i 14 •i 0 iLi-, N 0:: Inin! in ! N I U co N 0 iH . z d' Uli rr N !H • i i N A i ✓ i V} in I in cn-i VT i i C' > i ! i\ tU 'M • • (n .O • /0 W — N CO co 0 • • v i Cwu (n .0 N 0 in a i C w U) W (n a 0 i O C) a -- H H (n - co (CO i I.r-i Iar w C1 —ool as w .o W (wig w a — n --1 (C la H > Z a) (n H H =0w4 wC � UO co a ) 0 og U EE I Z H E w cr.. z 0 Z w aa, a o Q W > O U O w W .0 W C4 0Hi `� 1 > a U H H W > 0 u E Z a W W Z > U H C U w Z (n 0 W a (n ►--1 w W w (Ct C4 a cg Cil H E Z O H • WW U W O W U PN H CO \ H (n H 3 U H (n (n H W I. WH H — 3 E 1-1 E Z a HZE H 0HZ 0 z H ( �d '• OI H N M '1.1l0 h 00 O r-1 N M [r Ul l0 NM Ol O H N •r1 H H r-1 HH r-1 H H H H H N N N r) Z _ . • • it, til• ri In i 00 k..0 i cO 4--i 0 • , • ,i kr) V I c'l CY,i • • . 0 U) - , , - -, - rn1 • • • • 0 , in LI,, rn H i cn (0: • • . 03 m cn; 0 rn i t-- En; • • • 00. o; in ln i to el, , .. •: , . • • • 0 E-4 En in i (0 • • ; CA • • • • • . (h.i• • . , VI- til 4.1) 4O•i CA . • . . • ! . ...... • • 0 0.I . . • • • • . v•-i cn cs1 i En t-i N C-•i 01 i . ,--. .t.ts o --r i tr) ch i ..t. to 1 o! r•-• 0 - ... -: • - ./. to 0 En N (-j N .,1.i 0) . : (.4 •; crt to . • . ; N 1 • • . m i • • • • • . • ..„ . , • . . • • : • • • • . .14,; • de r4 v in i Ln o i to 1,1! 1.i cn rl 03 ,i N Tr i c0 C:,I c.0 i 44 = o kV C-•i r•1 el, r- 1.; ko i el ; ...,.. i --: de . r., r-; co CO 1 ,-4 a,, r•I 1 W •••1 " •••, - r,, ', 0, . • • , • • • : • N i . I • • ! • • CO- . 4/). 4/N1 4/)- i • • ....... • . . : • . • 0 N N, N UN; N N: N i el c0 cl H i cn .; co cv i rn; co to in 0 I . co i rsi cn i m; oN i =0 • • . : • . r4; • • En: En; En CA i tn. Ea! . . • • • . • • . • . • . i • • • — • • • • de co r4 ,i , 1.i H ch! - H i in LA rn N! or) •,i.I , M i r,,I 03 NO; 1 i , Ill 0 I rn •11 CD1 rO , ,, , 0 44! 0 ,4 i •,4. fl! o! T1 N r4 ,, r-i i V rl i ,, l0 01 (0 •---- •, .0 b) • . . : . N i • • 0 irS En tn.; EA 4/1., 4/). 4.0.i En 0., • . . • • • •.... . • . • . i • . . • • A*, 44 : • i o 0 O M H ,, to — -i - -! - cn I •i 0 w 1. N N; rn (0j N rl, N i N g M N! ri . to : . • : • • • • . . . • En.i • CR VT i tA• ,...,I En.; oi . • . . : • . : En •••-• • • . . . . . • • .E.i ^i de irl — • • . 0 N c0 i co 04: C.- Ch i N U 4-11 kL) Ifl I r- ,i ni ,i kJ"i el , o AD I rst rn• , N i CD i 00 i t. ., - -: - O I -: m W . co .1. .1 .1..I o 1 o N.:1,, .1.i e , v , N! rn , ... .__ ", , ; Ch 1.1 N i Nu.,i N! .1.) ! - c, • • cso cn • • • I ,--. •i . N • in; En En! .. r•L i ! En! rn • ---.. • . • • • • . . .....,...... . . • • 0 A • .• . • : • • de , t.1 00 c;r4 • N; N in i to ,I.; cri! ri N t•-• CD i co r4! co (0.; N! co V N r-! N Ch i tr, c 1 i N)a i 0-•I ^ s i s CO I 'i co _ ... ... O N coCT, t--i ON r-; l0 V i Ch i 03 LJ 0 -...... u., /4)! LIN • ol (0! •• • • In .44 i • r", it.,: i rn I . • r4 II .•• V i , • N 03 i i • • • C) 0 . • ., . •.,. 4A- • . ti). 104) , • • • • • •V ....... , • • • • • . • 01 . • • H - ,-. .4. En; 1. (4! oo CT i 1., CO ; ..• -•i .- ,, 00 0 V ‘.0 ,i 10 i to, er 4, .. r-4 , ,! H r4 i N ,,44; H! g 0 A 44 (4 ,--., ?-4 i ko o i . ..1. , i ,i • • • .-1 • , • • • . • • 0 •Y4 0 . ..i . 4.0, . I .i .,„., ..4 • • . i i • • -`,.. 0 -04 --••- • • • • th•i . • ‘741 in a , N . fn 01 • • ON i C13 ,; cri to; • rsi I en I"-i •,-i En i ...I • 0 A 1. o En -.... „ ri En r- to! -i cy,; - , - .! on s i .... to op i ,o r,3 i H ch i si. .1.i crt rn 1 tk•E-)1 ... v•.-,; , i - `..i , i-- En; ; cv rn I . • • ai• En in I i •: . cs,; CA i i • • 1 li 0 ,I ; OP i in= tn oo, i , de o Op g 0 14 En in I c'fio) to 1 rn En I i 0 • i • o (U• 44 M , rn i o ,-•- r-- cn: 0 id -.! En in; tn fn I • 0 > . i N rn 1 • • .• • CU • • . •, re 1 tly, . t.n. t.0-1 tA• ,,,,I .. . • til•, , • En it ID H — tli . U IN in Civ •ri g — al L. t rc.1 W to — VI CL) }.4 0 W O I tri U CD En Di c,2 0) En O (I) 2 m 0 iii En - W 0 0 Vi CVI . rel ‘t. E. 8 . W c4 re ill r4• rti E. U U 1 g '12 0. — W IS rtS W W A 0 Z H O. c4 oe tlii — EV -, I co co Ln CO H Ln CO H H 1 H H 00 H N H in H H M H H H H 00 M d' N N CO L- - CO 1 CO CO 1 CO M m L 1 H . H - . Ln . PI H al N H M N N N N VD N d4 l0 N M CO N • CO CO CO CO rl in N O CO d' 00 N in H 00 H - In N rl N N • o „No • o\CO CO CO CO CO CO CO CO CO Ln H N CO N I in CO N U1 CO Ln O CO crl O O O O N CO N N O H lD 0 00 N rl N N rl d' N I N N I N CO 00 N N U - H - - in - -I H r•1 H H to a) (I) M O ,I+ rl M -I. 0 0 dI C l0 Ln d' H li O in r--I O • H r-I H r-I N in lD in N a) CO 0 10 (4 H r-I it) in to rl U rt0 N tn. Vt. tA- to a o\o ovo Ln CO H in CO H H H H N N N CO el M Ln rl rl rl rl M M en 00 Co N L- tD a) in N C- Ln 0 r- I r, N I N in N co N - U - H - - in . . . . Hi -rl N CO 01 N rl CO CO CO CO H o H d' 00 in M CO • rl M M rl O N Ln Ln U CO CO N H N H N - CO (0 H rl H U) O N a) rl VI- li \ a) H o\o oho d' co in - CO in in in in H co co ' in l.i U H H N H rl N N N N M Ln M CO H 1~ fti (0c0 CO CO co 0 CO I CO CO I CO CO N d' N a) r'(i E . - CO H (1) 01 0 O dr rl O M rl rl M rl d0 in N CO U) N cd V lJ 4-4 co in r-I co • H H H H Ln N O N r--1 H ? O E U) Ln in in N rl 0 H H{ -r-I H W Q E U N co-H gi 2 H 4-1 W -.� H E -H O E r-4 P H• O ) O W H e li >-, o v �- b U -2 0 .� H 0N U) W - E 0 E as H Z 0 ._ --� >0 0 o -H rd 0 U 0 al 'O 0 a) -d rl U a) a) -0 rti 3 • O U) 0 u c U -r-1 W H cn �°�, a) X IC-15a) a) •?-1 N a 1� x U N 11 rd u) .� (t3 •r 1 tin 1> '� 0 a, IJ 4i 0 a) 0 N 3 a (d .0 co > 0 O O s-1 a) E a) U) rto 0 rd H XI X • U) O w a) a) O O E a) H a) 0a) U a) O a) 0 l.� O O O - 4__) rd L U E .� o U) b U Qa U -H O 0 v CCICCICCIE a) H 0 a) a) ? -- a) S•-U G a) U) o Q, 0, [I.� o 0 H Q, U N -H N 11 11 -►i H G4 Q41 --4 45 U O rti X -H N b � 1 0 X 11-1 l , 1-.1 G Q, 0 ,.Ii W ? N Wu)rn U) O X E 05 ii S•-1 .0 - 0 - 0 0 a) (t) n:5O S 1 a) o Ix [!) 1l U ?y 3 a) cn H a) U) U S� rl 0 s; 04 a) a) s-� .4„) 1, E U au L a) 0 0 H 0 E 1 1 1 a) Q) 11 r 1 11 a) .0a) 4) V0 S•-1 l.i .1, O X n 0 ? E .s� N C a) a) 0 0 c H H O O N a) a) a) •r-H Q) a) E x Z a) 00 a) a) U) O U 0 W E rd E E L O U) a) SA S-1 U 0 a) 0 O a) .c .0 j l.J .1.) 1-) a) Ln CCI U) a) a) H S S-4 U , U al 1 d4 s~ cn 0G 124a) 10 a) RS 1-J 1--I a) O O -►--1 U) •H Q; O - N X 0 a) N U ? E I n 4-1 4-1 0 U) 4-a 4-Jcn 0 L rl H CO U H1 r-1 U O a) a) 0 rti ni N U II N — RS L j — RS al a) 4-1 c1 4) U a) O r-+ a) a) N U co 0 cu X ? ? ? 1-i O 0 .1J a) ? 04 E E .0 c4 -H ci cci cn H O s -d o r--1 -H -r-1 a) E r40 H (IS 0 E aO H) O O 0 ? O H a) CO �- r-1 4_is-1 cI s-I O R', 0 U U a) 0 0000U Cr) r-1 -r-i ? \ � -H g1 E 1-) d U U 0 t: 0 S-r a) 0 0 I- -H GQ a) c LIl ws� W W b •r-1 O U) 4i a) 1-) 1~ ?r 0 H H O 0 to O s; al m04 co 0 0 -4 lJ a) Z lJ a) H XI 1-3 Qa 4J -r-i a) ..0 N l0 N E U S-1 s-a O -r-1 a, 0 a1 0 r4 a) t) to E a) - l.) ? 0 4 m s-i "E a) rd a) ro - c01 O 0 O a U O a) 0 w a) c a) a • �sZ, P, p, a) O 4-1 0 E 4-I a) r-1 -H -r-1 U a) -H (X d) E --1 r--1 ie U ?r 4.) 0 N 1-I O S•-1 Qa ?-+ _Ii li E U E U a) o a) al a) > a) a) a) -r-4 H U) -H (I) -H -H 4.3 0 0 X , O (1) ,-1 o a) to l.J V ? t7) to to to ? .0 a) a) a) a) .J -H S--4 S-1 rLi O 4--) U Ob U) .� H b -J C U U U U O its a) s: rli 0 0 OP a04 04 0) a) H O 0 CD O M U a) 0 4 , .0 .0 .0 (f) O H 01 01 H 01 W. X W 0 0 HUQH O Z U — t/) Wu .e U U U — X E CO ao N ao w N COhrn U) U) X rAi >, E rN E • . . . . . . . • . U1 N E .c E 3 0 -,4 0 H N N d' •d' h CO tfl fn H h iU .ri H H M N '-' + _rCi C C r-1 O F O -H H 0 h , F E •ri c:l — H m N•ri (d VE to VT VT VT in.tR VT VT VT tr) rn C to h U) U) k lD h N ao w f..( O Ul Ul to H U1 l0 rn h CO rl li•ri O (U rl rn (0 to r h o to rr' -)' .r, lD N cO r-1 M Ul m H h H b O O cy H N r-1 r-.1 O N O H Ci 'd n' 1/ 0000 0 0 0 r i Ul 0 O o r i N a) O rn 0) H fr. n, v N r-i rd C Q H 0 t7 (d O U 0 o 4.6 VT in. VT VI lR VT VI- (R j V) . U rd 0 VT tR VT to VT U) in- VT tR VT H 1•-1 m to ao Eo Ul to lD h Ul Ul r-E?Ul i C C ( - co M H on Ul N O d' N lD 0 i In M to U) Ul O Ul r-1 O M i Ul i H H ,d h M ri Er) h o r-1 M tCO 1 TA i H H a r( lit N d' r..i M M lD cM i(Jl i (d (n H H r-1 Ul 4--4 i N i O i ri 4-1 >, d' M h O h er M H Ul N i O i ,d >, , CO lD h 0 1113 h l0 l0 lN ao 00 a) L., d' h Ul kr. M d' co N Ul tD i N i ,u H M rn In to h h 10 to d' d' O v E ••-1 rn r- N O1 h h O cr lD O lD i nD i v ., v r . _ ai N a N H N rr-1 O N O r-1 O N Q UU0i1 Hl ' \ r1 M \ M N ri iN i N H W '64O > ft I !7 W rZr` , N H N 0 6 O i pO N i M i CL MO U t) O VT VT VT VT In t/T t/} t/T ut tR H In i i CO kr, H co h o H Ul •) co i M 1 r-1 E• a) N a) ao r-1 M mH d' co co H ,r,;h j ✓ U a) (.( E Ul h H (D H v' lD co OD Ul i r-i r1 H r' �[ v �• 0Ul r-1r_.4 [ 0 O h Urrli N l U) O H Ni d0 i.0 v v > niO fJJ- 0 U) v H i •r-) R' VT l tR E i i ,d rn to h CO M h N Cr to N N N v Q) v N l.00 to In to , CO DO 01 i In i tD N h UD r-1 N o h r-1 d'':H 0 ,C v --4 v L� p,t0 1 N r-1 h d' h lD co N h h i 4f)i v U > , mU U M ,r) h M r-i O H N h i M i ) v p R: m , N r-1 ri M O; �- g0, M '(n' i I i E N I O ri lP In Ul O O M d' N N i 4\i C r-1 r-1 1-1 H En r-1 ri H H O 2 H 0 Ul h h l0 H h d' h h h i in i >. p h h h h d' h h h h M -r1 1`I rn d' Cl to O M h03 N N N i H i LJ o N 4-1 • CO W CQ a) C - •i C .r..1 v ,.-1 r-1 H r-1 r-1 H H H H r-i O rdN Q\ k N N . M r-i 0 03 00 CO M , 4-4 CO M M U) v b Q' (b 01 C U) O in O h E 0 H h Em . v -_, .3 0 i i a, U o >• •� �• r-1 UT VT tl} V} VT VT VT V} tl} V> od i• • or O d' M CO N et, d' Ul H H i N i 03 Nd' to d' U\ r r-1 h i W rl r>_•,1 U UI `4 Hi h y • ✓ • v i • 0 al to f--4 a0 L) r O 1 r( i H I V 0 O i v a) N 'd M o CU i U v a) z °a C to °,, H U rd rn Cl. ra to (d >, >' ^ ^ ^ ^ ^ r-1 H to Ut M r-1 O h N O d' d' H M N h Ul 10 V) 4-1 U\ U U oo co l0 h rn N Ul U\ lD UD Ci Li U1 O CO O 01 O 0 lD H W h f 1 C co (U (rl Ul l0 Uf' h lt. O h N N C E O C a) M M r•1 l0 O N OD N V) in W + p r-1 N M d' h M h h O C - p .d -- r-r N tD rn rn b b EO C Q r-1 r-1 N N til E5 (,) ,H u .� �. H r--r a) N + CC .0 4J H E G' O U U rr2 >.,.i UA 0\ i. U , E •H H Ho H O \ Q1 u H x .3 Vn V T VT in. to VT irk tVT to U VT Vo irk tv, V)•tt? r•1 1-, 'r c H a h h U) d' U\ Ul O Ul aO co C O M d4-1 t13 O rOD l0 TA Ul OD U W O UD M to rO h M h h ..i >, 0U CO 1.(1 0 4-1 l0 N CO Ul d' M to O .d0 Cv 0 WiEN 1rN Ul ao rh 11) M kb 10 v d - O 'd O o h O Ul co h aD lD co O co d O 'd P lj.) ( to r1 N t l O O 0.7 L, •i NH r� H N o V' O l0 d' co N Nd v C CrHi • M ri H rrv' p+ rdpt4 rtS N A E C U Eti ECi N l'' 14 H , 0 0 U) u E 3 t H a o .14n. tn.in- t!}t/}in, in.t/T vt H (1) 0 H E 'O ami a7 3 A a M h d' N to M CO to 0 0 01 H (n O rd () v l0 O r•1 O M O l0 M h h y >4 '142U A H N o ., 1� H d' co en r-i V) O r4 N N 21 * N ad ,a 4' to b Hao N w CO , U3 CV r•) N H E .[ N a E•+ m ti) •r-i iiicn U Cu W C a in. v} U E H M H \ > W 0 >4 H a Q t0 N U1 to to U1 to to to Ul Ul kr) b ',, m O N b co d' d' d' O Ul h v' ch r-i i ["� E H r-1 ri H H ri r-i H r-1 r-1 N ,� 0 �+ Ul CO h CO 01 h CO Ul Ul l0 a • U ( ti Z+ —, p M M rl M rl rl M M M M Q L E N O C O rl r-1 h h h to co to en O U) .0C; •'� .0r-1 ni V H H N N rl d' h rl r-1 h .04-4r i M N .0 N E' A S U U in (n vT in- in in. in VT in in W F -i t7 H to V} v} VT V} VT in u} tn- VT 0 O v) C' 'd b 3 g O N U E U) v u 1.4 0. o. o a ( v C M >•,0 0 0 - H .0 410 O >; U O O U v Ni -H •. •H U U u V 04 w v r{ ) n ,i U u u 0 ^ '� in O C b 0 O 1/40 Ul O 0 O U Ul rl Ul H ca E 'Cia' H a) -r-1 > co H N. in aO to H N U, O O Es) ri 4'1 CO to 0 0 O W U v ,.-1 -rI \ O N r i r 1 in co h 01 dr O E( MO Q) Ul N h h OD h \ H` U3 fn rl 0 1.0 fnrl H U) W 0 UD 4•1 rl to H H rl b U) CO U ti, (A in~U) V}VT 4.4? X CD ' (U 4J rn O U) ' co Ul EllE o to coao to o 0 o to o 0 0 \ ci N h rl h o ul o h En o o to 7.0 W ^ C C E - 3 O O O o O O O O v E (V O 0 a, aD ao h l• •rl • • • f i O. • p' N H E C7 v HO N 1^ OH H O M Ul O o 0 N C -rl H H N d' h OD Ul C' CO 0 0 O (d UP v 0 r'-' r i r 1 N N a .ri L.) U C 'a' r� N d' h h WI C U C7 v a x .,.i H in.v,vT in. 4 to vT vt in. v} 4--1 -ri rd a' 3 4-1 as H = v = tll -ri ou d' H w , H w GO = ii _ U a1 M N (ng H U) :14) M N U H v N H yam,) ar \ c c c c c 0 c \ = N c = e = O b) al ri k,' r-i ,-i N rl I' l.0 CO C7 1-1 •ri ,k, ri ri N v rrl d' lD co u b O V) Il,' c a) ))) a N l) co H = co H _ G) CO U U r-4 l0 CC) r l0 r, rn N N N X , ,c U, N m r-1 N \D O r 1 -r r i H 1J .--1 (' • E E .3 4 oo H CT ,..0M00 I. r, r1 H N., N d' r r, sr( r .1 H N N r-1 + C .--1 o •r 1 .r{ C O .)C r-1 r , E F •r1 O i... (d r� in in in VT VT VT In to VT cn tr) C ›+ l0 r 1.0 /ID \D \D r N CO CO r., r,'' U 0 in l0 in in H to (c) ON r a0 ,M-1O 2 r'? rn U) U, r r lD to -t' d' Q1 �-I le, N CO r-1 Pi CT 01 r-4r r-1 a) CI' v\ O i ni v 0 O N ri N H r-I O N O r-1 O 11) O 0 0 0 0 0 0 0 r-1 01 O -1 N tr) � E C C7, E a1 N r1 fd C H 0 0 400 1, O (> VT vT vT VT sn V) . VT in U a VT V) VT <n vT VT VT VT VT VT U i r1 },) (!1 to CO t0 O, () \D r 0, O1 H U1{ )J) C 01 - (0 rl H 0, 01 N O d' N l0 O in m to 01 CT o to r-10 r, tf, _ rn O r♦ o ,-� r M , l0 r l0 m M r1 CO ri r-, b In to N I. , r, rl l0 d' 0, O r-1 r-1 r-) to r 1 N C7 9 r-1 N N C H , d' ( N O N d' N H rn N O 'd ,. C{ r, m to to r r lD N d' c0 Q1 '3' r 'C'T,' l0 r, d' act 01 lD Ntfl 11 Q) ri N r 1 N rn r N O -t' lD C� lD m .,-.1 a) ,-i . C b al rts N H N H , O N O H C7 N m a, 0 O O H to r,' 01 r1 N ch N N H N tri.), o N lD O In N N O CO 0, Cl r \D Q+ N -- Qi1 +) a ate'. (-I , N ri N r O a) O o Z 0 CV n, 0 (0 o OII U U )x O VT VT VT VT VT to VT VT in- VT " U1 Co l0 4-1 CO r O r-4 CT I. CO M O N (n co H r+, r, r1 d' ao a° ri r r-1 m r r-1 aD r-1 d' lP m m t1) r-1 r� r4-1) " .1:7 '11E C) (O r -r to N /n 1D O H N lD r 1 r 1 C C C U Co r-1 ri d' -= 0 a) ) (ts 1J c: Cr,.1 Cl) O �� F-1 to •ri VT cn >7: i i } Cr, U1 r c0 r, r N d' to N N N N a) v N l0 O in r-1 co co O, to C �) to to lD N rlD , N O r r-1 , ri C (,) O • a) 'ri C iJ 0 1) (v H (- d' r lD m N r- r- to ri -I; .. a) r11 O. .it m r•, ,0 r• r, .1 c, r1 N (- r, U 0 r () , rn ,1 (, ,i r1 r•, r, cn a' a) ►� ('' O r o 01 O i up tO rl aD d' 0, In C rr-1-1 H r-1 to H r-1 r-1 H O �/ H O 0, r r l0 r-1 r d' r r r to ✓,., O r r r d r ' r r r r m d Cto ' .1 t, r) to O N r m N N N H U O r 1 m b 41 CO a) 0 C •r.1 a1 H r1 r1 r--4 H r-1 r-1 4-1 r-1 r-i O t, O N co m 0, m r r-1 (7O m r, lD a) b O+ Rs Q1 X " Q) .� .>. r-1 r r N r 1 m (n 0 N (7 r 0 i-) b � E u o (;) •r1 •C- C7 as 0 0 C U O ri "VT VT VT VT VT VT VT VT VT VT a) • r1 a ›: i O •y' , co N d' d' to r1 r-1 N 01 N I. Ul Cr 01 rl H r M $.4 -t' r1 r 1� a) td 4-1 q .� 0 1 0'11 0 y c� C )) 0 7 m 1 j a 0 0 (0 H Cf) a, to ' Cl) ; �i1 .-i r-i •-i a) in chm r-1 O r N O d' d' '-i w M l0 N I. M0, U •C • •*, 1 7O C0 In r o, Nin r, lD lD C -C O d' O U, l0 co r. to ^ Li ,1 1.) to O to b O . N + 0 m 40 to m lD d' r ,C, r N N C e O C a) r-1 to d' r O VI CO N 11 ,n a) 0 ri N N d' r• m r r No ) - O .0 '-' HN lO O1 M td td E; r ' F o H H N N O F E N r-1 r�) .- — '- r� H O o -- + E 0 C _ .i d' C u F U ,9A H ri U a) U 101-0 F • vT cn to VT in to VT in VT in U 3 in VT VT VT VT VT v} 1-4 .0 - M U a b r r d' d' 01 O, O 0, co oo C O Is N r M O r l0 CO CO a0 00 >.W ,� E o to to to r lD rn ,n o co CO to -) 0 a) 'i H N to CO N r l0 M l0 l0 co .O C : 0 '0 H N 0, 4-1 0► CO O 01 r co ,S d CO ,J /-i l0 1Jrii In r-1 N In O O dl) N r--1 r� N to I. O r I. O N O .0 N O W F r H H CO O C 4 -N U �- ri ri M d' •d' o a . E C U 0 •r-1 1J )0 C .� �. H U 4 VT U E ri H a 3 VT . VT VT VT VT VT VT VT VT v►• E. u H b a) a A [ tX M r d' Nl) VI CO to O O al H ((f a) lD O r-1 O N C7 lD N r r j) N Ozic y NAE N -' Vri 'i' mM am lND rO nDri lN lN0 NI ,, rrdl (V EE u N fi ni N OE+ - i s u) p„ 3 a: VT V} i-3 x E H \ 0 › Q > O 41 in to in to to in in in in to '0 0 N 'O ri to OD r O M m N N N (� r, ri a1 r 1 r 1 r i ri r I r 1 r 1 ,1 r( N r-1 5 O C 'a) • N co r-1 N 01 O . d' . r-1 tot • • • • • • • • • C �, 0 )-1 N N m N N N r) N rl M O i E: r� r0-1 C CO r-i 01 lD r r M CO d' ri C '.7 1.1 (a O, C .O r-i r-1 H H N M d' r M 0, r ,C', D U F rtf -I C) f0-1 O -,C•( 0 C r-1 ri N N 1.J H 4 C_► u} +n VT if, in VT +n in if, vT n, - F -r1 C7 1-1 VT VT VT VT VT in in VT VT in 0O a ", o a) b 3 U E to a) JJ \ >. >. ,•. i� � O N �. (� A,;+ N a1 C r, i .1r L., 1-) 1J •r-1 •d -d .G A) U O O U a) '� u -ri •ri r1 U U U U P. a) ra v a, , U u u 0 PO N '� c , n `n o In to o . 0 u ►n M m H in r4 (v, a1 •.. ,a m r1 • Ul m to r-1 N tri O O tD r-1 , ao M o 0 a , -� O N ri ri v) CO r 01 d. o 0 w ilJ a) to N r co r r. H O Cr • iD r•, M o l0 M M r1 C 441 O W ri rl to ....Ir-1 M 1{1 O l) VT VT 1n 1n VT VT VT X, ••-1 a) r--1 O t70 tll u 4-4 , >, . O N 'd In co to o o O to o o O , o1 MS M ,i to C r-, . O C a1 r• M• r• O• to• o• r• ,n• o• O to to • N O '5 W C 0 0 0 0 l0 O N o 000 0 0 U E N ,_, Q, d' CO CO N l0 M r N N N 01 O, r� ('� a1 r 1 N H r 1 O M trl o o O Ql C •d H r-1 N d' r co U1 d' co O O Ob N v i) ft. H r 1 N N o O 0 C 0 d' H N d' r r 0 b1 U C7 0, n0, n, �- f •d u H VT VT VT VT VT VT VT VT VT V,- r-1 -4 r-1 to a) = a) -rr _ ca r-i w d' m r-1 W N — Q) M N r� '1 a) rl N r� 1D a) r„1 N = \ e v = z c ,O Q) N z \ r 1n r r r r O X71 0 -r4 X ri r-1 N r, d' lP CD •rl 'X ri r i N a r, d' l0 co 1l1 0 (n co r 1 z � \ r 1 r U1 to to to �. a0 N r-1 in CD N N CO M CD in in tll CD N M in C M CD M in CO 01 01 rl N M cr in CO M in CD M 01 in in mill M m r4 M M ID O N H In 01 d' 1p in H rl it in 00 in in in N In O N O N CD 0\ in in lD in M H N in 0 D H N H N N H N N 44 r-1 M N r-I a0 in M M N co r-1 N N H 01 LO to O O H 0n N N 0, H 0 d' r-1 M I- M to d' O mill in C7 a0 r-1 N d' M d' a0 N LD O O LC) H N N (- LO N r-1 a0 in in in N oO H r-H LO r- N in O O Li) N d' r- In H 00 M 01 N a0 (X) 01 CCCIII CO lc) H N iD N r. M d' in a0 r--1 r-1 H Mir) o0 I- 00 00 M rl 01 in r- r- M H to CD in LD o0 r-4 r--1 M in O in in a0 N in in 0) in r-I M N CCCIII H H CD 01 00 CD M N lD N 00 d' M N r-) ,--1 in LO d' M 00 00 00 N M in r-i an N rn N lD N M r- LO in N N H H r-1 in M M M Li) a0 in HN to N N in 01 N CD 1 I 1 I I 1 N a, 00 N 00 in CD N in in N N N d' in in In in M in H M (- O in In d' N lD O in r-1 N N N co N N m m M r-1 r-1 d' N a) 0\ M N N 0, c0 N o0 .-i M 1 1 1 1 1 1 r-1 r-1 H (rl in in M H N in H in M '0 H O H M in tri r-4 M d' d' O (IS (n a a) N LO M M lD r-1 LO in in lD N M in r-1 in N O O H 0\ M in H cr in M ' rd M M H 00 in 0\ in c0 r-1 cn 1 I I I I I in a) in lD M in O r-1 N ' 14 H M r-H I- N lD 0, 01 N a0 lD d' O oO N lD in N N N N 01 in I- I- in lD N N M M a0 N 0) M N O lD in M in CO N r--) in Ol 1 1 1 1 1 1 M \ . . O = In 00 in N N 0, M lD O O M N N to M in N H in \ H O N U N TA H > H H H JJ a bW ..... In Id d' N r-1 do lD I- H 00 N N ul CO lD t .. d' CD N CD M O N r--1 01 M O N a0 b 0 N in H N in in CD in 00 r-1 1n 1 I I 1 I 1 In A V) \1 0 rCO M N a0 r-1 d' H N in W la W I .,.4 H 01 r-1 M M Ha) , 1l N M M H E b a O ''4 H .0U U U) t. 0 N In up In a0 M co N ll lT IN N O a0 U O H N to In CO N M 01 In d' M N LP 1. P4 A ddt-- r-1 M M r r ao 0\ ao M do N N in r-1 H H I 1 1 I 1 I LD E.W NIn • tH in op 4i G] H 'd d' N M H N N \ U a) in lD io O -rl lV M )-1 in Id \ O H PI 0 , r-4 1J E-1 W r-1 (n a -,-1 W v _ U CO r-1 N r-H M d' O 0\ r� M N d' 0\ 1d U lD I"- CO H a0 H CO in M111 Ill N CO ' d' a d' d' N lD O in N N lD to co in 1 1 I 1 1 1 (n O \ . aj M b1 in N rn N tT M 00 0o M lD in OCr 9 n d W b 01 M M N r-1 lD N 00 N In H X -r-1 0, N In to it N H m Q4 In 1, W CSA W rI �. o , in Tjm rij '0 H W H b 0 0 co N H in O N H N ao M O L. 0\ in in O I-- M In I- M O M ap 00 01 Q\ M W Z to W N M d' in co01 to O M 01 d• M 1 1 1 I 1 1 _ rl 0 1-.4 a M M L.0Ur O I- H In 01 in in in H W M to a0 to a0 01 I� r� In O N O N > O a) O1 In to lD In M H r-1 N i In a) OMi ` � H .,. r� I� H N p; .. W N 1J U N N I � (0 -H O Z r+ 04 W P P. o n in in in u a HN J�1 }.1 f-1 A 11 $-1 i •• rl 0) a, -r-1 a) a) .-4 w a) w w -, b '0 E U (0 0 'O 'O E O (n W 1:3 E u In . N U0 ; a 'r I W O a O •r-1 $4 H u) E E (n U 1._► u E E In ,., U 0i E E tnn ii U u V H (n A a U A U vii X H .. U A U u)) X E. •. U A U A X E-+ a� w ClE. A in 0 E+ '`C X co a0 Qn N N N rn in M rn r�, rn M M u N N u1 0 H N N N N Ul W r-, Q1 r-i H N O d' 0 CD rt. Tr co 0 0 N N lD U, H l0 kD lf, r-, d0 01 CO In N H r, 411- In O In O in N CO N ,-, In-44 CO N,n O N ,n N CA N d' a) m i N 1 N r,� C� Hui M O a) to cn a a) H r, .44 H m Cr r, a) in 1 Cr Cr cn (1) o H C4 N N H H :o . in N N in CO N r, 1 Ol cel N O0 O O a = N H ch N N N O H H to- u a) W N in in b U o o N co O H cy O I in in b cn Q 1,4r\-, -I. N lD W Wen r, H �( H N r, E. E W (n O 0 aH u cn H o1 V) U V) a) o w rn in .1 A4 s, 0 do H io H ,� H N In in N N • o U In In O -,-( 0 \ O • .a u W Ga v., ,A a u x pq = r 00 in u1 O ,H rn r, o - o M 1:3 (� k r , m a• 0 (1) (I) U) w co O ft 0 - H H E`' p4 m in r, r O W Z ir).. z 0 0 E. M4 N a, in H U r, rn N U) O CO Cr) 4 N N a) a H Hnj H M o r, N ,n a) H N N C4 N N O QI r R4 VI U) H itS a, in O (i to a) u O 0 a a) H u cn L u a U a UH 'O Q1 A, v ,-1 Pa) �t' ,) u ft O 60 u u W U 0 0 In til a) 4 b H 0 to E to O CO H i -H 0 u -H Q., E rtf -H ca N 134 1 a --Se a) O Z d a '�0 0 ua d' d' N d' al O CO O N CO N H in O O a1 d' N N in N O d' O al H U) N N 111111 1 O d' I a) d' d' LC) CD d' N H CO r-1 .. . Rs LI) in in C` M O NMNN d' H In -I--) H H al C- d' N 01 d' N d' H d' O H H d' In Ln M In CD H H N W d' d' N In In d' N 0 O M In N O 0 co Oo N H In in M M MN C` H 0 rn in t 1 1 1 1 1 1 N I in M 0) H in in in H U N N in lf,..:_ di /4 /4N N d' In iD In H H O M In H d' d' H In N H In CO N CO H I I 1 1 I 1 I in I in H M N in H M 0) . H N d' in N O O in N 01 0 O N al d' N N N d' in in in co N N CO in d' H co C� rn N I I N I I I I I I I co I 00 N C` In H co d' in (1) - M in M N In O O N d' d' H CC) N H 00 Cn 'Ci H H H a) v .0 to U Rs Cn Cl N N M H O d' Ln M al N Ln Ul H N N O M Ln CO N H H H CO in lD N N 1 1 1 1 1 1 1 d' N I CO d' H al d' CO M 0 d' Lfl H N O d' H N Ln H H N M M M 00 H a1 N 11l d' 01 in in in OD O O in M C- In O d' H in In M CD CTl 1 1 1 1 1 1 1 Wit C l 1 CO in H in -U in in -U M d' H 01 H N d' in in a) ,-( n 01 d' M d H 00 CO00 H O n in N ' ((CSrd' M M 0 in In In Lfl H d' U) H H 1 1 1 1 1 1 1 Ln I H N d' N H a1 N p; H H N in d' H O M H H O <n i N d' d' H H in O 00 o M al M C r o H 00 O N O M d' Lfl In N - (3) M 1 1 1 1 1 1 1 H l0 I d' N d' d' al Ln M in H H• HN N H M dM C- ' N M d' N H H d' M co 0 H .0 H H RS a H RS W U _ M M al CO al In N H Ln M Lfl In lD al H d' d' H O M In 0 iD 00 H Ln H N IX Cl > N H H 1 1 1 1 1 1 1 M N 1 in CO in H N CO 00 CO H N cn 'i M d' lD a1 H-, H N • EH• O Li 1-) U) O (1) J-) .... • CI) U W d' d' M C� co 00 co d' d' In In al O W 0 (f) in Ln H o CO :-11 in d' C� o d' al In . A COC) = M M/ 1 1 1 1 1 1 I in in 1 in d' H d' In 01 H in 4 (T H 111 N al n In d' CO r- > \ U U H H M d' O -H O O \ O H H .0 ILI r. H -U) U) = N N d' Ln ao N N N M co m M N O -0 x Z d' d' rJ' in N in CO N M CO 01 M 00 H RS W •- N N I I I I I I I H in I N co a) co O N M M 0 M . . . H H O M „ d' N N H MLn Q N CA Y. In N M In in Cl' H M Cl' H H U) 'b H H M M d' M H 1 Ln co 0 a) 44i a) U) O in H I H W• MO ........ 1-4 d' d' 0 N Cl' in 0 CO 0 N CO N H in A 0, d' N O N 111 N d' 0 al H U) o o 1 (Cl 0 Cl) CO Cl' d' in o Cl' N H on RS U ,--1 ...] (1) 0 RS in in a) al N inc O N al N N d' H In U) ►-i 3 I H H 0 C; n N d' N C; al d' N d' H Cl' 0H 0 -O H H dn M In' (d In Lo C) mari ) H N a) (1) -H .v > C: cii a w H 0 CA l -a,� Cn a) b X C Z 0 X s� al o aa, 0 '0 °) q Cl Cl a) -'-I (1) a) -H a) a) -H a) a) U) -H v (1) H -H 0 Cui 'LS 'd E U U) 0 b b E U U) H b 'II E U U) G b Ti E U U) 0 z O C) o -H C, r--+ O O 0 O -H )-, r--+ (d O 0 O -r-1 C( 'H 0 0 0 0 -H C' r-1 H U H a) E as 4_, a) RS -d E Rs JJ > a) RSa E RS a) "� -•-1 E RS i-) a) RS H U E E E E (n .-i '-' --( E E U) C' 1 -0 -1-, E E U) C 4-) H a) f G O a) C) a) a) O ba)Q) N N O U O v 4) N O b O a) Q) N O Q W U Ca C u) F' U n U (r) F' -d U Q U Cn E'' U A U u) x H W Cl w Cl X Cl Cl 01 1 oVo 1 °\° 1--1 00 d' O cn in d' (.... H N 0 in O t-- Ol O N cc in O of 01 00 01 N M l0 N rl l0 in d' co M O O rl 01 M 0 lD H r-1 d' 00 rl N 00 N I I 01 r-i r-1 in cn O 01 I rl rl 0 u) . d' O O H H H N lD d' N 00 co 00 00 O N \0 H lD H H rl RS in 00 d' o cn O1 lD N CO N N CO N N N O N O N O .1, N cc in In In in d' co rl O M N in 0 O . . H H H H H d' H H N N N N H N N N d' O in In lD cr o\° o\° l0 H N Q\ N O l0 d' 0 l0 l0 N N H On r-i d' N N N N 01 VD CO CO t` CO I d' rl N in S-4 co N r-1 N In CO W N U N l0 N N c N In rl 1J in cal in 01 0 N Q) 111 in l0 TJ X (1) a) .-C Ul U rti to a in N CD r4 OD in A. (No rl rl N N d' in rl 0\ in O in c rl Ol N H CO in rl r-i in oo rl in N in H in I cc in l0 U N In in lD In N in d' -ri CT, l0 O cc O lD N In co in t- 00 00 M S1 lD l0 lD O H . H . U) H H H t� d' in rl N N 01° °(0 N c d' d' 0 H N N H in cf. lD CO 01 N 0 CO in OD N rl CO H l0 Nd' 00 d' 1 in 00 O E 0o H H N H CO d' • • 1-1 N N l0 N l0 d' O O In in in N In N 00 N Li i In in in H U N co In H In co r-) In cV d' a to °l, °\° NN N l0 d' d' O lD rl lD In N W to N N 00 0 d' 01 In O d' cn in d' O H in O1 N lD N Ul N in H O ,� cn N o1 rl I O d' d' O a O l0 cn N in In or N in d' CO N tS1 In H RS d' N N c' rl r-, lD In WcW rl H o • rl 01 N H-1 E to In H rl lD OD N N CO CO O 01 d' H • In • a N in H lD in HH M H ,_, kr, . 11 Hko N H G N N rt ,c. H .,., H ri RS it .SC li N ctS O • lD l0 d' O N 0 A 01' CT, O 00 0l r1 rl V 01 N N in 00 l0 3 cc 00 N O d' N Q F--1 l0 N H '' 00 N U co H r-1 in O Ol N O O H 0o H r-i N lcl c' m U H U U -H ul ao d' O 01 '01 l0 l0 N u, t` l0 0 N N I In N in O Q C✓ p N l0 in d' in in 0 co Inn Ian O N H 1J to E H d' H • rn - O of O N U) .0 E . a r-i U . U 0 >-4U •.may r-1 r-4 N 0 m aas H scr, Kc H a 0 H Oo ,t. o 01 In Cr N H Q' N o In 0 N 01 01 cAn • O ,-4 W 01 O1 00 0l N rl l0 N rl lD In d' OD in o me- 0\v, rlIn OO tr l0 H H d• O0 rl N O0 N 01 H ..-4 in O1 �� 01 I M rl O r-I r-I t� lD d' N co co co • co O N l0 4-1 lD H r--1 Nr.' NI H •r-1 'Z cc Z 0 to 00 d' O 01 cT lD N 00 b -d I� N 00 N N N N O N O • U x N kn In in in Ln d' H N cn rl - 1i rl N In 0 4 M [ Gs-, a .--1 d' r---i r-1 W U N N 1J N N • to O 0 H W w N o rd ° a ,a H •to O a 0Cu H r•i in r1 0o O H in 00 Li bl H N rl 01 b Oo In H 00 In N rl 00 0 O t� lD cc d' N 0W x E ► o1 d' o ,r) O o N In � O Oo 0D I Wd' H CC1N F--I O kc, l0 r( O r( U1 l0 co ,c1 O1 rl W • CY+ N O U O PIN H O 00 OD i U) Ii in N d' d' Q., Hrti H m 'u Q N N CO H rl M M W •ri H O N N 0' LJ Q O 41) it U N • U 0 (1) 0) r-4 01 01 rl N lD lD N O rl N In rl In U rl N -� > 01 N rl O H CO OD r-1 N Id • rl r-1 d' lD CO 4 r-1 b r-i 0 lD r-) lD In In in N 4-1 CO A u CO O HN c,-) `" . a 0 00 t moo-+ r-1 m rl N In 00 rl in W , In O N O CO -bl O 0 bl C4 Ul Oo w N O 01 Ul r-I N r--1 O oO N r-1 in L O H rn m �r l0 lD rn no r-1 H a\ N O - 01 r� '-1 0 -4 ti~ N . RI a) C7 �' H Irl H r-1 0O 0 d ��I N MS 0 Li cc Hr-1 .I1 .0.0 -r-1 .0 '0 C14 r--1 to to to rti to R1 •r1 r--I -.-1 t31 tl: N '0 S-I N id A•� a 14 b a a N H 0 m .0 y/ H -r-1 J •r-I - H • Ai '4-1 rt) cc O 0' CO a O' b' O 0 0 to li W 0 N to -� trl o, to w t) W W a U 4 01 to r. LI to a H �' >� • 'd o >~ L RI > -H 1J cn u b of a v -.-1 •,-I to E RS q • -ri -r-1 to g •• 0 to m -r•1 ... '- — a u '0 a to Q a .4 Ia )4 al i4 U u) 0 O U to $4 to Li w to 1 ao U) N '' 1J $.4 (0 0 Li N a) r-i Q `� o I� G`' o u H a H u a O .0 E o 0 .0 > • u to �, r-' ° a) a • 0 , t~ — O w --I Li ii O to N to •,.� N Rs ,.� p+ U to Li rts '+-1 CU -r-4 a a to ,i O 'd r-1 a) O > N NU to -r-1 G to 0 a) l.a X al v C rti 0 N H to rt N 0 'O a) b^ q w as C to to to 0 Li W U > a) r-1 Rs Li Q) a) N a) a) >,r-i 3 .,1 W N o to r-I al to a) O 01 0 a ►-a to 3 E. to r: x w •3 O H U I--+ a ul ~ ,E.� 'd � -i IL • O •r•+ , O (1) b to a rts •r.i H a N 00 01 O r-1 N rl d' l0 r-1 U inN OD rl Li Q) a .SG a) 0 0 H q H A N Rs > Li 4) N L ., U z In In In lD c l0 l0 l0 c ° O lD c VD CO 0 to O a) N O O Rt KC lu. 0 H (r) a I-i Z a 3 H �- TOWN OF ORO VALLEY / WATER UTILITIES Plant, Revenues and Expenses at 11/30/97, Customer Data at 11/30/97 Schedule 6 Based on Historic Amounts Page 1 OPERATION & MAINTENANCE EXPENSE ALLOCATION TO FUNCTION . Account Total Number Expense Description Expenses Commodity Demand Customer Service Meter Totals Total Personnel / Finance Dept. 150 Allocation: 502-512 All personnel costs 15,204 15,204 15,204 Operations and Maintenance: _ 619 Equipment Repair & Maint. - - 634 Travel & Training - - 637 Office Supplies - Total Operations & Maintenance - - - - - - - Total Personnel Expenses / Municipals Water Division-,---T5-6 .-EI-11:1---Ai ro-c-ition............µ`-.___......._.-.....--........_._�.............-�......._�. ..,..--__.,.......- 502-512 All personnel costs 420,420 - Allocated personnel costs - 199,097 177,444 43,879 420,420 Labor Costs allocated from work sheet 47.36% 42.21% 10.44% 100.00% Operations and Maintenance: - 301 Contract Personnel Services 653 653 653 302 Consultants 33,709 33,709 33,709 604 Other Professional Services 118,290 118,290 118,290 WP 18 2,145 2,145 2,145 608 C.A.P. M & I Water 89,277 89,277 89,277 C.A.P. Capital Charges 39,648 39,648 39,648 Recharge Costs - - 612 Power Purchased for Pumping 526,081 526,081 526,081 614 Water and Sewerage 98 98 98 615 Waste Disposal Fees 1,061 1,061 1,061 618 Vehicle Repair & Maintenance 22,942 22,942 22,942 619 Equipment Repair & Maint. 89,246 89,246 89,246 620 Building Repair & Maintenanc 4,012 4,012 4,012 621 Grounds Repair & Maintenance 1,202 1,202 1,202 624 Chemicals (792) (792) (792) 625 Rentals 3,711 3,711 3,711 626 Insurance (Based on Plant(a) 30,538 2,667 24,002 760 2,294 816 30,538 627 TeleCommunications 13,171 13,171 13,171 628 Postage 34,640 34,640 34,640 630 Advertising 107 107 107 631 Printing & Binding 2,831 2,831 2,831 632 Recording Fees 527 527 527 633 Trans. & Dist. Mains 1,741 1,741 1,741 634 Travel & Training 4,984 4,984 4,984 635 Memberships & Subscriptions 3,110 3,110 3,110 636 Testing 5,752 5,752 5,752 637 Office Supplies 9,754 9,754 9,754 638 Natural Gas & Electricity 1,290 1,290 1,290 639 Gasoline & Oil 13,058 13,058 13,058 640 Non-Capitalized Equipment 4,054 4,054 4,054 641 Uniforms 1,724 1,724 1,724 643 Bad Debts Expense 84 84 84 644 Field Supplies 4,644 4,644 4,644 645 Miscellaneous Other Operatin (496) (496) (496) 646 Depreciation (Schedule 6,P.2) - 647 Office Lease 17,121 17,121 17,121 648 Amortization (Schedule 6, P.2) - 651 Regulatory Expense 75,225 75,225 75,225 655 Equip. Repair/Maint. Wells 5,087 5,087 5,087 656 Equip. Repair/Maint. Booster 4,713 4,713 4,713 656.43 Berkley Pump & Motor 4,010 4,010 4,010 657 Equip. Repair/Maint. Mains 1,262 1,262 1,262 658 Equip. Repair/Maint. Resv. 663 663 663 659 Equip. Repair/Maint.Services 154 154 154 660 Equip. Repair/Maint. Hydrant - - 661 Equip. Repair/Maint. Meters 12 12 12 662 Bluestakes 1,687 1,687 1,687 663 Interest Security Deposits 1,328 1,328 1,328 664 Safety Compliance 1,507 1,507 1,507 Total Operations and Maintenance 1,611,191 692,458 549,570 322,007 2,448 44,707 1,611,191 952 Acqusition Interest Exp. (a) 1,319,699 115,247 1,037,226 32,823 99,134 35,268 1,319,699 Total Expense Allocation 2,930,889 807,706 1,586,796 354,831 101,582 79,975 2,930,889 (a) Using Plant Allocation fromSchedule;...s-._....__.......-.....--...,8.73.3. ...-...._..-.......78..:_59.6.i--....__-.---••-2,487%---. � 7.512%---.--2.672r.~ 100.000%. TOWN OF ORO VALLEY / WATER UTILITIES Plant, Revenues and Expenses at 11/30/97, Customer Data at 11/30/97 Schedule 6 Based on Historic Amounts Page 1A OPERATION & MAINTENANCE EXPENSE ALLOCATION TO FUNCTION Account Total Number Expense Description Expenses Commodity Demand Customer Service Meter Totals Percent of Expenses to Functions 27.5584% 54.1404% 12.1066% 3.4659% 2.7287% 100.000% 1/8 OF OPERATION AND MAINTENANCE EXPENSES AS WORKING CAPITAL ALLOWANCE 201,399 86,557 68,696 40,251 306 5,588 201,399 CAP Capital costs charged as Customer Cost CAP water costs charged as Commodity Cost CAP Recharge water costs charged as Commodity Cost o\o 0, U1 a) d' t� N LII N d' OD N M M O O al d' t-- N r--4 In Ul N O CO N t� O to d' '-I t- Ln a) ,-ti 01 '1' 40 l0 N Ln r--4 O r-i . p al d' r-I O N M d' N d' N H N d' N 1.1 LI) N r-1 10 Ul N ri N N d' M O 0 H LI) N r4 C) E� ` r-I H a -H g'o7) N LI) N H H H w H .-t o N o rn 01 d' (1) H d' l0 Ul H H a) N r--+ a) O N N Hd' H l0 -H l0 4) 4 X to In It • It O ci U U) a, l0 -•-i ci A. t-- It o M d' CO N E 01 N O N ao d' a) E co 0 a) U t� 10 N M N 0 H -H . . . U r-1 > M di 4-4 H M0 Ln 10 1---` 'Cl Cl) 1H CI, as -H r-I 0, ro '' 0, 1-I Icl -H c 1 t`- d' ON m a() a) a) Ul 40 rl al C) II) 'CI r i U E 04 6, II) Ul ,-i N N N X O N Cs] r-i In 1J co'Ila) H t N ' U O N 0, si a o ns N E ,-i a1 )..4 °\° a a) Ln M 10 H a+ N M 10 N N (1) 10 O 71 10 N N H H CO a) N M H 3 l0 r--1 MC ) al O 10 M O 0 N rn a1 O a) 0 In '--I \ rt . -H a, 0, b H E M l0 a) H r1 I-) N 40 N Ln In In -i a) r1 -i l0 a1 H r--4 r-c el CO - Sa q H r1' ri U no • co 0 H a) a N 4-4 rd Z r-i -r-i 0 w g a) cif H o 1J U r4 01 In N l0 {1 l0 N H N d' ri- A. cd as n U -0 d' ri t-- In d' N CO M 01 N a1 a0 En S_ -i c V' -I n N '1' 0 01 CO r1 a) d' tr1 cv H 0 In N H H 0 r-i r-i rl CO b N O HE H In N H al ci aD H to i to H 0 -- o -H H m 1) Ln ,� 0 u I Z 0, H-+ a0, In a) [i' N N In N it '14 CO N M M 0 a W O a) O al d' N CD In N r-i LN O a) N N . a) N b ,� d' H sLIl CO r1' Ol d' U 10 lDLI) r U N I v) ' 04 d1 .� O O N a) d' r---4 O N M d' N d' ,1 N H M d' a) In N r-i 10 In N v--4 N N d' M to H HH LI) N •---4r-� -r-i \ r i 1J Q w • `c 0 U) r-I 0 0 aL.) x w ,,CD o\o o\° ,„ o\o A. A. o\o w o\° o\o o\° ,No 0 qR, O N l0 M 10 M r-i d' M r-1 r--I M > 0 to O W O l0 M M N M In N \'' II) l0 l0 M -a ) a, 0Ln 1.-- N Cr) M m N r i I a> r I cf. M E, 0 'Ws ,--4H N W b 0 tri) w Q 0 In a) 11 ci H O W o ci -H H -H §+ H H al al M N l0 10 N O o M N II1 M ID ciS 'ci a) o So Q1 N M O H CO a) H N 'Li M H d' 10 a) H N S-1 H C l0 H l0 Ln Ln M N r-I CO a) COO r-i N M H ,0 a N N U 0 . to w to ci -H H co M t� In a) M In 10 N In O N O GO 04 U) T1 LnCO CO N O a1 In H N A H O ao N H CO W SOi H -,--4 s,-I al cA d' 1.0 1.0 01 CO r-i H 01 t� C E to Eli ) i CD - HOa) Q / H Ln r- H dS-i ti) —4i...) N F-' 4J S-I a) ( tri cY U 4a O o o a H H •H a ci • S Ta o Eo a aC, si C ; rci -r-4 -r-1 -r-1 H -H ri7 -•-1 b p, C 4 O b G 19 6, Ei O b o , O .. S-i P ELI ci w W S-+ 0 0 S-I -ri 0) a v1 i In a, 0 0 0 1i -'-i E to • • 0 a' r~ to r--i a) [� H C H a O a) o C 1, ,--i C; -r-1 -r-4 to E O r--I • -r-t •r-I to 4 cd ci S-I b 01 H -H 0 KC 0 C 1-i O r-I O U ci o, to Ca a, b Sa RS .-54 U a) r-I -r-i to I a) U) Sa to ci O H H bi a) J-) a) H-7 Sa -ri '-O to to U C .0 ri, S 4 O a) ci U U Ca 0 ')0 0 N H -H -H U 0 3 U 1.) to 0 '2f 1.1 > • U to ci Sa 3 U) a) Pi • C'., to t~ -H S-I H U U) to -ri S-I RI 1-1 O U to 1J rd r-i a) X Ll b O r-i a) ci > a) �-I O ,--t E •H C to O co U to to C H r-t to os S-4 H b ci r-i o 44 b C to H S� b C r-i ci H a) a) S-i a) a) >,r-i O Sa II-1 S-I O to 0 a) C O 4--i E-+ a, rts U • N CO al co r-I N rl d' 10 In N a) M O ',ZO, In In In 10 lf) 10 10 10 10 10 10 10 a) g4 o\o o\o o\o o\o o\o CD CD CD CD CD CD CD CD CD CD CDCDCDOCD j CD CD CD CD CD HHHHH U o\o o\o o\o n\o o\o (-1-1 Ul C` CO O r l CX) 1 d' r1 O H N O 0 0 CO CD O CD rI U I- CO ov, \n o\o o\n o\o r_{ in CD Q1 CCC Q1 o TH co = O N CD H N N () co . t)-) CD o O o H U (US Un (AO lP CO CO U) CO • C31 O If) d+ l -f4 CD CD CO (V CD CD CD CD CD CD CD CD o\o ::Cl' o\o o\n o\o CO r rl r N In N r� N CD O �+ N Cr) If: o\o o\" o\o o\n CO N O rl O CD 2'1 rl rl N o rl = C31 H • • in • O Ll) H Cd o\n o\n o\n o\n o\o L() Ill (CC C') OD (� RS co N H N In N N CD • • • O N = CD CD CD CO H H o\n \o o\° \o o\o H 0 L11 CO O d-+ d' H N 01 01 H (n jJ (1) _ -V CD 01 N • r N q.) kr) o e o\o o\o o\o o\o o\o U W = rn N rn C'l H -►I N C') CO (CC Ill (31 \ O O H • O H CD rzi r (1.) cm, o\o o\o cm) e\, O (x) LI) CD CD cn Si Z N Co r1 (n N U) O = r'1 rn •14 ON N r♦ 4-1 (1) U) U O w0 �' O W = o\o o\o o\o o\o o\o ►-1 r1 in Co N O r�-v{ \ Lfl •d H co H rd rn rn Cr) al • C'1 H cn O o CO rn N co C!) 11) Co Q1 O v In 0 a) Si a) 3J rd a, -H >-, -H -) S. U U 0 0 a) -H Ti Tj E S+ 0 0 0 -0 Un U E rd S a) E E to Ci Si a) 0 a) i a) a) ni U U U Un r-- a)a) tH• (-1 TI a) N t3l O ni cn a t- 0) 0 M H H RI O O O O .0 c4f0 0 O O O O N Ul Q E-1 e r-H H H r-H H F O H Q) C,4 U . 1-4 a O z U H .0 U) O U) 1-.) H E-i >, 000000000 U I U .0 r-H H r--H r-H H O O O O O Ht w O rn • o O e 0 rq 0 [+ U �+ H Ul X 0 0 0 0 0 a -� 01G1 01 01 01 x rt O O O O O 4• RI U) O N O Ul rd W Q t 0 a) U Q O O O O O O O O O W al rii , O O O 0 O O O 0 O O X al W >4 li r-1 r� r-1 H 'd H 0H O RS O H (/) 0 • U C a) -,-H 0 N -H X 0 U) 04 0 -H 0 -0 S-1 -H rt d U) � cU) Ti r-+ a) -H A a) N >, a Q 0 U) Un o -H E Rs Q., 4J > a) a) E 5 r E U) U) 4 4 O a) N -H a) a) -H U Q w 0 U cn X w TOWN OF ORO VALLEY / WATER UTILITIES Plant, Revenues and Expenses at 11/30/97, Customer Data at 11/30/97 Schedule 7 Based on Historic Amounts Page 3 DEVELOPMENT OF CLASS ALLOCATION FACTORS iif:•%JrYNiirr}'JJJJ.J%I/rYfriiiil:•ii:f:•Xfiiiiiii%AW'fJJJ/ri%JJ1JJifJ/1'A'1H//lllJlfiV/J!//h%JJJ/:%/riiiYr%ffiWlJJ/r%JJIr%Y1Jl Yfii'lf/.f/JJ/rYNf/fJN+YJfiii'1/%%iri%fJ/i%1 ii%1hY///fJ.%J/fJJJr'ff1/l/A'rWff1/.4%//ir'J/f/J//i%i0!•%/f/!/Jl1f//f/JJ1.•%Jll i'!J.A'/f/1JJiffA'Rj wwt COMMODITY ALLOCATION FACTOR t DEMAND ALLOCATION FACTOR , I i.,.J...J..'t':.s.i!..{l1.•lJ1r l:Ylf-4X!4.?N/1AfU.G6'/.14F/bYJIGC•J6wH�SCBRC?b35%/?:'JX?9!2/+00!+fF!(/.H.+Xl.NY1+N+C/f�UN11.....:.............. .•.• ..!ryr/.+/ ..:...:....:..»»»r».».....rr»r....r»:w............».»..».ww:,f.».».»...»...r.....»r.....»...»....w.».,»:».»».......:..:::»r,.r r••••.v:»:»»:....».:.....:w»...r::......,.».»« .r4h4.w J J!4Gvi41f Percent ofumber ofs Weighted - Percent Total Gallons 1 Meters 1 Number of - (in 1,000's) Ins • 1 and/or 1 Equivalent 1Meters and/ors •• Meter Size Year £ Total • Meter Size 1 Services 1Weight 1 Services 1 of Total f Meter 5/8" x 3/4" 1 1,167,584,900 1 50.9528%1<---(1)---> 5/8" x 3/4111 10,440 i 1.01 10,440 1 80.943% 1" 53,338,000 ; 2.32760; 3 1" 1 154 2.5; 385 2.985%1 21,516,000 0.93890: 1-1/2" 43 5.05 215 1.667%1 t 2" 146,998,600 6.4149%1<---(1)---> 2" 98 8.0 784 6.078 6" Resale 17,995,100 1 0.7853%1<---(a)---> 1 6" Resale 2 1 50.01 100 i 0.775 • 3" 136,026,000 5.9361%1 3" 14 16.05 224 1.737% 4" + Unmetered 1 33,507,000 1 1.4622% 4" 14 25.01 350 2.714%1 6" 565,149,400 24.6628%s • 6" 5 50.03 250 1.938% 8" 1,029,000 0.0449 8" 1 100.01 100 0.775% f 0 6 G if 1 ' 6" Golf { 148,361,000 } 6.4744% <---(a)---> £ o £ � 0.388 0; 50 0 50 Totals 1 2,291,505,000 100.0000%i 1 Totals 10,772 £,w.w»»»»,rw»rw»w.r..,w,.l 2wr,898 £ 100 000%i • � � r»;-•wMw»-w:. Ummetered 2,370,000 Ummetered 9 J J Arn%H%J!f/Y/'frflJ!'ri%%J%N%fiiDf/N�%%%%JJJffrrJ/J�:•'J/+ii:•X•:%•/i%4///ffri%Jf.!'11/�:WJ///!/ j4/+WJJ.4W%JJ.4N'1fiY1/#!'f{IJJFW VfiJAYNJJJ///JIH//+W/1f.W1JJJlJ•%NJr%i%'/.'iri4C{4lrr:•:WA'1.111.4.4/Jf/NJJJ/.4JJI/ffi%flfif!l4Jf.+.f+/.:r?!+1.:i YJff/i!r'lJlJ1//f/%'J.41Jf11J/4.4lffJ/>/%JfJ1Jf�%J.4//J/!•%�:!%4JJ/R4A'•4fh%JJlJJl1!/lJJf1J/JArHA%1R4 r*X?J'f.•%'l/YJJ/f///J/JJfJ/f.%1/1/1AY11//%%J1JwC??4/Nl/J/N//JJ1JJ11J/1JNf///11/'01/111//JJ 'f / ., 1 CUSTOMER ALLOCATION FACTOR gs SERVICES ALLOCATION FACTOR (b) ¢ 3Y,........Y9/HHH/H/// •. ••• ••••":'.•, ''• .9.19/H.3.1./.t.551./dH/,LSSW/H/A+//HH....11Hf/Wl/NY1NY/H//sWJY//1Y'S:'...9FHN////N•9W//NY/, 1.4.555.9.433'//1H,,,,,,,..,.91'/IH,'b9l'//dY/hS YHhYH/H//,94,15511,35,4,.. H59..." /wLY/h//wW.455.4Y.,597,,91.......J//YH.WhN5H.W.W.V.W WHYAHKI15'/ifSALLWAW.9.9555.114 { Number of 1 Percent of s Number ofInstallatio Weighted No. 5 Percent Meter Size 1 Meters 1 Total Meter Size 1 Services 1 n Cost € of Services I of Total 5/8" x 3/4" 1 10,440 1 96.9179% <---(1)---> 5/8" x 3/4'1 ' 10,440 1 $ 70.73 s $ 738,439 £ 93.8744%1 1" 154 s 1.4296 • 1" 1 154 96.92 £ 14,926 1.897505 • 1-1/2" 1 43 1 0.3992%1 1-1/2" 43 1 96.92 s 4,168 1 0.5298%1 2" 98 0.9098%1<---(1)---> 2" 1 98 156.08 15,296 1.9445% £ f •• 6• " Resale 2 1 0.0186%1<---(a)---> 6" Resale 2 890.00 1,780 0.2263%1 3"• 14 F 0.1300%` 3" 14 126.60 1,772 0.225303 £ 1 • 4" 14 0.1300%3 4" £ 14 286.64 4,013 0.5101%1 • • 6" • 5 I 0.0464%, 6" 1 5 1 890.00 1 4,450 1 0.5657%3 8" 1 0.0093%5 8" t 1 890.00 890 0.1131%3 6" Golf £ 1 1 0.0093%£<---(a)---> 6" Golf £ 1 890.00 5 890 1 0.1131%1 �Totals 10,772 1 100.0000%1 Totals 1 10,772 1 1 $ 786,624 1 100.0000%1 »»Iw»w»»ww,»»,»»rr»w.,»»...,».».:.,rr»»..ww.»» »».lww»w», .,s�.vr»..;:Nw:.;::»w».»r» »rw»».=rw-H:,•» wr»»,» w,_w. ,w.rw,w,rN»»»„ww,».;,,N,aw,.»»w:•n..w.vHrw»»w,ww,r,» ».,.,.»r»»,r,»„�.»,»r».»rv»w»w»r»M,..»wr»w».ww»»»rr»r»»»»»»w�,»»wr»»»r»»rw»r»r.»»»»wwr»r»r»»rr».»,.r»r,»w»»»w»,�»,»r,www»»a.»rr.»,.»,.».rh.w,.w,»»:� .r..»:»»r»»,,,.»»»».»,»r.,»w�..w»�,w»r,»..r»,»w� r.w�».» »»»»,» »w»rr»»r,w .» »»» »r»»»�.w.»w»r»r. »» r ww.»r»r,»» }p</Y,..9.....iWHH/J/H/HJy151/H/YHHAYI/lYA/JYHAf9YAYY1/Yif//H.W550,4,%9HWW..•W1ff/J/f9HYf/fJNH1,..,, /Hb?%/{H/,,,,,,,,,WiW1/j/,y/r%Hff/H!i3:Yi:Xr//XfIiHY/UH/IHi!N,,,,,...f/HAYHJ9Y//lHHJH//HA.YAY/A//,f METERS ALLOCATION FACTOR (b) i:•Yr%:r+Y.4f/.rfiYAYJJ//J//JJ{/Jfif//MAwhYwCrhY/r'/N+6'!r%4JJJJJJr%4JA'h'A'f/JJJIJIJJ/ffN/JJJfJJJ.4JJHJ/N.4J//iY.i/JAVNf/.4N.4N!%Jfftf.?rffllJffffi�b%%?•Y.?.'1.r+t!!rr/r%YJ/.f?b:4r%/.+fJ.4fJ.:'J.!frJ.4%4f.4/f.4JJJJ/iJJ/.?M+.3:!4iAYJffi%i:•:+f.4iY1JJ/.4JfJJ/.??+.•:+F.!r/Hl+lr,%/f.•ii:•i:Uiii'J.r??.:f%i.•::?;xyii%1ffrJ.J:4J.?+//N%r'ri Weighted 1 Percent of • • Number of Dollars of Meter Size 1 Meters ;Meter Cost 1 Meters Total • 5/8" /8� x»r 3/4"�»w»ww w w»»»»»ww»,»,..w»»,»»,.»w 10 4,4,0».,w»,»$»»ww».,»,..»29.27 w„„ .,,» »„$.w..ww,�ww.305,561 0,5»'»5w6»1,..».£,»w.,,..,..w..,».7.0.,-..0..9.5.9 1 • 1" 154 63.08 9,714 2.2284 1-1/2" 5 43 i 193.92 1 8,339 1 1.9129% • • • 2" 1 98 1 353.22 34,616 1 7.9408 6" Resale 3 2 i 5,620.00 1 11,240 1 2.5785%, (a) • I 3" 14 1 623.40 1 8,728 1 2.0021 4" 14 1 1,313.00 1 18,382 i 4.2168%€ 1 6" 5 1 5,620.00 1 28,100 1 6.4462%1 s 8" 1 1 5,620.00 `€ 5,620 € 1.2892%1 £ £ £ 6" Golf 1 £ 5,620.00 5,620 ) 1.2892%< (a) .�»»..$ 435,918 00»».»»,,..».,w...»»..w.w.:...».»».».,...» o Totals 10,772 W 1 1 .0000 0 ,»w»»»wwwr (1) Meters and services translated to equivalent 5/8" x 3/4" demand (a) Special Tariff, which differs from rates charged customers on same size meter. (b) Based on Town of Oro Valley's installation charges. Meter and Service Line costs determined based on Ratio of meter and service line charges allowed by AZ. Corp. Comm. Staff Memorandum of January 13, 1997 Lzs U) olP U RI 4-I N C O O) C U) U) U) • --I C (0 4) U) 11) -iJ U) c j M 05 -1--) (f) U -k) U U) U) -H U) a, cU 0 U N o x o a Ix l2 k r- M M di M N di Ol LO O LU lfl L M di Ol di O i c--I O L LO di al L I [� LO =I Ol L l9 r--I N LU O L L O r-I C N O N N CO LOOl CO di Ol di i' (5) in COCOo N CO ,--I ,--I COI N LC) N O C51N di C51O O N l0 l9 (3)= •- } O -H Ol I co M CO LO di LO N l9 [� cm r"-- O di O 00 lfl O co di O cm O c)-) e1 i -P r- CO N Ln CO O N M 0 CO ,--I N N N N Ln l9 N ,---1 O } Ol IRI 0 a) • O d, N r-I N N N d' di �--I O lfl 0o M r ,mow � 4° �, UZ _ z ) N di di c--I N r--I rI 11 O x ��,a O CO 69 69 69 69 69 69 60 6. 69 60 6. 69 60 69 60 60 60 60 69 69 69 dp o\0 60 or 60 11 O Ol O c---I CO LU N N O N di N c di CO CO O di [� C CO ,-I CO c--I Ol M r--11 •r 0 U) r-I =I U) O N LO C O CO CO N X r•--I CO ,---I CO N ,--IO M CO CO [r--- l9 d' di If.) d' -,--1 U) u) u 4) i O LU LU co O N c--I C) C) co LU O O LO O O Ol N rI c--IM Ol O Ol r-I} • E (0 a) 0) O r-I N l n d' N r-I } •� E� N 11 UI Z a) �-� a k1 O r 1 w } W xx W r4 H i1 4▪) U ▪ri 'CI •r1 W 4i • u) a, O 9-1 X 0 -r1 U) 0 N O 4i U) • 0 > U) U - a._.) -H • O r--I U) a) N 44 U) a--) -H -0 U) 4-I U) a) U) U) r-I r-1 -P a U N O Cr) ,-I a) N (0 U) N a) X RI -H U) U) i--I .-H U) U) U) N U) U) 2 (M U) U) U) U) c) c -H E N U) Lzs U) �I r-1 U) U) --I U) r-I U) -I-) --I N U) O 4 O C• Q U) 4i a) a) U) U) X � I > > > U) a) o RI U cn O X c--I 03 4-) 4-) U) U) a) C O U) C Q.. U Lzs U) c H WI-I U) U 0 -H O �-I N U U) U) N ,.c c U W a) a) N N 114 -I U) a U U) a -0 O .--I N O -H E U) 44 c4 O N 3 O ( O X 0 U) -P -H o U O a) U -I--) 0 (0 -H O O W (0 0 71 -H U) O U) 4-) U -H a--) �' N U) r-1 r--1 U) 0 C 4-) a 0 N a) -r-I -r-I r-1 U N 0 (0 -4-) (00 -HEI) U) r-1 0 N U) U) U N M X O -1-� �-I U J U) i U) H N O U) U) N U) �-I co ( O N �--I 03 0 • ( 4-) U W 0 O fy 'j U) 3r U) S~ co N U) -I •-1 C o o a -H O -H U) r� H N N -r I -H 4-I U) U U) O a) U U) N U) U) • �, U) �-I U) a) a) to E U) U) -,� U a) > -N U) U) -1--) e I I FC E r-1 X a 0 a--) E 0 c N 0 O -•-1 N a) a) Q N c -H O O N U) U) • r-1 N 0 0 c 0 ' Ix U H E-+ U X Z Z rx O a H X H E 1 N a a U a OHJI-I 0 124 a) • LO [- co Ol O r--I N di L LO (0 (U O N CO0 a)I H O N N N N CO CO CO M CO CO 4-i ,C CO CO 4) 0, N -I-) didi di di di di di di di di Co 4i di di di 0 W 0 Z 0 W . 0 r-I N CO di lfl [� CO Ol O c--I N M di LU lfl CO Ol O ,--1N CO di Lf-) l0r---- OO Ol O -Hr-1 r-I ,--I r--I r-I c-H r-I ,-I T---I r-I N N N N N N N N N N M 11 4-1 ;' a) 0 a) N a) a) a) 2, a) a) a) N o a) a) a) LO 12 00a) - o � Ri o •:z L7 O •C -H U) a)2 Pl) a) r4 N 111 {fl-_1 1 1 ? 0 [- i -t, d-' in LO N N N N 2r- ;di rn LO O 1 Ln - LO Ln CO di 01 Q) (` LO ¶--I 01 L() Ln N N d' 0 LO 2 In N LI) O Ln? In o r-I 2 r a N 111 j N [- 01 in 00 CO O O 01 0 N d' N 2[-- ?Ln co ,H 100 1 N LO N 1 O 2 01 r-I 0 01 .11 (1) I -4-)(>I -H 01 I Cr) LI) =I N CO N 0 N H LO01I"- o s d1 1 co Zr: LO N LO t31 I -1-) �I I > r--- in r N in Lf) M N O) N 1 Or) 1 Ln [` Cr) 1 O N in r--I 1(-- 0o 11 (>� 0 O v 0 d1 N r-1 .--I C\1 N N ,-I0 2 x N C N ?N N 1d1 2 <�' 1 s Q qg d1 z cp ti 1 1 1 i o\o o\o o\o o\o o\o o\o o\o o\o op o\o op op 'op op op o\o x op op o\o op i o\o i o\o 1 01 0 c--I CO N Ln CO in CX) O N 1 Ln 'N O N di 1 N c--I d' i 2 co 1 O 11 RI a) Or--I Ul O N LO 00 I- co c--1 c-H O in 0D 2 O N C ( =I CO H CO N 1=1 2 O 12 t (C .2 1 1 .1 E a) U] U) -N )i o Ln Ln in N O ,--I Ln) LO LO N r O H O O 1 CO Ln o O 1 L 2 O a) ( 0 a) O (C I n rn 2 rn? O11 > r 1 1 O a) O `� Z X a) a (4-1 a) 1 • 22 2i a) 2 2 1 11 CO �I C O 61 61 C` N Ln r-1 C Cr) -3 w a) a) a) U) U)co 2 LO co N 00 CO N 01 1 LW •ri (/) - oW 2 200 O d' Ln ('7 N N 2 co •r1 -IJ 4-1 cn N -H O a) U) U d'11 Ln d1 r LO co rn -I--) (C ,-I > 0 s r--I ( 4-I H; in in Ln o N N 10O O r-1 O O 1011 1 $ U (i (Ti U1 r-•1 x 2 1211 Q) d) a) 4) ,- Q) ( -P N 1it -1-) 0 E-1 a) U (1:1x 1 3 21 1 >1 H a) a) W � a) 4J o N 0 0 U) > U) U u) 0 0 a) O O r� U) 4-a co 0 4-1 r 4-1 i N 4-, U) $4 y-I (C a) U) U) r-1 O r-I o r•-I o r--1 -P U) ,H a) a) O (C U O o O O (C (1) ,C • U) (ci r-1 ,--I U U) H 4-1 r-1 C•7 N ( N U) (C (r) a) U) a) a) U) (I n 44 o rI O (C -H E a) U) r1 U) (f) a) P H o O O $4 LO LW P a) r1 H (Li ,--1 N O N O N WO WO a) ,-Q Wu a) a) U) a) P P O -4--) C0 \ \ I4 O O -P a) co 0 X ,--I 4-) 4 x 0 U) N i-1 N (0 U) U) N (C o (1) W O co co a) N ( I-1 9C (C 9� O a) W o > H U) U ) O r1 -H a) � 0 `� H - CO -,� o 0 H E a) U 1 9C O (z 0 0 - (I r-1 (C Z -P U) E U E H E 1-1 E H -1 OUO ( -H CO(O O CO(O r•1 a) a) -rl a) •rl - W a) -1-) -H -r-1 (C ,---I > 4 >1 -P I -P x -1-J U O U --1 �-�N ( 0 $4 U) -1--P CO U a a) (N (I) (f) > P (C U -P O a) U) 4) U) U1 co ( a (f) H -I a) •r1 O U) rI ( 14 O a) a) () a) P co 4J 9) O >, •r1 >i (Ii >, ( >1 P a) (C 0 a) rH co 0 (x a--) a) 0 (Is 4 U) U U) 'd U) 'V U) -PH • P U) ( cd P a) P • 0 O U a) O O a) U (C U d) U) S•1 N 1 �' 4-I �,' 4-I 0 4-I 04-I �"� U) U O Ul [nU) PO 0 s~ a) O I ,C (C 6 4-1 0 4-I (6 4 1 ai 4-1 0 -H a) a) a) (C -H a) 0r24U HU) Pi24ov) ovo0o U xz (24a HxH a al LO C- 00 (n c5) c) O O O O H RI N di Ln LW (6 Q1) O N Cr) aj rd (1) N N N N N 0') Cr) cn CY) ('') Cr) 4J CO ('") Cr) Cr) 4-1 ,r [--- CO co 4_) 4-) g' di dj di dj di dV dj dj dj ,r, di 0di d+ d1 d+ H 4-1 di di d1 H0 0 a) s O N CO di Ln r--- CO 6l- l O H N Cr) di in LO [- 00 cn O ,--1N CO d1 Ln L C- CO -,-1 H ,-I H--9 ,--I r-I r---I H H---I ,-1 H N N N N N N N N N HI Oro Valley Water Utility Rate Schedule A Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers $0.10 Increase in Monthly Minimums,with Increase to Larger Meters Based Meter Flow Potential,expressed as gallons per minute Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums (5/8 x 3/4 Inch Meter) 1.03% 2 Percentage Increase in Commodity Rates 0.00%' t.•:::::::::::.•.LLL•:::::::'. 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $9.850 1.03% 9.850 7 5/8 x 3/4 Inch-Other (a) $9.750 $9.850 1.03% 9.850 8 5/8 x 3/4 Inch- Residential City $1.03 $6.750 $7.783 15.31% 7.783 9 5/8 x 3/4 Inch-Commercial City $1.03 $6.750 $7.783 15.31% 7.783 10 5/8 x 3/4 Inch- Irrigation City $1.03 $6.750 $7.783 15.31% 7.783 11 5/8 x 3/4 Inch-Other City $1.03 $6.750 $7.783 15.31% 7.783 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr,Turf $24.380 $24.630 1.03% 24.630 14 1 Inch-Other $24.380 $24.630 1.03% 24.630 15 1 Inch- Residential City $2.59 $16.860 $19.450 15.36% 19.450 16 1 Inch- Commercial City $2.59 $16.860 $19.450 15.36% 19.450 17 1 Inch- Irrigation City $2.59 $16.860 $19.450 15.36% 19.450 18 1 Inch-Other City $2.59 $16.860 $19.450 15.36% 19.450 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $49.250 1.03% 49.250 20 1 1/2 Inch- Other $48.750 $49.250 1.03% 49.250 21 1 1/2 Inch-City $5.18 $33.710 $38.890 15.37% 38.890 22 2 Inch Res, Com, Irr,Turf, Res MF $78.000 $78.800 1.03% 78.800 23 2 Inch-Other $78.000 $78.800 1.03% 78.800 24 2 Inch- Residential City $8.29 $53.930 $62.220 15.37% 62.220 25 2 Inch- Irrigation City $8.29 $53.930 $62.220 15.37% 62.220 26 3 Inch- Irr, Turf $156.000 $157.600 1.03% 157.600 27 3 Inch-Other $156.000 $157.600 1.03% 157.600 28 3 Inch City $16.58 $107.850 $124.433 15.38% 124.433 29 4 Inch- Res,Turf, Irr, Res MF $243.750 $246.250 1.03% 246.250 30 4 Inch City $25.91 $168.530 $194.437 15.37% 194.437 31 6 Inch-Com, Turf $487.500 $492.500 1.03% 492.500 32 6 Inch-City $51.82 $337.050 $388.867 15.37% 388.867 33 8 Inch-Com, Turf $702.000 $709.200 1.03% 709.200 34 Unmetered, Const, Maint $9.750 $9.850 1.03% 9.850 35 V-Golf Irrigation $702.000 $709.200 1.03% 709.200 (a) One third (1/3) of difference in monthly minimums between"City"and "Non City" customers added to"City"customers to eventually align rates. Gallons included in Monthly Usage Charge 2,000 2,000 0.00% 2,000 Commodity Rates Residential, Commercial and Resale Customers Charge per 1,000 Gallons in excess of gallons included in Monthly Usage Charge $1.71 $1.710 0.00% 1.710 Residential, Commercial and Resale Customers Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 Resale/La Cholla Airpart& Metro Water $1.45 $1.45 0.00% 1.450 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule A Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30,1997 $0.10 Increase in Monthly Minimums,with Increase to Larger Meters Based on Flow Potential No Increase in Commodity Rates Percent Percent of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,562,631 $11,145 0.44% 59.40% 57.83% 2 Proforma for actual customer change 37,551 37,722 171 0.46% 0.87% 0.85% 3 Proforma for Estimated customer Growth 79,811 80,156 345 0.43% 1.86% 1.81% 4 1 Inch Residential 10,361 10,418 57 0.55% 0.24% 0.24% 5 1.5 Inch Residential 770 776 6 0.78% 0.02% 0.02% 6 2 Inch Residential 55,514 55,652 138 0.25% 1.29% 1.26% 7 4 Inch Residential 19,456 19,491 35 0.18% 0.45% 0.44% 8 5/8 Inch Commercial 3,263 3,277 14 0.42% 0.08% 0.07% 9 1 Inch Commercial 17,117 17,179 62 0.36% 0.40% 0.39% 10 1.5 Inch Commercial 17,602 17,683 81 0.46% 0.41% 0.40% 11 2 Inch Commercial 87,242 87,504 262 0.30% 2.03% 1.97% 12 6 Inch Commercial 84,975 85,095 120 0.14% 1.98% 1.92% 13 6 Inch Resale 32,877 32,947 70 0.21% 0.77% 0.74% 14 8 Inch Commercial 18,567 18,739 173 0.93% 0.43% 0.42% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,020 10 0.02% 0.91% 0.88% 17 3 inch Turf 183,737 183,773 37 0.02% 4.28% 4.15% 18 4 Inch Turf 31,402 31,430 28 0.09% 0.73% 0.71% 19 6 Inch Turf 794,230 794,410 180 0.02% 18.49% 17.93% 20 5/8 Inch Irrigation 32,484 32,584 100 0.31% 0.76% 0.74% 21 1 inch Irrigation 70,648 70,884 237 0.33% 1.64% 1.60% 22 1.5 Inch Irrigation 33,057 33,192 135 0.41% 0.77% 0.75% 23 2 Inch Irrigation 137,566 138,024 458 0.33% 3.20% 3.11% 24 3 Inch Irrigation 24,976 25,038 62 0.25% 0.58% 0.57% 25 6 Inch Irrigation 122,054 122,114 60 0.05% 2.84% 2.76% 26 6 Inch/Rancho Vistoso Golf Course 52,925 53,012 86 0.16% 1.23% 1.20% 27 5/8 Inch Other 27,693 27,708 15 0.05% 0.64% 0.63% 28 1 Inch Other 3,294 3,306 12 0.36% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,880 12 0.42% 0.07% 0.06% 30 2 inch other 5,946 5,962 16 0.27% 0.14% 0.13% 31 3 Inch Other 2,416 2,435 19 0.79% 0.06% 0.05% 32 Unmetered 1,141 1,144 3 0.23% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 115,980 5,986 5.44% 2.56% 2.62% 34 1 Inch Residential City 3,888 4,075 186 4.80% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,651 199 5.76% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 630 31 5.19% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,107 52 4.89% 0.02% 0.02% 39 1 Inch Irrigation City 610 636 26 4.25% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,250 99 2.40% 0.10% 0.10% 41 5/8 Inch Other City 73 83 10 14.23% 0.00% 0.00% 42 1 Inch Other City 479 515 36 7.57% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,262,018 18,677 0.45% 96.06% 96.18% 44 Meter Fee Income -----====76,329_ 76,329====---------=------0==== =====0.00%===_ ==:==1.78°x6====_�.====1.72°x6.- 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.23% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.73% 47 Reconnect Fees 6,100 6,100 0 0.00% 0.14% 0.14% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,431,117 18,677 0.43% 100.00% 100.00% Town of Oro Valley / Municipal Utilities Division Increase in Monthly Minimum Rate Schedule A Page 3 Monthly Minimums With $0.10 Meter Increase Flows on 5/8" In by Present Gallons 3/4 Meter Monthly Per Inch Size Minimums Minute Meters 5/8 x 3/4 $9.75 20 $9.85 3/4 30 1 $24.38 50 $24.63 1 1/2 $48.75 100 $49.25 2 $78.00 160 $78.80 3 $156.00 320 $157.60 4 $243.75 500 $246.25 6 $487.50 1,000 $492.50 8 $702.00 1,440 $709.20 Resulting Increase In Revenues with Annualized Number of Customers to 6/30/97, and Customer Growth of 780 Customers to 6/30/98 $ 18,677 Oro Valley Water Utility Rate Schedule B Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers NO Increase in Monthly Minimums Commodity Rate Increased $0.01 Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums 0.00%: 2 Percentage Increase in Commodity Rates 0.58%: 3 : 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, kr $9.750 $9.750 0.00% 9.750 7 5/8 x 3/4 Inch-Other (a) $9.750 $9.750 0.00% 9.750 8 5/8 x 3/4 Inch- Residential City $1.00 $6.750 $7.750 14.81% 7.750 9 5/8 x 3/4 Inch-Commercial City $1.00 $6.750 $7.083 4.94% 7.083 10 5/8 x 3/4 Inch-Irrigation City $1.00 $6.750 $6.861 1.65% 6.861 11 5/8 x 3/4 Inch-Other City $1.00 $6.750 $6.787 0.55% 6.787 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr,Turf $24.380 $24.380 0.00% 24.380 14 1 Inch-Other $24.380 $24.380 0.00% 24.380 15 1 Inch- Residential City $2.51 $16.860 $19.367 14.87% 19.367 16 1 Inch-Commercial City $2.51 $16.860 $19.367 14.87% 19.367 17 1 Inch- Irrigation City $2.51 $16.860 $19.367 14.87% 19.367 18 1 Inch-Other City $2.51 $16.860 $19.367 14.87% 19.367 19 1 1/2 Inch-Res, Com, Irr,Turf $48.750 $48.750 0.00% 48.750 20 1 1/2 Inch-Other $48.750 $48.750 0.00% 48.750 21 1 1/2 Inch-City $5.01 $33.710 $38.723 14.87% 38.723 22 2 Inch Res, Com, Irr, Turf, Res MF $78.000 $78.000 0.00% 78.000 23 2 Inch-Other $78.000 $78.000 0.00% 78.000 24 2 Inch-Residential City $8.02 $53.930 $61.953 14.88% 61.953 25 2 Inch- Irrigation City $8.02 $53.930 $61.953 14.88% 61.953 26 3 Inch- Irr, Turf $156.000 $156.000 0.00% 156.000 27 3 Inch-Other $156.000 $156.000 0.00% 156.000 28 3 Inch City $16.05 $107.850 $123.900 14.88% 123.900 29 4 Inch- Res, Turf, Irr, Res MF $243.750 $243.750 0.00% 243.750 30 4 Inch City $25.07 $168.530 $193.603 14.88% 193.603 31 6 Inch-Com,Turf $487.500 $487.500 0.00% 487.500 32 6 Inch-City $50.15 $337.050 $387.200 14.88% 387.200 33 8 Inch-Com, Turf $702.000 $702.000 0.00% 702.000 34 Unmetered, Const, Maint $9.750 $9.750 0.00% 9.750 35 V-Golf Irrigation $702.000 $702.000 0.00% 702.000 (a) One third(1/3) of difference in monthly minimums between"City"and "Non City" customers added to "City"customers to eventually align rates. Gallons included in Monthly Usage Charge 2,000 2,000 0.00% 2,000 Commodity Rates Residential, Commercial and Resale Customers Charge per 1,000 Gallons in excess of gallons included in Monthly Usage Charge $1.71 $1.720 0.58% 1.720 Residential, Commercial and Resale Customers Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 Resale/La Cholla Airpart& Metro Water $1.45 $1.46 0.69% 1.460 Charge per 1,000 Gallons in excess of 10,000 Gallons $1.71 $1.720 0.58% 1.720 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule B Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30,1997 NO Increase in Monthly Minimums Commodity Rate Increased$0.01 Percent Percent of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,560,053 $8,567 0.34% 59.40% 57.72% 2 Proforma for actual customer change 37,551 37,673 122 0.32% 0.87% 0.85% 3 Proforma for Estimated customer Growth 79,811 80,081 270 0.34% 1.86% 1.81% 4 1 Inch Residential 10,361 10,389 28 0.27% 0.24% 0.23% 5 1.5 Inch Residential 770 771 1 0.14% 0.02% 0.02% 6 2 Inch Residential 55,514 55,761 246 0.44% 1.29% 1.26% 7 4 Inch Residential 19,456 19,550 94 0.48% 0.45% 0.44% 8 5/8 Inch Commercial 3,263 3,275 11 0.35% 0.08% 0.07% 9 1 Inch Commercial 17,117 17,182 65 0.38% 0.40% 0.39% 10 1.5 Inch Commercial 17,602 17,659 57 0.32% 0.41% 0.40% 11 2 Inch Commercial 87,242 87,603 361 0.41% 2.03% 1.98% 12 6 Inch Commercial 84,975 85,404 429 0.50% 1.98% 1.93% 13 6 Inch Resale 32,877 33,057 180 0.55% 0.77% 0.75% 14 8 Inch Commercial 18,567 18,576 9 0.05% 0.43% 0.42% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,233 223 0.57% 0.91% 0.88% 17 3 inch Turf 183,737 184,790 1,054 0.57% 4.28% 4.17% 18 4 Inch Turf 31,402 31,570 168 0.53% 0.73% 0.71% 19 6 Inch Turf 794,230 798,772 4,542 0.57% 18.49% 18.01% 20 5/8 Inch Irrigation 32,484 32,617 133 0.41% 0.76% 0.74% 21 1 inch Irrigation 70,648 70,926 278 0.39% 1.64% 1.60% 22 1.5 Inch Irrigation 33,057 33,174 117 0.35% 0.77% 0.75% 23 2 Inch Irrigation 137,566 138,109 543 0.39% 3.20% 3.11% 24 3 Inch Irrigation 24,976 25,087 110 0.44% 0.58% 0.57% 25 6 Inch Irrigation 122,054 122,732 679 0.56% 2.84% 2.77% 26 6 Inch/Rancho Vistoso Golf Course 52,925 52,925 0 0.00% 1.23% 1.19% 27 5/8 Inch Other 27,693 27,846 153 0.55% 0.64% 0.63% 28 1 Inch Other 3,294 3,306 12 0.38% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,878 10 0.35% 0.07% 0.06% 30 2 inch other 5,946 5,972 26 0.43% 0.14% 0.13% 31 3 Inch Other 2,416 2,419 3 0.13% 0.06% 0.05% 32 Unmetered 1,141 1,146 5 0.45% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 116,202 6,208 5.64% 2.56% 2.62% 34 1 Inch Residential City 3,888 4,084 196 5.04% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,658 205 5.94% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 631 32 5.41% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,065 10 0.92% 0.02% 0.02% 39 1 Inch Irrigation City 610 637 28 4.53% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,268 117 2.81% 0.10% 0.10% 41 5/8 Inch Other City 73 73 0 0.55% 0.00% 0.00% 42 1 Inch Other City 479 515 37 7.63% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,266,11.3 22,772 0.55% - 96.06% 96.19% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.72% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.23% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.73% 47 Reconnect Fees 6,100 6,100 0 0.00% 0.14% 0.14% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,435,212 22,772 0.53% 100.00% 100.00% Oro Valley Water Utility Rate Schedule 1 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 No Increase in Commodity Rates Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums 3.49% 2 Percentage Increase in Commodity Rates j 0.00% 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $10.090 3.49% 10.090 7 5/8 x 3/4 Inch-Other (a) $9.750 $10.090 3.49% 10.090 8 5/8 x 3/4 Inch- Residential City $1.11 $6.750 $7.863 16.49% 7.863 9 5/8 x 3/4 Inch-Commercial City $1.11 $6.750 $7.863 16.49% 7.863 10 5/8 x 3/4 Inch- Irrigation City $1.11 $6.750 $7.863 16.49% 7.863 11 5/8 x 3/4 Inch-Other City $1.11 $6.750 $7.863 16.49% 7.863 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr,Turf $24.380 $25.230 3.49% 25.230 14 1 Inch-Other $24.380 $25.230 3.49% 25.230 15 1 Inch- Residential City $2.79 $16.860 $19.650 16.55% 19.650 16 1 Inch-Commercial City $2.79 $16.860 $19.650 16.55% 19.650 17 1 Inch- Irrigation City $2.79 $16.860 $19.650 16.55% 19.650 18 1 Inch-Other City $2.79 $16.860 $19.650 16.55% 19.650 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $50.450 3.49% 50.450 20 1 1/2 Inch-Other $48.750 $50.450 3.49% 50.450 21 1 1/2 Inch-City $5.58 $33.710 $39.290 16.55% 39.290 22 2 Inch Res, Com, Irr, Turf, Res MF $78.000 $80.720 3.49% 80.720 23 2 Inch-Other $78.000 $80.720 3.49% 80.720 24 2 Inch- Residential City $8.93 $53.930 $62.860 16.56% 62.860 25 2 Inch- Irrigation City $8.93 $53.930 $62.860 16.56% 62.860 26 3 Inch- Irr, Turf $156.000 $161.440 3.49% 161.440 27 3 Inch-Other $156.000 $161.440 3.49% 161.440 28 3 Inch City $17.86 $107.850 $125.713 16.56% 125.713 29 4 Inch- Res, Turf, Irr, Res MF $243.750 $252.250 3.49% 252.250 30 4 Inch City $27.91 $168.530 $196.437 16.56% 196.437 31 6 Inch-Com,Turf $487.500 $504.500 3.49% 504.500 32 6 Inch- City $55.82 $337.050 $392.867 16.56% 392.867 33 8 Inch- Com, Turf $702.000 $725.760 3.38% 725.760 34 Unmetered, Const, Maint $9.750 $10.090 3.49% 10.090 35 V-Golf Irrigation $702.000 $725.760 3.38% 725.760 36 (a) One third (1/3) of difference in monthly minimums between "City"and "Non City" 37 customers added to "City"customers to align rates in three (3)years. 38 Gallons included in Monthly Usage Charge 2,000 1,000 -50.00% 1,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 43 gallons included in Monthly Usage Charge $1.71 $1.710 0.00% 1.710 44 45 Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 46 Resale/La Cholla Airpart& Metro Water $1.45 $1.45 0.00% 1.450 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 1 Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30, 1997 Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 No Increase in Commodity Rates Percent Percent of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,770,712 $219,226 8.59% 59.40% 59.62% 2 Proforma for actual customer change 37,551 41,066 3,515 9.36% 0.87% 0.88% 3 Proforma for Estimated customer Growth 79,811 86,873 7,062 8.85% 1.86% 1.87% 4 1 Inch Residential 10,361 10,887 526 5.08% 0.24% 0.23% 5 1.5 Inch Residential 770 811 41 5.32% 0.02% 0.02% 6 2 Inch Residential 55,514 56,275 760 1.37% 1.29% 1.21% 7 4 Inch Residential 19,456 19,595 140 0.72% 0.45% 0.42% 8 5/8 Inch Commercial 3,263 3,493 229 7.02% 0.08% 0.08% 9 1 Inch Commercial 17,117 17,673 556 3.25% 0.40% 0.38% 10 1.5 Inch Commercial 17,602 18,149 547 3.11% 0.41% 0.39% 11 2 Inch Commercial 87,242 88,665 1,423 1.63% 2.03% 1.91% 12 6 Inch Commercial 84,975 85,424 449 0.53% 1.98% 1.84% 13 6 Inch Resale 32,877 33,136 258 0.79% 0.77% 0.71% 14 8 Inch Commercial 18,567 19,156 589 3.17% 0.43% 0.41% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,062 51 0.13% 0.91% 0.84% 17 3 inch Turf 183,737 183,901 164 0.09% 4.28% 3.96% 18 4 Inch Turf 31,402 31,510 107 0.34% 0.73% 0.68% 19 6 Inch Turf 794,230 794,904 674 0.08% 18.49% 17.11% 20 5/8 Inch Irrigation 32,484 34,032 1,548 4.76% 0.76% 0.73% 21 1 inch Irrigation 70,648 72,659 2,011 2.85% 1.64% 1.56% 22 1.5 Inch Irrigation 33,057 33,908 851 2.57% 0.77% 0.73% 23 2 Inch Irrigation 137,566 139,928 2,362 1.72% 3.20% 3.01% 24 3 Inch Irrigation 24,976 25,252 275 1.10% 0.58% 0.54% 25 6 Inch Irrigation 122,054 122,278 225 0.18% 2.84% 2.63% 26 6 Inch/Rancho Vistoso Golf Course 52,925 53,214 289 0.55% 1.23% 1.15% 27 5/8 Inch Other 27,693 27,950 257 0.93% 0.64% 0.60% 28 1 Inch Other 3,294 3,378 84 2.54% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,945 77 2.67% 0.07% 0.06% 30 2 inch other 5,946 6,035 89 1.49% 0.14% 0.13% 31 3 Inch Other 2,416 2,498 82 3.41% 0.06% 0.05% 32 Unmetered 1,141 1,189 48 4.22% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 125,334 15,340 13.95% 2.56% 2.70% 34 1 Inch Residential City 3,888 4,212 324 8.33% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,708 255 7.40% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 653 54 9.01% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,187 131 12.40% 0.02% 0.03% 39 1 Inch Irrigation City 610 655 45 7.38% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,279 128 3.08% 0.10% 0.09% 41 5/8 Inch Other City 73 91 18 24.75% 0.00% 0.00% 42 1 Inch Other City 479 538 60 12.44% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,477,890 234,549 5.68% 96.06% 96.36% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.64% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.17% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees __ 6,_100 _ 6,100 _____ 0 0_.00%_____ _ 0_.14%_______ 0.13% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,646,989 234,549____ __ _5.46% 00.00% 100.00% Oro Valley Water Utility Rate Schedule 1 Analysis of Revenue by Detailed Class Page 3 Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 No Increase in Commodity Rates Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.86 $1.97 8.59% 2 1 Inch Residential 19 14,044 45.24 47.54 2.30 5.08% 3 1.5 Inch Residential 1 11,000 64.14 67.55 3.41 5.32% 4 2 Inch Residential MF 15 152,011 317.23 321.57 4.34 1.37% 5 4 Inch Residential MF 1 671,929 1,389.69 1,399.66 9.97 0.72% 6 5/8 Inch Commercial 15 7,602 18.03 19.30 1.27 7.02% 7 1 Inch Commercial 21 27,867 69.02 71.26 2.24 3.25% 8 1.5 Inch Commercial 14 37,000 108.65 112.03 3.38 3.11% 9 2 Inch Commercial 27 112,321 266.80 271.15 4.35 1.63% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,559.34 18.71 0.53% 11 6 Inch Resale 2 1,285,364 1,369.89 1,380.65 10.76 0.79% 12 8 Inch Commercial 2 42,875 773.61 798.15 24.54 3.17% 13 2 inch Truf 1 1,857,383 3,250.85 3,255.14 4.29 0.13% 14 3 inch Turf 2 4,582,435 7,655.69 7,662.54 6.85 0.09% 15 4 Inch Turf 1 1,528,636 2,854.76 2,864.51 9.74 0.34% 16 6 Inch Turf 3 12,618,639 22,061.95 22,080.66 18.71 0.08% 17 5/8 Inch Irrigation 83 14,795 32.45 34.00 1.55 4.76% 18 1 inch Irrigation 79 30,990 74.68 76.81 2.13 2.85% 19 1.5 Inch Irrigation 22 45,104 122.89 126.05 3.16 2.57% 20 2 Inch Irrigation 48 96,435 240.08 244.20 4.12 1.72% 21 3 Inch Irrigation 3 285,231 640.41 647.47 7.06 1.10% 22 4 Inch Irrigation 2 204,542 591.31 600.88 9.57 1.62% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,434.49 24.06 0.55% 24 58 Inch Other 13 102,460 182.19 183.88 1.69 0.93% 25 1 Inch Other 4 27,375 68.63 70.37 1.74 2.54% 26 1.5 Inch Other 2 43,167 119.50 122.70 3.20 2.67% 27 2 inch other 2 130,250 297.31 301.74 4.43 1.49% 28 3 Inch Other 1 28,333 201.32 208.18 6.87 3.41% 29 Unmetered 2 21,846 43.88 45.74 1.85 4.22% 30 58 Inch Construction 241 2,840 13.33 14.19 0.85 6.40% 31 1 Inch Construction 12 5,310 31.41 33.21 1.80 5.73% 32 1.5 Inch Construction 3 67,303 161.35 164.24 2.89 1.79% 33 2 Inch Construction 3 3,722 81.99 85.80 3.81 4.65% 34 3 Inch Construction 7 215,788 521.86 528.87 7.01 1.34% 35 Construction Unmetered 2 34,000 65.75 67.16 1.41 2.14% 36 5/8 Inch Residential City 483 9,035 18.99 21.64 2.65 13.95% 37 1 Inch Residential City 6 23,722 54.01 58.51 4.50 8.33% 38 2 Inch Residential City 2 54,583 143.85 154.49 10.64 7.40% 39 1 Inch Commercial City 1 21,333 49.92 54.42 4.50 9.01% 40 5/8 inch Irrigation City 4 21,333 21.11 23.73 2.62 12.40% 41 1 Inch Irrigation City 1 10,260 60.98 65.48 4.50 7.38% 42 2 Inch Irrigation City 1 172,750 345.91 356.55 10.64 3.08% 43 5/8 Inch Other City 1 1,700 7.26 9.06 1.80 24.75% 44 1 Inch Other City 1 12,000 34.20 38.46 4.26 12.44% 45 Unmetered Maintenance 1 70,429 128.47 129.67 1.19 0.93% Town of Oro Valley / Municipal Utilities Division Monthly Minimum Pricing Rate Schedule 1 Page 4 Monthly Minimums With $0.34 Meter Increase Flows on 5/8" In by Present Gallons 3/4 Meter Monthly Per Inch Size Minimums Minute Meters 5/8 x 3/4 $9.75 20 $10.09 3/4 30 1 $24.38 50 $25.23 1 1/2 $48.75 100 $50.45 2 $78.00 160 $80.72 3 $156.00 320 $161.44 4 $243.75 500 $252.25 6 $487.50 1,000 $504.50 8 $702.00 1,440 $726.48 Resulting Increase In Revenues with Annualized Number of Customers to 6/30/97, and Customer Growth of 780 Customers to 6/30/98 $ 234,549 Oro Valley Water Utility Rate Schedule 2 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.024314 increase in commodity rate Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums 0.00%' 2 Percentage Increase in Commodity Rates r. 1.42%: 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $9.750 0.00% 9.750 7 5/8 x 3/4 Inch-Other (a) $9.750 $9.750 0.00% 9.750 8 5/8 x 3/4 Inch-Residential City $1.00 $6.750 $7.750 14.81% 7.750 9 5/8 x 3/4 Inch-Commercial City $1.00 $6.750 $7.750 14.81% 7.750 10 5/8 x 3/4 Inch- Irrigation City $1.00 $6.750 $7.750 14.81% 7.750 11 5/8 x 3/4 Inch-Other City $1.00 $6.750 $7.750 14.81% 7.750 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr,Turf $24.380 $24.380 0.00% 24.380 14 1 Inch-Other $24.380 $24.380 0.00% 24.380 15 1 Inch- Residential City $2.51 $16.860 $19.367 14.87% 19.367 16 1 Inch-Commercial City $2.51 $16.860 $19.367 14.87% 19.367 17 1 Inch- Irrigation City $2.51 $16.860 $19.367 14.87% 19.367 18 1 Inch-Other City $2.51 $16.860 $19.367 14.87% 19.367 19 1 1/2 Inch- Res, Com, Irr,Turf $48.750 $48.750 0.00% 48.750 20 1 1/2 Inch-Other $48.750 $48.750 0.00% 48.750 21 1 1/2 Inch-City $5.01 $33.710 $38.723 14.87% 38.723 22 2 Inch Res, Com, Irr,Turf, Res MF $78.000 $78.000 0.00% 78.000 23 2 Inch-Other $78.000 $78.000 0.00% 78.000 24 2 Inch- Residential City $8.02 $53.930 $61.953 14.88% 61.953 25 2 Inch- Irrigation City $8.02 $53.930 $61.953 14.88% 61.953 26 3 Inch-Irr,Turf $156.000 $156.000 0.00% 156.000 27 3 Inch-Other $156.000 $156.000 0.00% 156.000 28 3 Inch City $16.05 $107.850 $123.900 14.88% 123.900 29 4 Inch- Res,Turf, Irr, Res MF $243.750 $243.750 0.00% 243.750 30 4 Inch City $25.07 $168.530 $193.603 14.88% 193.603 31 6 Inch-Com,Turf $487.500 $487.500 0.00% 487.500 32 6 Inch-City $50.15 $337.050 $387.200 14.88% 387.200 33 8 Inch-Com, Turf $702.000 $702.000 0.00% 702.000 • 34 Unmetered, Const, Maint $9.750 $9.750 0.00% 9.750 35 V-Golf Irrigation $702.000 $702.000 0.00% 702.000 36 (a) One third (1/3)of difference in monthly minimums between"City"and "Non City" 37 customers added to "City"customers to eventually align rates. 38 Gallons included in Monthly Usage Charge 2,000 1,000 -50.00% 1,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 43 gallons included in Monthly Usage Charge $1.71 $1.7343140 1.42% 1.734 44 45 Rancho Vistoso Golf Course $0.30 $0.3000000 0.00% 0.300 46 Resale/La Cholla Airpart&Metro Water $1.45 $1.47431400 1.68% 1.474 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 2 Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30, 1997 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.024314 increase in commodity rate($.02 increase in Commodity Rates Percent Percent would produce a$226,945 Rate Increase, $03 Increase produces $245,081 ) of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change, Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,756,227 $204,741 8.02% 59.40% 59.31% 2 Proforma for actual customer change 37,551 40,821 3,270 8.71% 0.87% 0.88% 3 Proforma for Estimated customer Growth 79,811 86,443 6,632 8.31% 1.86% 1.86% 4 1 Inch Residential 10,361 10,765 404 3.90% 0.24% 0.23% 5 1.5 Inch Residential 770 793 23 3.05% 0.02% 0.02% 6 2 Inch Residential 55,514 56,410 895 1.61% 1.29% 1.21% 7 4 Inch Residential 19,456 19,705 249 1.28% 0.45% 0.42% 8 5/8 Inch Commercial 3,263 3,477 213 6.53% 0.08% 0.07% 9 1 Inch Commercial 17,117 17,625 508 2.97% 0.40% 0.38% 10 1.5 Inch Commercial 17,602 18,015 414 2.35% 0.41% 0.39% 11 2 Inch Commercial 87,242 88,661 1,419 1.63% 2.03% 1.91% 12 6 Inch Commercial 84,975 86,059 1,084 1.28% 1.98% 1.85% 13 6 Inch Resale 32,877 33,335 457 1.39% 0.77% 0.72% 14 8 Inch Commercial 18,567 18,608 41 0.22% 0.43% 0.40% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,571 560 1.44% 0.91% 0.85% 17 3 inch Turf 183,737 186,338 2,601 1.42% 4.28% 4.01% 18 4 Inch Turf 31,402 31,825 422 1.34% 0.73% 0.68% 19 6 Inch Turf 794,230 805,336 11,106 1.40% 18.49% 17.33% 20 5/8 Inch Irrigation 32,484 34,031 1,548 4.76% 0.76% 0.73% 21 1 inch Irrigation 70,648 72,549 1,901 2.69% 1.64% 1.56% 22 1.5 Inch Irrigation 33,057 33,740 682 2.06% 0.77% 0.73% 23 2 Inch Irrigation 137,566 139,701 2,136 1.55% 3.20% 3.01% 24 3 Inch Irrigation 24,976 25,309 333 1.33% 0.58% 0.54% 25 6 Inch Irrigation 122,054 123,724 1,670 1.37% 2.84% 2.66% 26 6 Inch/Rancho Vistoso Golf Course 52,925 52,929 4 0.01% 1.23% 1.14% 27 5/8 Inch Other 27,693 28,274 581 2.10% 0.64% 0.61% 28 1 Inch Other 3,294 3,368 74 2.23% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,929 61 2.11% 0.07% 0.06% 30 2 inch other 5,946 6,043 97 1.63% 0.14% 0.13% 31 3 Inch Other 2,416 2,441 25 1.04% 0.06% 0.05% 32 Unmetered 1,141 1,194 53 4.60% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 125,812 15,818 14.38% 2.56% 2.71% 34 1 Inch Residential City 3,888 4,232 343 8.83% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,717 265 7.67% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 656 57 9.44% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,192 137 12.93% 0.02% 0.03% 39 1 Inch Irrigation City 610 658 49 7.98% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,318 167 4.02% 0.10% 0.09% 41 5/8 Inch Other City 73 90 17 23.42% 0.00% 0.00% 42 1 Inch Other City 479 538 59 12.40% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,478,110 234,769 5.69% 96.06% 96.36% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.64% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.17% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees _ _ 6,_100_ 6,100 _ 0_ 0.00% __ 0.14%_ _ 0.13% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,647,209 234,769 5.47% 100.00% 100.00% Oro Valley Water Utility Rate Schedule 2 Analysis of Revenue by Detailed Class Page 3 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.024314 increase in commodity rate Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.73 $1.84 8.02% 2 1 Inch Residential 19 14,044 45.24 47.01 1.77 3.90% 3 1.5 Inch Residential 1 11,000 64.14 66.09 1.95 3.05% 4 2 Inch Residential MF 15 152,011 317.23 322.34 5.12 1.61% 5 4 Inch Residential MF 1 671,929 1,389.69 1,407.47 17.78 1.28% 6 5/8 Inch Commercial 15 7,602 18.03 19.21 1.18 6.53% 7 1 Inch Commercial 21 27,867 69.02 71.07 2.05 2.97% 8 1.5 Inch Commercial 14 37,000 108.65 111.21 2.55 2.35% 9 2 Inch Commercial 27 112,321 266.80 271.13 4.34 1.63% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,585.78 45.15 1.28% 11 6 Inch Resale 2 1,285,364 1,369.89 1,388.95 19.06 1.39% 12 8 Inch Commercial 2 42,875 773.61 775.33 1.72 0.22% 13 2 inch Truf 1 1,857,383 3,250.85 3,297.55 46.70 1.44% 14 3 inch Turf 2 4,582,435 7,655.69 7,764.08 108.39 1.42% 15 4 Inch Turf 1 1,528,636 2,854.76 2,893.15 38.39 1.34% 16 6 Inch Turf 3 12,618,639 22,061.95 22,370.45 308.50 1.40% 17 5/8 Inch Irrigation 83 14,795 32.45 34.00 1.55 4.76% 18 1 inch Irrigation 79 30,990 74.68 76.69 2.01 2.69% 19 1.5 Inch Irrigation 22 45,104 122.89 125.43 2.54 2.06% 20 2 Inch Irrigation 48 96,435 240.08 243.81 3.73 1.55% 21 3 Inch Irrigation 3 285,231 640.41 648.95 8.53 1.33% 22 4 Inch Irrigation 2 204,542 591.31 597.20 5.89 1.00% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,410.73 0.30 0.01% 24 58 Inch Other 13 102,460 182.19 186.01 3.82 2.10% 25 1 Inch Other 4 27,375 68.63 70.16 1.53 2.23% 26 1.5 Inch Other 2 43,167 119.50 122.02 2.52 2.11% 27 2 inch other 2 130,250 297.31 302.16 4.85 1.63% 28 3 Inch Other 1 28,333 201.32 203.40 2.09 1.04% 29 Unmetered 2 21,846 43.88 45.90 2.02 4.60% 30 58 Inch Construction 241 2,840 13.33 13.87 0.54 4.04% 31 1 Inch Construction 12 5,310 31.41 32.39 0.98 3.12% 32 1.5 Inch Construction 3 67,303 161.35 164.04 2.69 1.67% 33 2 Inch Construction 3 3,722 81.99 83.09 1.10 1.34% 34 3 Inch Construction 7 215,788 521.86 528.46 6.60 1.26% 35 Construction Unmetered 2 34,000 65.75 67.63 1.88 2.86% 36 5/8 Inch Residential City 483 9,035 18.99 21.72 2.73 14.38% 37 1 Inch Residential City 6 23,722 54.01 58.77 4.77 8.83% 38 2 Inch Residential City 2 54,583 143.85 154.88 11.04 7.67% 39 1 Inch Commercial City 1 21,333 49.92 54.63 4.71 9.44% 40 5/8 inch Irrigation City 4 21,333 21.11 23.84 2.73 12.93% 41 1 Inch Irrigation City 1 10,260 60.98 65.85 4.87 7.98% 42 2 Inch Irrigation City 1 172,750 345.91 359.82 13.91 4.02% 43 5/8 Inch Other City 1 1,700 7.26 8.96 1.70 23.42% 44 1 Inch Other City 1 12,000 34.20 38.44 4.24 12.40% 45 Unmetered Maintenance 1 70,429 128.47 131.03 2.56 1.99% Oro Valley Water Utility Rate Schedule 2A Changes in Representative Rate Schedules Page 4 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.02 increase in commodity rate Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums 0.00% 2 Percentage Increase in Commodity Rates 1.17%' 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $9.750 0.00% 9.750 7 5/8 x 3/4 Inch-Other la) $ $9.750 0.00% 9.750 8 5/8 x 3/4 Inch- Residential City $1.00 $6.750 $7.750 14.81% 7.750 9 5/8 x 3/4 Inch-Commercial City $1.00 $6.750 $7.750 14.81% 7.750 10 5/8 x 3/4 Inch-Irrigation City $1.00 $6.750 $7.750 14.81% 7.750 11 5/8 x 3/4 Inch-Other City $1.00 $6.750 $7.750 14.81% 7.750 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr, Turf $24.380 $24.380 0.00% 24.380 14 1 Inch-Other $24.380 $24.380 0.00% 24.380 15 1 Inch- Residential City $2.51 $16.860 $19.367 14.87% 19.367 16 1 Inch-Commercial City $2.51 $16.860 $19.367 14.87% 19.367 17 1 Inch-Irrigation City $2.51 $16.860 $19.367 14.87% 19.367 18 1 Inch-Other City $2.51 $16.860 $19.367 14.87% 19.367 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $48.750 0.00% 48.750 20 1 1/2 Inch-Other $48.750 $48.750 0.00% 48.750 21 1 1/2 Inch-City $5.01 $33.710 $38.723 14.87% 38.723 22 2 Inch Res, Com, Irr,Turf, Res MF $78.000 $78.000 0.00% 78.000 23 2 Inch-Other $78.000 $78.000 0.00% 78.000 24 2 Inch - Residential City $8.02 $53.930 $61.953 14.88% 61.953 25 2 Inch- Irrigation City $8.02 $53.930 $61.953 14.88% 61.953 26 3 Inch- Irr, Turf $156.000 $156.000 0.00% 156.000 27 3 Inch-Other $156.000 $156.000 0.00% 156.000 28 3 Inch City $16.05 $107.850 $123.900 14.88% 123.900 29 4 Inch-Res, Turf, Irr, Res MF $243.750 $243.750 0.00% 243.750 30 4 Inch City $25.07 $168.530 $193.603 14.88% 193.603 31 6 Inch-Com, Turf $487.500 $487.500 0.00% 487.500 32 6 Inch-City $50.15 $337.050 $387.200 14.88% 387.200 33 8 Inch-Com, Turf $702.000 $702.000 0.00% 702.000 34 Unmetered, Const, Maint $9.750 $9.750 0.00% 9.750 35 V-Golf Irrigation $702.000 $702.000 0.00% 702.000 36 (a) One third (1/3) of difference in monthly minimums between "City"and"Non City" 37 customers added to"City"customers to eventually align rates. 38 Gallons included in Monthly Usage Charge 2,000 1,000 -50.00% 1,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 43 gallons included in Monthly Usage Charge $1.71 $1.730 1.17% 1.730 44 45 Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 46 Resale/La Cholla Airpart& Metro Water $1.45 $1.47 1.38% 1.470 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 2A Present and Proposed Rates Without Conservation Page 5 For Year Ended November 30, 1997 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.02 increase in commodity rate($.024314 increase in Commodity Rates Percent Percent would produce the recommended$234,766 Rate Increase) of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,752,074 $200,587 7.86% 59.40% 59.32% 2 Proforma for actual customer change 37,551 40,761 3,210 8.55% 0.87% 0.88% 3 Proforma for Estimated customer Growth 79,811 86,312 6,500 8.14% 1.86% 1.86% 4 1 Inch Residential 10,361 10,752 392 3.78% 0.24% 0.23% 5 1.5 Inch Residential 770 793 23 2.98% 0.02% 0.02% 6 2 Inch Residential 55,514 56,303 788 1.42% 1.29% 1.21% 7 4 Inch Residential 19,456 19,664 208 1.07% 0.45% 0.42% 8 5/8 Inch Commercial 3,263 3,471 208 6.37% 0.08% 0.07% 9 1 Inch Commercial 17,117 17,596 479 2.80% 0.40% 0.38% 10 1.5 Inch Commercial 17,602 17,990 389 2.21% 0.41% 0.39% 11 2 Inch Commercial 87,242 88,504 1,262 1.45% 2.03% 1.91% 12 6 Inch Commercial 84,975 85,874 899 1.06% 1.98% 1.85% 13 6 Inch Resale 32,877 33,257 380 1.16% 0.77% 0.72% 14 8 Inch Commercial 18,567 18,604 37 0.20% 0.43% 0.40% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,475 464 1.19% 0.91% 0.85% 17 3 inch Turf 183,737 185,883 2,147 1.17% 4.28% 4.01% 18 4 Inch Turf 31,402 31,752 350 1.11% 0.73% 0.68% 19 6 Inch Turf 794,230 803,377 9,146 1.15% 18.49% 17.32% 20 5/8 Inch Irrigation 32,484 33,971 1,487 4.58% 0.76% 0.73% 21 1 inch Irrigation 70,648 72,426 1,778 2.52% 1.64% 1.56% 22 1.5 Inch Irrigation 33,057 33,689 631 1.91% 0.77% 0.73% 23 2 Inch Irrigation 137,566 139,465 1,899 1.38% 3.20% 3.01% 24 3 Inch Irrigation 24,976 25,261 285 1.14% 0.58% 0.54% 25 6 Inch Irrigation 122,054 123,431 1,378 1.13% 2.84% 2.66% 26 6 Inch /Rancho Vistoso Golf Course 52,925 52,929 4 0.01% 1.23% 1.14% 27 5/8 Inch Other 27,693 28,207 514 1.86% 0.64% 0.61% 28 1 Inch Other 3,294 3,362 68 2.07% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,924 56 1.96% 0.07% 0.06% 30 2 inch other 5,946 6,032 86 1.44% 0.14% 0.13% 31 3 Inch Other 2,416 2,439 24 0.98% 0.06% 0.05% 32 Unmetered 1,141 1,191 50 4.40% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 125,611 15,616 14.20% 2.56% 2.71% 34 1 Inch Residential City 3,888 4,225 336 8.65% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,712 259 7.51% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 655 55 9.26% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,190 135 12.74% 0.02% 0.03% 39 1 Inch Irrigation City 610 657 48 7.79% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,309 158 3.81% 0.10% 0.09% 41 5/8 Inch Other City 73 90 17 23.38% 0.00% 0.00% 42 1 Inch Other City 479 538 59 12.26% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,470,286 226,945 5.50% 96.06% 96.36% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.65% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.18% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees __ 6_,_100_ 6,100 __ 0 ____0.00%_____ 0._14%_ _ 0.13% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,639,385 226,945 5.28% 100.00% 100.00% Oro Valley Water Utility Rate Schedule 2A Analysis of Revenue by Detailed Class Page 6 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.02 increase in commodity rate Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.69 $1.80 7.86% 2 1 Inch Residential 19 14,044 45.24 46.95 1.71 3.78% 3 1.5 Inch Residential 1 11,000 64.14 66.05 1.91 2.98% 4 2 Inch Residential MF 15 152,011 317.23 321.73 4.50 1.42% 5 4 Inch Residential MF 1 671,929 1,389.69 1,404.58 14.89 1.07% 6 5/8 Inch Commercial 15 7,602 18.03 19.18 1.15 6.37% 7 1 Inch Commercial 21 27,867 69.02 70.95 1.93 2.80% 8 1.5 Inch Commercial 14 37,000 108.65 111.05 2.40 2.21% 9 2 Inch Commercial 27 112,321 266.80 270.65 3.86 1.45% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,578.07 37.44 1.06% 11 6 Inch Resale 2 1,285,364 1,369.89 1,385.72 15.83 1.16% 12 8 Inch Commercial 2 42,875 773.61 775.16 1.55 0.20% 13 2 inch Truf 1 1,857,383 3,250.85 3,289.54 38.70 1.19% 14 3 inch Turf 2 4,582,435 7,655.69 7,745.14 89.45 1.17% 15 4 Inch Turf 1 1,528,636 2,854.76 2,886.56 31.80 1.11% 16 6 Inch Turf 3 12,618,639 22,061.95 22,316.02 254.06 1.15% 17 5/8 Inch Irrigation 83 14,795 32.45 33.94 1.49 4.58% 18 1 inch Irrigation 79 30,990 74.68 76.56 1.88 2.52% 19 1.5 Inch Irrigation 22 45,104 122.89 125.24 2.35 1.91% 20 2 Inch Irrigation 48 96,435 240.08 243.39 3.31 1.38% 21 3 Inch Irrigation 3 285,231 640.41 647.72 7.31 1.14% 22 4 Inch Irrigation 2 204,542 591.31 596.34 5.04 0.85% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,410.73 0.30 0.01% 24 58 Inch Other 13 102,460 182.19 185.57 3.38 1.86% 25 1 Inch Other 4 27,375 68.63 70.04 1.42 2.07% 26 1.5 Inch Other 2 43,167 119.50 121.84 2.34 1.96% 27 2 inch other 2 130,250 297.31 301.60 4.30 1.44% 28 3 Inch Other 1 28,333 201.32 203.29 1.97 0.98% 29 Unmetered 2 21,846 43.88 45.81 1.93 4.40% 30 58 Inch Construction 241 2,840 13.33 13.87 0.53 4.01% 31 1 Inch Construction 12 5,310 31.41 32.39 0.98 3.11% 32 1.5 Inch Construction 3 67,303 161.35 163.77 2.42 1.50% 33 2 Inch Construction 3 3,722 81.99 83.09 1.10 1.34% 34 3 Inch Construction 7 215,788 521.86 527.57 5.71 1.09% 35 Construction Unmetered 2 34,000 65.75 67.49 1.74 2.64% 36 5/8 Inch Residential City 483 9,035 18.99 21.68 2.70 14.20% 37 1 Inch Residential City 6 23,722 54.01 58.68 4.67 8.65% 38 2 Inch Residential City 2 54,583 143.85 154.65 10.81 7.51% 39 1 Inch Commercial City 1 21,333 49.92 54.54 4.62 9.26% 40 5/8 inch Irrigation City 4 21,333 21.11 23.80 2.69 12.74% 41 1 Inch Irrigation City 1 10,260 60.98 65.73 4.75 7.79% 42 2 Inch Irrigation City 1 172,750 345.91 359.08 13.17 3.81% 43 5/8 Inch Other City 1 1,700 7.26 8.96 1.70 23.38% 44 1 Inch Other City 1 12,000 34.20 38.40 4.19 12.26% 45 Unmetered Maintenance 1 70,429 128.47 130.73 2.25 1.75% Oro Valley Water Utility Rate Schedule 2B Changes in Representative Rate Schedules Page 7 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.03 increase in commodity rate Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums 2 Percentage Increase in Commodity Rates 1.75%' 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $9.750 0.00% 9.750 7 5/8 x 3/4 Inch-Other (a) $9.750 $9.750 0.00% 9.750 8 5/8 x 3/4 Inch- Residential City $1.00 $6.750 $7.750 14.81% 7.750 9 5/8 x 3/4 Inch-Commercial City $1.00 $6.750 $7.750 14.81% 7.750 10 5/8 x 3/4 Inch-Irrigation City $1.00 $6.750 $7.750 14.81% 7.750 11 5/8 x 3/4 Inch-Other City $1.00 $6.750 $7.750 14.81% 7.750 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch-Res, Com, Irr,Turf $24.380 $24.380 0.00% 24.380 14 1 Inch-Other $24.380 $24.380 0.00% 24.380 15 1 Inch- Residential City $2.51 $16.860 $19.367 14.87% 19.367 16 1 Inch- Commercial City $2.51 $16.860 $19.367 14.87% 19.367 17 1 Inch- Irrigation City $2.51 $16.860 $19.367 14.87% 19.367 18 1 Inch-Other City $2.51 $16.860 $19.367 14.87% 19.367 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $48.750 0.00% 48.750 20 1 1/2 Inch-Other $48.750 $48.750 0.00% 48.750 21 1 1/2 Inch-City $5.01 $33.710 $38.723 14.87% 38.723 22 2 Inch Res, Com, Irr,Turf, Res MF $78.000 $78.000 0.00% 78.000 23 2 Inch-Other $78.000 $78.000 0.00% 78.000 24 2 Inch- Residential City $8.02 $53.930 $61.953 14.88% 61.953 25 2 Inch- Irrigation City $8.02 $53.930 $61.953 14.88% 61.953 26 3 Inch- Irr, Turf $156.000 $156.000 0.00% 156.000 27 3 Inch-Other $156.000 $156.000 0.00% 156.000 28 3 Inch City $16.05 $107.850 $123.900 14.88% 123.900 29 4 Inch- Res, Turf, Irr, Res MF $243.750 $243.750 0.00% 243.750 30 4 Inch City $25.07 $168.530 $193.603 14.88% 193.603 31 6 Inch-Com, Turf $487.500 $487.500 0.00% 487.500 32 6 Inch-City $50.15 $337.050 $387.200 14.88% 387.200 33 8 Inch-Com, Turf $702.000 $702.000 0.00% 702.000 34 Unmetered, Const, Maint $9.750 $9.750 0.00% 9.750 35 V-Golf Irrigation $702.000 $702.000 0.00% 702.000 36 (a) One third(1/3) of difference in monthly minimums between"City"and "Non City" 37 customers added to "City"customers to eventually align rates. 38 Gallons included in Monthly Usage Charge 2,000 1,000 -50.00% 1,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 43 gallons included in Monthly Usage Charge $1.71 $1.740 1.75% 1.740 44 45 Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 46 Resale/La Cholla Airpart& Metro Water $1.45 $1.48 2.07% 1.480 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 2B Present and Proposed Rates Without Conservation Page 8 For Year Ended November 30, 1997 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.03 increase in commodity rate($.024314 increase in Commodity Rates Percent Percent would produce the recommended $234,766 Rate Increase) of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,761,701 $210,214 8.24% 59.40% 59.30% 2 Proforma for actual customer change 37,551 40,900 3,349 8.92% 0.87% 0.88% 3 Proforma for Estimated customer Growth 79,811 86,616 6,805 8.53% 1.86% 1.86% 4 1 Inch Residential 10,361 10,782 421 4.07% 0.24% 0.23% 5 1.5 Inch Residential 770 794 24 3.13% 0.02% 0.02% 6 2 Inch Residential 55,514 56,551 1,036 1.87% 1.29% 1.21% 7 4 Inch Residential 19,456 19,758 302 1.55% 0.45% 0.42% 8 5/8 Inch Commercial 3,263 3,484 220 6.75% 0.08% 0.07% 9 1 Inch Commercial 17,117 17,662 546 3.19% 0.40% 0.38% 10 1.5 Inch Commercial 17,602 18,049 447 2.54% 0.41% 0.39% 11 2 Inch Commercial 87,242 88,868 1,626 1.86% 2.03% 1.91% 12 6 Inch Commercial 84,975 86,303 1,327 1.56% 1.98% 1.85% 13 6 Inch Resale 32,877 33,437 560 1.70% 0.77% 0.72% 14 8 Inch Commercial 18,567 18,613 47 0.25% 0.43% 0.40% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,697 687 1.76% 0.91% 0.85% 17 3 inch Turf 183,737 186,937 3,201 1.74% 4.28% 4.01% 18 4 Inch Turf 31,402 31,920 518 1.65% 0.73% 0.69% 19 6 Inch Turf 794,230 807,919 13,689 1.72% 18.49% 17.35% 20 5/8 Inch Irrigation 32,484 34,111 1,627 5.01% 0.76% 0.73% 21 1 inch Irrigation 70,648 72,711 2,063 2.92% 1.64% 1.56% 22 1.5 Inch Irrigation 33,057 33,808 750 2.27% 0.77% 0.73% 23 2 Inch Irrigation 137,566 140,013 2,447 1.78% 3.20% 3.01% 24 3 Inch Irrigation 24,976 25,372 396 1.58% 0.58% 0.54% 25 6 Inch Irrigation 122,054 124,110 2,056 1.68% 2.84% 2.66% 26 6 Inch/Rancho Vistoso Golf Course 52,925 52,929 4 0.01% 1.23% 1.14% 27 5/8 Inch Other 27,693 28,361 669 2.41% 0.64% 0.61% 28 1 Inch Other 3,294 3,375 81 2.45% 0.08% 0.07% 29 1.5 Inch Other 2,868 2,934 66 2.31% 0.07% 0.06% 30 2 inch other 5,946 6,058 112 1.88% 0.14% 0.13% 31 3 Inch Other 2,416 2,443 27 1.12% 0.06% 0.05% 32 Unmetered 1,141 1,197 56 4.87% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 126,077 16,083 14.62% 2.56% 2.71% 34 1 Inch Residential City 3,888 4,241 353 9.07% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,725 272 7.88% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 657 58 9.67% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,195 139 13.18% 0.02% 0.03% 39 1 Inch Irrigation City 610 660 50 8.23% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,330 179 4.30% 0.10% 0.09% 41 5/8 Inch Other City 73 90 17 23.48% 0.00% 0.00% 42 1 Inch Other City 479 539 60 12.58% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,488,422 245,081 5.94% 96.06% 96.37% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.64% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.17% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees 6,100 _ 6,100 __ 0 __ 0.00%__ 0.14% _ 0.13% evenue-Water Sales and Proformas $4,295,078, $4,657,521 245,081 5.71% 100.00% 100.00% 48 Total R - -- ---- - Oro Valley Water Utility Rate Schedule 2B Analysis of Revenue by Detailed Class Page 9 NO Increase in Monthly Minimums Gallons included in Minimum Decreased to 1,000 $0.03 increase in commodity rate Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.78 $1.89 8.24% 2 1 Inch Residential 19 14,044 45.24 47.08 1.84 4.07% 3 1.5 Inch Residential 1 11,000 64.14 66.15 2.01 3.13% 4 2 Inch Residential MF 15 152,011 317.23 323.15 5.92 1.87% 5 4 Inch Residential MF 1 671,929 1,389.69 1,411.29 21.60 1.55% 6 5/8 Inch Commercial 15 7,602 18.03 19.25 1.22 6.75% 7 1 Inch Commercial 21 27,867 69.02 71.22 2.20 3.19% 8 1.5 Inch Commercial 14 37,000 108.65 111.41 2.76 2.54% 9 2 Inch Commercial 27 112,321 266.80 271.77 4.97 1.86% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,595.94 55.30 1.56% 11 6 Inch Resale 2 1,285,364 1,369.89 1,393.21 23.32 1.70% 12 8 Inch Commercial 2 42,875 773.61 775.55 1.94 0.25% 13 2 inch Truf 1 1,857,383 3,250.85 3,308.11 57.26 1.76% 14 3 inch Turf 2 4,582,435 7,655.69 7,789.04 133.36 1.74% 15 4 Inch Turf 1 1,528,636 2,854.76 2,901.84 47.07 1.65% 16 6 Inch Turf 3 12,618,639 22,061.95 22,442.19 380.24 1.72% 17 5/8 Inch Irrigation 83 14,795 32.45 34.08 1.63 5.01% 18 1 inch Irrigation 79 30,990 74.68 76.86 2.18 2.92% 19 1.5 Inch Irrigation 22 45,104 122.89 125.68 2.79 2.27% 20 2 Inch Irrigation 48 96,435 240.08 244.35 4.27 1.78% 21 3 Inch Irrigation 3 285,231 640.41 650.56 10.15 1.58% 22 4 Inch Irrigation 2 204,542 591.31 598.33 7.02 1.19% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,410.73 0.30 0.01% 24 58 Inch Other 13 102,460 182.19 186.59 4.40 2.41% 25 1 Inch Other 4 27,375 68.63 70.31 1.68 2.45% 26 1.5 Inch Other 2 43,167 119.50 122.27 2.76 2.31% 27 2 inch other 2 130,250 297.31 302.90 5.59 1.88% 28 3 Inch Other 1 28,333 201.32 203.56 2.25 1.12% 29 Unmetered 2 21,846 43.88 46.02 2.14 4.87% 30 58 Inch Construction 241 2,840 13.33 13.88 0.54 4.09% 31 1 Inch Construction 12 5,310 31.41 32.40 0.99 3.15% 32 1.5 Inch Construction 3 67,303 161.35 164.39 3.04 1.88% 33 2 Inch Construction 3 3,722 81.99 83.09 1.10 1.35% 34 3 Inch Construction 7 215,788 521.86 529.64 7.78 1.49% 35 Construction Unmetered 2 34,000 65.75 67.82 2.07 3.15% 36 5/8 Inch Residential City 483 9,035 18.99 21.76 2.78 14.62% 37 1 Inch Residential City 6 23,722 54.01 58.90 4.90 9.07% 38 2 Inch Residential City 2 54,583 143.85 155.19 11.34 7.88% 39 1 Inch Commercial City 1 21,333 49.92 54.75 4.83 9.67% 40 5/8 inch Irrigation City 4 21,333 21.11 23.90 2.78 13.18% 41 1 Inch Irrigation City 1 10,260 60.98 66.00 5.02 8.23% 42 2 Inch Irrigation City 1 172,750 345.91 360.80 14.89 4.30% 43 5/8 Inch Other City 1 1,700 7.26 8.97 1.71 23.48% 44 1 Inch Other City 1 12,000 34.20 38.51 4.30 12.58% 45 Unmetered Maintenance 1 70,429 128.47 131.43 2.95 2.30% Oro Valley Water Utility Rate Schedule 3 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers Increase in Monthly Minimums Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change age 1 Percentage Increase in Monthly Minimums �� 18.15% 2 Percentage Increase in Commodity Rates 0.00%: 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $11.520 18.15% 11.520 7 5/8 x 3/4 Inch-Other (a) $9.750 $11.520 18.15% 11.520 8 5/8 x 3/4 Inch- Residential City $1.59 $6.750 $8.340 23.56% 8.340 9 5/8 x 3/4 Inch-Commercial City $1.59 $6.750 $8.340 23.56% 8.340 10 5/8 x 3/4 Inch-Irrigation City $1.59 $6.750 $8.340 23.56% 8.340 11 5/8 x 3/4 Inch-Other City $1.59 $6.750 $8.340 23.56% 8.340 12 3/4 Inch $0.000 $0.000 NA 0.000 13 1 Inch- Res, Com, Irr, Turf $24.380 $28.800 18.13% 28.800 14 1 Inch-Other $24.380 $28.800 18.13% 28.800 15 1 Inch- Residential City $3.98 $16.860 $20.840 23.61% 20.840 16 1 Inch-Commercial City $3.98 $16.860 $20.840 23.61% 20.840 17 1 Inch- Irrigation City $3.98 $16.860 $20.840 23.61% 20.840 18 1 Inch-Other City $3.98 $16.860 $20.840 23.61% 20.840 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $57.600 18.15% 57.600 20 1 1/2 Inch-Other $48.750 $57.600 18.15% 57.600 21 1 1/2 Inch-City $7.96 $33.710 $41.673 23.62% 41.673 22 2 Inch Res, Com, Irr, Turf, Res MF $78.000 $92.160 18.15% 92.160 23 2 Inch-Other $78.000 $92.160 18.15% 92.160 24 2 Inch- Residential City $12.74 $53.930 $66.673 23.63% 66.673 25 2 Inch- Irrigation City $12.74 $53.930 $66.673 23.63% 66.673 26 3 Inch- Irr, Turf $156.000 $184.320 18.15% 184.320 27 3 Inch-Other $156.000 $184.320 18.15% 184.320 28 3 Inch City $25.49 $107.850 $133.340 23.63% 133.340 29 4 Inch- Res, Turf, Irr, Res MF $243.750 $288.000 18.15% 288.000 30 4 Inch City $39.82 $168.530 $208.353 23.63% 208.353 31 6 Inch-Com,Turf $487.500 $576.000 18.15% 576.000 32 6 Inch-City $79.65 $337.050 $416.700 23.63% 416.700 33 8 Inch-Com, Turf $702.000 $829.440 18.15% 829.440 34 Unmetered, Const, Maint $9.750 $11.520 18.15% 11.520 35 V-Golf Irrigation $702.000 $829.440 18.15% 829.440 36 (a) One third (1/3) of difference in monthly minimums between "City"and "Non City" 37 customers added to "City"customers to align rates in three (3)years. 38 Gallons included in Monthly Usage Charge 2,000 2,000 0.00% 2,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 43 gallons included in Monthly Usage Charge $1.71 $1.710 0.00% 1.710 44 45 Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 46 Resale/La Cholla Airpart&Metro Water $1.45 $1.45 0.00% 1.450 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 3 Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30, 1997 Increase in Monthly Minimums Percent Percent of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,748,748 $197,261 7.73% 59.40% 59.15% 2 Proforma for actual customer change 37,551 40,586 3,035 8.08% 0.87% 0.87% 3 Proforma for Estimated customer Growth 79,811 85,909 6,098 7.64% 1.86% 1.85% 4 1 Inch Residential 10,361 11,373 1,012 9.77% 0.24% 0.24% 5 1.5 Inch Residential 770 876 106 13.80% 0.02% 0.02% 6 2 Inch Residential 55,514 57,950 2,436 4.39% 1.29% 1.25% 7 4 Inch Residential 19,456 20,075 620 3.18% 0.45% 0.43% 8 5/8 Inch Commercial 3,263 3,504 241 7.38% 0.08% 0.08% 9 1 Inch Commercial 17,117 18,213 1,096 6.40% 0.40% 0.39% 10 1.5 Inch Commercial 17,602 19,035 1,434 8.15% 0.41% 0.41% 11 2 Inch Commercial 87,242 91,872 4,630 5.31% 2.03% 1.98% 12 6 Inch Commercial 84,975 87,099 2,124 2.50% 1.98% 1.87% 13 6 Inch Resale 32,877 34,116 1,239 3.77% 0.77% 0.73% 14 8 Inch Commercial 18,567 21,625 3,059 16.47% 0.43% 0.47% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 39,180 170 0.44% 0.91% 0.84% 17 3 inch Turf 183,737 184,388 651 0.35% 4.28% 3.97% 18 4 Inch Turf 31,402 31,889 487 1.55% 0.73% 0.69% 19 6 Inch Turf 794,230 797,416 3,186 0.40% 18.49% 17.16% 20 5/8 Inch Irrigation 32,484 34,256 1,772 5.45% 0.76% 0.74% 21 1 inch Irrigation 70,648 74,829 4,181 5.92% 1.64% 1.61% 22 1.5 Inch Irrigation 33,057 35,438 2,381 7.20% 0.77% 0.76% 23 2 Inch Irrigation 137,566 145,679 8,114 5.90% 3.20% 3.14% 24 3 Inch Irrigation 24,976 26,081 1,104 4.42% 0.58% 0.56% 25 6 Inch Irrigation 122,054 123,116 1,062 0.87% 2.84% 2.65% 26 6 Inch/Rancho Vistoso Golf Course 52,925 54,454 1,529 2.89% 1.23% 1.17% 27 5/8 Inch Other 27,693 27,962 269 0.97% 0.64% 0.60% 28 1 Inch Other 3,294 3,506 212 6.44% 0.08% 0.08% 29 1.5 Inch Other 2,868 3,080 212 7.41% 0.07% 0.07% 30 2 inch other 5,946 6,229 283 4.76% 0.14% 0.13% 31 3 Inch Other 2,416 2,756 340 14.07% 0.06% 0.06% 32 Unmetered 1,141 1,187 46 4.03% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 119,205 9,211 8.37% 2.56% 2.57% 34 1 Inch Residential City 3,888 4,175 287 7.37% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,758 306 8.86% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0.00% 0.00% 37 1 Inch Commercial City 599 647 48 7.97% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,135 80 7.53% 0.02% 0.02% 39 1 Inch Irrigation City 610 650 40 6.53% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,304 153 3.68% 0.10% 0.09% 41 5/8 Inch Other City 73 89 16 21.89% 0.00% 0.00% 42 1 Inch Other City 479 535 56 11.64% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,477,634 234,293 5.68% 96.06% 96.36% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.64% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.17% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees 6,100 6,100 0 0.00% 0.14% 0.13% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,646,733 234,293 5.45% 100.00% 100.00% Oro Valley Water Utility Rate Schedule 3 Analysis of Revenue by Detailed Class Page 3 Increase in Monthly Minimums Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.66 $1.77 7.73% 2 1 Inch Residential 19 14,044 45.24 49.66 4.42 9.77% 3 1.5 Inch Residential 1 11,000 64.14 72.99 8.85 13.80% 4 2 Inch Residential MF 15 152,011 317.23 331.14 13.92 4.39% 5 4 Inch Residential MF 1 671,929 1,389.69 1,433.94 44.25 3.18% 6 5/8 Inch Commercial 15 7,602 18.03 19.36 1.33 7.38% 7 1 Inch Commercial 21 27,867 69.02 73.44 4.42 6.40% 8 1.5 Inch Commercial 14 37,000 108.65 117.50 8.85 8.15% 9 2 Inch Commercial 27 112,321 266.80 280.96 14.16 5.31% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,629.13 88.50 2.50% 11 6 Inch Resale 2 1,285,364 1,369.89 1,421.51 51.63 3.77% 12 8 Inch Commercial 2 42,875 773.61 901.05 127.44 16.47% 13 2 inch Truf 1 1,857,383 3,250.85 3,265.01 14.16 0.44% 14 3 inch Turf 2 4,582,435 7,655.69 7,682.83 27.14 0.35% 15 4 Inch Turf 1 1,528,636 2,854.76 2,899.01 44.25 1.55% 16 6 Inch Turf 3 12,618,639 22,061.95 22,150.45 88.50 0.40% 17 5/8 Inch Irrigation 83 14,795 32.45 34.22 1.77 5.45% 18 1 inch Irrigation 79 30,990 74.68 79.10 4.42 5.92% 19 1.5 Inch Irrigation 22 45,104 122.89 131.74 8.85 7.20% 20 2 Inch Irrigation 48 96,435 240.08 254.24 14.16 5.90% 21 3 Inch Irrigation 3 285,231 640.41 668.73 28.32 4.42% 22 4 Inch Irrigation 2 204,542 591.31 635.56 44.25 7.48% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,537.87 127.44 2.89% 24 58 Inch Other 13 102,460 182.19 183.96 1.77 0.97% 25 1 Inch Other 4 27,375 68.63 73.05 4.42 6.44% 26 1.5 Inch Other 2 43,167 119.50 128.35 8.85 7.41% 27 2 inch other 2 130,250 297.31 311.47 14.16 4.76% 28 3 Inch Other 1 28,333 201.32 229.64 28.32 14.07% 29 Unmetered 2 21,846 43.88 45.65 1.77 4.03% 30 58 Inch Construction 241 2,840 13.33 15.10 1.77 13.27% 31 1 Inch Construction 12 5,310 31.41 35.83 4.42 14.07% 32 1.5 Inch Construction 3 67,303 161.35 170.20 8.85 5.48% 33 2 Inch Construction 3 3,722 81.99 96.15 14.16 17.27% 34 3 Inch Construction 7 215,788 521.86 550.18 28.32 5.43% 35 Construction Unmetered 2 34,000 65.75 67.52 1.77 2.69% 36 5/8 Inch Residential City 483 9,035 18.99 20.58 1.59 8.37% 37 1 Inch Residential City 6 23,722 54.01 57.99 3.98 7.37% 38 2 Inch Residential City 2 54,583 143.85 156.59 12.74 8.86% 39 1 Inch Commercial City 1 21,333 49.92 53.90 3.98 7.97% 40 5/8 inch Irrigation City 4 21,333 21.11 22.70 1.59 7.53% 41 1 Inch Irrigation City 1 10,260 60.98 64.96 3.98 6.53% 42 2 Inch Irrigation City 1 172,750 345.91 358.66 12.74 3.68% 43 5/8 Inch Other City 1 1,700 7.26 8.85 1.59 21.89% 44 1 Inch Other City 1 12,000 34.20 38.18 3.98 11.64% 45 Unmetered Maintenance 1 70,429 128.47 130.24 1.77 1.38% Oro Valley Water Utility Increase in Monthly Minimum Rate Schedule 3 Page 4 Monthly Minimums With $1.77 Meter Increase Flows on 5/8" In by Present Gallons 3/4 Meter Monthly Per Inch Size Minimums Minute Meters 5/8 x 3/4 $9.75 20 $11.52 3 / 4 30 1 $24.38 50 $28.80 1 1/2 $48.75 100 $57.60 2 $78.00 160 $92 .16 3 $156.00 320 $184.32 4 $243 .75 500 $288 .00 6 $487.50 1, 000 $576.00 8 $702.00 1,440 $829.44 Resulting Increase In Revenues with Annualized Number of Customers to 6/30/97, and Customer Growth of 780 Customers to 6/30/98 $ 234,293 Oro Valley Water Utility Rate Schedule 4 Changes in Representative Rate Schedules Page 1 Year Ended November 30, 1997 Phase-in increases to City Customers. In Three years rates are to be the same. Add to increase equation, 1/3 of differential between regular and City Customers Increase in Monthly Minimums 6.05% lncreease in Commodity Rates 5.26% Increase Line Customer Classification Present Proposed Percent Percent- No. and Meter Size Rates Rates Change ,................age 1 Percentage Increase in Monthly Minimums r 6.05% 2 Percentage Increase in Commodity Rates 5.26%': 3 4 Monthly Usage Charge for: 5 Residential,Commercial, Irrigation, Resale and Miscellaneous Customers 6 5/8 x 3/4 Inch Res, Com, Irr $9.750 $10.34 6.05% 10.340 7 5/8 x 3/4 Inch-Other ______(a)_ __ $9.750 $10.34 6.05% 10.340 8 5/8 x 3/4 Inch- Residential City $1.20 $6.750 $7.95 17.73% 7.947 9 5/8 x 3/4 Inch-Commercial City $1.20 $6.750 $7.95 17.73% 7.947 10 5/8 x 3/4 Inch-Irrigation City $1.20 $6.750 $7.95 17.73% 7.947 11 5/8 x 3/4 Inch-Other City $1.20 $6.750 $7.95 17.73% 7.947 12 3/4 Inch $0.000 $0.00 NA 0.000 13 1 Inch-Res, Com, Irr,Turf $24.380 $25.84 5.99% 25.840 14 1 Inch-Other $24.380 $25.84 5.99% 25.840 15 1 Inch- Residential City $2.99 $16.860 $19.85 17.75% 19.853 16 1 Inch-Commercial City $2.99 $16.860 $19.85 17.75% 19.853 17 1 Inch- Irrigation City $2.99 $16.860 $19.85 17.75% 19.853 18 1 Inch-Other City $2.99 $16.860 $19.85 17.75% 19.853 19 1 1/2 Inch- Res, Com, Irr, Turf $48.750 $51.68 6.01% 51.680 20 1 1/2 Inch-Other $48.750 $51.68 6.01% 51.680 21 1 1/2 Inch-City $5.99 $33.710 $39.70 17.77% 39.700 22 2 Inch Res, Com, Irr, Turf, Res MF $78.000 $82.68 6.00% 82.680 23 2 Inch-Other $78.000 $82.68 6.00% 82.680 24 2 Inch- Residential City $9.58 $53.930 $63.51 17.77% 63.513 25 2 Inch- Irrigation City $9.58 $53.930 $63.51 17.77% 63.513 26 3 Inch- Irr, Turf $156.000 $165.36 6.00% 165.360 27 3 Inch-Other $156.000 $165.36 6.00% 165.360 28 3 Inch City $19.17 $107.850 $127.02 17.77% 127.020 29 4 Inch- Res,Turf, Irr, Res MF $243.750 $258.38 6.00% 258.380 30 4 Inch City $29.95 $168.530 $198.48 17.77% 198.480 31 6 Inch-Corn,Turf $487.500 $516.75 6.00% 516.750 32 6 Inch-City $59.90 $337.050 $396.95 17.77% 396.950 33 8 Inch-Com, Turf $702.000 $744.12 6.00% 744.120 34 Unmetered, Const, Maint $9.750 $10.34 6.05% 10.340 35 V-Golf Irrigation $702.000 $744.12 6.00% 744.120 36 (a) One third (1/3) of difference in monthly minimums between"City"and "Non City" 37 customers added to "City"customers to align rates in three (3)years. 38 Gallons included in Monthly Usage Charge 2,000 2,000 0.00% 2,000 39 40 Commodity Rates Residential, Commercial and Resale Customers 41 42 Charge per 1,000 Gallons in excess of 1.799775 43 gallons included in Monthly Usage Charge $1.71 $1.800 5.26% 1.800 44 45 Rancho Vistoso Golf Course $0.30 $0.30 0.00% 0.300 46 Resale/La Cholla Airpart& Metro Water $1.45 $1.54 6.21% 1.540 Oro Valley Water Utility Summary of Revenues by Meter Size at Rate Schedule 4 Present and Proposed Rates Without Conservation Page 2 For Year Ended November 30, 1997 Increase in Monthly Minimums 6.05% lncreease in Commodity Rates 5.26% Percent Percent of of Present Proposed Line Customer Classification Present Proposed Dollar Percent Water Water No. and/or Meter Size Revenues Revenues Change Change Revenues Revenues 1 5/8 Inch Residential $2,551,487 $2,694,339 $142,853 5.60% 59.40% 57.97% 2 Proforma for actual customer change 37,551 39,659 2,108 5.61% 0.87% 0.85% 3 Proforma for Estimated customer Growth 79,811 84,276 4,465 5.59% 1.86% 1.81% 4 1 Inch Residential 10,361 10,947 586 5.65% 0.24% 0.24% 5 1.5 Inch Residential 770 815 45 5.83% 0.02% 0.02% 6 2 Inch Residential 55,514 58,535 3,021 5.44% 1.29% 1.26% 7 4 Inch Residential 19,456 20,505 1,049 5.39% 0.45% 0.44% 8 5/8 Inch Commercial 3,263 3,446 182 5.58% 0.08% 0.07% 9 1 Inch Commercial 17,117 18,062 945 5.52% 0.40% 0.39% 10 1.5 Inch Commercial 17,602 18,587 985 5.60% 0.41% 0.40% 11 2 Inch Commercial 87,242 92,022 4,780 5.48% 2.03% 1.98% 12 6 Inch Commercial 84,975 89,534 4,559 5.36% 1.98% 1.93% 13 6 Inch Resale 32,877 34,904 2,027 6.16% 0.77% 0.75% 14 8 Inch Commercial 18,567 19,661 1,094 5.89% 0.43% 0.42% 15 1.5 Inch Turf 0 0 0 0.00% 0.00% 0.00% 16 2 inch Truf 39,010 41,070 2,060 5.28% 0.91% 0.88% 17 3 inch Turf 183,737 193,433 9,697 5.28% 4.28% 4.16% 18 4 Inch Turf 31,402 33,075 1,673 5.33% 0.73% 0.71% 19 6 Inch Turf 794,230 836,161 41,931 5.28% 18.49% 17.99% 20 5/8 Inch Irrigation 32,484 34,271 1,787 5.50% 0.76% 0.74% 21 1 inch Irrigation 70,648 74,533 3,886 5.50% 1.64% 1.60% 22 1.5 Inch Irrigation 33,057 34,895 1,838 5.56% 0.77% 0.75% 23 2 Inch Irrigation 137,566 145,135 7,570 5.50% 3.20% 3.12% 24 3 Inch Irrigation 24,976 26,335 1,359 5.44% 0.58% 0.57% 25 6 Inch Irrigation 122,054 128,512 6,458 5.29% 2.84% 2.77% 26 6 Inch/Rancho Vistoso Golf Course 52,925 53,431 505 0.96% 1.23% 1.15% 27 5/8 Inch Other 27,693 29,162 1,469 5.31% 0.64% 0.63% 28 1 Inch Other 3,294 3,476 182 5.52% 0.08% 0.07% 29 1.5 Inch Other 2,868 3,028 160 5.57% 0.07% 0.07% 30 2 inch other 5,946 6,271 324 5.46% 0.14% 0.13% 31 3 Inch Other 2,416 2,557 141 5.83% 0.06% 0.06% 32 Unmetered 1,141 1,203 62 5.44% 0.03% 0.03% 33 5/8 Inch Residential City 109,994 120,658 10,663 9.69% 2.56% 2.60% 34 1 Inch Residential City 3,888 4,245 356 9.16% 0.09% 0.09% 35 2 Inch Residential City 3,452 3,796 344 9.95% 0.08% 0.08% 36 5/8 Inch Commercial City 0 0 0 0.00% 0,00% 0.00% 37 1 Inch Commercial City 599 656 57 9.48% 0.01% 0.01% 38 5/8 inch Irrigation City 1,056 1,153 98 9.25% 0.02% 0.02% 39 1 Inch Irrigation City 610 663 53 8.72% 0.01% 0.01% 40 2 Inch Irrigation City 4,151 4,450 299 7.21% 0.10% 0.10% 41 5/8 Inch Other City 73 85 12 16.85% 0.00% 0.00% 42 1 Inch Other City 479 534 55 11.42% 0.01% 0.01% 43 Total Water Revenues 4,125,979 4,478,670 235,329 5.70% 96.06% 96.36% 44 Meter Fee Income 76,329 76,329 0 0.00% 1.78% 1.64% 45 Miscellaneous Service Revenue 54,514 54,514 0 0.00% 1.27% 1.17% 46 Establishment Fees 32,156 32,156 0 0.00% 0.75% 0.69% 47 Reconnect Fees __ 6,_100__ 6,100____ _ 0__ _ ___0.00%___ 0_._14% _ _ 0.13% 48 Total Revenue-Water Sales and Proformas $4,295,078 $4,647,769 235,329. 5.48% 100.00% 100.00% Oro Valley Water Utility Rate Schedule 4 Analysis of Revenue by Detailed Class Page 3 Increase in Monthly Minimums 6.05% Increease in Commodity Rates 5.26% Average Number of Customer Customers Line Classification at Average Present Proposed Dollar Percent No. and/or Meter Size 11/30/97 Consumption Rates Rates Increase Increase 1 5/8 Inch Residential 9,287 9,625 $22.89 $24.18 $1.28 5.60% 2 1 Inch Residential 19 14,044 45.24 47.80 2.56 5.65% 3 1.5 Inch Residential 1 11,000 64.14 67.88 3.74 5.83% 4 2 Inch Residential MF 15 152,011 317.23 334.49 17.26 5.44% 5 4 Inch Residential MF 1 671,929 1,389.69 1,464.64 74.94 5.39% 6 5/8 Inch Commercial 15 7,602 18.03 19.04 1.01 5.58% 7 1 Inch Commercial 21 27,867 69.02 72.83 3.81 5.52% 8 1.5 Inch Commercial 14 37,000 108.65 114.74 6.08 5.60% 9 2 Inch Commercial 27 112,321 266.80 281.41 14.62 5.48% 10 6 Inch Commercial 2 1,787,458 3,540.63 3,730.58 189.94 5.36% 11 6 Inch Resale 2 1,285,364 1,369.89 1,454.33 84.44 6.16% 12 8 Inch Commercial 2 42,875 773.61 819.20 45.59 5.89% 13 2 inch Truf 1 1,857,383 3,250.85 3,422.52 171.67 5.28% 14 3 inch Turf 2 4,582,435 7,655.69 8,059.72 404.03 5.28% 15 4 Inch Turf 1 1,528,636 2,854.76 3,006.82 152.05 5.33% 16 6 Inch Turf 3 12,618,639 22,061.95 23,226.70 1,164.75 5.28% 17 5/8 Inch Irrigation 83 14,795 32.45 34.24 1.78 5.50% 18 1 inch Irrigation 79 30,990 74.68 78.79 4.11 5.50% 19 1.5 Inch Irrigation 22 45,104 122.89 129.72 6.83 5.56% 20 2 Inch Irrigation 48 96,435 240.08 253.29 13.21 5.50% 21 3 Inch Irrigation 3 285,231 640.41 675.27 34.86 5.44% 22 4 Inch Irrigation 2 204,542 591.31 623.79 32.48 5.49% 23 6 Inch Rancho Vistoso Golf C 1 12,363,417 4,410.43 4,452.55 42.12 0.96% 24 58 Inch Other 13 102,460 182.19 191.85 9.67 5.31% 25 1 Inch Other 4 27,375 68.63 72.42 3.79 5.52% 26 1.5 Inch Other 2 43,167 119.50 126.16 6.65 5.57% 27 2 inch other 2 130,250 297.31 313.53 16.22 5.46% 28 3 Inch Other 1 28,333 201.32 213.06 11.75 5.83% 29 Unmetered 2 21,846 43.88 46.27 2.39 5.44% 30 58 Inch Construction 241 2,840 13.33 14.02 0.68 5.12% 31 1 Inch Construction 12 5,310 31.41 32.98 1.57 5.00% 32 1.5 Inch Construction 3 67,303 161.35 169.82 8.47 5.25% 33 2 Inch Construction 3 3,722 81.99 86.70 4.71 5.75% 34 3 Inch Construction 7 215,788 521.86 549.84 27.98 5.36% 35 Construction Unmetered 2 34,000 65.75 69.29 3.54 5.38% 36 5/8 Inch Residential City 483 9,035 18.99 20.83 1.84 9.69% 37 1 Inch Residential City 6 23,722 54.01 58.95 4.95 9.16% 38 2 Inch Residential City 2 54,583 143.85 158.16 14.32 9.95% 39 1 Inch Commercial City 1 21,333 49.92 54.65 4.73 9.48% 40 5/8 inch Irrigation City 4 21,333 21.11 23.07 1.95 9.25% 41 1 Inch Irrigation City 1 10,260 60.98 66.29 5.32 8.72% 42 2 Inch Irrigation City 1 172,750 345.91 370.86 24.95 7.21% 43 5/8 Inch Other City 1 1,700 7.26 8.49 1.22 16.85% 44 1 Inch Other City 1 12,000 34.20 38.11 3.91 11.42% 45 Unmetered Maintenance 1 70,429 128.47 135.31 6.84 5.32% Oro Valley Water Utility Increase in Monthly Minimum Rate Schedule 4 Page 4 Monthly Minimums With 6 . 0000% + Meter Increase Flows on 5/8" In by Present Gallons 3/4 Meter Monthly Per Inch Size Minimums Minute Meters 5/8 x 3/4 $9.75 20 $ 10. 34 (a) 3 / 4 30 1 $24 . 38 50 $ 25. 84 (a) 1 1/2 $48 . 75 100 $ 51. 68 (a) 2 $78 . 00 160 $ 82 . 68 (a) 3 $156. 00 320 $ 165 . 36 (a) 4 $243 . 75 500 $ 258 . 38 (a) 6 $487 . 50 1, 000 $ 516. 75 (a) 8 $702 . 00 1, 440 $ 744 . 12 (a) Resulting Increase In Revenues with Annualized Number of Customers to 6/30/97, and Customer Growth of 780 Customers to 6/30/98 $ 235, 329 (a) Cents Rounded Oro Val ley Water Utility Town Council Meeting, June 18 , 1998 Index to Tabs and Schedules Tab Number Schedule 1 Text on Setting Rates and Rate Design Text 2 Cost of Service Study based on Actual Revenues Cost of and Expenses at November 30, 1997 Service 3 Revenues and Expenses for the Twelve Months ended Revenues & November 30, 1997 . Expenses as a percent of Expenses Revenues . 4 Impact of $0 . 10 Increase in Monthly Minimums Schedule A on 5/8 x 3/4 inch meters, and ratioed increases Page 2 of $0 . 10 per month to larger meters Increase = $ 18, 677 Impact of $0 . 01 Increase in Commodity Rates Schedule B Increase = $ 22, 772 Page 2 5 Reduce gallons included in Minimum from 2, 000 to Schedule 1 1, 000, and Increase in Monthly Minimums $0 . 34 Page 2 Increase = $ 234, 549 6 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates $0 . 024314 Increase in Commodity Rates, Pages 1-3 Schedule 2 Increase = $ 234, 769 Page 2 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates Schedule 2A $0 . 02 Increase in Commodity Rates, Pages 4-6 Page 5 Increase = $ 226, 945 Reduce gallons included in Minimum from 2, 000 to 1, 000, and Increase in Commodity Rates Schedule 2B $0 . 03 Increase in Commodity Rates, Pages 7-9 Page 8 Increase = $ 245, 081 7 Increase in Monthly Minimums of $1 . 77, Schedule 3 Increase = $ 234, 293 Page 2 8 Across the Board Increases in monthly minimums Schedule 4 and commodity rates Page 2 Increase = $ 235, 329