Loading...
07-079 - OORDINANCE NO. 07-079 AN ORDINANCE OF THE TOWN OF PROSPER, TEXAS ADOPTING A BUDGET AND APPROPRIATING RESOURCES FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2007 AND ENDING SEPTEMBER 30, 2008, IN ACCORDANCE WITH EXISTING STATUTORY REQUIREMENTS; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE OF THIS ORDINANCE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. WHEREAS, pursuant to the laws of the State of Texas, the Town Manager of the Town of Prosper has submitted to the Mayor and Town Council a proposed budget of the revenues and expenditures/expenses for conducting the affairs of Prosper and providing a complete financial plan for Fiscal Year 2007/ 2008: and has fled the same with the Town Secretary (the "budget"): and WHEREAS, a public hearing was held by the Town Council on said budget on August 28, 2007 at which time said budget was fully considered, and interested taxpayers were given the opportunity to be heard by the Town Council; and WHEREAS, the Town Council has studied the budget and listened to the comments of the taxpayers at the public hearing and has investigated and determined that adoption of the budget is in the best interest of the Town; and WHEREAS, the Town Council finds that all legal notices, hearings, procedures and publishing requirements for the adoption of the budget have been performed or completed in the manner and form set forth by law. Now, Therefore: BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, COLLIN COUNTY, TEXAS SECTION 1: Findings Incorporated. The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2: Adoption of Budget. We the Mayor and Town Council for the Town of Prosper do hereby approve, ratify, and adopt for fiscal year beginning October 1, 2007 and ending September 30, 2008 the Budget as filed with the Town Secretary. SECTION 3: Annropriation of Funds. The sums below are hereby appropriated from the respective funds for the payment of expenditures on behalf of Prosper as established in the approved budget: General Fund $ 5,357,419 Water & Sewer Fund $ 3,851,914 Interest & Sinking Fund $ 1,866,948 Page 1 of 2 SECTION 4: Authority of Town Manager. Specific authority is hereby given to the Town Manager to transfer appropriations budgeted from one account classification or activity to another within any individual department or activity; and, to transfer appropriations from designated appropriations to any individual department or activity. SECTION 5: SayingL/ Repealing Klause. All provisions of any ordinance in conflict with this Ordinance are hereby repealed; but such repeal shall not abate any pending prosecution for violation of the repealed Ordinance, nor shall the repeal prevent prosecution from being commenced for any violation if occurring prior to the repeal of the Ordinance. Any remaining portions of conflicting ordinances shall remain in full force and effect. SECTION 5: Severability. Should any section, subsection, sentence, clause or phrase of this Ordinance be declared unconstitutional or invalid by a court of competent jurisdiction, it is expressly provided that any and all remaining portions of this Ordinance shall remain in full force and effect. Prosper hereby declares that it would have passed this Ordinance, and each section, subsection, sentence, clause, or phrase thereof irrespective of the fact that any one or more sections, subsections, sentences, clauses, or phrases be declared unconstitutional or invalid. SECTION 7: Effective Date. This Ordinance shall become effective from and after its adoption and publication as required by law. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS ON THIS 18"' DAY OF SEPTEMBER, 2007 AT A MEETING WHICH WAS HELD IN STRICT ACCORDANCE WITH THE TEXAS OPEN MEETING ACT.. ATTEST TO: WATT[-1EW D. DENTON, TRMC Town Secretary Date of Publication A LES NISWANGER, Mayor Dallas Morning News — Collin County Edition Page 2 of 2 Q F P„q/� 0® L J p dW o � 0 dW O i 0 6 p 4 ow6p 01y+�y rp ��4RP OY�r� N�. 11#01110110 AS �� FY 2007-2008 Budget The Town of Prosper ADOPTED A TAX RATE THAT WILL RAISE MORE TAXES FOR MAINTENANCE AND OPERATIONS THAN LAST YEARS TAX RATE. f�l THE TAX RATE WILL RAISE TAXES FOR MAINTENANCE AND OPERATIONS ON A $100,000 HOME BY APPROXIMATELY $90.53, LN :D w s N O F ADOPTED BUDGET FY 2007 - 2008 Adopted September 18, 2007 October 1, 2007 - September 30, 2008 11?046. Rev 08I1sW Z3 W N SP ER ADOPTED BUDGET FY 2007 - 2008 Mike Land, Town Manager Pres er Town Council Members Charles Niswanger, Mayor Dave Turley, Place 1 Council Member Kenneth Dugger, Place 2 Council Member Kevin Drown, Place 3 Council Member Mike Wadsworth, Place 4 Council Member David Bristol, Place 5, Mayor Pro -Tem Ray Smith, Place 6 Council Member October 1, 2007 - September 30, 2008 H15 AWN OF SPE FY 2007-2008 Budget *"This budget will raise more total property taxes than last year's budget by $Ijc267,r257r X4.92° . and of that amount 1651,388.98 is tax revenue to be raised from new property added to the roll this year." •Indudes Debt Servloe and General Fund expenditures Rev 8/15/07 t P TOWN ER September 14, 2007 Dear Honorable Mayor and Council Members: I am pleased to present the proposed FY 2007-2008 budget for the Town of Prosper for your consideration. Prosper is at an exciting time in its history, faced with the possibilities and challenges offered by the explosive growth confronting it. Located in the fastest growing county in Texas and one of the fastest growing counties in the United States, Prosper must balance the infrastructure demands of citizens and business expectations of service against the Town's ability to fund these needed items. It is also an opportunity for today's leaders to lay the solid foundation for the Town to promote the sustainable, quality development necessary to improve the quality of life of future generations. This budget is an important step in that direction. One way to look at the Town government is to consider it a parent company operating many different and diverse subsidiary businesses. All of these "businesses" should be operated in a business -like manner, but not necessarily as a private sector business would. For example, some of the subsidiaries, like the water system, are true enterprise operations and should rely on their program income and not operate at a loss. Other subsidiary operations, such as parks or streets, generate little or no revenue and rely on handing from other non -program sources. The FY 2007-2008 budget process was different from recent years in that the Finance/Business Manager and other department heads were involved throughout the process and the budget workshops were in a different format. In addition to these changes, the lack of continuity in the Town Manager's o:lliice added extra complexity to the process. Council and staff are commended for handling the process without missing a step. In this letter I will establish the context of the budget and highlight significant revenue and expenditure items. Overview The proposed budget includes several items that affect multiple departments, including: 1. Salary Study — Waters Consulting presented the results of a salary and benefits study to the Council in July 2007. The plan calls for a three-phase implementation that will bring all positions to the base salary identified by the study within 12 months. The study compared each individual position with comparable positions in a selected group of cities with which Prosper competes for labor. The study determined that, on average, non-public safety related positions were 16.1 percent below market and public safety (i.e. fire and police personnel) were 28.4 percent below market. The net fiscal impact of following the recommended plan is $152,364. 2. Group Insurance — Request for proposals were received for group medical, dental, accidental death & dismemberment, and life insurance. After careful evaluation Council decided to change carriers for a net savings of $38,672 while at the same time improving the level of coverage in certain areas. 3. Mileage Reimbursement — Effective January 2008, the proposed budget allows for increasing the Town's mileage reimbursement rate to $0.55 per mule to possibly match the Internal Revenue Service's rate increase published in January of each year. 4. Copier Leases — Currently each department makes its own arrangements for photocopiers. In FY 2007-2008 it is proposed that all copiers come under a single lease in order to take advantage of volume pricing and to simplify administration. 5. Telephone System. City offices are currently located at six locations, each with their own phone system. This fractured telecommunications arrangement inhibits customer service and reduces efficiency because each office can only be accessed by a ten digit phone number (rather than a three digit extension) and requires at least three telephone attendants. Some of these systems also have maintenance issues. A new, unified telephone system is proposed that is portable, allow easy transfer of calls to different locations, uniform and enhanced voicemail capabilities, and can be operated by as few as one attendant, if necessary. 6. Growth Rate — Based on historical data, including building permits, new water meters, and growth studies, the budget assumes a 16 percent annual growth rate. This assumption drives certain revenue and expenditure line items such a utility franchise payments, maintenance and operations costs, etc. 7. Contingency — Section 7.08 of the Charter requires that a minimum of ten percent of total general fund expenditures be budgeted for use on unforeseen expenditures. This requirement was established by the Charter adopted in November 2006 and has not been part of the Town's budget in the past. After evaluation by the Town Attorney, Auditor, and other Town staff, the contingent expenses will be offset by contingent revenues of the same amount. Revenue Ad Valorem. Ad valorem (property) taxes represent the largest single revenue source (41 percent) for the General Fund. According to the Collin County Appraisal District, as of January 1, 2007, Prosper had added $112,400,000 in new construction and $12,100,000 through annexation in 2006 for a total taxable value of $762,250,305. During calendar year 2006 the average residential homestead value increased from $280,800 to $316,400. The proposed tax rate of $0.52 exceeds the effective rate of $0.426053 and the rollback rate of $0.487886. Prospers ad valorem value per capita is $93,751 compared to the area average of $80,688 while the ad valorem revenue per capita is $468 compared to the average of $411. Sales Taxes. At 22 percent sales tax is the second largest source of revenue for the General Fund. In FY 2006-2007 the Town unexpectedly lost two large sales tax providers, causing sales tax revenue to drop by about 20.84 percent. Although there is currently some commercial retail development in various stages of construction or planning, sales tax is predicted to grow a modest 2.4 percent. Even with the anticipated growth sales tax revenue will still be lower than what was received in FY 2005-2006. Utility Rates. No changes in water, wastewater, or sanitation rates are proposed. A residential water customer in Prosper who consumes 5,000 gallons will still pay $27.46 while the area average is $22.47. A 50,000 gallon commercial customer will pay $289.37 in Prosper where the average is $202.63. The residential wastewater pays $22.38 for 5,000 gallons and the average for the same consumption is $22.06; 50,000 gallon commercial customers pay $66.30 to Prosper and average $146.38 in the area. Interest Income. Due to a reduction in the fund balance, interest income is anticipated to be lower by 26.7 percent ($22,720). Expenses Highlights of each department's appropriations are detailed below: Administration. The Prosper Economic Development Corporation is expected to move from their current location in Town Hall, providing an opportunity to expand the utility billing office to accommodate the second utility billing clerk proposed in the budget. Engaging a consultant to assist with development of a strategic plan. 0 Posting of Code of Ordinances on the Internet to improve citizen access. Police Two new positions are proposed. Currently, when the Court Clerk (thee only civilian employee) is out on an errand, on vacation, etc., the Municipal Court and Police Department must be closed to the public. The addition of an Administrative Assistant will improve customer service by allowing Municipal Court and Police Department to be open when the Court Clerk is out. The position will also improve department administration. • The second position is a Patrolman. Adding another officer will help meet the demands of a growing population. Fire • Three new fiill time positions are planned for in the 2007-2008 fiscal year. With the addition of these additional full time positions the Department will now have a total of 12 full time emergency response fire fightemEMT personnel not including the Chief and Fire Marshal supplemented by six part-time and an additional thirteen volunteer service providers. The Department successfully secured grant fimding of $54,000 to leverage Town funds for the purchase of a new brush truck and $98,800 for the purchase of new and replacement air packs. Streets The Streets Department has two equipment purchases planned. The Department will be purchasing a street broom for the skid loader and a sanding skid. This equipment will assist the Department in the area of street maintenance. Parks • The Parks Department is an area receiving additional funding in the coming year. The Department will add an additional maintenance person, funding the mowing of ROW's, irrigating sports fields, and installing an irrigation system at sports fields. Inspections and Code Enforcement • Two new positions will be hired in 2007-2008, a plans examiner, and an Administrative Assistant position. Both of these positions should improve the Department's response to customer service needs and timeliness of work product. To improve service delivery and response in the field a new lap top computer is being purchased to use in the field to complete reports. Planning and Engineering • A new Permit Technician will be brought on board during the fiscal year to assist customers manage the permitting process. Associated with this position is the necessary expense for computer and other associated information technology related item. Legal expenses are expected to increase in the new year due to several large master planned projects being proposed and their need for legal review. Public Works — Water Fund • Expenditures in the Water Fund are expected to increase in the areas of Water Purchases, and meter purchases. Capital purchases include a tractor with a brush hog to maintain easements, a 5 cubic yard Dump Truck and a new pick up truck. Public Works — Sewer Fund Planned equipment purchases in the Sewer Fund include a backhoe trailer, a Dump Truck, a pick up truck and a finish mower. Public Works — Utility Billing • There will be the addition of one new Utility Billing Clerk enabling the customer service aspect of the operation to be open from 8:00 am. until 5:00 p.m. each day, ensuring complete personal service for the citizens of Prosper. Many of these new positions will not be hired until April of 2008 allowing for budget constraints, market adjustments, space planning and modifications and business planning as well. Future Considerations Over FY 2007-2008 several issues will require investigation and planning. First, there is no doubt that the retail sector in Prosper is poised for very high growth, particularly along the Highway 380 and Preston Road corridors. The sooner retail outlets develop, the quicker pressure on ad valorem revenue can be reduced by replacing it with increasing sales tax revenue. Indeed, construction, agreements, and planning for several projects are already underway. The United States and north Texas economies appear to be entering more uncertain times, as evidence by slower home sales, increasing supplies of lots, higher home foreclosure rates, etc. To date Prosper has not felt the full negative impact of a slowing economy as some of our neighbors have; however, our local economy should be monitored closely throughout the entire year and adjustments made to the budget accordingly. Second, most of the debt for water and wastewater is being covered by the General Fund. This arrangement is not necessarily wrong but it does mask the true cost of operating these utilities. For example, even without the debt included, wastewater system revenues are not sufficient to meet the systems expenditures. Additionally, until sales tax revenues increase significantly, the Town is very reliant on ad valorem revenue. If ad valorem revenue has to be used to subsidize enterprise operations, that means there is less money available to meet the increasing demands on General Fund programs such as streets, parks, and emergency services. A fairness argument can also be made that all citizens are being charged for part of the utility system, regardless of their consumption of the service, when the cost of the service should be borne by those who consume the service. Careful consideration should be given to charging water and sewer debt to their respective enterprise funds and adjusting the customer rate structures so that they can pay for all system costs. Third, a major area of concern operationally is the lack of any semblance of a purchasing system or policies. Currently each department buys material, equipment, and services individually, frequently without the prior knowledge of the Finance/Business Manager or Town Manager. Significant economies of scale are lost and the inability to properly manage the budget throughout the year, at a minimum, jeopardizes the efficiency and effectiveness of the government and at worst can potentially imperil the soundness of the overall budget. Fourth, as described earlier, the proposed budget includes implementation of the Waters Consulting Group salary study; however, as also noted, it only brings salaries to the base level identified in the study. If the Town is to be competitive in the labor market and attract and retain the quality employees required to provide the level of service demanded by our citizens, then it will be necessary to consider additional increases to raise salaries to the average range identified in the study. Fifth, research and planning should begin in FY 2007-2008 for transition to dispatching emergency services ourselves. Currently the City of Frisco provides dispatching for the Town but, at their request, the Town has committed to leaving Frisco dispatch sooner rather than later. It is possible the Collin, County Sheriffs Office would dispatch Prospers emergency services; however, this is likely a short to medium term solution. Prospers call volume does not meet the minimum criteria to qualify for its own public safety answering point (PSAP) but is predicted to do so by late in calendar year 2008. For Prosper to operate its own dispatch service will require an annual budget conunitment of over $250,000 in personnel costs, plus a few hundred thousand dollars in initial capital costs, and expenses related to additional space in facilities that do not presently exist. The General Fund will not be able to absorb such a large expense in the short term but beginning research and planning now will ensure an orderly and responsible transition. Lastly, the current format of the budget needs to be revised to improve readability, understanding, and usefulness. Closing I would like to thank Finance/Business Manager Ron Butler for the many late nights and hard work running the numbers and adapting to a different way to do the budget process. The Department Heads also deserve kudos for preparation of their respective budgets and willingness to thoroughly participate in the process. I would also be remiss if I did not thank the Mayor and Council for their patience and thoughtful consideration and input. I have enjoyed my brief tenure with the Town of Prosper and know that incoming Town Manager Mike Land will provide valued leadership throughout the implementation of this budget. Please do not hesitate to contact me if you have any questions regarding this document. Respectfully submitted, Kevin Carruth Interim Town Manager N P T' O W N PEOFR Ad Voloreum Tax Rate Distribution Ad Valoreum Tax Revenue & Distribution Tax Rate Comparison Budget Summaries & Graphs Schedule of Personnel General Fund Departmental Summaries Administration / Communication Police / Court Fire Streets Parks & Recreation Inspections / Code Enforcement Plannind / Engineering Public Works Fund Water / Sewer / Utilities Schedule of Indebtedness Interest & Sinking Fund Summary Schedule of Indebtedness Capital Projects Fund Summary Five Year Capital Project Program Parks Fund Summary Impact Fees Fund Summary Special Revenue Fund Summary Economic Development Corporation Summary TABLE OF CONTENTS 1 2 3 4 8 10 18 24 33 38 42 45 SO 58 59 68 69 70 74 77 78 82 90 91 95 96 100 101 104 105 I& Z)'W S PER ADOPTED BUDGET FY 2007 — 2008 Ad Vaioreum "Tax Rate Distribution October 1, 2007 - September 30, 2008 Ad Valorem Taxes Tax Rate Distribution FY 2007-2008 Debt Service 47% General Fund 53% PER $100 VALUATION 2GO61 2007 2_00712008 General Fund Tax Rate (M & O) 0.184549 0.275075 Debt Serice Tax Rate ( 1 & S) 0.314268 0.244925 Total Tax Rate 0.498817 0.520000 E General Fund Debt Service Total Taxable Value $ 762,250,305 $ 762,250,305 Tax Rate Per $100 0.275075 0.244925 Tax Collections $ 2,096,760 $ 1,866,942 Tax Collections -Freeze $ 66,098 $ 58,853 Total Tax Collections $ 2,162,858 $ 1,925,795 One Cent Equals $ 76,225 $ 76,225 53% 47% Tax Rate Distribution FY 2007-2008 Debt Service 47% General Fund 53% PER $100 VALUATION 2GO61 2007 2_00712008 General Fund Tax Rate (M & O) 0.184549 0.275075 Debt Serice Tax Rate ( 1 & S) 0.314268 0.244925 Total Tax Rate 0.498817 0.520000 E gC)g o o po 00 u1 I:t M N .-1 S O O Q O 6 6 6 O O TIf_j Va 0) a�iys T�ofAJ �y J fid.. 4b cu m w x H N 0 oC x H S 41 � M C x ca Ln g ■ PER FY 2007 - 2005 ADOPTED BUDGET SUMMARIES October 1, 2007 - September 30, 2008 Rev OISM 4 TW OF P SPER GENERAL FUND Town of Prosper Fiscal Year 2007 - 2008 Adopted Budget CONSOLIDATED STATEMENT A B C D 5,357,419 5,357,418 "NET REVENU VE Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 REVENUES EXPENDITURES 4,339,447 3,231,084 4,328,761 4,277,455 4,135,495 4,045,544 5,357,419 5,357,418 "NET REVENU VE NET REVENUES OVER (UNDER) EXPEN51TURES 1 1,108,3631 51,3061 89,951 10 PARKS FUND WATER / SEWER FUND 118,5561 1,115,800 1,774,300 REVENUES REVENUES 3,742,356 3,266,665 3,266,500 3,867,000 EXPENDITURES 1,087,687 3,438,653 3,295,019 3,851,914 DEBT SERVICE FUND REVENUES EXPENDITURES CAPITAL PROJECTS FUND 926,276 1,791,055 1,813,656 1,965,930 834,524 1,706,684 1,916,092 1,866,948 REVENUES EXPENDITURES 12,453,373 158,384 165,500 19,491,238 660,312 9,615,152 206,100 8,404,244 "NET REVENU VE R EXPER31TUP99 112,294,993 (19,325,738)1 ?9,954,840)1 ,1 ,14 PARKS FUND 1,288,7621 118,5561 1,115,800 1,774,300 REVENUES 271,301 607,000 378,000 614,000 EXPENDITURES _ 183,304 - 31,000 35,000 IMPACT FEES FUND REVENUES 1,288,762 1,208,744 1,403,400 2,223,500 EXPENDITURES - 1,090,188 287,600 449,200 NET REVENUES OVER (UNDER) EXPENDITURE91 1,288,7621 118,5561 1,115,800 1,774,300 ECONOMIC DEVELOPMENT CORP. REVENUES 540,089 520,000 468,000 440,000 EXPENDITURES 230,308 324,943 218,351 319,066 19 $5. Town of Prosper FY 2007 - 2008 Budget Consolidated Fund Revenue Summary $3,867,000 Water & Sewer 26% 37% $440,000 EDC' Projects 3% 6 )30 Interest & ;inking 13% 0 Parks Fund 4% 1 Fee Town of Prosper FY 2007 - 2008 Budget Consolidated Fund Expenditure Summary $3,851,914 Water & Sewer 19% $5,357,418- General 5,357,418_General Fund 26% $35,000 Parks Fund 0% $1,866,948 Interest & Sinking $319,066 2% N $449,200 Impact Fee Fund .� 2% $8,404,244 Capital Projects 42% 19 i TOWN S PER. ADOPTED BUDGET FY 2007 - 2008 SCHEDULE OF PERSONNEL V& Ir ON O W F PER GENERALFUND Administration Police Fire Streets Parks Court Inspections Code Enforcement Planning Engineering Total Full -Time Total Part -Time Total General Government PQBLIC WOR Water Wastewater Utility Billing Total Full -Time Total Part -Time Total Public Works Economic Development Corporation Administration Total Full -Time Total Part -Time Total Economic Development Subtotal All Funds Full -Time Subtotal All Funds Part -Time Total All Funds Schedule of Personnel Fiscal Year Budget 2007 - 2008 4.0 5.0 5.0 Adopted FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Actual Budgeted Projected Budget 4.0 5.0 5.0 5.0 7.0 9.0 9.0 11.0 15.0 16.0 17.0 20.0 2.0 2.0 2.0 2.0 1.0 1.0 1.0 2.0 1.0 1.0 1.0 1.0 4.0 7.0 7.0 9.0 1.0 1.0 1.0 1.0 1.0 2.0 2.0 3.0 Q� 1_0 1.0 12 27.0 36.0 37.0 46.0 9_0 9.0 9_0 9_0 36.0 45.0 46.0 55.0 4.0 5.0 5.0 5.0 3.0 3.0 3.0 3.0 19 1_0 1_0 L.9 8.0 9.0 9.0 10.0 37.00 47.00 48.00 57.00 8.0 9.0 9.0 10.0 2.00 2_0 2.0 2`0 2.0 2.0 2.0 1.0 �0 0_0 OA 1D 2.0 2.0 2.0 2.0 37.00 47.00 48.00 57.00 9.00 9.00 900 10.00 46.00 56.00 57.00 67.00 9 1 OWN OF T S PER. ANNUAL BUDGET FY 2007 - 2008 GENERAL FUND 10 1SPER OWN OF P Town of Prosper FY 2007 - 2008 Town Budget General Fund Summary Fund Balance / Reserves Adopted Account FY 06/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description Actual Budgeted Projected Budget 3ENERAL FUND REVENUES Taxes: Property Sales Franchise Licenses, fees, and permits Charges for services Grants Investment Income Fines, warrants and seizures Contributions Miscellaneous EXPENDITURES Current: General Government Police Department Fire Department Streets Parks and Recreation Inspections Engineering Planning Capital Outlay $ 762,200 $ 1,050,041 $ 1,087,841 $ 2,179,403 $ 1,508,786 $ 1,603,800 $ 1,173,744 $ 1,202,000 $ 201,064 $ 202,980 $ 236,980 $ 269,065 $ 960,326 $ 1,147,040 $ 1,212,280 $ 1,144,950 $ 303,660 $ 143,700 $ 152,750 $ 148,820 $ 33,089 $ 30,000 $ 32,250 $ 184,000 $ 74,363 $ 43,200 $ 85,150 $ 62,430 $ 106,481 $ 105,000 $ 105,500 $ 120,000 $ 33,462 $ - $ - $ - $ 355,887 $ 3,000 $ 49,000 $ 46,750 Total Revenues $ 4,339,318 $ 4,328,761 $ 4,135,495 $ 5,357,419 $ 601,398 $ 796,781 $ 832,000 $ 912,461 $ 785,210 $ 990,119 $ 903,545 $ 1,196,475 $ 909,617 $ 1,170,412 $ 1,073,130 $ 1,367,129 $ 209,309 $ 339,339 $ 332,449 $ 285,059 $ 29,561 $ 86,418 $ 74,248 $ 200,441 $ 294,691 $ 476,148 $ 444,732 $ 582,771 $ - $ - $ - $ 130,716 $ 158,360 $ 211,709 $ 175,560 $ 288,288 $ 242,937 $ 206,529 $ 209,879 $ 414,078 Total Expenses $ 3,231,084 $ 4,277,455 $ 4,045,544 $ 5,357,418 Excess / (Deficit) $ 1,108,235 $ 51,306 $ 89,951 $ 0 OTHER FINANCING SOURCES(USES) Capital Leases $ - $ $ $ Transfers (cut) $ $ $ $ Transfer Out for Debt Service $ - $ $ $ Total Other Financing Sources (uses) $ - $ - $ - $ Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending 16% Reserve Calculation: Less Restricted Funds -Contributions Police rt, Fire Donations -Utility Escrow for sideways, etc Court Security Fund Court Technology Fund Balance of Unrestricted Funds 16% Reserve Amount over/ (under) Reserve Actual Reserve % $ 1,108,236 $ 51,306 $ 89,951 $ 0 $ 1,820,709 $ 2,587,322 $ 2,587,322 $ 2,677,273 $ 2,928,944 $ 2,638,628 $ 2,677,273 $ 2,677,274 $ (68,512) $ $ $ $ (267,230) $ $ $ (5,667) $ $ e; $ (212) $ _ - _ $ 5 $ (341,621) $ $ $ - $ 2,587,322 $ 2,638,628 $ 2,677,273 $ 2,677,274 $ 516,973 $ 684,393 $ 647,287 $ 857,187 $ 2,070,349 $ 1,954,235 $ 2,029,986 $ 1,820,087 80.08% 61.69% 66.18% 49.97% 11 Franchi 64 Town of Prosper FY 2007 - 2008 Adopted Budget General Fund Revenue Sources Flnes, warrants and selzures Miumea fmr maminam X - 22% 12 arty Tax r% RILIU W a SPER Town of Prosper Fiscal Year 2007.2008 Summary of Revenues By Department General Fund $ 4,339,447 Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description Actual Budgeted Projected Budget General Fund $ 4,339,447 $ 4,328,761 $ 4,135,495 $ 5,357,419 Administration $ 3,125,032 $ 3,237,121 $ 2,942,625 $ 4,015,199 Police $ 52,928 $ 35,700 $ 37,880 $ 39,020 Court $ 106,662 $ 105,200 $ 105,650 $ 120,200 Fire $ 312,429 $ 142,000 $ 147,250 $ 298,800 Streets $ - $ - $ 120,000 $ _ Packs / Recreation $ 271,301 $ 607,000 $ 378,000 $ _ Communication $ 6,100 $ $ $ _ $ $ Inspections $ 668,304 $ 742,740 $ 769,090 $ 793,200 Planning $ 74,092 $ 66,000 $ 133,000 $ 91,000 General Fund Totals $ 4,339,447 $ 4,328,761 $ 4,135,495 $ 5,357,419 Water & Sewer Fund $ 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 Interest & Sinking Fund $ 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 Parks Fund $ 412,407 $ 425,400 $ 429,400 $ 1,030,500 Park Dedication Fees $ 99,146 $ 255,000 $ 258,000 $ 259,500 Park Improvement Fees $ 172,155 $ 352,000 $ 120,000 $ 354,500 Parks Fund Totals $ 271,301 $ 607,000 $ 378,000 $ 614,000 Impact Fees Fund Interest Income $ 51,206 $ - $ - $ - Water Impact Fees $ 463,687 $ 419,696 $ 516,000 $ 678,750 Wastewater Impact Fees $ 361,462 $ 363,648 $ 458,000 $ 514,250 Thoroughfare Impact Fees $ 412,407 $ 425,400 $ 429,400 $ 1,030,500 Impact Fees Fund Totals $ 1,288,762 $ 1,208,744 $ 1,403,400 $ 2,223,500 Capital Projects Fund Series 2004 Bond $ 432,711 $ 100,000 $ 175,000 $ 6,100 Series 2006 Bond $ 12,020,6$2 $ 65,500 $ 485,312 $ 200.000 Capital Projects Fund Totals $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 Totals $ 23,021,615 $ 11,367,725 $ 11,857,363 $ 14,233,948 EDC Fund $ 540,089 $ 520,000 $ 468,000 $ 440,000 Totals Funds $ 23,561,604 $ 11,887,725 $ 12,125,363 $ 14,673,948 13 Town of Prosper FY 2007 - 2008 Adopted Budget General Fund Revenues by Department Administration 75% 15% 5% 14 Police 1% Pri-r PEI. Town of Prosper Fiscal Year 2007 - 2008 Summary of Expenditures By Department Administration $ 618,950 $ Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 I Description Actual Budgeted Projected Budget 887,770 $ 1,146,625 Court $ Administration $ 618,950 $ 776,745 $ 811,964 $ 892,641 Police $ 786,107 $ 977,988 $ 887,770 $ 1,146,625 Court $ 111,686 $ 111,466 $ 115,110 $ 157,610 Fire $ 971,401 $ 1,255,762 $ 1,158,830 $ 1,595,479 Streets $ 223,774 $ 339,339 $ 332,449 $ 331,059 Parks / Recreation $ 29,561 $ 86,418 $ 74,248 $ 221,549 Communication $ 6,905 $ 22,016 $ 22,016 $ 25,500 Inspections $ 324,090 $ 494,212 $ 462,796 $ 567,951 Engineering $ $ - $ - $ 130,716 Planning $ 158,610 $ 213,509 $ 180,360 $ 288,288 General Fund Totals $ 3,231,084 $ 4,277,455 $ 4,045,544 $ 5,357,418 Water & Sewer Fund $ 1,087,687 $ 3,438,653 $ 3,295,019 $ 3,851,914 Interest & Sinking Fund $ 834,524 $ 1,706,684 $ 1,916,092 $ 1,866,948 Parks Fund Park Dedication Fees $ 40,304 $ - $ 31,000 $ - Park Improvement Fees $ 143,000 $ - $ _ - $ 35,000 Parks Fund Totals $ 183,304 $ - $ 31,000 $ 35,000 Impact Fees Fund Water Impact Fees $ 1,160,542 $ 796,888 $ 144,700 $ 329,200 Wastewater Impact Fees $ - $ - $ 56,900 $ - Thoroughfare Impact Fees $ - $ 293,300 $ 86,000 $ 120,000 Transfer of Capital Assets $ (1,160,542) $ - $ $ - Impact Fees Fund Totals $ - $ 1,090,188 $ 287,600 $ 449,200 Capital Projects Fund Series 2004 Bond $ 158,380 $ 7,425,738 $ 6,042,573 $ 368,312 Series 2006 Bond $ - $ 12,065,500 $ 3,572,579 $ 8,035,932 Capital Projects Fund Totals $ 158,380 $ 19,491,238 $ 9,615,152 $ 8,404,244 Totals $ 5,494,979 $ 30,004,218 $ 19,190,406 $ 19,984,724 EDC Fund $ 230,308 $ 324,943 $ 218,351 $ 319,066 Totals Funds $ 5,725,287 $ 30,329,161 $ 19,408,757 $ 20,283,789 15 Town of Prosper FY 2007 - 2008 Adopted Budget General Fund Expenditure Engineering Communication Inspections 2% Parks / 1 %Q 11% Recreation 4% Streets Planning 6% 5% Administration 17% Fire 30% Police Court 21% 3% IL (9 TOWN OF SP R ADOPTED BUDGET FY 2007 - 2008 GENERAL FUND FUND 10 17 ADMINISTRATION/COMMUNICATION r Aas.l.utaTTI to U � Admlrimr 1--- --- 'town I4fansger Mike Land Town Sevalary CornmunicielIons ___---- r�<lec�>�rra„�rr Finance/eusinoas Ma"lleat �,_..�.�_ 9r✓n 9vlly� Accounts Payable 1 Payroll Clark 1 Koren COO Revenue & Expense Summary l.11illly Filling Cleric 18 Projected Adopted Actual Budgeted Year End 1 Budget 2005-2006 2006-2007 2006-2007 i 2007-2008 18 revenues 3,125,03Z 7,121 1 2,942,625 14,015,199 Expenditures 625,855 1 798,761 1 833,9801 918,141 18 >�tmmt: Administration Administration consists of the Town Manager, Town Secretary, Communications, and -Finance. The mission of Administration is to provide professional leadership, guidance, and coordination to implement Town policies and ordinances as established by Council. Provide effective, quick and reliable information to the citizens with posting of legal notices as required by State law & Town Ordinances. Effectively record council meeting and other meeting as required and keep the Council updated on State laws pertaining to Council. Administrations mission is also to provide fiscal financial management to the Town, implement financial policy, prepare fiscal budget, and operating an accounting system according to law and GAAP, GASB policies and procedures. • Completed implementation of new Financial, Payroll, AP and Utility software • Hired new Accounts Payable/Finance Clerk to handle AP and Payroll. Also assist Finance Manager when required • Started implementation of Fixed Base Meter reading system for Utility Billing • Town Secretary started new centralized filing system • Updating Personnel files to meet government requirements • Improved collection of pass due utility bills a Staff assured continued operation of Town Hall by assuming duties of vacated positions • Continuing training to ensure personnel or qualified and certified to perform the required duties expected of them. .... . . .......................... • All manuals are a constant work in progress as ordinances change. Current manuals are being reviewed and new one established a Continue to diversify investments to realize higher interest yield. • Organized and reviewed AP to reduce double payments. Will regularly examine programs and services to reduce operating costs or enhance service levels with cost increase. • Streamline operations process to ensure customer friendly service. • Utilize new financial and utility programs (software) to reduce cost and increase revenue. Continued training to assure that personnel are kept updated, knowledgeable, and efficient in their respective working areas. • Charges for services are to be reviewed. • Setup online payment process, bank drafting, and credit card acceptance • Create new position as Receptionist / Clerk to assist Utility Billing and Town Hall • Update meter reading system to ensure accurate data available to citizens and staff • To implement a near paper filing system 19 Town of Prosper F Adopted Departmental Budget TOWN ° � Fiscal Year, 2007-2008 1S P O R Summary of Revenue Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 4030 Miscellaneous 4035 3% Construction Insp Fees A B C D 4060 NSF Fees 325 Revenue Projected - 4105 Tax Revenue - Delinquent Actual Budgeted Revenue Adopted Budget Account Tax Revenue - Current Revenue FY Current Fiscal Current FY for Code Title of Account 2005-2006 Year 2006- 1 200+-2007 FY 2007-2008 4030 Miscellaneous 4035 3% Construction Insp Fees 184,081 295,000 275,000 250,000 4060 NSF Fees 325 300 60 - 4105 Tax Revenue - Delinquent 4,764 2,000 34,000 15,000 4110 Tax Revenue - Current 748,261 1,043,841 1,043,841 2,159,223 4115 Penalty & Interest 9,175 4,200 10,000 5,180 4120 Sales Tax - Gen. Fund 1,506,516 1,602,000 1,171,944 1,200,000 4130 Mixed Beverage Sales Tax 2,270 1,800 1,800 2,000 4140 Franchise Fee - Electric 142,898 143,200 172,800 202,400 4150 Franchise Fee - Telephone 23,808 24,180 24,180 20,985 4160 Franchise Fee - Gas 26,682 30,000 30,500 32,880 4180 Franchise Fee - Other - - - - 4190 Franchise Fee - Cable 7,676 5,600 9,500 12,800 4200 T -Mobile 18,000 18,000 18,000 18,000 4205 Internet America 19,500 18,000 18,000 18,000 4215 Annexation Fees 4,000 2,500 1,500 2,500 4218 Administrative Fees -EDC 1,500 1,500 1,500 12,000 4636 Child Safety Fee -Special Rev 5,079 4610 Interest Income 74,182 43,000 85,000 62,230 4910 Other Revenues 136,645 2,000 45,000 2,000 4915 Escrow 209,670 4995 Transfer In Totals $ 3,125,032 $ 3,237,121 $ 2,942,625 $ 4,016,199 20 go Z Town of Prosper ,fi Adopted Departmental Budget P TOWN �E � Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 5110 Salaries & Wages A B C D 5115 Salaries - Overtime 405 Expenditures Projected 1,500 5120 Salaries - Leave Time Actual Budgeted Expense Adopted Budget Account Salaries -Longevity Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5150 5110 Salaries & Wages 217,473 275,201 289,990 334,012 5115 Salaries - Overtime 405 400 865 1,500 5120 Salaries - Leave Time 4,242 - - - 5140 Salaries -Longevity 1,725 1,875 1,725 2,325 5145 Social Security Expense 14,267 17,204 17,621 20,845 5150 Medicare Expense 3,337 4,023 4,336 4,875 5155 SUTA Expense 567 2,350 840 1,418 5160 Health Insurance 13,184 22,167 19,765 32,788 5165 Dental 1,193 1,996 1,397 2,955 5170 Life Insurance / A D & D 443 725 1,636 236 5173 AD & D 79 - - 758 5175 TML Expense (insurance) 96,965 115,700 115,700 118,900 5180 TMRS Expense 13,313 17,367 26,172 34,366 5185 Short/Long Term Disability 1,199 3,781 2,112 2,244 5180 Contract Labor 3,675 5,200 5,200 5,100 5191 Hiring Cost - 80 8,200 480 5193 Record Retention 1,136 15,000 10,000 15,000 5210 Supplies 9,699 12,060 10,000 11,645 5212 Building Supplies 2,065 2,100 1,500 1,500 5220 Office Equipment 1,643 2,720 2,700 2,720 5230 Dues School Subscriptions 2,612 4,770 4,770 6,710 5240 Postage & Delivery 1,770 2,916 2,916 4,930 5250 Publications 932 875 875 1,945 5260 Advertising - - - 300 5270 Bank Charges 23 270 270 575 5280 Printing & Reproduction 1,107 2,380 3,400 3,380 5290 Miscellaneous 4,652 - - - 5310 Rental Expense 1,003 1,200 1,500 1,300 5312 Equipment Lease - - - 5320 Repair A Maintenance - - - - 5325 Copier Lease 5,250 7,200 7,200 9,480 5330 Copier Expense 1,282 300 300 300 5335 Radio / Vedio Repairs - - - - 5340 Building Repairs 319 5,000 5,000 7,700 5350 Vehicle Expense 7,500 5,250 5,500 - 5410 Professional Services - 24,900 40,000 10,000 5412 Audit Fees 20,000 23,000 21,400 26,000 5414 Tax Fees 12,821 15,860 15,860 29,600 21 Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 5416 Engineering Fees A B C D 1,000 - 5418 Expenditures Projected 13,637 20,870 Actual Budgeted Expense Adopted Budget Account Legal Fees Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 12,438 7,200 7,200 8,500 5416 Engineering Fees 42,779 21,000 1,000 - 5418 IT Fees 13,637 20,870 20,870 26,020 5430 Legal Fees 39,829 45,000 45,000 40,705 5435 Legal Notices / Filings 12,438 7,200 7,200 8,500 5460 Election Expense 3,910 10,000 30,000 15,000 5480 Contracted Services 8,927 21,540 21,540 17,400 5520 Telephone 8,395 9,920 9,920 21,193 5521 Cell Phones 2,273 3,600 3,600 3,800 5522 Pagers 116 - 14 - 5525 Electricity 8,282 11,520 11,520 14,400 5530 Travel/Meals/Lodging Expense 1,545 6,710 6,710 10,340 5532 Entertainment 127 100 100 3,800 5533 Mileage Expense 1,474 4,100 4,100 4,735 5536 Training I Seminars 3,833 9,060 9,060 10,880 5538 Training / Seminars - Council 1,047 4,600 4,600 5,350 5600 Special Events - 5,675 6,000 8,950 6110 Capital Expenditures - - - - 6140 Capital Expenditures -Equip 24,457 1,980 1,980 5,680 6160 Capital Expenditures -Vehicles - - - - 7142 Transfers to W1S - Totals $ 618,950 $ 776,745 $ 811,964 $ 892,641 22 Town of Prosper Adopted Departmental Budget T OER ;; Fiscal Year, 2007-2008 P-OSummary of Expenditures Fund: GENE AL FUND 10 Department: Communication 95 5190 A B C D 4,800 8,800 Expenditures Projected Supplies Account Actual Expense FY Budgeted Expense Current FY Current FY Adopted Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 - 5190 Contract Labor 3,823 4,800 4,800 8,800 5210 Supplies 196 1,916 1,916 1,900 5230 Dues School Subscriptions - - - - 3240 Postage & Delivery 540 1,250 1,250 1,250 5250 Publications 216 40 40 40 5265 Promotional Expense 1,673 2,500 2,500 2,000 5280 Printing & Reproduction - 10,170 10,170 10,170 5290 Miscellaneous 102 - - 5530 Travel/Meals/Lodging Expense 355 845 845 845 5536 Training / Seminars - 495 495 495 6140 Capital Expenditures -Equip - - - - Totals $ 6,905 $ 22,016 $ 22,016 $ 25,500 23 POLICE/COURT Revenue & Expense Summary evenuee I 159,590 140,9001 ,5 15 , Expenditures 1 897,79-3 1 1,699,Z54 1 1,002,880 1 1,304,235 24 Projected Adopted Actual 2005 1 Budgeted Year End Budget 2006 2006-2007 2006-2007 2007-2008 evenuee I 159,590 140,9001 ,5 15 , Expenditures 1 897,79-3 1 1,699,Z54 1 1,002,880 1 1,304,235 24 Deperuneat: Police The Prosper Police Department Mission Statement is: To provide efficient police services to meet current needs and future demands through proactive community interactions, crime prevention and modern law enforcement techniques. The Prosper Police Department is a full service department offering a myriad of police services. These services include, but are not limited to: • General Patrol + Accident Investigation/Reconstruction Community Focused Policing/Crime Prevention ■ School Resource Officer Program • National Night Out/Health and Safety Fair * Crisis Intervention • Criminal Investigation • K-9 (narcotics) unit • Emergency Response Team • Traffic Enforcement • Community Outreach Programs Through our close relationship with citizens and business owners, the department is taking a proactive approach to crime prevention and crisis intervention. We are taking Community Oriented Policing one step further by applying Community Focused Policing. • The PPD moved into a different facility this year ■ The School Resource Officer Program completed its fust year. • The PPD K-9 unit was trained and is nationally certified. • The Health and Safety Fair proceeds purchased over $7000 of equipment for special needs kids • The Cops for a Clause program provided assistance to over 200 children during Christmas • The PPD made several drug arrests and solved a bank robbery. • The PPD implemented a bicycle patrol to enhance visibility and community awareness. ■ PPD implemented a Safety Tip program using the Prosper Press to provide safety tips to citizens in the paper. * Consistently keep our active case load down to a minimum by assigning follow-up investigations. • Implemented training schedule that provided for advanced professional training for all officers • Promoted David Lightfoot to sergeant and hired two additional officers. 25 • Examine services provided to insure cost effectiveness of our mission. • Continue present programs of community outreach and look for new ways to include the citizens in our quest to make our community a safe and desirable place to live. • Provide for adequate and safe emergency communications for the citizens and the people who we serve. • Provide adequate work space for employees that will provide ease of access to citizens and visitors to the police department. • Encompass National Accreditation Standards as we grow to provide for an easier transition when the department looks to become an accredited department. • Provide adequate staffing to provide desired coverage and officer safety. ■ Expand staffing to start building a command structure. • Provide training and equipment equivalent to the duties and responsibilities expected of the staff. • Implement an emergency response plan for the Town in the event of a natural disaster or catastrophic incident. • Update our policies and procedures to keep abreast of changes made through legislation and case law. • Retain present staff through adequate training, equipment, staffing, pay and benefits. • Attract quality personnel for positions opened by growth. • Increase enforcement of traffic law to generate higher voluntary compliance. • Work with other Town departments and the Council to promote goodwill and quality service for our community. • Partner with the Prosper ISD to increase staffing of the School Resource Officer Program to provide for a SRO full time at the High School, and SRP in the Middle School, and one SRO rotating through the elementary schools. 26 Town of Prosper, Texas Department: d The municipal court of Town of Prosper is dedicated to executing the tasks associated with the administration of a municipal court on behalf of the citizens of Prosper and in accordance with the laws of the State of Texas and ordinance of the Town of Prosper. ► Improve consistency in operations by receiving training from attending seminars and continuing education classes. Passed Level III test and currently working on final certification by doing 40 hours of court observation ► Created new forms to help expedite court processes Increased collections of fines amounts by utilizing the OMNI base reporting system Decreased number of Capias and Arrest Warrants filed in the court ► Continue to upgrade court software with version updates to better improve the quality of court systems ► Signed on with an outside collection agency to collect past due warrants Continued Membership to organizations that provide information and training for courts. Joined the National Association of Court Management. • Will regularly examine programs and services to reduce operating costs or enhance service levels with cost increase. • Streamline operations process to ensure customer friendly service. Obtain Level III certification and be classified as a Certified Municipal Court Clerk • Continue with education requirements and needs for the court and memberships that are currently held. + Continue to increase collection of past due fine and warrants through collection agency 27 r Town of Prosper ''' Adopted Departmental Budget r ° w N ° Fiscal Year, 2007-2008 - - ' p Summary of Revenue Fund: GENERAL FUND 10 Department: Police 20 4030 Miscellaneous 4230 Other Permits A B C D 220 200 250 220 4450 Revenue Projected 5,500 7,500 7,600 4510 Grants Actual Budgeted Revenue Adopted Budget Account 30,000 30,000 31,200 Revenue FY Current Fiscal Current FY for Code Title of Account 2005-2006 Year 2006-2007 2006-2007 FY 2007-2006 4030 Miscellaneous 4230 Other Permits - - 130 - 4440 Accident Reports 220 200 250 220 4450 Alarm Permits 7,641 5,500 7,500 7,600 4510 Grants - - - _ 4520 Resource Officer Reimb. 28,010 30,000 30,000 31,200 4530 Contributions 17,057 - - - 4910 Other Revenues - 4920 Lease / Purchase Proceeds - - - - Totals $ 52,928 $ `;] 35,700 $ 37,880 $ 39,020 Town of Prosper Adopted Departmental Budget pr � N rtj Fiscal Year, 2007-2008 1� Summary of Expenditures Fund: GENERAL FUND 10 Department: Police 22 6110 Salaries & Wages A B C D 515,441 5115 Expenditures Projected 17,500 17,500 22,844 Budgeted Expense Adopted Budget Account 25,000 Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 1 FY 2007-2008 6110 Salaries & Wages 317,701 422,970 393,701 515,441 5115 Salaries - Overtime 25,992 17,500 17,500 22,844 5120 Salaries - Leave 2,256 - 25,000 - 5125 Salaries - Sick 1,175 - - 6140 Salaries - Longevity 4,500 5,750 5,625 6,725 6145 Social Security Expense 21,612 27,666 26,211 33,991 5160 Medicare Expense 5,054 6,470 6,130 7,950 5165 SUTA Expense 496 2,430 860 2,970 6160 Health Insurance 29,296 37,684 35,932 42,097 5165 Dental 2,745 3,394 2,728 3,219 6170 Life Insurance 854 1,383 1,557 473 6171 Life Insurance Supplemental 8,759 9,819 9,819 - 6173 Life/AD&D (Standard Insur. Policy) 154 - - 1,404 6180 TMRS Expense 23,599 27,894 29,504 45,669 6185 Short/Long Term Disability 2,005 5,673 3,182 4,318 5190 Contract Labor 1,960 5,520 5,520 7,440 5191 Hiring Cost 74 1,580 500 2,960 5192 Physical & Psychological - 3,400 750 2,700 5205 Contributions 21,054 - - - 5210 Supplies 8,527 9,300 9,000 12,000 5212 Building Supplies 1,250 2,525 1,600 2,500 5214 Tactical Supplies 160 800 730 600 5215 Ammunition 5,092 5,500 5,000 5,500 5220 Office Equipment - 800 800 5,300 5230 Dues and Subscriptions 1,663 2,500 1,500 2,500 5240 Postage & Delivery 237 750 750 750 6250 Publications 267 1,225 900 750 5260 Advertising 1,113 850 - 1,400 5265 Promotional Expense - 2,250 2,000 2,250 5280 Printing & Reproduction 479 2,300 1,500 2,300 5290 Miscellaneous 3,175 - - - 5310 Rental Expense 7,900 9,620 9,620 12,270 5320 Repair & Maintenance 613 5,900 5,900 5,000 6326 Copier Lease 2,368 3,000 3,000 3,500 6330 Copier Expense 547 - - 1,000 29 Fund: GENERAL FUND 10 Department: Poiice 20 6335 Radio/Video Repairs A B C D 5360 Vehicle Expense Expenditures Projected Gas/Grease/OlUlnspections 5400 Unlfonn Expense Budgeted Expense Adopted Budget Account IT Fees .Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 6335 Radio/Video Repairs 5340 Building Repairs 5360 Vehicle Expense 5363 Gas/Grease/OlUlnspections 5400 Unlfonn Expense 6410 Professional Services 6418 IT Fees 5430 Legal Fees 6460 Dispatch Expense 6480 Contracted Services 6620 Telephone 6621 Cell Phones 5622 Pagers 6524 Gas 5526 Electricity 6630 Travel Expense 6633 Mileage Expense 6636 Training / Seminars 6600 Special Events 6630 Safety Equipment 5640 Signs S Hardware 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles - 6,250 4,000 6,250 320 1,000 1,000 1,000 12,894 20,000 18,000 20,000 25,525 35,000 24,000 31,995 8,332 7,300 7,300 13,500 1,154 1,500 500 2,000 13,049 9,750 3,900 15,000 7,925 3,500 6,000 10,000 60,445 92,750 49,000 90,000 13,945 29,900 29,900 29,900 6,524 9,800 9,000 12,900 3,465 5,000 5,000 9,250 464 - 164 - 374 900 700 750 3,670 3,000 2,800 3,000 3,875 4,000 2,500 4,500 636 1,000 750 1,000 9,332 14,500 11,000 17,500 - 3,950 3,000 11,000 - 1,350 1,350 - - 1,750 1,750 1,500 46,097 3,725 3,725 - 17,458 18,200 18,200 21,350 47,944 77,410 77,410 86,410 Totals $ 786,107 $ 977,988 $ 887,770 $ 1,146,626 30 I�SPER Town of Prosper Adopted Departmental Budget pTOWN °F Fiscal Year, 2007-2008 i Summary of Revenue Fund: GENERAL FUND 10 Department: Court ZQ 4410 Fines 106,481 105,000 105,500 120,000 Security Fee 4610 Interest Income 181 200 150 200 4910 Other Revenues 4996 Transferin Totals $ 106,662 $ 105,200 $ 106,650 $ 120,200 31 A B C D Revenue Projected Actual Budgeted Revenue Adopted Budget Account Revenue FY Current F Y Current FY for Code Title of Account 2005-2006 j 2006-2007 2006-2007 FY 2007-2008 4410 Fines 106,481 105,000 105,500 120,000 Security Fee 4610 Interest Income 181 200 150 200 4910 Other Revenues 4996 Transferin Totals $ 106,662 $ 105,200 $ 106,650 $ 120,200 31 Town of Prosper Adopted Departmental Budget P TOWN � � , Fiscal Year, 2007-2008 1`'�,► Summary of Expenditures Fund: GENERAL FUND 10 Department: Court 70 5110 A B C D 38,959 5115 Expenditures Projected 800 7,852 Actual Budgeted Expense Adopted Budget Account Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 1 2006-2001 FY 2007-2008 5110 Salaries & Wages 35,289 38,930 37,461 38,959 5115 Salaries - Overtime 5,992 800 7,852 8,000 6120 Salaries - Leave 693 - - - 5125 Salaries - Sick - - - 750 6140 Salaries - Longevity 1,000 1,000 1,000 1,000 6145 Social Security Expense 2,629 2,525 2,997 2,973 6160 Medicare Expense 615 591 670 695 5155 SUTA Expense 63 270 200 270 6160 Health Insurance 4,309 4,433 4,433 4,074 6166 Dental 392 399 399 312 5170 Life Insurance 125 165 165 45 5173 ADSD 23 - - 123 5180 TMRS Expense 2,851 2,540 3,500 3,995 6185 Short/Long Term Disability 292 323 388 343 6190 Contract Labor 1,920 5210 Supplies 1,481 3,000 2,000 3,000 5212 Building Supplies 624 600 20 500 5230 Due and Subscriptions 146 350 175 350 6240 Postage & Delivery 988 1,100 800 1,200 6250 Publications 35 150 50 100 5270 Bank Charges - - - 100 5280 Printing & Reproduction 1,448 1,500 900 1,000 6290 Miscellaneous 250 - - 200 5310 Rental Expense - - - 8,550 5363 Gas/Oil/Inspections - - - 5400 Uniform Expense 478 300 150 150 6418 IT Fees 1,120 1,500 1,500 2,500 6420 Municipal Court/Judge Fees 6,050 9,500 8,500 9,750 6425 State Fine Expense 42,682 38,000 40,000 60,000 6430 Legal Fees 72 690 300 500 5520 Telephone 75 200 600 650 5626 Electricity 3,600 6530 Travel/Meals/Lodging Expense 215 1,000 400 1,000 5533 Mileage Expense 483 600 350 500 5536 Training / Seminars 185 1,000 300 500 6140 Capital Expenditures -Equip 1,084 - - - Totals $ 111,686 $ 111,466 $ 115,110 $ 157,610 32 FIDE Igo Ira Fires Marshall Doug Tyson A Shift 9 901 t C Shilt Fire Captain Fire Craplsin Fire Captain Technology - Fire - EMS oporertlons L «rte Smltt� •�_�"_. � Stuart 1, ^ Fuat't hter! Fire fighter( Flrotfgtttar! Flrefii hter! Flrafl kited 9 F,aCem�lc Ftrailgtttrtrf �Iretlghterrl g FtreR�hter! 9 Firetigftt4� Paramedic Paramedic Rram'c4iC Pnralhedic Paramedic PatrarrtactJr Paramedic Pwarnedle lasrari Dwayne kh Karrf9: SCratlGIC hlaegan S c1C4 Mi+ntl?', Gfaham Norvefi Revenue & Expense Summary 33 rojec ed Adopted Actual Budgeted Year End 1 Budget 1 2005-2006 2006-2007 2006-2007 2007-2008 33 avenues 1 312,4291 142,0001 147,2501298,800 x turves T 971,401 1 11,255,76-21 1,158,830 1 17595,479 33 Town of Prosper, Texas , uftwi. Fire 0 E M S • Continuing training to ensure fire personnel are qualified and certified to perform the required duties expected of them. • All manuals are a constant work in progress as standards and ordinances change. Current manuals are Fire Department S.O.G.'s and Lifeline EMO. • Completed Install of all storm sirens for Prospers early warning system • New software for computer EMS reporting. • Worked with GIS to produce a map book for emergency services. • Hired Fire Marshal • Regularly examine programs and services to enhance service levels. • Provide Fir RMS service at a level that our citizens and council expect. • EMS charges for services will be reviewed. • Lower ISO rating to help lower homeowners' insurance rates. • Increase staffing levels to accommodate growth of Town. • Continue to expand on Storm Warning system. + Salary Survey adjustment. 34 Town of Prosper c Adopted Departmental Budget TOWN � T� Fiscal Year, 2007-2008 J, Summary of Revenue Fund: GENERAL FUND 10 Department: Fire 30 4030 Miscellaneous A B C D Other Permits - - - Actual Revenue Budgeted Projected Revenue Adopted Budget Account 135,000 Revenue FY Current F Y Current FY for Code Title of Account 2005-2006 1 2006-2007 2006-2007 J FY 2007-2008 4411 Collin Co. Fire Association 6,069 4,000 11,000 6,000 4440 4030 Miscellaneous 4230 Other Permits - - - - 4310 Charges for Services 289,680 134,000 134,000 135,000 4315 Fire Inspections 225 4,000 - 5,000 4410 Fines - - - - 4411 Collin Co. Fire Association 6,069 4,000 11,000 6,000 4440 Accident Reports 50 - - - 4510 Grants - - 2,250 152,800 4530 Contributions 16,405 - - - 4610 Interest Income - 4810 Other Revenues Totals $ 312,429 $ 142,000 $ 147,250 $ 298,800 35 P PE SR. Fund: GENgRAL FUND - 10 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: M 30 5110 Salaries & Wages A B C D 5115 Salaries - Overtime 127,442 Expenditures 112,908 115,000 6120 Salaries - Leave Time 2,533 Budgeted Projected Adopted Budget Account Salaries -Sick Time Actual Expense Current FY Expense Current for Code Title of Account FY 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 5145 5110 Salaries & Wages 407,856 539,732 454,043 663,864 5115 Salaries - Overtime 127,442 112,908 112,908 115,000 6120 Salaries - Leave Time 2,533 - - - 5125 Salaries -Sick Time 865 - - - 5140 Salaries - Longevity 5,175 6,975 6,775 7,600 5145 Social Security Expense 33,116 40,896 38,376 49,799 5150 Medicare Expense 7,745 9,564 5,557 11,647 5155 SUTA Expense 738 4,320 2,485 5,130 6160 Health Insurance 39,902 44,334 41,404 46,850 5165 Dental 3,448 3,992 3,194 3,582 5170 Life Insurance 1,310 1,250 1,628 518 5171 Life Insurance Supplement 7,565 7,566 8,626 8,626 5173 AD & D 235 - - 1,860 5180 TMRS Expense 32,624 41,253 40,921 61,470 5185 Short/Long Term Disability 3,353 6,022 4,353 4,460 5190 Contract Labor 974 2,320 2,320 2,320 5191 Hiring Cost 536 200 200 1,525 5193 Record Retention - 240 - 250 5194 Fire Dept Annual Phy & Health Screening 9,735 16,200 16,200 16,200 5205 Contribution 8,536 - - - 5210 Supplies 10,645 11,000 11,000 8,400 5212 Building Supplies 4,223 4,700 4,700 5,550 5220 Office Equipment 522 1,500 1,500 1,500 5221 Fire Marshall Expense 8,000 5230 Dues and Subscriptions 1,092 1,790 1,790 1,785 5240 Postage & Delivery 316 500 500 500 5250 Publications 131 250 250 350 5260 Advertising - 500 500 500 5280 Printing B Reproduction - 500 500 500 5290 Miscellaneous 1,185 - - - 5320 Repair & Maintenance 10,973 18,400 18,400 13,400 5325 Copier Lease - - - 5330 Copier Expense 147 250 250 250 5335 Radio ! Video Repairs 755 21,450 21,450 37,950 5340 Building Repairs 1,605 13,350 13,350 6,750 5350 Vehicle Expense 11,374 9,650 9,650 14,000 5353 Gas/Grease/OiUlnspections 19,882 20,350 20,350 20,345 5400 Uniform Expense 4,965 8,000 8,000 8,800 5410 Professional Services 1,044 15,000 15,000 15,000 5418 IT Fees 6,600 5430 Legal Fees 18 - - - 36 Fund: GENERAL FUND 10 Department: Fir 30 5440 EMS Expense A is C D 79,204 5450 Dispatch Expense Expenditures 11,140 11,140 10,150 5465 Budgeted Projected Adopted Budget Account - Actual Expense Current FY Expense Current for Code Title of Account FY 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 5440 EMS Expense 55,755 75,610 75,610 79,204 5450 Dispatch Expense 10,084 11,140 11,140 10,150 5465 Public Relations - - - 5480 Contracted Services 17,703 28,660 28,660 23,524 5520 Telephone 4,616 5,720 5,720 8,020 5521 Cell Phones 5,181 4,500 4,500 7,700 5522 Pagers 1,473 1,800 1,800 2,100 5523 Water - - _ 5524 Gas 4,712 5,600 5,600 7,000 5525 Electricity 18,827 24,000 24,000 20,600 5530 Travel Expense 851 1,000 2,500 2,000 5533 Mileage Expense 778 1,500 1,500 1,500 5536 Training / Seminars 7,467 9,000 9,000 11,950 5610 Fire Fighting Equipment 3,515 12,670 12,670 18,250 5630 Safety Equipment 16,090 24,250 24,250 24,260 6110 Capital Expenditures 4,661 - - - 6140 Capital Expenditures -Equip 57,123 17,250 17,600 108,350 6160 Capital Expenditures -Vehicles - 68,100 68,100 120,000 Totals $ 971,401 $ 1,255,762 $ 1,158,830 $ 1,595,479 37 STREETS Wastewater Operator Sherman Brown lhlafntenance Workers p Dustin Oat'C Alphomw Williams r �sf�ltrr< Public Works 01'r" F"rants. Jatorntn f Parks Maintenance Worker Saul Benitez Public Warks Construction Inspector Maintenance Worker Tony Acevedo Sireat Superintendent iManuet Forya Maintenance Worker Roberto Majus 1. - — _j Revenue & Expense Summary Water operator Devon Kennedy avenues - I _ IF-xpenditures 1 223,774 1 339,339 1 332,4491 55 38 r0iec pte Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 avenues - I _ IF-xpenditures 1 223,774 1 339,339 1 332,4491 55 38 pepaMnwi: S1 t'ecis Maintain street and traffic safety through the Street Improvement Program, drainage work, sidewalk and curb repair and pothole repair. This responsibility also includes the maintenance of signs, makings, maintenance and operation of school zone flashers, and street lighting. • Improve East First Street from Custer Road to Coit Road. • Continuing training to ensure personnel are qualified and certified to perform the required duties expected of them. All manuals are a constant work in process as laws and ordinances change. Current manuals are updated as needed. • Developed Street Repair Plan and implemented the plan by replacing 3 streets. • Maintained roadway ditches. • Proactively responded to in climate weather by sanding Town Farm to Market roads. • Maintained out lying gravel roads. ■ Will regularly examine programs and services to reduce operating costs or enhance service levels with cost increase. • Streamline operations process to ensure customer friendly service. • Develop a preventative maintenance program for the Street Department which includes patching, replacing and sealing concrete and asphalt roadways. • Develop a drainage maintenance program which will includes mowing, silt removal, regarding and structure maintenance. • Set sidewalk repair procedure and get Town Council approval. • Set up computer driven vehicle maintenance program using the fuel system and mileage to ensure proper vehicle maintenance is performed. • Upgrade all major roadway signage to high reflective sheeting which would include stop signs, and speed limit signage. * Upgrade the Down Town street signs with the new logo and replace sign posts with break away mounts. 39 r r Town of Prosper �'' Adopted (Departmental Budget r � " OFR Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: Streets 40 5110 A 1 B C D 71,018 5115 Expenditures Projected 5,000 5,000 Actual Budgeted Expense Adopted Budget Account Expense FY Current IY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 1 FY 2007-2008 5110 Salaries & Wages 55,610 57,373 57,373 71,018 5115 Salaries - Overtime 3,412 5,000 5,000 5,000 5120 Salaries - Leave Time 1,072 - - - 6140 Salaries - Longevity 1,825 2,000 1,450 2,000 6146 Social Security Expense 3,872 3,991 3,991 4,837 5150 Medicare Expense 905 933 933 1,131 5155 SUTA Expense 268 540 540 540 5160 Health Insurance 8,617 8,867 8,867 8,148 5166 Dental 784 798 798 623 6170 Life Insurance / AD & D 204 250 250 90 5173 AD & D 44 - - 191 6180 TMRS Expense 4,046 4,009 4,009 6,499 5186 Short/Long Tenn Disability 451 788 788 532 5190 Contract Labor - - - - 6191 Hiring Cost - 40 40 - 5210 Supplies 1,729 7,000 5,000 4,400 5220 Office Equipment 3,600 5230 Dues & subscriptions 500 5290 Miscellaneous - - - 5310 Rental Expense 2,500 6320 Repair & Maintenance - 6,000 5,000 10,500 5321 Signal Light Repairs 180 - - 6340 Building Repairs 6,000 5350 Vehicle Expense 5,908 6,000 5,000 4,800 5353 Gas/Grease/OiUlnspections 215 8,000 6,000 5,500 5400 Uniform Expense 309 1,400 1,400 1,670 5480 Contracted Services 31,125 128,000 128,000 32,800 5520 Telephone - 510 510 500 6521 Cell Phones 472 2,000 1,500 1,300 5526 Electricity 39,090 40,000 45,000 50,000 6530 Travel/Lodging/Meals Expense 600 5636 Training / Seminars 600 6620 Tools & Equipment 6,773 5,840 6,000 5,700 5630 Safety Equipment - 2,000 2,000 980 5640 Signs & Hardware 12,376 8,000 8,000 8,500 40 Fund: GENERAL FUND 10 Department: Streets 40 6650 Maintenance Materials 30,024 40,000 35,000 44,000 6110 Capital Expenditures 6,715 - - - 6140 Capital Expenditures -Equip 7,750 - - 18,000 6160 Capital Expenditures -Vehicles - - - 28,000 Totals $ 223,774 $ 339,339 $ 332,449 $ 331,059 41 A B C D Expenditures Projected Actual Budgeted Expense Adopted Budget Account Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 6650 Maintenance Materials 30,024 40,000 35,000 44,000 6110 Capital Expenditures 6,715 - - - 6140 Capital Expenditures -Equip 7,750 - - 18,000 6160 Capital Expenditures -Vehicles - - - 28,000 Totals $ 223,774 $ 339,339 $ 332,449 $ 331,059 41 PARIS & RECREATION Wastewater Operator � Sherman Brawn Maintenance Workers Dustin Clark Alphonso Wolllams PutAlc Works Manayt:r i Fronk Jaromin Malnton.ance J , a Parks Malmonrnco Public Works — Construdon Inspector , Ma6ntenence Worker O Tony Acevedo J Expense Summary Street Superintendent Manuel Parga Maintenance Worker Roberto Alelos Water Operator Devon Kennedy evenue3 - - Expendltures 29,561 1 86,418 1 74,2481-- 42 , 4 42 Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 evenue3 - - Expendltures 29,561 1 86,418 1 74,2481-- 42 , 4 42 D „t: Parks & Recreation The mission of the Parks and Recreation Department is to ensure that the leisure needs of the Prosper community are met. This is accomplished by providing our residents with opportunities for year round public recreation and leisure services. The Town current has 5 active parks consisting of 24 acres. • Hired new employee to work part-time for Parks and part-time for Public Works. • Continuing training to ensure personnel or qualified and certified to perform the required duties expected of them. • All manuals are a constant work in progress as ordinances change. Current manuals are being reviewed and new one established • Made significant improvements to the downtown park area. • Took over the Pecan Park maintenance • Will regularly examine programs and services to reduce operating costs or enhance service levels with cost increase. • Streamline operations process to ensure customer friendly service. • Develop a preventive maintenance program for Parks Department. • Continued improvement to Town parks to enhance the enjoyment of our citizens. • Review charges & fees for park services (lights). • Reconstruct Down Town ball fields by installing new irrigation and level up on fields. • Out source roadway mowing to enable current employees to spend time on recreation activities. • Outsource chemical applications on the fields for weed control. 43 Town of Prosper 1SPER Adopted Depart mental Budget P°''�NO Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: Parks 60 5110 Salaries S Wages A B C D 5146 Social Security Expense 5150 Expenditures Projected SUTA Expense 6160 health Insurance Actual Budgeted Expense Adopted Budget Account AD & D - Standard Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 200('x2007 1 FY 2007-2008 5110 Salaries S Wages 5115 Salaries - Overtime 5140 Salaries - Longevity 5146 Social Security Expense 5150 Medicare Expense 6156 SUTA Expense 6160 health Insurance 6166 Dental 5170 Life Insurance / AD & D 5173 AD & D - Standard 5180 TMRS Expense 5185 Short/Long Term Disability 5190 Contract Labor 6210 Supplies 5212 Building Supplies 6230 Dues & Subscriptions 6240 Postage & Delivery 5280 Printing & Reproduction 5290 Miscellaneous 6320 Repair & Maintenance 5360 Vehicle Expense 5353 Gas/Oil/Grease/inspection 6400 Uniforms 5430 Legal Fees 6480 Contracted Services 5620 Telephone 6521 Cell Phone 5623 Water 6525 Electricity 5530 Travel/Lodging/Meals Expense 5636 Training/Seminam 6600 Special Events 5630 Safety Equipment 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles - 25,690 18,500 45,433 - 3,000 2,000 2,000 - 75 75 775 - 1,783 1,783 2,989 - 417 400 699 - 270 270 540 4,433 2,200 7,129 - 399 250 545 - 45 20 90 - - - 225 - 1,802 1,000 4,016 - 354 200 500 2 150 150 900 1,800 400 - 500 400 500 6,596 9,000 9,000 16,300 313 - 500 2,600 1,650 3,000 2,000 4,500 - 300 300 1,650 918 - - - - 4,000 4,000 72,500 - 900 900 500 1,250 - - - 12,000 20,082 30,000 30,000 19,000 400 400 - 300 300 800 - - - 21,108 Totals $ 29,561 $ 86,418 $ 74,248 $ 221,549 44 INSPECTIONS/CODE ENFORCEMENT y Nam, 1„ r .om m_ - _ -- • 3.�i�_ _ - _ ..ins" I Dlrewor of Developrnow Srrvirrns Hulan Wer)b Building Official Town Engineer Sr. Town Planners Bryon ,Ai4enbaugh Mulpn Webb Asulstant to the Building Official 1 Permit Trechnlcallon I Trudy vnflrgn IILII I Pamela Evans Senior Sullding inspector Code Entorcemant Officer l Slswa f=reeman Oevld Lsdi%la i Plumbingilaepector 6ulldinglnspector Building Inapector fUffy Sandoval Wayna'3nall Lee Doolln 1 Revenue & Expense Summary IFIevenues 668,3041742,740 1 769,090 1793,200 Ex enditures 324,090 1 494,212 1 462,796 15 , 45 Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 IFIevenues 668,3041742,740 1 769,090 1793,200 Ex enditures 324,090 1 494,212 1 462,796 15 , 45 nepertm�t: Inspections / Code 1, nforcement / Health Inspections The mission of the Building Inspections Division is to provide quality inspections of both residential and commercial projects to ensure they provide the minimum requirements to safeguard the public health, safety and welfare of our citizens, business community and to ensure the safety of emergency personnel during emergency operations. This is achieved through plan review prior to the issuance of a permit and on-site inspections, after permit issuance, to verify code compliance throughout the construction process. The mission of the Code Enforcement Division is to provide quality services to a rapidly growing community for the protection and promotion of the health, safety, welfare, property values and environment of the citizens of the Town of Prosper. Due to increased building the Inspections Department hired one additional Building Inspector. ■ Continuing training to ensure personnel are properly licensed and certified to perform the required duties expected of them. Cross trained building inspector through field training and training courses which resulted in inspector successfully completing the State of Texas Plumbing Inspector Certification Exam. • Increase staff by replacing current part time staff by adding a full time administrative person and a plans examiner to maintain a consistent level of service expected with continued growth in the town. • Work towards reduction in permit plan review turnaround time dependent on additional staff and pace of growth in town. • Develop proactive code enforcement program dependent on additional staff and pace of growth in town. • Continue proactive training of all staff in effort to keep up with new practices and procedures. Formally adopt the 2006 International Code Council code series of Building, Residential, Mechanical, Electrical, Plumbing, Energy Conservation, Fuel Gas and Property Maintenance Code and the 2005 National Electric Code. Provide guidance and support to the Fire Department for adoption of the 2006 International Fire Code. ■ Develop annual non-residential inspection and Certificate of Occupancy inspection program in conjunction with the Fire Department. Inspections would be geared to life safety, occupancy and zoning issues. 46 Town of Prosper '` Adopted Departmental Budget P N E Fiscal Year, 2007.2008 Summary of Revenues Fund: GENERAL_ FUND 10 Department: inspections/Code Enforcement 80 A B C D - Revenue Projected - 4012 Budgeted Revenue Adopted Account Actual Revenue Current F Y Current FY Budget for Code THIe of Account FY 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 4011 Permit Application Fee - - 100 - 4012 Saturday Inspection Fee - - _ 4013 Permit Expiration Fee 4014 Electronic Map Sub. Fee 4016 Public Inconvenience Fee - - - 4017 Registration Fee 600 4030 Miscellaneous - - - 4210 Building Permits 536,647 606,630 625,250 638,020 4230 Other Permits 95,146 112,290 95,140 89,935 4240 Plumb/Elect/Mech. Permits 3,412 7,120 1,500 3,245 4242 Re -Inspection Fees 31,595 15,000 41,000 15,000 4245 Health Inspection Fees 1,504 1,700 5,500 3,000 4910 Other Revenues - - - 44,000 Totals $ 668,304 $ 742,740 $ 769,090 $ 793,200 47 Town of Prosper Adopted Departmental Budget p TO N E � Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: Inspections 80 5110 Salaries & Wages A B C D 5115 Salaries - Overtime 9,120 Expenditures Projected 15,000 5140 Salaries - Longevity Actual Budgeted Expense Adopted Budget Account Social Security Expense Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 186,122 290,968 261,905 336,716 5115 Salaries - Overtime 9,120 10,000 15,000 15,000 5140 Salaries - Longevity 1,075 2,325 2,000 4,725 5145 Social Security Expense 12,172 18,804 16,553 22,122 5150 Medicare Expense 2,847 4,398 3,871 5,174 5155 SUTA Expense 1,000 2,160 1,622 2,700 5160 Health Insurance 15,504 26,600 26,600 28,517 6165 Dental 1,574 2,395 2,395 2,181 6170 Life Insurance / ADBD 461 800 1,022 315 5173 AD & D - Standard 83 - - 1,034 5180 TMRS Expense 12,433 17,317 17,317 27,337 5185 Short/Long Term Disability 1,091 3,633 2,000 2,603 6180 Contract Labor 1,814 2,300 - - 6191 Hiring Cost 39 160 160 80 5210 Supplies 5,357 7,200 7,200 7,200 5212 Building Supplies 818 480 500 520 5220 Office Equipment 2,982 5,300 5,500 6,134 6230 Dues S Subscriptions 1,750 4,527 4,527 5,000 5240 Postage & Delivery 145 400 400 400 5250 Publications 161 550 550 500 5260 Advertising - 500 500 500 6270 Bank Charges - 200 200 200 5280 Printing & Reproduction 1,748 5,255 5,300 5,300 5280 Miscellaneous 60 - - 100 5320 Repair & Maintenance 236 1,500 1,500 1,500 5340 Building Repairs 1,870 5,000 5,000 9,115 5350 Vehicle Expense 2,254 1,500 1,000 1,500 6353 Gas/Greass/Oil/Inspections 5,756 10,000 7,000 10,000 5400 Uniform Expense 1,528 3,000 3,000 3,730 5410 Professional Services 4,784 4,500 5,500 6,500 6416 Engineering Fees 600 1,000 1,000 1,000 5416 IT Fees 3,293 4,000 7,000 6,000 5430 Legal Fees 632 2,000 3,000 3,000 5465 Public Relations 196 500 500 300 6480 Contracted Services - 13,660 13,660 13,660 48 Fund: GENERAL FUND 10 Department: Inspections 80 5520 Telephone A B C D 7,360 6521 Cell Phones Expenditures Projected 4,500 10,897 Actual Budgeted Expense Adopted Budget Account 500 Expense FY Current FY Current FY for Code Title of Account 1 2005-2006 1 2006-2007 2006-2007 FY 2007-2008 5520 Telephone 5,081 5,280 5,400 7,360 6521 Cell Phones 3,970 5,200 4,500 10,897 5525 Electricity 286 500 500 500 5524 Gas (Building) - - - - 5630 Travel I Lodging / Meals Expense - 1,500 1,500 2,000 6633 Mileage Expense - 250 100 250 6536 Training / Seminars 4,973 3,850 4,500 5,850 5620 Tools S Equipment 475 5,686 4,000 4,000 5630 Safety Equipment 403 950 950 1,250 6110 Capital Expenditures 846 1,200 1,200 600 6140 Capital Expenditures -Equip - - - 4,580 6160 Capital Expenditures -Vehicles 28,552 16,864 16,864 - Totals 324,090 494,212 462,796 567,951 49 PLANNING / ENGINEERING Revenue & Expense Summary avenues 1 74,092 1 66,000 1 133,00 1,00 x n tures 158,610 1 213,509 1 180,360419,005 50 Projected op e Actual BudgetedYear End Budget 2005-200612006-2007712006-20071 2007-2008 avenues 1 74,092 1 66,000 1 133,00 1,00 x n tures 158,610 1 213,509 1 180,360419,005 50 Town of Prosper, Texas � t epafttmt: Planning The Planning Department supports the Town Council, Planning & Zoning Commission, Parks & Recreation Board and the Board of Adjustment relating to the Town's zoning and development services. The department maintains the Town's Zoning Ordinance and Subdivision Ordinance. The department also coordinates Development Review Committee (includes zoning and development cases) and population projections. • In January 2007, the Planning & Zoning Commission held their first regular meeting to act on development cases and provide the Town Council with recommendations on zoning cases. Town staff coordinates the scheduling of meetings, the agenda, and the packet. The Planning & Zoning Commission meets twice a month. • The Comprehensive Plan was amended to include criteria to consider in evaluating whether to allow residential or non-residential development to deviate from the Future Land Use Plan. • Met with downtown property owners, held two joint work sessions with the Town Council and the Planning & Zoning Commission, and brought public hearings before the Planning & Zoning Commission and the Town Council to amend the Zoning Ordinance's Downtown Districts, create the Downtown Retail District, and to rezone approximately 56.7 acres of downtown Prosper. • Updated the Town's Zoning Map and the Planned Development files. • The Zoning Ordinance was amended to include strict screening and height requirements for open storage. • The Subdivision Ordinance was amended to require six foot (6') sidewalks along thoroughfares, five foot (5') sidewalks along collectors and residential streets, and to extend the minimum cul-de-sac length to six hundred feet (600'). • Scheduled meetings of the Mahard Ranch Committee to discuss the proposed development by Forest City. • Evaluate and update the Zoning Ordinance, Subdivision Ordinance, and the Comprehensive Plan as needed or as instructed by the Town Council or the Planning & Zoning Commission. • Examine services to maximize efficiency and effectiveness to minimize operating costs while enhancing the level of service. • Prioritize customer service by maximizing the amount of information on the Town's website including copies of all Planned Development Ordinances. Focus on minimizing the response time to voicemails and emails from citizens and developers. • Review the fee schedule. 51 nwa=,t: Lngineering The Engineering Department supports the Town Council, Planning & Zoning Commission, Parks & Recreation Board and the Board of Adjustment relating to the Town's engineering services. The department maintains the Town's design standards, construction details, and construction specifications. The department also coordinates its plan review with the Development Review Committee, performs transportation planning, manages capital improvement projects and administers the floodplain. • Updated the Impact Fee Ordinance and adopted a Capital Improvement Plan. • Created a right-of-way ordinance to manage the franchise utility companies constructing improvements in the Town's right-of-way that was adopted by Town Council on January 23, 2007. • Current staff performs all reviews of engineering plans for new residential and non-residential developments in the Town that were previously done by a consultant. • Current staff performs all reviews of water well permits that were previously done by a consultant. • Bid the Preston Road Elevated Storage Tank project. • Submitted projects for consideration by the Collin County Transportation Committee for a November 2007 Bond Election. • Completed evaluation of the sanitary sewer alternatives to the west side of Prosper and is negotiating contract for membership services with the Upper Trinity Regional Water District. • Acquired the necessary easements to allow the construction of the Shaddock Farms Sewer Line that will provide sewer to Ariana Estates, Shaddock Farms, and Saddlecreek. • The final acceptance procedure was amended in the Subdivision Ordinance from previously requiring Town Council approval to allow the Town staff final acceptance of the projects. • The Subdivision Ordinance was amended to require six foot sidewalks along thoroughfares, five foot sidewalks along collectors and residential streets, and to extend the minimum cul-de- sac length to 600 feet. • Examine the proposed water system on the west side of Prosper and evaluate the ability to serve through Upper Trinity Regional Water District. • Evaluate and update the Drainage System Design Standards. • Examine services to maximize efficiency and effectiveness to minimize operating costs while enhancing the level of service. • Prioritize customer service by maximizing the amount of information on the Town's website including copies of all design standards, construction details, and construction specifications. 52 I�SPER Town of Prosper Adopted Departmental Budget wNofFiscal Year, 2007-2008 P Summary of Expenditures Fund: GEUERAL FUND 10 Department: Engineering _ 5110 Salaries & Wages A B C D _ 5120 Salaries - Leave Time Expenditures Projected 5125 Account Actual Expense Budgeted Expense Current FY Current FY Adopted Budget for Code Tltle of Account FY 2005-2006 2006-2007 2006-2007 i FY 2007-2008 1,340 5110 Salaries & Wages 91,936 5115 Salaries - Overtime _ 5120 Salaries - Leave Time _ 5125 Salaries - Sick 5140 Salaries - Longevity 475 5145 Social Security Expense 5,729 6160 Medicare Expense 1,340 5155 SUTA Expense 270 5160 Health Insurance 4,074 5165 Dental 312 5170 Life Insurance / AD & D 45 5173 AD & D - Standard 162 5180 TMRS Expense 7,698 5185 Short/Long Term Disability 585 5189 Administrative Fees 5190 Contract Labor _ 5191 Hiring Cost _ 5193 Record Retention _ 5210 Supplies 1000 5212 Building Supplies 300 5220 Office Equipment 950 5230 Dues & Subscriptions 750 5240 Postage & Delivery 150 5250 Publications 5260 Advertising _ 5280 Printing & Reproduction 125 5290 Miscellaneous 200 5310 Rental Expense _ 5320 Repair & Maintenance 5325 Copier Lease _ 5330 Copier Expense _ 5340 Building Repairs 1,000 5350 Vehicle Expense 5353 Gas/Groase/Oil/lnspections _ 5400 Uniform Expense 60 5410 Professional Services 5412 Audit Fees 5416 Engineering Fees _ 5418 IT Fees 850 5430 Legal Fees 5,000 5480 Contracted Servlces _ 53 Fund: E L FUNQ 10FUN Department: Engineering _ 5520 Telephone A B C D 5525 Electricity 500 Expenditures Projected 1,200 Account Mileage Expense Actual Expense Budgeted Current FY Expense Current FY Adopted Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 6140 5520 Telephone 1,725 5521 Cell Phones 1,580 5525 Electricity 500 5530 Travel/Lodging/Meals Expense 1,200 5533 Mileage Expense 1,000 5536 Training / Seminars 1,500 5620 Tools S Equipment 200 6110 Capital Expenditures 6140 Capital Expenditures -Equip _ 6160 Capital Expenditures -Vehicles Totals $ E vl $ 130,716 Town of Prosper ��`` Adopted Departmental Budget OF Fiscal Year, 2007-2008 Summary of Revenue TOWN e Fund: GENERAL. FUND 19 Department: Planning 29 4030 Miscellaneous 8,701 A S C D 25,000 45,000 25,000 4225 Revenue Projected 60,000 4230 Other Permits - Actual Budgeted Revenue Adopted Budget Account 250 Revenue FY Current Fiscal Current FY for Code Title of Account 2005-2006 1 Year 2006-2007 2006-2007 FY 2007-2008 4030 Miscellaneous 8,701 1,000 4,000 750 4220 Zoning Fees 18,130 25,000 45,000 25,000 4225 Plat Fees 46,261 40,000 80,000 60,000 4230 Other Permits - - 4,000 5,000 4910 Other Revenues - - - 250 Totals $ 74,092 $ 66,000 $ 133,000 $ 91,000 56 Town of Prosper '' Adopted Departmental Budget TOWN E n Fiscal Year, 2007-2008 11, Summary of Expenditures Fund: GENERAL FIND 10 Department: Planning 90 5110 Salaries & Wages A B C D 123,859 5115 Salaries - Overtime Expenditures Projected - 2,000 Actual Budgeted Expense Adopted Budget Account - Expense FY Current FY Current FY for Code Title of Account 2005-2006 J 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 75,213 106,000 71,154 123,859 5115 Salaries - Overtime -- - - 2,000 6120 Salaries - Leave Time 4,924 - - - 5140 Salaries - Longevity 650 275 25 450 5146 Social Security Expense 5,009 6,595 4,413 7,831 5160 Medica re Expense 1,171 1,542 1,032 1,831 5166 SUTA Expense 755 540 416 810 5160 Health Insurance 3,704 8,867 6,548 10,185 5165 Dental 337 798 532 779 6170 Life Insurance / AD&D 161 190 256 113 6173 AD & D - Standard 29 - - 334 5180 TMRS Expense 3,377 6,664 4,771 10,522 5185 Short/Long Term Disability 269 1,458 521 884 5190 Contract Labor 1,300 1,950 5,000 1,950 5191 Hiring Cost - 40 40 40 5210 Supplies 2,916 2,400 4,500 3,000 5212 Building Supplies 218 300 300 300 6220 Office Equipment 187 2,500 2,500 6,200 5230 Dues / Subscriptions 678 600 600 1,125 5244 Postage & Delivery 58 200 510 250 5250 Publications - - - 125 5260 Advertising - - - 40 6280 Printing & Reproduction 495 1,000 500 500 5290 Miscellaneous - - - - 5310 Rental Expense 5320 Repair & Maintenance - - - _ 5326 Copier Lease 2,486 2,400 2,400 5,200 5330 Copier Expense - - - - 6340 Building Repairs 505 3,000 3,000 2,500 6350 Vehicle Expense - - - _ 6410 Professional Services 38,000 38,000 38,000 41,026 6416 Engineering Fees 6418 IT Fees 1,013 6,470 6,470 850 6430 Legal Fees 8,578 8,000 10,000 45,000 5436 Legal Notices 1 Filings 296 2,000 1,750 2,000 56 Fund: GENERAL FUND 1 Department: Planning 90 6480 Contracted Services 6620 Telephone A B C D 6521 Cell Phones 1,055 Expenditures Projected 3,000 5526 Electricity Actual Budgeted Expense Adopted Budget Account Meals/Lodging Expense Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2008.2007 FY 2007-2008 6480 Contracted Services 6620 Telephone 4,835 5,380 5,380 8,940 6521 Cell Phones 1,055 1,440 1,440 3,000 5526 Electricity - 500 500 500 5630 Meals/Lodging Expense - 1,000 1,000 1,000 6533 Mileage Expense 140 600 750 1,500 6636 Training / Seminars - 1,000 1,250 3,645 5640 Signs and Hardware - 6110 Capital Expenditures 250 - 3,000 - 6140 Capital Expenditures -Equip - - - _ 6160 Capital Expenditures -Vehicles - 1,800 1,800 - Totals $ 168,610 $ 213,609 $ 180,360 $ 288,288 57 IN T OWN PER. ADOPTED BUDGET FY 2007 - 2008 PUBLIC WORKS FUND 20 PUBLIC WORKS Wastewater operator 5'�rnlar� [3rcrwn Maintenance Worker Dustin Giant Alphormo Wdlliarns Public Works � Construction Inapaclor + MAIMOnsnce Worker cony Ai. 11 Sheat Sllperintendmnt Manuel Paro�j i Maintenance Worker Hoberl a Alejos Revenue & Expense Summary Water oporator Devon Kefinedy Revenues 3,742,356 1 3,266,665 1 3,266,500 1 3,867,000 Expenditures 1,087,687 1 3,438.653 1 3,295,019 1 3,851,914 =�7 Projected Adopted Actual Budgeted 1 Year End 1 Budget 1 2005-2006 2006-2007 2006-2007 2007-2008 Revenues 3,742,356 1 3,266,665 1 3,266,500 1 3,867,000 Expenditures 1,087,687 1 3,438.653 1 3,295,019 1 3,851,914 =�7 r TC}VYN �?�' P S P E Town of Prosper FY 2007 - 2008 Town Budget Public Works Fund Summary Net Assets / Reserves WATER 1 SEWER FUND OPERATING REVENUES Water and Sewer charges $ 2,407,911 $ Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description Actual Budgeted Projected Budget WATER 1 SEWER FUND OPERATING REVENUES Water and Sewer charges $ 2,407,911 $ 2,045,000 $ 2,055,000 $ 2,961,480 Sanitation charges $ 282,266 $ 240,000 $ 300,000 $ 348,000 Water and Sewer connections $ 435,395 $ 300,000 $ 245,000 $ 400,000 Service initiation fees $ 477,656 $ 655,165 $ 575,000 $ 25,520 Miscellaneous $ 81,500 $ 1,500 $ 1,500 $ 51,000 Total Operating Revenues $ 3,684,729 $ 3,241,665 $ 3,176,500 $ 3,786,000 NON-OPERATING REVENUES Interest Income $ 57,627 $ 25,000 $ 90,000 $ 81,000 TRANSFERS IN Operating transfers $ $ $ $ Transfers in from other funds $ $ $ - Total transfers in $ $ $ - Total Revenues $ 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 OPERATING EXPENSES Personnel services $ 327,687 $ 449,163 $ 458,404 $ 526,401 Materials and supplies $ 418,266 $ 820,250 $ 1,280,250 $ 838,563 Contractual services $ 1,354,905 $ 1,908,600 $ 1,526,060 $ 2,102,290 Depreciation $ 188,747 $ 168,000 $ 282,234 $ 300,000 Total Operating Expenses $ 2,289,605 $ 3,346,013 $ 3,546,948 $ 3,767,254 NON-OPERATING EXPENSES Interest expense and fiscal charges 362,714 $ 92,640 $ 478,514 $ 84,880 Net Income (loss) before operating transfers $ 1,090,037 $ (171,987) $ (758,962) $ 15,086 TRANSFERS Transfers in (out) for debt service $ 404,090 $ $ 443,379 $ Transfers in (out) for capital assets $ 1,160,542 $ - $ 287,064 $ Total transfers $ 1,564,632 $ - 730,443 $ - Change In Net Assets $ 2,654,669 $ (171,987) $ (28,519) $ 15,086 Net Assets, beginning (as stated) $ 3,996,963 $ 6,651,632 $ 6,651,632 $ 6,623,113 Net Assets, ending $ 6,651,632 $ 6,479,645 $ 6,623,113 $ 8,638,199 160% Reserve $ 366,337 $ 535,362 $ 567,512 $ 602,761 80 Sanitfe Town of Prosper FY 2007 - 2008 Adopted Budget Public Works Fund Revenue Sources Service Initiation Fee Miscellaneous i e% 61 77% terest Town of Prosper FY 2007 - 2008 Adopted Budget Public Works Expenditures Interest Paid Personnel Services Contractual Services 54% 62 Materials & Supplies 22% nepanme�t: PIlliIic Works - Water The mission is to provide safe potable water at adequate pressure and in sufficient quantity with the highest standard of quality. To maintain the pump station facilities, water lines and other infrastructure at safe and operational levels. • The department hired one person to assist with water line repairs and other maintenance. • Ensured continuing education for personnel to secure and assure qualified and certified employees are performing the required duties expected of them. • Updated the Water Construction manual insure consistency and quality in water line construction. • Implemented the AMR meter reading system. • Acquired new software for accurate billing • Reviewed water rate structure. • Revised and upgraded SCADA program for monitoring of water consumption • Completed construction of 3MG ground water storage tank and Pump Station. • Created Public Works Construction notes to help Contractors, engineers and owners better understand the requirements. • Reduced the unaccounted water usage to state averages of less than 10%. • Will regularly examine programs and services to reduce operating costs or enhance service levels with cost increase. • Streamline operations process to ensure customer friendly service and return all inquiries within 1 day. • Develop a preventive maintenance program for valves, hydrants and blow offs. To help the Fire Department lower the ISO rating for the Residents. • Continued implementation of new water rate structure developed from rate study • Reduce water consumption by 5% thru citizen awareness. • Start a recycle station at Public Works. • Implement rehabilitation and replacement program of aging infrastructure. • Provide safe drinking water and highest standard of pressure and volume of water for fire protection. • Improve coordination with other City departments in development process. • Repair water leaks with in 24 hours. • Improve customer service to residents by becoming proactive versus reactive when possible. 63 Licpanment: Nubby Works - St ever The mission is to provide safe, effective sewer collection system and transport wastewater to the treatment facility in a safe and economical manner. To maintain wastewater treatment facilities and collection lines in accordance with regulatory guidelines. • The department hired a new Public Works Director with extensive knowledge and skills in waste water and collection and inspection. * Continuing training to ensure personnel or qualified and certified to perform the required duties expected of them. * Updated Sewer Construction manuals to help facilitate contractors, developers and engineers working in Prosper and ensure quality and reduce maintenance in the future. • Review charges & fees for services. • Reviewed new sewer rate structure. • Updated SCADA program for monitoring of Lift Stations. • Tied on to NTMWD and removed 200,000 gallons of waste water for the treatment plant. * Defined Public Works inspection of residential homes prior to Certificate of Occupancy. * Established Capital Improvement Plan for sewer line replacement. • Follow the Capital Improvements Plan for sewer line installation. • Reply to sewer backups within an hour. • Replace services on Broadway East of Colman to Church Street. • Streamline operations process to ensure customer friendly service. * Develop a preventive maintenance program to fix or replace manholes damaged for SO3 gases. * Continued development of Standard Operating Procedures for line replacement and upgrades. • Lower infiltration within the collection system too area standards. • Continuing training to ensure personnel or qualified and certified to perform the required duties expected of them. • Decommission waste water plant and become a collection system only. • Add odor control to all lift stations within 200 feet of homes and require odor control be installed to new lift stations. M Town of Prosper Adopted Departmental Budget P � P E Fiscal Year, 2007-2008 Summary of Revenue Fund: WATER FUND (PUBLIC WORKS) 20 Department: Public Warks _ 4000 Water / Sewer Initiation Fee A B C D 25,520 4005 Water Projected 2,000,000 2,000,000 2,320,000 4006 Revenue Budgeted Revenue Adopted Budget Account 553,000 Actual Revenue Current Fiscal Year Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 4000 Water / Sewer Initiation Fee 31,077 12,000 22,000 25,520 4005 Water 2,339,995 2,000,000 2,000,000 2,320,000 4006 Sewer 446,579 643,165 553,000 641,480 4007 Sanitation 282,266 240,000 300,000 348,000 4009 Late Fees 67,916 45,000 55,000 50,000 4010 Tap / Meter Fees 435,395 300,000 245,000 400,000 4011 Permit Application Fee - - - - 4012 Saturday Inspection Fee - - - - 4013 Permit Expiration Fee - - - 4014 Electronic Map Sub. Fee - - - - 4016 Public Inconvenience Fee - - - - 4017 Registration Fee - 4030 Miscellaneous - - - 4060 NSF Fees 75 500 500 500 4610 Interest Income 57,627 25,000 90,000 81,000 4910 Other Revenues 81,425 - - - 4911 Salvage/Recycle Materials - 1,000 1,000 500 Totals 8 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 65 It , Town of Prosper ' Adopted Departmental Budget P T� P E n Fiscal Year, 2007-2008 l� Summary of Expenditures Fund: WATER FUND (EUBLIQ WORK 22 Department: Public Work _ 5110 A B C ID 335,854 367,386 Expenditures Projected 18,818 10,000 Budgeted Expense Adopted Budget Account Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 1,677 5110 Salaries & Wages 227,970 335,854 335,854 367,386 5113 Salaries - Overtime 18,818 10,000 17,276 40,100 5120 Salaries - Leave Time 4,533 - - - 5125 Salaries - Sick 1,677 - - - 5140 Salaries - Longevity 1,300 3,375 3,150 3,775 6145 Social Security Expense 15,160 21,778 21,778 25,081 5150 Medicare Expense 3,546 5,093 5,093 5,866 5155 SUTA Expense 1,117 3,930 3,930 2,700 5160 Health Insurance 30,490 39,901 39,901 39,720 5165 Dental 2,736 3,593 3,593 3,037 5170 Life Insurance / AD & D 724 1,095 1,095 439 5173 AD & D - Standard 132 - - 971 5175 TML Expense (Insurance) - - - 5180 TMRS Expense 17,451 21,972 21,972 34,258 5185 Short/Long Term Disability 1,795 4,642 4,642 2,748 5189 Administrative Fees - - - - 5190 Contract Labor - - - - 5191 Hiring Cost 239 120 120 320 5193 Record Retention - 5,000 5,000 2,100 6210 Supplies 6,326 6,000 3,000 4,600 5212 Building Supplies 785 1,200 1,200 1,600 5220 Office Equipment 3,357 5,450 5,450 11,700 5230 Dues & Subscriptions 1,804 2,850 2,850 5,175 5240 Postage & Delivery 7,512 8,500 8,500 9,500 5260 Publications - - - 400 5260 Advertising 241 1,700 1,700 1,000 5270 Bank Charges 50 500 500 600 5280 Printing & Reproduction 5,312 2,550 2,550 6,980 5290 Miscellaneous 1,817 - - 2,500 5310 Rental Expense 3,750 2,500 2,500 13,000 5320 Repair & Maintenance 232 3,000 3,000 2,900 5321 Signal Lights Repairs - 500 500 - 5325 Copier Lease - - - - 5330 Copier Expense 83 500 500 2,200 5335 Radio / Video Repairs - - - 2,500 5340 Building Repairs 8,043 8,000 8,000 10,000 5350 Vehicle Expense 4,959 7,000 7,000 11,000 5353 Gas/Grease/Oil/Inspections 16,083 20,000 20,000 25,500 5400 Uniform Expense 1,332 3,000 3,000 6,510 6410 Professional Services 29,804 21,810 21,810 30,000 5412 Audit Fees 500 600 600 1,500 66 Fund: WATER FUND (PUBLIC WORM 20 Department: Public Works _ 5416 Engineering Fees A B C D 25,000 25,000 Expenditures Projected 5418 IT Fees Budgeted Expense Adopted Budget Account 14,300 Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2006 20,000 5416 Engineering Fees 62,775 25,000 25,000 17,000 5418 IT Fees 89 14,300 14,300 38,470 $430 Legal Fees 23,525 20,000 30,000 11,500 5470 Trash Collection 297,314 283,300 283,300 312,100 5480 Contracted Services 1,228 6,000 6,000 35,000 5520 Telephone 4,098 3,200 4,600 12,720 5621 Cell Phones 3,536 5,400 6,650 8,900 5522 Pagers 255 - - - 5624 Gas - Building 2,104 4,300 4,300 4,000 5525 Electricity 425,408 400,000 400,000 405,100 5530 Travel/Lodging/Meals Expense - 900 900 2,650 5533 Mileage Expense 258 500 500 2,248 5536 Training / Seminars 790 6,500 6,500 5,200 6540 Water Testing 16,539 15,000 15,000 20,500 5545 Meter Purchases 59,011 50,000 50,000 198,000 5550 Water Purchases 446,383 489,500 489,500 600,000 5560 Sewer Management Fees 41,346 225,000 225,000 605,500 5590 Interest Expense 320,798 376,527 - 5620 Tools & Equipment 1,185 5,200 5,200 10,000 5630 Safety Equipment - 2,500 2,500 16,600 5640 Signs & Hardware 4,224 2,400 2,400 1,000 5650 Maintenance Materials 25,355 40,000 40,000 60,000 5660 Chemical Supplies 13,842 31,000 31,000 25,000 5670 System Improvements 221,467 80,000 150,000 142,500 5680 Lift Stations - - - 26,000 5910 Depreciation 188,747 168,000 282,234 300,000 5911 Amortization 5,047 7,200 16,547 17,000 6110 Capital Expenditures 27,666 792,000 792,000 29,600 6140 Capital Expenditures -Equip 2,782 38,000 38,000 57,000 6160 Capital Expenditures -Vehicles 86,000 86,000 143,000 6175 1999 Bond Payment 1,968 17,283 17,283 - 6180 2001 Bond Payment 34,901 68,157 68,157 67,660 7145 Transfer from I & S - 7146 Transfer from Bond Fund (404,090) (443,379) 7147 Transfer to GF - 7148 Transfer to IM Fees Water (1,160,542) (287,064) - Totals $ 1,087,687 $ 3,438,663 $ 3,296,019 $ 3,851,914 67 priOSPER WN OF 2001 Certificate of Obligation FY Ending 9/30 Schedule of Indebtedness Public Works Principal Interest Fiscal Total 2008 36,300 31,359 67,659 2009 36,300 29,816 66,116 2010 37,950 28,274 66,224 2011 39,600 26,699 66,299 2012 41,250 25,055 66,305 2013 44,550 23,302 67,852 2014 46,200 21,364 67,564 2015 47,850 19,285 67,135 2016 51,150 17,084 68,234 2017 54,450 14,680 69,130 2018 56,100 12,066 68,166 2019 59,400 9,346 68,746 2020 62,700 6,435 69,135 2021 66,000 3,300 69,300 Total 679,800 68 268,065 947,865 DW S ADOPTED BUDGET FY 2007 - 2008 INTEREST & SINKING FUND 30 69 DEBT SERVICE 2001 - CO 2003 Tax Note 11% 4% 1998 - CO 2004 Tax Note 3% 43% 1996 - CO 4% 2006 - CO 35% Revenue & Expense Summary avenues I 926,-2LU 1,791,0651 1,813,6561 1,965,930 jEx=d1turss 1 634,524 1 1,706,684 1 1,916,092 1,866,94 70 Projected Adopted Actual Budgeted 1 Year End 1 Budget 1 2005-2006 2006-2007 2006-2007 2007-2008 avenues I 926,-2LU 1,791,0651 1,813,6561 1,965,930 jEx=d1turss 1 634,524 1 1,706,684 1 1,916,092 1,866,94 70 TOWN OF p SPER Town of Prosper Fiscal Year 2007 - 2008 Debt Service Summary DEBT SERVICE FUND REVENUES Taxes: Property $ 911,377 $ 1,783,055 $ 1,789,656 $ 1,940,430 Investment Income (Interest) $ 14,899 $ 8,000 $ 241000 $ 25,500 Total Revenues $ 926,276 $ 1,791,055 $ 1,813 656 1,965,930 EXPENDITURES Debt Service: $ (1,978) $ Adopted Account FY 06/06 FY 06/07 I FY 06 / 07 I FY 07108 I Description I Actual Budgeted Projected Budget DEBT SERVICE FUND REVENUES Taxes: Property $ 911,377 $ 1,783,055 $ 1,789,656 $ 1,940,430 Investment Income (Interest) $ 14,899 $ 8,000 $ 241000 $ 25,500 Total Revenues $ 926,276 $ 1,791,055 $ 1,813 656 1,965,930 EXPENDITURES Debt Service: $ (1,978) $ (6,400) $ (6,400) $ Principal $ 177,357 $ 336,206 $ 336,206 $ 805,192 Interest $ 251,100 $ 490,683 $ 490,683 $ $ (406,068) $ (879,795) $ (1,089,203) $ _1,061,756 Total Expenditures $ 428,457 $ 826,888 $ 826,889 $ 1,866,948 $ 222,807 $ 314,558 $ 314,558 $ 212,122 Excess of revenues over expenditures $ 497,819 $ 964,167 $ 986,767 $ 98,982 OTHER FINANCING SOURCES (USES) Administrative Fees $ (1,978) $ (6,400) $ (6,400) $ Transfers in for debt service $ - $ - $ - $ - Transfers out for debt service $ (404,090) $ (873,395) $ (1,082,803) $ - Total other financing sources $ (406,068) $ (879,795) $ (1,089,203) $ Net change in fund balances $ 91,751 $ 84,371 $ (102,436) $ 98,982 Fund Balance, beginning (as stated) $ 222,807 $ 314,558 $ 314,558 $ 212,122 Fund Balance, ending $ 314,558 $ 398,930 $ 212,122 $ 311,104 MOW Rev 71 w Town of Prosper '`` Adopted Departmental Budget p TOWP � Fiscal Year, 2007-2008 Summary of Revenue Fund: DEBT SERVICE FUND 30 Department: Int. & Sinking 10 4106 Tax Revenue - Delinquent A B C D 4610 Interest Income 4910 Revenue Projected Transfer in 14,899 8,000 Actual Budgeted Revenue Adopted Budget Account Revenue FY Current Fiscal Current FY for Code Title of Account 1 2005-2006 1 Year 2006-2007 2006-2007 FY 2007-2008 4106 Tax Revenue - Delinquent 4110 Tax Revenue - Current 4115 Penalty & Interest 4610 Interest Income 4910 Other Revenues 13,500 Transfer in 6,385 2,500 38,000 5,000 895,379 1,777,555 1,738,156 1,929,430 9,613 3,000 13,500 6,000 14,899 8,000 24,000 25,500 Totals $ 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 72 Town of Prosper * �' Adopted Departmental Budget P T N E Fiscal Year, 2007-2008 Summary of Expenditures Fund: QF,.BJ'-S.FRVICE_FUND 30 Department: Int. & Sin in 10 5270 Bank Charges A B C D - 6180 2001 Bond Payment Expenditures Projected 136,334 136,334 137,368 6185 Budgeted Expense Adopted Budget Account - Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5270 Bank Charges - 500 500 - 6180 2001 Bond Payment 135,839 136,334 136,334 137,368 6185 1996 Bond Payment - - - 70,313 6190 1998 Bond Payment - - - 63,990 6195 2002 Tax Note Payment 50,656 50,656 50,656 - 6196 2003 Tax Note Payment 75,066 75,066 75,066 75,067 6197 2004 Bond Payment 166,895 225,796 225,796 838,000 6198 2006 Bond Payment - 338,537 338,537 682,210 6200 Bond Administrative Fees 1,978 6,400 6,400 - 7142 Transfer to W/S 404,090 873,395 873,395 - 7144 Transfer to Bond Fund -Cap Proj 209,408 - 7149 Transfer to Debt Service Fund - Totals $ 834,524 $ 1,706,684 $ 1,916,092 $ 1,866,948 73 PIsPER Schedule of Indebtedness General Fund 1996 Certificate of Obligation Fiscal Years _ Ending 130 Principal Interest Fiscal Total 2008 40,000 30,313 70,313 2009 45,000 27,740 72,740 2010 50,000 24,818 74,818 2011 50,000 21,705 71,705 2012 55,000 18,410 73,410 2013 60,000 14,773 74,773 2014 65,000 10,788 75,788 2015 65,000 6,611 71,611 2016 70,000 2.258 72,258 Subtotal 500,000 157,414 657,414 1998 Certificate of Oblieation Fiscal Years _ Ending 9/30 Principal Interest Fiscal Total 2008 40,000 23,990 63,990 2009 40,000 22,410 62,410 2010 45,000 20,790 65,790 2011 45,000 18,923 63,923 2012 50,000 17,010 67,010 2013 50,000 14,835 64,835 2014 50,000 12,635 62,635 2015 55,000 10,410 65,410 2016 55,000 7,935 62,935 2017 60,000 5,460 65,460 2018 60,000 2,730 62,730 Subtotal 550,000 157,128 707,128 2001 Certificate of Oblieation Fiscal Years _ Ending 9/30 Principal Interest Fiscal Total 2008 73,700 63,668 137,368 2009 73,700 60,536 134,236 2010 77,050 57,404 134,454 2011 80,400 54,206 134,606 2012 83,750 50,870 134,620 74 2001 Certificate of Obligation (continued Fiscal Years _ Ending 9130 Principal Interest Fiscal Total 2013 90,450 47,310 137,760 2014 93,800 43,376 137,176 2015 97,150 39,155 136,305 2016 103,850 34,686 138,536 2017 110,550 29,805 140,355 2018 113,900 24,499 138,399 2019 120,600 18,974 139,574 2020 127,300 13,065 140,365 2021 134,000 6,700 140,700 2017 Subtotal 1,380,200 544,254 1,924,454 2004 Certificate of Obligation Fiscal Years _ Ending 9/30 Principal Interest Fiscal Total 2008 405,000 433,000 838,000 2009 455,000 416,800 871,800 2010 475,000 398,600 873,600 2011 490,000 379,600 869,600 2012 510,000 360,000 870,000 2013 530,000 339,600 869,600 2014 550,000 318,400 868,400 2015 570,000 296,400 866,400 2016 595,000 273,600 868,600 2017 620,000 249,056 869,056 2018 645,000 222,706 867,706 2019 670,000 195,294 865,294 2020 700,000 166,819 866,819 2021 730,000 137,069 867,069 2022 765,000 106,044 871,044 2023 800,000 72,575 872,575 2024 835.000 37.575 872,575 Subtotal 10,345,000 4,403,138 14,748,138 2006 Certificate of Obligation Fiscal Years _ Ending 9130 Principal Interest Fiscal Total 2008 405,000 433,000 838,000 2009 455,000 416,800 871,800 2010 475,000 398,600 873,600 2011 490,000 379,600 869,600 2012 510,000 360,000 870,000 75 2006 Certificate of Oblijzation (continued] Fiscal Years Ending 9130 Principal Interest Fiscal Total 2013 530,000 339,600 869,600 2014 550,000 318,400 868,400 2015 570,000 296,400 866,400 2016 595,000 273,600 868,600 2017 620,000 249,056 869,056 2018 645,000 222,706 867,706 2019 670,000 195,294 865,294 2020 700,000 166,819 866,819 2021 730,000 137,069 867,069 2022 765,000 106,044 871,044 2023 800,000 72,575 872,575 2024 835,000 37,575 872,575 2025 449,800 41,418 491,218 2026 470,600 21,177 491,777 Subtotal 11,265,400 4,465,733 15,731,133 2003 Tax Date Fiscal Years Ending 9130 2008 Subtotal Total Principal Interest Fiscal Total 71,492 3,575 75,067 71,492 3,575 24,112,092 9,731,240 76 75,067 33,843,332 -: 1 1 t` m 0 V 0 - t 111 omw mi I Ll ADOPTED BUDGET FY 2007 - 2008 CAPITAL PROJECT FUND 75 2004 BOND / 2006 BOND WA CAPITAL PROJECTS --� r �Yic.:..IC:.IL .���rt���'�';'�",nd+aa.�-� .u� r.�'I�_i `�7 .w...� i. -� o. •°: Renovate PD - Expansion for growth 2008 Bond sage Elevated Water Tank - Prosper Trails Drainage CUIVertS, Street Paving, Wastewater Flow Reversal, Park Improvements Revenue & Expense Summery 2004 Bond Usaae: 3 MG Storage Tank, Prosper Trails Storage Tank, Danville Water Proj. Revenues 12,453,373 Projected Adopted Actual Budgeted Year End 1 Budget 1 2005-2006 2006-2007 2006-2007 2007-2006 Revenues 12,453,373 165,5001 660,3121 206,100 Expenditures 158,380 19„491,238 1 9,615,152 1 8,404,244 78 Town of Prosper �` ► Adopted Budget 1' 0 W'4 a r: Fiscal Year, 2007-2008 P S p E R Capital Projects Fund Balance / Reserves CAPITAL PROJECTS $ - $ - $ Adopted Account FY 06/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description Actual Budgeted Projected Budget CAPITAL PROJECTS $ - $ - $ - $ REVENUES General Government $ 500 $ 68,500 $ Proceeds From Bond Issuance $ 12,000,000 $ - $ - $ Miscellaneous $ - $ - $ - $ - Investment Income (Interest) $ 453,,373 $ 165,500 $ 660,312 $ 206,100 $ 19,491,238 $ 9,6151152 $ 8,404,244 Total Revenues $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 EXPENDITURES Current: $ - $ - $ - $ Bond issuance cost General Government $ 500 $ 68,500 $ 531,541 $ - Capital Outlay $ - $ 19,422,738 $ 9,083,610 $ 8,404,244 $ - $ Transfers Out $ $ Total Expenditures $ 500 $ 19,491,238 $ 9,6151152 $ 8,404,244 Excess of revenues over expenditures $ 12,452,873 $ (19,325,738) $ (8,954,840) $ (8,198,144) OTHER FINANCING SOURCES (USES) Bonds Issue $ - $ - $ - $ Bond issuance cost $ (157.880) $ $ - $ - Due From Water Sewer $ - $ - $ - $ - Transfers In - Impact fees $ - $ $ - $ Transfers Out $ $ $ $ - Total other financing sources $ (157,880) $ - $ - $ Net change In fund balances $ 12,294,993 $ (19,325,738) $ (8,954,840) $ (8,198,144) Fund Balance, beginning $ 7,321,385 $ 19,616,378 $ 19,616,378 $ 10,651,539 Fund Balance, ending $ 19,616,378 $ 290,640 $ 10,661,539 $ 2,463,395 79 P � A1C S PES. Fund: Capital Projects 75 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department: Bonds 1N( 4611 Interest Inc -2004 Bond $ 432,711 $ 100,000 $ 4612 Interest Inc -2006 Bond $ 20,662 $ 65,500 $ 4910 Other Revenues - - 4995 Transfers In - 4999 Bond Proceeds -2006 $ 12,000,000 $ - $ Totals $ 12,453,373 $ 165,500 $ 80 175,000 $ 6,100 485,312 $ 200,000 660,312 $ 206,100 A B C D Revenue Budgeted 1Year2006-2007 Projected Adopted Budget Account Actual Revenue Current Fiscal Revenue Current for Code Title of Account I FY 2005-2006 FY 2006-2007 FY 2007-2008 4611 Interest Inc -2004 Bond $ 432,711 $ 100,000 $ 4612 Interest Inc -2006 Bond $ 20,662 $ 65,500 $ 4910 Other Revenues - - 4995 Transfers In - 4999 Bond Proceeds -2006 $ 12,000,000 $ - $ Totals $ 12,453,373 $ 165,500 $ 80 175,000 $ 6,100 485,312 $ 200,000 660,312 $ 206,100 Fund: CaUftftgjects 75 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Bonds 10 5290 A B C D - 68,500 148,223 Actual Expenditures Projected Adopted Budget Account Expense FY Budgeted Current Expense Current for Code Title of Account 2005-2006 FY 2006-2007 FY 2006-2007 1 FY 2007-2008 5290 Miscellaneous Expense -2004 500 - - 5411 Professional Services -2004 Bond - 68,500 148,223 6412 Professional Services -2006 Bond $ 383,318 6110 Capital Expenditures 6111 Capital Expenditures -2004 Bond - 7,357,238 5,894,350 6112 Capital Expenditures -2006 Bond - 12,065,500 3,189,260 6160 Capital Expenditures -Vehicles - - - 6210 Bond Costs 157,880 7150 Transfer to General Fund - _ 20,690 347,622 8,035,932 Totals $ 158,380 $ 19,491,238 $ 9,615,152 $ 8,404,244 81 Section 7.11 of the Town Charter requires a Five Year Capital program be included in the budget In accordance with this requirement the following information is provided for Water, Wastewater, and Thoroughfare. o A list of all capital improvements which are proposed to be undertaken during the five fiscal years succeeding the budget year, with appropriate supporting information as to the necessity for such improvements. a Cost estimates, method of financing, and recommended time schedules for each improvement; and, a The estimated annual cost of operating and maintaining the facilities to be constructed or acquired. The proposed projects provided are based on information contained within the approved Town of Prosper Capital Improvement plan and Town staff recommendations on projected development. *r . iq Z �I �I �I I �I �I I �I � �I �I �I �I �I �I �I �I �I � v C! v lacclacall-1-010 IMMEMEMMEM MEMEMEM !Joe Em 40 h N e M N MM 8 IRa 4 Et - P q , r s a Goa ppY MM pN p R,4 W U 1A Ig 40 09 to .4, r Vi R5 M do I to a 46 M w m w W, ri a �I �I �I I �I �I I �I � �I �I �I �I �I �I �I �I �I � v C! v 0 zp-4 fig po f.. m lacclacall-1-010 IMMEMEMMEM MEMEMEM !Joe Em 0 zp-4 fig po f.. m 40 h N e M N MM 0 zp-4 fig po f.. m U r.. M N M M M N N b W N W N 09 N N A A Si 101 0 1 fill 11 010191TH mi u1jeca coma DO Dill qjs y ti u J k S 8 U 8 8 8 8 LL 8 8$ 4 � 8 8 8 8 8 � , g�` � $ 58� g g w � � QS � � �i• •' �� h Po N N N N 8 M 8$ M H 8 M 8 M 8 M N .8 8$ #a 1► 8 N d! 8 8 v 8 ►► 8 Y1 8 K N M h M N OM Y! oN OS 69 N X04 W p OMj M N M M M N N b W N W N 09 N N A A Si 101 0 1 fill 11 010191TH mi u1jeca coma DO Dill qjs rri vs�.ao o1R�ipp�pQCl�� 0 Z114 a CL � 6 HRII � zmom C 4 C* 8 8 8 8 8 8 8 8 8$ 8 8 8 8 8 rri vs�.ao o1R�ipp�pQCl�� 0 Z114 a CL � 6 HRII � zmom C 4 C* ter. uu U m �/ � om fop mp (o� m mp ma mO ter. uu U m w Ci 04 pp0 0 O 0 Z04 W Y n:ylr R� r S5g IN 1 T OWN PER. ADOPTED BUDGET FY 2007 - 2008 PARKS FUND 60 Parks Dedication Parks Improvement Kil PARKS FUND Revenue & Expense Summary Perk Dedication Revenues 1 99,1461 255,000 1 258,000 1 259,500 Expenditures 40,304 - 31,000 1 - Park Improvement Expenditures 143,000 91 Projected Adopted Actual Budgeted Year End 12006-200712007-2008 Budget 2005-2006 2006-2007 Perk Dedication Revenues 1 99,1461 255,000 1 258,000 1 259,500 Expenditures 40,304 - 31,000 1 - Park Improvement Expenditures 143,000 91 1SPER OWN OF Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Park Summary Fund Balance PARK FUND $ 87,998 $ Adopted Account FY 05/06 I FY 06/07 I FY 06 / 07 I FY 07 /08 I Description Actual Budgeted Projected Budget PARK FUND $ 87,998 $ 607,000 $ 347,000 $ REVENUES Fund Balance, beginning (as stated) $ 336,396 $ 424,396 $ 424,396 Park Improvement Fees $ 172,000 $ 352,000 $ 118,000 $ 352,000 Park Dedication Fees $ 98,400 $ 255,000 $ 255,000 $ 255,000 Park Improvement -Interest $ 155 $ - $ 2,000 $ 2,500 Park Dedication -Interest $ 746 $ - $ 3,000 $ 4,500 Total Revenues $ 271,301 $ 607,000 $ 378,000 $ 614,000 EXPENDITURES General government -Parks Improv $ 183,304 $ - $ 31,000 $ 35,000 General government -Parks Dedication $ - $ - $ - $ Total Expenses $ 183,304 $ - $ 31,000 $ 35,000 Excess / (Deficit) $ 87,998 $ 607,000 $ 347,000 $ 579,000 OTHER FINANCING SOURCES (USES) Total Other Financing Sources (uses) $ - $ $ - $ Net change in fund balances $ 87,998 $ 607,000 $ 347,000 $ 579,000 Fund Balance, beginning (as stated) $ 336,396 $ 424,396 $ 424,396 $ 771,396 Fund Balance, ending $ 424,396 $ 1,031,396 $ 771,396 $ 1,350,396 92 p11TOWN OF SPER Fund: Parks 60 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department: Parks 60 4045 Park Fees -Dedication 98,400 A B C D 352,000 118,000 352,000 4615 Interest Income -Park Ded Revenue Projected 4,500 4620 Interest Income -Park Imp 155 Actual Budgeted Revenue Adopted Budget Account Totals $ Revenue FY Current Fiscal Current FY for Code Title of Account 1 2005-2006 1 Year 2006- 2006-2007 FY 2007-2008 4045 Park Fees -Dedication 98,400 255,000 255,000 255,000 4055 Park Fees - Improvements 172,000 352,000 118,000 352,000 4615 Interest Income -Park Ded 746 - 3,000 4,500 4620 Interest Income -Park Imp 155 - 2,000 2,500 Totals $ 271,301 $ 607,000 $ 378,000 $ 614,000 93 Fund: Parks Fund BO Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Parks 6Q 5410 Professional Services -Pk Dad 5411 Professional Services -Pk Imp 6120 Capital Expenditures -Park Improv 6140 Capital Expenditures -Park Ded 6160 Capital Expenditures -Vehicles 7141 Transfer to Parks & Rec Fund 40,304 - 31,000 - 35,000 143,000 - - - Totals $ 183,304 $ 94 - $ 31,000 $ 35,000 A B C D Expenditures Projected Actual Budgeted Expense Adopted Budget Account Expense FY Current FY Current FY for Code Title of Account 2006-2006 2006-2007 2006-2007 FY 2007-2008 5410 Professional Services -Pk Dad 5411 Professional Services -Pk Imp 6120 Capital Expenditures -Park Improv 6140 Capital Expenditures -Park Ded 6160 Capital Expenditures -Vehicles 7141 Transfer to Parks & Rec Fund 40,304 - 31,000 - 35,000 143,000 - - - Totals $ 183,304 $ 94 - $ 31,000 $ 35,000 ADOPTED BUDGET FY 2007 - 2008 IMPACT FEES FUND 65 Water Impact Sewer Impact Thoroughfare Impact IMPACT FEES FUNDS Revenue & Expense Summary Water Expenditures 796,888T 144,700 329,200 Wastewater Impact Expenditures I I - 1 56,900 Expenditures - 293,300 86,000 1Cl,GO(1 9 -- Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 Water Expenditures 796,888T 144,700 329,200 Wastewater Impact Expenditures I I - 1 56,900 Expenditures - 293,300 86,000 1Cl,GO(1 9 -- pI_"SPER TOWN Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Impact Fees Summary Account Description FY 05/06 Actual FY 06/07 Budgeted FY 06 / 07 Projected Adopted FY 07 / 08 Budget $ IMPACT FEES REVENUES Impact Fees $ - $ - $ - $ - Water $ 463,687 $ 409,696 $ 490,000 $ 648,750 Sewer $ 361,462 $ 353,648 $ 440,000 $ 494,250 Thoroughfare $ 412,407 $ 415,400 $ 415,400 $ 1,014,500 Investment income $ 51,206 $ 30,000 $ 58,000 $ 66,000 1,090,188 $ Total Revenues $ 1,288,762 $ 1,208,744 $ 1,403,400 $ _ 2,223,500 EXPENDITURES General Government $ $ $ - $ General Government -water $ - $ - $ 17,700 $ General Government -sewer $ $ - $ 17,700 $ - General Government -thoroughfare $ $ - $ 12,000 $ Capital Outlay -water $ $ 796,888 $ 127,000 $ 329,200 Capital Outlay -sewer $ $ - $ 39,200 $ Capital Outlay -thoroughfare $ - $ 293,300 $ 74,000 $ 120,000 Total Expenses $ $ 1,090,188 $ 287,600 $ 449,200 Excess / (Deficit) $ 1,288,762 $ 118,556 $ 1,115,800 $ 1,774,300 OTHER FINANCING SOURCES (USES) Transfers In $ - Transfers Out (1,160,542) $ Total Other Financing Sources (uses) $ (1,160,542) $ Net change In fund balances $ 128,220 $ 118,556 $ 1,115,800 $ 1,774,300 Fund Balance, beginning (as stated) $ 1,273,769 $ 1,401,989 $ 1,401,989 $ 2,517,789 Fund Balance, ending $ 1,401,989 $ 1,520,545 $ 2,517,789 $ 4,292,089 PYA r n TOWN P SPPR Fund: Impact Fee Fund 65 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department Impa_ct Fees 999 4016 Impact Fees - Water A B C I) 4020 Impact Fees - Sewer 361,462 Revenue 440,000 494,250 4040 Impact Fees - Thorfare Actual Budgeted Current Projected Adopted Budget Account Miscellaneous Revenue FY Fiscal Year 2006- Revenue Current for Code Title of Account 2005-2006 2007 1 FY 2006-2007 FY 2007-2008 4016 Impact Fees - Water 463,687 409,696 490,000 648,750 4020 Impact Fees - Sewer 361,462 353,648 440,000 494,250 4040 Impact Fees - Thorfare 412,407 415,400 415,400 1,014,500 4030 Miscellaneous - - _ _ 4610 Interest Income 51,206 - - _ 4615 Interest -Water Impact - 10,000 26,000 30,000 4620 Interest -Sewer Impact - 10,000 18,000 20,000 4640 Interest-Thorfare Impact - 10,000 14,000 16,000 4910 Other Revenues - - - - Totals $ 1,288,762 ; 1,208,744 ; 1,403,400 $ 2,223,600 98 M P TOWN ER Fund: t=act Faes Fund 65 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Impact Fees 99 5410 A B C 0 Professional Services -Water - - 17,700 - Expenditures Projected 17,700 - 5440 Budgeted Expense Adopted Budget Account Actual Expense Current FY Current FY for Code Title of Acoount FY 2005-2006 1 2008-2007 2006-2007 FY 2007-2008 5410 Professional Services 204,391 - - - 5415 Professional Services -Water - - 17,700 - 5420 Professional Services -Sewer - - 17,700 - 5440 Professional Services-Thorfare - - 12,000 - 6110 Capital Expenditures 956,151 - - - 6115 Capital Expenditures -Water - 796,888 127,000 329,200 6120 Capital Expenditures -Sewer - - 39,200 - 6140 Capital Expenditures-Thorfare - 293,300 74,000 120,000 6160 Capital Expenditures -Vehicles - - - - 7144 Transfer to Capital Assets (1,180542) - - - Totals $ - $ 1,090,188 $ 287,600 $ 448,200 99 TOWN OF spF.R ADOPTED BUDGET FY 2007 - 2008 SPECIAL REVENUE FUND 67 100 SPECIAL REVENUE Revenue & Expense Summary Police Donations Revenues 1 8,4201 15,000 1 8,5001 13,000 Expenditures 1 1,107 15,0001 3,600 7,000 Fife Dent Donations Revenues Expenditures 8,748 8,500 39,060 13,000 Health & Safety Fair Donations 3,000 lid Safety Donations mevenues _ - -1 4,7101, 3,000 Ex ndltures Escrow Revenues - 290,000 Expenditures Court Security Fund Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 Police Donations Revenues 1 8,4201 15,000 1 8,5001 13,000 Expenditures 1 1,107 15,0001 3,600 7,000 Fife Dent Donations Revenues Expenditures 8,748 8,500 39,060 13,000 Health & Safety Fair Donations 3,000 lid Safety Donations mevenues _ - -1 4,7101, 3,000 Ex ndltures Escrow Revenues - 290,000 Expenditures Court Security Fund Town of Prosper °�' Adopted Departmental Budget TOWN � � Fiscal Year, 2007-2008 Summary of Revenue Fund: SPECIAL REVENUE FUND 67 Department: So Rev_ 10 4530 Police Donation A B C D 4535 Child Safety Donations 4536 Revenue Projected Court Technology Revenue 4610 Interest Income Actual Budgeted Revenue Adopted Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 1 Year 2006-2007 2006-2007 FY 2007-2008 4530 Police Donation 4531 Fire Dept Donations 4532 Health & Safety Fair Donations 4535 Child Safety Donations 4536 Court Security Revenue 4537 Court Technology Revenue 4610 Interest Income 4915 Escrow Income 8,420 13 Totals $ 8,433 $ 102 15,000 8,500 13,000 15,000 10,300 13,000 - 6,100 3,000 - 4,710 3,000 _ 1,870 1,500 2,160 1,800 - 290,000 - 30,000 $ 323,640 $ 35,300 r Town of Prosper Adopted Departmental Budget " OF Fiscal Year, 2007-2008 P ► P E R Summary of Expenditures Fund: Special Revenue Fund _ 67 Department: Spec Rev IQ 5203 Court Technology Expense A 10 C D - - - - 5205 Expenditures Projected 7,000 5206 Fire Dept Donations Expense Actual Budgeted Expense Adopted Account 3,000 Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5203 Court Technology Expense - - - 5204 Court Security Expense - - - - 5205 Police Donations Expense 1,107 15,000 3,600 7,000 5206 Fire Dept Donations Expense 8,748 8,500 39,060 13,000 5207 Health & Safety Fair Expense - - - 3,000 5208 Child Safety Expense - - 5209 Escrow Expense - - - 5290 Miscellaneous - - 7,570 - 5291 Special Operation - - 1,400 1,000 Totals $ 9,855 8 23,500 $ 51,630 8 24,000 103 Is r TOWN OF SP R ANNUAL BUDGET FY 2007 - 2008 ECONOMIC DEVELOPMENT CORPORATION (EDC) 104 ECONOMIC DEVELOPMENT CORP. Ecoromtc Development Corporatlon Board of 'Directors EDC Director iIlan Tolleson EDC Assistant Beth Larson Revenue & Expense Summary Projected Adopted Actual Budgeted Year End Budget .2005-2006 2006-2007 2006-2007 2007-2008 Revenues 540,489 520,000 1 468,0004 0,000 [Expenditures 230,308 324,9431 218,351 1319,066 105 nop c: I'Vononlic Development Col- oration Mission — To promote and sustain a diversified economy through business assistance programs and infrastructure projects that result in the creation of primary jobs and the expansion of the local tax base. Programs & Services — Business Recruitment, Business Retention & Expansion, Revitalization, Public -n -Private Partnerships, Capital Investment and Marketing. Employees: Two staff members: Executive Director and EDC Assistant ■ Established policies and programs that incentive development (i.e., Tax Abatement, Freeport Goods Exemption, Tax Increment Financing) and identified available State Incentive Options. • Launched "All Roads Lead to Prosper" Advertising Campaign, completed marketing materials (i.e., Logo, Fast Facts, and Community Profile) and engaged consultant to design EDC website. • Engaged Cofer Haag & Thrasher to conduct Retail Trade Area Study and Leakage Analysis to promote retail development. ■ Launched campaign to elevate the development community's awareness of Prosper through press releases, articles in area newspapers, magazines, business journals, online wire services and professional trade shows. • Voters approved Local Option Election for sale of mixed beverages for on -premise consumption. ■ Completed Investment Policy. • Completed 2005 Economic Development Annual Report — Power Point Presentation. ■ Finalize pending TIRZ and the Project and Finance plans. ■ Continue promoting Prosper as a prime location for residential and commercial development through contacts with real estate brokers, developers and retailers that make decisions to invest or reinvest in Prosper. ■ Complete duties of Impact Fee Advisory Committee and periodically make recommendation to Town Council on the Capital Improvement Plan and Program. • Promote the construction of public infrastructure that will support development -ready lots. ■ Finalize EDC website. ■ Establish Economic Development Roundtable — committee of local and area political and business leaders that will consider town and regional initiatives affecting the local economy. ■ Develop a Marketing Plan and Strategies. • Maintain demographic & business databases with up-to-date information. it Promote professional development for staff. 106 o" p TOWN PLR Town of Prosper FY 2007 - 2008 Town Budget Economic Development Corporation Net Assets / Reserves ECONOMIC DEVELOPMENT Adopted Account FY 05/06 FY 06/07 I FY 06 / 07 I FY 07 / 08 I Description Actual Budgeted Projected Budget ECONOMIC DEVELOPMENT OPERATING REVENUES Total Operating Expenses $ 230,308 Sales Tax $ 502,172 $ 500,000 $ 411,000 $ 390,000 Interest $ 37,881 $ 20,000 $ 57,000 $ 50,000 Other Income $ 36 $ - $ - $ - Total Operating Revenues $ 540,089 $ 520,000 $ 468,000 $ 440,000 OPERATING EXPENSES Total Operating Expenses $ 230,308 $ 324,943 $ 218,351 $ 319,066 Total Expenses $ 230,308 $ 324,943 $ 218,351 $ 319,066 INCOME (LOSS) $ 309,781 $ 195,057 $ 249,649 $ 120,934 Change in Net Assets $ 309,781 $ 195,057 $ 249,649 $ 120,934 Fund Balance, beginning (as stated) $ 761,458 $ 1,071,239 $ 1,071,239 $ 1,320,888 Fund Balance, ending $ 1,071,239 $ 1,266,296 $ 1,320,888 $ 1,441,822 107 Town of Prosper `` Adopted Departmental Budget p TOWN ER Fiscal Year, 2006-2007 Summary of Revenue Fund: Economic Development 80 Department: EDC 65 4030 Miscellaneous A 8 C D 4530 Contributions 4610 Revenue Projected Other Revenues Actual Budgeted Revenue Adopted Budget Account Revenue FY Current Fiscal Current FY for Code Title of Account 2005-2006 Year 2006-2007 2006-2007 FY 2007-2008 4030 Miscellaneous 4060 NSF Fees 4120 Sales Tax - EDC 4530 Contributions 4610 Interest Income - EDC 4910 Other Revenues 502,172 500,000 411,000 390,000 37,881 20,000 57,000 50,000 36 - - - Totals $ 540,089 520,000 468,000 440,000 108 Town of Prosper IT Adopted Departmental Budget PN E Fiscal Year, 2007-2008 OWN of Expenditures Fund: ggol3gmic Dew1opment 80 Department: EDC 65 5001 Master Plan - Other A B C D 5110 Salaries & Wages $ 96,519 $ Expenditures Projected 111,520 5115 Salaries - Overtime Actual Budgeted Expense Adopted Account Salaries - Longevity Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5150 Medicare Expense 1,401 1,535 1,290 1,663 5001 Master Plan - Other - 5110 Salaries & Wages $ 96,519 $ 105,042 $ 88,317 $ 111,520 5115 Salaries - Overtime 149 - 100 3,000 5140 Salaries - Longevity 250 850 850 175 5145 Social Security Expense 5,991 6,565 5,515 7,111 5150 Medicare Expense 1,401 1,535 1,290 1,663 5155 SUTA Expense 155 540 814 540 5160 Health Insurance 8,546 8,867 7,051 4,254 5165 Dental 701 798 399 312 5170 Life Insurance 253 90 134 45 5173 ADBD 55 - 135 162 5180 TMRS Expense 6,603 6,626 7,264 9,554 5185 ShortlLong Term Disability 658 1,443 511 500 5189 Administrative Fee 1,500 1,500 1,500 12,000 5190 Contract Labor - 1,300 1,165 1,000 5191 Hiring Cost 39 117 117 - 5193 Record Retention - 200 200 200 5210 Supplies 2,847 3,700 3,700 3,700 5212 Building Supplies - 300 300 700 5220 Office Equipment 1,303 3,200 3,200 3,200 5230 Dues School Subscriptions 360 1,825 1,825 1,825 5240 Postage & Delivery 156 1,500 1,500 1,500 5250 Publications 196 425 425 425 5260 Advertising - 300 - - 5265 Promotional Expenses 33,607 50,000 20,500 41,950 5270 Bank Charges 30 200 - - 5280 Printing & Reproduction 1,120 1,200 1,200 1,200 5290 Miscellaneous 145 - - - 5310 Rental Expense 70 75 75 100 5312 Equipment Lease - - - - 5320 Repair S Maintenance - - 63 5325 Copier Lease 468 - - - 5330 Copier Expense 2,469 4,000 4,000 4,000 5340 Building Repairs - 1,000 100 1,000 5350 Vehicle Expense - - - - 6410 Professional Services 42,145 30,000 30,000 20,000 5412 Audit Fees 500 500 1,200 1,500 5416 Engineering Fees 10,000 10,000 10,000 7,000 109 Fund: E onomlc Develoornent B0 Department: EDC 65 5418 IT Fees A 9 C D 500 4,000 Expenditures Projected Legal Fees Account Code Title of Account Actual Budgeted Expense Expense FY Current FY Current FY 2005-2006 2006-2007 2006-2007 Adopted Budget for FY 2007-2008 6435 5418 IT Fees 176 500 500 4,000 5430 Legal Fees 2,485 8,400 8,400 9,000 6435 Legal Noticas / Filings - 700 700 700 5480 Contracted Services - - - -. 5520 Telephone 3,039 3,300 3,300 3,300 5521 Call Phones 829 900 900 1,700 6524 Gas - 500 - - 5525 Electricity - 2,400 1,600 1,700 5530 Travel Expense 1,659 5,500 5,500 5,500 5533 Mileage Expense 979 5,045 2,000 4,000 5536 Training / Seminars 2,905 4,000 2,000 4,030 6015 Leverage Fund Principal - 50,000 - 45,000 6140 Capital Expenditures -Equip - - - - Totals $ 230,308 $ 324,943 $ 218,351 $ 319,066 110 AFFIDAVIT OF PUBLICATION STATE OF TEXAS COUNTY OF DALLAS Before me, a Notary Public in and for Dallas County, this day personally appeared Lynda Black, Legal Advertising Representative for the DALLAS MORNING NEWS being duly sworn by oath, states the attached advertisement of: Town of Prosper as published in The Dallas Morning News — Collin County Edition ORDINANCE NO, 07.679 September 27, 2007 (Lynda Black) Sworn to and subscribed before me this September 27, 2007, A.D ,o •'N" '� f ". L[SA 8A*n-E NF1F-1_p NDlaq Publ�,, SIA a 01 Texas