Loading...
09-06-1988 (City Council) Agenda Packet AGENDA CALLED CITY COUNCIL MEETING CITY OF WYLIE, TEXAS TUESDAY, SEPTEMBER 6, 1988 6:30 P. M. CONFERENCE ROOM CITY MANAGER'S OFFICE MUNICIPAL COMPLEX 2000 HIGHWAY 78 NORTH CALL TO ORDER) INVOCATION IV` , ORDER OF PAGE BUSINESS REFERENCE BUSINESS 1 Insert Discussion of 1988/89 General Fund Budget 2 Insert Discussion of 1988/89 Water and Sewer Fund Budget 3 General Discussion 4 Adjourn NOTICE OF A CALLED MEETING Notice is hereby given that the governing body of the City of Wylie will meet for a called session on the 671 day of 198F. , in the City Manager ' s Conference Room in the Municipal Complex of Wylie at 2000 Highway 78 North, Wylie, Texas for the purpose of considering the attached Agenda . 7 _ �, � Carolyn t.y Secretary Posted this the =//id day of _.,k;,/ /:_L-z1Z 198 ? , at ,_. , l2/ /. M. GENERAL FUND ****************************************************************************** PROPOSED TOTAL BUDGET ****************************************************************************** . GENERAL UTILITY SANITATION IMPACT LIFT TOTAL STATION ****************************************************************************** 1987/1988 2 ,390 ,000 1 ,450 ,000 275 ,000 175 ,000 150 ,000 4 ,440 ,000 PROPOSED 1988/1989 2 ,465 ,000 1 ,825,000 275 ,000 45,000 40 ,000 4 ,650 ,000 E 1 i i E 1 3 } 1988-89 OPERATING BUDGET Expenditures by Fund General Utility 14g Lift Station Impact Sanitation FUND 1988- 89 % OF BUDGET TOTAL General $ 2,465,000 53 % Utility 1,825,000 39% Sanitation 275,000 6% Impact 45,000 I % Lift Station 40,000 1 % TOTAL $ 4,650,000 100% TAX STRUCTURE FISCAL YEAR 1988- 1989 ***************************************************************** ESTIMATED TOTAL ASSESSED $293,142 ,666 VALUATION 1988 TAX RATE . 5125 TOTAL EST. TAX LEVY (100%) $1 ,502 ,356. ANTICIPATED 90% CURRENT TAX COLLECTIONS $1 ,352 ,000 . DELINQUENT & P & I COLLECTIONS $ 82 ,500 . INTEREST & SINKING FUND $ 408,500 . REQUIREMENTS AMOUNT AVAILABLE FOR GENERAL FUND OPERATIONS AND LINE OF CREDIT REPAYMENT $1,026 ,000 . 1988/89 GENERAL FUND BUDGET REVENUES GENERAL FUND ACTUAL ESTIMATED PROJECTED 1986/87 1987/88 1988/89 .5125 ***************************************************************** PROPERTY TAXES 1,004 ,102 1,340 ,000 1 ,434 ,500 SALES TAXES 298 ,011 270,000 278 ,000 PERMITS, FINES & FEES 452,687 325,000 319 ,500 FRANCHISE TAX 253 , 682 293,000 313,000 INTERFUND TRANSFERS 12 ,500 75 ,000 120 ,000 TOTAL 2,020 ,982 2 , 303 ,000 2 ,465 ,000 PROPOSED 1988/89 GENERAL FUND BUDGET EXPENDITURES BY DEPARTMENT m DEPARTMENT ACTUAL ESTIMATED PROJECTED 1986/87 1987/88 1988/89 ***************************************************************** CITY COUNCIL 84,933 135 ,000 tZT,0-0 0/01 _cd`' CITY MANAGER 116 ,306 75 ,000 134 ,500 _ CITY SECRETARY 120 ,314 63,500 56,500 CODE ENFORCEMENT 95, 107 88 ,200 94 ,000 PLANNING/ENGINEERING 130 ,168 69 ,000 68 ,500 FINANCIAL SERVICES 177 ,676 198 ,000 214 ,000 PERSONNEL -0- 36 ,200 -0- , MUNICIPAL COURT 39 ,862 52 ,000 47 ,750 DEBT SERVICE 73,261 392 ,950 408,500 BUILDING SERVICES -0- -0- 251 ,250 POLICE ADMINISTRATION 81 ,679 88 ,000 72 ,000 POLICE PATROL 414 ,500 372,000 363 ,000 POLICE INVESTIGATION 75,699 45 ,000 38,500 POLICE COMMUNICATIONS 104 ,271 126 ,000 105 ,500 FIRE DEPARTMENT 67, 753 54 ,000 26 ,400 EMERGENCY MEDICAL SVC. 116,517 32,500 40 ,000 FIRE MARSHALL -0- 5,650 -0- LIBRARY 69 ,561 47 ,000 26 ,600 PARKS 153,470 32 ,000 46,000 STREETS 336 ,396 322,000 2?90.2 ,s'd01- GARAGE -0- 23,000 28 ,000 ANIMAL CONTROL 39 ,843 35 ,000 38 ,000 TOTAL 2,297 ,316 2 ,292 ,000 2 ,465,000 *********************************************************** GENERAL FUND DEBT SERVICE *********************************************************** BOND 1988 DEBT PAYMENTS *********************************************************** CERT. OF OBLIGATION 1980 20 ,065 GEN. OBLIGATION BONDS 1986 185,260 G 0 EQUP NOTES ' 86 (PUB.S) 30 ,075 G 0 EQUIP NOTES ' 88 (BM) 96 ,680 CERT OF OBLIGATIONS ' 88 (S) 139 ,600 PAYING AGENT FEES 2,750 TOTAL 474 ,430 1988-89 GENERAL FUND BUDGET Expenditures by Service Area Public Works Public Safety 4---Support Services \ ,1L)11h' — \ --------j 7-----Y Community Services Long Term Debt y General Government — SERVICE AREA 1988-89 % OF BUDGET TOTAL Public Safety 693, 150 29% Public Works 508 1500 21 % — Support Services 465,750 19% Community Services 72,600 3% — General Government 257,500 11% Long Term Debt 408,500 17% TOTAL $ 2,406,000 100 % 1988-89 GENERAL FUND BUDGET Revenues Property Taxes Sales Taxes Interfund Transfers Franchise Tax Permits, Fines a Fees CATEGORY 1988 - 89 % OF BUDGET TOTAL Property Taxes $ 1,434, 500 58 % Interfund Transfers 120,000 5% Franchise Tax 313 ,000 13% Permits, Fines a Fees 319, 500 13% Sales Taxes 278,000 11 % TOTAL $ 2,465,000 100% iegh PROGRAM BUDGET SUMMARY DEPT. NO. 101 MOM Program MAYOR AND CITY COUNCIL Program Description The Mayor and City Council are elected by the citizens of Wylie to establish policy for the City under the Council/Manager form of government under which the City operates. The Mayor and City Council oversee the operations of City government by providing the City Manager with administration guidelines and performance objectives. The City Council is responsible for review and adopting the annual budget, approving '® major purchases and contracts, appointing members of advisory boards, reviewing and approving zoning changes and representing the City's interest before local, state and federal bodies. Program Goal To make thoughtful and appropriate policy decisions regarding the overall development -- of the City, effective and efficient run of municipal services and other issues to enhance the quality of life in Wylie and represent the best interest of all citizens. ORM Program Objectives for 1988-89 r Significant Budget Changes Nsk Additional costs for legal services included in new budget Funds added to provide monthly newsletter to citizens and contribute to Collin County Crisis Center IMMO . . Program Expenditures Actual Estimated Prrolooted 4.14) ., 1986-17 1987 -88 1988-88 Personnel Services $ 10,800. $ 12,000. Contractual Services 50,850. 42,325. Supplies 6, 150. 11,675. Capitol OutloY/ 5�k.S00• 1' t7 67,200. 6i,000. Program Total $135,000. $-} 000-r ... / #' :rto 4 ‘,. ) Revenues Actual Estimated Projected _ 1986-87 1987- 88 1988-89 Al f Number of Employees 1 - Personnel Summary 1986-87 1987-88 1988-89 NO FULL TIME PERSONNEL J ✓ 1 Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 PROGRAM BUDGET SUMMARY DEPT. NO. 102 A .. dam CITY MANAGER Program Description The City Manager, appointed by the City Council, is the Chief Executive officarof the City of Wylie. He is primarily responsible for employing professional staff members, directs and supervises the administration of all departments, sees that all state and federal laws and city ordinances are enforced, prepares the City Council meeting agendas, prepares and submits an annual budget, financial report and capital improve- ments plan and carrys out the day to day activities of the City within the policy guidelines established by the City Council. Program Goal To improve the delivery of services offered to the Wylie citizens in an equitable and efficient manner. Program Objectives for 1988-89 To implement the programs outlined in the City Manager's Action Plan To monitor the effectiveness of all city operations To provide Mayor and City Council with administrative support necessary to implement policy To improve the City Manager's Office ability to respond to citizen inquiries "'Significant Budget Changes 1 Adminstrative Assistant transfered from Police Administration to City Managers Office to complete codification of code book of ordinances, annexation procedings receptionist and clerical relief for Municipal Court, City Secretary and City Manager. Merit pool and travel & training for all departments included in City Managers Budget 4, . . f 1 .. Program Expenditures Actual Estimated Projected 1996-07 1987 - 88 MSS-69 Personnel Services $ 62,700. $ 85,650. Contractual Services 17,875. 16,725. Supplies 2,625. 3,625. Capitol Outlay 800. 28,500. Program Total $ 84,000. $134,500. f I 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 f Number of Employees N - Personnel Summary 1986-87 1987-88 1988-89 City Manager 1 1 1 Administrative Secretary 1 0 0 Administrative Assistant 0 0 1 J Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 PROGRAM BUDGET SUMMARY DEPT. NO. 103 Program CITY SECRETARY — Progrom Description The City Secretary keeps all records of the City, takes and types all minutes of all City Council meetings, must see that all City Council, Planning and Zonnig, Zoning Board of Adjustment, Library Board, and Park Board — meetings have a secretary, if no one is available, the City Secretary must cover the meetings, file records at County, do agendas and packets for all City Council and all other board meetings, public hearing notices, work up all annexations and — do all elections. Since there is no receptionist, the City Secretary is also going for the mail in the mornings and sorting it out most of the time. The City Secretary is also doing most of the typing for all departments. Program Goal Codification of and the completion of Code Book of Ordinances, set up new file system, start re-certification of my City Clerk Certification (this must be done within five years and one year and a half has passed) . Program Objectives for 1988-89 To have better organization of packets on packet day To complete and codify Code book of Ordinances .., Annex all areas surrounded by present City Limits Seek boundary agreement with all surrounding cities Re-certification for City Clerk (this takes 5 years ) — Ikkok 1111 .M Significant Budget Changes ----part time high school student included to fill in as receptionist in afternoons MOM 01. Program Expenditures Actual Es iMatid Projected 19e6-87 1!ei -eel 1988-89 - Personnel Services $ 46,500. $ 41,540. Contractual Services 17,510. 9,635. Supplies 4,840. 5,325. - Capitol Outlay 650. -0- Program Total $ 69,500. $ 56,500. \ J w 1 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 Copies, Zoning Ord. , SubDivision Ord. , etc. $2,068.51 $1,000.00 $500.00 . t J i Number of Employees 1 — Personnel Summary 1986-87 1987-88 1988-89 City Secretary 1 1 1 Clerk 1 r. Receptionist 1 1 (1/2 yr.) Part Time receptionist 0 0 1 -1/2 day I if N Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Meetings & Minutes City Council {( P & Z, Zoning Bd. Park Bd, Lib. J Board 78 4f0--- �V Annexations 14 3 15 Ordinances 73 29 65 Resolutions 30 25 30 Public Hearing Notices 100 60 100 Elections 4 2 1 PROGRAM BUDGET SUMMARY DEPT. NO. 1()5 4111 Program CODE ENFORCEMENT Program Description Code Enforcement provides construction inspection services on the structure and all components, ie: Electric, Plumbing and Mechanical work. We provide secretarial services and advice to the Planning and Zoning Commission and Zoning Board of Adjustments, administer the F.E.M.A. flood plain management program, provide staff support to the construction Trades Board. provide or construct ordinances as requested by other departments or the Council. Provide supervision for the Fire Marshal and enforce all of the "Nuisance" ordinances, also provide developmental inspections until a development inspector is hired. MVO Program Goal To provide safe, habitable structures to the present and future residents of Wylie, and a pleasant, healthful enviroment. Also to reduce the number of substandard housing units, lower the fire risk and apply the best available resources to accomplish all of these goals. -- Program Objectives for 1988-89 To continue to provide construction inspection within our present time frame To continue the abatement of nuisances as we observe or are advised of their existance To provide information as requested by other departments and/or the public The time frame for construction inspections is within four hours of the time ... of request 1 - Significant Budget Changes 1 Building Inspectors will continue to fill in as development inspector, with added duties as Fire Marshall also included New funds added for Code Book updates, brochures and public handouts "� Progress Expenditures Actud Estimated Projected toot 67 1967 - 60 1908-69 ° Personnel Ser vices $ 73,500. $ 79,600. Contractual Services 17,725. 9,250. - Supplies 5,275. 5, 150. Capital Outlay -0- -0- Program Total $ 96,500. $ 94,000.00 .. \ J 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 Building Permits $106,487.00 $ 30,000.00 $ 45,000.00 Electrical Permits $ 19,598.00 $ 7,000.00 $ 7,000.00 Plumbing Permits $ 23,598.00 $ 8,000.00 $ 8,000.00 Mechanical Permits $ 20,171.00 $ 9,000.00 $ 9,000.00 Electric License $ 4,558.00 $ 4,000.00 $ 4,000.00 Other license and Permits $ 5,950.00 $ 4,500.00 $ 4,500.00 Code Fines $ 1,211.00 $ 200.00 $ 150.00 Reinspection Fees $ 2,455.00 $ 1,000.00 $ 1,000.00 p Number of Employees Personnel Summary 1986-87 1987-88 1988-89 Building Official 1 1 1 Inspector 1 1 1 Permit Clerk 1 1 1 t - I Performance Measures Actual Estimated Projected - 1966-87 1987 - 88 1988- 89 Construction Inspections 5,128 1,840 2,500 - Complaints (Nuisance Ordinance) 814 945 1,400 Subdivision Inspected 0 2 Normal construction inspection response time has been and is within four working hours of call. J r PROGRAM BUDGET SUMMARY DEPT. NO . 107 Program ENGINEERING Program Description Engineering is responsible for providing subdivision plat & plan review and Subdivision construction quality control; City infrastructure (water, sewer & trans- portation systems) mapping and planning; Right-of-Way acquisition and project ad- minstration; technical interpretations and recommendations to City Council and Public Works; State and Federal agency communications and reports. A total of two personnel are responsible for fulfilling these functions. Program Goal Provide the best infrastructure economically possible through long-range planning and implementation. Program Objectives for 1988-89 Adopt NCTCOG Standard Specifications for Public Works with the necessary changes to accomodate Wylie's unique conditions. Adopt a set of Standard Details for Public Works Construction. Revise, Expand & Detail the City of Wylie Base Map. Complete preparation of the first complete set of water & sewer system maps. Work toward completing a water and sewer system master plan. Adopt a Master Thoroughfare Plan. "'Significant Budget Changes Purchase of new aerial map and water and sewer map update "" _ 1 Program Expenditures Actual Estimated Projected 151136-07 1907 -SO 1900-09 - Personnel Services $ 59,000. $ 58,775. Contractual Services 13,445. 6,415. - Supplies 2,950. 3,310. Capitol Outlay 955. -0- Program Total $ 76,350. $ 68,500. • Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 J Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 City Engineer 1 0 0 Acting City Engineer 0 1 1 Asst. City Engineer 1 0 0 .- Technician 1 0 0 Draftsman 0 1 1 Develpmental Inspector 1 0 0 I ir Performance Measures Actual Estimated Projected 1906-87 1987 - 88 1988- 89 Subdivisions Completed 6 3 2 Infrastructure Improvement Projects (water lines, 0 3 2 sewer lines & streets) 11/44. PROGRAM BUDGET SUMMARY DEPT. NO. 110 - Department: Financial Services program Finance Administration Division: Administration — Procom Oesctiptice Finance Administration is responsible for directing and controlling the areas of accounting, budgeting, data processing, cashiering, tax collections, auditing, — municipal court, utility billing, risk management and warehouse operations. In risk management, this division is responsible for the property, liability and casualty insurance. — Finance Administration advises the City Manager on the status of city financial operations and policies. Makes reports as needed to the Council. Manages the City's debt services program budget (depts. 130 & 515) '- Program Goal To provide the necessary financial and related data to the City Manager, Council, - and Department Heads so that optimal decisions may be made on behalf of the City. Enhanced professional development and technical training would allow for the implemntation/consideration of new approaches/methods so as to improve Financial -° Services Department operations in administration as well as other divisions. Program Objectives for 1988-89 Increase funds available for investment New bank depository agreement - Monitor the effectiveness of operating departments to assure the highest level of services possible at designated funding levels while minimizing overall costs Increase funds liquidity and reduce liability/casualty risk costs Comprehensive Financial Report for 1987-88 Significant Budget Changes — Increased funding for legal fees-delinquent tax collections Increased funding for General Fund share of audit — Transfer Personnel Specialist for fulltime payroll function J Pretoria, ElqtenM1 rss Acted Ewe Projected , -f!17 MST -M MSS-Se Personnel gervices $118,9 75. $142,750. Contractual Services 66,825. 60,000. Supplies 10,625. 11,250. ,.,_ Cc ital Outlay 2,075. -0- Program Total $198,500. $214,000. Nil I IN Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 .41 Number of Employees - Personnel Summary 1986-87 1987-88 1988-89 Director of Finance 1 1 1 Tax-Assessor Collector * 1 .5 .5 - Accountant ** 1 1 3 Payroll Clerk ** 1 9 9 Payroll Clerk **** 9 1 * Tax-Assessor Collector transferred to Finance(110) from City Secretary (103) as of 10/01/87, in 1986-87 year position was a rashieringJaccounting function-Position now split between tax division operations, accounts receivable & financial retorts. - ** Position eliminated due to budget cuts 10/30/87 A" Position transferred to Personnel as of 10/01/87 111‘**** Position transferred from Personnel to Finance as of 10/01/88 Performance Measures Actual Estimated Projected 1966-87 1987 - 88 1988- 89 Documenting/Vouchering Accounts -. Payable for Disbursement 55 37 43 Financial Reports 12 12 12 - Receipts Deposits 250 232 238 PROGRAM BUDGET SUMMARY DEPT. NO. 110 DEPARTMENT FINANCIAL SERVICES Program TAX ADMINISTRATION AND COLLECTION DIVISION: TAX ASSESSING/COLLECTING Program Description This program mails and collects current and delinquent tax statements; posts tax -- payments and updates corrections and address changes on the current and delinquent tax roll; prepares and issues tax certificates; assists tax attorneys; prepares various reports for State and City; records and deposits all other revenues for ,� the City; and prepares and calculates the effective tax rate. WM Program Goal To perform duties that are set out by the State Property Tax Board and the City To increase tax collections - both in current and delinquent taxes. *Authorization: City Charter: Article IV (City Administration; Section VI (Administration Department) ; Subsection D - City Assessor/Collector. Also State Property Tax Code. Program Objectives for 1988-89 1) 98% Collection of current taxes 2) Maintain and correct tax roll as needed 3) Assist tax attorneys in delinquent tax collection and tax suits 4) Decrease the delinquent tax roll 5) Work towards certification as required by State law and to enroll Tax Collector/ Clerk in certification program Significant Budget Changes NIN NNW 4/ Program EspensStures Actud Estotea Projected 1986-97 1997 -88 19138-89 Personnel Services Contractual Services Supplies — Capitol Outlay Program Total _ ` so/ 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1968-89 Current Taxes $942,921. $1,249,000. $1,319,000. Delinquent Taxes 40,984. 65,000. 50,000. Penalty and Interest 20, 197. 22,000. 20,000. Tax Certificates 556. 500. 1,000. 400 Number of Employees Personnel Summory I986-87 1987-88 1988-89 Tax Assessor/Collector .5 .5 .5 — Tax Tax Collector/Clerk 1.0 1.0 1.0 1986-87 - other .5 spent as City Secretary (Department 103) — 1987-88 - other .5 spent in accounting, cashiering, and accounts receivable 1988-89 - other .5 spent in accounting, cashiering, and accounts receivable Tax Administration and Collection functions transferred to Financial Services from City Secretary as of october 1, 1987 per auditors recommendations. Now 4, / 1 Performance Measures Actual Estimated Projected - 1966-87 1987 - 88 1988- 89 Current Collections 92.4% 90.0% 90.0% Prior years and penalties 4.0% 5.0% 2.0% Average number of taxpayers serviced 3,219 4,567 4, 700 Tax Searches 250 265 275 Professional Registration 2 and Certification Compliance 2 1 I PROGRAM BUDGET SUMMARY DEPT. NO. 110 4111 DEPARTMENT: FINANCIAL SERVICES Program TAX APPRAISAL AND ASSESSMENT DIVISION: TAX ADMINISTRATION & COLLECTIONS Program Description Funds have been allocated in Department 110 (Financial Services) for the City's prorated Appraisal District for their appraised services and record maintenance. .. Program Goal * Authorizaton: State Property Tax Code Program Objectives for 1988-89 1w Aek Significant Budget Changes Costs are increasing due to the City's increased contribution to the Collin County Central appraisal District vOf (MP' 1 Progress Expendturee Actual Estimated Projected 1986-87 1987 -88 1988-89 Personnel Services Contractual Services Supplies Capital Outlay Program Total j Revenues Actual Estimated Projected v_. 1986-87 1987- 88 1988-89 N/A �.. ` 1 r Number of Employees 1 - Personnel Summary 1986-87 1987-88 1988-89 None Appraisal and Assessment services performed through Collin County Central Appraisal District r. J 1 n- Performance Measures Actual Estimated Projected 1986-87 1987 - 88 i988- 89 Tax Roll Accounts 3,219 4,518 4,680. Supplemental Roll Accounts N/A 49 20 Total Accounts 3,219 4,518 4,700 Check business, personal property changes and new accounts through inspections and updates so as to provide up to date assessment values. PROGRAM BUDGET SUMMARY DEPT. NO. 110 • Department: Financial Services • Program Purchasing/Inventory. Division: Purchasing Program Description Purchasing is responsible for the acquisition and distribution of supplies, equipt.tit and services for all city departments. Functions include (but are not limited to) develo?neat of stan- dards and specifications, solicitation of formal and informal bids, vendor selection,expediting, quality control, inventory control, verification of available funding and reconciliation of vendor invoices. Ref: City Charter Article 7, Section 9 and Purchasing Policies and Procedures Manual adopted by Council 4/28/87. Also, see Article 2368B of Vernon's Civil Statues regarding competitive bidding law. Program Goal To assist the using departments in the procurement of goods and services in the most efficient, expeditious and cost effective manner possible. Program Objectives for 1988-89 Implei:ttitation ot computerized inventory control system for central warehouse. Expansion and improvement of central stores for general office supplies and fam. Further cost reductions through broadening of vendor base, pur- less frequently and in greater volume/ Bids for volume purchases to restock warehouse inventory. Significant reduction of emergency purchases by assisting and encouraging improved planning by using departments. Utilizing joint purchasing agreements with other cities and government entities. Significant Budget Changes N _ Programs Expenditures Actual Estimated Projected 1996-QT 1907 - ee 1900-e9 Personnel Ssr vices Contactual Services Supplies Capital Outlay Program Total ) 4' Revenues Actual Estimated Projected 1986-87 1987- 88 1968-89 Al P. Number of Employees N Personnel Summary 1986-87 1987-88 1988-89 - Purchasing Agent 1 1 1 \ J iPrt \ Performance Measures Actual Estimated Projected ,- 1986-87 1987 - 88 1988- 89 P.O. 's Processed 2,000 1,200 1,200 Req. 's Processed N/A 1,500 2,000 Formal Bids N/A 10 12 Info.caal Bids N/A 1,200 2,000 0' PROGRAM BUDGET SUMMARY DEPT. NO. 120 DEPARTMENT: FINANCIAL SERVICES Program COURT SERVICES DIVISION: MUNICIPAL COURT -- Program Description The Municipal Court Clerk is responsible for maintaining all records of the court, .... collecting court finds, court fees and state taxes, preparing warrants of arrest, and performing administrative and clerical functions. It also helps to serve as a information center for the defendants, attorneys and witnesses, the court is additionally responsible for getting the complaints ready for court, and is responsible for sending the bond money to other agencies. This court also prepares the court docket and serves only Class "C" Misdemeanor Cases. AIMOM Program Goal To provide efficient and effective services to the citizens, also to provide a cost -- effective, high quality service in disposing of criminal cases filed in the Municipal Court. Program Objectives for 1988-89 .� To increase the number of cases filed in the Municipal Court To increase the current level of service in processing citations and preparing ^- warrants To dispose of the old cases on the courts docket AUTHORIZATION: City Charter - Article IV, City Administration, Section 3- Municipal Court (A-G) , Section 3 (E) Municipal Court Clerk, Section 3 (B&C) Municipal Court Clerkel J Significant Budget Changes s f r rt Time o f Cle ( 0 - 25 o s per w ) new program, putt ch�zf es -°' ,/ I /' 1 , Program Expenditures Actual Estimated Projected a. 1986-111 1987 - 88 1988-89 Personnel Services $ 24,950. $ 24,770 .- Contractual Services 19,300. 20,210. Supplies 2,750. 2,770. - Capitol Outlay -0- -0- Program Total $ 47,000. $ 47,750. I 1' 1 Revenues Actual Estimated Projected .. 1986-87 1987- 88 1968-89 Municipal Court Fines $102,537. $100,000. $100,000. Court Admin. Fees 9,413. 7,500. 11,000. J Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Court Clerk 1 1 1 *Municipal Judge * * * - *Deputy Municipal Judge * * * *Prosecuting Attorney * * * - *Professional Services Employees - only one Court Clerk is a full time employee, but there is one (1) each, Municipal Court Judge, Deputy Judge, and Prosecuting Attorney. Slit .0 P 1 Performance Measures Actual Estimated Projected 1966-87 1987 - 88 1988- 89 Traffice Citations 3826 4320 5325 Non-Traffic Citations 2897 3980 5120 Courtesy Letters 550 600 725 Warrants 664 789 950 .., Parking Tickets 15 25 38 Ordinance Violations (includes Code Enforcement, Junk Salvage, Utility Billing Complaints) 106 324 452 r" PROGRAM BUDGET Surer 1 DEPT. NO. 201 • ProartINI POLICE ADMINISTRATION Program Description "' Police Administration provides direction to the Department, implements controls in the proper places, ensures there is coordination between the various Departmental units, promulgates policies and procedures, and creates an environment where well-trained personnel provide the highest levels of police service. These services include Communications, Jail, Records, Crime Prevention, Training, Recruiting Personnel functions, and Budget preparation. Administration is responsible for recruiting, processing and the background investigation of all police officer applicants. Provides educational instruction and develops performance standards for entry level and senior officers. ... Program Goal To provide excellent police services through the maximum utilization and development of police personnel and resources. To provide research and initiate short and long range planning. To provide professional recruitment and training for the Wylie Police Department in -•- order to maintain the highest quality of service to the community. Program Objectives for 1988-89 -- - To computerize interdepartmental personnel records and budget records. - To initiate a computerized entry of all offense and arrest reports. - To create a training needs assessment for a 40 hour minimum yearly training program for each police officer. - To establish a training program for communications personnel to be cross-trained as certified jailers. AMR fr-Significant Budget Changes 1 r. -- Upgrading Records Clerk position to Secretafy, transferring Administrative Assist. to City Manager's Office r j1j,k, -- Additional funds for personal computer ',p Prow Nei Expenditures Actual Estimated Projected 191315-87 t91117 -SS 1988-89 Personnel Services $ 64,500. $ 63,020 Contractual Services 16,400. 4,905. Supplies 3,100. 2,075. Capitol Outlay -0- 2,000. Program Total $ 84,000. $ 72,000. . \ I e Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 I Number of Employees Personnel Summary 1986-87 1987-88 1988-89 Police Chief 1 1 1 Secretary 1 0 1 Administrative Assistant 0 1 0 1 e Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 J PROGRAM BUDGET SUMS DEPT. NO. 202 Program POLICE PATROL ENFORCEMENT Program Description Police Patrol Enforcement consists of two fixed patrol shifts whose deployment is based on the manpower available. Patrol Enforcement responds to all citizen requests for police service and insures enforcement of criminal and traffic laws. Serves as liason with local/county traffic safety groups, Selective Traffic Enforcement Programs, special event traffic and parking control, and professional investigation of injury and fatality accidents. Patrol serves warrants of arrest, both felony and misdemeanor, issued by courts of appropriate jurisdiction. Patrol also provides assistance, upon request, to other law enforcement agencies in the execution of their warrants with the City of Wylie. Patrol officers assigned to Bailiffs are responsible for maintaining the security and insuring the orderly proceedings of the Municipal Court. Police patrol is responsible for all preliminary investigations on all offenses and must secure all crime scenes. Program Goal To provide a sense of security in the community through efficient allocations of resources and insure the ability to respond to citizen calls for service; to prevent ,. and detect offenses through innovative patrol techniques; and to seek citizen input relative to services provided. To promote traffic safety, traffic enforcement, and the orderly flow of traffic through city streets and highways coupled with the reduction of traffic collisions. To provide efficient and expeditious disposition of arrest warrants. Program Objectives for 1988-89- To assure criminal law enforcement by maintaining or increasing present level of arrests. - To maintain an average response time at the present level for Priority I calls. - To assure traffic laws enforcement at the present level with a possible increase in the issuance of radar speeding citations. - To provide increased professional training for accident investigators and to keep pace with trends and innovations in traffic management. 4)1 Significant Budget Changes -- Adding one Police Officer for new year and 2 new police cars to replace vehicles with over 100,000 miles � J IN Pr � Expenditures� 11�xfi Actual Estimated Projected 1966-87 1967 -OS 1910-09 Personnel Services $281,100. $292,270. Contractual Services 55,150. 14,350. Supplies 22,200. 18,680. Capitol Outlay 39,550. 37,700. Program Total $398.000. $363,000. Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 ,. Lake Patrol - Corps of ,7p Engineers $38,689.00 $38,926.97 9 9 7 200• 41 at Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Police Lieutenant 1 0 0 Police Sergeant 1 2 2 "" Police Officer 10 6 7 TOTAL 12 8 9 1 Performance Measures t Ac ual Estimated Projected .._ 1986-87 19E4- 88 1988- 89 Patrol Calls for Service 5892 6533 Calls per Officer per year 491 775 816 Avg. Response Time - Priority I Calls for Service (Minutes) 2.5 3.5 3.5 Citations Issued 2759 1944 1944 '- Arrests 511 360 360 Traffic Accident Fatalities 2 3 4 Personal Injury Accidents 45 54 65 — \Total Accidents Investigated 139 146 154 f PROGRAM BUDGET SUMMARY DEPT. NO. 203 - Program POLICE INVESTIGATIONS Program Description —` Police investigations has the responsibility of investigating all criminal offenses which occur within its jurisdiction and compiling related documentation to assure a successful prosecution. The investigation of all juvenile-perpetrated offenses and follow-up of missing persons, internal affairs, police identification, and police property control are also handled by investigations. Coordinates with the forensic laboratory system on all matters of criminal evidence. Investigation also handles the majority '^ of crime prevention programs, such as neighborhood crime watch. WIMP WOW Program Goal To provide a high degree of efficiency in the investigation of crime. To provide effective follow-up investigation of all criminal offenses so as to maintain an effective clearance rate. To provide assistance in the investigation of allegations of employee/officer misconduct both criminal and non-criminal in nature. To maintain efficient storage of all property entered into property and evidence control and to legally dispose of those items. Program Objectives for 1988-89 - To maintain the clearance rate of crimes against persons offense (89%) and to increase the clearance rate of crimes against property by 3Z. - To establish a narcotic enforcement unit for pro-active investigations to identify �. target, arrest, and prosecute narcotics dealers and increase the volume of seized assets presented for forfeiture. - To expand the crime prevention program to encompass liason with the schools and - provide better communications with the citizens about crime problems and prevention. - To computerize the police property inventory for better efficiency. 40/ Significant Budget Changes No Special Changes 1 Progreak Expenditures Actual Estimated Projected . 1966-87 MST -a �d r9 -99 Personnel Services $ 32,625. $ 31,950. Contractual Services 11,000. 4,025. Supplies 2,375. 2,525. Capital Outlay 1,000. -0- Program Total $ 47,000. $ 38,500. - L J _ l 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 Seized monies & vehicles $3305.00 $1400.00 -0- J Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Detective 2 1 1 I ._ f, 1 Performance Measures Actual Estimated Projected ..,r. 1986-87 1987 - 88 1988- 89 Offenses reported 798 812 850 Offenses cleared 298 244 250 - Cases filed with District Attorney's Office 66 88 117 Neighborhood Crime Watch Meetings 2 10 10 Neighborhood Crime Watch Areas 5 31 31 J PROGRAM BUDGET SUMMARY DEPT. NO. 204 Program POLICE COMMUNICATIONS AND RECORDS Program Description — Police Communications is responsible for the operation and maintenance of the police radio communications system, including the receiving and dispatching of calls for service -- and in-house report-taking. Police Records receives, processes and maintains all documents initiated as a result of police and citizen interaction. AMR MOW MM Program Goal To provide all the necessary communication methods to ensure an effective response to all situations. ..., To maintain efficient storage and retrieval capabilities of all documents processed through the Records section in accordance with legal guidelines. Program Objectives for 1988-89 -'° - To establish the operation of the Police Communication Center. - To establish effective employee training for communication personnel through the use of external training opportunities and in-house training programs. MOM - To improve the current call management system. - To continue to efficiently house and retrieve police documents. - To continue to provide prompt and professional service for telephone and window customers. 1 NNk Significant Budget Changes -- Records Clerk transferred to Police Administration as Administrative Secretary Pre via Expenditures Actual Estimated Projected 96-il7 1987 - II On- Personnel Services $ 98,125. $ 89,750. Contractual Services 24,050. 6,825. Supplies 4,225. 4,325. Capitol Outlay 4,600. 4,600. Program Total $131,000. $105,500. Not Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 J Number of Employees Personnel Summary 1986-87 1987-88 1988-89 Dispatchers 4 4 4 Records Clerk 1 1 0 TOTAL 5 5 gr 1 Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Police calls for service 5892 6204 6533 Texas Crime Information Center Computer Transactions 17,779 14,973 14,973 Average Data Entry Error Rate 2.1% 1.2% 1.8% Statewide Avg. Data Entry Error Rate 2.5% 2.4% 2.4% 9-1-1 Calls Answered 10,945 2,737 Documents Processed 1514 1406 1406 PROGRAM BUDGET SUMMARY DEFT. NO. 220 Program FIRE DEPARTMENT -^• Program Description The mission of the Wylie Fire Department is: to provide protection from threats -- to the lives and property of the people of Wylie, through swift response to fire, medical emergency, hazardous material, incidents and all other disasters. Program Goal To reduce dollar loss from fires and other disasters in our City Increase membership by at least five persons per year Develope our own training program to reduce schooling and travel expense Replace aging and worn out equipment, to up grade the performance of fire and disaster control in our City WINO Program Objectives for 1988-89 Faster response time to all calls 6 minutes or less within City Place in service a support vehicle for fire and rescue use —^ Replace old boat with newer more usalbe boat that is safer Replace aging fire engine to maintain current Key Rate and provide seating and safer response for firefighters _„ Develop compensation plan to take care of firefighters normal salaries in case of injury on job as Wylie Firefighter. ikkk 'Significant Budget Changes S --Use of Public Safety Bond Funds for purchase of support vehicle, rescue boat, hydralic air big system and miscellaneous hoses and tools MRS MEW NNW a Pregram Expenditures Mud Estimated Projected _u 1986.67 Mr? -80 1998-89 Personnel Services $ 12,525. $ 13,375. - Contractual Services 22,625. 4,675. Supplies 6,350. 6,350. -. Capitol Outlay 18,000 2,000. Program Total $ 59,500. $ 26,400. ,.. OIN Revenues Actual Estimated Projected 1986-87 1987- 88 1968-89 From Collin County Firefighter Assoc. for County Fire Runs $6,800.00 $7,000.00 $7,400.00 Contracts with St. Paul and -0- $1,000.00 $1,500.00 Rockwall -0- $ 400.00 $ 500.00 Al is Number of Employees 1 - Personnel Summary 1986-87 1987-88 1988-89 Volunteer Firefighters 28 30 35 Active on membership L J t' 1 - Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Calls in City 130 160 180 Calls in County 91 114 115 Mutal Aid Given 18 14 20 Mutal Aid Received 6 12 10 Total Calls Answered 245 300 325 J 40.6 PROGRAM BUDGET SUMMARY DEPT. N0. 301 program RITA AND TRUETT SMITH LIBRARY Program Description The Rita and Truett Smith Library is responsible for the organization, maintenance and distribution of library materials in a wide variety of formats to the citizens of Wylie and the surrounding unincorporated areas. The Library provides convenient access and assistance to library users and offers programs to promote use of the collection of materials. Program Goal To provide for the citizens of Wylie and surrounding areas access to a wide - variety of materials and services that reflect the informational, educational and recreational needs of this community and to provide activities which promote their fullest use. Program Objectives for 1988-89 To seek to stabalize local funding for the continuance of library services During this year of transition, the new library director, library board and — City Manager will develop one year and long term library goals To seek three additional funding resources in the community for enhanced library services to increase the total volunteer work force by 40% To increase adult circulation by 10% To increase juvenile circulaton by 15% to increase video circulation by 10% To increase library programing for adults and children by 10% Significant Budget Changes --Library Directors salary funded through Meadows Grant and outside support --Continuing active membership in North East Texas Library System "' f 4' Preview Expenditures ktuM Estimated Projected 199647 19117 - e9 1986-99 Personnel Services $ 27,325. $ 19,050 _ Contractual Services 15,850. 4,225. Supplies 3,825. 3,325. - Capital Outlay -0- -0- Program Total $ 47,000. $ 26,600. I Revenues Actual Estimated Projected _ 1986-87 1987- 88 1988-89 Library Fines $ 1,294. $ 1,000. $ 1,000. w Library Contributions and Grants 1,469. 12,000. 25,000. _ County Contributions 2,625. 3,000. 3,500. - N 1 INumber of Employees IN _„, Personnel Summary 1986-87 1987-88 1988-89 Library Director 1 0 1 - Library Aide 2 1 1 J Ae° 1 a-, Performance Measures • Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Budget $69,814. $ 59,078. $ 65,198. - Funding Sources -0- 1 3 Volunteers -0- 18 25 Circulation Adult 7,468 6,526 7, 178 ,„ Juvenile 10,961 9,201 10,581 Videos 2,360 2,365 2,601 Programs 16 45 50 Total monies contributed from NETLS since 1976 $65,000.00 A r PROGRAM BUDGET SUMMARY DEPT. NO. 310 Program PARKS AND RECREATION 447.4 Program Description Parks and Recreation is responsible for the operation and maintenance of the City park system. These responsibilities include care of all vegetative growth, lighting, irrigation systems, playground and picnic areas, and parking facilities. It also includes maintenance of all structures and buildings. Program Goal Provide and maintain City Parks and keep right-of-ways mowed Program Objectives for 1988-89 OAP --To improve the system of trash and litter removal in all parks --Properly install and maintain an irrigation system at City Park --Initiate a weed control programAIM --Upgrade existing playground equipment --Provide adequate maintenance throughout the park --Improve efficiency of mowing right-of-ways MOO "Significant Budget Changes Full time personnel dedicated solely to maintaining the Parks brought on in February Adding two new lawn mowers, sprinkler system and playground equipment upgrade Participating with State of Texas for a Highway Beautification Grant to construct landscaped entry ways along FM 544 and SH 78 MOP r . iisk P't M fvhe Animal Estliiielled Projected SMIS-97 NIP -MI 19l9-N ._ Personnel Services $ 1,000. $ 18,525. CeMrectuoi Services 23,950. 12,400. Supplies 4,925. 11,775. Capital Outlay 1,125. 3,300. Program Taal $ 31,000. $ 46,000. J 4 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 J fNumber of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Grounds Foreman 1 0 1 Maintenance Worker 1 0 0 1 Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Acreage Maintained 48.5 48.5 48.5 .. Park Sites 3 3 3 Right-of-ways (Miles) 9 9 9 PROGRAM BUDGET SUMMARY DEPT. N0. 420 EMI Pr°Wen STREETS AND DRAINAGE Program Descr iption Streets and Drainage is responsible for all street surface repair and preventative maintenance designed to reduce or eliminate the normal adverse effects of traffic and environment. It performs work required to rectify specific citizen complaints and responds to weather related emergencies. Additionally it is responsible for maintenance of drainage ditches and channels, culverts, and storm drains. Program Goal To properly maintain streets and drainage facilities for the City of Wylie at an acceptable level, and to program a complete inventory of all asphalt, concrete, and gravel streets, to include drainage ditches and channels. Program Objectives for 1988-89 --Seal Coat 5 lane miles of street --Crack Seal 4 lane miles of street '^ --Clean 200 linear feet of culvert pipe --Reconstruct 2 lane miles of asphalt street as per the assessment program --To maintain major street repair at 6.94 tons per man hour f Significant Budget Changes AIN --continual upgrade of streets through crack seal program and use of Bomag IMO MOM Mr MM. J 4' Previa EiOeM Lures Actual Estimated Profited $10547 1!n -M 1!M-SD Pstionnel Services $ 92,675. $ 94,300. Contractual service! 126,300. 77,100. Suppilee 105,025. 107,600. Capita Outlay -o- -a--, 9-61-6J, Program Tool $324,000. $. 79e0. Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 _ � I Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Street Crew Foreman 1 0 1 Street Superintendent 1 0 1 Maintenance Worker 4 4 A kliftir ilOr ie IN Performance Measures Actl f_A Estimated Estimated Projected 1986-87 1987 - 88 1988- 89 Borrow Ditches Cleaned (Miles) N/A 2 4 Street Repair (Tons per man hour) N/A 6.94 6. 94 - Crack Seal (lane miles) N/A .75 4 Reconstruction (lane miles) N/A 2 2 Street Resurface (lane miles) N/A 1 2 J PROGRAM BUDGET SUMMARY DEPT. NO. 440 ' "" Program FLEET MAINTENANCE Program Description Fleet Maintenance is responsible for servicing and maintaining the City's entire fleet. Included as its functions are repairs, preventative maintenance, and auto parts inventory control. MOW MOW Program Goal To provide all City departments with an efficient and effective fleet of vehicles ., and equipment. This goal can be reached by establishing uniform specifications designed to reduce vehicle repairs, and implementing a priority system to reduce down time on emergency vehicles. Program Objectives for 1988-89 - To increase the availability of vehicles and equiment to 90% for all departments - Implement a priority system )1 Significant Budget Changes \ - Shifting mechanic to night duty for more efficient services \ 1, POW.. Espeadit »s 8ettd Eallineled Mkt t91&-4117 MP -11111 IMO-M! Pwioiwief Services t $ 20, 150. $ 23,550. Contractual Services 0 �.._ er " , 2,200. 1,550. Supplies - 2,950. 2,900. Capitol Outlay c - 1,200. -0- Program Total $ 26,500. $ 28,000. J INN Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 thlik 41 Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Chief Mechanic 1 1 1 Nit 1 Performance Measures Actual Estimated Projected µ 1966-87 1987 - 88 1988- 89 Vehicles Maintained n/a 14 20 Equipment Maintained n/a 17 20 `...m Emergency Vehicles Maintained n/a 11 13 Come Backs n/a 4 10 Emergency Vehicle Repairs n/a 77 95 _ Public Works Vehicle Repairs n/a 107 115 Equipment Repairs n/a 51 60 Finance Dept. Repairs n/a 20 30 Total Reapirs Made n/a 255 300 Contracted Repairs n/a 20 40 40.6 PROGRAM sumo. SUMMARY DEPT. NO. 450 .� Program ANIMAL CONTROL Program Description Animal Control provides services to the citizens of Wylie which are aimed at reducing the incidence preventable illness and disease within the community by patrolling for -" stray animals and the removal of dead animals, and the taking of unclaimed/unwanted animals to the Garland Humane Society. Also included is licensing animals that have valid proof of rabies vaccinations and the adoption of animals. It also enforces the City of Wylie Animal Control Ordinance. MOOR Program Goal Provide better animal control for Wylie, better enforcement of the Animal Control IMPR Ordinance adopted by the City of Wylie, and to provide for more efficient responses and answers to citizen calls for service. Program Objectives for 1988-89ORMOR --To increase dog and cat licensures by 3% --To increase the number of dogs and cats released from Animal Control by 3% 'Significant Budget Changes IMMO --Purchase of cat cages and upgrade of animal shelter Program Expenditures Acted Esd Projected -R IOW -N i'.es-M Personnel Ser vices $ 19,575. $ 21,160. Contractual Services 11,390. 8,990. Supplies 4,900. 4,350. Capitol Outlay 2,135. 3,500. Program Total $ 38,000. $ 38,000. J e Revenues Actual Estimated Projected 1986-87 1987- 88 1968-89 Fines and Fees $2,005. $ 4,000. $ 4,500. Al el Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Animal Control Officer 1 1 1 J Performance Measures Actual Estimated Projected 1966-87 1987 - 88 1988- 89 Dog & Cat License Issued 177 365 376 Dogs & Cats Adopted n/a 56 60 Citations Issued n/a 40 42 Animals Impounded n/a 802 842 UTILITY FUND ************************************************************* 1988/89 UTILITY FUND BUDGET REVENUES ************************************************************* UTILITY FUND ACTUAL BUDGETED PROPOSED 1986/87 1987/88 1988/89 ************************************************************* WATER SALES 578 ,881 827 ,500 784 ,250 SEWER SERVICES 401 ,565 531 ,000 587 ,500 TAP FEES 41 ,498 37 ,500 13 ,000 PENALTIES/CONNECTION FEES 8,208 33 ,750 46 ,750 MISCELLANEOUS 24 ,342 20 ,250 16 ,500 TOTAL 1 ,054 ,494 1 ,450 ,000 1 ,448 ,000 ************************************************************* PROPOSED 1988/89 UTILITY FUND BUDGET EXPENDITURES BY DEPARTMENT ************************************************************* ACTUAL BUDGETED PROPOSED 1988/87 1987/88 1988/89 ************************************************************* UTILITY ADMINISTRATION 167 ,906 151 ,000 188,500 WATER SERVICES 496 ,696 519 ,500 570 ,000 WASTEWATER SERVICES 323 ,127 384 , 525 627 ,000 UTILITY BILLING 138 ,057 194 ,500 181 ,000 DEBT SERVICE 97 ,390 200 ,475 218 ,500 BUILDING SERVICES 0 0 40 ,000 TOTAL 1 ,223 , 176 1 ,450 ,000 1 , 825 ,000 °." *********************************************************** UTILITY FUND DEBT SERVICE *********************************************************** BOND 1988 DEBT PAYMENTS *********************************************************** CERT OF OBLIGATION ' 88 (S) 65 ,500 BD PAY W/S SYS REV BD ' 71 32,250 BD PAY W/S SYS SERIES 80 35 ,200 BD PAY NTMWD BD ' 80 15 ,500 BD PAY W/S REV 86 SERIES 18 , 450 PAYING AGENT FEES 1 ,600 CITY COUNCIL RESERVE 50 ,000 TOTAL 218 ,500 1988- 89 UTILITY FUND BUDGET Expenditures by Department Water Services Utility Sewer Services Administration Building Services Utility Billing Debt Service SERVICE AREA 1988 - 89 % OF BUDGET TOTAL Utility Administration $ 188,500 10% Water Services 570,000 31% Sewer Services 627,000 34% Utility Billing 181 ,000 10% Debt Service 218,500 12% Building Services 40,000 2 % TOTAL $ 1 ,825, 000 100% 1988-89 UTILITY FUND BUDGET Revenues Water Sales Proposed Increase Sewer —in Rates ► //I 4 Services Misc. Tap Fees Penalties/Connection Fees CATEGORY 1988-89 % OF BUDGET TOTAL Water Sales $ 784,250 43% Sewer Services 587,500 32% Tap Fees 13 ,000 I % Penalties/Connection Fees 46,750 2% Miscellaneous 16,500 I % Prop. Increase in Rates 37 7,000 2 I % TOTAL $ 1,825 ,000 100% PROGRAM BUDGET SUM MARY DEPT. NO. 501 Program PUBLIC WORKS ADMINISTRATION Program Description Public Works Administration provides direction and coordination for the programs within the division to implement the public works programs and activities of the city. Responsible for overall supervision and administration of animal control, parks and recreation, streets and drainage, wastewater collection system, and upkeep of heavy equiment orperations to include maintenance and scheduling of vehicle repairs. Program GoalIMP To provide direction for the activities of the Public Works Division and to ensure that the department is responsive to the needs of the citizens and maximizes the benefits obtained for the costs expended. Program Objectives for 1988-89 .. --To review the organizational structure of the Public Works Division for possible changes to improve efficiency of operations. -- To increase scheduled maintenance work, in turn decreasing citizen complaint calls 1 ._ eg Significant Budget Changes --Increase in administrative cost transfer from $80,000. to $120,000. which reflects _. auditor's cost allocation figures for general fund support to utility fund (contractual services) IN Progrew Expenditures Actual Estinumed Projected 6-07 1117 -1M3 1900-09 Personnel Services $ 75,568. $ 52,700. $ 55,600. CmMroctual Services 60,336. 89,525. 125,850. Supplies 6,378. 6,350. 7,050. Capitol Outlay 7,901. 2,425. -0- Program Total $167,906. $151,000. $188,500. Ali 1/INRevenues Actual Estimated Projected 1986-87 1987- 88 1988-89 .. I e Number of Employees 41 Personnel Summary 1986-87 1987-88 1988-89 Public Works Superintendent 1 1 1 Administrative Secretary 1 1 1 t I Performance Measures Actual Estimated ed Projected 1986-87 1987 - 88 1988- 89 Inter-Office Record System 0 1 3 Citizen Complaints n/a 1065 1075 Scheduled Activities n/a 710 740 PROGRAM BUDGET SUMMARY DEPT NO. 502 Program WATER OPERATIONS Program Description Water Operations is responsible for operating and maintaining the water distribution system and facilities, such as water tower and pump stations, that distribute potable water to the citizens of Wylie, and assisting other City departments if and when the occasion should arise. Program Goal To supply adequate potable water and fire protection to the City of Wylie with as .,. little interference of services as possible, doing this in compliance with all Federal, State, and City Ordinances or Laws. Program Objectives for 1988 -89 --To respond to all damaged fire hydrants within 24 hours --To install all new tap orders within 3 days --To renew 2,000 linear feet of water main per year MOM el'Significant Budget Changes --Increase of $48,000. minimum payment for water purchases form NTMWD (352,600,000 gals. to 432,712,000 gals.) IOW --Values and repair to pump station at NTMWD J Program Expe enures Actual Estimated Pro)eased 19116-11l 1W -811 19O-M Persoonnel Services $ 117,414. $ 119,725. $ 115,325. Contractual Services 290,524. 306,725. 341, 150. Supplles 55,843. 56,600. 81,525. Capitol Outlay 32,915. 36,200. 32,000. Program Total $ 496,696. $ 519,500. $ 570,000. ihili Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 Ail eNumber of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Water Superintendent 1 1 1 General Foreman 1 1 1 - Maintenance Worker 1 1 1 Equipment Operator 1 1 1 iii I 1 Performance Measures Actual Estimated Projected 1986-87 1987 - 88 1988- 89 Water Main Leaks Repaired n/a 118 130 Avg. Labor & Equip. cost per repair n/a $180.00 $180.00 Avg. Material cost per repair n/a n/a n/a Fire Hydrant repairs n/a 12 14 Avg. Labor & Equip. cost per repair n/a $145.00 $145.00 _ Avg. Material cost per repair n/a n/a n/a Water Taps Installed n/a 6 50 Avg. Labor & Equip. cost per repair n/a $142.00 $142.00 Avg. Material cost per repair n/a n/a n/a PROGRAM BUDGET SUMMARY DEPT. NO. 503 Program WASTEWATER/LIFT STATION OPERATIONS Program Description Wastewater/Life Station Operations is responsible for maintaining the entire — collection system by clearing of sewer stoppages, sewage lift station operation and maintenance. NOM Program Goal To maintain the sanitary sewer collection system in good condition so as to minimize — sewage backups and sewage overflow, and to decrease mobile collection locations by 3%. NOM Program Objectives for 1988-89 - Jet 2000 feet of sewer mains - Perform general maintenance one time per month on lift stations - Increase property line clean-outs by 10% — -Initiate installation of new lines through North Texas Municipal Water District sewer bonds 1 e Significant Budget Changes --NTMWD plant operations increased to 105,797 from 74,074 --Contractual (debt service for Texas Water Development Board Bond - $2,000,000) OM* increase from 136,200 to 256,738 (will level out after this year) --Regional Sewer Plan - $15,000. ... _ Pfsgraw Expenditures Actual Estimated Projrc*d 1986-1/7 I9.7 -SS19as-la Services $ 72, 163. $ 60,200. $ 86,750. Contractual Services 154,335. 261,250. 450,450. Supplies 53,616. 45,075. 54,050. Capital Outlay 43,013. 18,000. 35,750. Program Total $323, 127. $334,525. $627,000. J - r Illsk Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 Wastewater Foreman 1 1 1 Maintenance Worker 3 1 1 Mobil Collection Operator 1 1 1 Lift Station Maintenance Worker 2 0 0 Equipment Operator 1 0 0 Performance Measures Actual Estimated ma ed Projected - 1986-87 1987 - 88 1988- 89 Pumps Replaced n/a 38 45 Sewer Stoppages n/a 200 200 "" Clean-out installation n/a 56 61 Mobil Collection (Man Hours) 548 730 730 Lift Stations 8 7 9 Daily Rounds (Man Hours) 834 730 938 PRAM BUDGET SUMMARY DEPT NO. 510 Program UTILITY BILLING 1 WAREHOUSE ..- Program Description This department is responsible for the billing of all City utility customers, ... collection of revenues from those customers and all record keeping associated with those accounts. Department also is responsible for neter reading and servicing (connects, fials, cut-offs, meter changes, re-reads and testing) . These activities have to be done in a timely manner so that bills can be processed and sent out on time. City currently uses two (2) billing cycles. Department also has responsibility for warehouse activities, fixed asset control, inventory control and operation materials & fuel supplies. Department -" also has a data processing technician who provides information management and computer-related assistance to all departments. Since most computing functions are in finance or utility billing, the majority of his time is spent in those _.. departments. Program Goal Program Objectives for 1988-89 e Significant Budget Changes --Receptionist at City Hall - half of salary carried in dept. no. 510 --Data Processing Technician transferred to Utility Billing in 1988 year had been in Finance & Street/Drainage (General Fund) --Utility Fund audit share increase from $4,000 to $7,000 (contractual services) -'" * 1 Pry'Pr•greis Expenditures kph Emoted Projected 190647 1907 -SO 190O-09 - Personnel Services $ 64,678. $103,350. $111,825. Contractual Services 27,877. 54,175. 37,750. .... Supplies 27,321. 29,375. 31,425. Capitol Outlay 18,181. 7,600. -0- Program Total $138,057. $194,500. $181,000. Ali _ r 1 Revenues Actual Estimated Projected 1986-87 1987- 88 1988-89 - Water Sales $579,881. $827,500. $784,150. Sewer Service 401,565. 531,000. 587,500. Tap Fees 41,498. 37,500. 13,000. .-. Penalties/Connection Fees 8,208. 33,750. 46,750. Miscellaneous 24,341. 20,250. 16,500. Transfers 88,388. -0- -0- Short-Term note 50,000. -0- -0- TOTAL $1, 193,881. $1,450,000. $1,448,000. -. 4, / Number of Employees 1 Personnel Summary 1986-87 1987-88 1988-89 -- Senior Billing Clerk 1 1 1 Meter Service worker 1 (mid yr.) 1 1 Meter Reader 1 1 1 — Warehouseman 1 1 1 Data Processing Technician 1 1 1 Recptionist (other half Gen. Fd. 0 0 .5 City Sec. 103) Performance Measures Actual Estimated Projected "-. 1986-87 1987 - 88 1988- 89 Utility Billing Statement 29,640 30,550 31,000 - Termination notices (utility) 5,562 6,920 7, 100 CITY OF WYLIE, TEXAS FINANCIAL REVIEW OF UTILITY ENTERPRISE FUND PREPARED BY: CHARLES BINFORD FINANCIAL MANAGEMENT CONSULTANT SEPTEMBER 6, 1988 CITY OF WYLIE, TEXAS WATER CONSUMPTION & BILLING DATA BY MONTH FISCAL YEAR 1987-88 Total Billed Consumption Average Estimated Consumption Per Account Monthly Amount Month Accounts (in 1,000 Gals.) (in Gallons) Bill Billed October 2,574 35,366.8 13,740 $29.69 $76,422 November 2,564 23,343.6 9,104 21.25 54,485 December 2,528 18,429.2 7,290 17.95 45,378 January 2,513 20,065.2 7,985 19.21 48,275 February 2,520 18,569.9 7,369 18.09 45,587 March 2,541 22,810.3 8,977 21.02 53,412 April 2,556 26,794.3 10,483 23.76 60,731 May 2,592 29,547.0 11,399 25.43 65,915 June 2,624 38,595.9 14,709 31.45 82,525 July 2,649 38,741.8 14,625 31.30 82,914 August (Est.) 2,660 40,000.0 15,038 32.05 85,253 September (Est.) 2,660 38,500.0 14,474 31.02 82,513 Averages 2,617 29,230.3 11,169 $25.01 $65,284 Total Billed 350,764.0 Consumption (gallons) Total Amount $783,408 Billed fit. �� I, 7 ( 0*r � w , c 1 CITY OF WYLIE, TEXAS BILLED WATER CONSUMPTION BY MONTH 1986-87 AND 1987-88 1987-88 Consumption Billed Consumption (Gallons) : Increase (Decrease) Over 1986-87 Month 1986-87 1987-88 Gallons Per Cent October 22,705,619 35,366,784 12,661,165 55.8% November 27,533,704 23,343,649 (4,190,055) -15.2% December 17,709,897 18,429,181 719,284 4.1% January 17,869,356 20,065,192 2,195,836 12.3% February 18,110,765 18,569,912 459,147 2.5% March 18,074,069 22,810,300 4,736,231 26.2% April 26,270,633 26,794,293 523,660 2.0% May 28,033,641 29,547,026 1,513,385 5.4% June 23,231,760 38,595,900 15,364,140 66.1% July 30,419,211 38,741,835 8,322,624 27.4% August * 45,735,871 40,000,000 (5,735,871) -12.5% September * 40,748,923 38,500,000 (2,248,923) -5.5% Totals 316,443,449 350,764,072 34,320,623 10.8% Totals through July 229,958,655 272,264,072 42,305,417 18.4% * Billed consumption estimated for August and September, 1988. 2 CITY OF WYLIE, TEXAS WATER CONSUMPTION VS. WATER SALES AND SEWER SERVICE INCOME FISCAL YEAR 1987-88 Water Sales Sewer Service Water Consumption $ Per $ Per Month (Gallons) Income 1,000 Gals. Income 1,000 Gals. October 35,366,784 $71,105 $1.74 $42,256 $1.75 November 23,343,649 54,229 1.53 42,941 1.21 December 18,429,181 58,148 2.49 43,961 1.88 January 20,065,192 50,880 2.76 48,698 2.64 February 18,569,912 48,789 2.43 42,645 2.13 March 22,810,300 50,731 2.73 41,054 2.21 April 26,794,293 44,484 1.95 38,968 1.71 May 29,547,026 67,042 2.50 48,866 1.82 June 38,595,900 62,889 2.13 48,381 1.64 July 38,741,835 66,308 1.72 50,896 1.32 August (Est) 40,000,000 80,000 2.06 51,000 1.32 September 38,500,000 85,000 2.13 51,000 1.28 (Est) Totals 350,764,072 $739,605 $2.10 I $550,666 r $1.64 Notes: (1) Water consumption represents "billed consumption" for each month, from "Bill Frequency Analysis." (2) Water sales and sewer service income represents amount collected each month, from "Revenue Budget Report." (3) $ per 1,000 gallons calculated by dividing each month's collected income by previous month's billed consumption. 3 CITY OF WYLIE, TEXAS UTILITY FUND REVENUE FISCAL YEAR 1987-88 (BUDGET BASIS) Actual Estimate Original 10 Months 2 Months Estimate Budget Ended Ending for Source of Revenue Estimate 7-31-88 9-30-88 Year Water Sales Retail $820,000 $574,605 $165,000 $739,605 Water Sales Bulk 2,500 3,000 600 3,600 Other Water Sales 5,000 4,790 1,010 5,800 Water Tap Fees 30,000 5,159 1,941 7,100 Meter Turn On-Off Fees 3,750 2,120 380 2,500 Sewer Service Retail 530,000 448,666 102,000 550,666 Sewer Service Bulk 1,000 0 0 0 Sewer Tap Fees 7,500 1,378 322 1,700 Interest on Investments 2,500 1,915 585 2,500 Interest for Deposit Fund 6,650 6,069 0 6,069 Penalty & Interest 30,000 35,295 7,705 43,000 Insurance Proceeds 100 0 0 0 Damage Reimbursement 1,000 1,143 0 1,143 Service Improvement 500 73 0 73 Reimbursement Industrial Test Reimb. 500 0 0 0 Other Misc. Revenue 9,000 8,804 696 9,500 TOTAL REVENUE $1,450,000 $1,093,017 $280,239 $1,373,256 t , A ,v I' n rt L , � ,(11 L'- i a li iI 4 ,J' CITY OF WYLIE, TEXAS UTILITY FUND EXPENSES FISCAL YEAR 1987-88 (BUDGET BASIS) Actual Estimate Original 10 Months 2 Months Estimate Budget Ended Ending for Expense Classification Estimate 7-31-88 9-30-88 Year UTILITY ADMINISTRATION Personal Services $52,700 $44,546 $8,954 $53,500 Supplies 6,350 3,727 1,273 5,000 Contractual Services 89,525 7,442 77,558 85,000 Capital Outlay 2,425 301 2,199 2,500 Sub-Total Administration 151,000 56,016 89,984 146,000 WATER OPERATIONS Personal Services 119,975 77,174 12,826 90,000 Supplies 56,600 25,852 9,148 35,000 Electrical Services 34,125 29,743 7,757 37,500 Water Purchases 220,000 163,210 64,142 227,352 Other Contractual Services 52,600 33,922 11,078 45,000 Capital Outlay 36,200 24,849 11,351 36,200 Sub-Total Water Operations 519,500 354,750 116,302 471,052 SEWER OPERATIONS Personal Services 60,200 71,830 11,170 83,000 Supplies 45,075 32,286 7,714 40,000 Contract Sewer Services * 141,500 118,175 92,099 210,274 Other Contractual Services 81,000 70,732 14,268 85,000 Capital Outlay 16,300 12,311 3,989 16,300 Sub-Total Sewer Operations 344,075 305,334 129,240 434,574 UTILITY BILLING Personal Services 98,850 83,994 21,006 105,000 Supplies 34,425 15,681 5,319 21,000 Contractual Services 52,625 39,278 5,722 45,000 Capital Outlay 8,600 1,892 5,608 7,500 Sub-Total Utility Billing 194,500 140,845 37,655 178,500 DEBT SERVICE 190,925 121,083 29,392 150,475 TOTAL EXPENSES $1,400,000 $978,028 $402,573 $1,3j80,601 * Includes $ 121,014 as debt service payment on Contract Revenue Bonds. k /A ;,,, t,1, )". 'J 5 CITY OF WYLIE, TEXAS ASSUMPTIONS USED IN PROJECTING UTILITY FUND REVENUES AND EXPENSES REVENUE: Water Sales- The methodology used in projecting water sales for fiscal year 1988-89 and subsequent years is to multiply the estimated number of water ac- counts times an average monthly bill based on projected water consumption. Starting with an average customer account number of 2,617 in 1987-88 (from City of Wylie "bill frequency analyses") , an annual growth rate of 5% is projec- ted for subsequent years through 1992-93. The average consumption per account in 1987-88 is estimated at 134,033 gallons (350,764,072 gallons total consumption divided by 2,617) . For projection purposes, an average annual consumption of 126,000 gallons per account is used, resulting in the following estimates: 1988-89 1989-90 1990-91 1991-92 1992-93 Average accounts 2,748 2,885 3,029 3,180 3,339 Total billed con- 346,248 363,510 381,654 400,680 420,714 sumption (1,000 gallons) The projected annual consumption per account of 126,000 gallons is equal to an average monthly consumption of 10,500 gallons. At current rates, the monthly water bill for 10,500 gallons is $ .9. If this average monthly bill is multiplied times the projected average number of accounts each year and then multiplied times 12, the following estimates are produced: 1988-89: $ 784,499 1989-90: 823,610 1990-91: 864,719 1991-92: 907,826 1992-93: 953,218 Sewer Service Income- For projection purposes, a revenue dollar amount per 1,000 gallons of water consumption was used. The computed revenue dollar amount, based on 1987-88 billing records, is $ . Multiplying this amount times the projected annual consumption in each of the years starting in 1988-89 produces the following estimates: 1988-89: $ 567,847 1989-90: 596,156 1990-91: 625,913 1991-92: 657,115 1992-93: 689,971 (Continued) 6 EXPENSES: Personal Services- All personal services are projected to increase at the rate of 7.5% per annum for years following 1988-89. Supplies- Annual increase of 7.5% subsequent to 1988-89. Administrative Payment to General Fund- Projected at $ 120,000 per year. Water Purchases- The estimated metered water consumption for each year is divided by .83 to allow for an estimated system loss factor of 17% and to arrive at the estimated volume of water to be purchased from the North Texas Municipal Water District. From this number, the annual minimum purchase volume is subtrac- ted (the annual minimum purchase volume is the previous year's total purchased volume) to determine the volume in excess of the minimum purchase amount. The minimum purchase volume is multiplied times the projected rate per 1,000 gallons charged by the District, and the resulting number is added to the product of the excess volume amount times a rate of 12 cents per 1,000 gallons. As a result, the following estimates were calculated: 1987-88: 351,556,000 gals. @ $ .619 per 1,000 $ 217,613 81,156,000 " @ .12 9,739 $ 227,352 1988-89: 432,712,000 gals. @ $ .619 per 1,000 $ 267,849 1989-90: 432,712,000 gals. @ $ .669 per 1,000 $ 289,484 5,252,000 " @ .12 630 $ 290,114 1990-91: 437,964,000 gals. @ $ .719 per 1,000 $ 314,896 21,860,000 " @ .12 2,623 $ 317,519 1991-92: 459,824,000 gals. @ $ .769 per 1,000 $ 353,605 22,923,000 " @ .12 2,751 $ 356,356 1992-93: 482,747,000 gals. @ $ .769 per 1,000 $ 371,232 24,137,000 " @ .12 2,896 $ 374,128 Payments to NTMWD for Operation of Wastewater Treatment Plant- Annual increase of 7.5% after 1988-89. Other Contractual Services- 7.5% increase per annum for years subsequent to 1988-89. 7 SUGGESTED FINANCIAL MANAGEMENT GUIDELINES FOR UTILITY ENTERPRISE FUND: 1. Annual operating revenue should exceed operating expenses. 2 . Debt Service Coverage- Net income before depreciation should be at least 1.5 times the maximum annual debt service on all outstanding Revenue Bonds. 3. Working capital balance at end of each year equal to at least 45 days of operation. r/r� ,11 o I. I \J i 8 I CITY OF WYLIE, TEXAS UTILITY ENTERPRISE FUND PROJDC'TICN CF REVENUE, EXPENSES & NET INX14E (ASSUMING CURRENT RATES AND 5% ANNUAL GROWTH IN CUSTOMERS) 1984-85 1985-86 1986-87 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 Actual Actual Actual Estimate Estimate Estimate Estimate Estimate Estimate i OPERATING REVENUE: 1 Water Sales $363,352 $539,768 $579,881 $739,605 $784,499 $823,610 $864,719 $907,826 $953,218 Sewer Service 215,876 315,501 401,565 550,666 567,847 596,156 625,913 657,115 689,971 Tap Fees 36,790 74,111 41,498 8,800 13,000 15,000 15,000 15,000 15,000 Other Revenue 53,015 28,993 23,275 65,616 75,000 78,750 82,688 86,822 91,163 ti TOTAL OPERATIIM REVENUE 669,033 958,373 1,046,219 1,364,687 1,440,346 1,513,516 1,588,320 1,666,763 1,749,352 OPERATING EXPENSES: Utility Administration: 6 Personal Services 63,559 N/A N/A 53,500 55,600 59,770 64,253 69,072 74,252 € Supplies 9,434 N/A N/A 5,000 7,050 7,579 8,147 8,758 9,415 Adm. Payment to General Fund 0 N/A N/A 75,000 120,000 120,000 120,000 120,000 120,000 € Other Contractual Services 47,540 N/A N/A 10,000 5,850 6,289 6,760 7,267 7,812 up F Sub-Total Administration 120,533 168,139 167,906 143,500 188,500 193,638 199,160 205,097 211,479 i f Water Operations: Personal Services 55,687 N/A N/A 90,000 115,325 123,974 133,272 143,268 154,013 Supplies 50,760 N/A N/A 35,000 81,525 87,639 94,212 101,278 108,874 Water Purchases from NTNWD N/A N/A N/A 227,352 267,849 290,114 317,519 356,356 374,128 Other Contractual Services 151,016 N/A N/A 82,500 73,301 78,799 84,708 91,062 97,892 f Sub-Total Water Operations 257,463 360,041 419,676 434,852 538,000 580,526 629,712 691,964 734,907 1 Sewer Operations: iPersonal Services 44,393 N/A N/A 83,000 86,750 93,256 100,250 107,769 115,852 1 Supplies 14,053 N/A N/A 40,000 54,050 58,104 62,462 67,146 72,182 Payments to N1M4D: Treatment Plant� Debt Serviceeon Contrac Operationst N/A N/A N/A 74,074 105,797 113,732 122,262 131,431 141,288 121,014 242,028 242,028 242,028 242,028 242,028 Revenue Bonds 1 Other Contractual Services 61,496 N/A N/A 85,000 102,625 110,322 118,596 127,491 137,053 Sub-Total Sewer Operations 119,942 119,106 280,369 403,088 591,250 617,442 645,598 675,865 708,403 i 1 I 1 i i CITY OF WYLIE, TEOAS ( UTILITY ENTERPRISE FUND PROJECTION OF REVENUE, EXPENSES & NET INCOME (ASSUMING CURRENT RATES AND 5% ANNUAL GROWTH IN CUSTOMERS) 1984-85 1985-86 1986-87 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 Actual Actual Actual Estimate Estimate Estimate Estimate Estimate Estimate Utility Billing: Personal Services N/A N/A N/A 105,000 111,825 120,212 129,228 138,920 149,339 Supplies N/A N/A N/A 21,000 31,425 33,782 36,316 39,039 41,967 Contractual Services N/A N/A N/A 45,000 37,750 40,581 43,625 46,897 50,414 Sub-Tota1 Utility Billing N/A 79,594 138,057 171,000 181,000 194,575 209,168 224,856 241,720 Building Services 0 0 0 0 40,000 43,000 46,225 49,692 53,419 Net Contract Bond Payments to N/A N/A N/A 15,186 14,710 13,750 13,250 12,750 12,250 NTMWD ($ 110,000 Series 1972B) N o TOTAL OPERATING EXPENSES 497,938 726,880 1,006,008 1,167,626 1,553,460 1,642,930 1,743,113 1,860,224 1,962,178 OPERATIIG wow 171,095 231,493 40,211 197,061 (113,114) (129,414) (154,794) (193,461) (212,826) PLUS:NON-OPERATING REVENUE (EXPENSES): Depreciatioh (108,099) (91,596) (184,092) (202,501) (222,751) (245,026) (269,529) (296,482) (326,130) Interest IIR..u1 23,398 6,456 9,274 7,500 10,000 12,500 12,500 12,500 12,500 Bond Interest & Bank Charges (56,029) (56,687) (66,776) (66,447) (130,815) (114,582) (110,832) (106,929) (103,149) Other Non-Operating Revenue 0 (12,896) (3,095) 0 0 0 0 0 0 (Expenses) TOTAL NON-OPERATING REVENUE (140,730) (154,723) (244,689) (261,448) (343,566) (347,108) (367,861) (390,911) (416,779) (EXPENSES) NET INCOME $30,365 $76,770 ($204,478) ($64,387) ($456,680) ($476,523) ($522,655) ($584,372) ($629,605) / . CITY OF WYLIE, TEXAS UTILITY ENTERPRISE FUND ` PROJN TICK OF COVERAGE CN CURRENT DEBT AND INCOME REQUIRED FOR DEBT SERVICE PAYMENTS (ASSUMING CURRENT RATES AND 5% ANNUAL GROWTH IN CUSTOMERS) 1984-85 1985-86 1986-87 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 Actual Actual Actual Estimate Estimate Estimate Estimate Estimate Estimate 9 NET INCOME BEFORE DEPRECIATION $194,493 $237,949 $49,485 $204,561 ($103,114) ($116,914) (S142,294) ($180,961) ($200,326) AND BOND INTEREST Maximum Annual Debt Service 86,220 86,220 86,220 86,220 86,220 86,220 86,220 86,220 86,220 Requirement on Revenue Bonds Coverage of Maximum Annual 2.26 2.76 0.57 2.37 -1.20 -1.36 -1.65 -2.10 -2.32 1 Debt Service Additional Income Required for 0 232,444 246,244 271,624 310,291 329,656 1.5 Coverage of Current Debt N PLUS: N City of Wylie Certificates, 66,239 66,461 64,931 65,645 63,860 1988 Issue ($ 605,000) NT44D $ 1,350,000 installment 114,750 148,263 150,075 151,463 ( / Sale Bonds (Proposed) * / ADDITIONAL INCOME REQUIRED TO $298,683 $427,455 $484,818 $526,011 $544,979 PROVIDE 1.5 COVERAGE OF MAXIMUM ANNUAL DEBT SERVICE CN CURRENT REVENUE BCtIDS AND MEET DEBT SERVICE REQUIRE- MENTS ON OTHER DEBT ISSUES * Assumes sale date of 4-1-89 and 8.5% average effective interest rate. t ' 4, - L, CTIY CF W121, MOS UTILITZENTERERISE FIND ANALYSIS CF WBUN CAPImL (ASSIMIN O RFC AND A 5% FERAMINIGUCE Fes) 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 Ling capital at start of year $172,531 $232,871 $218,469 $244,288 $261,279 $276,813 Sau c 3 cf waking capital: C eratirg ramie 1,364,687 1,440,346 1,513,516 1,588,320 1,666,763 1,749,352 I�ilttw� m u Te 7,500 10,000 12,500 12,500 12,500 12,500 akal seam; of.working capital 1,372,187 1,450,346 1,526,016 1,600,820 1,679,263 1,761,852 Lies cf ding capital: Cperating Expenses 1,167,626 1,553,460 1,642,930 1,743,113 1,860,224 1,962,178 liacirticrl of reveriE bard debt 20,000 25,000 25,000 25,000 25,000 30,000 Interest expanse (reN i bards) 61,721 60,326 58,606 56,886 55,141 53,396 C`.apital outlay Lulu operations 62,500 67,000 73,700 81,070 89,177 98,095 City of Wylie C1acttificates, 1988 Isgp 0 66,239 66,461 64,931 65,645 63,860 N1MPD Instal]ntii . Sale &xris * 0 0 114,750 148,263 150,075 151,463 Zt.kal uses cf waking capital 1,311,847 1,772,025 1,981,447 2,119,263 2,245,262 2,358,992 Net increase OKI- ) in working capital 60,340 (321,679) (455,431) (518,443) (565,999) (597,140) (irking coital at az3 of year $232,871 ($88,808) ($236,962) ($274,155) ($304,720) ($320,327) 45 days of working capital = $161,735 $218,469 $244,288 $261,279 $276,813 $290,835 rays cf waking capital at end cf war- 65 0 0 0 0 0 Additirn3l irzxne required fcr 45 days 0 $307,277 $481,250 $535,434 $581,533 $611,162 of waking capital * Assures sale date of 4-1-89 arzi 8.5% average effective iritcrct Late. 12 (T1Y CF WM TR, TEXAS ATIOQLFICN CF FU 1VCE, MENSES & CFERATIM WYE '10 ATER & SIER Fi1J.TIC1E FI AL 1987-88 'II J 1992-93 (AS'SIMM QR NT F PND A 5% MNU L Cl I IN CIEIGFI) TIER 1987-88 1988-89 1989-90 1990-91 1991.92 1992-93 Operating Fein: Water Sales $739,605 $784,499 $823,610 $864,719 $907,826 $953,218 VatPr Tap Fees 7,100 10,400 12,000 12,000 12,000 12,000 Cher Fevenae 32,808 37,500 39,375 41,344 43,411 45,582 Slab-'Ibtal Cperating FmE 779,513 832,399 874,985 918,063 963,237 1,010,800 Cceratirag Ekcen9Es: Personal Services 169,924 201,818 216,954 233,299 250,718 269,521 SlTaies 48,063 101,115 108,698 116,851 125,614 135,036 Water Pun:bases 227,352 267,849 290,114 317,519 356,356 374,128 Prim Payment to a eral Fund 37,500 60,000 60,000 60,000 60,000 60,000 Ot1tr E pares 110,126 95,394 102,548 110,239 118,507 127,396 Stab-Zbtal CFerating5pEn9ES 592,965 726,175 778,314 837,834 911,195 966,080 Operating Itruie fir) $186,548 $106,224 $96,671 $80,230 $52,042 $44,719 SIEWM C rating 1 ': Saner Service $550,666 $567,847 $596,156 $625,913 $657,115 $689,971 Sam Tap Furs 1,700 2,600 3,000 3,000 3,000 3,000 Comer Ftvene 32,808 37,500 39,375 41,344 43,411 45,582 SUb-'Ibtal Cperatirg Revere 585,174 607,947 638,531 670,257 703,526 738,553 C E pa>se;: Personal Services 161,576 167,683 180,259 193,778 208,311 223,935 Supplies 52,937 72,935 78,406 84,286 90,607 97,402 kin. Payment to CEraeral Eland 37,500 60,000 60,000 60,000 60,000 60,000 Payments to NI!'W): Th±ttneit. Plant CFeratias 74,074 105,797 113,732 122,262 131,431 141,288 Oaatract 12cnis (1972) 15,186 14,710 13,750 13,250 12,750 12,250 Ontrxt B n's (1987) 121,014 242,028 242,028 242,028 242,028 242,028 Other Dcpenses 112,374 124,133 133,443 143,451 154,210 165,775 Sito-Ibtaal CFerating Expenses 574,661 787,285 821,617 859,055 899,337 942,679 Cperating Iuure (Saner) $10,513 ($179,338) ($183,086) ($1:4,798) ($195,811) ($204,126) (1) Ut-i l i ty Etillirg expanses allocated 1/2 t o eater and 1/2 to seer. (2) Utility Acininistraticn scarier allocated 55% to pater and 45% to saaar based cn data dare of total Ferscnal services expense, emcapt for adbinistrative Fayrnalt to the Cameral F1nd uhiria vas distributed equally between bate' and 9FAUC. 13 CITY OF WYLIE, TEXAS ADDITIONAL INCOME REQUIREMITS (ASSUMING 5% ANNUAL INCREASE IN CUSTOMERS) 1988-89 1989-90 1990-91 1991-92 1992-93 1. For 1.5 Coverage on $232,444 $246,244 $271,624 $310,291 $329,656 Current Revenue Bonds 2. For 1.5 Coverage on 298,683 312,705 336,555 375,936 393,516 Current Revenue Bonds and Debt Service on 1988 Certificates 3. For 1.5 Coverage on 298,683 427,455 484,818 526,011 544,979 Current Revenue Bonds, Debt Service on 1988 C.O. 's and Proposed Installment Sale Bonds ($ 1,350,000) 4. For 45 Days of Working 307,277 481,250 535,434 581,533 611,162 Capital (including Installment Sale Bonds) 5. For 45 Days of Working 307,277 366,500 387,171 431,458 459,699 Capital (without Installment Sale Bonds) 6. For Zero Balance 88,808 455,431 518,443 565,999 597,140 Working Capital (with Installment Sale Bonds) 7. For Zero Balance 88,808 340,681 370,180 415,924 445,677 Working Capital (without Installment Sale Bonds) 14 OPTIONS FOR PRODUCING ADDITIONAL UTILITY FUND INCOME: 1. Increase current water and/or sewer rates across-the-board by a certain percentage, with the increase applying to both minimum and volume charges. 2. Increase the volume charge for water and/or sewer service, leaving the minimum charge unchanged. 3. Increase the monthly minimum charge for water and/or sewer service. 4. Charge a higher volume rate for monthly water consumption above a certain level during summer months only. 5. Charge a higher volume rate for monthly water consumption above a certain level throughout the year. 6. Establish a multi-tiered volume structure providing for rate differentials between low, moderate and high consumption levels. 7. Provide for automatic "pass through" charges to cover annual cost increases attributable to water purchases, wastewater treatment services and/or other cost increases. 8. Levy taxes to pay debt service on Installment Sale Bonds, thereby reducing working capital requirements in the Utility Enterprise Fund. i 9. Combination of above. 1 y 1 1 �� ,f vs*1 15 CITY OF WYLIE, TEXAS UTILITY ENTERPRISE FUND ADDITIONAL REVENUE RESULTING FROM ALTERNATIVE RATE INCREASES (ACROSS-THE-BOARD PERCENTAGE INCREASES APPLIED TO MINIMUM & VOLUME CHARGES) (ASSUMING 5% ANNUAL INCREASE IN CUSTOMERS) Per Cent Increase 1988-89 1989-90 1990-91 1991-92 1992-93 WATER SALES 5% $39,225 $41,181 $43,236 $45,391 $47,661 10% 78,450 82,361 86,472 90,783 95,322 15% 117,675 123,542 129,708 136,174 142,983 20% 156,900 164,722 172,944 181,565 190,644 25% 196,125 205,903 216,180 226,957 238,305 30% 235,350 247,083 259,416 272,348 285,965 35% 274,575 288,264 302,652 317,739 333,626 40% 313,800 329,444 345,888 363,130 381,287 45% 353,025 370,625 389,124 408,522 428,948 50% 392,250 411,805 432,360 453,913 476,609 SEWER SERVICE 5% $28,392 $29,808 $31,296 $32,856 $34,499 10% 56,785 59,616 62,591 65,712 68,997 15% 85,177 89,423 93,887 98,567 103,496 20% 113,569 119,231 125,183 131,423 137,994 25% 141,962 149,039 156,478 164,279 172,493 30% 170,354 178,847 187,774 197,135 206,991 35% 198,746 208,655 219,070 229,990 241,490 40% 227,139 238,462 250,365 262,846 275,988 45% 255,531 268,270 281,661 295,702 310,487 50% 283,924 298,078 312,957 328,558 344,986 16 CITY OF WYLIE, TEXAS ANNUAL INCREASE TO RESIDENTIAL UTILITY CUSTOMER USING AVERAGE OF 10,000 GALLONS OF WATER PER MONTH (VARIOUS % RATE INCREASES) Water Sewer Total Current annual cost $274 .56 $213 . 60 $488 .16 % Increase $ Increase $ Increase $ Increase 1% $2. 75 $2 .14 $4. 88 2% 5 .49 4.27 9 . 76 3% 8. 24 6.41 14.64 4% 10.98 8 .54 19.53 5% 13 .73 10.68 24.41 6% 16. 47 12 . 82 29.29 7% 19. 22 14. 95 34.17 8% 21. 96 17.09 39.05 9% 24. 71 19 . 22 43. 93 10% 27 .46 21 . 36 48 .82 11% 30 . 20 23 .50 53 .70 12% 32. 95 25 .63 58.58 13% 35 .69 27.77 63.46 14% 38 .44 29.90 68.34 15% 41.18 32 .04 73.22 16% 43.93 34 . 18 78 .11 17% 46 .68 36 .31 82.99 18% 49 .42 38 .45 87.87 19% 52.17 40 .58 92 .75 20% 54. 91 42. 72 97. 63 21% 57. 66 44 . 86 102.51 22% 60.40 46 .99 107.40 23% 63 .15 49. 13 112 .28 24% 65 . 89 51 .26 117.16 25% 68.64 53 .40 122.04 26% 71.39 55.54 126 . 92 27% 74.13 57.67 131.80 28% 76. 88 59 . 81 136 .68 29% 79. 62 61. 94 141.57 30% 82. 37 64.08 146 .45 31% 85.11 66. 22 151. 33 32% 87 . 86 68. 35 156. 21 33% 90. 60 70.49 161.09 34% 93.35 72. 62 165.97 35% 96 .10 74. 76 170 . 86 36% 98 . 84 76 .90 175.74 37% 101.59 79.03 180. 62 38% 104.33 81.17 185.50 39% 107.08 83.30 190 .38 40% 109.82 85. 44 195.26 17 CITY OF WYLIE, TEXAS EFFECT OF VARIOUS % INCREASES ON MONTHLY WATER BILLS (ALL CUSTOMERS) 2,000 4,000 8,000 10,000 15,000 Gallons Gallons Gallons Gallons Gallons Current Rates $8.32 $11.96 $19.24 $22.88 $31.98 % Increase Amount of monthly bill with increase: 50% $12.48 $17.94 $28.86 $34.32 $47.97 45% 12.06 17.34 27.90 33.18 46.37 40% 11.65 16.74 26.94 32.03 44.77 35% 11.23 16.15 25.97 30.89 43.17 30% 10.82 15.55 25.01 29.74 41.57 25% 10.40 14.95 24.05 28.60 39.98 20% 9.98 14.35 23.09 27.46 38.38 15% 9.57 13.75 22.13 26.31 36.78 10% 9.15 13.16 21.16 25.17 35.18 5% 8.74 12.56 20.20 24.02 33.58 0% 8.32 11.96 19.24 22.88 31.98 20,000 25,000 30,000 40,000 50,000 Gallons Gallons Gallons Gallons Gallons Current Rates $41.08 $50.18 $59.28 $77.48 $95.68 % Increase Amount of monthly bill with increase: 50% $61.62 $75.27 $88.92 $116.22 $143.52 45% 59.57 72.76 85.96 112.35 138.74 40% 57.51 70.25 82.99 108.47 133.95 35% 55.46 67.74 80.03 104.60 129.17 30% 53.40 65.23 77.06 100.72 124.38 25% 51.35 62.73 74.10 96.85 119.60 20% 49.30 60.22 71.14 92.98 114.82 15% 47.24 57.71 68.17 89.10 110.03 10% 45.19 55.20 65.21 85.23 105.25 5% 43.13 52.69 62.24 81.35 100.46 0% 41.08 50.18 59.28 77.48 95.68 18 CITY OF WYLIE, TEXAS EFFECT OF VARIOUS % INCREASES ON MONTHLY SEWER BILLS (RESIDENTIAL CUSTOMERS) 2,000 4,000 6,000 8,000 10,000 Gallons Gallons Gallons Gallons Gallons Current Rates $8.20 $10.60 $13.00 $15.40 $17.80 % Increase Amount of monthly bill with increase: 50% $12.30 $15.90 $19.50 $23.10 $26.70 45% 11.89 15.37 18.85 22.33 25.81 40% 11.48 14.84 18.20 21.56 24.92 35% 11.07 14.31 17.55 20.79 24.03 30% 10.66 13.78 16.90 20.02 23.14 25% 10.25 13.25 16.25 19.25 22.25 20% 9.84 12.72 15.60 18.48 21.36 15% 9.43 12.19 14.95 17.71 20.47 10% 9.02 11.66 14.30 16.94 19.58 5% 8.61 11.13 13.65 16.17 18.69 0% 8.20 10.60 13.00 15.40 17.80 12,000 15,000 Gallons Gallons Current Rates $20.20 $23.80 % Increase Amount of monthly bill with increase: 50% $30.30 $35.70 45% 29.29 34.51 40% 28.28 33.32 35% 27.27 32.13 30% 26.26 30.94 25% 25.25 29.75 20% 24.24 28.56 15% 23.23 27.37 10% 22.22 26.18 5% 21.21 24.99 0% 20.20 23.80 (Current Maximum) 19 CITY OF WYLIE, TEXAS EFFECT OF VARIOUS % INCREASES ON MONTHLY SEWER BILLS (NON-RESIDENTIAL CUSTOMERS) 2,000 4,000 8,000 10,000 15,000 Gallons Gallons Gallons Gallons Gallons Current Rates $8.20 $10.60 $15.40 $17.80 $23.80 % Increase Amount of monthly bill with increase: 50% $12.30 $15.90 $23.10 $26.70 $35.70 45% 11.89 15.37 22.33 25.81 34.51 40% 11.48 14.84 21.56 24.92 33.32 35% 11.07 14.31 20.79 24.03 32.13 30% 10.66 13.78 20.02 23.14 30.94 25% 10.25 13.25 19.25 22.25 29.75 20% 9.84 12.72 18.48 21.36 28.56 15% 9.43 12.19 17.71 20.47 27.37 10% 9.02 11.66 16.94 19.58 26.18 5% 8.61 11.13 16.17 18.69 24.99 0% 8.20 10.60 15.40 17.80 23.80 20,000 30,000 50,000 75,000 100,000 Gallons Gallons Gallons Gallons Gallons Current Rates $29.80 $41.80 $65.80 $95.80 $125.80 % Increase Amount of monthly bill with increase: 50% $44.70 $62.70 $98.70 $143.70 $188.70 45% 43.21 60.61 95.41 138.91 182.41 40% 41.72 58.52 92.12 134.12 176.12 35% 40.23 56.43 88.83 129.33 169.83 30% 38.74 54.34 85.54 124.54 163.54 25% 37.25 52.25 82.25 119.75 157.25 20% 35.76 50.16 78.96 114.96 150.96 15% 34.27 48.07 75.67 110.17 144.67 10% 32.78 45.98 72.38 105.38 138.38 5% 31.29 43.89 69.09 100.59 132.09 0% 29.80 41.80 65.80 95.80 125.80 20 CITY OF WYLIE, TEXAS CALCUTATICN OF MINIMUM CHAIGE REWIRED TO RECOVER FIXED COSTS FISCAL YEAR 1988-89 WATER Total Allocated Fixed Variable Cost To Water Cost Cost Operating Expenses: Administration $188,500 $97,675 $64,128 $33,547 Utility Billing 181,000 90,500 73,206 17,294 Water Operations: Personal Services 115,325 115,325 115,325 - Supplies 81,525 81,525 40,763 40,763 Water Purchases 267,849 267,849 - 267,849 Other Expenses 73,301 73,301 36,651 36,651 Capital Outlay 67,000 32,000 32,000 - Debt Service 151,565 113,674 113,674 - Less Income: Water Tap Fees (10,400) (10,400) (5,200) (5,200) Other Operating Revenue (75,000) (37,500) (18,750) (18,750) Interest on Investments (10,000) (5,700) (2,850) (2,850) Net Cost To Be Recovered With $1,030,665 $818,249 $448,946 $369,303 Water Service Charges Net Cost/Average i of Water $297.76 $163.37 $134.39 Accounts (2,748) Current Minimum Annual Charge $78.00 for Water Service Monthly Minimum Water Charge $13.61 Required to Recover Fixed Costs SEWER Total Allocated Fixed Variable Cost To Sewer Cost Cost Operating Expenses: Administration $188,500 $90,825 $65,870 $24,955 Utility Billing 181,000 90,500 73,206 17,294 Sewer Operations:Personal Services 86,750 86,750 86,750 Supplies 54,050 54,050 27,025 27,025 Payments to N1UWD 362,535 362,535 309,636 52,899 Other EXpenses 102,625 102,625 51,313 51,313 Capital Outlay 67,000 35,000 35,000 - Debt Service 151,565 37,891 37,891 - Less Income: Sewer Tap Fees (2,600) (2,600) (1,300) (1,300) Other Operating Revenue (75,000) (37,500) (18,750) (18,750) Interest on Investments (10,000) (4,300) (2,150) (2,150) Net Cost To Be Recovered With $1,106,425 $815,776 $664,491 $151,286 Sewer Service Charges Net Cost/Average # of Sewer $296.86 $241.81 $55.05 • Accounts (2,748) Current Minimum Annual Charge $84.00 for Sewer Service Monthly Minimum Sewer Charge $20.15 Required to Recover Fixed Costs 21 CITY OF WYLIE, TEXAS ESTIMATED ADDITIONAL INCOME RESULTING FROM INCREASE IN MINIMUM MONTHLY CHARGES (ASSUMING 5% PER ANNUM INCREASE IN CUSTOMERS) Current Monthly Monthly Minimum Charge Minimum Charge To Recover Fixed Costs $6.50 Water $13.61 7.00 Sewer 20.15 1988-89 1989-90 1990-91 1991-92 1992-93 Avg. No. of Accounts 2,748 2,885 3,029 3,180 3,339 Fixed Cost Additional Annual Income: Recovery (%) 1988-89 1989-90 1990-91 1991-92 1992-93 WATER 100% 234,459 246,148 258,434 271,318 284,883 95% 212,019 222,589 233,699 245,350 257,617 90% 189,579 199,030 208,965 219,382 230,351 85% 167,139 175,471 184,230 193,414 203,085 80% 144,699 151,913 159,495 167,446 175,818 75% 122,259 128,354 134,760 141,478 148,552 70% 99,818 104,795 110,025 115,510 121,286 65% 77,378 81,236 85,291 89,542 94,020 60% 54,938 57,677 60,556 63,575 66,753 55% 32,498 34,118 35,821 37,607 39,487 50% 10,058 10,559 11,086 11,639 12,221 SEWER 100% 433,634 455,253 477,976 501,804 526,894 95% 400,411 420,373 441,356 463,358 486,526 90% 367,188 385,494 404,735 424,912 446,157 85% 333,964 350,614 368,114 386,465 405,789 80% 300,741 315,734 331,494 348,019 365,420 75% 267,518 280,855 294,873 309,573 325,052 70% 234,294 245,975 258,253 271,127 284,683 65% 201,071 211,095 221,632 232,681 244,315 60% 167,848 176,216 185,011 194,234 203,946 55% 134,625 141,336 148,391 155,788 163,578 50% 101,401 106,456 111,770 117,342 123,209 45% 68,178 71,577 75,149 78,896 82,841 40% 34,955 36,697 38,529 40,450 42,472 35% 1,731 1,818 1,908 2,003 2,104 22 CITY OF WYLIE, TEXAS ALTERNATIVE WATER AND SEWER RATE SCHEDULES Description of Rate Adjustment Resulting Rate Schedule 1. Increase water and sewer rates Water: Minimum (first 1,000 gals.) $7.15 .15 by 10% across-the-board. Over 1,000 gals. (per 1,000) Sewer: Minimum (first 1,000 gals.) 7.70 Over 1,000 gals. (per 1,000) 1.32 2. Increase water and sewer rates Water: Minimum (first 1,000 gals.) $7.80 by 20% across-the-board. Over 1,000 gals. (per 1,000) 2.18 Sewer: Minimum (first 1,000 gals.) 8.40 Over 1,000 gals. (per 1,000) 1.44 3. Increase water and sewer rates Water: Minimum (first 1,000 gals.) $8.45 by 30% across-the-board. Over 1,000 gals. (per 1,000) Sewer: Minimum (first 1,000 gals.) 9.10 Over 1,000 gals. (per 1,000) 1.56 4. Increase water and sewer rates Water: Minimum (first 1,000 gals.) $9.10 by 40% across-the-board. Over 1,000 gals. (per 1,000) 2.55 Sewer: Minimum (first 1,000 gals.) 9.80 Over 1,000 gals. (per 1,000) 1.68 5. Increase water and sewer rates Water: Minimum (first 1,000 gals.) $9.75 by 50% across-the-board. Over 1,000 gals. (per 1,000) Sewer: Minimum (first 1,000 gals.) 10.50 Over 1,000 gals. (per 1,000) 1.80 6. Increase the volume charge for Water: Minimum (first 1,000 gals.) $6.50 water and sewer service by 10%; Over 1,000 gals. (per 1,000) 2.00 leave minimum charges unchanged. Sewer: Minimum (first 1,000 gals.) 7.00 Over 1,000 gals. (per 1,000) 1.32 7. Increase the volume charge for Water: Minimum (first 1,000 gals.) $6.50 water and sewer service by 20%; Over 1,000 gals. (per 1,000) leave minimum charges unchanged. Sewer: Minimum (first 1,000 gals.) 7.00 Over 1,000 gals. (per 1,000) 1.44 8. Increase the monthly minimum Water: Minimum (first 1,000 gals.) $8.87 charge for water and sewer Over 1,000 gals. (per 1,000) service to recover 60% of fixed Sewer: Minimum (first 1,000 gals.) 12.09 2.09 costs; leave volume charges Over 1,000 gals. (per 1,000) unchanged. 9. Increase the monthly minimum Water: Minimum (first 1,000 gals.) $10.21 .21 charge for water and sewer Over 1,000 gals. (per 1,000) service to recover 75% of fixed Sewer: Minimum (first 1,000 gals.) 15.11 5.11 costs; increase water and sewer Over 1,000 gals. (per 1,000) volume charges by 20%. (Continued) 23 CITY OF WYLIE, TEXAS ALTERNATIVE WATER AND SEWER RATE SCHEDULES Description of Rate Adjustment Resulting Rate Schedule 10. Add 20% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 water consumption above 20,000 1,001 to 20,000 gals. (per 1,000) 1.82 gallons during summer months Over 20,000 gals. (per 1,000) 2.18 only. 11. Add 40% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 water consumption above 20,000 1,001 to 20,000 gals. (per 1,000) 1.82 gallons during summer months Over 20,000 gals. (per 1,000) 2.55 only. 12. Add 20% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 monthly water consumption above 1,001 to 20,000 gals. (per 1,000) 1.82 20,000 gallons throughout the Over 20,000 gals. (per 1,000) 2.18 year. 13. Add 40% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 monthly water consumption above 1,001 to 20,000 gals. (per 1,000) 1.82 20,000 gallons throughout the Over 20,000 gals. (per 1,000) 2.55 year. 14. Add 20% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 monthly water consumption above 1,001 to 10,000 gals. (per 1,000) 1.82 10,000 gallons throughout the Over 10,000 gals. (per 1,000) 2.18 year. 15. Add 40% to volume rate for Water: Minimum (first 1,000 gals.) 6.50 monthly water consumption above 1,001 to 10,000 gals. (per 1,000) 1.82 10,000 gallons throughout the Over 10,000 gals. (per 1,000) 2.55 year. 16. Three-tier rate structure with Water: Minimum (first 1,000 gals.) 6.50 20% between tiers. 1,001 to 10,000 gals. (per 1,000) 1.82 10,001 to 30,000 gals. (per 1,000) 2.18 Over 30,000 gals. (per 1,000) 2.62 17. Three-tier rate structure with Water: Minimum (first 1,000 gals.) 6.50 30% between tiers. 1,001 to 10,000 gals. (per 1,000) 1.82 10,001 to 30,000 gals. (per 1,000) 2.37 Over 30,000 gals. (per 1,000) 3.08 18. Three-tier rate structure; Water: Minimum (first 1,000 gals.) 6.50 increase water volume rate by 1,001 to 10,000 gals. (per 1,000) 2.18 20%, with 30% between tiers. 10,001 to 30,000 gals. (per 1,000) 2.83 Over 30,000 gals. (per 1,000) 3.68 24 CITY OF WYLIE, TEXAS ESTIMATED ADDITIONAL INCOME FROM ALTERNATIVE RATE SCHEDULE OPTIONS (ASSUMING 5% ANNUAL INCREASE IN CUSTOMERS) Rate Schedule Number 1988-89 1989-90 1990-91 1991-92 1992-93 1 Water $78,450 $82,361 $86,472 $90,783 $95,322 Sewer 56,785 59,616 62,591 65,712 68,977 Total 135,235 141,977 149,063 156,495 164,299 2 Water 156,900 164,722 172,944 181,565 190,644 Sewer 113,569 119,231 125,183 131,423 137,994 Total 270,469 283,953 298,127 312,988 328,638 3 Water 235,350 247,083 259,416 272,348 285,965 Sewer 170,354 178,847 187,774 197,135 206,991 Total 405,704 425,930 447,190 469,483 492,956 4 Water 313,800 329,444 345,888 363,130 381,287 Sewer 227,139 238,462 250,365 262,846 275,988 Total 540,939 567,906 596,253 625,976 657,275 5 Water 392,250 411,805 432,360 453,913 476,609 Sewer 283,924 298,078 312,957 328,558 344,986 Total 676,174 709,883 745,317 782,471 821,595 6 Water 56,389 59,200 62,155 65,254 68,516 Sewer 37,593 39,467 41,437 43,502 45,678 Total 93,982 98,667 103,592 108,756 114,194 7 Water 112,778 118,400 124,310 130,507 137,033 Sewer 75,185 78,934 82,873 87,005 91,355 Total 187,963 197,334 207,184 217,512 228,388 (Continued) 25 CITY OF WYLIE, TEXAS ESTIMATED ADDITIONAL INCOME FROM ALTERNATIVE RATE SCHEDULE OPTIONS (ASSUMING 5% ANNUAL INCREASE IN CUSTOMERS) Rate SNumbee Number 1988-89 1989-90 1990-91 1991-92 1992-93 8 Water 54,938 57,677 60,556 63,575 66,753 Sewer 167,848 176,216 185,011 194,234 203,946 Total 222,786 233,893 245,567 257,809 270,699 9 Water 235,119 246,841 259,161 272,081 285,685 Sewer 342,621 359,702 377,656 396,482 416,307 Total 577,740 606,542 636,817 668,563 701,991 10 Water 20,174 21,183 22,242 23,354 24,522 11 Water 40,348 42,365 44,484 46,708 49,043 12 Water 39,341 41,308 43,373 45,542 47,819 13 Water 78,682 82,616 86,747 91,084 95,638 14 Water 55,082 57,836 60,728 63,764 66,953 15 Water 110,164 115,672 121,456 127,529 133,905 16 Water 97,021 101,872 106,966 112,314 117,930 17 Water 151,828 159,419 167,390 175,760 184,548 18 Water 295,683 310,467 325,991 342,290 359,405 26 CITY OF WYLIE, TEXAS EFFECT OF ALTERNATIVE RATE CONSUMPTION SCHEDULES ON NUAL CHARGES ES)FOR WATER AND SEWER SERVICE (VARIOUS Rate Increase in Annual Charge at Following Monthly Consumption Levels (Gallons) : Schedule Number 2,000 4,000 10,000 12,500 20,000 30,000 40,000 50,000 100,000 WATER48.84 $70.44 $92.04 1 9.9 $14.28 $27.24 $32.64 65.28 $97.68 140.88 184.08 $227.28 $443.28 219.9228.56 54.48 3 39.96 43.20 82.80 99.36 148.80 214.80 132.00 197.64 285.24 0.80 346.80 676.80 4 39.96 57.48 110.04 372.84 460.44 898.44 64.64 46.48 55.68 .88 574.08 08 5 49.92 71.76 137.28 124.84 241.04 362.64 484.24 105.84 112103.84 6 2.16 6.48 19.44 .68 7 4.32 12.96 38.88 49.68 82.08 20.04 20.04 125.28 20.04 120.04.48 220.04 420.04 8 20.04 20.04 20.04 .20 472.20 9 48.84 57.48 83.40 94_2p0 126.60- p 114.40.80 228.80.00 243.20 115.20 - 11 * -0- -0- -0- -0- 10 * -0- -0- -0- -0- 29.20 58.40 87.60 233.60 12 -0- -0- -0- 43.20 86.40 129.60 345.60 -0- -0- -0- 87.60 175.20 262.80 700.80 ...' 14 -0- -0- -0- 10.80 43.20 86.40 129.60 172.80 388.80 15 -0- -0- -0- 21.60 86.40 172.80 259.20 345.60 777.60 16 -0- -0- -0- 10.80 43.20 86.40 182.40 278.40 758.40 17 -0- -0- -0- 16.56 66.00 132.00 283.20 434.40 1,190.40 18 4.32 12.96 38.88 69.24 160.08 281.28 504.48 727.68 1,843.68 2,000 4,000 8,000 10,000 20,000 30,000 40,000 50,000 100,000 SEWER + 35.76 $50.16 $64.56 § 1 9.68 $12.72 $18.48 $21.36 42.72 $71.52 100.32 129.12 157.92 $150.96 301.92 2 19.68 25.44 36.96 3 29.36 50.88 73.92 64.08 107.28 150.48 193.68 236.88 452.88 4 39.36 50.88 73.92 85.44 143.04 200.64 258.24 315.84 603.84 5 49.20 63.60 92.40 106.80 178.80 250.80 322.80 394.80 754.80 6 1.44 4.32 10.08 12.96 27.36 41.76 56.16 70.56 142.56 7 2.88 8.64 20.16 25.92 54.72 83.52 112.32 141.12 285.12 8 61.08 61.08 61.08 61.08 61.08 61.08 61.08 61.08 61.08 1 9 100.20 105.96 117.48 123.24 152.04 180.84 209.64 238.44 382.44 * Sumner rates only, increased charges based on 4 months. + Current maximum annual charge of $ 285.60 (20,000 gals.) for residential sewer customers.