Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Packets - Council Packets (1392)
AGENDA ORO VALLEY TOWN COUNCIL BUDGET STUDY SESSION MAY 23, 2001 ORO VALLEY TOWN COUNCIL CHAMBERS 11,000 N. LA CANADA DRIVE STUDY SESSION - AT OR AFTER 6:00 PM CALL TO ORDER ROLL CALL 1. REVIEW OF MAY 21, 2001 BUDGET FOLLOW-UP ITEMS 2. WATER UTILITY DEPARTMENT • Enterprise Fund • Water Impact Fees Construction Fund • Water Impact Fees Debt Service Fund • Alternative Water Resources Fund • Water Company Acquisition 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 the Oro Valley Town Clerk, at 229-4700. POSTED: 5/21/01 4:30 p.m. Ih MEMORANDUM TO: Mayor and Council FROM: Chuck Sweet, Town Manager David Andrews, Finance Director DATE: May 23, 2001 SUBJ: Follow-up Issues from May 21 Budget Review Session A number of issues were raised during the budget session on May 21. This memorandum serves as staff follow-up to these issues. 1 . Issue: Organizational Chart for Library and Related Funding for Positions Response: Please refer to the attachments. 2. Issue: Ability of Departments to Support General Plan Update Response: In Progress 3. Issue: Funding for Friends of the Library Response: Staff recommends that funding of $9,200 be added to the FY 2001/02 budget as a one-time expenditures. 4. BudgetedComputers,Costs for Com uters, Scanners, Printers, Etc. Response: Staff will provide standard cost pricing for these items with FY 2002/03 budget. 5. Issue: Ceramic Street Tiles at Painted Sky Elementary Response: Funding for this item has been deleted from the budget. 6. Issue: Budgeted Salary for Legal Assistant Response: Estimated salary was budgeted at $27,997. Actual salary should be budgeted at $29,016. Cost increase of $1,016. Cost increase of $1 ,019 for salary plus $149 for social security and retirement for a total of $1,168. 7. Issue: Performance Measures for Magistrate Court Response: Performance measures for all departments are being revised based on coordination and direction from department head retreat. 8. Issue: Police Department — Emergency Vehicle Equipment Response: $14,000 will be added back to the Police Department's Non- Capitalized Equipment budget line item for this equipment. 9. Issue: Police Department— Prisoner Release Facility/La Canada Access/Secured Parking Area Projects Response: Current fiscal year estimated actuals of $85,700 for prisoner release facility will be reduced to $13,619. The balance of$72,081 will be brought forward to FY 2001/02 for completion of this project. Additionally, funding for the La Canada Access/Secured Parking Area project will be reduced by $30,000 to a budget of$190,000. The $30,000 will be added to the prisoner release facility project for a total project budget of $102,081 for FY 2001/02. 10. Issue: Funding for Additional Commissioned Personnel in the Police Department Response: Please see attached memorandum from Chief Sharp. CC: Dan Dudley, Town Attorney George Dunscomb, Town Magistrate Danny Sharp, Chief of Police Brent Sinclair, Community Development Director Bill Jansen, Town Engineer Jeff Grant, Human Resources Director r • Oro Valley Public Library Organization Chart (DRAFT) May 1, 2001 Citizens of Oro Valley Town Council Town Manager Friends of the 1 Tucson-Pima Oro Valley Community Development ,.••'"Public Library Public Library ..` -I'd Managing i Librarian 1,"� Senior Librarian Senior Library Associate Information Services Circulation Manager Librarian — Library Associate Circulation -- Customber Services Library Pages Representatives 2.5 FTE 3.5 FTE — Library Associate Information Services Librarian Children Services Secretary I r 1 TOWN OF ORO VALLEY COMMUNITY DEVELOPMENT LIBRARY SERVICES DIVISION GENERAL FUND FISCAL YEAR 2001-2002 BUDGETED EXPENDITURES AUTHORIZED POSITIONS&SALARIES CURRENT YR. BUDGET YEAR 2001-2002 No.of DEPT.REQUEST MANAGER REVIEW COUNCIL APPROVAL POSITIONS No.of $ No.of $ No.of $ AUTHORIZED POSITIONS AMOUNT POSITIONS AMOUNT POSITIONS AMOUNT 1 1 $ 60,000 1 $ 50,003 Managing Librarian , r 1 0 - 0 - Circulation Manager r ' 1 0 - 0 Information Specialist , ` _. 1 13,333 , Information Specialist Senior Librarian' 0 1 40,000 0 1 20,000 1, 10,000 , Senior Library Assistant" ' 1 20,000 1 10,000 , Adult Services Librarian" 0 0 1 20,000 1 10,000 Children Services Librarian — ' y �- 0 1 20,000_. 0 Teen Services Librarian �-1 12 22,500 2 22,500 Library Assistants*" 0• . 28,875 3.5 18,875 Customer Services Representative"" 0, 5.5 0, 4.5 22,500 2.5 12,500 Library Page""' 5,250 1 1,475 , 0 1 - ` Secretary I""' SUBTOTALS3 19 3 259,125 14 $ 148,686 _ 4,575 SALARY b WAGE ADJUSTMENTS TOTAL-SALARIES b WAGES 3 19 $ 259,125 14 S 153,261 • Assume a 4/1/02 start date with an annual salary of$53,333 "Assume a 4/1/02 start date with an annual salary of$40,000 "'Assume a 4/1/02 start date with an annual cost of$45,000 ""Assume a 4/1/02 start date with an annual cost of$75,500 "IP"Assume a 4/1/02 start date with an annual cost of S50,000 Assume a 6/1/02 start date with an annual salary of$17,700 917 Town of Oro Valley FY 2001/02 Town Budget Hard Expenditure Adjustments Per Town Council Review Through May 14,2001 Item Expenditure One-Time Recurring Description Impact Items Items Office Furniture-Admin. Building Decrease $ (29,300) Council Travel&Training Increase 2,600 Council Laptop Computers Decrease (5,000) Referendum Election Increase 28,000 Town Clerk-CD Burner Increase 300 Delay Hiring of Assistant Town Manager Decrease (15,114) Information Systems-OPS Increase 4,800 Audio Visual Equipment-Carryforward Increase 60,000 Pool Manager's Salary Increase 3,822 Parks&Recreation-Tool Locker Increase 500 GOVAC Request/July 4 Celebration Increase 36,941 Reclassification of HR Specialist Increase 2,000 Seed money for Friends of the Library Increase 9,200 Legal Assistant's Budgeted Salary Increase 1,168 Police Department- Emergency Vehicle Equipment Increase 14,000 Police Department- Prisoner Release Area Carryforward Increase 72,081 Police Department- Prisoner Release Area Increase 30,000 Police Department-La Canada Access/Secured Parking Area Decrease (30,000) Total $169,281 $ 16,717 Town of Oro Valley FY 2001/02 Town Budget Potential Additional Expenditure Adjustments Per Town Council Review Through May 14,2001 Item Expenditure One-Time Recurring Description Impact Items Items Accelerate Hiring of Budget Analyst Increase 12,864 Economic Development-Tax Base Analysis Increase 10,000 Economic Development-GTEC Recruiting Trips Increase 2,250 Economic Development- Real Estate Data Increase 850 Town Sponsorship of Fat Tire Bike Race Increase 3,000 Accelerate Hire Date for Fire Marshall Increase 18,741 Parks& Recreation-Special Events Funding Increase 43,750 Building Safety Reclassification-Building Inspector III to Plans Examiner Increase 8,050 Building Safety Reclassification- Dev.Tech Ito Dev.Tech. II Increase 3,019 Building Safety Reclassification-Building Inspector I (2)to Building Inspector II (2) Increase 4,092 Annexation Expenses Decrease (85,000) Total $ (85,000)_ $106,616 Y� � QOJLEqR/ r. �!, O � 11000 N. La Canada Dr. 11! �.. ,` Oro Valley, Arizona 85737 `"" � �T° � Phone (520) 229-4900 FAX (520) 797-2616 DANIEL G.SHARP,Chief of Police 1 www.ovpd.org • DEDAg�� ORO VALLEY POLICE DEPARTMENT "INTEGRITY, PRIDE, EXCELLENCE" MEMORANDUM DATE: May 22, 2001 TO: Mayor and Council FROM: ' ief Sharp RE: Follow Up From May 21 Budget Study Session Per your request I have attached listed expenses related to the classification of the Police Department's requested positions for this year's budget submission. I have also attached a copy of the current and proposed organization charts. In the proposed organizational chart the new positions are highlighted in yellow. In regard to the equipment needed relating to the requested positions it is my opinion that the Police Department's Anti-Racketeering funds are appropriate and permissible for these expenses. Further I believe the Department will have sufficient funds in the Seizure account to pay for the related equipment needs. TOWN OF ORO VALLEY POLICE FISCAL YEAR 2001-2002 Cost of Equipment per POSITION SALARY appx ERE Total Salary&ERE Related Equipment requested position Ballistic Vest, Weapon,Uniform Leather,Patches, OFFICER S 34,757.00 $10,427, $45,184 Radio wl Mic, $2,100 Ballistic Vest, Weapon,Uniform Leather,Patches, SERGEANT $ 52,915.00 $15,875 $68,790 Radio w/Mic, $2,100 Work Station,Chair, Telephone,Misc DETECTIVE S 36,941.00 $11,082 $48,023 Office Supplies $3,000 Ballistic Vest, Weapon,Uniform Leather,Patches, Radio w/Mic,Work LIEUTENANT $ 63,454.00 $19,036 $82,490 Station Computer $3,600 Work Station,Chair, Telephone,Misc SECRETARY $ 21,883.00 $6,565 $28,448 Office Supplies $3,000 Headset&hearing DISPATCHER S 26,333.00 $7,900 $34,233 test $300, VEHICLES:PATROL a$26,000(Fully Equipped) ADMIN a$18,000 .ri _ k, .. _.... ___ -...- ,,,,, C p `� CLT.,. -Ca, s ____ .• V1 d m y b 5 4FD- r..- r � z rri p, „, _ r 4.'izs 4• o a W © 5 H- r0.,„ Et ie-Dt,c, 0 a i _9 r ii:2, P $4 53 c4 41 g: "Z r) ' '8 04 ...i,,,, rn ...4, i K p..1. 53 c, o � i .0p_ '-i `� 1-- o ____ i,,, illi a ,00 M(7'om' '3+ lD ` n 2.4- g O i 9, o - 5.1(.9 ea r ti a• -,7-, O>- pay . 5 —mom a N,n, ,., 6- g.gd Cd} d•,....,~ ti 5.0 kr14p � v'arA= ;,*�O� �� . y a A' n CD • u, — L o ''�b • n"o 8•� w� ztc I.LIL- o p -,.' 2-'R.B y 5) 0 . r -.-6-,,,, O a ■t• n °A- r b 0b 9.5 aa r .--i co II:bQ, '4. I§ta r t. t. ,,, tt cn 2- a 0 x cO a, O ` r ►�IN �n o tv �� o ztv o „ y 9-:11 aa r tt H }v 0.._. 0 Pii . 5 cra 0 ', SEl bozo n w i.t.°aa r c„ FS O > Po o v, 5 O O-d +-� .. H4; a d� r°* g. 0 4 z g —yro CA gi C4"ti''.)1-- n— i 0 00 ORO VALLEY WATER UTILITY INTEROFFICE MEMORANDUM _ _ _ TO: Mayor and Council Members FROM: Alan Forrest,Water Utility Director AF VIA: Chuck Sweet,Town Manger DATE: May 21, 2001 SUBJECT: Proposed Revenue Increase&Related Water Rate Design CC: Shirley Seng,Utility Administrator David Andrews,Finance Director During the past several weeks, staff has received comments from several Council Members expressing concern about the proposed 7% revenue increase and the related rate design. Some of the issues discussed were: • The proposed increase vs. the rate of inflation • The impact to low end water users • Explore financing options to spread the capital costs over several years • Lack of projected revenue stream for alternative water revenue Staff worked with the rate consultant this past week to try to reduce the proposed revenue increase and/or re-design the rate structure for less impact to the low end users. In doing this, we reviewed our proposed budget and found that,with the exception of proposed capital outlay, the majority of our costs are determined by agencies other than the Town. Line items that could be reduced are estimated to represent less than 1% of the total budget. Based on direction received from Council to 1) remove golf courses from groundwater as soon as possible, 2) construct the plant identified in the master plan to increase service levels to existing customers, and 3) avoid any new debt if at all possible; staff determined that a 7% revenue increase was the lowest possible increase that could be implemented and still meet sound financial criteria. Projections used in the financial scenarios did not include revenue from customers using alternative water supplies. They did, however, include a loss of revenue as well as a reduction in power costs for years 4 and 5 when golf courses are removed from groundwater. If revenue from alternative water customers were to be included in the projections, the O&M and debt service expenses would also need to be included. Without knowing what alternative water source (CAP or effluent) the utility will be supplying or what delivery route will be constructed, staff chose to omit both revenue and expense projections. It is staff's opinion that the "best case" scenario is that alternative water revenue and expenses will be equal or "break even". It is unlikely that there will be a positive net income to help offset the projected loss realized by removing golf courses from groundwater. The followingrevenue scenarios were considered as a result of comments received: reared 10year projections that assume a 5% revenue increase in year 1 followed by 7% 1. Staff prepared revenue increases in all subsequent years. The projected expenditures are the same as those used inthe Annual Report. The results include consecutive net losses in years 3 - 10 and negative cash flowsggin year beginning 4. The debt service coverage remained adequate. It is projected that retained earnings will become negative in year 7. 2. Staffprep ared another scenario that used the same assumptions as scenario 1 with the exception of addingfinancingfor capital projects in January 2003. This was done to increase cash flows p and spread the cost of the capital improvements over 20 years. The results include consecutive p net losses inyears 3 - 10. The financingcreated stable cash flows, however, it has created a critical potential for falling below required the debt service coverage (1.0). Should anything arise in years 5 -10 the Town could default on bond covenants relating to debt unexpected service coverage. The following rate structures were considered as a result of comments received: A. In an effort to minimize the impact to low end water users, staff has prepared an option that p allows for a 4.9% increase in the base rate plus varying increases in the commodity rates. The average residential customer using 8,000 gallons of water will realize a 5% rate increase ($1.18/month).What makes this option work is that the usage allowed in the tiers will remain as theyexist today. Although the option will provide the 7% revenue increase the utility needs, it Y g p slowsg pro ress toward fixed cost recovery and continues to make the utility overly reliant on commodity sales to meet its revenue needs. B. An optional rate structure designed to generate a 5% revenue increase was also prepared. It is quite similar to Optionin thatprovides a A it 4.9% increase in the base rate plus varying . increases in the commodityrates. The average residential customer using 8,000 gallons of water will realize a 5% rate increase ($1.19/month). Modifications to the usage allowed in the tiers have also been made. As with Option A, this rate structure slows progress toward fixed cost recovery and continues to make the utility overly reliant on commodity sales to meet its revenue needs. C. Another b pon ex option explored staff was a 0% rate increase. All rates were to remain as they are p Y today, but the "free" 1,000 gallons in the base rate was removed. This did not generate enough revenue to be considered a viable option. Removal of the first 1,000 gallons combined with an increase in commodity rates could produce the desired revenue, but this option could no longer be considered a 0% rate increase. There is no attachment for this option since it was not considered by staff to be a viable option. Staff's recommendation is to implement the 7% revenue increase scenario as recommended by the Water UtilityCommission alongwith their proposed rate structure yielding a 6.7% rate increase for the average residential customer ($1.59/month). Attachments: 1. Summary page - 10 year projections - 5% revenue increase - no new debt 2. Summary page - 10 year projections - 5% revenue increase - new debt in January 2003 3. Summary page - 10 year projections - 7% revenue increase - Commission Preferred Scenario 4. Summary page - 10 year projections - 10% revenue increase - Commission Alternative Scenario A. Rate Structure - 7% revenue increase - 5% rate increase - Option A B. Rate Structure - 5% revenue increase - 5% rate increase - Option B C. Rate Structure - 7% revenue increase - 6.7% rate increase - Commission Recommendation D. Rate Structure - 10% revenue increase 9.1% rate increase - Commission Alternative +br Proposed Rate Design Water Utility Commission Recommendation Produces 7% Revenue Increase Average Residential Customer Using 8,000 Gallons 6.7% Rate Increase= $1.59/month The following rates are for 5/8" x 3/4" meters: Current Proposed Current Proposed Percent Gallons Included Gallons Included Rate Rate Increase Base Rate 1,000 1,000 $11.25 $12.00 6.67% Tier 1 1,001 - 8,000 1,001 - 10,000 $ 1.78 $ 1.90 6.74% Tier 2 8,001 - 16,000 10,001 - 25,000 $ 2.08 $ 2.35 12.98% Tier 3 16,000 plus 25,001 plus $ 2.31 $ 3.00 29.87% The attached tables will provide specific increases for each meter size based on usage. T , TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON CUSTOMERS WITH A 5/8 X 3/4" METER PROPOSED BASE RATE 6.67% INCREASE IN BASE RATE FROM $11.25 TO $12.00 (INC. 1000 GALS) PROPOSED COMMODITY 6.74% INCREASE IN TIER 1 FROM $1.78 TO $1.90 (1,000 - 10,000 GALS) 12.98% INCREASE IN TIER 2 FROM $2.08 TO $2.35 (10,001 -25,000 GALS) RS-4 revised 29.87% INCREASE IN TIER 3 FROM $2.31 TO $3.00 (OVER 25,000 GALS) CUSTOMERS GALLONS CURRENT PROPOSED AMOUNT PERCENT IN USAGE USED RATE RATE INCREASED INCREASED CATEGORY 4 : ...• t•-,-9q91 A\ vX \J4 : l} iv } } : 017 • 6 a 01111111, 2,000 1303 1,90 0.87 67 0 ` 678 fi.. 3,000 • 14` 1,prilitiolgage 0=99 67 828- k . 4,000 16.59 17170 1.11 6.7 1000 shaded area :s 5,000` 18.37 19.60. 1.23 6.7 1074 represents ................... 00000laoli4.::36.7 - 1076 58%of residential 6,000 20.15 21.505 7,000 21.93 23.40 1.47 6.7 9941customer base :2:5 30 j,,..5:91 ? t z � 898 t° .}.:: 8 . .: . 23..:71 �+..: _ 40:9........_. . ? {t � 6 T�it t t� .W i ;t �:. f 9,000 25.79 27.20 1.41 5.5 760 10,000 27.87 29.10 1.23 4.4 680 11,000 29.95 31.45 1.50 5.0 577 12,000 32.03 33.80 1.77 5.5 494 13,000 34.11 36.15 2.04 6.0 419 14,000 36.19 38.50 2.31 6.4 368 15,000 38.27 40.85 2.58 6.7 300 16,000 40.35 43.20 2.85 7.1 262 17,000 42.66 45.55 2.89 6.8 204 18,000 44.97 47.90 2.93 6.5 196 19,000 47.28 50.25 2.97 6.3 166 20,000 49.59 52.60 3.01 6.1 137 21,000 51.90 54.95 3.05 5.9 120 22,000 54.21 57.30 3.09 5.7 106 23,000 56.52 59.65 3.13 5.5 95 24,000 58.83 62.00 3.17 5.4 74 25,000 61.14 64.35 3.21 5.3 68 26,000 63.45 67.35 3.90 6.1 59 27,000 65.76 70.35 4.59 7.0 50 28,000 68.07 73.35 5.28 7.8 46 29,000 70.38 76.35 5.97 8.5 40 30,000 72.69 79.35 6.66 9.2 36 31,000 75.00 82.35 7.35 9.8 31 32,000 77.31_ 85.35 8.04 10.4 30 33,000 79.62 88.35 8.73 11.0 26 34,000 81.93 91.35 9.42_ 11.5 19 35,000 84.24 94.35 10.11 12.0 20 36,000 86.55 97.35 10.80 12.5 18:, 37,000 88.86 100.35 11.49_ 12.9 17 38,000 91.17 103.35 12.18 13.4 13 39,000 93.48 106.35 12.87 13.8 11 40,000 95.79 109.35 13.56 14.2 11 • ` TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1" METER BASE RATE = $30.01 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 16,000 GALLONS TIER 2 = $2.35 FOR 16,001 -27,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 27,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 28.13 30.01 1.88 6.7% 16,000 54.83 58.51 3.68 6.7% 27,000 77.71 84.36 6.65 8.6% 38,000 103.12 117.36 14.24 13.8% 50,000 130.84 153.36 22.52 17.2% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1 1/2" METER BASE RATE = $60.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 38,000 GALLONS TIER 2 = $2.35 FOR 38,001 - 64,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 64,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 56.25 60.00 3.75 6.7% 38,000 122.11 130.30 8.19 6.7% 64,000 176.19 191.40 15.21 8.6% 90,000 236.25 269.40 33.15 14.0% 125,000 317.10 374.40 57.30 18.1% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 2" METER BASE RATE = $96.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 80,000 GALLONS TIER 2 = $2.35 FOR 80,001 - 134,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 134,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 90.00 96.00 6.00 6.7% 80,000 230.62 246.10 15.48 6.7% 134,000 342.94 373.00 30.06 8.8% 275,000 668.65 796.00 127.35 19.0% 325,000 784.15 946.00 161.85 20.6% A 1r TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 3" METER BASE RATE = $192.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 186,000 GALLONS TIER 2 = $2.35 FOR 186,001 - 311,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 311,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 180.00 192.00 12.00 6.7% 100,000 356.22 380.10 23.88 6.7% 186,000 509.30 543.50 34.20 6.7% 311,000 769.30 837.25 67.95 8.8% 450,000 1090.39 1254.25 163.86 15.0% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 4" METER BASE RATE = $300.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 169,000 GALLONS TIER 2 = $2.35 FOR 169,001 -283,000 GALLONS TIER 3= $3.00. FOR USAGE OVER 283,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 281.25 300.00 18.75 6.7% 100,000 457.47 488.10 30.63 6.7% 169,000 580.29 619.20 38.91 6.7% 283,000 817.41 887.10 69.69 8.5% 350,000 972.18 1088.1 115.92 11.9% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 6" METER BASE RATE = $600.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.35 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 562.50 600.00 37.50 6.7% 1,000,000 2340.72 2498.10 157.38 6.7% 1,800,000 3764.72 4018.10 253.38 6.7% 3,000,000 6260.72 6838.10 577.38 9.2% 5,000,000 10879.34 12838.10 1958.76 18.0% • TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 8" METER BASE RATE = $1200.00 COMMODITY RATE: TIER 1 = $1.90 FOR 0 m 1,800,000 GALLONS TIER 2 = $2.35 FOR 1,800,001 -3,006,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 1125.00 1200.00 75.00 6.7% 1,000,000 2903.22 3098.10 194.88 6.7% 1,800,000 4327.22 4618.10 290.88 6.7% 3,000,000 6823.22 7438.10 614.88 9.0% 5,000,000 11441.84 13438.10 1996.26 17.4% GOLF COURSE CONSERVATION RATES TO BECOME EFFECTIVE WHEN USAGE EXCEEDS THE ARIZONA DEPT. OF WATER RESOURCES ANNUAL ALLOTMENT. Proposed Rate Design -Alternative Water Utility Commission Recommendation Produces 10% Revenue Increase Average Residential Customer Using 8,000 Gallons 9.1% Rate Increase = $2.15/month The following rates are for 5/8" x 3/4" meters: Current Proposed Current Proposed Percent Gallons Included Gallons Included Rate Rate Increase Base Rate 1,000 1,000 $11.25 $12.00 6.67% Tier 1 1,001 - 8,000 1,001 - 10,000 $ 1.78 $ 1.98 11.24% Tier 2 8,001 - 16,000 10,001. - 25,000 $ 2.08 $ 2.45 17.79% Tier 3 16,001 plus 25,001 plus $ 2.31 $ 3.25 40.69% The attached tables will provide specific increases for each meter size based on usage. TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON CUSTOMERS WITH A 5/8 X 3/4" METER PROPOSED BASE RATE 6.67% INCREASE IN BASE RATE FROM $11.25 TO $12.00 (INC. 1000 GALS) PROPOSED COMMODITY 11.24% INCREASE IN TIER 1 FROM $1.78 TO $1.98 (1,000 - 10,000 GALS) 17.79% INCREASE IN TIER 2 FROM $2.08 TO $2.45 (10,001 -25,000 GALS) RS-6 40.69% INCREASE IN TIER 3 FROM $2.31 TO $3.25 (OVER 25,000 GALS) CUSTOMERS GALLONS CURRENT PROPOSED AMOUNT PERCENT IN USAGE USED RATE RATE INCREASED INCREASED CATEGORY 0 11.25 12.00 0.75 6.7 385 1,000 11.25 12.00 0.75 6.7 501 2,000 13.03 13.98 0.95 7.3 678 3,000 14.81 15.96 1.15 7.8 828 4,000 16.59 17.94 1.35 8.1 1000 shaded area 5,000 18.37 19.92 1.55 8.4 1074 represents 6,000 20.15 21.90 1`.75 8.7 1076 58%of residential 7,000 21.93 23.88 1.95 8.9 994 customer base 8,000 23.71 25.86 2.15 9.1 898 9,000 25.79 27.84 2.05 7.9 760 10,000 27.87 29.82 1.95 7.0 680 11,000 29.95 32.27 2.32 7.7 577 12,000 32.03 34.72 2.69 8.4 494 13,000 34.11 37.17 3.06 9.0 419 14,000 36.19 39.62 3.43 9.5 368 15,000 38.27 42.07 3.80 9.9 300 16,000 40.35 44.52 4.17 10.3 262 17,000 42.66 46.97 4.31 10.1 204 18,000 44.97 49.42 4.45 9.9 196 19,000 47.28 51.87 4.59 9.7 166 20,000 49.59 54.32 4.73 9.5 137 21,000 51.90 56.77 4.87 9.4 120 22,000 54.21 59.22 5.01 9.2 106 23,000 56.52 61.67 5.15 9.1 95 24,000 58.83 64.12 5.29 9.0 74 25,000 61.14 66.57 5.43 8.9 68 26,000 63.45 69.82 6.37 10.0 59 27,000 65.76 73.07 7.31 11.1 50 28,000 68.07 76.32 8.25 12.1 46 29,000 70.38 79.57 9.19 13.1 40 30,000 72.69 82.82 10.13 13.9 36 31,000 75.00 86.07 11.07 14.8 31 32,000 77.31 89.32 12.01 15.5 30 33,000 79.62 92.57 12.95 16.3 26 34,000 81.93 95.82 13.89 17.0 19 35,000 84.24 99.07 14.83 17.6 20 36,000 86.55 102.32 15.77 18.2 18 37,000 88.86 105.57 16.71 18.8 17 38,000 91.17 108.82 17.65 19.4 13 39,000 93.48 112.07 18.59 19.9 11 40,000 95.79 115.32 19.53 20.4 11 TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1" METER BASE RATE = $30.01 COMMODITY RATE: TIER 1 = $1.98 FOR 0 - 16,000 GALLONS TIER 2 = $2.45 FOR 16,001 -27,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 27,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 28.13 30.01 1.88 6.7% 16,000 54.83 59.71 4.88 8.9% 27,000 77.71 86.66 8.95 11.5% 38,000 103.12 122.41 19.29 18.7% 50,000 130.84 161.41 30.57 23.4% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1 1/2" METER BASE RATE = $60.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0 -38,000 GALLONS TIER 2 = $2.45 FOR 38,001 -64,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 64,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 56.25 60.00 3.75 6.7% 38,000 122.11 133.26 11.15 9.1% 64,000 176.19 196.96 20.77 11.8% 90,000 236.25 281.46 45.21 19.1% 125,000 317.10 395.21 78.11 24.6% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 2" METER BASE RATE = $96.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0 -80,000 GALLONS TIER 2 = $2.45 FOR 80,001 - 134,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 134,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 90.00 96.00 6.00 6.7% 80,000 230.62 252.42 21.80 9.5% 134,000 342.94 384.72 41.78 12.2% 275,000 668.65 842.79 174.14 26.0% 325,000 784.15 1005.29 221.14 28.2% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 3" METER BASE RATE = $192.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0- 186,000 GALLONS TIER 2 = $2.45 FOR 186,001 -311,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 311,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 180.00 192.00 12.00 6.7% 100,000 356.22 388.02 31.80 8.9% 186,000 509.30 588.30 79.00 15.5% 311,000 769.30 894.55 125.25 16.3% 450,000 1090.39 1346.30 255.91 23.5% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 4" METER BASE RATE = $300.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0 - 169,000 GALLONS TIER 2 = $2.45 FOR 169,001 -283,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 283,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 281.25 300.00 18.75 6.7% 100,000 457.47 496.02 38.55 8.4% 169,000 580.29 632.64 52.35 9.0% 283,000 817.41 911.94 94.53 11.6% 350,000 972.18 1129.69 157.51 16.2% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 6" METER BASE RATE = $600.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.45 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 562.50 600.00 37.50 6.7% 1,000,000 2340.72 2578.02 237.30 10.1% 1,800,000 3764.72 4162.02 397.30 10.6% 3,000,000 6260.72 7102.02 841.30 13.4% 5,000,000 10879.34 13597.22 2717.88 25.0% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 8" METER BASE RATE = $1200.00 COMMODITY RATE: TIER 1 = $1.98 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.45 FOR 1,800,001 -3,006,000 GALLONS TIER 3 = $3.25 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 1125.00 1200.00 75.00 6.7% 1,000,000 2903.22 3178.02 274.80 9.5% 1,800,000 4327.22 4762.02 434.80 10.0% 3,000,000 6823.22 7702.02 878.80 12.9% 5,000,000 11441.84 14197.22 2755.38 24.1% GOLF COURSE CONSERVATION RATES TO BECOME EFFECTIVE WHEN USAGE EXCEEDS THE ARIZONA DEPT. OF WATER RESOURCES ANNUAL ALLOTMENT. 4 Optional Rate Design Prepared 5/21/01 Produces 7% Revenue Increase Average Residential Customer Using 8,000 Gallons 5.0% Rate Increase= $1.18/month The following rates are for 5/8" x 3/4" meters: Current proposed Current Proposed Percent Gallons Included Gallons Included Rate Rate Increase Base Rate 1,000 1,000 $11.25 $11.80 4.89% Tier 1 1,001 - 8,000 1,001 - 8,000 $ 1.78 $ 1.87 5.06% Tier 2 8,001 - 16,000 8,001 - 16,000 $ 2.08 $ 2.35 12.98% Tier 3 16,001 plus 16,001 plus $ 2.31 $ 3.00 29.87% The attached tables will provide specific increases for each meter size based on usage. ... ,......„ .,..,.,,,_. , . . .... , ...,. ....,...... ....., ..., ... ..„............. .. ,.........,-....,......-....,,,,..1,,,,........,,..,,,_................,.s...,-....-.:,,-s--.• , -•, _.... . .,.•• • •,. TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON CUSTOMERS WITH A 5/8 X 3/4" METER PROPOSED BASE RATE 4.9% INCREASE IN BASE RATE FROM $11.25 TO $11.80 (INC. 1000 GALS) PROPOSED COMMODITY 5.1% INCREASE IN TIER 1 FROM $1.78 TO $1.87 (1,000 - 8,000 GALS) . 12.98% INCREASE IN TIER 2 FROM $2.08 TO $2.35 (8,001 - 16,000 GALS) RS-4A 29.87% INCREASE IN TIER 3 FROM $2.31 TO $3.00 (OVER 16,000 GALS) CUSTOMERS GALLONS CURRENT PROPOSED AMOUNT PERCENT IN USAGE USED RATE RATE INCREASED INCREASED CATEGORY pleoletnispingliging5511111,11111r-4.g IS ...1.-: • lofmffifttl000iogpupipixjip 5.ji lionalliti11i80romin0,.:551" 49 :.7,,,,,,r7"'• 501 2,0001,111111111.a.Q .11.iiiiii”114M111111111111111111p.6/11111810rIo4g,.",':'.: ' 674, I . 3,000 1481 t554 insignow akiiii:i;iz,,i„:„:. ,„,-49 828 '-- 0- shaded area i:14,;.010- 4000 '''''''""'""':'':'"'-:71tEV59IllffIIIIIItft7:4IIIIIIrIIIIIII,BIIPMiii:;;::Z: '4.9 100_..:,.,„: 5,000 ' 18:.37 . 1928. 1:'-'''''''''7:-:-,:-.'::',:-----'0.91"tokitaser- 5.0 1074 represents 6,00020.15:... :.:'' ' 21.15 1'.0q14111taill, 5.0 . 1076. 58%of residential 7000 -7---. 21 93 . . 23.02,,:,:: 1.0quistli 50 9914 customer base a 000 -'-:i,-: ....: . 23.7 1:!:111:110111101112440.914111101,110040 1717171!.,' 5,0 :i::4::ili:iiiii,iiliillil!!:iil 898 9,000 25.79 27.24 1.45 5.6 760 10,000 27.87 29.59 1.72 6.2 680 11,000 29.95 31.94 1.99 6.6 577 12,000 32.03 34.29 2.26 7.1 494 13,000 34.11 36.64 2.53 7.4 419 14,000 36.19 38.99 2.80 7.7 368, 15,000 38.27 41.34 3.07 8.0 300 16,000 40.35 43.69 3.34 8.3 262, 17,000 42.66 46.69 4.03 9.4 204 18,000 44.97 49.69 4.72 10.5 196 19,000 47.28 52.69 5.41 11.4 166 20,000 49.59 55.69 6.10 12.3 137 21,000 51.90 58.69 6.79 13.1 120 22,000 54.21 61.69 7.48 13.8 106, 23,000 56.52 64.69 8.17 14.5 95 24,000 58.83 67.69 8.86 15.1 74 25,000 61.14 70.69 9.55 15.6 68 26,000 63.45 73.69 10.24 16.1 59 27,000 65.76 76.69 10.93 16.6 50 28,000 68.07 79.69 11.62. 17.1 46 29,000 70.38 82.69 12.31 17.5 40 30,000 72.69 85.69 13.00. 17.9 36, 31,000 75.00 88.69 13.69 18.3. 31 32,000 77.31 91.69 14.38 18.6 30, 33,000 79.62 94.69 15.07 18.9 26, 34,000 81.93 97.69 15.76 19.2. 19 35,000 84.24 100.69 16.45 19.5 20 36,000 86.55 103.69 17.14 19.8 18 37,000 88.86 106.69 17.83 20.1 17, 38,000 91.17 109.69 18.52 20.3 13 39,000 93.48 112.69 19.21 20.5 11 40,000 95.79 115.69 19.901 20.8 11, TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1" METER BASE RATE = $29.50 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 16,000 GALLONS TIER 2 = $2.35 FOR 16,001 -27,000 GALLONS TIER 3 =$3.00 FOR USAGE OVER 27,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 28.13 29.50 1.37 4.9% 16,000 54.83 57.55 2.72 5.0% 27,000 77.71 83.40 5.69 7.3% 38,000 103.12 116.40 13.28 12.9% 50,000 130.84 152.40 21.56 16.5% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1 1/2" METER BASE RATE = $59.00 COMMODITY RATE: TIER 1 = $1.87 FOR 0 -38,000 GALLONS TIER 2 = $2.35 FOR 38,001 -64,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 64,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 56.25 59.00 2.75 4.9% 38,000 122.11 128.19 6.08 5.0% 64,000 176.19 189.29 13.10 7.4% 90,000 236.25 267.29 31.04 13.1% 125,000 317.10 372.29 55.19 17.4% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 2" METER BASE RATE = $94.40 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 80,000 GALLONS TIER 2 = $2.35 FOR 80,001 - 134,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 134,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 90.00 94.40 4.40 4.9% 80,000 230.62 242.13 11.51 5.0% 134,000 342.94 369.03 26.09 7.6% 275,000 668.65 792.03 123.38 18.5% 325,000 784.15 942.03 157.88 20.1%, a t TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 3" METER BASE RATE = $188.80 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 186,000 GALLONS TIER 2 = $2.35 FOR 186,001 - 311,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 311,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 180.00 188.80 8.80 4.9% 100,000 356.22 373.93 17.71 5.0% 186,000 509.30 534.75 25.45 5.0% 311,000 769.30 828.50 59.20 7.7% 450,000 1090.39 1245.50 155.11 14.2% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 4" METER BASE RATE = $295.00 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 169,000 GALLONS TIER 2 = $2.35 FOR 169,001 -283,000 GALLONS TIER 3 = $3.00. FOR USAGE OVER 283,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 281.25 295.00 13.75 4.9% 100,000 457.47 480.13 22.66 5.0% 169,000 580.29 609.16 28.87 5.0% 283,000 817.41 877.06 59.65 7.3% 350,000 972.18 1078.06 105.88 10.9% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 6" METER BASE RATE =$590.00 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.35 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 562.50 590.00 27.50 4.9% 1,000,000 2340.72 2458.13 117.41 5.0% 1,800,000 3764.72 3954.13 189.41 5.0% 3,000,000 6260.72 6774.13 513.41 8.2% 5,000,000 10879.34 12770.23 1890.89 17.4% • TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 8" METER BASE RATE = $1180.00 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.35 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 = $3.00 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 1125.00 1180.00 55.00 4.9% 1,000,000 2903.22 3048.13 144.91 5.0% 1,800,000 4327.22 4544.13 216.91 5.0% 3,000,000 6823.22 7176.13 352.91 5.2% 5,000,000 11441.84 13172.23 1730.39 15.1% GOLF COURSE CONSERVATION RATES TO BECOME EFFECTIVE WHEN USAGE EXCEEDS THE ARIZONA DEPT. OF WATER RESOURCES ANNUAL ALLOTMENT. Optional Rate Design Prepared 5/21/01 Produces 5% Revenue Increase Average Residential Customer Using 8,000 Gallons 5.0% Rate Increase = $1.19/month The following rates are for 5/8" x 3/4" meters: Current Proposed Current Proposed Percent Gallons Included Gallons Included Rate Rate Increase Base Rate 1,000 1,000 $11.25 $11.81 4.98% Tier 1 1,001 - 8,000 1,001 - 10,000 $ 1.78 $ 1.87 5.06% Tier 2 8,001 - 16,000 10,001 - 25,000 $ 2.08 $ 2.29 10.10% ler • 11 pus ,II pus . . '0 The attached tables will provide specific increases for each meter size based on usage. TABLE FOR MONTHLY CHARGES & PERCENT INCREASE COMPARISON CUSTOMERS WITH A 5/8 X 3/4" METER PROPOSED BASE RATE 4.98% INCREASE IN BASE RATE FROM $11.25 TO $11.81 (INC. 1000 GALS PROPOSED COMMODITY 5.06% INCREASE IN TIER 1 FROM $1.78 TO $1.87 (1,000 - 10,000 GALS) 10.10% INCREASE IN TIER 2 FROM $2.08 TO $2.29 (10,001 - 25,000 GALS) 5% Option 17.32% INCREASE IN TIER 3 FROM $2.31 TO $2.71 (OVER 25,000 GALS) CUSTOMERS GALLONS CURRENT PROPOSED AMOUNT PERCENT IN USAGE USED RATE RATE INCREASED INCREASED CATEGORY 0 11.25 11.81 0.56 5.0 385 1,000 11.25 11.81 0.56 5.0 501 2,000 13.03 13.68 0.65 5.0 678. 3,000 14.81 15.55 0.74 5.0 828 4,000 16.59 17.42 0.83' 5.0 1000 shaded area 5,000 18.37 19.29 0.92 5.0 1074 represents 6,000 20.15 21.16 1.01 5.0 1076 58%of residential 7,000 21.9 23.03 1.10 5.0 994 customer base 8,000 23.71 24.90 1.19 5.0 898 9,000 25.79 26.77 0.98 3.8 760 10,000 27.87 28.64 0.77 2.8 680 11,000 29.95 30.93 0.98 3.3 577 12,000 32.03 33.22 1.19 3.7 494 13,000 34.11 35.51 1.40 4.1 419 14,000 36.19 37.80 1.61 4.4 368 15,000 38.27 40.09 1.82 4.8 300 16,000 40.35 42.38 2.03 5.0 262 17,000 42.66 44.67 2.01 4.7 204 18,000 44.97 46.96 1.99 4.4 196 19,000 47.28 49.25 1.97 4.2 166 20,000 49.59 51.54 1.95 3.9 137 21,000 51.90 53.83 1.93 3.7 120 22,000 54.21 56.12 1.91 3.5 106 23,000 56.52 58.41 1.89 3.3 95 24,000 58.83 60.70 1.87 3.2 74 25,000 61.14 62.99 1.85 3.0 68 26,000 63.45 65.70 2.25 3.5 59 27,000 65.76 68.41 2.65 4.0 50 28,000 68.07 71.12 3.05 4.5 46 29,000 70.38 73.83 3.45 4.9 40 30,000 72.69 76.54 3.85 5.3 36 31,000 75.00 79.25 4.25 5.7 31 32,000 77.31 81.96 4.65 6.0 30 33,000 79.62 84.67 5.05 6.3 26 34,000 81.93 87.38 5.45 6.7 19 35,000 84.24 90.09 5.85 6.9 20 36,000 86.55 92.80 6.25 7.2 18 37,000 88.86 95.51 6.65 7.5 17 38,000 91.17 98.22 7.05 7.7 13 39,000 93.48 100.93 7.45 8.0 11 40,000 95.79 103.64 7.85 8.2 11 TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1" METER BASE RATE = $29.54 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 16,000 GALLONS TIER 2 = $2.29 FOR 16,001 -27,000 GALLONS TIER 3 = $2.71 FOR USAGE OVER 27,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 28.13 29.54 1.41 5.0% 16,000 54.83 57.59 2.76 5.0% 27,000 77.71 82.78 5.07 6.5% 38,000 103.12 112.59 9.47 9.2% 50,000 130.84 145.11 14.27 10.9% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 1 1/2" METER BASE RATE = $59.06 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 38,000 GALLONS TIER 2 = $2.29 FOR 38,001 - 64,000 GALLONS TIER 3 = $2.71 FOR USAGE OVER 64,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 56.25 59.06 2.81 5.0% 38,000 122.11 128.25 6.14 5.0% 64,000 176.19 187.79 11.60 6.6% 90,000 236.25 258.25 22.00 9.3% 125,000 317.10 353.10 36.00 11.4% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 2" METER BASE RATE = $94.50 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 80,000 GALLONS TIER 2 = $2.29 FOR 80,001 - 134,000 GALLONS TIER 3 = $2.71 FOR USAGE OVER 134,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 90.00 94.50 4.50 5.0% 80,000 230.62 242.23 11.61 5.0% 134,000 342.94 365.89 22.95 6.7% 275,000 668.65 748.00 79.35 11.9% 325,000 784.15 883.50 99.35 12.7% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 3" METER BASE RATE = $189.00 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 186,000 GALLONS TIER 2 = $2.29 FOR 186,001 -311,000 GALLONS TIER 3 =$2.71 FOR USAGE OVER 311,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 180.00 189.00 9.00 5.0% 100,000 356.22 374.13 17.91 5.0% 186,000 509.30 534.95 25.65 5.0% 311,000 769.30 821.20 51.90 6.7% 450,000 1090.39 1197.89 107.50 9.9% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 4" METER BASE RATE = $295.31 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 169,000 GALLONS TIER 2 = $2.29 FOR 169,001 -283,000 GALLONS TIER 3 = $2.71 FOR USAGE OVER 283,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 281.25 295.31 14.06 5.0% 100,000 457.47 480.44 22.97 5.0% 169,000 580.29 592.64 12.35 2.1% 283,000 817.41 853.70 36.29 4.4% 350,000 972.18 1035.27 63.09 6.5% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 6" METER BASE RATE = $590.63 COMMODITY RATE: TIER 1 = $1.87 FOR 0- 1,800,000 GALLONS TIER 2 = $2.29 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 = $2.71 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 562.50 590.63 28.13 5.0% 1,000,000 2340.72 2458.76 118.04 5.0% 1,800,000 3764.72 3954.76 190.04 5.0% 3,000,000 6260.72 6702.76 442.04 7.1% 5,000,000 10879.34 12120.24 1240.90 11.4% TABLE FOR MONTHLY CHARGES AND PERCENT INCREASE COMPARISON FOR CUSTOMERS WITH A 8" METER BASE RATE = $1181.25 COMMODITY RATE: TIER 1 = $1.87 FOR 0 - 1,800,000 GALLONS TIER 2 = $2.29 FOR 1,800,001 - 3,006,000 GALLONS TIER 3 =$2.71 FOR USAGE OVER 3,006,000 GALLONS GALLONS BILL AT THE BILL AT THE AMOUNT OF PERCENT OF USED IN CURRENT PROPOSED INCREASE INCREASE 1 MONTH RATE RATE PER MONTH 0 1125.00 1181.25 56.25 5.0% 1,000,000 2903.22 3049.38 146.16 5.0% 1,800,000 4327.22 4545.38 218.16 5.0% 3,000,000 6823.22 7293.38 470.16 6.9% 5,000,000 11441.84 12710.86 1269.02 11.1% GOLF COURSE CONSERVATION RATES TO BECOME EFFECTIVE WHEN USAGE EXCEEDS THE ARIZONA DEPT. OF WATER RESOURCES ANNUAL ALLOTMENT. Oro Valley Water Utility Page 1 of 2 Budget Summary Prepared: May 21, 2001 Percentage Description Amount of Budget Capital Outlay Water Rights Acquisition 5,000,000 Projects Financed by Bonds 3,446,125 Relocate Mains - Road Improve. 888,375 Land Acquisition 500,000 Telemetry 160,000 Other 1,391,400 11,385,900 $ 11,385,900 58.16% Debt Service Principal 1,207,000 Interest 1,697,883 2,904,883 2,904,883 14.84% Personnel 1,439,160 7.35% Depreciation/Amortization 1,377,200 7.04% Power for Pumping 914,000 4.67% CAP Costs M&I Capital 290,164 Delivery 112,500 402,664 402,664 2.06% Professional Services Billing & Rates 55,700 Finance Dept. 34,100 Legal Dept. 25,000 Misc. Consulting 15,000 Engineering System Map 20,000 On-Call 50,200 200,000 200,000 1.02% Equipment Repair& Maint. 160,200 0.82% Wells,Reservoirs,Boosters, Mains, Hydrants, Meters Issuance Costs 125,000 0.01 Regulatory Expenses ADEQ 3,000 ADWR 28,500 CAGRD 90,000 121,500 121,500 0.62% Water Quality Testing 78,500 0.40% Insurance 78,000 0.40% Oro Valley Water Utility Page 2 of 2 Budget Summary Prepared: May 21, 2001 Description Amount Postage 67,800 0.35% Office Rent 38,625 0.20% Conservation Program 35,000 0.18% Gas, Oil & Tires 28,600 0.15% Vehicle, Equipment& Grounds Maint. 24,650 0.13% Printing & Binding 20,720 0.11% Chemicals (chlorine) 13,000 0.07% Water Purchased for Resale 11,000 0.06% Telemetry Maintenance 10,900 0.06% Bluestake (service & supplies) 8,200 0.04% Other Line Items Non-Capitalized Equipment 27,960 Telecommunications 20,325 Office Supplies 15,000 Memberships & Subscriptions 12,300 Travel & Training 10,500 Contract Personnel 10,000 Field Supplies 7,500 Uniforms 7,400 Rentals 5,925 Safety 5,200 Interest on Security Deposits 3,500 Bad Debt Allowance 3,500 Water Utility Commission 1,650 Advertising 100 130,860 130,860 0.67% Total Budget $ 19,576,362 100.00% a: a a mC � CD o o 0 , D 13 D < .. O m � N C `< Z D V) N Z rn V ,p O CA Vt -a w "1 o p CC 0 CO N o D o r" r= CO � C) N N co n rn "< z 46 40 ND N O 70 o _ w N O N 0 N CO 1%) O CD (31 O (31 W cp o O --1 '7. W .... w y w o N C) O o C co .A 0 D N cri m w N m o 0 o N IA 'in(31 C) �OJ1 Z O C Z rn O 4f) 414 Z o n rni4 y ij V yc.ri 7J o oo N m .._, cA as O D mm -co CSO O 0) C O O m m Z co O -< Z n o , N 0 N N CJt ,r O -n �_ w Z Cn D cn Z p 411 40 n z N Z " o G) V V I. IV o• O o . co O O 0 y 00 N O f -64 N ... .... O -� - O -4 co 0 0 N y 0 N W C'`� (A O V VT O O O C) 41. 03 40 V) N .-. 0 Cr) o -.1 N . 0 N C )CTI O O .4 C00 O CJ1 C) N T1. N N O N C) O CO O O_ 41. O ', O W X 0 0 Z > 0 13 CD Q CD cin CD CD CL Q N rn a) 5 0 O Cn —0 > CD o c )o = , D < D 0 CD F. 6T1 ''S' r .. rn O ..<rn Cl) 0) -n `< Z D N -I v. N Z rn V 73 V al C ,p a) Co N o D —I° N O 'A` N 0 r — a) N N 0 0 -.<rn , z 441 N D N O o p 41. -4 a) C N 0 O ✓ a) W X 01 - 0 v 40 NC0 O y Co — -.1C) o .4p, W C 0 N CA O a) • Z O 01 OP D 1.) a) x r rn N Z rn cn 64 44 Z o C Z -, ..a -Z/1O -.I ',/1 IV a) O rn D .� N O O N _ O — Oco ) 01 n O 41. x Z D O—I 44 64 o rn rn NO N co O In) O m rn -criO co a) rn O c.n v v rn co 64 4N 000 — C, O Z LT) :p °) O y 01 c c D E oZ — o cmc C c/9 D — X O 64 40 -< z IV N y cr •1 0 0 4 b 41. c 0 co O CC O O 00 a) _a {t tol N .-. O .p -. 0 03 o o N 00 c) -� O CO P. O C,) co n) O) (1) 60 N 0 41. -a .-i.V 0 /O COO O - p N CO '1=' 01 O V r i N 0 O 0) 00 {A EA N r. O 41. V V 0 a) w O O V -� O N' ' O N CT Di CD a c' W u v) V < cn a° -* a N C) 73 0 73 CI = 5 -. rn rn 0 m () o 3 Z CD E) B 5 * 5 =° — m _xi< r- 7= 00 •• rn C u) -n .n -< O °y m -n '4 x Z 4. 4. N c Z rn cy o0 70 w co r� -< D CI oo o f' _r .p N N (inLJ 0m -< o Z AO 40 N D O 73 .a O - o O 01 O N 0 Q) o NO COsip 01 N N ® m co (0 o o N o m CA a) 4=. rn v N 0 m Na o Np m 01 0 I Z e o • 0 0 o D, 0 0 o X cotv N 01 0 73 .�, m N 0 N - 0 c 0 voi w too c k a) O O 0 "0000 rn CA 03 Z v rn v N Co o -< y 0 N o C) N 41. 03 O O 0 -, o 0 N 00 E C) 0) 40 4,3 _a O Z � y o N N Oa N .A N N O Co O 0 cm � 00 O W V) 40) N .-. 0 -, O "' "K) 'J 00 N N 0 N O CA GJ O O O O CD N .... O O V W N co o N 'v N O 01 t O a) -, tf, 401 N \ 01 N C o N a )Co a) O V (00 0) C.y LI c C) C/) Q C/) 0 -• rn m O `c° 0 a) ° 0ci) Z D > < MINI N N .. O rn CD ... W m m CS G 73E o � Z m N /3 D o r' 01 O Co r:3 '< --I O 00 (A w N - V) r o rn 4/3 40 N XID Co y a o 00 0 o c o ~ o °) o co 4 w 40) AR D r.) r 0 ', .p .. co y O i Oo N O 00 0 w e O (,,, 0 O N 4 Coo o Z CA 0 D —Im o cn ^, N Co -,1 4C) CA 4b y o ti, m N 0 Z oo 0 CA D X O 4' X N m 0 o C) o N W C N O O N O E (.0c O) m v 40 m N v 0 o CO 01 CD CY' o 0 Co 4o 0 03 E E 4/7 40N 0 N o 0 ~ Z w w o) o r~� N 4 O v1 co co N o) N 4). O y 0 L.) Co Q) C N co C) O o 0 Co O Q) in 40 N 0 .a C) ..a O co [OV N p N Q) O_ 1 01 O -,1 CO 41, 40 N O - COC '� p N ~ N 0 lV G (n ..s N O -., O Q)