Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03-54 - O
TOWN OF PROSPER, TEXAS ORDINANCE NO. f,3 Jr"�I AN ORDINANCE OF THE TOWN OF PROSPER, TEXAS ADOPTING A BUDGET AND APPROPRIATING RESOURCES FOR THE TOWN OF PROSPER, TEXAS FOR THE FISCAL YEAR BUDGET BEGINNING OCTOBER 1, 2003; 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 Mayor has submitted to the Town Council of the Town of Prosper, Texas ("Town Council")the proposed budget of the revenues and expenditures for conducting the affairs of Prosper and providing a complete financial plan for the fiscal year beginning October 1, 2003 and ending September 30, 2004 and has filed the same with the Town Secretary (the "budget"). A copy of the budget is attached hereto as Exhibit "A" and incorporated herein for all purposes; and WHEREAS, a public hearing was held by the Town Council on said budget on September 16, 2003 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; 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. The proposed budget estimate of revenues and expenditures for Prosper, attached hereto as Exhibit "A", as submitted by the Mayor and appropriated by the Town Council for the fiscal year beginning October 1, 2003 and ending September 30, 2004, is hereby approved and adopted. SECTION 3: Appropriation 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 $ 2,521,936 Water& Sewer Fund $ 2,050,241 State Fines Fund $ 25,760 Interest & Sinking Fund $ 323,477 2001 Bond Fund $ 1,267,275 Thoroughfare Impact Fee Fund ---- ORDINANCE APPROVING THE BUDGET FOR FISCAL YEAR 2003-2004— Page 1 C:\Documents and Settings\new administrator\Local Settings\Temporary Internet Files\OLK4\2004 General Budget Ordinance.doc Park Dedication Fee Fund $ 48,595 Park Improvement Fees Water Impact Fee Fund Sewer Impact Fee Fund SECTION 4: Authority of Town Administrator. Specific authority is hereby given to the Town Administrator 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 6: 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 29th day of September, 2003. CH LES ANG , Mayor ATTEST TO: ANAE JENNIN , Town S tary zi Date of Publication&�rt'"j'd 7.! 4 l�j � � Dallas Morning News—Collin County Edition ORDINANCE APPROVING THE BUDGET FOR FISCAL YEAR 2003-2004—Page 2 C:\Documents and Settings\new administrator\Local Settings\Temporary Internet Files\OLK4\2004 General Budget Ordinance.doc Exhibit A Town of Prosper Fiscal Year 2003-2004 Annual Budget 2003-04 Final Town Budget.xls Annual Budget General Fund Fiscal Year 2003-2004 Town of Prosper GENERAL FUND BUDGET SUMMARY 2004 Proposed Description Budget REV-Administrative 1,946,734.00 REV-Police 27,048.00 REV-Fire/EMS 186,206.00 REV-Streets - REV-Parks 48,595.00 REV-Inspections 327,828.00 REV-Communications - REV-Planning - Total REV $ 2,536,411.00 EXP-Administrative 979,941.94 EXP-Police 438,083.23 EXP-Fire/EMS 686,224.88 EXP-Streets 191,664.40 EXP-Parks 58,375.00 EXP-Inspections 71,659.00 EXP-Communications 4,400.00 EXP-Planning 91,587.66 Total EXP $ 2,521,936.11 Ending Balance-GENERAL FUND 14,474.89 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2003 2004 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance 375,911.00 443,000.00 67,089.00 REV Carry Over State Fines 15,000.00 REV Transfer In-EDC 22,050.00 REV 4030 Miscellaneous 1,544.03 - (1,544.03) REV 4035 3%Construction Fee 16,133.00 120,000.00 103,867.00 REV 4100 Atty Fees-Taxes - - - REV 4105 Property Taxes- Delinquent 1,000.00 6,000.00 5,000.00 REV 4110 Property Taxes-Current 448,356.49 559,640.00 111,283.51 REV 4113 Rollback Taxes 4,914.02 - (4,914.02) REV 4115 Taxes-Penalties 12,000.00 14,000.00 2,000.00 REV 4120 Sales Taxes 543,198.34 612,636.00 69,437.66 REV 4140 Franchise Taxes- Electric 129,100.00 85,000.00 (44,100.00) REV 4150 Franchise Taxes- Telephone 10,000.00 10,000.00 - REV 4160 Franchise Taxes-Gas 6,200.00 6,200.00 - REV 4180 Franchise Taxes-Other 4,700.00 4,700.00 - REV 4215 Annexation Fees 500.00 2,250.00 1,750.00 REV 4220 Zoning Permits 20,000.00 8,760.00 (11,240.00) REV 4225 Plat Fees 15,084.00 10,450.00 (4,634.00) REV 4230 Other Permits 400.00 4,075.00 3,675.00 REV 4610 Interest Income 5,777.00 5,777.00 - REV 4910 Other Revenue 6,292.52 17,196.00 10,903.48 Total REV 1,601,110.40 1,946,734.00 308,573.60 EXP 5110 Salaries&Wages 78,122.25 168,680.00 90,557.75 EXP 5115 Salaries-Overtime 6,000.00 2,000.00 (4,000.00) EXP 5125 Salaries-Sick 830.40 2,000.00 1,169.60 EXP 5140 Salaries-Longevity Pay 1,300.00 1,700.00 400.00 EXP 5145 Social Secruity Expense 5,215.58 8,629.16 3,413.58 EXP 5150 Medicare Expense 1,219.77 2,018.11 798.34 EXP 5155 SUTA Expense 139.63 189.00 49.37 EXP 5160 Health/Dental Insurance 12,053.36 13,500.00 1,446.64 EXP 5175 Liability(TML) 35,458.22 35,458.00 (0.22) EXP 5180 TMRS Expense 2,128.29 3,500.39 1,372.10 EXP 5185 Long Term/Short Term Disability 904.54 1,311.00 406.46 . EXP 5190 Contract Labor 3,780.00 3,780.00 - EXP 5195 TT&L - - - EXP 5210 Supplies 11,400.00 11,400.00 - EXP 5230 Dues Fees Schools Subscriptions 15,840.00 21,838.00 5,998.00 EXP 5240 Postage and Delivery 3,000.00 3,000.00 - EXP 5250 Publications 3,000.00 7,000.00 4,000.00 EXP 5270 Bank Charges 500.00 500.00 - EXP 5280 Printing and Reproduction 4,700.00 4,700.00 - EXP 5290 Miscellaneous Expense 6,000.00 4,359.28 (1,640.72) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2003 2004 Proposed Budget Type Code Account Title Total Budget Total Budget Variance EXP 5310 Rental Expense 12,500.00 14,304.00 1,804.00 EXP 5320 Repairs&Maintenance 2,500.00 2,500.00 - EXP 5350 Vehicle Expense 1,500.00 - . (1,500.00) EXP 5410 Professional Services 100,000.00 100,000.00 - EXP 5430 Legal Fees 77,000.00 140,000.00 63,000.00 EXP 5460 Election Expense 1,720.78 1,354.00 (366.78) EXP 5480 Contracted Services 25,974.00 25,974.00 - EXP 5520 Telephone&Utilities 38,000.00 38,000.00 - EXP 5530 Travel - 4,500.00 4,500.00 EXP 6110 Capital Expenditure 805.43 - (805.43) EXP 6140 Capital Expenditure- Equipment 7,000.00 26,470.00 19,470.00 EXP Contingency(60 Day) - 331,277.00 331,277.00 Total EXP (458,592.25) (979,941.94) (521,349.69) Total 10-Administrative 1,142,518.15 966,792.06 (175,726.09) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2003 2004 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Notations: REV Beginning Balance-Projected carry over funds from 2002-03. REV 4110 Property taxes based on rollback rate of 0.324100 REV 4120 Based on projected 02-03 income of$513,463+$70,000(new business)x 5% EXP 5110 Salaries&Wages-Increase of 4%. Personnel classification changes: 1)Utility Clerk moved to Water/Sewer,2)new City Secretary moved from Water to General,3)full year for Accounting Clerk,4) new Town Administrator. EXP 5125-5185 Increases accordingly per Personnel classification changes. EXP 5230 Increase for City Council Member Orientation and Annual Conference TML. EXP 5250 Increase for change of Town newspaper to Dallas Morning News. EXP 5350 Decrease in vehicle expense. Moved to Travel. EXP 5430 Increase for MUD Attorney. EXP 5530 Increase to correctly expense travel expense previous budget in#5350. EXP Allocation to Reserve Fund. EXP 6140 includes$22,000 for computer servers,firewalls,virus protectin,etc. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 20-Police 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV 4230 Other Permits 4,100.00 4,075.00 (25.00) REV 4440 Accident Reports 80.00 5,777.00 5,697.00 REV 4530 Contributions 12,500.00 17,196.00 4,696.00 Total REV 16,680.00 27,048.00 10,368.00 EXP 5110 Salaries&Wages 132,145.00 187,883.00 55,738.00 EXP 5115 Salaries-Overtime 4,500.00 10,000.00 5,500.00 EXP 5140 Salaries-Longevity Pay 1,500.00 2,400.00 900.00 EXP 5145 Social Secruity Expense 8,471.99 8,760.86 288.87 EXP 5150 Medicare Expense 1,981.35 2,048.91 67.56 EXP 5155 SUTA Expense 42.17 189.00 146.83 EXP 5160 Health/Dental Insurance 18,382.58 18,000.00 (382.58) EXP 5170 Life Insurance 10,000.00 6,914.00 (3,086.00) EXP 5180 TMRS Expense 3,457.12 3,691.85 234.73 EXP 5185 Long Term/Short Term Disability 2,393.90 3,000.00 606.10 EXP 5205 Contribution Expenses 12,500.00 12,500.00 - EXP 5210 Supplies 10,707.00 37,500.00 26,793.00 EXP 5230 Dues Fees Schools Subscriptions 5,737.71 9,500.00 3,762.29 EXP 5240 Postage and Delivery 525.27 2,000.00 1,474.73 EXP 5250 Publications 344.87 600.00 255.13 EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction 205.52 500.00 294.48 EXP 5290 Miscellaneous Expense 83.00 - (83.00) EXP 5310 Rental Expense - - EXP 5320 Repairs&Maintenance 68.78 15,275.00 15,206.22 EXP 5350 Vehicle Expense 20,530.47 20,500.00 (30.47) EXP 5410 Professional Services 1,233.00 6,700.00 5,467.00 EXP 5430 Legal Fees 851.82 4,500.00 3,648.18 EXP 5450 Dispatch Expense 2,700.00 38,260.00 35,560.00 EXP 5520 Telephone&Utilities 3,167.27 8,220.00 5,052.73 EXP 5530 Travel - - - EXP 6110 Capital Expenditure - 8,500.00 8,500.00 EXP 6140 Capital Expenditure- Equipment - 5,200.00 5,200.00 EXP 6160 Capital Expenditure- Vehicle 15,440.61 25,440.61 10,000.00 Total EXP (256,969.43) (438,083.23) (181,113.80) Total 20-Police (240,289.43) (411,035.23) (170,745.80) Notations: EXP 5110 Salaries&Wages-1)$50,000 added for grant officer,2)moved salary previous paid from state fines to police,3)plus 4%merit increase. EXP 5115-5185 Increases according to Salary increase. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 30-Fire 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV 4310 Charges for Services 160,000.00 173,706.00 13,706.00 REV 4530 Contributions 12,500.00 12,500100 - Total REV 172,500.00 186,206.00 13,706.00 EXP 5110 Salaries&Wages 232,802.88 268,810.88 36,008.00 EXP 5115 Salaries-Overtime 40,000.00 42,500.00 2,500.00 EXP 5140 Salaries-Longevity Pay 2,700.00 2,700.00 - EXP 5145 Social Security Expense 16,913.78 16,914.00 0.22 EXP 5150 Medicare Expense 3,955.64 3,956.00 0.36 EXP 5155 SUTA Expense 237.14 378.00 140.86 EXP 5160 Health/Dental Insurance 16,707.85 27,000.00 10,292.15 EXP 5170 Life Insurance 5,878.00 5,878.00 - EXP 5180 TMRS Expense 6,901.91 6,902.00 0.09 EXP 5185 Long Term/Short Term Disability 3,048.16 2,600.00 (448.16) EXP 5190 Contract Labor 15,000.00 18,000.00 3,000.00 EXP 5205 Expense from FD/PD Donations - 12,500.00 12,500.00 EXP 5210 Supplies 22,500.00 38,200.00 15,700.00 , EXP 5230 Dues Fees Schools Subscriptions 10,260.00 11,860.00 1,600.00 EXP 5240 Postage and Delivery 500.00 500.00 - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense 4,200.00 4,500.00 300.00 EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 3,800.00 13,700.00 9,900.00 EXP 5350 Vehicle Expense 9,500.00 10,500.00 1,000.00 EXP 5410 Professional Services 269.00 270.00 1.00 EXP 5430 Legal Fees - - - EXP 5440 EMS 48,800.00 45,500.00 (3,300.00) EXP 5450 Dispatch Expense 3,600.00 3,600.00 - EXP 5520 Telephone&Utilities 4,500.00 10,000.00 5,500.00 EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment 14,000.00 14,500.00 500.00 EXP 6160 Capital Expenditure- Vehicle 50,656.15 124,956.00 74,299.85 Total EXP (516,730.51) (686,224.88) (169,494.37) Total 30-Fire (344,230.51) (500,018.88) (155,788.37) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 30-Fire 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Notations: EXP 5110 Salaries-4%STEP increase in lieu of 4%merit increase. • EXP 5115 Maintain Manning on Medics EXP 5170 Life Insurance for F/Fs(200,000.00) EXP 5205 Expense from FD/PD Donations-Target Items and Fire Prevention. EXP 5210 Protective Clothing,Office Supplies,Fire Hose,Fire Tools,Explorer Program,Fire foam,Uniforms for 26 EXP 5230 Books,Schools,Department Dues,Radio Fees,ISO Inspection Fees EXP 5290 Rehab Fluids,Miscellaneous Items EXP 5320 SCBA Flow Test,SCBA&Bunker Gear Repair,Annual Air Comp Test,Hydrostat Test.Radio Repairs EXP 5350 Fuel and Repair for eight(8)Vehicles EXP 5440 Medical control.Ambulance supplies,Bio waste pick up,Paramedic,EMT and Seminar training. EXP 5450 Dispatching fees to Frisco. 12 X 300. EXP 5520 Telephones,Pagers and Utilities-Increase for new fire station. EXP 6140 Rescue tools for Engine EXP 6160 Capital Expenditure-Payments for existing fire engine and ambulances. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 40-Streets 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV 4320 Impact Fees-Streets 21,175.00 (21,175.00) Total REV 21,175.00 - (21,175.00) EXP 5110 Salaries&Wages 30,239.96 48,682.40 18,442.44 EXP 5115 Salaries-Overtime 4,000.00 4,000.00 - EXP 5125 Salaries-Sick 509.60 578.00 EXP 5140 Salaries-Longevity Pay 1,000.00 1,100.00 100.00 EXP 5145 Social Secruity Expense 2,122.88 3,208.00 1,085.12 EXP 5150 Medicare Expense 496.48 750.00 253.52 EXP 5155 SUTA Expense 43.37 126.00 82.63 EXP 5160 Health/Dental Insurance 2,783.88 9,000.00 6,216.12 EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 866.27 1,301.00 434.73 EXP 5185 Long Term/Short Term Disability 330.72 610.00 279.28 EXP 5190 Contract Labor - - - EXP 5210 Supplies 10,000.00 7,116.00 (2,884.00) EXP 5230 Dues Fees Schools Subscriptions - - - , EXP 5240 Postage and Delivery - - - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense 302.45 - (302.45) EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 130,000.00 109,593.00 (20,407.00) EXP 5350 Vehicle Expense 7,000.00 5,000.00 (2,000.00) EXP 5410 Professional Services 74.00 - (74.00) EXP 5430 Legal Fees - - - EXP 5520 Telephone&Utilities 960.00 600.00 (360.00) EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - - - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (190,729.61) (191,664.40) (934.79) Total 40-Streets (169,554.61) (191,664.40) (22,109.79) Combined Budget Report-GENERAL FUND BUDGET 60-Parks and Recreation 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV 4025 Impact Fees-Parks Dedication 20,000.00 (20,000.00) REV 4120 Sales Taxes 127,500.00 - (127,500.00) REV 4530 Contributions 4,500.00 - (4,500.00) REV 4610 Interest Income REV Transfer-In(Park Fees) - 48,595.00 48,595.00 Total REV 152,000.00 48,595.00 (103,405.00) EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick EXP 5140 Salaries-Longevity Pay - _ - EXP 5145 Social Secruity Expense - _ - EXP 5150 Medicare Expense - _ - EXP 5155 SUTA Expense - _ - - EXP 5160 Health/Dental Insurance - - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense _ - - EXP 5185 Long Terrn/Short Term Disability - _ - EXP 5190 Contract Labor - EXP 5210 Supplies 150.00 150.00 - EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery 1,000.00 500.00 (500.00) EXP 5250 Publications EXP 5270 Bank Charges - 120.00 120.00 EXP 5280 Printing and Reproduction 75.00 75.00 - EXP 5290 Miscellaneous Expense 500.00 500.00 - - EXP 5310 Rental Expense _ - EXP 5320 Repairs&Maintenance 3,750.00 4,000.00 250.00 EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 32,500.00 37,000.00 4,500.00 - - EXP 5430 Legal Fees - EXP 5480 Contracted Services 18,000.00 15,530.00 (2,470.00) EXP 5520 Telephone&Utilities - - - - - EXP 5530 Travel - EXP 6110 Capital Expenditure - _ - EXP 6140 Capital Expenditure-Equipment 2,400.00 500.00 (1,900.00) . EXP 6160 Capital Expenditure-Vehicle - - - Total EXP (58,375.00) (58,375.00) - Total 60-Parks and Rec 93,625.00 (9,780.00) (103,405.00) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 80-Inspections 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV 4210 Building Permits 135,000.00 326,328.00 191,328.00 REV 4230 Other Permits 710.00 1',500.00 790.00 Total REV 135,710.00 327,828.00 192,118.00 EXP 5110 Salaries&Wages 14,405.54 39,000.00 24,594.46 EXP 5115 Salaries-Overtime 1,351.48 2,500.00 1,148.52 EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay 900.00 300.00 (600.00) EXP 5145 Social Secruity Expense 1,032.73 2,220.00 1,187.27 EXP 5150 Medicare Expense 241.59 519.00 277.41 EXP 5155 SUTA Expense 19.55 63.00 43.45 EXP 5160 Health/Dental Insurance 2,460.33 4,500.00 2,039.67 EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 617.15 900.00 282.85 EXP 5185 Long Term/Short Term Disability 228.48 457.00 228.52 EXP 5190 Contract Labor 16,127.50 - (16,127.50) EXP 5210 Supplies 1,500.00 4,450.00 2,950.00 Dues Fees Schools EXP 5230 Subscriptions 294.00 5,000.00 4,706.00 EXP 5240 Postage and Delivery - 500.00 500.00 EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction 257.12 500.00 242.88 EXP 5290 Miscellaneous Expense - 500.00 500.00 EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 745.00 1,500.00 755.00 EXP 5350 Vehicle Expense 423.30 1,500.00 1,076.70 EXP 5410 Professional Services 35.00 - (35.00) EXP 5430 Legal Fees - 4,750.00 4,750.00 EXP 5520 Telephone&Utilities 1,900.00 2,500.00 600.00 EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment 504.95 (504.95) EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (43,043.72) (71,659.00) (28,615.28) Total 80-Inspections 92,666.28 256,169.00 163,502.72 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 80-Inspections 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Notations: REV 4210 Amount of building permit fees is based on 100%increase EXP 5110 Salaries&Wages-Full Time Inspector and 50%of part time Public Works/Inspections clerk EXP 5430 Legal Fees-Review of building code updates(IRC&MEC) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative(Communications Committee) 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay - . - - EXP 5145 Social Secruity Expense - - - EXP 5150 Medicare Expense - - - EXP 5155 SUTA Expense - - - EXP 5160 Health/Dental Insurance - - - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense - - - EXP 5185 Long Term/Short Term Disability - - - EXP 5190 Contract Labor - - - EXP 5210 Supplies - 1,500.00 1,500.00 EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery - - - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - 2,400.00 2,400.00 EXP 5290 Miscellaneous Expense - - - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance - - - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services - 500.00 500.00 EXP 5430 Legal Fees - - - EXP 5520 Telephone&Utilities - - - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - - - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP - (4,400.00) (4,400.00) Total 10-Communications Committee - (4,400.00) (4,400.00) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 90-Planning 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance EXP 5110 Salaries&Wages 36,679.81 61,000.00 24,320.19 EXP 5115 Salaries-Overtime - EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay - 300.00 300.00 EXP 5145 Social Secruity Expense 2,274.15 3,782.00 1,507.85 EXP 5150 Medicare Expense 531.86 884.50 352.64 EXP 5155 SUTA Expense 79.16 63.00 (16.16) EXP 5160 Health/Dental Insurance 1,604.53 4,500.00 2,895.47 EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 928.00 1,534.16 606.16 EXP 5185 Long Tenn/Short Term Disability 211.02 211.00 (0.02) EXP 5190 Contract Labor 1,530.00 - (1,530.00) EXP 5210 Supplies 1,500.00 3,536.00 2,036.00 EXP 5230 Dues Fees Schools Subscriptions 1,400.00 1,897.00 497.00 EXP 5240 Postage and Delivery - 500.00 500.00 EXP 5250 Publications - - - EXP 5280 Printing and Reproduction 800.00 800.00 - EXP 5290 Miscellaneous Expense 200.00 (200.00) EXP 5310 Rental Expense 12,000.00 4,500.00 (7,500.00) EXP 5320 Repairs&Maintenance 100.00 (100.00) EXP 5350 Vehicle Expense 500.00 - (500.00) EXP 5410 Professional Services 39.00 (39.00) EXP 5430 Legal Fees - 4,750.00 4,750.00 EXP 5520 Telephone&Utilities 2,000.00 2,000.00 - EXP 5530 Travel - 1,330.00 1,330.00 EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment 500.00 - (500.00) EXP 6160 Capital Expenditure- Vehicle - - Total EXP (62,877.53) (91,587.66) (28,710.13) Total 90-Planning (62,877.53) (91,587.66) (28,710.13) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 90-Planning 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Notations: EXP 5110 Salaries&Wages-Town Planner EXP 5210 Supplies-Audio/Visual equipment for presentations at council meetings,and public hearings. Laser Printer($1000)and Cartridges($400) $1,400 Digital Camera $300 CD Writer $106 Adobe Acrobat 6.0 $300 Scanner $150 Chairs for Office $180 Shelf for Printer and Scanner $100 Other $1,000 EXP 5230 Dues,Fees,Schools,and Subscriptions American Planning Association(registration) $252 Texas Department of Health(registration) $50 Code Enforcement(reqd continuing education) $200 Planning Advisory Service fee $595 TXAPA Conference registration $300 Registration for other Planning seminars or classes $500 EXP 5310 Rental Expenses 1/2 of EDC/Planning trailer(1/2 of$750/month) $4,500 EXP 5430 Legal Fees(consulation regarding and review of development standards) $4,750 EXP 5530 Travel Mileage Reimbursement for out of town meetings $500 Mileage Reimbursement for land use surveys $50 Mileage Reimbursement for TXAPA $165 Meal Expenses($10 breakfast/$10 lunch/$15 dinner)-TXAPA $115 Meal Expenses($10 breakfast/$10 lunch/$15 dinner)-Other $50 Hotel-TXAPA $450 Annual Budget Water and Sewer Fund Fiscal Year 2003-2004 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 50-Water/Sewer 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance 1,413,863.62 965,576.89 (448,286.73) REV 4000 W/S Service Initiation 9,000.00 10,010.00 1,010.00 REV 4005 Water Sewer Sanitation 900,000.00 1,053,000.00 ' 153,000.00 REV 4010 Connection Type& Construction Fees 163,104.50 228,200.00 65,095.50 REV 4015 Impact Fees-Water 141,772.50 (141,772.50) REV 4020 Impact Fees-Sewer 129,936.50 (129,936.50) REV 4030 Miscellaneous 600.00 500.00 (100.00) REV 4610 Interest Income 15,000.00 15,000.00 Total REV 2,773,277.12 2,272,286.89 (500,990.23) EXP 5110 Salaries&Wages 127,889.75 103,460.48 (24,429.27) EXP 5115 Salaries-Overtime 10,000.00 5,000.00 (5,000.00) EXP 5125 Salaries-Sick 351.36 829.00 EXP 5140 Salaries-Longevity Pay 1,500.00 2,100.00 600.00 EXP 5145 Social Secruity Expense 8,329.38 6,302.00 (2,027.38) EXP 5150 Medicare Expense 1,948.01 1,474.00 (474.01) EXP 5155 SUTA Expense 260.05 252.00 (8.05) EXP 5160 Health/Dental Insurance 15,343.80 18,000.00 2,656.20 , EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 3,463.21 2,572.00 (891.21) EXP 5185 Long Tenn/Short Term Disability 1,189.59 1,473.00 283.41 EXP 5190 Contract Labor - 5,000.00 5,000.00 EXP 5210 Supplies 60,000.00 60,000.00 - EXP 5230 Dues Fees Schools Subscriptions 5,000.00 5,000.00 - EXP 5240 Postage and Delivery 3,186.68 3,187.00 0.32 EXP 5250 Publications - - - EXP 5270 Bank Charges 160.00 160.00 - EXP 5280 Printing and Reproduction 600.00 600.00 - EXP 5290 Miscellaneous Expense 2,000.00 2,000.00 - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 50,000.00 92,088.00 42,088.00 EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 280,000.00 280,000.00 - EXP 5430 Legal Fees 60,000.00 169,532.00 109,532.00 EXP 5470 Trash Collection 144,000.00 144,000.00 - EXP 5520 Telephone&Utilities 170,000.00 170,000.00 - EXP 5530 Travel - - - EXP 5540 Water Testing 12,000.00 12,000.00 - EXP 5560 Sewer Management Fees 80,000.00 80,000.00 - EXP NTMWD/Frisco Water Fees - 467,500.00 467,500.00 EXP 6110 Capital Expenditure 250,000.00 - (250,000.00) EXP 6140 Capital Expenditure- Equipment 11,588.57 40,000.00 28,411.43 EXP 6160 Capital Expenditure- Vehicle - 15,800.00 15,800.00 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 50-Water/Sewer 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance EXP 6175 1999 Bond Payment 17,414.00 17,414.00 - EXP 6180 2001 Bond Payment 58,270.49 58,270.49 - EXP Contingency(60 Day) - 286,226.95 ' 286,226.95 Total EXP (1,374,494.89) (2,050,240.92) (675,746.03) Ending Balance-Water/Sewer 1,398,782.23 222,045.97 (1,176,736.26) Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 50-Water/Sewer 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Notations: EXP 5110 includes$6,000 for 50%of part time Public Works/Inspections clerk EXP 5430 Legal Fees-Increase for growth and MUD Attorney. EXP 6140 Capital Expenditure-Equipment-$4,000 to update computer,$35,000 generator,and$1,000 for computer for temporary clerk EXP 6160 Capital Expenditure-Vehicle-Current truck given to Inspections. New truck for Public Works. Annual Budget )111ticNL‘Y---„ Thoroughfare Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper THOROUGHFARE IMPACT FEE FUND BUDGET 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance - - - REV Thoroughfare Impact Fees - . 82,390.00 82,390.00 REV Interest Income - - Total REV - 82,390.00 82,390.00 EXP Transfer-Out - - Total EXP - - - Total-Thoroughfare Impact Fee Fund - 82,390.00 82,390.00 Annual Budget 31111111 Water Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper WATER IMPACT FEE FUND BUDGET 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance - - REV Impact Fees-Water - 234,108.00 234,108.00 REV Interest Income - - Total REV - 234,108.00 234,108.00 EXP - Total EXP - - - Total-Water Impact Fee Fund - 234,108.00 234,108.00 Annual Budget 34k. Sewer Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper SEWER IMPACT FEE FUND BUDGET 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance - - REV Impact Fees-Sewer ' 162,564.00 REV Interest Income - - Total REV - 162,564.00 - EXP - _ Total EXP - - - Total-Sewer Impact Fee Fund - 162,564.00 162,564.00 Annual Budget Interest and Sinking Fund Fiscal Year 2003-2004 Town of Prosper INTEREST AND SINKING(1&S)FUND 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance - 53,000.00 53,000.00 REV 4105 Property Taxes-Delinquent 15,000.00 9,313.00 (5,687.00) REV 4110 Property Taxes-Current 253,508.98 270,699.56 17,190.58 REV 4610 Interest Income 2,500.00 2,500.00 - Total REV 271,008.98 335,512.56 64,503.58 EXP 5270 Bank Charges - 160.00 160.00 EXP 6180 01 Bond Payment 115,740.98 135,074.00 19,333.02 EXP 6185 96 Bond Payment 71,203.00 68,738.00 (2,465.00) EXP 6190 98 Bond Payment 66,565.00 64,505.00 (2,060.00) EXP 6200 Bond Adminstrative Fees - 2,000.00 2,000.00 EXP Contingency(60 Day) - 53,000.00 53,000.00 Total EXP (253,508.98) (323,477.00) (69,968.02) Total-Interest and Sinking 17,500.00 12,035.56 (5,464.44) Annual Budget 111411 --. Park Dedication Fee Fund Fiscal Year 2003-2004 Town of Prosper PARK DEDICATION FEE FUND 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Fees-Parks Dedication 20,000.00 48,595.00 28,595.00 REV Interest Income - - - Total REV 20,000.00 48,595.00 28,595.00 EXP Transfer-Out(P&R) - 48,595.00 48,595.00 Total EXP - (48,595.00) (48,595.00) Total-Park Fees 20,000.00 - (20,000.00) Annual Budget Park Improvement Fee Fund Fiscal Year 2003-2004 Town of Prosper PARK IMPROVEMENT FEE FUND 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Fees-Parks Improvement REV Interest Income - - - Total REV - - - EXP Transfer-Out - - Total EXP - - - Total-Park Fees - - - 1341 Annual Budget State Fine Fund Fiscal Year 2003-2004 Town of Prosper STATE FINES FUND BUDGET 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance REV Beginning Balance REV 4410 Fines 76,000.00 102,300.00 26,300.00 REV 4425 Time Payment Fees - 550.00 550.00 REV 4610 Interest Income 155.80 136.00 (19.80) Total REV 76,155.80 102,986.00 26,830.20 EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay - - - EXP 5145 Social Security Expense - - - EXP 5150 Medicare Expense - - - EXP 5155 SUTA Expense - - - EXP 5160 Health/Dental Insurance - - - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense - - - EXP 5185 Long Tenn/Short Tenn Disability - - - EXP 5210 Supplies 27,475.00 - (27,475.00) EXP 5230 Dues Fees Schools Subscriptions 9,271.29 - (9,271.29) EXP 5240 Postage and Delivery 774.73 - (774.73) EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense 550.00 - (550.00) EXP 5320 Repairs&Maintenance 31.25 - (31.25) EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 195.00 - (195.00) EXP 5420 Municipal Court/Judge Fees 6,000.00 6,000.00 - EXP 5425 State Fines Expense 19,760.00 19,760.00 - EXP 5430 Legal Fees 500.00 - (500.00) EXP 5450 Dispatch Exp 1,300.00 - (1,300.00) EXP 5520 Telephone&Utilities 3,000.00 - (3,000.00) EXP 5530 Travel - - - EXP 6110 Capital Expenditure 1,856.66 - (1,856.66) EXP 6140 Capital Expenditure- Equipment 2,000.00 - (2,000.00) Total EXP (72,713.93) (25,760.00) 46,953.93 Ending Balance- State Fines 3,441.87 77,226.00 73,784.13 Notations: The only Expenses allowed payable from State Fines are Municipal Court/Judge Fees and State Fines Expense. Any balance from 2003-04 must be carried over to the following year and used as General Fund Items. Annual Budget 2001 Bond Fund Fiscal Year 2003-2004 Town of Prosper 2001 BOND FUND BUDGET(Fire/EMS) 2002-03 Amended Budget vs.2003-04 Proposed Budget Account Account 2002-03 2003-04 Proposed Budget Type Code Account Title Total Budget Total Budget Variance Beginning Balance(TexPool) 1,266,145.20 REV 4610 Interest Income 20,000.00 20,000.00 Total REV - 1,286,145.20 20,000.00 EXP 6110 Capital Expenditure 1,200,000.00 1,167,114.95 (32,885.05) EXP 5270 Bank Charges - 160.00 160.00 EXP 6140 Equipment 100,000.00 100,000.00 - Total EXP 1,300,000.00 1,267,274.95 (32,725.05) Ending Balance-2001 BOND FUND 18,870.25 AFFIDAVIT OF PUBLICATION STATE OF TEXAS COUNTY OF DALLAS Before me, a Notary Public in and for Dallas County, this day personally appeared Lynda Black, Legal Advertising Representative for the DALLAS MORNING NEWS being duly sworn by oath, states the attached advertisement of: TOWN OF PROSPER as published in THE DALLAS MORNING NEWS —COLLIN COUNTY EDITION on: October 4, 2003 — October 6, 2003 TOWN OF PROSPER, TEXAS ORDINANCE NO. 03-54 AN ORDINANCE OF THE TOWN OF PROPER, TEXAS ADOPTING`A BUDGET AND APPROPRIAT- ING RESOURCES FOR THE TOWN OF PROSPER, TEXAS FOR THE FISCAL YEAR BUDGET BEGINNING. OCTOBER 1, 2003;,PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVID- ING FOR AN- EFFECTIVE DATE OF THIS ORDI- NANCE; AND'PRDVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. (Lynda Black) Sworn to and subscribed before me this October 7, 2003, A.D ‘` p,TTEjyF% —.di+ A �°• � = (Lisa Battenfield d>g7EOF1 .••• . , J :1 . I .; '/ • Town of Prosper Fiscal Year 2003-2004 Amended Budget 2003-04 Final Town Budget (Amended June 2004).xls I Annual Budget General Fund Fiscal Year 2003-2004 Town of Prosper GENERAL FUND BUDGET SUMMARY 2003-2004 2003-2004 Budget Description Approved Budget Amended Budget Variance REV-Administrative 1,946,734.00 2,238,830.00 292,096.00 REV-Police 27,048.00 111,163.00 84,115.00 REV-Fire/EMS 186,206.00 197,706.00 11,500.00 REV-Streets - - - REV-Parks 48,595.00 - (48,595.00) REV-Inspections 327,828.00 2`1,500.00 (76,328.00) REV-Communications - - REV-Planning - - - Total REV $ 2,536,411.00 $ 2,799,199.00 262,788.00 EXP-Administrative 979,941.94 950,855.68 (29,086.26) EXP-Police 438,083.23 564,587.55 126,504.32 EXP-Fire/EMS 686,224.88 716,912.88 30,688.00 EXP-Streets 191,664.40 211,104.93 19,440.53 EXP-Parks 58,375.00 21,375.00 (37,000.00) EXP-Inspections 71,659.00 73,939.00 2,280.00 EXP-Communications 4,400.00 4,400.00 - EXP-Planning 91,587.66 91,587.66 - Total EXP $ 2,521,936.11 $ 2,634,762.70 112,826.59 Ending Balance 14,474.89 164,43630 149,961.41 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance 443,000.00 569,454.00 126,454.00 REV Cany Over State Fines 15,000.00 15,000.00 - REV Transfer In-EDC 22,050.00 22,050.00 - REV 4030 Miscellaneous - - - REV 4035 3%Construction Fee 120,000.00 120,000.00 - REV 4100 Atty Fees-Taxes - - REV 4105 Property Taxes- Delinquent 6.9b0.00 6.000.00 - REV 4110 Property Taxes-Current 559.640.00 559,640.00 - REV 4113 Rollback Taxes - - - REV 4115 Taxes-Penalties 14,000.00 14,000.00 - REV 4120 Sales Taxes 612.636.00 778 278.00 165,642.00 REV 4140 Franchise Taxes- Electric 85.000.00 85,000.00 - REV 4150 Franchise Taxes- Telephone 10.000.00 10,000.00 - REV 4160 Franchise Taxes-Gas 6.200.00 6,200.00 - REV 4180 Franchise Taxes-Other 4.700.00 4,700.00 - REV 4215 Annexation Fees 2,250.00 2,250.00 - REV 4220 Zoning Permits 8,760.00 8,760.00 - REV 4225 Plat Fees 10.450.00 10,450.00 - REV 4230 Other Permits 4.075.00 4,075.00 - REV 4610 Interest Income 5.777.00 5,777.00 - REV 4910 Other Revenue 17.196.00 17,196.00 - Total REV 1,946,734.00 2,238,830.00 292,096.00 EXP 5110 Salaries&Wages 168.680.00 116,000.00 (52,680.00) EXP 5115 Salaries-Overtime 2,000.00 2,000.00 - EXP 5125 Salaries-Sick 2.000.00 2,000.00 - EXP 5140 Salaries-Longevity Pay 1.700.00 600.00 (1,100.00) EXP 5145 Social Secruity Expense 8.629.16 7,192.00 (1,437.16) EXP 5150 Medicare Expense 2.018.11 1,682.00 (336.11) EXP 5155 SUTA Expense 189.00 189.00 - EXP 5160 Health/Dental Insurance 13.500.00 9,000.00 (4,500.00) EXP 5175 Liability(TML) 35.458.00 35,458.00 - EXP 5180 TMRS Expense 3.500.39 2,917.40 (582.99) EXP 5185 Long Term/Short Term Disability 1.311.00 1,311.00 - EXP 5190 Contract Labor 3.780.00 3,780.00 - EXP 5195 TT&L - - - EXP 5210 Supplies 11.400.00 11,400.00 - EXP 5230 Dues Fees Schools Subscriptions 21.838.00 21,838.00 - EXP 5240 Postage and Delivery 3,000.00 3,000.00 - EXP 5250 Publications 7.000.00 8,000.00 1,000.00 EXP 5270 Bank Charges 500.00 500.00 - EXP 5280 Printing and Reproduction 4,700.00 4,700.00 - EXP 5290 Miscellaneous Expense 4.359.28 4,359.28 - Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 5310 Rental Expense 14,304.00 14,304.00 - EXP 5320 Repairs&Maintenance 2,500.00 2,500.00 - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 100,000.00 100,000.00 - EXP 5430 Legal Fees 140,000.00 100,000.00 (40,000.00) EXP 5460 Election Expense 1,354.00 1,354.00 - EXP 5480 Contracted Services 25,974.00 25,974.00 - EXP 5520 Telephone&Utilities 38,000.00 108,550.00 70,550.00 EXP 5530 Travel 4,500.00 4,500.00 - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment 26,470.00 26,470.00 - EXP Contingency(60 Day) 331,277.00 331,277.00 - Total EXP (979,941.94) (950,855.68) 29,086.26 Total 10-Administrative 966,792.06 1,287,974.32 321,182.26 Notes: 1)REV-Actutal beginning balance is reflected. 2)REV 4120-Sales tax increased. Monthly receipts have ranged from$44,427 to$99,407 and have averaged$64,856, more than$13,000 per month than the monthly budgeted amount of$51,053 3)EXP 5110-Salaries&Wages decreased to reflect one less emplyee in Administration. Variety of benefits adjusted. 4)EXP 5250-Publications increased to compensate for large number of notices for annexations. 5)EXP 5430-Legal fees reduced due to less consultation and meeting attendance. 6)EXP 5520-Telephone&Utilities increased to reflect addition of DSL costs and reimbursement to subdivisions for street lighting costs. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 20-Police Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV 4230 Other Permits 4,075.00 4,075.00 - REV 4440 Accident Reports 5,777.00 88.00 (5,689.00) REV 4510 COPS Grant - 100.000.00 100,000.00 REV 4530 Contributions 17,196.00 7,000.00 (10,196.00) Total REV 27,048.00 111,163.00 84,115.00 EXP 5110 Salaries&Wages 187,883.00 281.134.00 96,251.00 EXP 5115 Salaries-Overtime 10,000.00 13.0(,0.00 - EXP 5140 Salaries-Longevity Pay 2,400.00 2,/00.00 300.00 EXP 5145 Social Secruity Expense 8,760.86 17,616.00 8,855.14 EXP 5150 Medicare Expense 2,048.91 4,121.00 2,072.09 EXP 5155 SUTA Expense 189.00 1,449.00 1,260.00 EXP 5160 Health/Dental Insurance 18,000.00 31,500.00 13,500.00 EXP 5170 Life Insurance 6,914.00 6,914.00 - EXP 5180 TMRS Expense 3,691.85 7.146.00 3,454.15 EXP 5185 Long Term/Short Term Disability 3,000.00 3,811.94 811.94 EXP 5205 Contribution Expenses 12,500.00 12,500.00 - EXP 5210 Supplies 37,500.00 37,500.00 - EXP 5230 Dues Fees Schools Subscriptions 9,500.00 9,500.00 - EXP 5240 Postage and Delivery 2,000.00 2,000.00 - EXP 5250 Publications 600.00 600.00 - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction 500.00 500.00 - EXP 5290 Miscellaneous Expense - - - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 15,275.00 15 275.00 - EXP 5350 Vehicle Expense 20,500.00 20,500.00 - EXP 5410 Professional Services 6,700.00 6,700.00 - EXP 5430 Legal Fees 4,500.00 4,500.00 - EXP 5450 Dispatch Expense 38,260.00 38,260.00 - EXP 5520 Telephone&Utilities 8,220.00 8,220.00 - EXP 5530 Travel - - - EXP 6110 Capital Expenditure 8,500.00 8,500.00 - EXP 6140 Capital Expenditure- Equipment 5,200.00 5,200.00 - EXP 6160 Capital Expenditure- Vehicle 25,440.61 25,440.61 - Total EXP (438,083.23) (564,587.55) (126,504.32) Total 20-Police (411,035.23) (453,424.55) (42,389.32) Notes: I)REV 4510-COPS Grant added to reflect source of income 2)REV 4440-Accident reports reduced/Original amount was erroneously budgeted 3)REV 4530-Contributions decreased to reflect actual amounts 4)EXP 5110-Salaries&Wages increased to reflect wages of officers funded by COPS rant. Associated benefits also adjusted. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 30-Fire Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Collin County Fire 0 11,500.00 11,500.00 REV 4310 Charges for Services 173,706.00 173,706.00 - REV 4530 Contributions 12,500.00 12,500.00 - Total REV 186,206.00 197,706.00 11,500.00 EXP 5110 Salaries&Wages 268,810.88 268,810.88 - EXP 5115 Salaries-Overtime 42,500.00 60,000.00 17,500.00 EXP 5140 Salaries-Longevity Pay 2,700.00 2,700.00 - EXP 5145 Social Secruity Expense 16,914.00 16,914.00 - EXP 5150 Medicare Expense 3,956.00 3,956.00 - EXP 5155 SUTA Expense 378.00 378.00 - EXP 5160 Health/Dental Insurance 27,000.00 27,000.00 - EXP 5170 Life Insurance 5,878.00 7,566.00 1,688.00 EXP 5180 TMRS Expense 6,902.00 6,902.00 - EXP 5185 Long Term/Short Term Disability 2,600.00 2,600.00 - EXP 5190 Contract Labor 18,000.00 18,000.00 - EXP 5205 Expense from FD/PD Donations 12,500.00 12,500.00 - EXP 5210 Supplies 38,200.00 40,200.00 2,000.00 EXP 5230 Dues Fees Schools Subscriptions 11,860.00 11,860.00 - EXP 5240 Postage and Delivery 500.00 500.00 - EXP 5250 Publications - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense 4,500.00 13,500.00 9,000.00 EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 13,700.00 14,200.00 500.00 EXP 5350 Vehicle Expense 10,500.00 10,500.00 - EXP 5410 Professional Services 270.00 270.00 - EXP 5430 Legal Fees - - - EXP 5440 EMS 45,500.00 45,500.00 - EXP 5450 Dispatch Expense 3,600.00 3,600.00 - EXP 5520 Telephone&Utilities 10,000.00 10,000.00 - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment 14,500.00 14,500.00 - EXP 6160 Capital Expenditure- Vehicle 124,956.00 124,956.00 - Total EXP (686,224.88) (716,912.88) (30,688.00) Total 30-Fire (500,018.88) (519,206.88) (19,188.00) Notes: 1)EXP 5115-Overtime budget increased. Full time personnel are receiving more oevrtime due to smaller pool of volunteers. 2 EXP 5170-Life insurance adjusted to reflect rate iuncrease. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 40-Streets Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 5110 Salaries&Wages 48,682.40 48,682.40 - EXP 5 1 1 5 Salaries-Overtime 4,000.00 4,000.00 - EXP 5125 Salaries-Sick 578.00 578.00 EXP 5140 Salaries-Longevity Pay 1,100.00 900.00 (200.00) EXP 5145 Social Secruity Expense 3,208.00 3,208.00 - EXP 5150 Medicare Expense 750.00 750.00 - EXP 5155 SUTA Expense 126.00 126.00 - EXP 5160 Health/Dental Insurance 9,000.00 9,000.00 - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 1,301.00 1,301.00 - EXP 5185 Long Term/Short Term Disability 610.00 610.00 - EXP 5190 Contract Labor - - - EXP 5210 Supplies 7,116.00 7,116.00 - EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery - - - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense - - - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 109,593.00 125,000.00 15,407.00 EXP 5350 Vehicle Expense 5,000.00 5,000.00 - EXP 5410 Professional Services - - - EXP 5430 Legal Fees - - - EXP 5520 Telephone&Utilities 600.00 600.00 - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - 4,233.53 4,233.53 EXP 6140 Capital Expenditure- Equipment - - - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (191,664.40) (211,104.93) (19,440.53) Total 40-Streets (191,664.40) (211,104.93) (19,440.53) Notes: 1)EXP 5320-Repairs&Maintenance increased to allow for Town panicipation in County improvement of CR 74,78,and 80. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 60-Parks and Recreation Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay - - - EXP 5145 Social Secruity Expense - - EXP 5150 Medicare Expense - - - EXP 5155 SUTA Expense - - - EXP 5160 Health/Dental Insurance - - - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense - - - EXP 5185 Long Term/Short Term Disability - - - EXP 5190 Contract Labor - - - EXP 5210 Supplies 150.00 150.00 - EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery 500.00 500.00 - EXP 5250 Publications - - - EXP 5270 Bank Charges 120.00 120.00 - EXP 5280 Printing and Reproduction 75.00 75.00 - EXP 5290 Miscellaneous Expense 500.00 500.00 - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 4,000.00 4,000.00 - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 37,000.00 - (37,000.00) EXP 5430 Legal Fees - - - EXP 5480 Contracted Services 15,530.00 15,530.00 - EXP 5520 Telephone&Utilities - - - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure-Equipment 500.00 500.00 - EXP 6160 Capital Expenditure-Vehicle - - - Total EXP (58,375.00) (21,375.00) 37,000.00 Total 60-Parks and Rec (58,375.00) (21,375.00) 37,000.00 Notes: 1)REV-Park fees moved to Park Dedication Fund. Fees are to be used for improvements/property only. 2)EXP 5410-Professional services expenditures eliminated due to decision not to proceed with Parks Master Plan in FY 2003-2004. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 80-Inspections Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV 4210 Building Permits 326,328.00 250,000.00 (76.328.00) REV 4230 Other Permits I.500.00 1,500.00 - Total REV 327,828.00 251,500.00 (76,328.00) EXP 5110 Salaries&Wages 39,000.00 31,625.00 (7,375.00) EXP 5115 Salaries.Ovutme 2,500.00 - (2.500.00) EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay 300.00 - (300.00) EXP 5145 Social S.cruity Expense 2,220.00 1,735.00 (485.00) EXP 5150 Medicare Expense 519.00 406.00 (113.00) EXP 5155 SUTA Expense 63.00 63.00 - EXP 5160 Health/DentalInsurance 4,500.00 2,250.00 (2,250.00) EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 900.00 703.00 (197.00) EXP 5185 Long Term/Short Tern Disability 457.00 457.00 - EXP 5190 Contract Labor - 15,500.00 15.500.00 EXP 5210 Supplies 4,450.00 4,450.00 - Dues Fees Schools EXP 5230 Subscriptions 5,000.00 5,000.00 - EXP 5240 Postage and Delivery 500.00 500.00 - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction 500.00 500.00 - EXP 5290 Miscellaneous Expense 500.00 500.00 - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance 1.500.00 1,500.00 - EXP 5350 Vehicle Expense 1.500.00 1,500.00 - EXP 5410 Professional Services - - - EXP 5430 Legal Fees 4,750.00 4.750.00 - EXP 5520 Telephone&Utilities 2,500.00 2,500.00 - EXP 5530 Travel - - - • EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (71,659.00) (73,939.00) (2,280.00) Total 80-Inspections 256,169.00 1.77,561.00 (78,608.00) Notes: I)REV 4210-Bldg permit revenue decreased to conservative level,although permits have been on the rise. 2)EXP 5110-Salaries&Wages adjsuted to reflect the salary of a Building Official and Building Inspector. Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 10-Administrative(Communications Committee) Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick - - EXP 5140 Salaries-Longevity Pay - - - EXP 5145 Social Secruity Expense - - - LXP 5150 Medicare Expense - - - EXP 5155 SUTA Expense - - - EXP 5160 Health/Dental insurance - - - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense - - - EXP 5185 Long Tetm/Short Term Disability - - - EXP 5190 Contract Labor - - - EXP 5210 Supplies 1,500.00 1,500.00 - EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery - - - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction 2,400.00 2,400.00 - EXP 5290 Miscellaneous Expense - - - EXP 5310 Rental Expense - - - EXP 5320 Repairs&Maintenance - - - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services 500.00 500.00 - EXP 5430 Legal Fees - - - EXP 5520 Telephone&Utilities - - - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - - - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (4,400.00) (4,400.00) - Total 10-Communications Committee (4,400.00) (4,400.00) - Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 90-Planning Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 5110 Salaries&Wages 61,000.00 61,000.00 - EXP 5115 Salaries-Overtime - EXP 5125 Salaries-Sick - - EXP 5140 Salarie,-Longevity Pay 300.00 300.00 - EXP 5145 Social Sxruity E,.pense 3,7N2.0e 3,782.00 • EXP 5150 Medicare Fxp"•nse 854.5u 884.50 - EXP 5155 SUT.A Expense 63.00 63.00 - EXP 5160 Health/Dental Insurance 4,500.00 4,500.00 - EXP 5170 Life Insurance - - - EXP 5180 TMRS Expense 1,534.16 1,534.16 - EXP 5185 Long Term/Short Term Disability 211.00 211.00 - EXP 5190 Contract Labor - - - EXP 5210 Supplies 3,536.00 3,536.00 - EXP 5230 Dues Fees Schools Subscriptions 1,897.00 1,897.00 - EXP 5240 Postage and Delivery 500.00 500.00 - EXP 5250 Publications - - - EXP 5280 Printing and Reproduction 800.00 800.00 - EXP 5290 Miscellaneous Expense - EXP 5310 Rental Expense 4,500.00 4,500.00 - EXP 5320 Repairs&Maintenance - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services - EXP 5430 Legal Fees 4,750.00 4,750.00 - EXP 5520 Telephone&Utilities 2,000.00 2,000.00 - EXP 5530 Travel 1,330.00 1,330.00 - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - - - EXP 6160 Capital Expenditure- Vehicle - - - Total EXP (91,587.66) (91,587.66) - Total 90-Planning (91,587.66) (91,587.66) - ii.\ Annual Budget * r-lc *--'' Water and Sewer Fund Fiscal Year 2003-2004 Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 50-Water/Sewer Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Begirming Balance 965,576.89 1,154,199.00 188,622.11 REV 4000 W/S Service Initiation 10,010.00 10,010.00 - REV 4005 Water Sewer Sanitation 1,053,000.00 1,053,000.00 - RF` 4010 Connection Type& Construction Fees 228.200.00 22`s.2C0.04 'U 4015 Impact F c,•es-Water tZU: 4020 Impact Fees-Sewer RE\ 4030 Miscellaneous 500.00 5J:1.00 - REV 4610 Interest Income 15,000.00 15,000.00 Total REV 2,272,286.89 2,460,909.00 188,622.11 EXP 5110 Salaries&Wages 103,460.48 105,898.00 2,437.52 EXT 5115 Salaries-Overtime 5,000.00 5,000.00 - EXP 5125 Salaries-Sick 829.00 829.00 EX? 5140 Salaries-Longevity Pay 2,100.00 1,500.00 (600.00) EXT 5145 Social Secruity Expense 6,302.00 6,302.00 - EXT 5150 Medicare Expense 1,474.00 1,474.00 - EXT 5155 SUTA Expense 252.00 252.00 - EX? 5160 HeattliDental Insurance 18.000.00 18,000.00 - EXT 5170 Life Insurance - - - EXT 5180 TMRS Expense 2,572.00 2,572.00 - EXT 5185 Long TernvShort Term Disability 1,473.00 1,473.00 - EXT 5190 Contract Labor 5,000.00 5,000.00 - EXT 5210 Supplies 60,000.00 60,000.00 - EXT 5230 Dues Fees Schools Subscriptions 5,000.00 5,000.00 - E1T 5240 Postage and Delivery 3,187.00 3,187.00 - EXT 5250 Publications - - - EXT 5270 Bank Charges 160.00 160.00 - EXT 5280 Mining and Reproduction 600.00 600.00 - EXT 5290 Miscellaneous Expense 2,000.00 2,000.00 - EXT 5310 Rental Expense - - - EXT 5320 Repairs&Maintenance 92,088.00 92,088.00 - EX? 5350 Vehicle Expense - - - ENT 5410 Professional Services 280,000.00 280,000.00 - EXT 5430 Legal Fees 169,532.00 169,532.00 - EXT 5470 Trash Collection 144,000.00 144,000.00 - EXT 5520 Telephone&Utilities 170,000.00 170,000.00 - EXP 5530 Travel - - - EXT 5540 Water Testing 12,000.00 12,000.00 - EXT 5560 Sewer Management Fees 80,000.00 175,000.00 95,000.00 EXT NTMWD/Frisco Water Fees 467,500.00 116,875.00 (350,625.00) EX? 6110 Capital Expenditure - 269,901.50 269,901.50 EXT 6140 Capital Expenditure- Equipment 40,000.00 40,000.00 - Town of Prosper Combined Budget Report-GENERAL FUND BUDGET 50-Water/Sewer Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance EXP 6160 Capital Expenditure-Vehicle 15,800.00 15,800.00 - EXP 6175 1999 Bond Payment 17,414.00 17,414.00 - EXP 6180 2001 Bond Payment 58.270.49 58,270.49 - c.XP Contingency(6)Da} 2S',,2.:6 45 286.226.95 - 1 otal EXP (2,05P 240.92) (2/1(6.354.94) (16,114.02) Ending Balance-Water/Sewer 222,045.97 394,554.06 172,508.09 Notes: 1)Actual beginning balance reflected 2)EXP 5110-Salaries&Wages adjusted to include one additional maintenance worker. 3)EXP 5560-Sewer Mgmt Fees increased to reflect continued cost of sewage hauling from Gentle Creek. 4)EXP-NTMWD/Frisco Water Fees reduced by 75%since water line will not be complete until July. 5)EXP 6110-Gentle Creek/Steeplechase sewer project(S171,313.75)and Preston Road water line expense reflected Annual Budget Thoroughfare Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper THOROUGHFARE IMPACT FEE FUND BUDGET Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance - - - REV REV Thoroughfare Impact Fees 82,390.00 255,000.00 172,610.00 REV REV Interest Income - 1 ecs4'UN: Total REV 82,39(1.C. . 255,000.00 172,610.00 EXP CR 80 Reimbursement l 80,000.00 180,000.00 EXP EXP CR 74,78,and 80 Road 50,000.00 50,000.00 Improvement Total EXP Total EXP - 230,000.00 230,000.00 Ending Balance-Thoroughfare Fees 82,390.00 25,000.00 (57,390.00) Annual Budget )11111 * Water Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper WATER IMPACT FEE FUND BUDGET Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance - REV Impact Fees-Water 234,108.00 234,108.00 - REV Interest Income - Total RE\ 234,108.00 23,1,108.00 EXP Total EXP - - - Total-Water Impact Fee Fund 234,108.00 234,108.00 - Annual Budget slim . Sewer Impact Fee Fund Fiscal Year 2003-2004 Town of Prosper SEWER IMPACT FEE FUND BUDGET Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance - REV Impact Fees-Sewer 162,564.00 162,564.00 REV Interest Income - 1 ota!REV !6%,$64.(N) 162,564.00 - EXP - Total EXP - - - Total-Sewer Impact Fee Fund 162,564.00 162,564.00 - Annual Budget Interest and Sinking Fund Fiscal Year 2003-2004 Town of Prosper INTEREST AND SINKING(1&S)FUND Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance 53,000.00 53,000.00 - REV 4105 Property Taxes-Delinquent 9,313.00 9,313.00 - REV 4110 Property Taxes-Current 270,699.56 270,699.56 - REV 2004 Bond(Accrued Interest) 48,800.00 48,800.00 REV 4610 Interest Income 2.500.00 2,500.00 - 1 otal REV 33 .512.56 334,312.56 48,800.00 EXP 5270 Bank Charges i 60.00 160.00 - EXP 6180 01 Bond Payment 135,074.00 135,074.00 - EXP 6185 96 Bond Payment 68,738.00 68,738.00 - EXP 6190 98 Bond Payment 64,505.00 64,505.00 - EXP 6200 Bond Adminstrative Fees 2,000.00 2,000.00 - EXP Contingency(60 Day) 53,000.00 53,000.00 - Total EXP (323,477.00) (323,477.00) - Total-Interest and Sinking 12,035.56 60,835.56 48,800.00 Annual Budget Park Dedication Fee Fund Fiscal Year 2003-2004 Town of Prosper PARK DEDICATION FEE FUND Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Fees-Parks Dedication 48,595.00 16,473.00 (32,122.00) REV Interest Income - - - Total REV 48,595.00 16,473.00 (32,122.00) Total EXI' - - Total-Park Fees 48,595.00 16,473.00 (32,122.00) Notes: I)Park Dedication Fees have been moved to appropriate fund and reduced. Annual Budget Park Improvement Fee Fund Fiscal Year 2003-2004 Town of Prosper PARK IMPROVEMENT FEE FUND Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance Beginning Balance 226,000.00 226,000.00 REV Fees-Parks Improvement - - - REV Grant Income - 173,047.00 173,047.00 REV Interest Income - - - Total REV - 399,047.00 399,047.00 EXP Capital Expediture(Soccer 389,64').0( i89,o,r6.';0 Fields) - Total EXP - 389,646.00 389,646.00 Total-Park Fees - 9,401.00 9,401.00 Notes: 1)Beginning balance added 2)REV-Grant income added 3)EXP-Expenses for soccer fields added i Annual Budget *pi._ EDC Fund Fiscal Year 2003-2004 Town of Prosper EDC FUND 2004 2004 Account Account Proposed Proposed Budget Type Code Account Title Budget Budget Variance REV Beginning Balance 255,000 255,000 - REV Sales Tax Revenue 200,000 259,426 59,426 Total REV 455,000 514,426 59,426 EXP 5110 Salaries&Wages 80,050 80,050 - EXP 5115 Sala s-..1`N,.r'nnc - EXP 5125 Salari,- -Sick EXP 5140 Sala,'es-Longevity Pay - EXP 5145 Social Secruit;. Expense, - EXP 5150 Medicare Expense - EXP 5155 SUTA Expense - EXP 5160 Health/Dental Insurance - EXP 5175 Liability(TML) - EXP 5180 TMRS Expense - EXP 5185 Long Term/Short Term Disability - EXP 5190 Contract Labor - EXP 5195 TT&L - EXP 5210 Supplies 2,000 2,000 - EXP 5230 Dues Fees Schools Subscriptions 1,250 1,250 - EXP 5240 Postage and Delivery 2,570 2,570 - EXP 5250 Publications - EXP 5270 Bank Charges - EXP 5280 Printing and Reproduction 1,500 1,500 - EXP 5290 Miscellaneous Expense 1,800 1,800 - EXP 5310 Rental Expense 6,427 6,427 - EXP 5320 Repairs&Maintenance I,200 1,200 - EXP 5350 Vehicle Expense - EXP 5410 Professional Services 63.200 63,200 - EXP 5430 Legal Fees 10,500 10,500 - EXP 5460 Election Expense - EXP 5480 Contracted Services - EXP 5520 Telephone&Utilities 6,990 6,990 - EXP 5530 Travel 750 750 - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - Public Library 10,000 10,000 - Rental Sign 1,750 1,750 - City Sign 10,000 10,000 - Parks and Rec - Total EXP (199,987) (199,987) - Ending Balance-EDC FUND 255,013.00 314,439.00 (59,426) Annual Budget State Fine Fund Fiscal Year 2003-2004 Town of Prosper STATE FINES FUND BUDGET Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance REV Beginning Balance REV 4410 Fines 102,300.00 102,300.00 - REV 4425 Time Payment Fees 550.00 550.00 - REV 4610 Interest Income 136.00 136.00 - :otai REV ;12,936.00 102,986.00 - EXP 5110 Salaries&Wages - - - EXP 5115 Salaries-Overtime - - - EXP 5125 Salaries-Sick - - EXp 5140 Salaries-Longevity Pay - - - EXP 5145 Social Secruity Expense - - - EXp 5150 Medicare Expense - - - EXP 5155 SUTA Expense - - - EXP 5160 Health/Dental Insurance - - - EXP 5170 Life Insurance - - - Exp 5180 TMRS Expense - - - EXP 5185 Long Term/Short Term Disability - - - EXP 5210 Supplies - - - EXP 5230 Dues Fees Schools Subscriptions - - - EXP 5240 Postage and Delivery - - - EXP 5250 Publications - - - EXP 5270 Bank Charges - - - EXP 5280 Printing and Reproduction - - - EXP 5290 Miscellaneous Expense - - - EXp 5320 Repairs&Maintenance - - - EXP 5350 Vehicle Expense - - - EXP 5410 Professional Services - - - EXP 5420 Municipal Court/Judge Fees 6,000.00 6,000.00 - EXP 5425 State Fines Expense 19,760.00 19,760.00 - EXP 5430 Legal Fees - - - EXP 5450 Dispatch Exp - - - EXP 5520 Telephone&Utilities - - - EXP 5530 Travel - - - EXP 6110 Capital Expenditure - - - EXP 6140 Capital Expenditure- Equipment - - - Total EXP (25,760.00) (25,760.00) - Ending Balance- State Fines 77,226.00 77,226.00 - Notations: The only Expenses allowed payable from State Fines are Municipal Court/Judge Fees and State Fines Expense. Any balance from 2003-04 must be carried over to the following year and used as General Fund Items. 111111 - Annual Budget 2001 Bond Fund Fiscal Year 2003-2004 Town of Prosper 2001 BOND FUND BUDGET(Fire/EMS) Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance Beginning Balance(TexPool) 1,266,145.20 1,266,145.20 REV 4610 Interest Income 20,000.00 20,000.00 - Total REV 1,286,145.20 1,286,145.20 - EXP 6110 Capital Expenditure i.'67.1149 1,167,1 14.95 - EXP 5270 Bank Charges I,SO 00 160.00 - EXP 6140 Equipment 100,000.00 100,000.00 - Total EXP 1,267,274.95 1,267,274.95 - Ending Balance-2001 BOND FUND 18,870.25 18,870.25 Annual Budget **-114\ , Series 2004 CO Fund Fiscal Year 2003-2004 Town of Prosper Series 2004 Certificates of Obligation Account Account 2003-2004 2003-2004 Budget Type Code Account Title Approved Budget Amended Budget Variance Beginning Balance(TexPool) 10,500,000.00 10,500,000.00 REV 4610 Interest Income 57,175.00 57,175.00 Total REV - 10,557,175.00 10,557,175.00 EXP FinancialiLegai Services 80,000.00 80,000.00 LXP 6110 Capital Expenditure ;,280,000.00 1,280,000.00 EXP 5410 Professional Services 147,300.00 147,300.00 Total EXP - 1,427,300.00 1,427,300.00 Ending Balance-Series 2004 BOND FUND - 9,129,875.00 9,129,875.00 Notes: 1)2004 Series Bond Fund created toreflect issuance of COs 2)EXP 6110-Capital Expenditures added to reflect Gentle Ceek/Steeplechase sewer project 3)EXP 5410-Professional services added to reflect Needs Assessment/Facilities Master Plan($97,300)and engineering services for the design of water infrastructure projects($50,000) Administration Tow» Of Prosper MEMORANDUM To: Mayor and Town Council From: Douglas C. Mousel, Town Adminis-tiator\\ Date: Junel,2004 Subject: Amendment of 2003-2004 Budget Description: A number of circumstances have led to the need to amend the Town's 2003-2004 budget (see the following Fiscal Year 2003-2004 Amended Budget). A comparison can be made to year to date numbers by reviewing the current budget reports under separate cover (see Financial Reporting folder). The proposed budget amendments are described below: General Fund In the general fund. increases in the Town's sales tax and a reduction in the Town's legal expenses are significant enough to warrant a budget amendment. Revenues in the General Fund have been adjusted as follows: • The actual beginning balance is reflected • Sales tax revenue has been increased • Revenue from COPS grant has been added • Building permit fees have been decreased to a conservative level, although permit activity for the FY 2003-2004 is increasing • Revenue from the Collin County Fire Association has been added as directed by the Council in November 2003 The net increase in revenue will accommodate the following additional expenditures: • Town participation in a County project to improve to County Roads 74, 78, and 80 • Hiring of a Building Inspector/Plan Reviewer • Reimbursement of past street lighting costs for subdivisions In addition, the following expenditures have been adjusted: • Police salaries and benefits have been increased to reflect the positions funded by the COPS grant Item #12 of the June 8, 2004 Town Council Meeting - Page 1 of 3 • Salaries & Wages and benefits in Administration have been decreased to reflect the impact of having one less employee • Contract Labor in Inspections has been adjusted to reflect the costs of contract labor in the first part of FY 2003-2004 • Salaries & Wages in Inspections have been adjusted to reflect a Building Official rather than an Inspector and Clerk and a proposed Inspector • Fire Department expenditures have been adjusted as directed by the Council in November 2003 Overall, the ending balance of the General Fund is projected to be at least $154,436 at the end �f the 2003-2004 fiscal year, and increase of approximately $150,000 from $14,47 5. Water & Sewer Fund In the water and sewer fund, the actual beginning balance is reflected. Also, only a portion of the $467,500 budgeted for water service fees to the NTMWD and the City of Frisco will be used, since the water line will only be active for a quarter of the 2003-2004 fiscal year. Therefore, these fees have been reduced by 75%. Sewer management expenditures exceed the budgeted amount, because the frequency of sewer hauling has increased based on increased volumes. Hauling will continue until near the end of the 2003-2004 fiscal year. Therefore, the sewer management fees have been increased. As part of the budget amendment, staff is also requesting the ability to hire an additional maintenance worker. The additional $171,313.75 required to extend a sewer line east from the Steeplechase subdivision closer to Wilson Creek as part of the Gentle Creek/Steeplechase sewer project is included in the capital expenditures account. When these changes are incorporated, the projected ending balance increases by over $170,000 from $222,046 to $394,554. Thoroughfare Impact Fee Fund A total of $82,390 was budgeted as revenue in the Thoroughfare Impact Fee Fund. To date, the Town has collected over $230,000 in FY 2003-2004. This is primarily due to a development agreement with the developer of the Whispering Farms subdivision. The agreement required the lump sum payment of thoroughfare impact fees prior to final acceptance of the subdivision rather than the individual payment of fees with the issuance of a building permit of each home within the subdivision. The fees were intended to be used towards the improvement of CR 74, 78, and 80. However, two years ago, the Town entered into another development agreement with three developers to finance improvements to CR 78. The agreement requires that $180,000 of the recently collected thoroughfare impact fees be reimbursed to these developers. This expenditure is reflected in the proposed budget amendment. As directed by the Council, the project to improve CR 74, 78, and 80 will be funded by the remaining fees and the general fund. Parks and Recreation, Park Dedication, and Park Improvement Fund A number of Parks and Recreation projects and activities are funded from the general fund. In addition, the Town maintains Park Dedication and Park Improvement Funds. Park dedication and improvement fees are to be used for the sole purpose of land acquisition for parks and improvements to parks. The beginning balance of the Parks Item #12 of the June 8, 2004 Town Council Meeting - Page 2 of 3 Improvement Fund is listed in the proposed budget amendment. This balance is to be combined with a grant secured by the Parks and Recreation Committee to construct soccer fields at the elementary school. These revenues and expenditures are reflected in the Parks Improvement Fund. Series 2004 CO Fund The budget amendment includes a new fund, the Series 2004 CO Fund, which includes the proceeds from the Certificates of Obligation issued earlier this year by the Town. The Fund lists the following expenditures: • Financial and legal services to issue the Certificates of Obligator • Gentle C,eek/Steeplechase Sewer Improvemeni. Project • Need Assessment/Town Facilities Plan ($97,300) • Design fees for pending water projects ($50,000) Recommendation: Staff recommends that the Council approve the amended FY 2003-2004 Town budget, authorizing the adjustment of revenues and expenditures and including the authorization to hire a Building Inspector and Maintenance Worker. • • Item #12 of the June 8. 2004 Town Council Meeting - Page 3 of 3