Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Ord 286-2006 Adopting the 2006-2007 Budget.pdf
CITY OF ANNA, TEXAS Ordinance No. 286-2006 Ordinance Adopting the Budget For the 2006-2007 Fiscal Year AN ORDINANCE MAKING APPROPRIATIONS FOR THE SUPPORT OF THE CITY OF ANNA FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2006 AND ENDING SEPTEMBER 30, 2007 AND ADOPTING THE ANNUAL BUDGET OF THE CITY OF ANNA FOR THE 2006-2007 FISCAL YEAR. WHEREAS, the budget, appended here as Exhibit A, for the fiscal year beginning October 1, 2006 and ending September 30, 2007, was duly presented to the City Council by the City Manager and a public hearing was ordered by the City Council and a public notice of said hearing was caused to be given by the City Council and said notice was published in the McKinney Courier -Gazette and said public hearing was held according to said notice; now, therefore, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF ANNA: SECTION 1. That the appropriations for the fiscal year beginning October 1, 2006, and ending September 30, 2007 for the support of the general government of the City of Anna, Texas, be fixed and determined for said terms in accordance with the expenditures shown in the City's fiscal year 2006-2007 budget, a copy of which is appended hereto as Exhibit A; SECTION 2. That the budget, as shown in words and figures in Exhibit A, is hereby approved in all respects and adopted as the City's budget for the fiscal year beginning October 1, 2006 and ending September 30, 2007. PASSED AND APPROVED this, the 12th day of September, 2006. Ayes 7 Nays 0 Abstained 0 APPROVED: enneth Pelham, Mayor ATTEST: Nat a Wilkison, City Secretary of - 1 of 1 Pages Ordinance adopting the budget 2006-2007.doc 09/12/2006 BUDGET Under the Anna City Charter the City Manager is responsible for submitting a budget for each fiscal year. The city council is responsible for final disposition of the budget. Often the process involves considerable discussion, negotiation and direction from the council to the manager and staff. Such has been the case during this year's budget process. The FY 2007 budget was developed according to the following process: • Department heads were requested to submit budget requests • Department heads submitted budget requests, with written and/or verbal justifications • The Assistant City Manager compiled the department requests • The City Manager reviewed the first draft budget and submitted it to council • Council reviewed the first draft budget and gave general and in some instances specific directions to the manager regarding budget revisions • Several modifications to the budget have been made, at council direction, resulting in the document presented at this time. Municipal budgets include two basic funds — the General Fund and the Utility Fund (including water services, sanitary sewer services, and solid waste collection services). The following are the basic assumptions and primary features of the FY 2007 budgets for the two funds. GENERAL FUND Revenues 1. Tax rate of $0.525 (same total rate as prior year)*. 2. Sales tax collections assume a 30% increase from FY 2006 to FY 2007. 3. Building permit revenues based on 400 permits with average value of $1,700. 4. Court revenues based on just under one citation per day at average fine amount of $200. *Total tax rate is unchanged. However, $0.086381 of the $0.525 total tax rate is dedicated to debt service. In FY 2006 the total $0.525 was for operations and maintenance. Expenditures 1. Personnel a. New position of City Planner, funded in Development Department. b. New position of Project Manager, funded in Administration Department (25%), Development Department (50%), and Economic Development Department (25%). C. Two additional positions in the Police Department (one of those positions authorized recently but will be funded primarily in FY 2007). d. Total salary increases of approximately five percent in the Administration, Development, and Court Departments with provisions for a maximum of $15,000 split between the departments for incentive pay. The Police Department did not give a percentage increase except for the Chief. The two base pays for officers were increased. Incentive pay of $30,600 is included in the Police Budget e. Funding for salary of Planning Tech position moved from Administration Department to Development Department. 2. The Administration Department expenditures include costs associated with furniture, fixtures, and equipment for new City Hall building (on property adjacent to existing buildings) 3. Department requests have been honored as much as possible within parameters provided by council. All department budget requests have been reduced slightly from original draft budget. Proposed FY 2007 requests relative to FY 2006 budgets are as follows: Dept 2006 Budget 2007 Budget % Change Administration Development Fire Ambulance Police Municipal Court Park Streets $687,210 $659,052 -4.1% $605,659 $829,321 +37.4% $195,427 292,897 +49.9% $ 38,798 $ 40,747 +4.5% $455,309 $663,928 +45.8% $154,929 $ 75,935 -50.9% $ 37,750 $ 24,750 -34.4% $319,000 $370,000 +16.0% Total $2,494,082 $2,956,630 +18.5% UTILITY FUND Revenues and Expenditures Utility Fund revenues assume a 20% increase in water, sewer and trash service revenues. This increased is based primarily on residential growth. Utility Fund expenditures include personnel cost increases of 5% and making a previous half time field position into a full time position and $9,000 for incentive pay. Capital expenditures include a ground storage tank at the Fifth Street water plant, continuation of the water meters for radio read, encasement of GTUA water line at future thoroughfares and some equipment upgrades. Proposed FY 2007 requests relative to FY 2006 budgets are as follows: Dept 2006 Budget 2007 Budget % Change Water Dept $1,382,338 $2,280,170 +65.0 Sewer Dept. $1,023,183 $ 628,000 -38.6% Total $2,405,521 $2,908,170 +20.9% Administration Budget Wooksheet General Fund Departments Proposed 2007 Budget Proposed 2007 Budget Revenues Expenditures _ Administration_ $2,003,730.00 $659,052.00 _ 1,344,678.00 Development _ _ $880,500.00 $829,321.00 _ 51,179.00 Fire Department $600.00 _ $292,897.00 _ (292,297.00) Ambulance $0.00 $40,747.00 (40,747.00) Police Department $1,500.00 $663,928.00 (662,428.00) Municipal Court $61,800.00 $75,935.00 (14,135.00) Park $0.00 $24,750.00 (24,750.00) _ Streets _ General Fund Total t $8,500.00 $2,956,630.00 _ $370,000.00 $2,956,630.00 (361,500.00) 0.00 Water and Sewer Fund Departments Proposed 2007 Budget Proposed 2007 Budget Revenues Expenditures _ Water $1,670,850.00 $2,280,170.00 (609,320.00) Sewer $1,245,500.00 $628,000.00 617,500.00 _ Water and Sewer Fund Total $2,916,350.00 _ $2,908,170.00 8,180.00 Debt Service Fund $250,790.00 $249,290.00 1,500.00 Capital Projects Fund $615,000.00 $2,536,286.00 (1,921,286.00) - -- ---- -�---- 9/8/2006 I - -- - -moi -- -- ---- Administration Budget Wooksheet Administration Rev. Periods 1-112006 Annual YTD Estimated Proposed Admin. Rev. Proposed 2007 Budget Budget Actual Year End Budget 2007 Revenues Budget Budget Revenues 10-400-5100 PropertyTax- Current $1,077,109.00 $1,097,742.98 $1,154,103.37 $1,243,730.00 10-400-5100 PropertyTax-Current 10-400-5102 Property Tax Rev. - Delinquent $22,208.00 $63,291.79 $61,712.29 $60,000.00 10-400-5102 Property Tax Revenue - Delinquent 10-400-5103 Property Tax Penalty & Interes_t_ $11,104.00 $30,650.52 $28,265.61 $20,000.00 10-400-5103 Property Tax Penalty & Interest 10-400-5206 Franchise Tax $138,750.00 $237,256.67 $252,158.63 $300,000.00 _ 10-400-5206 Franchise Tax 10-400-5225 Sales Tax Revenue - General $172,425.00 $206,212.96 $225,000.00 $300,000.00 10-400-5225 Sales Tax Revenue - General 10-400-5400 Discounts Earned $0.00 $0.00 $0.00 $0.00 10-400-5400 Discounts Earned 10-400-5491 Gain on sales of Assets $0.00 $0.00 $0.00 $0.00 10-400-5491 Gain on sales of Assets 10-400-5499 Miscellaneous Revenue _ $6,609.00 _ _ _ $11,540.46 $18,300.11 $10,000.00 10-400-5499 Miscellaneous Revenue 10-400-5500 Grant Revenue $0.00 $0.00 $0.00 $0.00 10-400-5500 Grant Revenue 10-400-5530 Interest Revenue $11,750.00 $42,743.45 $50,893.23 $70,000.00 10-400-5530 Interest Revenue 10-400-5711 Returned Ck. Re -Deposited $0.00 $1,205.08 $0.00 $0.00 10-400-5711 Returned Checks Re -Deposited Total Revenue $1,439,955.00 $1,690,643.91 $1,790,433.24 $2,003,730.00 Total Revenue Other Source of Funds Revenues Other Source of Funds Revenues 10-400-5801 Transfers in - Water Fund $0.00 $0.00 $0.00 $0.00 _ 10-400-5801 Transfers in -_Water Fund 10-400-5803 Transfers in - Trust Funds $0.00 $0.00 $0.00 $0.00 10-400-5803 Transfers in - Trust Funds 10-400-5850 Other Finance Source $0.00 $0.00 $0.00 $0.00 10-400-5850 Other Finance Source -Cap Lease 10-400-5855 Other Financial Source $0.00 $0.00 $0.00 10-400-5855 Other Fin.Source - Contrib. Cap. Totals Other _ Source of Funds Revenues $0.00 _ $0.00 $0.00 _$0.00 $0.00 Other Source of Funds Revenues Total Administration Revenues $1,439,955.00 $1,690,643.91 $1,790,433.24 $2,003,730.00 Total Administration Revenue Expenditures _ Payroll Expenditures Payroll Expenditures 10-400-6101 Salaries $316,145.00 $273,920.11 $308,825.70 $345,505.00 10-400-6101 Salaries 10-400-6102 Salaries - Overtime $1,563.00 $3,677.97 $7,161.54 $5,000.00 10-400-6102 Salaries - Overtime 10-400-6114 Payroll Taxes -City FICA $24,185.00 $20,964.11 $28,721.33 $26,867.00 10-400-6114 Payroll Taxes -City Part FICA 10-400-6121 _Part Health Insurance $37,802.00 $31,001.28 $36,299.58 $28,565.00 10-400-6121 Health Insurance 10-400-6125 TMRS Retirement $12,835.00 $12,762.54 $17,141.90 $18,965.00 _ _ 10-400-6125 TMRS Retirement 10-400-6126 Unemployment $834.00 $3,710.07 $5,010.77 $1,702.00 _ 10-400-6126 Unemployment 10-400-6127 Worker's Compensation $1,851.00 $3,989.12 $4,912.00 $8,286.00 10-400-6127 Worker's Compensation 10-400-6129 Miscellaneous Payroll $700.00 $700.00 $700.00 $700.00 10-400-6129 Miscellaneous Payroll Total Payroll Expenditures $395,915.00 $350,725.20 $408,772.82 $435,590.00 Total Payroll Expenditures Supplies Expenditures Supplies Expenditures 10-400-6208 Office Supplies $12,828.00 $7,898.11 $8,500.00 $9,000.00 10-400-6208 Office Supplies 10-400-6209 _ Other Supplies - Misc. $5,170.00 $4,273.72 $6,214.25 $6,000.00 10-400-6209 Other Supplies - Misc. 10-400-6212 Postage _ Total Supplies Expenditures $1,633.00 $19,631.00 $627.34 $12,799.17 $854.26 $15,568.51 $1,000.00 10 -400 -621 -2 -Postage $16,000.00 TotalSupplies Expenditures Administration Budget Wooksheet Administration Expend. Periods 1-112006 Annual YTD Estimated Proposed Admin. Expend. Proposed 2007 Budget Budget Actual Year End 2007_ Budget _ Budget Budget Expenditures Maintenance Expenditures Maintenance Expenditures 10-400-6302 Maint. & Repair - Equip. $1,000.00 $96.40 $296.40 750.00 10-400-6302 Maint. & Repair - Equipment 10-400-6303 Maint. & Repair - Buildings $0.00 $0.00 $0.00 0.00 10-400-6303 Maint. & Repair - Buildings 10-400-6305 Maint. & Repair - Other $0.00 $0.00 $0.00 0.00 10-400-6305 Maint. & Repair - Other Total Maintenance Expenditures $1,000.00 $96.40 $296.40 750.00 Total Maintenance Expenitures Services Expenditures Services Expenditures 10-400-6703 Contract Services $41,430.00 $24,617.59 $27,000.00 38,594.00 10-400-6703 Contract Services 10-400-6711 Travel Expense $3,000.00 $3,634.22 $3,165.89 3,000.00 10-400-6711 Travel Expense 10-400-6712 Rental Expense $3,000.00 $2,956.52 $889.01 1,100.00 10-400-6712 Rental Expense 10-400-6715 Appraisal District Fees $9,725.00 $7,643.00 $13,143.00 8,218.00 _ 10-400-6715 Appraisal District Fees 10-400-6716 Election Expenses $12,500.00 $5,892.42 $9,764.67 10,000.00 10-400-6716 Election Expenses 10-400-6721 Education & Training $4,238.00 $2,576.78 $2,316.78 3,500.00 10-400-6721 Education & Training 10-400-6722 Insurance - Property & Liability $9,363.00 $12,929.55 $19,873.40 21,000.00 10-400-6722 Insurance - Property & Liability 10-400-6731 Public Notices - Advertising $1,552.00 $1,131.87 $2,467.67, 3,000.00 10-400-6731_ Public Notices - Advertising 10-400-6753 Legal Expense $50,671.00 $33,645.22 $38,423.21 50,000.00 10-400-6753 Legal Expense 10-400-6754 Accounting Expenses $0.00 $0.00 $0.00 0.00 10-400-6754 Accounting Expenses 10-400-6755 Audit Expense $5,000.00 $5,000.00 $5,000.00 5,000.00 10-400-6755 Audit Expense 10-400-6756 Engineering $0.00 $675.00 $675.00 0.00 10-400-6756 Engineering 10-400-6761 _ Dues, Public., Permits & Lic. $3,242.00 $2,252.87 $3,423.17 3,500.00 10-400-6761 Dues, Public., Permits &Licenses 10-400-6770 Penalties $0.00 $0.00 $0.00 0.00 10-400-6770 Penalties 10-400-6780 Electricity $10,000.00 $2,536.82 $5,212.59 15,000.00 10-400-6780 Electricity 10-400-6781 _ Gas - Natural/Propane $1,500.00 $699.82 $1,114.01 3,000.00 10-400-6781 Gas - Natural/Propane 10-400-6783 Telephones - Pagers $12,000.00 $7,794.10 $11,158.34 13,000.00 10-400-6783 Telephones - Pagers 10-400-6786 Returned Check Expense $0.00 $0.00 $0.00 0.00 10-400-6786 Returned Check Expense 10-400-6799 _ Other Services -Misc. $2,839.00 -$442.34 $7,000.00 8,800.00 10-400-6799 Other Services - Misc. Total Services Expenditures $170,060.00 $113,543.44 $150,626.74 186,712.00 TotalServices Expenditures Capital Expenditures Expenditures Capital Expenditures Expenditures _ 10-400-6911 Machinery & Equipment $25,000.00 $3,114.60 $5,212.60 10,000.00 10-400-6911 Machinery & Equipment 10-400-6921 Buildings & Improvements $2,500.00 $0.00 $550.00 10,000.00 10-400-6921 Buildings & Improvements 10-400-6931 Land & Improvenents _ $73,104.00 $73,104.07 $73,104.07 _ 0.00 10-400-6931 Land & Improvenents 10-400-6941 Other Capital Expenditures $0.00 $0.00 $0.00 0.00 10-400-6941 Other Capital Expenditures Total Capital Expenditures Expenditures $100,604.00 $76,218.67 $78,866.67 20,000.00 Total Capital Expenditures Expenditures Other Uses of Funds Expenditures Other Uses of Funds Expenditures 10-400-9811 Transfers Out- Water Fund $0.00 $0.00 $0.00 0.00 10-400-9811 Transfers Out -Water Fund 10-400-9813 Transfers Out - Trust Funds $0.00 $0.00 $0.00 0.00 10-400-9813 Transfers Out - Trust Funds Totals Other Uses of Funds Expenditures $0.00 $0.00 $0.00 0.00 Totals Other Uses of Funds Expenditures Total Administration Expenditures $687,210.00 $553,382.88 $654,131.14 $659,052.00 Total Administration Expenditures Development Rev. Periods 1-11 2006 Annual YTD Estimated Proposed Development Revenues Budget Actual Year End 1 2007 Budget Development Revenues Budget Budget Development Revenues _ 10-420-5313 Building Permits $750,000.00 $671,924.09 _ $770,804.49 $680,000.00 10-420-5313 Building Permits 10-420-5314 Zoning Fees $5,000.00 $39,214.02 $40,042.32 $40,000.00 10-420-5314 Zoning Fees 10-420-5315 Subdivision Plat Fees $5,000.00 $3,732.00 $4,473.00 $10,000.00 10-420-5315 Subdivision Plat Fees 10-420-5316 Contractor Registration $3,500.00 $3,425.00 $5,825.00 $3,500.00 10-420-5316 Contractor Registration 10-420-5325 Subdivision Inspection Fees $_100,000.00 $258,348.40 $258,348.40 $100,000.00 10-420-5325 Subdivision Inspect.Fees 10-420-5327 Irrigation Permit Fees $17,280.00 $25,600.00 $27,425.00 10-420-5327 Irrigation Permit Fees 10-420-5499 Miscellaneous Revenue $1,500.00 $3,386.80 $3,886.80 _$20,000.00 $27,000.00 10-420-5499 Miscellaneous Revenue Total Development Revenues _ $882,280.00 _ $1,005,630.31 $1,110,805.01 $880,500.00 Total Development Revenues Payroll Expenditures Payroll Expenditures 10-420-6101 Salaries $28,392.00 $29,545.31 $31,994.001 $154,836.00 10-420-6101 10-420-61_02 Salaries - Overtime T_ $500.00 $65.67 $115.67 $0.00 _ _ _Salaries 10-420-6102 Salaries - Overtime 10_-420-6114 Payroll Taxes-City Part FICA $2,171.00 $2,255.20 $2,459.22 $11,876.00 __ 10-420-6114 PR Taxes-City Part 10-420-6121 Health Insurance $4,726.00 $4,092.09 $4,847.79 $14,963.00 _Fica 10-420-6121 Health Insurance 10-420-6125 TMRS Retirement $1,092.00 $950.73 $1,009.25 $8,365.00 10-420-6125 TMRS Retirement 10-420-6126 Unemployment_ _ $81.00 $632.76 _ $809.76 $891.00 10-420-6126 Unemployment 10-420-6127 _ Worker's Compensation _ $395.00 $556.28 $671.58 $990.00 10-420-6127 Compensation 10-4_2_0-6129 Miscellaneous Payroll $100.00 $100.00 $100.00 _ _Worker's 10-420-6129 Miscellaneous Total Payroll Expenditures $37,457.00 $38,198.04 $42,007.271 _$40_0.00 $192,321.00 Payroll Total Payroll Expenditures Supplies Expenditures Supplies Expenditures 10-420-6208 10-420-6209_ _ Office Supplies _ Other Supplies - Misc. _ $2,750.00!1_ $1,250.001 $2,978.36 $546.04 $3,100.00 $830.04 $6,000.00 $ 10-420-6208 Office Supplies 10-420-6209 Other Supplies-_Mis_c. 10-420-6210 Clothing Supplie_ s__ $0.00 $0.00 $0.00 __ _2,000.00 $0.00 10-420-6210 Clothing Supplies 10-420-6212 ______ Postage $1,000.00 $525.39 $714.17 $1,750.00 10-420-6212 Postage 10-420-6216 Vehicle Supplies -Fuel $0.00 $0.00 $0.00 $0.00 _ 10-420-6216 Vehicle Supplies - Fuel 10-420-6217-Vehicle Supplies - Other j $0.00 $0.00 $0.00 _ --u- $0.00 10-420-6217 Vehicle Supplies - Other Total Supplies Expenditures_ ! $5,000.00 $4,049.79 $4,644.21 $9,750.00 Total Supplies Expenditures Maintenance Expenditures 10-420-6301 Maint. & Repair - Vehicles $0.00 $0.00 $0.00 $0.00 Maintenance Expenditures 10-420-6301 Maint. & Repair - Veh. 10-420-6302 Maint. & Repair - Equipment $500.00 $308.75 $529.30 $550.00 10-420-6302 Maint. & Repair - Equip. 10-420-6303 Maint. & Repair - Buildings $1,000.00 $60.00 $610.00 _ $750.00 10-420-6303 Maint. & Rep. - Buildings 10-420-6305 Maint. & Repair- Other $0.001 $0.00 $0.00 $0.00 10-420-6305 Maint. & Repair - Other Total Maintenance Expenditures $1,500.001 $368.75 $1,139.30 $1,300.00 Total Maintenance Expenditures Development Rev. Periods 1-1_1_2.006 Annual YTD Estimated Proposed Development Expenditures Budget Actual YTD 2007 Budget _ Services Expenditures Budget Budget Services Expenditures 10-420-6703 Contract Services $395,152.00 $314,619.62 $382,686.60 $272,000.00 10-420-6703 Contract Services 10-420-6705 Subdivision Inspections $100,000.00 $98,800.00 $109,180.00 $100,000.00 10-420-6705 Subdivision Inspections 10-420-6712 Rental Expense $1,000.00 $3,393.67 $2,984.00 $3,000.00 10-420-6712 Rental Expense 10-420-6721 Education & Training $0.00 $130.00 $230.00 $1,250.00 10-420-6721 Education & Training 10-420-6722 Insurance - Property & Liability $2,500.00 $581.79 $775.72 $1,000.00 10-420-6722 Ins. - Pro. & Liability 10-420-6731 Public Notices - Advertising $800.00 $2,397.39 $2,763.39 $2,500.00 10-420-6731 Public Notices - Adver. 10-420-6753 _ Legal Expense _ $20,000.00 $30,693.41 $33,380.41 $34,000.00 10-420-6753 Legal Expense 10-420-6755 _ _ Audit Expense $750.00 $750.00 $750.00 $1,250.00 10-420-6755 Audit Expense 10-420-6756 Engineering $12,500.00 $833.00 $1,000.00 $1,200.00 10-420-6756 Engineering 10-420-6759 _ Plat Review $25,000.00 $13,880.00 $14,000.00 $15,000.00 _ 10-420-6759 Plat Review 10-420-6761 Dues, Publications, Permits & License: $250.00 $1,026.60 $1,152.60 $2,500.00 _ 10-420-6761 Dues, Publications, Per. 10-420-6780 Electricity $1,500.00 $1,786.61 $1,500.61 $1,750.00 10-420-6780 Electricity 10-420-6783 Telephones - Pagers $500.00 _ $2,582.41 $2,859.82 $4,000.00 _ 10-420-6783 Telephones - Pagers 10-420-6799 _ Other Services - Misc. $1,250.00 $365.05 $465.05 $1,500.00 10-420-6799 Other Services - Misc. Total Service Expenditures $561,202.00 $471,839.55 $553,728.20 $440,950.00 Total Service Expenditures Capital Expenditures Capital Expenditures 10-420-6910 Motor Vehicles $0.00 $0.00 $0.00 $0.00 10-420-6910 Motor Vehicles 10-420-6911 Machinery& Equipment_ $500.00 $2,092.00 $2,990.00 $10,000.00 10-420-6911 Machinery& Equipment 10-420-6941 _ Other Capital Expenditures $0.00 $0.00 $0.00 $175,000.00 10-420-6941 Other Capital Expend. Total Capital Expenditures $500.00 $2,092.00 $2,990.00 $185,000.00 Total Capital Expenditures Total Development Expenditures $605,659.00 $516,548.13 $604,508.98 $829,321.00 Total Development Expenditures Fire Department Periods 1-112006 AnnualEstimated ire Proposal City Fire Department u ge YearEnd BudgetBudget -2007 -Budget Revenues Fire Revenues 10-543-5499 Miscellaneous Revenue $0.00 $476.84 $0.00 $0.00 10-543-5499 Miscellaneous Revenue 10-543-5530 Interest Revenue $0.00 $120.00 $0.00 $600.00 _ 10-543-5530 Interest Revenue Total Revenues $0.00 $596.84 $0.00 $600.00 Other Source of Funds Revenues Other Source of Funds Revenues 10-543-5850 Other Finance Source -Cap Lease $0.00 $0.00 $0.00 $0.00 10-543-5850 Other Finance Source -Cap L. Total Revenues $0.00 $596.84 $0.00 $600.00 Total Revenues Payroll Expenditures Payroll Expenditures 10-543-6101 Salaries _ $0.00 $0.00 $106,509.00 $0.00 10-543-6102 Overtime $0.00 $0.00 $1,800.00 $0.00 _ 10-543-6114 City's part FICA & SSS $0.00 $0.00 $8,200.00 $0.00 10-543-6121 Health Insurance $0.00 $0.00 $14,282.73 $0.00 10-543-6121 Health Insurance 10-543-6125 Retirement $0.00 $0.00 $5,325.45 $0.00 10-543-6126 Unemployment $0.00 $0.00 $400.00 $0.00 10-543-6126 Unemployment 10-543-6127 Worker's Compensation $0.00 $0.00 $8,123.45 $0.00 10-543-6127 Worker's Compensation 10-543-6129 Miscellanoues Payroll $0.00 $0.00 _ $3,000.00 $0.00 Total Payroll Expenditures $0.00 $0.00 $147,640.63 $0.00 _ Total Payroll Expenditures Supplies Expenditures Supplies Expenditures 10-543-6208 Office Supplies $0.00 $0.00 $6,000.00 $0.00 10-543-6208 Office Supplies 10-543-6209 Other Supplies - Misc. $0.00 $0.00 $0.00 $0.00 10-543-6209 Other Supplies - Misc. 10-543-6210 Clothing Expense $0.00 $0.00 $2,500.00 $0.00 _ 10-543-6212 Postage $0.00 $0.00 $300.00 $0.00 10-543-6216 Vehicle Supplies -Fuel $0.00 $0.00 $5,500.00 $0.00 10-543-6216 Vehicle Supplies -Fuel 10-543-6217 Vehicle Supplies - Other $0.00 $0.00 $0.00 _ $0.00 _10-5-43-6216 10-543-6217 Vehicle Supplies -Other Total Supplies Expenditures $0.00$0.00 $14,300.00 $0.00 Total Supplies Expenditures Maintenance Expenditures___ Maintenance Expenditures _ 10-543-6301 Maint. & Repair - Vehicles $0.00 $0.00 $0.00 $0.00 10-543-6301 Maint. & Repair - Vehicles 10-543-6302 Maint. & Repair - Equipment $0.00 $0.00 $3,500.00 $0.00 10-543-6302 Maint. & Repair - Equipment 10-543-6303 Maint. & Repair - Buildings $0.00 $0.00 $10,000.00 $0.00 10-543-6303 Maint. & Repair - Buildings Total Maintenance Expenditures $0.00 $0.00 $13,500.00 $0.00 Total Maintenance Expenditures _ Services_Expenditure_s Services Expenditures 10-543-6703 Contract Services $0.00 $0.00 $0.00 $0.00 10-543-6703 Contract Services _ _ 10-543-6721 Education &Training_ $0.00 $0.00 $8,000.00 $0.00 10-543-6721 Education & Training _ 10-543-6722 Insurance - Property & Liability_ $4,862.00 $8,130.57 $0.00 $8,500.00 10-543-6722 Insurance - Property & Liability 10-543-6731 Public Notices - Advertising $0.00 $0.00___$0-00 $0.00 10-543-6731 Public Notices - Advertising 10-543-6753 Legal Expense 1 $0.00 $0.00 $0.00 $0.00 10-543-6753 Legal Expense 10-543-6778 Fire Protection and Prevention $139,525.00 $139,525.00 $0.00 $202,072.00 _ Fire Protection and Prevention 10-543-6780 Electricity j $3,500.00 _ $8,815.28 $0.00 $9,500.00 _10-543-6778 10-543-6780 Electricity 10-543-6781 Gas - Natural/Propane $0.00 $0.00 $0.00 $0.00 10-543-6781 Gas - Natural/Propane 10-543-6783 Telephones - Pagers $0.00 $0.00 $1,800.00 $0.00 _ 10-543-6783 Telephones - Pagers 10-543-6789 Debt -Service Principal $0.00 $0.00 $0.00 $0.00 10-543-6789 Debt -Service Principal 10-543-6790 Interest Expense $0.00 $8,731.46 $0.00 $6,750.00 10-543-6790 Interest Expense 10-543-6799 Other Services -Misc. $0.00 $0.00 $14,656.00 $0.00 10-543-6799 Other Services - Misc. _ Total Service Expenditures $147,887.00 $16_5,202.31 $24,456.00 $226,822.00 Total Service Expenditures Capital Expenditures Capital Expenditures Expenditures 10-543-6910 Motor Vehicles _ 10-543-6911 Machinery & Equipment $47,540.00 $40,905.92 $0.00 $0.00 $50,000.00 $41,075.00 $25,000.00 10-543-6910 Motor Vehicles 10-543-6911 Machinery & Equipment _-$0.00 10-543-6941 Other Capital Expenditures $0.00 $0.00 $0.00 $0.00 10-543-6941 Other Capital Expenditures Total Capital Expenditures _ $40,905.921 $50,000.00 $66,075.00 Total Capital Expenditures Total Fire Expenditures _$47,540.00 $195,427.00 $206,108.23 $249,896.63 _ $292,897.00 Total Fire Ex enditures Ambulance Expenditures_ Annual YTD Projected Proposed _ Periods 1-112006 Budget Actual Year End 2007 Budget 10-544-6779 Ambulance Service $38,798.48 $38,798.48 $38,798.48 $40,746.77 Total Ambulance Expenditures $38,798.48 $38,798.48 $38,798.48 $40,746.77 Police Revenues Periods 1 -11 AnnualProjected Proposed Proposed Police Budget 2007_ u get �cfu—aT— ear n u get Police Revenues Police Revenues 10-550-5499 Misc. Revenues $0.00 $1_,574.00 $1,500.00 _ $1,500.00 10-550-5499 Misc. Revenues 10-550-5500 Grant Revenue----- $0.00 $0.00 $0.00 $0.00 10-550-5500 Grant Revenue _ Total Police Revenues $0.00 $1,574.00 $1,500.00 $1,500.00 Total Police Revenues Payroll Expenditures Payroll Expenditures 10-550-6101 Salaries $226,324.00 $193,467.05 $214,301.75 $363,117.00 10-550-6101 Salaries 10-550-6102 Salaries -Overtime $7,875.00 $1,812.58 $6,701.22 $20,000.00 10-550-6102 Salaries - Overtime 10-550-6114 Payroll Taxes -City Part FICA $17,314.00 $14,979.49 $16,537.11 $29,377.00 10-550-6114 Payroll Taxes -City Part FICA 10-550-6121 Health Insurance $28,354.00 $18,197.61 $21,000.00 $36,300.00 10-550-6121 Health Insurance 10-550-6125 TMRS Retirement $8,602.00 $7,840.62 $8,448.33 $20,735.00 10-550-6125 TMRS Retirement _ 10-550-6126 Unemployment $639.00 $3,117.78 $3,700.00 $3,900.00 _ 10-550-6126 Unemployment 10-550-6127 Worker's Compensation $16,941.00 $14,083.92 $16,966.55 $28,100.00 10-550-6127 Worker's Compensation 10-550-6129 Miscellaneous Payroll $2,100.00 $1,672.00 $4,622.00 $900.00 10-550-6129 Miscellaneous Payroll Total Payroll Expenditures $308,149.00 _ $255,171.05 $292,276.96 $502,429.00 Total Payroll Expenditures _ Supplies _ Office Supplies 10-550-6208 Office Supplies $3,500.00 $1,587.89 $4,250.00 10-550-6208 Office Supplies 10-550-6209 Other Supplies - Misc. $5,000.00 $1,848.07 $5,000.00 10-550-6209 Other Supplies - Misc. 10-550-6210 Clothing Supplies $2,500.00 _ $3,089.44 q$3,577.O7 $1,500.00 10-550-6210 Clothing Supplies 10-550 6212 Postage $1,250.00 $695.63 $1,000.00 10-550-6212 Postage _ 10-550-6216Vehicle Supplies -Fuel $9,000.00 $11,543.63 $25,000.00 10-550-6216Vehicle Supplies - Fuel 10-550-6217 Vehicle Supplies - Other $1,500.00 $968.19 $1,950.00 10-550-6217 Vehicle Supplies -Other Total Supplies Expenditures_ $22,750.00 $21,732.85 524,898.03 $38,700.00 Total Supplies Expenditures _ _ Maintenance Expenditures Maintenance Expenditures 10-550-6301 Maint. & Repair - Vehicles $3,500.00 $3,635.55 $3,499.32 $5,500.00 10-550-6301 Maint. & Repair - Vehicles 10-550-6302 Maint. & Repair - Equipment $0.00 $0.00 $0.00 $2,000.00 10-550-6302 Maint. & Repair - Equipment 10-550-6303 Maint. & Repair - Buildings $2,000.00 $368.75 $1,480.75 $2,000.00 10-550-6303 Maint. & Repair - Buildings Total Maintenance Expenditures $5,500.00 $4,004.30 $4,980.07 $9,500.00 Total Maintenance Expenditures_ Services Expenditures Services Expenditures 10-550-6703 Contract Services $0.00 $1,107.00 _ $1,500.00 $0.00 10-550-6703 Contract Services 10-550-6711 Travel Expense $2,500.00 _ $1,057.62 $2,079.27 $3,500.00 10-550-6711 Travel Expense 10-550-6712 Rental Expense $3,800.00 $4,185.95 $2,850.00 $4,000.00 _ 10-550-6712 Rental Expense 10-550-6721 Education & Training $2,000.00 $1,258.83 $1,388.83 $3,000.00 10-550-6721 Education & Training 10-550-6722 Insurance - Property & Liability $3,510.00 $6,057.14 $7,496.42 $8,500.00 10-550-6722 Insurance - Property & Liab. 10-550-6731 Public Notices - Advertising $600.00 $635.92 _ $935.92 $750.00 10-550-6731 Public Notices - Advertising 10-550-6753 Legal Expense $6,000.00 _ $2,870.91 $2,722.77 _ $6,000.00 10-550-6753 Legal Expense 10-550-6780 Electricity $3,000.00 $1,786.61 $2,532.72 $4,500.00 10-550-6780 Electricity 10-550-6783 Telephones - Pagers $3,500.00 $5,557.71 $7,622.48 $9,350.00 10-550-6783 Telephones - Pagers 10-550-6799 Other Services - Misc. $25,000.00 $12,143.57 $24,993.28 $31,677.00 10-550-6799 Other Services - Misc. Total Services Expenditures $49,910.00 _ $36,661.26 $54,121.69 $71,277.00 Total Services Expenditures Capital Expenditures Capital Expenditures _ 10-550-6910 Motor Vehicles _ $44,000.00 $50,980.88 $60,180.88 $25,982.00 10-550-6910 Motor Vehicles 10-550-6911 Machinery & Equipment $25,000.00 $40,551.99 $35,445.70 $16,040.00 10-550-6911 Machinery & Equipment Total Capital Expenditures $69,000.00 $91,532.87 $95,626.58 $42,022.00 Total Capital Expenditures Total Police Expenditures _ $455,309.00 $409,102.33 $471,903.33 $663,928.00 Total Police Expenditures Municipal Court Budget Worksheet 2007 Municipal Court Periods 1-112006 Annual YTD Actual Estimated Proposed Municipal Court Revenues Budget Budget Year nd Budget 2007 Revenues 10-552-5110 Court Fines $180,000.00 $18,658.71 $32,000.00 $60,000.00 10-552-5110 Court Fines 10-552-5111 Mun. Court Tech. Fund $2,920.00 $540.14 $550.00 $1,000.00 10-552-5111 Mun. Court Tech. Fund 10-552-5112 Mun. Court Building Sec. F_.___ $2,190.00 $237.97 $400.00 $800.00 10-552-5112 Mun. Court Build. Sec. F. 10-552-5499 Misc. Revenue $0.00 $0.00 $0.00 $0.00 10-552-5499 Misc. Revenue Total Municipal Court Revenues $185,110.00 $19,436.82 $32,950.00 $61,800.00 Total Municipal Court Revenues Payroll Expenditures Payroll Expenditures 10-552-6101 Salaries $30,139.00 $27,659.07 $32,000.00 $34,460.00 10-552-6101 Salaries 10-552-6102 Salaries - Overtime $500.00 $89.87 $150.00 $500.00 10-552-6102 Salaries - Overtime _ _ 10-552-6114 Payroll Taxes -City Part FICA $2,306.00 $2,117.71 $2,306.00 $2,682.00 10-552-6114 Pay.Tax.-City Part FICA _ 10-552-6121 Health Insurance $4,726.00 $4,092.09 $4,726.00 $5,000.00 10-552-6121 Health Insurance 10-552-6125 TMRS Retirement $1,176.00 $1,204.30 $1,179.00 $1,893.00 10-552-6125 TMRS Retirement 10-552-6126 Unemployment $87.00 $525.23 $625.00 $750.00 10-552-6126 Unemployment 10-552-6127 Worker's Compensation $195.00 $440.97 $556.27 $650.00 10-552-6127 Worker's Compensation 10-552-6129 Miscellaneous_ Payroll $100.00 $150.00 $150.00 $100.00 10-552-6129 Miscellaneous Payroll _ _ Total Payroll Expenditures $39,229.00 $36,279.24 $41,692.27 $46,035.00 Total Payroll Expenditures Supplies Expenditures Supplies Expenditures 10-552-6208 Office Supplies $3,000.00 $1,002.97 $1,500.00 $2,000.00 10-552-6208 Office Supplies 10-552-6209 Other Supplies - Misc. $500.00 $24.25 $250.00 _ $500.00 10-552-6209 Other Supplies - Misc. 10-552-6212 Postage $1,200.00 $726.30 $1,200.00 $1,200.00 10-552-6212 Postage _ _ Total Supplies Expenditures $4,700.00 $1,753.521 $2,950.00 _ Total Supplies Expenditures Maintenance Expenditures _$3,700.00 Maintenance Expenditures 10-552-6302 Maint. & Repair - Equipment $0.00 $0.00 $0.00 $0.00 10-552-6302 Maint. & Repair - Equip. Total Maintenance Expenditures $0.00 $0.00 $0.00 $0.00 Total Maintenance Expenditures Services Expenditures Services Expenditures 10-552-6703 Contract Services $12,500.00 $3,205.72 $5,000.00 _ $10,000.00 10-552-6703 Contract Services 10-552-67_11 Travel Expense $500.00 $785.441 $785.44 $1,500.00 10-552-6711 Travel Expense _ _ 10-552-6712 Rental Expense $0.00 $993.67 $588.98 $750.00 10-552-6712 Rental Expense 10-552-6717 State Court Cost $90,000.00 $0.00 $0.00 $0.00 10-552-6717 State Court Cost 10-552-6721 Education & Training $500.00 $503.84 $503.84 $750.00 10-552-6721 Education & Training 10-552-6753 Legal Expense $1,000.00 $4,691.46 $5,000.00 $8,000.00 10-552-6753 Legal Expense 10-552-6761 Dues, Publications, Permits & Licenses $500.00 $528.07 $528.07 $600.00 10-552-6761 Dues, Pub., Per. & Lic. 10-552-6783 Telephones - Pagers $0.00 $501.94 $459.31 $600.00 10-552-6783 Telephones - Pagers 10-552-6799 Other Services - Misc. $1,000.00 $0.00 $0.00 $1,000.00 10-552-6799 Other Services - Misc. Total Service Expenditures $106,000.00 $11,210.14 $12,865.64 $23,200.00 Total Service Expenditures_ _ Capital Expenditures Capital Expenditures 10-552-6911 Machinery&Equipment $5,000.00 $1,717.00 $1,615.00 _ $3,000.00 10-552-6911 Machinery&Equipment Total Capital Expenditures $5,000.00 $1,717.00 $1,615.001 $3,000.00 Total Capital Expenditures Total Court Expenditures 1 $154,929.001 $50,959.90 $59,122.911 $75,935.00 Total Court Expenditures Park Reveunues Periods 1-112006 Annual YTD I Estimated Proposed Proposed Budget 2007 Revenues Budget Actual Year End 2007 Budget Park Revenues 10-555-5326 Park Fees $0.00 $0.001 $0.00 $0.00 10-555-5326 Park Fees 10-555-5499 Misc. Revenues $0.00 $0.00 $0.00 _ _ $0.00 10-555-5499 Misc. Revenues 10-555-5500 Grant Revenues $0.00 $0.00 $0.00 $0.00 10-555-5500 Grant Revenues 10-555-5530 Interest Revenue $0.00 $0.00 $0.00 _ _ 10-5_55-5530 Interest Revenue _ _ Total Park Revenue $0.00 $0.00 $0.00 _$0.00 $0.000 _ Other Source of Funds Revenue 10-555-5855 Other Source Contributed Capital $0.00 $397,446.02 $397,446.02 + $0.00 Total Park Other Source of Fund Revenues_ $0.00 $397,446.02 $397,446.02 $0.00 Total Park Revenue _ $0.00 _ $397,446.02 $397,446.02 $0.00 Total Park Revenue Park Expenditures Periods 1-7 2006 Supplies Expenditures Current Budget YTD Actual Estimated Year End Amount !Proposed Budget 2007 Supplies Expenditures 10-555-6209 Other Supplies - Misc. ---------------- --- --- -- - - - -- -- Total Park Expenditures $250.00 -- - $250.00 $0.00 $0.00 $250.00 10-555-6209 Other Supplies--.- Misc. - -- - - -------------- $0.00 .00 $250.00 Total Park Expenditures $0 Maintenance Expenditures Maintenance Expenditures 10-555-6302 Maint. & Repair - Equipment $1,500.00 $8,693.68 $6,650.34 $2,000.00 10-555-6302 Maint. &_Repair - Equipment 10-555-6303 Maint. & Repair- Buildings 10-555-6304 Maint. & Repair - Grounds -� $2,500.00 $5,000.00 $1,966.63 $8,170.93 $1,966.63 $8,332.95 $2,500.00 10-555-6303 Maint. & Repair- Buildings $6,000.00 10-555-6304 Maint. & Repair - Ground_ s Total Maintenance Expenditures $9,000.00 $18,831.24 $16,949.92 $10,500.00 Total Maintenance Expenditures Services Expenditures Services Expenditures 10-555-6703 Contract Services $5,000.00 $3,915.00 $7,830.00, $6,000.00 10-555-6703 Contract Services 10-555-6780 Electricity $2,500.00 $4,332.06, 10-555_-6780 Electricity _ 10-555-6799 Other Services - Misc. $1,500.00 __$4,126.50 $0.00 $0.00 _$3,000.00 $1,500.00' 10-555-6799 Other Seryices - Mis_c. Total Services Expenditures $9,000.00 $8,041.50 $12,162.06 $10,500.00 Total Services Expenditures Capital Expenditures 10-555-6911 Machinery & Equipment $12,000.00 $21,693.57 $21,693.57 _ Capital Expenditures $3,500.00 10-555-6911 Machinery & Equipment 10-555-6931 Land & Improvenents $7,500.00 $400,642.04 $6,000.00L__ $0.00 10-555-6931 Land_ & Im_proven_e_nts Total Capital Expenditures $19,500.00 $422,335.61 $27,693.571 $3,500.00 Total Capital Expenditures Total Park Expenditures $37,750.00 $449,208.35 $56,805.55 $24,750.00 Total Park Expenditures Street Revenues Periods 1-11 20_0.6 Annual YTD I Estimated Proposed Street_ Revenues Budget Actual ear nd 2007 Budget Sfir-e-e-tilevenues Budget Budget 10-580-5208 Street Repair Fees $0.00 $185.00 $200.00 $500.00 10-580-5208 Street Repair Fees 10-580-5226 Sales Tax Revenue $43,200.00 $51,553.24 $52,500.00 $8,000.00 10-580-5226 Sales Tax Revenue _ 10-580-5499 Misc. Revenue $0.00 $0.00 $0.00 $0.00 10-580-5499 Misc. Revenue Total Revenues $43,200.00 $51,738.24 $52,700.00 $8,500.00 Total Revenues Other Source of Funds Revenue Other Source of Funds Revenue 10-580-5803 Transfers in Trust Funds $0.00 $0.00 $0.00 $0.00 10-580-5803 Transfers in Trust Funds Total Other Source of Funds Revenue $0.00 $0.00 $0.00 _ $0.00 Total Street Revenues $43,200.00 $51,738.24 $52,700.00 $8,500.00 Total Street Revenues Supplies Expenditures Supplies Expenditures 10-580-6209 Other Supplies - Misc. $2,500.00 $0.00 $2,000.00 $2,500.00 10-580-6209 Other Supplies - Misc. Total Supplies Expenditures $2,500.00 $0.00 $2,000.00 $2,500.00 Total Supplies Expenditures Maintenance Expenditures Maintenance Expenditures 10-580-6_302 Maint. & Repair- Equipment $2,500.00 $1,461.52 $2,000.00 _ $2,500.00 10-580-6302 Maint. & Repair- Equipment _ _ 10-580-6320 Maint. & Repair - Streets $98,000.00 _ $5,925.81 $5,664.96 $6,000.00 10-580-6320 Maint. & Repair - Streets 10-580-6322 Maint. & Repair - Bridges $0.00 $0.00 $0.00 $0.00 10-580-6322 Maint. & Repair - Bridges 10-580-6324 Maint. & Repair- Signs, Fences, & Sidewalks $5,000.00 $3,717.08 $5,000.00 _ $4,000.00 10-580-6324 Maint. & Repair - Signs, Fences, 10-580-6326 Maint. & Repair - Storm Sewer $2,500.00 $401.16 $2,500.00 $2,500.00 10-580-6326 Maint. & Repair - Storm Sewer Total Maintenance Expenditures $108,000.00 $11,505.57 $15,164.96 $15,000.00 Total Maintenance Expenditures Services Expenditures _ Services Expenditures 10-580-6703 Contract Services $2,500.00 $401.00 $401.00 $152,500.00 10-580-6703 Contract Services 10-580-6721 Education & Training $0.00 $0.00 $0.00 $0.00 10-580-6721 Education & Training 10-580-6722 Insurance - Property & Liability $3,000.00 $0.00 $0.00 $3,000.00 10-580-6722 Insurance - Property& Liability _ 10-580-6753 Legal Expense $0.00 $384.75 $500.00 $0.00 10-580-6753 Legal Expense _ _ 10-580-6756 Engineering $5,000.00 $10,998.10 $11,500.00 $10,000.00 10-580-6756 Engineering 10-580-67_80 Electricity $60,000.00 $62,288.21 $64,035.00 $72,000.00 10-580-6.780 Electricity 10-580-6799 Other Services - Misc. $0.00 $0.00 $0.00 $0.00 10-580-6799 Other Services - Misc. Total Services Expenditures $70,500.00 $74,072.06 $76,436.00 $237,500.00 Total Services Expenditures Capital Expenditures Expenditures_ _ Capital Expenditures Expenditures 10-580-6911 Machinery& Equipment $0.00 $0.00 $0.00 $0.00 10-580-6911 Machinery& Equipment 10-580-6933 Capital Improvements - Streets $138,000.00 $156,377.23 $156,377.23 $115,000.00 10-580-6933 Capital Improvements - St. Total Capital Expenditures $138,000.00 $156,377.23 $156,377.23 $115,000.00 Total Capital Expenditures Total Street Expenditures $319,000.00 $241,954.86 $249,978.191 $370,000.00 Total Street Expenditures Debt Service Budget Wooksheet Debt Service Revenue Annual YTD Estimated Proposed Debt Service Revenue _ Budget Periods1-10 YTD 2007 Budget 40-611-5101 Property Tax Rev.- I & S Fund $0.00 $249,290.00 40-611-5101 Property Tax Rev.- I & S Fund 40-611-5102 Property Tax Rev -Delinquent $0.00 $0.00 40-611-51_02 Property Tax Rev -Delinquent 40-611-5400 Discounts Earned $0.00 $0.00 40-611-5400 Discounts Earned 40-611-5499 Misc. Revenue _ $11,561.88 $11,561.88 $0.00 40-611-5499 Misc. Revenue _ 40-611-5530 Insterest Revenue $225.08 $595.00 $1,500.00 40-611-5530 Insterest Revenue _ Total Revenues $11,786.96 $12,156.88 $250,790.00 Total Revenues _ Other Source of Funds Revenues _ Other Source of Funds Revenues 40-611-5800 Transfers In $0.00 $0.00 $0.00 40-611-5800 Transfers In Total Other Source of Funds Rev. $0.00 $0.001 _ $0.00 Total Other Source of Funds Rev. Total Debit Service Revenues $11,786.96 $12,156.88 $250,790.00 Total Debit Service Revenues Debit Service Expenditures Debit Service Expenditures _ 40-611-6790 Interest Expense $0.00 $0.00 _ $198,890.00. 40-611-6790 Interest Expense 40-611-6799 Other Sevices-Misc. $0.00 $0.00 $400.00 40-611-6799 Other S_evi_ces_-_Misc. Total Debit Service Expenses $0.00 $0.00 $199,290.00 Total Debit Service Expenses Other Uses of funds Expenditures Other Uses of funds Expenditures 40-611-8000 Bond Payment $0.00 $0.00 $50,000.00 40-611-8000 Bond Payment 40-611-9811 Trans. Out -Water Fund $0.00 $0.00 $0.00 40-611-9811 Trans. Out -Water Fund_ Total Other Uses of Funds Expend. $0.00 $0.00 $50,000.00 Total Other Uses of Funds Expend. Total Debt Service Expenses & Use of Funds $0.00 $0.00 $249,290.00 Total Debt Service Expenses & Use of Funds CO Project Construction Fund Service Budget Wooksheet 50-625-5499 Misc. Rev. _ 50-625-5500 Grant Revenues 50-625-5530 Interest Rev. _ Total Revenues Other Sources of Rev. 50-625-5106 Intergov. Rev. 50-6_25-580_0 Transfer In _ 50-625-5840 Bond Proceeds Total Other Source of Rev. Total Revenues & Sources of Funds Capital Projects Expenditures 50-625-6911 Mach. & Equip. 50-625-6931 Land & Imp. 50-625-6941 Other Cap. Expend_. Total Expenditures Other Uses of Funds Expend. _ 50-625-9811 Trans. Out -WF Total Uses of Other Funds Total Expenditures $0.00 $0.001 $0.00 $0.00 $0.00 $0.00 $31,576.39 $61,677.16 $77,000.00 $31,576.39 $61,677.16 $77,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,434,600.00 $2,446,574.97 $0.00 $2,434,600.00 $2,446,574.97 $0.00 $0.00 50-625-5106 Intergov. Rev. $0.00 2,466,176.39 $2,508,252.13 $77,000.00 $0.00 Total Capital Projects Rev. YTD $615,000.00 $26,111.39 _ $28,571.79 $108,572.00 $7,529.75 $17,448.25 $19,383.00 $59,022.35 $413,677.04 $428,754.00 $92,663.49 $459,697.08 $556,709.00 $0.00 $0.001 $0.00 $0.00 $0.00 - $0.00 13.49 $459,697.081 $556,709.00 ear $0.001, 50-625-5499 Misc. Rev. $__572,0_00.00 50-625-5500 Grant Revenues $43,000.00 _ 50-625-5530 Interest Rev. $615,000.00 Total Revenues Other Sources of Rev. $0.00 50-625-5106 Intergov. Rev. $0.00 50-625-5800 Transfer In $0.00 50-625-5840 Bond Proceeds $0.00 Total Capital Projects Rev. $615,000.00 $0.00 50-625-6911 Mach. & Equip. $0.001 50-625-6931 Land & Imp. $2,536,286.00i 50-625-6941 Other Cap. Expend. $2,536,286.00 !Total Expenditures Other Uses of Funds Expend. $0.00 50-625-9811 Trans. Out $0.00 Total Uses of Other Funds 16.00 Total Expenditures Water Rev. Periods 1-112006 Annual YTD Estimated Proposd Water Rev. Proposed BudgetActual ear nd 20 7 u get 7 Budget Water Revenues Water Revenues 60-701-5115 Water Sales $1,277,045.00 $1,040,649.08 $1,200,000.00 $1,500,000.00 60-701-5115 Water Sales 60-7_01-5116 W & S Tap Fees $1,500.00 $6,950.00 $2,950.00 $1,500.00 60-701-5116 W & S Tap Fees 60-701-5117 _ Late Payment Penalty $46,328.00 $50,926.61 $49,000.00 $50,000.00 60-701-5117 Late Payment Penalty 60-701-5118 Connection & Re_con_nection_Fee $26,903.00 $32,380.00 $30,000.00 $30,000.00 60-701-5118 Connect & Recon. Fee 60-701-5119 NSF Fees $1,350.00 $1,475.00 $1,500.00 $1,350.00 60-701-5119 NSF Fees 60-701-5122 Meter Install Fee $50,000.00 $87,750.00 $70,000.00 $60,000.00 60-701-5122 Meter Install Fee 60-701-5400 Discounts Earned $0.00 $0.00 $0.00 $0.00 60-701-5400 Discounts Earned 60-701-5491 Gain on sales of Assets $0.00 $6,770.79 to—Woo $0.00 60-701-5491 Gain on sales of Assets 60-701-5499 Miscellaneous Revenue $916.00 $5,001.00 $4,400.00 $1,000.00 60-701-5499 Miscellaneous Revenue 60-701-5500 Grant Revenue $0.00 $0.00 $0.00 $0.00 60-701-5500 Grant Revenue 60-701-5530 Interest Revenue $1,000.00 $23,428.25 $22,500.00 $23,000.00 60-701-5530 Interest Revenue 60-701-5711 Returned Ch. Re -Dep. _J $3,500.00 $6,602.44 $4,000.00 $4,000.00 60-701-5711 Returned Cks- Re -Dep. Total Water Revenue $1,408,542.00 $1,261,933.17 $1,384,350.00 $1,670,850.00 Total Water Revenue Other Source of Funds Revenues_ Other Source of Funds Revenues 60-701-5802 Transfers ral Fund in - Gene $0.00 $0.00 $0.00 $0.00 60-701-5802 Transfers in - G F 60-701-5803 Transfers in - Trust Funds $125,000.00 $0.00 $0.00 $0_.00______60-701-5803 Transfers in - Trust F. 60-701-5900 _ Cash Overage/Shortage $0.00 _ $24.76 —$30.00--$0.00— 60-701-5900 Cash Overage_/Shortage Total Other Source of Revenue $125,000.00 $24.76 $30.00 $0.00 _ Total Other Source of Revenue Total Water Revenues t $1,533,542.00 $1,261,957.93. $1,384,380.00 $1,670,850.00 Total Water Revenues Payroll Expenditures Payroll Expenditures 60-701-6101 Salaries $353,888.00 $298,654.24 $350,000.00 $399,310.00 _ 60-701-6101 Salaries 60-701-6102 Salaries - Overtime $18,391.00 $16,065.81 $18,000.00 $20,000.00 60-701-6102 Salaries - Overtime 60-701-6114 Payroll Taxes -City Part FICA $28,479.00 $24,096.39 $28,479.00 $32,177.00 60-701-6114 Payroll Taxes -City Part FICA 60-701-6121 Health Insurance $51,983.00 $41,720.23 $52,608.00 $71,425.00 60-701-6121 Health Insurance 60-701-6125 TMRS Retirement $14,297.00 $12,315.37 $13,389.43 $22,707.00 60-701-6125 TMRS Retirement 60-701-6126 Unemployment $945.00 $5,839.30 $6,400.00 $6,400.00 60-701-6126 Unemployment 60-701-6127 Worker's Compensation $20,750.00 $21,134.21 $25,170.00 $25,170.00 60-701-6127 Worker's Compensation 60-701-6129 _ Miscellaneous Payroll $1,100.00 $1,100.00 $1,100.00 $1,300.00 60-701-6129 Miscellaneous Payroll Total Payroll Expense $489,833.00 $420,925.55 $495,146.43 $578,489.00 Total Payroll Expenditures Supplies Expenditures Supplies Expenditures 60-701-6208 Office Supplies $15,000.00 $6,355.56 $10,000.00 _ $15,000.00 _ 60-701-6208 Office Supplies 60-701-6209 Other Supplies -Misc. $2,500.00 $1,145.90 $2,000.00 $2,500.00 _ 60-701-6209 Other Supplies -Misc. 60-701-6210 Clothing Supplies $9,500.00 $6,975.01 $9,500.00 $11,000.00 _ 60-701-6210 Clothing Supplies 60-701-6211 Chemicals $6,000.00 $7,104.05 $6,000.00 $7,500.00 60-701-6211 Chemicals 60-701-6212 Postage $7,200.00 $7,212.45 $7,000.00 $8,500.00 60-701-6212 Postage 60-701-6216 Vehicle Supplies - Fuel $12,000.00 $13,182.11 $12,000.00 $15,000.00 60-701-6216 Vehicle Supplies - Fuel 60-701-6217 Vehicle Supplies - Other $1,800.00 $759.44 $1,500.00 $1,800.00 60-701-6217 Vehicle Supplies - Other Total Supplies Expenditures $54,000.00 $42,734.52 $48,000.00 $61,300.00 Total Supplies Expenditures Water Expenditures Budget Actual Year End Year End Water Department Expend. Maintenance Expenditures Budget Budget Budget Maintenance Expenditures 60-701-6301 Maint. & Repair - Vehicles $3,000.00 $1,713.72 $3,000.00 $3,000.00 60-701-6301 Maint. & Repair - Vehicles 60-701-6302 Maint. & Repair - Equipment $6,000.00 $6,505.78 $5,500.00 $6,000.00 60-701-6302 Maint. & Repair - Equip. 60-701-6303 Maint. & Repair - Buildings $5,000.00 $1,598.98 $1,500.00 $3,000.00 60-701-6303 Maint. & Re. - Buildings 60-701-6305 Maint. & Repair - Other $1,500.00 $236.00 $500.00 $1,500.00 60-701-6305 Maint. & Repair - Other 60-701-6330 Maint. & Repair - Water Lines $25,000.00 $30,856.40 $28,500.00 $30,000.00 60-701-6330 Maint. & Rep.Water Lines 60-701-6332 Maint. & Repair - Storage Tanks $1,500.00 $0.00 $0.00 $2,000.00 60-701-6332 Maint. & Rep.Stor. Tanks 60-701-6334 Maint. & Repair - Pumps, Wells, & $36,000.00 $42,833.57 $45,000.00 $48,000.00 60-701-6334 Maint. & Rep. Pumps 60-701-6336 Maint. & Repair - Water Meters $20,000.00 $18,786.17 $18,000.00 $25,000.00 60-701-6336 Maint. & Rep. W. Meters Total Maintence Expenditures $98,000.00 $102,530.62 $102,000.00 $118,500.00 Total Maintence Expenditures Services Expenditures Services Expenditures 60-701-6703 Contract Services $25,000.00 $21,997.84 $25,000.001 $32,000.00 60-701-6703 Contract Services 60-701-6711 Travel Expense $1,000.00 $751.16 $800.001 $1,000.00 60-701-6711 Travel Expense 60-701-6712 _ _ Rental Expense $2,500.00 $2,338.35 $1,600.00 $2,500.00 _ 60-701-6712 Rental Expense 60-701-6721 Education & Training $1,500.00 $881.88 $1,500.00 $2,500.00 60-701-6721 Education & Training 60-701-6722 Insurance - Property & Liability $15,000.00 $10,088.06 $20,374.00 $49,375.00 60-701-6722 Ins. Property &_Liability 60-701-6731 Public Notices - Adver. $3,000.00 $2,387.73 $3,000.00 $3,500.00 60-701-6731 Public Notices - Adver. 60-701-6753 Legal Expense $140,000.00 $22,092.67 $22,000.00 $140,000.00 60-701-6753 Legal Expense 60-701-6754 Accounting Exp. $400.00 $0.00 $0.00 $400.00 60-701-6754 Accounting Expenses 60-701-6755 _ _ Audit Expense $4,250.00 $4,750.00 $5,000.00 $5,000.00 60-701-6755 Audit Expense 60-701-6756 Engineering $20,000.00 $10,225.50 $13,500.00 $20,000.00 60-701-6756 Engineering 60-701-6761 Dues, Pub. Per. & LIC. $10,000.00 $1,890.79 $8,000.00 $10,000.00 60-701-6761 Dues, Publ. Per. & Lic. 60-701-6770 Penalties $0.00 _ $93.75 $93.75 $0.00 60-701-6770 Penalties 60-701-6780 Electricity $188,000.00 $228,780.01 _ $200,000.00 $250,000.00 60-701-6780 Electricity W--701-6M-1-Gas - Nat.& Prop. $300.00 $0.00 $0.00 $300.00 60-701-6781 Gas - Natural/Propane 60-701-6783 60-701-6785 Telephones - Pagers__ Bad Debt Expense -- $7,500.00 $0.00 $8,847.70 $89.00 $9,000.00 $89.00 $10,000.00 $100.00 60-701-6783 Telephones - Pagers 60-701-6785 Bad Debt Expense 60-701-6786 Returned Ck Exp. $4,500.00 $6,596.83 $9,300.00 $12,000.00 60-701-6786 Returned Check Expense 60-701-6790 Interest Expense $18,055.00 $20,736.88 $27,068.87 $27,200.00 60-701-6790 Interest Expense 60-701-6795 Bond Fees $1,500.00 $0.00 $0.00 $0.00 _ 60-701-6795 Bond Fees 60-701-6799 Other Ser. Misc. $0.00 ($5,846.48) $0.00 $5,000.00 60-701-6799 Other Services - Misc. Total Service Expenditures $442,505.00 $336,701.67 $346,325.62 $570,875.00 Total Service Expenditures Capital Expenditures Capital Expenditures 60-701-6801 Depreciation $200,000.00 $242,000.00 $273,000.00 $350,000.00 60-701-6801 Depreciation 60-701-6910 _ Motor Vehicles $0.00 $0.00 $0.00 $0.00 60-701-6910 Motor Vehicles 60-701-6911 Machinery & Equipment $3,000.00 $1,717.00 $3,000.00 $6,000.00 60-701-6911 Machinery & Equipment 60-701-6940 Grant Reimbursement $0.00 $0.00 $0.00 $0.00 60-701-6940 Grant Reimbursement 60-701-6941 Other Capital Expenditures $95,000.00 $600.00 $95,000.00 $595,006.00 60-701-6941 Other Capital Exp. Total Capital Expenditures $298,000.00 $244,317.00 $371,000.00 $951,006.00 Total Capital Expenditures Other Uses of Funds Expenditures Other Uses of Funds Expenditures 60-701-9812 Transfers Out - G F $0.00 $0.00 $0.00 $0.00 60-701-9812 Transfers Out - GF 60-701-9813 Transfers Out - T F $0.00 $0.00 $0.00 $0.00 60-701-9813_ Transfers Out - Trust F. _ Total Uses of Funds Expenditures $0.00 $0.00 $0.00 $0.00 Total Water Expenditures $1,382,338.00 $1,147,209.36 $1,362,472.05 $2,280,170.00 Total Water Expenditures Sewer Department Worksheet Sewer Rev. Periods 1-112006 Annual YTD Estimated Proposed Proposed 20_0.7 Sewer Budget _ Budget Actual Year End 20_07 Budget _ Sewer Revenues _ - Budget g_ Sewer Revenues Revenues Revenues _ _ Revenues - —_ 60-705-5116 W & S Tap Fees $0.00 $2,000.00 $2,000.00 $2,000.00 60-705-5116 W & S Tap Fees _ 60-705-5120 Reimburse S. Line_ $0.00 _ $0.00 $0.00 $0.00 60-705-5120 Reimburse Sewer Line _ 60-705-5201 Sewer Revenue $550,000.00 $660,371.31 $725,000.00 $870,000.00 60-705-5201 Sewer Revenue 60-705-5324 S.Line Cam. Insp. Fee $0.00 $11,650.00 $8,500.00 $17,500.00 60-705-5324 S. Line Cam. linspec. Fee 60-705-5499 Miscellaneous Rev. $0.00 $0.00 $1,000.00 60-705-5499 Miscellaneous Revenue 60-705-5500 Grant Revenue _$1,500.00 $0.00 $0.00i $0.00 $0.00 60-705-5500 Grant Revenue _ 60-705-5530 Interest Revenue $2,000.00 _ $4,641.891 $5,000.00 $5,000.00 60-705-5530 Interest Revenue 60-705-5601 Sanitation Revenue $200,000.00 $283,828.521 $250,000.00 $350,00_0.00 _ 60-705-5601 Sanitation Revenue Total Revenues_ $753,500.00 $962,491.72 $990,500.00 $1,245,500.00 Total Revenues Other Source of Funds Revenues _ I Other Source of Funds Revenues_ 60-705-5803 Transfers_ in - Trust F. $120,000.00 $0.001 $0.00 _ $0.00 60-705-5803 Transfers in - Trust Funds Total Other Source of Funds Rev. _ _ $120,000.00 $0.00 $0.00 $0.00 Total Other Source of Funds Revenues Total Sewer Revenues $873,500.00 $962,491.72 $990,500.00 $1,245,500.00 Total Sewer Revenues Payroll Expenditures Payroll Expenditures 60-705-6127 Worker's- Comp.- $0.001 $4,207.54 $6,513.64 $6,700.00 60-705-6127 Worker's Compensation Total Payroll Expenditures $0.00 $4,207.54 $6,513.64 1 $6,700.00 Total Payroll Expenditures Supply Expense Supply Expense _ _ 60-705-6209 Other Supplies - Misc. $1,000.00 $2,306.76 $3,000.00 $2,500.00 60-70_5-6_209 Other Supplies - Misc. 60-705-6211 Chemicals _ $5,000.00 _ $5,990.80 $4,000.00 $5,000.00 _ 60-705-6211 Chemicals Total Supplies Expenditures $6,000.00 $8,297.56 $7,000.00 $7,500.00 Total Supplies Expenditures Maintenance Expenditures Maintenance Expenditures 60-705-6302 Maint. & Repair _-_Equip. $2,500.00 $2,000.00 $2,500.00 60-705-6302 Maint. & Repair- Equip. 60-705-6303 Maint. & Repair- Build. $1,000.00 __$_1,790.77 $787.80 $1,000.00 $1,000.00 60-705-6303 Maint. & Repair- Buildings 60-705-6305 Maint. & Repair - Other $0.00 $0.00 $0.00 $0.00 60-705-6305 Maint. & Repair- Other 60-705-6340 Maint. &_Repair - S L 60-705-6342 Maint. & Repair - Lift St. _ $25,000.00 $12,500.00 $7,551.25 $15,995.95 $5,000.00 $12,500.00 $25,000.00 $12,500.00 60-705-6340 _Maint. & Repair - S. Lines 60-705-6342 Maint. & Repair - Lift Stat. 60-705-6344 Maint. & Repair -_S.P._ $25,000.00 $34,684.49 $30,000.00 $30,000.00 60-705-6344 Maint. & Repair - S. Plant Total Maintenance Expenditures $66,000.00 $60,810.26 $50,500.00 $71,000.00 Total Maintenance Expenditures Sewer Department Worksheet Sewer Exp. Periods 1-11 2006 Annual YTD Estimated Proposed Proposed 2007 Sewer Budget Budget Actual Year End 2007 Budget _ Services Expenditures Budget Budget Services Expenditures 60-705-6703 Contract Services $25,000.00 $23,063.99 $20,000.00 $25,000.00 60-705-6703 Contract Services 60-705-6704 Sanitation Contract $150,000.00 $217,884.41 $238,124.99 $277,800.00 _ 60-705-6704 Sanitation Contract 60-705-6712 Rental Expense $500.00 $107.10 $500.00 $500.00 60-705-6712 Rental Expense 60-705-6721 Education & Training $1,400.00 $436.04 $1,000.00 _ $2,000.00 60-705-6721 Education & Training 60-705-6722 Ins - Prop. & Liab. $2,000.00 $0.00 $0.00 $2,000.00 60-705-6722 Ins. - Property & Liability 60-705-6725 Sanitation Sales Tax $0.00 _ $0.00 $0.00 $0.00 60-705-6725 Sanitation Sales Tax 60-705-6731 Pub. Notices - Ad. $500.00 $130.60 $100.00 _ $500.00 60-705-6731 Public Notices - Advertising 60-705-6753 Legal Expense $0.00 $0.00 $0.00 $0.00 60-705-6753 Legal Expense _ 60-705-6756 Engineering $10,000.00 $13,980.94 $14,000.00 $15,000.00 60-705-6756 Engineering 60-705-6761 Dues, Pub., Per. & Lic. $7,500.00 $8,534.50 $8,000.00 $9,000.00 60-705-6761 Dues, Publ., Per. & Licenses 60-705-6780 Electricity $70,000.00 $86,952.87 $86,600.00 $100,000.00 60-705-6780 Electricity 60-705-6783 Telephones - Pagers _ $1,800.00 $2,843.42 $3,000.00 $4,000.00 60-705-6783 Telephones - Pagers 60-705-6790 Interest Expense___ $671,483.00 $23,390.73 $27,070.00 $28,000.00 60-705-6790 Interest Expense _ 60-705-6795 Bond Fees $0.00 $0.00 $0.00 $0.00 _ 60-705-6795 Bond Fees 60-705-6799 Other Services - Misc. $1,500.00 $935.00 $500.00 $1,500.00 60-705-6799 Other Services - Misc. Total Services Expenditures $941,683.00 $378,259.60 $398,894.99 $465,300.00 Total Services Expenditures Capital Expenditures Expenditures Capital Expenditures Expenditures 60-705-6911 Machinery& Equip. $7,000.00 $9,364.24 $9,364.24 $60,000.00 60-705-6911 Machinery& Equipment 60-705-6941 Other Capital Expend. $2,500.001 $1,600.00 $52,000.00 $17,500.00 60-705-6941 Other Capital Expenditures Total Capital Expenditures $9,500.001 $10,964.24 $61,364.24 $77,500.00 Total Capital Expenditures ITotal Sewer Expenditures ota ewer Expenditures