The URL can be used to link to this page

Budget - FY 2007-2008ORDINANCE 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 filed 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: ApptiMriation 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 $ b866,948 Page 1 of 2 SECTION 4: Authority of Town Manger. 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: Savings/ Repealing Clause. 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 S: 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`x' DAY OF SEPTEMBER, 2007 AT A MEETING WHICH WAS HELD IN STRICT ACCORDANCE WITH THE TEXAS OPEN MEETING ACT.. ATTEST TO: — ATTHEW D. DENTON, TRMC Town Secretary Date of Publication Z A ES NISWANGER, Mayor Dallas Morning News — Collin County Edition , ,► Page 2 of 2 OF PRS `e p ��bOOt+044 Do .i5 X�,. 7Za r 7 Vpo u 6e +'Y� i° a v c ti U y V 4ft 10 00 Y *96 4 I& MR l� P—rot TOWN OF SSPE FY 2007m2OO8 Budget The Town of Prosper ADOPTED A TAX THAT WILL RAISE MORE TAXES MAINTENANCE AND OPERATIONS THAN YEAR'S TAX RATE. RATE FOR j u►sT THE TAX RATE WILL RAISE TAXES FOR MAINTENANCE AND OPERATIONS ON A i $lOOrO0O HOME BY APPROXIMATELY $90.53. PIN 80W I W-=' 19 ADOPTED BUDGET FY 2007 - 2008 Adopted September 18, 2007 October 1, 2007 - September 30, 2008 Rev 09/15/07 P rAb S P E 11:;z. ADOPTED BUDGET FY 2007 2008 Mike Land, Town Manager Prosser 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 JWN OF SPER FY 2007m2OO8 Budget *"''his budget will raise more total property taxes than last year's budget by 1.r267.257r 44,920/o and of that amount $�38� IS tax revenue to be raised from new property' added to the roll this year." *Includes Debt Service and General Fund eqendltures Rev BIM07 iSPR P E 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 funding 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 office 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 mile 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 cornercial 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. • Posting of Code of Ordinances on the Internet to improve citizen access. Police • Two new positions are proposed. Currently, when the Court Clerk (the 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 full 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 fighters/EMT 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 egttipment 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 a.m. 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 commitment 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 band 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 riS P OE' 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 1D 18 24 33 38 42 45 50 58 59 68 69 70 74 77 78 82 90 91 95 96 100 101 104 105 (z Z) NOV S PER ADOPTED BUDGET FY 2007 — 2008 Ad V'aloreum Tax Fate Distribution October 1, 2007 - September 30, 2008 Ad Valorem Taxes Tax Rate Distribution FY 2007-2008 Debt Service 47% General Fund 53% General Fund Tax Rate (M & O) Debt Serice Tax Rate ( I & S) Total Tax Rate PER $100 VALUATION 2006 12007 2007/2008 Q.I 84549 0.275075 0.314268 0.244925 0.498817 2 0.520000 General Fund Debt Servioe 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% General Fund Tax Rate (M & O) Debt Serice Tax Rate ( I & S) Total Tax Rate PER $100 VALUATION 2006 12007 2007/2008 Q.I 84549 0.275075 0.314268 0.244925 0.498817 2 0.520000 dA 4,r 0/0, r© ra .r� d o' m CC �Vill n ��p ai G� cc x �'r N �j o0 v 4.0 x j m L °ro J J T og 00 I- ko Ln M N O G O O O O O 6 C FY 2007 - 200$ ADOPTED BUDGET SUMMARIES October 1, 2007 - September 30, 2008 Rev 08115107 4 1SPER OWN OF P GENERAL FUND REVENUES EXPENDITURES WATER / SEWER FUND Town of Prosper Fiscal Year 2007 - 2008 Adopted Budget CONSOLIDATED STATEMENT A B C D 3,867,000 EXPENDITURES Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 4,339,447 4,328,761 4,135,495 5,357,419 3,231,084 4,277,455 4,045,544 5,357,418 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 NET REVENUES OVER (UNDER) EXPENDITURES- 2,654.669 171.988 15,086 DEBT SERVICE FUND REVENUES 926,276 1,791,055 1,813,656 1,965,930 EXPENDITURES 834,524 1,706,684 1,916,092 1,866,948 INET REVENUES OVER ND EXE DITU 91,7521 84,371 98,9 2 CAPITAL PROJECTS FUND REVENUES 12,453,373 165,500 660,312 206,100 EXPENDITURES 158,380 19,491,238 9,615,152 8,404,244 NET REVENUES OVER R) EXPENDITURES 1 12,294,993 1 (19,325,738)1 (8, 5 , (8,198.144)11 PARKS FUND REVENUES 271,301 607,000 378,000 614,000 EXPENDITURES 183,304 - 31,000 35,000 NET REVENMES O (UNDE PENDITURES 87,9981 607,0001 347,000 579,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) EXPENDITURES 1,288,762 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 5 Town of Prosper FY 2007 - 2008 Budget Consolidated Fund Revenue Summary $3,887,000 Water & Sewer 26 or io $440,000 EDC rro ecto 3% ?30 Interest & ;inking 13% 0 Parke Fund 4% ;t Fee Town of Prosper FY 2007 - 2008 Budget Consolidated Fund Expenditure Summary $3,851,914 Water & Sewer 19% $5,357,418„ General Fund 26% $35,000 Parks Fund 0% $1,866,948 Interest & Sinking $319,066 2% 7 $449,200 Impact Fee Fund % 2% $8,404,244 Capital Projects 42% 0 11 0 ADOPTEDBUDGET FY 2007 - 2008 SCHEDULE OF PERSONNEL r r 1� TOWN F SPER GENERAL FUND 5.0 Administration Adopted Police FY 06/07 Fire FY 07 / 08 Streets Budgeted Parks Budget Court 2.0 Inspections 2.0 Code Enforcement 1.0 Planning 2.0 Engineering 1.0 1.0 Total Full -Time 4.0 Total Part -Time Total General Government 9.0 PUBLIC WORKS 1.0 Water 1.0 Wastewater 2.0 Utility Billing 3.0 U Total Full -Time 1.0 Total Part -Time Total Public Works 36.0 Economic Development Corporation Administration 9_0 9_0 Total Full -Time 9_0 Total Part -Time Total Economic Development 46.0 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 U 1.00 1.0 L. 27.0 36.0 37.0 46.0 9_0 9_0 9.00 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 Q 1_0 1.00 LQ 8.0 9.0 9.0 10.0 U 0_0 OA U 8.0 9.0 9.0 10.0 2_0 2_0 2.0 2`0 2.0 2.0 2.0 1.0 QQ 0_0 0_0 19 2.0 2.0 2.0 2.0 37.00 47.00 48.00 57.00 9.00 9.00 9.00 10.00 46.00 56.00 57.00 67.00 9 wo TOWN OF SPER ANNUAL BUDGET FY 2007 - 2008 GENERAL FUND 10 pil0W11 OF SP ,ER Town of Prosper FY 2007 - 2008 Town Budget General Fund Summary Fund Balance /Reserves ULIMr-KAL I-UNV 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 Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description I Actual Budgeted Projected Budget ULIMr-KAL I-UNV 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,085 $ 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 $ $ 158,360 $ - $ - $ 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 $ 562,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 (out) $ $ $ $ Transfer Out for Debt Service $ - $ $ $ Total Other Financing Sources (uses) $ - $ - $ - $ Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending 16`Yo Reserve Calculation: Less Restricted Funds -Contributions Police & 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,235 $ 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) $ $ $ $ (212) $ $ $ $ (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 Franchf 64 Town of Prosper FY 2007 - 2008 Adopted Budget General Fund Revenue Sources Fines, warrants and seizures Chpmac fnr carvlrta a 2°Y 22% 12 party Tax 41% piltSPER Town of Prosper Fiscal Year 2007 - 2008 Summary of Revenues By Department General Fund $ 4,339,447 $ 4,328,761 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 Water & Sewer Fund 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 Fl re $ 312,429 $ 142,000 $ 147,250 $ 298,800 Streets $ - $ - $ - $ 378,000 Parks / Recreation $ $ $ • $ $ $ Communication $ - $ Capital Projects Fund Totals $ $ $ $ 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 Impact Fees Fund Totals $ 1,288,762 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 $ 814,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,662 $ 65,500 $ 485,312 $ 200,000 Capital Projects Fund Totals $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 Totals $ 23,021,515 $ 11,367,725 $ 11,667,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% 2% IIIOV/ Vuvl10 5% 15% ° 14 Police 1% 1SPER OWN OF p Town of Prosper Fiscal Year 2007.2008 Summary of Expenditures By Department Wwcuaial rums 158,380 $ 7,425,738 Adopted Account FY 05/06 FY 06/07 FY 08 / 07 FY 07 / 08 Description Actual Budgeted Projected Budget Wwcuaial rums 158,380 $ 7,425,738 $ 6,042,573 $ 368,312 Series 2006 Bond $ 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 Fess Fund Water Impact Fees $ 1,160,542 $ Wastewater Impact Fees $ - $ Thoroughfare Impact Fees $ - $ Transfer of Capital Assets $ (1,160, 542} $ Impact Fees Fund Totals $ - $ Capital Projects Fund 796,888 $ 144,700 $ 329,200 - $ 56,900 $ - 293,300 $ 86,000 $ 120,000 1,090,188 $ 287,600 $ 449,200 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 $ 6,494,979 S 30,004,218 S 19,190,406 $ 19,964,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 % 11% Recreation Streets Planning _50/0 Administration 17% Fire I 30% +I Police Court 21% 3% 16 ADOPTED BUDGET FY 2007 - 2008 GENERAL FUND FUND 10 17 ADMINISTRATION/COMMUNICATION Town Manager Aas'lstanl to the Town AdrmlWstralor Town Secretary Flnanc+w'Bunlneas ?0iDnager I Commun4caitons tvt.711hgw CJa9sllonL �.___a+ti Putter Recounts Payable I Payroll Clerk } Karen GIN fl Utility 13011rig Cl*rk' Revenue & Expense Summary avenues 1 3,125,032 1 3,237,121 1 2,942,625 1 4,015,199 lExpendltures 1 625,8551 798,761 1 833,980 918,f-41 18 Projected_ Adopted Actual Budgeted Year End 1 Budget 2005-2006 2006-2007 2006-2007 2007-2008 avenues 1 3,125,032 1 3,237,121 1 2,942,625 1 4,015,199 lExpendltures 1 625,8551 798,761 1 833,980 918,f-41 18 lkpt. 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 • 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 • Continue to diversify investments to realize higher interest yield. • Organized and reviewed AP to reduce double payments. ■ ...................... I........ • 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 r °�' Adopted Departmental Budget �ry TOWN � � Fiscal Year, 2007-2008 i 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- 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,126,032 $ 3,237,121 $ 2,942,625 $ 4,016,199 20 Town of Prosper � Adopted Departmental Budget i 'TOWN E n Fiscal Year, 2007-2008 1� Summary of FExpenditures Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 5110 A B C D 334,012 5115 Expenditures Projected 400 865 Actual Budgeted Expense Adopted Budget Account Expense FY Current FY Current FY for Code Title of Account 2005-2006 i 2006-2007 2006-2007 FY 2007-2008 Social Security Expense 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 ShortlLong Term Disability 1,199 3,781 2,112 2,244 5190 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 S 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 & Maintenance - - - - 5325 Copier Lease 5,250 7,200 7,200 9,480 5330 Copier Expense 1,282 300 300 300 5335 Radio / Vedic, 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 Fess 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 A B C D 1,000 Expenditures Projected IT Fees 13,637 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 12,438 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 / 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 W/S - Totals $ 618,950 $ 776,745 $ 811,964 $ 892,641 22 Town of Prosper Adopted Departmental Budget FPF OF Fiscal Year, 2007-2008 RET09Summary of Expenditures Fund: GENE R6L FUND 10 Department: Communication 95 6190 Contract Labor A B C D 8,800 6210 Supplies Expenditures Projected 1,916 1,900 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 Publications 6190 Contract Labor 3,823 4,800 4,800 8,800 6210 Supplies 196 1,916 1,916 1,900 5230 Dues School Subscriptions - - - - 3240 Postage i 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 aolfca Chl�t k(rrf, M��atfln A56t Court Amy Ughtf-ol L7 - - — Police Captam Galy fOrHcme allce Sagerant 3rho0 1 U11,12 as affce off lt or police Officer ��P(),Iicl'�Off PcNlce S�fTfcear 0tldcvr Wr s I4 i 6bafl G,010943 Pin 4 l GibfS7RM .fa5or+ -- — 'i Revenue & Expense Summery rojec a aoptea Actual 200.5 Budgeted Year End Budget 2006 20106-2007 2006-2007 2007-2008 Revenues 1 159,590 1 73,930 0 15 ,2 Expen lturet3 1 897,793 1 1,089,454 1 1,002,880 11,304,235 24 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 fast 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 Department: 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 bevel 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 Town of Prosper '`'� Adopted Departmental Budget P °� P � Fiscal Year, 2007-2008 - - 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-2008 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 $ 32,928 $ 28 35,700 $ 37,880 $ 39,020 Town of Prosper I. Adopted Departmental Budget p T Fiscal Year, 2007-2008 I Summary of Expenditures Fund: GENERAL FUND 10 Department: Police 2,Q A B C D Expenditures Projected 515,441 Budgeted Expense Adopted Budget Account Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 1 2006-2007 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 - - 5140 Salaries - Longevity 4,500 5,750 5,625 6,725 5145 Social Security Expense 21,612 27,666 26,211 33,991 5150 Medicare Expense 5,054 6,470 6,130 7,950 5155 SUTA Expense 496 2,430 860 2,970 6160 Health Insurance 29,296 37,684 35,932 42,097 6165 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/ADBD (Standard Insur. Policy) 154 - - 1,404 5180 TMRS Expense 23,599 27,894 29,504 45,669 5185 Short/Long Term Disability 2,005 5,673 3,182 4,318 6190 Contract Labor 1,960 5,520 5,520 7,440 6191 Hiring Cost 74 1,580 500 2,960 5192 Physical & Psychological - 3,400 750 2,700 5206 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 5250 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 5326 Copier Lease 2,368 3,000 3,000 3,500 5330 Copier Expense 547 - - 1,000 29 Fund: GENERAL FUND 10 Department: Police 20 6336 Radio/Video Repairs A B C D 5340 Building Repairs 320 Expenditures Projected 1,000 5360 Vehicle Expense 12,894 Budgeted Expense Adopted Budget Account Gas/Grease/OlUlnspections Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 6336 Radio/Video Repairs - 6,250 4,000 6,250 5340 Building Repairs 320 1,000 1,000 1,000 5360 Vehicle Expense 12,894 20,000 18,000 20,000 5353 Gas/Grease/OlUlnspections 25,525 35,000 24,000 31,995 6400 Uniform Expense 8,332 7,300 7,300 13,500 6410 Professional Services 1,154 1,500 500 2,000 6418 IT Fees 13,049 9,750 3,900 15,000 5430 Legal Fees 7,925 3,500 6,000 10,000 6460 Dispatch Expense 60,445 92,750 49,000 90,000 6480 Contracted Services 13,945 29,900 29,900 29,900 6620 Telephone 6,524 9,800 9,000 12,900 5621 Cell Phones 3,465 5,000 5,000 9,250 5622 Pagers 464 - 164 - 5524 Gas 374 900 700 750 6526 Electricity 3,670 3,000 2,800 3,000 6630 Travel Expense 3,875 4,000 2,500 4,500 6633 Mileage Expense 636 1,000 750 1,000 5636 Training / Seminars 9,332 14,500 11,000 17,500 6600 Special Events - 3,950 3,000 11,000 6630 Safety Equipment - 1,350 1,350 - 5640 Signs & Hardware - 1,750 1,750 1,500 6110 Capital Expenditures 46,097 3,725 3,725 - 6140 Capital Expenditures -Equip 17,458 18,200 18,200 21,350 6160 Capital Expenditures -Vehicles 47,944 77,410 77,410 86,410 Totals $ 786,107 $ 877,988 $ 887,770 $ 1,146,625 30 Town of Prosper `' Adopted Departmental Budget p TOWN � � Fiscal Year, 2007-2008 T 1L: 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 Transfer In Totals $ 106,662 $ 106,200 $ 106,660 $ 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 2006-2007 2006-2007 1 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 Transfer In Totals $ 106,662 $ 106,200 $ 106,660 $ 120,200 31 Town of Prosper 14SP Adopted Departmental Budget pOF� , Fiscal Year, 2007-2008 1`t� Summary of Expenditures Fund: GENERAL FUND 10 Department: Court 70 5110 Salaries $ Wages A B C D 6116 Salaries - Overtime 5,992 Expenditures Projected 8,000 5120 Salaries - Leave Actual Budgeted Expense Adopted Budget Account Salaries - Sick Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries $ Wages 35,289 38,930 37,461 38,959 6116 Salaries - Overtime 5,992 800 7,852 8,000 5120 Salaries - Leave 693 - - - 5125 Salaries - Sick - - - 750 5140 Salaries - Longevity 1,000 1,000 1,000 1,000 5145 Social Security Expense 2,629 2,525 2,997 2,973 5160 Medicare Expense 615 591 670 695 6155 SUTA Expense 63 270 200 270 6160 Health Insurance 4,309 4,433 4,433 4,074 6166 Dental 392 399 399 312 6170 Life Insurance 125 165 165 45 5173 ADBD 23 - - 123 6180 TMRS Expense 2,851 2,540 3,500 3,995 6186 Short/Long Term Disability 292 323 388 343 6190 Contract Labor 1,920 5210 Supplies 1,481 3,000 2,000 3,000 6212 Building Supplies 624 600 20 500 5230 Due and Subscriptions 146 350 175 350 6240 Postage & Delivery 988 1,100 800 1,200 5250 Publications 35 150 50 100 5270 Bank Charges - - - 100 6280 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 6426 State Fine Expense 42,682 38,000 40,000 60,000 5430 Legal Fees 72 690 300 500 5520 Telephone 75 200 600 650 5625 Electricity 3,600 5530 Travel/Meals/Lodging Expense 215 1,000 400 1,000 6533 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 $ 116,110 $ 157,610 32 FIRE Fire 7FI 1. Marshal t Doug - - A Shift Fire Captain �`rchnnloJW Flrtsf#gl,tr*rl Flrolighter! Ficefighterl PAramedlc tl 9"0 Paramadlc Paramedic Jawuyrra Gr<ihair�r Norwell � B Shim. Fire Caplaln - Fire I Operabong Stuart Firelighrerf Flrell+ghter! Firefighter! Paramedic Paranlrsrllt Paremodle HaOh Hams! Scall giAil`,criC Revenue & Expense Summary C -EMs Curtis Srrrlth Flrefilghterl Flreflghtert Firaligh1W ParamncfJr Paramedic ParamedicFtic N9tirgan „ kali lenses Revenues 1 312,4291 142,000 1 147,250 298,800 Expenditures 1 971,401 1 1,255,762 1 1,158, 30 1 1,595,479 33 rojec a op e Actual Budgeted Year End 1 Budget 2005-2006 2006-2007 2006-2007 2007-2008 Revenues 1 312,4291 142,000 1 147,250 298,800 Expenditures 1 971,401 1 1,255,762 1 1,158, 30 1 1,595,479 33 Town of Prvspey,_ Texas lkp t: Fire re / E M 4 • 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 Fire/EMS 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 I'S Town of Prosper Adopted Departmental Budget p P Fiscal Year, 2007-2008 Summary of Revenue Fund: GE'NERAII._FU-Na 10 Department: Fire 30 4030 Miscellaneous 4230 Other Permits 4310 Charges for Services A B C D 225 4,000 - 5,000 4410 Revenue projected - 4411 Collin Co. Fire Association Actual Budgeted Revenue Adopted Budget Account - Revenue FY Current F Y Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 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 - - - - 4910 Other Revenues - - - - Totals $ 312,429 $ 142,000 $ 147,250 $ 298,800 35 Fund: (3EIVERAL FUND _ 10 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Ene 30 5110 A 8 C d 663,864 5115 Expenditures 127,442 112,908 112,908 115,000 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 Salaries - Longevity 5110 Salaries & Wages 407,856 539,732 454,043 663,864 5115 Salaries - Overtime 127,442 112,908 112,908 115,000 5120 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 S 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 & 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/Oil/Inspections 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: Fiero 5440 A e C D 79,204 5450 Expenditures 10,084 11,140 11,140 10,150 Budgeted Projected Adopted Budget Account Actual Expense Current FY Expense Current far Code Title of Account FY 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 Telephone 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 - - - - $480 Contracted Services 17,703 28,660 26,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 - - - 6524 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 I Seminar 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,250 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 Public Work% Olrcctor Flank Jatornin _— -- — -ALL------ -- Tasks Maintenance r Worker w Wastewater Operator Pub0c Works Street Superintendent Water Operator Sherman Brawn Construction Inspector manual Warne Devon Kennedy Maintenance Workers Maintenance Worker Mairdenance Worker 2007-2008 Dustin Clair Tony Acevedo Hobestu Aielcre Alphonso WlAlams Revenue & Expense Summary Revenues - 11 - I - FEt end tures 223,774 1 339,339 1 332,449 1 3 1, 5 38 rode Adopted Actual Budgeted Year End Budget 2005-2006 2006-200712006-2007 2007-2008 Revenues - 11 - I - FEt end tures 223,774 1 339,339 1 332,449 1 3 1, 5 38 Department: Maintain street and traffic safety through the Street Improvement Program, drainage work, sidewalk and d curb repair and pothole repair. This responsibility also includes the maintenance of signs, makings, d 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 Town of Prosper I-ISP'ED'R Adopted Departmental Budget pFiscal Year, 2007-2008 Summary of Expenditures Fund, GENERAL FUND 10 Department: Streets 40 5110 Salaries & Wages A B C D 5140 Salaries - Longevity 6145 Expenditures Projected Medicare Expense 5155 SUTA Expense Actual Budgeted Expense Adopted Budget Account Life Insurance / AD & D Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 6115 Salaries - Overtime 5120 Salaries - Leave Time 5140 Salaries - Longevity 6145 Social Security Expense 5150 Medicare Expense 5155 SUTA Expense 5160 Health Insurance 6166 Dental 6170 Life Insurance / AD & D 6173 AD & D 6180 TMRS Expense 6185 Short/Long Term Disability 5190 Contract Labor 6191 Hiring Cost 6210 Supplies 6220 Office Equipment 5230 Dues & subscriptions 5290 Miscellaneous 5310 Rental Expense 5320 Repair & Maintenance 5321 Signal Light Repairs 6340 Building Repairs 5350 Vehicle Expense 5353 Gas/Grease/OlUlnspections 5400 Uniform Expense 5480 Contracted Services 6620 Telephone 6621 Cell Phones 5626 Electricity 6530 Travel/Lodging/Meals Expense 5536 Training / Seminars 6620 Tools & Equipment 6630 Safety Equipment 5640 Signs & Hardware 55,610 57,373 57,373 71,018 3,412 5,000 5,000 5,000 1,072 - - - 1,825 2,000 1,450 2,000 3,872 3,991 3,991 4,837 905 933 933 1,131 268 540 540 540 8,617 8,867 8,867 8,148 784 798 798 623 204 250 250 90 44 - - 191 4,046 4,009 4,009 6,499 451 786 788 532 - 31,125 40 40 - 1,729 7,000 5,000 4,400 3,600 500 2,500 - 6,000 5,000 10,500 180 - - - 6,000 5,908 4,800 215 5,500 309 1,670 32,800 - 500 472 1,300 9,090 50,000 600 600 6,773 5,700 - 980 2,376 8,500 3 40 6,000 8,000 1,400 128,000 510 2,000 40,000 5,840 2,000 8,000 5,000 6,000 1,400 128,000 510 1,500 45, 000 6,000 2,000 8, 000 Fund: QF ,NERAL FUND 10 Department: Streets 400 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 PARKS & RECREATION l Wastewater Operator Sharman Brown i i Maintenance Workers Dustin Clark. Alphonso Wollkams Expense Summary Public Works Manager hFar�amin Parks Malmenenre Worker Saul 6 Len ltitz I Public Works __— I ConMiruction inspector I I �i 1 Maintenance Worker I Parke Maintenance Street Superintendent Manuel Parga Maintenance Worker Roberto Alejos W star Operator Devon Kennedy avenues x endltums 29,561 1 86,418 74,248 221,549 42 Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 avenues x endltums 29,561 1 86,418 74,248 221,549 42 n est: Warks &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 Adopted Departmental Budget P7 pE Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: Parks 60 6110 Salaries & Wages A B C D 6145 Social Security Expense 6150 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 1 2006-2007 1 2006-2007 1 FY 2007-2008 6110 Salaries & Wages 6116 Salaries - Overtime 5140 Salaries - Longevity 6145 Social Security Expense 6150 Medicare Expense 6166 SUTA Expense 6160 Health Insurance 6166 Dental 5170 Life Insurance / AD & D 5173 AD & D - Standard 6180 TMRS Expense 6186 ShortlLong Term Disability 5190 Contract Labor 6210 Supplies 5212 Building Supplies 5230 Dues & Subscriptions 6240 Postage & Delivery 6280 Printing & Reproduction 6290 Miscellaneous 6320 Repair & Maintenance 5360 Vehicle Expense 6363 Gas/Oil/Grease/Inspection 5400 Uniforms 6430 Legal Fees 6480 Contracted Services 6620 Telephone 6621 Cell Phone 6623 Water 6625 Electricity 6530 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,649 44 INSPECTIONS/CODE ENFORCEMENT Oullding Qlflclal` f Sr. Town Planners Bryan Auseinbaugh P lumb(n9 In ePWor Larry Sandoval .-aftomm Plarm It Technlcatlon Pamela Evarm Cade Enlorcernent Officer SuIlding tnepecior Lee Doolln Revenue & Expense Summery Revenues 1 668,3041742,740 1 769,090 1 793,200 t*xpendltures 1 324,090 1 494,212 1 462,796 1567,951 45 Projected Adopted Actual Budgeted Year End Budget I 2005-2006 2006-2007 2006-2007 2007-2008 Revenues 1 668,3041742,740 1 769,090 1 793,200 t*xpendltures 1 324,090 1 494,212 1 462,796 1567,951 45 EDepanme«t: ltlwpec°tions / Code l nfurcement / health Inst vc1ions 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 0 4011 A B C D 100 - Revenue Projected Saturday Inspection Fee - - Budgeted Revenue Adopted Account Actual Revenue Current F Y Current FY Budget for Code Title of Account FY 2005-2006 1 2006-2007 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 PEj Fiscal Year, 2007-2008 TOWN Summary of Expenditures Fund: GENERAL FUND 10 Department: insaeclinns 80 5110 A B C D 336,716 6115 Expenditures Projected 10,000 15,000 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 5110 Salaries & Wages 186,122 290,968 261,905 336,716 6115 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 5165 Dental 1,574 2,395 2,395 2,181 6170 Life Insurance 1 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 5180 Contract Labor 1,814 2,300 - - 6191 Hiring Cost 39 160 160 80 6210 Supplies 5,357 7,200 7,200 7,200 6212 Building Supplies 818 480 500 520 5220 Office Equipment 2,982 5,300 5,500 6,134 5230 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 5270 Bank Charges - 200 200 200 5280 Printing & Reproduction 1,748 5,255 5,300 5,300 5290 Miscellaneous 60 - - 100 5320 Repair BMaintenance 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 5363 Gas/GreatWOil/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 5416 Engineering Fees 600 1,000 1,000 1,000 5418 IT Fees 3,293 4,000 7,000 6,000 5430 legal Fees 632 2,000 3,000 3,000 6465 Public Relations 196 500 500 300 5480 Contracted Services - 13,660 13,660 13,660 48 Fund: GENERAL FUND 10 Department: Inspections 80 5520 Telephone A B C D 6521 Cell Phones 3,970 Expenditures Projected 10,897 5525 Electricity Actual Budgeted Expense Adopted Budget Account Gas (Building) Expense FY Current FY Current FY for Code Title of Account 2005-2006 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 5624 Gas (Building) - - - - 5630 Travel / Lodging / Meals Expense - 1,500 1,500 2,000 5633 Mileage Expense - 250 100 250 6536 Training / Seminars 4,973 3,850 4,500 5,850 5620 Tools & 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 Sr, Town Planner Building, Offidar Sr. Town Planner — f Chris Copple � Bryan Ausenbaugh Wadey Horde" Revenue & Expense Summary evenues 1 74,092 1 66,000 1 133,000 1 91,02U lExpenditures 158,610 1 213,509 180,360 1 419,005 50 rode a Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 evenues 1 74,092 1 66,000 1 133,000 1 91,02U lExpenditures 158,610 1 213,509 180,360 1 419,005 50 �p ,ant: 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 Dwaroment: 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 Town of Prosper Adopted Departmental Budget PT O PER Fiscal Year, 2007-2008 Summary of Expenditures Fund: CEUERAL FUND--- 10 Department: Engineering 5110 Salaries & Wages A B C D 5120 Salaries - Leave Time - Expenditures Projected - 5140 Salaries - Longevity 475 Budgeted Expense Adopted Budget Account Medicare Expense Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5170 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 5150 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 1,000 5212 Building Supplies 300 5220 Office Equipment 950 5230 Dues & Subscriptions 750 S240 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 Ges/Grease/OilAnspections - 5400 Uniform Expense 60 5410 Professional Services - 5412 Audit Fees 5416 Engineering Fees - 5418 IT Fees 850 $430 Legal Fees 5,000 5480 Contracted Services - 53 Fund: GENE86L FUND I D Department: Engineering _ 3520 Telephone A B C D Electricity 5530 Travei/Lodging/Meals Expense Expenditures Projected Mileage Expense 5536 Training / Seminars 5620 Budgeted Expense Adopted Budget Account 6140 Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 3520 Telephone 3521 Cell Phones 5525 Electricity 5530 Travei/Lodging/Meals Expense 5633 Mileage Expense 5536 Training / Seminars 5620 Tools & Equipment 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles Totals $ 54 $ 1,725 1,580 500 1,200 1,000 1,500 200 $ 130,716 Town of Prosper Adopted Departmental Budget pi � Fiscal Year, 2007-2008 Summary of Revenue Fund: GENERAL FUND 14 Department: Planning 2Q 4030 Miscellaneous 9,701 A B 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 9,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 1'* Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Fund: GENERAL FUND 10 Department: Plgnnin90 6110 Salaries &Wages A B C D 5116 Salaries - Overtime - Expenditures Projected 2,000 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 1 2006-2007 FY 2007-2008 6110 Salaries &Wages 75,213 106,000 71,154 123,859 5116 Salaries - Overtime - - - 2,000 5120 Salaries - Leave Time 4,924 - - - 5140 Salaries - Longevity 650 275 25 450 5145 Social Security Expense 5,009 6,595 4,413 7,831 6160 Medicare Expense 1,171 1,542 1,032 1,831 5165 SUTA Expense 755 540 418 810 6160 Health Insurance 3,704 8,867 6,548 10,185 6165 Dental 337 798 532 779 6170 Life Insurance / ADBD 161 190 256 113 6173 AD & D - Standard 29 - - 334 6180 TMRS Expense 3,377 6,664 4,771 10,522 6186 ShortlLong 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 5220 Office Equipment 187 2,500 2,500 6,200 5230 Dues / Subscriptions 678 600 600 1,125 5240 Postage & Delivery 58 200 510 250 6250 Publications - - - 125 5260 Advertising - - - 40 5280 Printing & Reproduction 495 1,000 500 500 5290 Miscellaneous - - - - 6310 Rental Expense - - - - 6320 Repair & Maintenance - - - - 5326 Copier Lease 2,486 2,400 2,400 5,200 5330 Copier Expense - - - - 5340 Building Repairs 505 3,000 3,000 2,500 5350 Vehicle Expense - - - - 6410 Professional Services 38,000 38,000 38,000 41,026 5416 Engineering Fees - - - - 6418 IT Fees 1,013 6,470 6,470 850 5430 Legal Fees 8,578 8,000 10,000 45,000 5435 Legal Notices / Filings 296 2,000 1,750 2,000 56 Fund: GENERAL FUND 10 Department: Planning 90 6480 Contracted Services A B C D 5625 Electricity 5630 Expenditures Projected Mileage Expense 5536 Training ! Seminars Actual Budgeted Expense Adopted Budget Account Capital Expenditures -Equip Expense FY Current FY Current FY for Code Title of Account 2005-2006 2006-2007 2006-2007 1 FY 2007-2008 6480 Contracted Services 5520 Telephone 5621 Cell Phones 5625 Electricity 5630 Meals/Lodging Expense 5533 Mileage Expense 5536 Training ! Seminars 6640 Signs and Hardware 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles 4,835 5,380 5,380 8,940 1,055 1,440 1,440 3,000 - 500 500 500 - 1,000 1,000 1,000 140 600 750 1,500 - 1,000 1,250 3,645 250 - 3,000 - - 1,800 1,800 - Totals $ 158,610 $ 213,509 $ 180,360 $ 288,288 57 IN TOWN OF sp R ADOPTED BUDGET FY 2007 - 2008 PUBLIC WORKS FUND 20 58 PUBLIC WORKS wastewater Operator S"Mali ayowv Maintenance Workers ` Dustin Clark Alphonso Willian" PutAle Works tlirecrlor Frank Ja,romin PI Parks Maintenance Worker Saul Benitez i iPublIC Works I Conniruction in9pwor i, Maintenance 'Worker Torry Aceveft Street Superintendent Manuel Parga Maintenance Worker i I Roberto Alelas i Revenue & Expense Summary Water Operator i C Oevon Konj dy 6"---- - — — 59 Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 59 Revenues 3,742,3563,266,665 3,266,500 1 3,867,000 Expenditures 1.087,687 1 3,438.653 13,295,019 1 3,851,914 59 ■ ''`� Town of Prosper 'i° u lic - 2008 Town Budget Public Works Fund Summary P S P IF, Net Assets / Reserves Adopted Account FY 05/06 FY 06/07 FY '6' 07 FY 07 / 08 Description Actual Budgeted Projected Budget WATER] SEWER FUND $ 327,687 $ 449,163 $ 458,404 $ OPERATING REVENUES Materials and supplies $ 418,266 $ 820,250 $ 1,280,250 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 1,090,037 $ (171,987) $ (758,962) $ 15,086 Interest Income $ 57,627 $ 25,000 $ 90,000 $ 81,000 TRANSFERSIN Operating transfers $ $ $ $ Transfers In from other funds $ $ $ Total transfers in $ - $ - $ Total Revenues $ 3,742,356 $ 3,266,865 $ 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,660 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 t• $ 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,983 $ 6,651,632 $ 6,651,632 $ 6,623,113 Net Assets, ending $ 6,651,632 $ 6,479,645 $ 6,823,113 $ 6,638,199 16% Reserve $ 366,337 $ 535,362 $ 567,512 $ 602,751 60 Sanith Town of Prosper FY 2007 - 2008 Adopted Budget Public Works Fund Revenue Sources Service Initiation Fee Miscellaneous tgc. 61 77°k terest M Town of Prosper FY 2007 - 2008 Adopted Budget Public Works Expenditures Interest Paid Personnel Services 2% r 14% Contractual Services 54% 62 Materials & Supplies 22% Department: Public VV o r k s- Water 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 uepancne�zi; Public Works - Sewer - 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. 64 * Town of Prosper IT Adopted Departmental Budget P N O F Fiscal Year, 2007-2008 R Summary of Revenue Fund: 'WATER FUND (PUBLIC -WORKS) 20 Department: Public Works _ 4000 Water / Sewer Initiation Fee A B C D 4005 'Water 2,339,995 2,000,000 Projected 2,320,000 4006 Sewer 446,579 Revenue Budgeted Revenue Adopted Budget Account Sanitation Actual Revenue Current Fiscal Year Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 4010 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 $ 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 65 Town of Prosper `' Adopted Departmental Budget P T P E n Fiscal Year, 2007-2008 1� Summary of Expenditures Fund: WATER FUND (,PUBLIC WORKS) 20 Department: Public Warks _ 5110 A B C D 367,386 5115 Expenditures Projected 10,000 17,276 40,100 Budgeted Expense Adopted Budget Account Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 Salaries - Longevity 5110 Salaries & Wages 227,970 335,854 335,854 367,386 5115 Salaries - Overtime 18,818 10,000 17,276 40,100 5120 Salaries - Leave Time 4,533 - - - 5125 Salaries - Sick 1,677 - - - 6140 Salaries - Longevity 1,300 3,375 3,150 3,775 5145 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 1 AD & D 724 1,095 1,095 439 5173 AD & D - Standard 132 - - 971 5175 TML Expense (Insurance) - - - - 6180 TMRS Expense 17,451 21,972 21,972 34,258 5185 Short/Long Tenn 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 5210 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 5250 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 6,043 8,000 8,000 10,000 5350 Vehicle Expense 4,959 7,000 7,000 11,000 5353 Gas/Grease/OilAnspections 16,083 20,000 20,000 25,500 5400 Uniform Expense 1,332 3,000 3,000 6,510 5410 Professional Services 29,804 21,810 21,810 30,000 $412 Audit Fess 500 600 600 1,500 66 Fund: WATER'FUND fPQ8LlC =RKS] 20 Department: Public Works _ 5416 Engineering Fees A B C D 6418 IT Fees 89 Expenditures Projected 38,470 5430 Legal Fees 23,525 Budgeted Expense Adopted Budget Account Trash Collection Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5520 5416 Engineering Fees 62,775 25,000 25,000 17,000 6418 IT Fees 89 14,300 14,300 38,470 5430 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 T*lephone 4,098 3,200 4,600 12,720 5521 Cell Phones 3,536 5,400 6,650 8,900 6622 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 5640 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 469,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 S 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 $670 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,295,019 $ 3,851,914 67 priOWN OF SPER 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 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% 1 2006 - CO 35% Revenue & Expense Summary Revenues 1 926,275 1 1,791,055 1 1,815,696 1 1,965,930 x n itures 834,524 1 1,706.684 1 1,916,092 11,866,948 70 Projected Adopted Actual Budgeted I Year End Budget 1 2005-2006 2006-2007 2006-2007 2007-2008 Revenues 1 926,275 1 1,791,055 1 1,815,696 1 1,965,930 x n itures 834,524 1 1,706.684 1 1,916,092 11,866,948 70 Town of Prosper Fiscal Year 2007 - 2008 Debt Service Summary Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description I Actual I Budgeted I Projected I 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 $ 24,000 $ 25,500 Total Revenues $ 926,276 $ 1_,791,055 $ 1_,8_1.3,656 $ 1,965,930 EXPENDITURES Debt Service: $ (1,978) $ (6,400) $ (6,400) $ Transfers in for debt service Principal $ 177,357 $ 336,206 $ 336,206 $ 805,192 Interest $ 251,100 $ 490,683 $ 490,683 $ 1,061,756 Total Expenditures $ 428457 $ 826,888 $ 826,889 $ 1,866,948 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) $ Fund Balance, beginning (as stated) $ 222,807 $ 314,558 $ 314,558 $ Fund Balance, ending $ 314,558 $ 398,930 $ 212,122 $ 71 98,982 212,122 311,104 8/14/07 Rev Town of Prosper �'' Adopted Departmental Budget p TOWN E Fiscal Year, 2007-200$ Summary of Revenue Fund: DEBT SERVICE FUND 30 Department: Int. & Sinking 10 4105 Tax Revenue - Delinquent A a C D 4610 Interest Income 4910 Revenue Projected Transfer In 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 4105 Tax Revenue - Delinquent 4110 Tax Revenue - Current 4115 Penalty & Interest 4610 Interest Income 4910 Other Revenues Transfer In 6,385 2,500 895,379 1,777,555 9,613 3,000 14,899 8,000 38,000 5,000 1,738,156 1,929,430 13,500 6,000 24,000 25,500 Totals $ 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 72 Town of Prosper IT Adopted Departmental Budget owN oF Fiscal Year, 2007-2008 P9 P E R Summary of Expenditures Fund: DEBT SERVICE FUND 30 Department: Int. & Sinking 10 5270 Bank Charges A B C D 6180 2001 Bond Payment 135,839 Expenditures Projected 137,368 6186 1996 Bond Payment - Budgeted Expense Adopted Budget Account 1998 Bond Payment 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 6186 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,624 $ 1,706,684 $ 1,916,092 $ 1,866,948 73 1996 Certificate of Obligation Fiscal Years Ending 9/30 2008 2009 2010 2011 2012 2013 2014 2015 2016 Subtotal 1998 Certificate of Obligation Fiscal Years Ending 9/30 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Subtotal 2001 Certificate of Obligation Fiscal Years Ending 9/30 2008 2009 2010 2011 2012 ER Principal 40,000 45,000 50,000 50,000 55,000 60,000 65,000 65,000 70,000 Principal 40,000 40,000 45,000 45,000 50,000 50,000 50,000 55,000 55,000 60,000 60,000 550,000 Principal 73,700 73,700 77,050 80,400 83,750 74 Schedule of Indebtedness General Fund Interest 30,313 27,740 24,818 21,705 18,410 14,773 10,788 6,611 2,258 157,414 Interest 23,990 22,410 20,790 18,923 17,010 14,835 12,635 10,410 7,935 5,460 2,730 157,128 Interest 63,668 60,536 57,404 54,206 50,870 Fiscal Total 70,313 72,740 74,818 71,705 73,410 74,773 75,788 71,611 72,258 657,414 Fiscal Total 63,990 62,410 65,790 63,923 67,010 64,835 62,635 65,410 62,935 65,460 62,730 707,128 Fiscal Total 137,368 134,236 134,454 134,606 134,620 2001 Certificate of Oblieation [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 Oblieation 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 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 Obllaation 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 �j 2006Certificate of Qblieation (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 Note Fiscal Years €ndins 91,30 2008 Subtotal Total Principal Interest Fiscal Total 71,492 3,575 75,067 71,492 3,575 75,067 24,112,092 9,731,240 33,843,332 `ll T OWN PER. ADOPTED BUDGET FY 2007 - 2008 CAPITAL PROJECT FUND 75 2004 BIND / 2006 BOND 77 CAPITAL PROJECTS Renovate PD- ESipBftslon,fbt growth 2006 Bond U,gag§ Elevated Water Tank. Prosper Tralls Drainage Culverts, Street Paving, Wastewater Plow Reversal, Park Improvements I ro Revenue & Expense Summary 2004 Bond IUsaae: 3 MG Storage Tank, Prosper Tralls Storage Tank, Danville Water Proj, Revenues 12,453,373 1 165,5001 660,312 1 206,100 Expenditures 1 158,380 1 19,491,238 1 9,615,152 1 8,404,244 78 Projected Adopted Actual Budgeted Year End 1 Budget 1 2005-2006 2006-2007 2006-2007 2007-2008 Revenues 12,453,373 1 165,5001 660,312 1 206,100 Expenditures 1 158,380 1 19,491,238 1 9,615,152 1 8,404,244 78 sr �4t P TOWN S PEIN, Town of Prosper Adopted Budget Fiscal Year, 2007-2008 Capital Projects Fund Balance / Reserves Account Description FY 05/06 Actual FY M07 Budgeted FY 06 / 07 Projected Adopted FY 07 / 08 Budget REVENUES CAPITAL PROJECTS $ - $ - $ - $ - REVENUES $ (157 880) $ $ - $ - Proceeds From Bond Issuance $ 12,000,000 $ - $ - $ Miscellaneous $ - $ - $ - $ - Investment Income (Interest) $ 453,373 $ 165,500 $ 660,312 $ 206,100 Total Revenues $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 EXPENDITURES Current: General Government $ 500 $ 66,500 $ 531,541 $ - Capital Outlay $ - $ 19,422,738 $ 9,083,610 $ 8,404,244 Total Expenditures $ 500 $ 19,491,238 $ 9,615,152 $ 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,661,539 Fund Balance, ending $ 19,616,378 $ 290,640 $ 10,661,539 $ 2,463,395 79 P TO S P'ER Fund: Capital Proiects 75 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department: Bonds 10 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 $ 175,000 $ 6,100 485,312 $ 200,000 660,312 $ 206,100 A B C D Revenue Budgeted Projected Adopted Budget Account Actual Revenue Current Fiscal Revenue Current for Code Title of Account FY 2005-2006 1 Year 2006-2007 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 $ 175,000 $ 6,100 485,312 $ 200,000 660,312 $ 206,100 P ISP R Fund:a Hal Pr ' cts 75 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Bons 10 5290 Miscellaneous Expense -2004 500 A B C D Professional Services -2004 Bond - 68,500 Actual Expenditures Projected Adopted Budget Account 383,318 Expense FY Budgeted Current Expense Current for Code Title of Account 2005-2006 FY 2006-2007 FY 2006-2007 FY 2007-2008 5290 Miscellaneous Expense -2004 500 - - - 5411 Professional Services -2004 Bond - 68,500 148,223 - 5412 Professional Services -2006 Bond $ 383,318 - 6110 Capital Expenditures $ 20,690 6111 Capital Expenditures -2004 Bond - 7,357,238 5,894,350 347,622 6112 Capital Expenditures -2006 Bond - 12,065,500 3,189,260 8,035,932 6160 Capital Expenditures -Vehicles - - - - 6210 Bond Costs 157,880 7150 Transfer to General Fund - - - Totals $ 158,380 $ 19,491,238 $ 9,615,152 $ 8,404,244 81 Section 7.1 I of the Town Charter requires a lave Year Capital Program be included in the budget. 1n accordance with this requirement the following information is provided for Water, Wastewater, and Thoroughfare. • 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. - _ • Cost estimates, method of financing, and recommended time schedules for each improvement; and, • 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. f—, - ez V-7 to, as 40 1& 8$ I'`�91ii�.9 - I - I - I - I - I V, I " i en I -P f w a I w I a 1 w1 to j a I to I - I V# I . N 04 Ni w a ZPL4 i7R a4 fps P! N N N N M H N N N N q N Ci N N l _Wo �i Qm a a m M 0 m M a 0 m a V - Im 1 I 111 f I i I f I f I I I f � f a A w w �O LL Q LL N N L LL M H M N q q M N N N N N n - N N w N N ri N [� [U N fV tai N I w NN H ®H or N A i3 A9 69 1pT pN 4pv yp� F C 1 40 N a 8 8 N 8 M 8 H 8 h 8 N y 8 6 49 8 4i 8$ N W q 8 M 8 N [ 8g N N N N M H N N N N q N Ci N N l _Wo �i Qm a a m M 0 m M a 0 m a V - Im 1 I 111 f I i I f I f I I I f � f a ZPL4 E R. i a A w N N N N M H M N q q M N N N N N n - w w N N M N N N w 4Y N I w rt w N g C a ZPL4 E R. i Qin QQv t. . W U a A Qin QQv t. . W U mU�:ALL LL LL 88 M M M � tq � N N N N N N w N N N N N S 8 8 8 8 8$ 8 8 8 8 8 8 818 d S N pN py pN oy pN eR N R pM py pM pN p epA app O O 8 $ O O 8 8 8 O O O O O O80 ipf N N QN M N N N N N N N N N N N fll� llflilll �If fill flill 7G VII S M go s 8 8 8 N 8 N 8 N 8 N ib r wN N N N 8 8 8 8 N 8 N 8 w r 8 w N N r to r N r N N R to w r x CIL g g _1 7G VII S M v u , p c tv ti r t p5p a 16 PW a a c ,C V p 17. OOY 0 0 zl:w �+ o� pl--: I v,�1 ADOPTED BUDGET FY 2007 - 2008 PARKS FUND 60 Parks Dedication Parks Improvement Kil PARKS FUND Revenue & Expense Summary Park Dedication Revenues 99,146 255,000 1 258,000 1 259,540 Expenditures 1 40.30411 31,0001 - Park Improvement Expenditures -1 143,0001 - 35,000 91 Projected Adopted Actual Budgeted Year End Budget 2005-2006 2006-2007 2006-2007 2007-2008 Park Dedication Revenues 99,146 255,000 1 258,000 1 259,540 Expenditures 1 40.30411 31,0001 - Park Improvement Expenditures -1 143,0001 - 35,000 91 Pli,WN OF SPER Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Park Summary Fund Balance PARK FUND Adopted Account FY 06/06 FY 06/07 I FY 06 / 07 I FY 07 /08 I Description Actual Budgeted Projected Budget PARK FUND REVENUES 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,398 $ 424,396 $ 424,396 $ 771,396 Fund Balance, ending $ 424,396 $ 1,031,396 $ 771,396 $ 1,350,396 92 1 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 Dad Revenue Projected 4,500 4620 Interest Income -Park Imp 155 Actual Budgeted Revenue Adopted Budget Account Revenue FY Current Fiscal Current FY for Code Title of Account 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 Dad 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 0111 P T 9PER Fund: Parks Fund BO Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Parks 9 5410 Professional Services -Pk Ded 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 Tule of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5410 Professional Services -Pk Ded 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 Mtn a � i0cl r -i - ADOPTED BUDGET FY 2007 - 2008 IMPACT FEES FUND 65 Water Impact Sewer Impact Thoroughfare Impact 95 IMPACT FEES FUNDS Revenue & Expense Summary Water Expenditures - 796,889 1 144,700 329,200 Wastewater Impact 363,648 1 458 Expenditures - 56,900 - Expenditures 293,300 120,000 Projected pted Zudget Actual Budgeted Year End 2005-2006 2006-2007 2006-2007 2007-2008 Water Expenditures - 796,889 1 144,700 329,200 Wastewater Impact 363,648 1 458 Expenditures - 56,900 - Expenditures 293,300 120,000 1 s TOWN OP SER 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 I Projected Adopted FY 07 / 08 I 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 $ 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 97 M A� P PEI. Fund: Impact Fee Fund 65 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department Impact Fees 9-9 4015 Impact Fees - Water A B C D 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 FY 2006-2007. FY 2007-2008 4015 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,208 - - - 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 4810 Other Revenues - - - - Totals $ 1,288,762 $ 1,208,744 $ 1,403,400 $ 2,223,500 98 F�4 P 7 9PER Fund: Impact Fees Fund 65 Town of Prosper Adopted Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Impact Feg 99 5410 Professional Services 204,391 - A B C D 17,700 - 5420 Professional Services -Sewer - - Expenditures Projected Professional Services-Thorfare - - 12,000 - 6110 Budgeted Expense Adopted Budget Account Capital Expenditures -Water - 796,888 Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 2006-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 Capftal Expenditures -Sewer - - 39,200 - 6140 Capital Expenditures-Thorfare - 293,300 74,000 120,000 6160 Capital Expenditures -Vehicles - - - - 7144 Transfer to Capital Assets (1,160,542) - - - Totals $ - $ 1,090,188 $ 287,600 $ 449,200 99 DW S ADOPTED BUDGET FY 2007 - 2008 SPECIAL REVENUE FUND 67 100 SPECIAL REVENUE Revenue & Expense Summary Police Donations Revenues 8,420 15,0001 Projected Adopted Actual Budgeted Year End Budget 2005-200812006-2007 1,1071 15,000 1 2006-2007 2007-2008 Police Donations Revenues 8,420 15,0001 8,500 13,000 Expenditures 1,1071 15,000 1 3,600 1 7,000 Fire Dept Donations Revenues - 1 15,0001 10,300 13,000 Expenditures 8,748 8,5001 39,0601 13,D00 Wealth & Safety Fair Donations Revenues I - I - I 6,100 r 3400 E nditur�es _ - 3,000 Child Safety Donations 4,7101 3,000 Expenditures Escrow Revenues - - 290.000 - Ex nditures - - Court Security Fund I Revenues I - I - 1 1,8701 1.5001 Expenditures - - - iGil Town of Prosper �''� Adopted Departmental Budget .° Fiscal Year, 2007-2008 SPER Summary of Revenue Fund: SPECIAL REVENUE FUND 67 Department: Sp Rev 1Q 4530 Police Donation 8,420 A B C D 15,000 10,300 13,000 4532 Revenue Projected 3,000 4535 Child Safety Donations - Actual Budgeted Revenue Adopted Account 1,500 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 8,420 15,000 8,500 13,000 4531 Fire Dept Donations - 15,000 10,300 13,000 4532 Health & Safety Fair Donations - - 6,100 3,000 4535 Child Safety Donations - - 4,710 3,000 4536 Court Security Revenue - - 1,870 1,500 4537 Court Technology Revenue - - 2,160 1,800 4610 Interest Income 13 - - - 4915 Escrow Income - - 290,000 - Totals $ 8,433 $ 30,000 $ 323,640 $ 35,300 102 Town of Prosper 4`50R Adopted Departmental Budget PPEFiscal Year, 2007-2008 Summary of Expenditures Fund: Spe(: al Revenue end 67 Department: Spec Rev 1Q 5203 Court Technology Expense A B C D - - - 5205 Expenditures Projected 7,000 5206 Fire Dept Donations Expense Actuai 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 $ 23,500 $ 51,630 $ 24,000 103 Is I T OWN PER. ANNUAL BUDGET FY 2007 - 2,008 ECONOMIC DEVELOPMENT CORPORATION (EDC) 104 ECONOMIC DEVELOPMENT CORP. Economic Development Corporation Board of Directors EDC Director Dan Tolleson l EDC Assistant LM I— . — --- , -- — - --j Beth Larson Revenue & Expense Summery Revenues 540,089 520,000 46 , 4 0,000 Ex enditures 1 230,308 1 324,94 218,351 1 319,066 105 rojected Adopted Actual Budgeted Year End Budget .2005-2006 2006-2007 2006-2007 2007.2008 Revenues 540,089 520,000 46 , 4 0,000 Ex enditures 1 230,308 1 324,94 218,351 1 319,066 105 nepc: F.Collonlic Development Corporation 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. • Promote professional development for staff. 106 14SPER TOWN OF - P Town of Prosper FY 2007 - 2008 Town Budget Economic Development Corporation Net Assets / Reserves ECONOMIC DEVELOPMENT Adopted Account FY 05/06 FY 06/07 FY 06 / 07 FY 07 / 08 Description Actual Bud ted 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 1P14Town of Prosper "' Adopted Departmental Budget TOWN ° r Fiscal Year, 2006-2007 S E Summary of Revenue Fund: Economic Devely ment 80 Department: EDC 65 4030 Miscellaneous $ - $ - $ $ - 4060 NSF Fees - - - 4120 Sales Tax - EDC 502,172 500,000 411,000 390,000 4530 Contributions - - - - 4610 Interest Income - EDC 37,881 20,000 57,000 50,000 4910 Other Revenues 36 - - Totals $ 540,089 520,000 468,000 440,000 108 A B C D Revenue Projected 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 502,172 500,000 411,000 390,000 4530 Contributions - - - - 4610 Interest Income - EDC 37,881 20,000 57,000 50,000 4910 Other Revenues 36 - - Totals $ 540,089 520,000 468,000 440,000 108 Town of Prosper # °�` Adopted Departmental Budget PT, N ER Fiscal Year, 2007-2008 I- Summary of Expenditures Fund: g9onomic Developmenj 80 Department: EDC 65 5001 Master Plan - Other 5110 Salaries & Wages A B C D 88,317 $ 111,520 Expenditures Projected Salaries - Overtime 149 - 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 5,991 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 Short/Long 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 6260 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 & 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 - - - - 5410 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: EcortoftDeuelapr ent _ 80 Department: 6DC 65 5418 A B C D 4,000 5430 Expenditures Projected 8,400 8,400 Actual Budgeted Expense Adopted Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006x2007 2006-2007 1 FY 2007-2008 Telephone 5418 IT Fees 176 500 500 4,000 5430 Legal Fees 2,485 8,400 8,400 9,000 5435 Legal Notices / Filings - 700 700 700 5480 Contracted Services - - - - 5520 Telephone 3,039 3,300 3,300 3,300 5521 Cell Phones 829 900 900 1,700 5524 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