Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2007 Annual Budget
G �TY OF OAK PARK HEIG/17-S, 2007 BUDGET CITY OF OAK PARK HEIGHTS 2007 FINAL BUDGET TABLE OF CONTENTS I. OAK PARK HEIGHTS CITY OFFICIALS 1 II. MEMO FROM FINANCE DIRECTOR 2 III. ORGANIZATIONAL CHART 4 IV. TOP 10 MAJOR CONTRACTS & TOP 8 MAJOR CONSULTANTS 5 V. GENERAL FUND 6 GENERAL FUND REVENUE SUMMARY 7 GENERAL FUND EXPENDITURE SUMMARY 11 MAYOR & COUNCIL 12 CITY ADMINISTRATION 13 LEGAL 14 GENERAL MANAGEMENT & BUILDING 15 ELECTIONS 17 FINANCE 18 COMPUTER 19 AUDIT 20 INSURANCE 21 ASSESSING 22 PLANNING & ZONING 23 ENGINEERING 24 BUILDING INSPECTIONS 25 POLICE 26 FIRE DEPARTMENT 27 CIVIL DEFENSE 28 ANIMAL CONTROL 29 PUBLIC WORKS - STREET MAINTENANCE 30 PUBLIC WORKS - SNOW REMOVAL 31 PUBLIC WORKS - STREET IGHTING 32 2007 FINAL BUDGET TREE REMOVAL & PLANTING 33 SANITATION & SOLID WASTE 34 PARKS 35 COUNCIL CONTINGENCY 37 MISCELLANEOUS EXPENSE 38 TRANSFERS OUT TO OTHER FUNDS 39 VII. WATER UTILITY FUND 40 WATER UTILITY FUND REVENUES 41 WATER UTILITY FUND EXPENDITURES 42 VIII. SEWER UTILITY FUND 44 SEWER UTILITY FUND REVENUES 45 SEWER UTILITY FUND EXPENDITURES 46 IX. STORM SEWER UTILITY FUND 48 STORM SEWER UTILITY FUND REVENUES 49 STORM SEWER UTILITY FUND EXPENDITURES 50 X. SANITATION FUND 52 SANITATION FUND REVENUES 53 SANITATION FUND EXPENDITURES 54 XI. DEBT SERVICE FUNDS - SCHEDULE OF INDEBTEDNESS 55 XII. PARK AND RECREATION DEVELOPMENT FUND 56 XIII. BUDGETED PROJECTS AND EQUIPMENT REVOLVING FUND - SCHEDULE OF ACTIVITY 57 2007 FINAL BUDGET OAK PARK HEIGHTS CITY OFFICIALS POSITION TERM EXPIRES MAYOR DAVID BEAUDET 12/31/2008 COUNCILMEMBER LES ABRAHAMSON 12/31/2010 COUNCILMEMBER MARK SWENSON 12/31/2010 COUNCILMEMBER JACK DOERR 12/31/2008 COUNCILMEMBER MARY MCCOMBER 12/31/2008 CITY STAFF Eric A. Johnson - City Administrator Judy Holst - Finance Director Lindy Swanson - Police Chief Tom Ozzello - Public Works Director David Mol - City Auditor Mark Vierling - City Attorney Dennis Postler - City Engineer 2007 FINAL BUDGET Page 1 Oa , / Memo To: Mayor and Council From: Judy L. Holst, Deputy Clerk/Finance Director Date: 8/11/06 Re: Preliminary Budget Transmittal Memo With this document I am transmitting the proposed 2007 Budget. This budget document culminates one and a half months of work by finance and the various City departments. I would like to thank all those involved with compiling this document. This document contains the requests from the various departments. Several of the requests are capital projects and are incorporated into the Capital Improvements Program document. As you know, the Legislature did not impose Levy Limits for 2007. This will enable the City to budget the costs for necessary services and transfer funds to the Budgeted Projects Fund and the Street Reconstruction Fund for capital purchases. The Legislature reinstated the Market Value Homestead Credit for 2007. Cities are instructed not to deduct the amount of Market Value Homestead Credit from their total amount of their levy. The Legislature adopted a new LGA formula in 2003 which increases the volatility of LGA. The formula "grandfather ", which was formerly set at each city's 1993 LGA distribution, was eliminated and 2 of the more stable formula factors (population and commercial /industrial market value percentage) for calculating aid for cities over 2500 were replaced with 2 that are subject to more year -to -year change (the 3 year average of auto accidents per capita and taconite aid phase -in Page 2 For the purpose of the Truth in Taxation hearing, the State is using the IPD (implicit price deflator) determined by the Bureau of Economic Analysis of the U.S. Department of Commerce for the 12 -month period ending March 31 for government consumption expenditures and gross investment for state and local governments. For levy year 2006, taxes payable 2007, this percentage increase in the IPD is 6.4187 %. This means if our levy is less than 6.4187% we are not required to hold a Truth in Taxation hearing, although, we may still choose to hold this hearing. In any case we are still required to certify hearing dates to the County. I am assuming the County will have the fiscal disparity information available by the end of August, estimated tax values sometime in September, and the final tax values mid to late September. The total proposed General Fund Budget for revenues has an increase of 11.79% over the 2006 budget. The major areas of increase, over and above the Tax Levy are Business Licenses - Permits, Non - business Licenses - Permits, and Miscellaneous Revenue. The increases are primarily due to a proposed increase in liquor and tobacco license fees, building permits for new development, reimbursements for the juvenile officer, reimbursement for police overtime, reimbursement for elections and interest on investments. The decreases in revenues were mainly due to a decrease in the Safe and Sober Grant, less anticipated revenue for CUP, PUD, etc. applications, and less anticipated revenue from miscellaneous fines and forfeits. The total proposed General Fund Budget for expenditures has an increase of 8.86% over the 2006 budget. The major areas of increase are Mayor & Council, General Management & Building, Finance, Insurance Snow Removal, Street Lighting, Tree Removal, and Transfers Out. The increases are primarily due to rising costs for utilities and fuel, rising costs of tree removal, the shift of salary allocation for the utility billing/accounting position, and requested transfers to the Budgeted Projects Fund for capital purchases. Department Heads will be at the workshops to explain their increased budgets. The proposed budget provides for reserving funds for future programs such as sealcoating and mill and overlay, trails, parks, storage area, police radio equipment, vehicles, municipal building, park equipment, and computers. The intent is to save for these programs over several years to prevent a large expenditure in any one year. Council will determine which programs are viable and the amount to reserve. Please keep in mind the City must adopt a proposed budget by resolution and certify the proposed tax levy to Washington County by September 15. If you have any further comments or questions, please let me know. Page 3 ORGANIZATIONAL CHART CITY COUNCIL PLANNING COMMISSION PARKS COMMISSION CITY ADMINISTRATOR LEGAL Administrative Secretary Planning & Code Enforcement Officer Building Official Engineer Planner POLICE FINANCE PUBLIC WORKS Police Chief Finance Director Public Works Director Police Dispatcher Sr. Accountant Public Works Foreman Sergeant (2) Utility Billing/Accountant Public Works Operator (2) Officers (6) Arborist 21 Employees 2007 FINAL BUDGET Page 4 Too Maior Contracts Tot) 8 Maior Consultants 1. Solid Waste Disposal & Recycling 1. Legal 2. Snow Plowing and Sanding 2. Engineering 3. Street Sweeping 3. Planning 4. Street Repair/ Seal Coating/ Crack Sealing 4. Auditor 5. Mowing Public Properties 5. Assessing 6. Fleet Maintenance 6. Arborist 7. Waste Treatment 7. MIS /Computer 8. Janitorial/ Cleaning 8. Financial /Bond Consultants 9. Fire Protection Services 10. Public Safety Dispatch 2007 FINAL BUDGET Page 5 GENERALFUND The General Fund is used to account for revenues and expenditures necessary to carry out the basic functions of the City government. Basic functions include administration, finance, police, public works, fire protection, among smaller operations. Appropriations are made from this fund on an annual basis. TOTAL GENERAL FUND REVENUES $3,363,334 TOTAL GENERAL FUND EXPENDITURES $3,283,930 GENERAL FUND SURPLUS (DEFICIT) $79,404 2007 FINAL BUDGET Page 6 GENERAL FUND REVENUE SUMMARY FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED TAXES $1,910,848 $2,218,209 $2,406,808 $0 $2,809,655 $2,809,655 SPECIAL ASSESSMENTS $5 $4 $0 $0 $0 $0 BUSINESS LICENSES - PERMITS $31,385 $31,708 $30,340 $2,115 $32,005 $32,005 NONBUSINESS LICENSES - PERMITS $273,210 $333,804 $142,000 $100,182 $155,600 $155,600 FINES & FORFEITS $78,269 $69,850 $62,000 $34,591 $60,500 $60,500 INTERGOVERNMENTAL REVENUES $70,362 $101,519 $96,898 $960 $91,984 $91,984 CHARGES FOR SERVICES $150,126 $215,969 $74,465 $36,217 $68,200 $68,200 MISC. REVENUES $129,804 $144,903 $115,270 $34,355 $145,390 $145,390 TOTAL GENERAL FUND REVENUE SUMMARY $2,644,009 $3,115,966 $2,927,781 $208,420 $3,363,334 $3,363,334 2007 FINAL BUDGET Page 7 GENERAL FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED TAXES 101 - 31010 -000 GEN. PROP. TAXES- CURRENT & DELINQUENT $1,981,691 $2,282,034 $2,474,455 $0 $2,789,655 $2,789,655 LESS MARKET VALUE HOMESTEAD CREDIT CUT ($88,487) ($85,647) ($85,647) $0 $0 $0 NET GEN. PROP. TAXES - CURRENT & DELINQUENT $1,893,204 $2,196,387 $2,388,808 $0 $2,789,655 $2,789,655 101 - 31020 -000 GEN. PROP TAXES- PENALTIES & INTEREST $435 $2,061 $0 $0 $0 $0 101 - 31050 -000 PAYMENT IN LIEU OF TAXES $17,209 $19,761 $18,000 $0 $20,000 $20,000 TOTAL TAXES $1,910,848 $2,218,209 $2,406,808 $0 $2,809,655 $2,809,655 SPECIAL ASSESSMENTS 101 - 32020 -000 SPECIAL ASSESSMENTS- CURRENT $0 $0 $0 $0 $0 $0 101 - 32030 -000 SPECIAL ASSESSMENTS- DELINQUENT $0 $0 $0 $0 $0 $0 101 - 32040 -000 SPECIAL ASSESSMENTS - PENALTIES & INT. $5 $4 $0 $0 $0 $0 TOTAL SPECIAL ASSESSMENTS $5 $4 $0 $0 $0 $0 BUSINESS LICENSES & PERMITS 101 - 33010 -000 GENERAL CONTRACTORS LICENSES $3,370 $3,175 $2,500 $1,160 $2,300 $2,300 101 - 33020 -000 REFUSE LICENSES $1,200 $1,200 $1,050 $150 $1,200 $1,200 101 - 33040 -000 TOBACCO LICENSES $1,192 $1,654 $1,650 $0 $1,760 $1,760 101 - 33050 -000 LIQUOR LICENSES $21,117 $22,952 $22,890 $0 $24,150 $24,150 101 - 33060 -000 NON -INTOX. MALT LIQUOR LICENSES $806 $802 $800 $0 $860 $860 101- 33070 -000 AMUSEMENT LICENSES $405 $330 $405 $0 $330 $330 101- 33080 -000 HOME OCCUPATION LICENSES $60 $45 $60 $25 $45 $45 101 - 33085 -000 RIGHT OF WAY PERMITS $0 $0 $0 $0 $300 $300 101 - 33095 -000 FIREWORKS SALES LICENSES $550 $550 $550 $450 $550 $550 101 - 33100 -000 OTHER LICENSES $460 $400 $335 $230 $410 $410 101 - 33105 -000 LAWN FERTILIZER LICNESE $200 $100 $100 $100 $100 $100 101 - 33110 -000 INVESTIGATION FEES $2,025 $500 $0 $0 $0 $0 TOTAL BUSINESS LICENSES & PERMITS $31,385 $31,708 $30,340 $2,115 $32,005 $32,005 2007 FINAL BUDGET Page 8 GENERAL FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED NONBUSINESS LICENSES & PERMITS 101 - 34010 -000 BUILDING PERMITS $243,047 $317,705 $136,000 $90,010 $147,600 $147,600 101 - 34015 -000 FIRE PROTECTION PERMITS $24,325 $6,962 $4,000 $3,122 $4,000 $4,000 101 - 34020 -000 PLUMBING PERMITS $5,838 $9,137 $2,000 $7,050 $4,000 $4,000 TOTAL NONBUSINESS LICENSES & PERMITS $273,210 $333,804 $142,000 $100,182 $155,600 $155,600 FINES & FORFEITS 101 - 35010 -000 COURT FINES $77,769 $67,771 $60,000 $34,052 $60,000 $60,000 101 - 35030 -000 DOG FINES $0 $0 $0 $39 $0 $0 101 - 35040 -000 OTHER FINES & FORFEITS $500 $2,079 $2,000 $500 $500 $500 TOTAL FINES & FORFEITS $78,269 $69,850 $62,000 $34,591 $60,500 $60,500 INTERGOVERNMENTAL REVENUE 101 - 36030 -000 LOCAL GOVERNMENT AID $0 $0 $27,798 $0 $27,984 $27,984 101 - 36070 -000 POLICE AID $58,419 $61,097 $58,100 $0 $61,000 $61,000 101 - 36090 -000 OTHER STATE REVENUE $3,060 $2,040 $2,040 $0 $2,040 $2,040 101 - 36100 -000 OTHER LOCAL GOVERNMENTS $0 $646 $0 $0 $0 $0 101 - 36115 -000 COMPLIANCE GRANTS $0 $0 $960 $960 $960 $960 101 - 36140 -000 STATE GRANT $8,402 $37,736 $8,000 $0 $0 $0 101 - 36150 -000 MET COUNCIL PLANNING GRANT $481 $0 $0 $0 $0 $0 TOTAL INTERGOVERNMENTAL REVENUE $70,362 $101,519 $96,898 $960 $91,984 $91,984 CHARGES FOR SERVICES 101 - 37010 -000 GENERAL GOVERNMENT $8,929 $19,251 $10,000 $3,984 $5,000 $5,000 101 - 37050 -000 OTHER SERVICES $50,337 $84,719 $0 $0 $0 $0 101 - 37060 -000 CHARGES TO OTHER FUNDS $90,860 $94,140 $64,465 $32,233 $63,200 $63,200 101 - 37065 -000 TIF ADMINISTRATION FEES $0 $6,000 $0 $0 $0 $0 101- 37080 -000 DEVELOPMENT CHARGE $0 $6,000 $0 $0 $0 $0 101 - 37090 -000 CONSTRUCTION /ENGINEERING FEE $0 $5,859 $0 $0 $0 $0 TOTAL CHARGES FOR SERVICES $150,126 $215,969 $74,465 $36,217 $68,200 $68,200 2007 FINAL BUDGET Page 9 GENERAL FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED MISC. REVENUE 101 - 38010 -000 INTEREST ON INVESTMENTS $38,834 $54,031 $46,920 $32,467 $65,000 $65,000 101 - 38030 -000 SALE OF MUNICIPAL PROPERTY $1,508 $1,167 $0 $0 $0 $0 101 - 38040 -000 INSURANCE REFUNDS & REIMBURSEMENTS $380 $0 $0 $370 $0 $0 101 - 38050 -000 OTHER REFUNDS & REIMBURSEMENTS $74,243 $66,469 $62,000 $1,518 $74,390 $74,390 101 - 38060 -000 DONATIONS & CONTRIBUTIONS $250 $3,000 $0 $0 $0 $0 101 - 38090 -000 INTEREST ON INSURANCE DEPOSITS $354 $1,400 $350 $0 $0 $0 101 - 39030 -000 LMCIT DIVIDEND $14,235 $18,836 $6,000 $0 $6,000 $6,000 TOTAL MISC. REVENUE $129,804 $144,903 $115,270 $34,355 $145,390 $145,390 TOTAL GENERAL FUND REVENUES $2,644,009 $3,115,966 $2,927,781 $208,420 $3,363,334 $3,363,334 2007 FINAL BUDGET Page 10 SUMMARY OF PAST GENERAL FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED MAYOR & COUNCIL $54,371 $51,990 $67,865 $32,857 $75,160 $75,160 CITY ADMINISTRATION $172,868 $191,981 $202,945 $95,381 $212,360 $212,360 LEGAL $17,823 $17,447 $30,000 $7,164 $30,000 $30,000 GENERAL MANAGEMENT & BUILDING $77,813 $64,660 $74,300 $29,310 $84,400 $84,400 ELECTIONS $5,006 $3,284 $6,800 $340 $3,390 $3,390 FINANCE $157,083 $164,266 $173,325 $83,602 $220,265 $220,265 COMPUTER $9,380 $17,322 $22,000 $1,297 $22,470 $22,470 AUDIT $16,498 $10,743 $15,900 $15,838 $16,500 $16,500 INSURANCE $235,559 $271,819 $300,935 $142,086 $324,795 $324,795 ASSESSING $18,126 $18,126 $19,100 $0 $19,035 $19,035 PLANNING & ZONING $23,317 $26,791 $58,800 $11,689 $30,050 $30,050 ENGINEERING $14,673 $5,843 $27,000 $2,818 $27,000 $27,000 BUILDING INSPECTIONS $137,711 $142,456 $120,215 $55,589 $123,150 $123,150 POLICE $852,796 $896,760 $954,415 $438,020 $997,700 $997,700 FIRE $118,183 $119,990 $125,492 $62,497 $133,125 $133,125 CIVIL DEFENSE $75 $94 $5,100 $39 $5,100 $5,100 ANIMAL CONTROL $1,044 $738 $1,900 $0 $1,650 $1,650 PUBLIC WORKS- STREET MAINTENANCE $41,403 $34,733 $47,895 $20,421 $51,705 $51,705 PUBLIC WORKS -SNOW REMOVAL $53,477 $63,476 $86,500 $37,932 $93,500 $93,500 PUBLIC WORKS- STREET LIGHTING $47,446 $49,492 $55,450 $22,322 $60,800 $60,800 TREE REMOVAUPLANTING $28,115 $30,049 $35,530 $15,562 $40,530 $40,530 SANITATION & WASTE $88,500 $88,500 $88,500 $44,250 $73,500 $73,500 PARKS $88,181 $99,980 $127,625 $38,569 $134,745 $134,745 COUNCIL CONTINGENCY $6,764 $6,652 $10,000 $3,577 $10,000 $10,000 MISCELLANEOUS EXPENSE $0 $21,000 $0 $0 $0 $0 TRANSFERS OUT $224,800 $461,630 $270,180 $135,090 $493,000 $493,000 TOTAL SUMMARY OF PAST GENERAL FUND EXPENDITURES $2,491,012 $2,859,822 $2,927,772 $1,296,250 $3,283,930 $3,283,930 2007 FINAL BUDGET Page 11 MAYOR & COUNCIL FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40100 -101 SALARIES OF REGULAR EMPLOYEES $26,000 $26,000 $26,000 $13,000 $28,600 $28,600 101 -40100 -103 PROFESSIONAL & CONSULTANT SERVICES $12,891 $10,932 $18,000 $11,989 $19,500 $19,500 TOTAL PERSONAL SERVICES $38,891 $36,932 $44,000 $24,989 $48,100 $48,100 CONTRACTUAL SERVICES 101 -40100 -201 POSTAGE (NEWSLETTER) $0 $733 $1,000 $239 $1,000 $1,000 101 -40100 -203 TRAVEL, CONFERENCE, & SCHOOLS $2,916 $3,635 $7,000 $2,663 $10,125 $10,125 101 -40100 -205 PRINTING, PUBLISHING, NEWSLETTER $7,758 $6,802 $10,000 $3,646 $9,000 $9,000 101 -40100 -212 OTHER CONTRACTUAL SERVICES $375 $0 $500 $0 $500 $500 TOTAL CONTRACTUAL SERVICES $11,049 $11,170 $18,500 $6,548 $20,625 $20,625 MATERIALS & SUPPLIES 101-40100-311 OTHER MATERIAL & SUPPLIES $499 $548 $800 $300 $800 $800 TOTAL MATERIAL & SUPPLIES $499 $548 $800 $300 $800 $800 FIXED CHARGES 101- 40100 -408 SUBSCRIPTIONS & MEMBERSHIPS $70 $903 $75 $25 $945 $945 101 - 40100 -410 FICA CONTRIBUTION $1,989 $1,989 $1,990 $995 $2,190 $2,190 TOTAL FIXED CHARGES $2,059 $2,892 $2,065 $1,020 $3,135 $3,135 MISC. EXPENSES 101 -40100 -910 COMMUNITY PICNIC $1,248 $448 $2,000 $0 $2,000 $2,000 101 -40100 -910 EMPLOYEE RECOGNITION EVENT $625 $0 $500 $0 $500 $500 TOTAL MISC. EXPENSES $1,873 $448 $2,500 $0 $2,500 $2,500 TOTAL MAYOR & COUNCIL $54,371 $51,990 $67,865 $32,857 $75,160 $75,160 2007 FINAL BUDGET Page 12 CITY ADMINISTRATION FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONNEL SERVICES 101 -40400 -101 SALARIES OF REGULAR EMPLOYEES $140,030 $153,278 $152,510 $76,999 $160,300 $160,300 101 -40400 -102 SALARIES OF TEMPORARY EMPLOYEES $1,159 $1,092 $4,000 $0 $4,000 $4,000 TOTAL PERSONAL SERVICES $141,189 $154,370 $156,510 $76,999 $164,300 $164,300 CONTRACTUAL SERVICES 101 -40400 -202 TELEPHONE $5,659 $5,855 $6,000 $2,974 $6,180 $6,180 101 -40400 -203 TRAVEL, CONFERENCE, SCHOOLS $1,428 $5,963 $10,750 $2,830 $10,750 $10,750 101 -40400 -205 PRINTING & PUBLISHING $13 $67 $50 $0 $75 $75 101 -40400 -212 OTHER CONTRACTUAL SERVICES $164 $0 $1,000 $0 $1,000 $1,000 TOTAL CONTRACTUAL SERVICES $7,264 $11,885 $17,800 $5,804 $18,005 $18,005 MATERIAL & SUPPLIES 101 -40400 -303 OFFICE SUPPLIES $2,085 $1,629 $3,000 $550 $3,000 $3,000 101 -40400 -310 BOOKS & PERIODICALS $359 $0 $400 $48 $200 $200 101 -40400 -311 OTHER MATERIAL & SUPPLIES $27 $428 $600 $259 $600 $600 TOTAL MATERIAL & SUPPLIES $2,471 $2,057 $4,000 $857 $3,800 $3,800 FIXED CHARGES 101 - 40400 -408 SUBSCRIPTIONS & MEMBERSHIPS $420 $619 $500 $0 $650 $650 101 - 40400 -409 PERA CONTRIBUTION $11,228 $12,363 $12,465 $6,338 $13,340 $13,340 101 - 40400 -410 FICA CONTRIBUTION $10,296 $10,687 $11,670 $5,383 $12,265 $12,265 TOTAL FIXED CHARGES $21,944 $23,669 $24,635 $11,721 $26,255 $26,255 TOTAL CITY ADMINISTRATION $172,868 $191,981 $202,945 $95,381 $212,360 $212,360 2007 FINAL BUDGET Page 13 LEGAL FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40200 -103 PROFESSIONAUCONSULTANT SERVICES $17,823 $17,447 $30,000 $7,164 $30,000 $30,000 PERSONAL SERVICES $17,823 $17,447 $30,000 $7,164 $30,000 $30,000 TOTAL LEGAL $17,823 $17,447 $30,000 $7,164 $30,000 $30,000 2007 FINAL BUDGET Page 14 GENERAL MANAGEMENT AND BUILDING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -40000 -201 POSTAGE $2,283 $2,128 $2,000 $984 $2,200 $2,200 101 -40000 -202 TELEPHONE $579 $0 $0 $0 $0 $0 101 -40000 -203 TRAVEL, CONFERENCE, SCHOOLS $0 $40 $0 $0 $0 $0 101 -40000 -206 UTILITIES $15,660 $22,654 $18,000 $10,723 $25,000 $25,000 101 -40000 -207 MAINTENANCE & REPAIR OF BUILDING & STRUCTURE $440 $2,841 $10,000 $360 $10,000 $10,000 101 -40000 -208 MAINTENANCE & REPAIR OF EQUIPMENT $25 $441 $1,000 $0 $1,000 $1,000 101 -40000 -212 OTHER CONTRACTUAL SERVICES $23,797 $16,167 $20,000 $10,314 $21,000 $21,000 TOTAL CONTRACTUAL SERVICES $42,784 $44,271 $51,000 $22,381 $59,200 $59,200 MATERIALS & SUPPLIES 101 -40000 -302 CLEANING SUPPLIES $99 $251 $200 $0 $200 $200 101 -40000 -303 OFFICE SUPPLIES $1,792 $1,179 $1,700 $1,329 $1,700 $1,700 101 -40000 -310 BOOKS & PERIODICALS $287 $982 $1,000 $643 $1,000 $1,000 101 -40000 -311 OTHER MATERIALS & SUPPLIES $3,597 $2,767 $5,000 $2,146 $5,000 $5,000 TOTAL MATERIAL & SUPPLIES $5,775 $5,179 $7,900 $4,118 $7,900 $7,900 FIXED CHARGES 101 - 40000 -403 RENT OF EQUIPMENT $856 $475 $900 $779 $1,200 $1,200 101 - 40000 -408 SUBSCRIPTIONS & MEMBERSHIPS $5,939 $6,381 $6,500 $2,032 $6,900 $6,900 101 - 40100 -417 LICENSE & REGISTRATION $0 $310 $0 $0 $0 $0 101 - 40000 -430 PROPERTY TAX $0 $4 $0 $0 $0 $0 TOTAL FIXED CHARGES $6,795 $7,170 $7,400 $2,811 $8,100 $8,100 CAPITAL OUTLAY 101 -40000 -504 OTHER IMPROVEMENTS $11,278 $0 $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $11,278 $0 $0 $0 $0 $0 REFUNDS & REIMBURSEMENTS 101 -40000 -701 OTHER REFUNDS & REIMBURSEMENTS $500 $0 $0 $0 $0 $0 TOTAL REFUNDS & REIMBURSEMENTS $500 $0 $0 $0 $0 $0 2007 FINAL BUDGET Page 15 GENERAL MANAGEMENT AND BUILDING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER 101 -40000 -905 FLEX PLAN FUNDING $3,000 $440 $0 $0 $0 $0 101 -40000 -940 GRANTS & CONTRIBUTIONS $7,600 $7,600 $8,000 $0 $9,200 $9,200 101 -40000 -955 INTEREST AND PENALTIES $81 $0 $0 $0 $0 $0 TOTAL OTHER $10,681 $8,040 $8,000 $0 $9,200 $9,200 TOTAL GENERAL MANAGEMENT AND BUILDING $77,813 $64,660 $74,300 $29,310 $84,400 $84,400 2007 FINAL BUDGET Page 16 ELECTIONS FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40300 -102 SALARY OF TEMPORARY EMPLOYEE $4,029 $2,642 $4,500 $0 $2,700 $2,700 TOTAL PERSONAL SERVICES $4,029 $2,642 $4,500 $0 $2,700 $2,700 CONTRACTUAL SERVICES 101 -40300 -201 POSTAGE $0 $0 $600 $0 $0 $0 101 -40300 -208 MAINTENANCE & REPAIR OF EQUIPMENT $340 $340 $400 $340 $340 $340 TOTAL CONTRACTUAL SERVICES $340 $340 $1,000 $340 $340 $340 MATERIAL & SUPPLIES 101 -40300 -311 OTHER MATERIAL & SUPPLIES $637 $302 $1,300 $0 $350 $350 TOTAL MATERIAL & SUPPLIES $637 $302 $1,300 $0 $350 $350 TOTAL ELECTIONS $5,006 $3,284 $6,800 $340 $3,390 $3,390 2007 FINAL BUDGET Page 17 FINANCE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40600 -101 SALARIES OF REGULAR EMPLOYEES $135,425 $142,265 $146,720 $72,412 $187,500 $187,500 TOTAL PERSONAL SERVICES $135,425 $142,265 $146,720 $72,412 $187,500 $187,500 CONTRACTUAL SERVICES 101 -40600 -202 TELEPHONE $1,461 $1,426 $1,600 $717 $1,600 $1,600 101 -40600 -203 TRAVEL, CONFERENCE, SCHOOLS $395 $144 $1,900 $37 $1,900 $1,900 101 -40600 -212 OTHER CONTRACTUAL SERVICES $0 $44 $100 $0 $100 $100 TOTAL CONTRACTUAL SERVICES $1,856 $1,614 $3,600 $754 $3,600 $3,600 MATERIALS & SUPPLIES 101 -40600 -303 OFFICE SUPPLIES $1,712 $1,436 $2,000 $430 $2,100 $2,100 101 -40600 -311 OTHER MATERIALS & SUPPLIES $150 $148 $400 $0 $400 $400 101 -40600 -312 UNIFORMS $28 $23 $300 $0 $325 $325 TOTAL MATERIAL & SUPPLIES $1,890 $1,607 $2,700 $430 $2,825 $2,825 FIXED CHARGES 101 - 40600 -408 SUBSCRIPTIONS & MEMBERSHIPS $225 $240 $275 $240 $275 $275 101 - 40600 -409 PERA CONTRIBUTION $7,489 $7,867 $8,805 $4,344 $11,720 $11,720 101 - 40600 -410 FICA CONTRIBUTION $10,198 $10,673 $11,225 $5,422 $14,345 $14,345 TOTAL FIXED CHARGES $17,912 $18,780 $20,305 $10,006 $26,340 $26,340 TOTAL FINANCE $157,083 $164,266 $173,325 $83,602 $220,265 $220,265 2007 FINAL BUDGET Page 18 COMPUTER FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -40650 -208 MAINTENANCE OF EQUIPMENT $1,225 $0 $7,000 $0 $0 $0 101 - 40650 -212 OTHER CONTRACTUAL SERVICES $5,098 $12,050 $13,500 $1,135 $20,970 $20,970 TOTAL CONTRACTUAL SERVICES $6,323 $12,050 $20,500 $1,135 $20,970 $20,970 MATERIALS & SUPPLIES 101 -40650 -311 OTHER MATERIALS & SUPPLIES $3,057 $5,272 $1,500 $162 $1,500 $1,500 TOTAL MATERIALS & SUPPLIES $3,057 $5,272 $1,500 $162 $1,500 $1,500 TOTAL COMPUTER $9,380 $17,322 $22,000 $1,297 $22,470 $22,470 2007 FINAL BUDGET Page 19 AUDIT FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40670 -103 PROFESSIONAUCONSULTANT SERVICES $16,498 $10,743 $15,900 $15,838 $16,500 $16,500 TOTAL PERSONAL SERVICES $16,498 $10,743 $15,900 $15,838 $16,500 $16,500 TOTAL AUDIT $16,498 $10,743 $15,900 $15,838 $16,500 $16,500 2007 FINAL BUDGET Page 20 INSURANCE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CITY INSURANCE 101 - 40690 -404 INSURANCE ON BUILDING & CONTENT $13,817 $14,583 $16,500 $0 $16,440 $16,440 101 - 40690 -405 INSURANCE ON EQUIPMENT $4,412 $4,475 $4,150 $0 $4,990 $4,990 101 - 40690 -406 WORKERS COMPENSATION $21,723 $26,338 $26,700 $24,741 $29,100 $29,100 101 - 40690 -418 GENERAL LIABILITY INSURANCE $13,561 $14,524 $15,100 $0 $14,530 $14,530 101 - 40690 -419 UMBRELLA INSURANCE $4,213 $4,723 $4,925 $0 $4,960 $4,960 TOTAL CITY INSURANCE $57,726 $64,643 $67,375 $24,741 $70,020 $70,020 EMPLOYEE BENEFIT INSURANCE 101 - 40690 -415 EMPLOYEE HOSPITAL & LIFE INSURANCE $171,607 $200,914 $227,220 $114,360 $247,325 $247,325 101 - 40690 -416 EMPLOYEE DISABILITY INSURANCE $6,226 $6,262 $6,340 $2,985 $7,450 $7,450 TOTAL EMPLOYEE BENEFIT INSURANCE $177,833 $207,176 $233,560 $117,345 $254,775 $254,775 NOTE: UTILITY FUND BUDGET /EXPENDITURE FOR CITY INSURANCE $21,772 $23,080 $4,870 $24,490 $24,490 GENERAL FUND BUDGET /EXPENDITURE FOR CITY INSURANCE $64,643 $67,375 $24,741 $70,020 $70,020 $86,415 $90,455 $29,611 $94,510 $94,510 UTILITY FUND BUDGET /EXPENDITURE FOR EMPLOYEE INSURANCE $41,755 $44,095 $21,552 $43,135 $43,135 GENERAL FUND BUDGET /EXPENDITURE FOR EMPLOYEE INSURANCE $207,176 $233,560 $117,345 $254,775 $254,775 TOTAL EMPLOYEE INSURANCE $248,931 $277,655 $138,897 $297,910 $297,910 TOTAL ALL INSURANCE $335,346 $368,110 $168,508 $392,420 $392,420 TOTAL INSURANCE COSTS $235,559 $271,819 $300,935 $142,086 $324,795 $324,795 2007 FINAL BUDGET Page 21 ASSESSING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -40700 -103 PROFESSIONAL & CONSULTANT SERVICES $18,126 $18,126 $19,100 $0 $19,035 $19,035 TOTAL PERSONAL SERVICES $18,126 $18,126 $19,100 $0 $19,035 $19,035 TOTAL ASSESSOR $18,126 $18,126 $19,100 $0 $19,035 $19,035 2007 FINAL BUDGET Page 22 PLANNING & ZONING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101-40500-103 PROFESSIONAL & CONSULTANT SERVICES $22,242 $25,141 $28,000 $11,104 $28,000 $28,000 101 -40500 -103 PROF & CONS SVCS -COMP PLAN /ZONING ORD/TRL PLAN $0 $0 $28,750 $0 $0 $0 TOTAL PERSONAL SERVICES $22,242 $25,141 $56,750 $11,104 $28,000 $28,000 CONTRACTUAL SERVICES 101 -40500 -203 TRAVEL, CONFERENCE, SCHOOL $0 $0 $300 $0 $300 $300 101 -40500 -209 MEETING PER DIEMS $1,075 $1,650 $1,500 $575 $1,500 $1,500 TOTAL CONTRACTUAL SERVICES $1,075 $1,650 $1,800 $575 $1,800 $1,800 MATERIALS AND SUPPLIES 101 -40500 -311 OTHER MATERIALS AND SUPPLIES $0 $0 $100 $10 $100 $100 TOTAL MATERIALS AND SUPPLIES $0 $0 $100 $10 $100 $100 FIXED CHARGES 101 - 40500 -408 SUBSCRIPTIONS & MEMBERSHIPS $0 $0 $150 $0 $150 $150 TOTAL FIXED CHARGES $0 $0 $150 $0 $150 $150 TOTAL PLANNING & ZONING $23,317 $26,791 $58,800 $11,689 $30,050 $30,050 2007 FINAL BUDGET Page 23 ENGINEERING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -41000 -103 PROFESSIONAL & CONSULTANT SERVICES $14,673 $5,843 $27,000 $2,818 $27,000 $27,000 TOTAL PERSONAL SERVICES $14,673 $5,843 $27,000 $2,818 $27,000 $27,000 TOTAL ENGINEERING $14,673 $5,843 $27,000 $2,818 $27,000 $27,000 2007 FINAL BUDGET Page 24 BUILDING INSPECTIONS FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -41530 -101 SALARIES OF REGULAR EMPLOYEES $83,175 $89,372 $92,530 $45,664 $95,300 $95,300 101 -41530 -103 PROFESSIONAL & CONSULTANT SERVICES $20,702 $28,710 $0 $0 $0 $0 101 -41530 -104 FIRE PROTECTION SERVICES $13,126 $3,481 $2,500 $1,561 $2,000 $2,000 TOTAL PERSONAL SERVICES $117,003 $121,563 $95,030 $47,225 $97,300 $97,300 CONTRACTUAL SERVICES 101 -41530 -201 POSTAGE $450 $371 $400 $88 $400 $400 101 -41530 -202 TELEPHONE $1,974 $2,095 $2,000 $933 $2,000 $2,000 101 -41530 -203 TRAVEL, CONFERENCE, SCHOOLS $1,656 $1,251 $2,500 $474 $2,500 $2,500 101 -41530 -208 MAINTENANCE OF EQUIPMENT $337 $2,646 $2,000 $0 $2,000 $2,000 101 -41530 -212 OTHER CONTRACTUAL SERVICES $1,625 $13 $2,000 $4 $2,000 $2,000 TOTAL CONTRACTUAL SERVICES $6,042 $6,376 $8,900 $1,499 $8,900 $8,900 MATERIAL & SUPPLIES 101 -41530 -303 OFFICE SUPPLIES $780 $883 $1,000 $80 $1,000 $1,000 101 -41530 -307 MOTOR FUELS & LUBRICANTS $633 $781 $800 $264 $850 $850 101 -41530 -310 BOOKS & PERIODICALS $1,219 $87 $400 $0 $400 $400 101 -41530 -311 OTHER MATERIALS & SUPPLIES $179 $233 $500 $173 $500 $500 101 -41530 -312 UNIFORMS $594 $488 $600 $125 $600 $600 TOTAL MATERIAL & SUPPLIES $3,405 $2,472 $3,300 $642 $3,350 $3,350 FIXED CHARGES 101 - 41530 -408 SUBSCRIPTIONS & MEMBERSHIPS $200 $350 $300 $135 $300 $300 101 - 41530 -409 PERA CONTRIBUTION $4,693 $4,942 $5,555 $2,740 $5,960 $5,960 101 - 41530 -410 FICA CONTRIBUTION $6,326 $6,673 $7,080 $3,334 $7,290 $7,290 101 - 41530 -417 LICENSE /REGISTRATION FEE $42 $80 $50 $14 $50 $50 TOTAL FIXED CHARGES $11,261 $12,045 $12,985 $6,223 $13,600 $13,600 TOTAL BUILDING INSPECTIONS $137,711 $142,456 $120,215 $55,589 $123,150 $123,150 2007 FINAL BUDGET Page 25 POLICE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101-41510-101 SALARIES OF REGULAR EMPLOYEES $672,222 $696,293 $739,680 $341,168 $762,000 $762,000 101-41510-103 PROFESSIONAL & CONSULTANT SERVICES $41,987 $44,262 $50,000 $18,313 $50,000 $50,000 TOTAL PERSONAL SERVICES $714,209 $740,555 $789,680 $359,481 $812,000 $812,000 CONTRACTUAL SERVICES 101-41510-201 POSTAGE $343 $266 $450 $114 $400 $400 101 -41510 -202 TELEPHONE $7,468 $7,879 $8,000 $4,010 $8,200 $8,200 101 -41510 -203 TRAVEL, CONFERENCE, SCHOOLS $1,704 $1,731 $4,500 $643 $4,500 $4,500 101 -41510 -208 MAINTENANCE & REPAIR OF EQUIPMENT $16,543 $11,468 $12,000 $9,702 $13,000 $13,000 101 -41510 -212 OTHER CONTRACTUAL SERVICES $6,809 $7,006 $7,500 $4,770 $7,500 $7,500 TOTAL CONTRACTUAL SERVICES $32,867 $28,350 $32,450 $19,239 $33,600 $33,600 MATERIAL & SUPPLIES 101-41510-303 OFFICE SUPPLIES $1,357 $1,444 $1,500 $293 $1,500 $1,500 101 -41510 -307 MOTOR FUELS & LUBRICANTS $16,866 $21,170 $23,500 $10,972 $30,000 $30,000 101 - 41510 -310 BOOKS & PERIODICALS $236 $0 $400 $35 $400 $400 101 -41510 -311 OTHER MATERIALS & SUPPLIES $3,131 $3,735 $5,000 $504 $5,000 $5,000 101 -41510 -312 UNIFORMS $6,083 $6,158 $7,275 $5,389 $9,200 $9,200 TOTAL MATERIAL AND SUPPLIES $27,673 $32,507 $37,675 $17,193 $46,100 $46,100 FIXED CHARGES 101 - 41510 -403 RENT OF EQUIPMENT $6,840 $6,840 $8,000 $1,710 $8,000 $8,000 101 - 41510 -408 SUBSCRIPTIONS & MEMBERSHIPS $1,192 $1,102 $400 $210 $500 $500 101 - 41510 -409 PERA CONTRIBUTION $60,780 $63,350 $75,440 $35,170 $86,400 $86,400 101 - 41510 -410 FICA CONTRIBUTION $8,673 $9,030 $10,270 $4,464 $10,600 $10,600 101 - 41510 -417 LICENSE & REGISTRATION FEE $415 $556 $500 $127 $500 $500 TOTAL FIXED CHARGES $77,900 $80,878 $94,610 $41,681 $106,000 $106,000 OTHER EXPENSES 101 -41510 -503 FURNITURE & EQUIPMENT $147 $0 $0 $426 $0 $0 101 -41510 -701 REFUNDS & REIMBURSEMENTS $0 $14,470 $0 $0 $0 $0 TOTAL OTHER EXPENSES $147 $14,470 $0 $426 $0 $0 TOTAL POLICE DEPARTMENT $852,796 $896,760 $954,415 $438,020 $997,700 $997,700 2007 FINAL BUDGET Page 26 FIRE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 - 41520 -212 OTHER CONTRACTUAL SERVICES $118,183 $117,990 $120,992 $60,497 $128,625 $128,625 101 -41520 -214 INSPECTION SERVICES $0 $0 $2,500 $0 $2,500 $2,500 TOTAL CONTRACTUAL SERVICES $118,183 $117,990 $123,492 $60,497 $131,125 $131,125 MATERIALS & SUPPLIES 101 -41520 -311 OTHER MATERIALS & SUPPLIES (EDUCATION MATERIALS) $0 $2,000 $2,000 $2,000 $2,000 $2,000 TOTAL MATERIALS 8 SUPPLIES $0 $2,000 $2,000 $2,000 $2,000 $2,000 TOTAL FIRE $118,183 $119,990 $125,492 $62,497 $133,125 $133,125 2007 FINAL BUDGET Page 27 CIVIL DEFENSE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -41540 -206 UTILITIES $75 $94 $100 $39 $100 $100 101 -41540 -212 OTHER CONTRACTUAL SERVICES $0 $0 $5,000 $0 $5,000 $5,000 TOTAL CONTRACTUAL SERVICES $75 $94 $5,100 $39 $5,100 $5,100 TOTAL CIVIL DEFENSE $75 $94 $5,100 $39 $5,100 $5,100 2007 FINAL BUDGET Page 28 ANIMAL CONTROL FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -41550 -212 OTHER CONTRACTUAL SERVICES $1,003 $659 $1,750 $0 $1,500 $1,500 TOTAL CONTRACTUAL SERVICES $1,003 $659 $1,750 $0 $1,500 $1,500 MATERIAL & SUPPLIES 101 -41550 -311 OTHER MATERIAL & SUPPLIES $41 $79 $150 $0 $150 $150 TOTAL MATERIAL & SUPPLIES $41 $79 $150 $0 $150 $150 TOTAL ANIMAL CONTROL $1,044 $738 $1,900 $0 $1,650 $1,650 2007 FINAL BUDGET Page 29 PUBLIC WORKS - STREET MAINTENANCE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -42010 -101 SALARIES OF REGULAR EMPLOYEES $15,210 $14,770 $18,660 $8,719 $19,715 $19,715 101 -42010 -102 SALARIES OF TEMPORARY EMPLOYEES $934 $0 $0 $0 $0 $0 101 -42010 -103 PROFESSIONAL & CONTRACTUAL SERVICES $0 $1,462 $0 $0 $0 $0 101 -42010 -107 UNEMPLOYMENT $202 $0 $0 $0 $0 $0 TOTAL PERSONAL SERVICES $16,346 $16,232 $18,660 $8,719 $19,715 $19,715 CONTRACTUAL SERVICES 101 -42010 -201 POSTAGE $2 $11 $30 $0 $30 $30 101 -42010 -202 TELEPHONE $192 $194 $230 $96 $240 $240 101 -42010 -203 TRAVEL, CONFERENCE, SCHOOLS $0 $74 $0 $51 $180 $180 101 -42010 -206 UTILITIES $2,598 $2,226 $3,300 $1,431 $3,600 $3,600 101 -42010 -208 MAINTENANCE & REPAIR OF EQUIPMENT $262 $452 $850 $130 $1,000 $1,000 10142010 -212 OTHER CONTRACTUAL SERVICES $15,030 $10,788 $14,585 $4,189 $15,585 $15,585 TOTAL CONTRACTUAL SERVICES $18,084 $13,745 $18,995 $5,897 $20,635 $20,635 MATERIAL & SUPPLIES 101 -42010 -301 CHEMICAL SUPPLIES $0 $0 $0 $0 $400 $400 101 -42010 -303 OFFICE SUPPLIES $21 ($1) $30 $6 $75 $75 101 -42010 -307 MOTOR FUELS & LUBRICANTS $255 $387 $350 $179 $500 $500 10142010 -308 SMALL TOOLS $89 $32 $75 $7 $400 $400 10142010 -311 OTHER MATERIAL & SUPPLIES $1,671 $1,171 $2,500 $3,501 $3,500 $3,500 101 -42010 -312 UNIFORMS $107 $156 $210 $28 $210 $210 10142010 -313 STREET SIGNS $1,635 $1,091 $3,000 $853 $3,000 $3,000 TOTAL MATERIAL & SUPPLIES $3,778 $2,836 $6,165 $4,574 $8,085 $8,085 FIXED CHARGES 101 - 42010 -403 RENT OF EQUIPMENT $1,194 $0 $500 $53 $500 $500 101- 42010 -409 PERA CONTRIBUTION $780 $817 $1,120 $523 $1,235 $1,235 10142010410 FICA CONTRIBUTION $1,219 $1,103 $1,430 $652 $1,510 $1,510 101 - 42010417 LICENSE OR REGISTRATION FEE $2 $0 $25 $3 $25 $25 TOTAL FIXED CHARGES $3,195 $1,920 $3,075 $1,231 $3,270 $3,270 CAPITAL OUTLAY 101 -42010 -505 OTHER IMPROVEMENTS $0 $0 $1,000 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $1,000 $0 $0 $0 TOTAL STREET MAINTENANCE $41,403 $34,733 $47,895 $20,421 $51,705 $51,705 2007 FINAL BUDGET Page 30 PUBLIC WORKS - SNOW REMOVAL FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -42020 -208 MAINTENANCE & REPAIR OF EQUIPMENT $340 $1,030 $1,500 $107 $1,000 $1,000 101 -42020 -212 OTHER CONTRACTUAL SERVICES $52,439 $62,190 $83,500 $37,802 $92,000 $92,000 TOTAL CONTRACTUAL SERVICES $52,779 $63,220 $85,000 $37,909 $93,000 $93,000 MATERIAL & SUPPLIES 101 -42020 -311 OTHER MATERIAL & SUPPLIES $698 $256 $1,500 $23 $500 $500 TOTAL MATERIAL & SUPPLIES $698 $256 $1,500 $23 $500 $500 TOTAL SNOW REMOVAL $53,477 $63,476 $86,500 $37,932 $93,500 $93,500 2007 FINAL BUDGET Page 31 PUBLIC WORKS - STREET LIGHTING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 101 -42030 -206 UTILITIES $47,446 $49,492 $53,450 $22,322 $58,800 $58,800 101 -42030 -212 OTHER CONTRACTUAL SERVICES $0 $0 $1,000 $0 $2,000 $2,000 TOTAL CONTRACTUAL SERVICES $47,446 $49,492 $54,450 $22,322 $60,800 $60,800 CAPITAL OUTLAY 101 -42030 -505 OTHER IMPROVEMENTS $0 $0 $1,000 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $1,000 $0 $0 $0 TOTAL STREET LIGHTING $47,446 $49,492 $55,450 $22,322 $60,800 $60,800 TOTAL PUBLIC WORKS $142,326 $147,701 $189,845 $80,675 $206,005 $206,005 2007 FINAL BUDGET Page 32 TREE REMOVAL & PLANTING FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED ARBORIST PERSONAL SERVICES 101 -42040 -103 PROFESSIONAL & CONSULTANT SERVICES $11,745 $10,282 $15,125 $4,635 $15,125 $15,125 TOTAL PERSONAL SERVICES $11,745 $10,282 $15,125 $4,635 $15,125 $15,125 CONTRACTUAL SERVICES 101 -42040 -201 POSTAGE $0 $3 $5 $0 $5 $5 101 -42040 -202 TELEPHONE $4 $0 $0 $0 $0 $0 101 -42040 -203 TRAVEL,CONFERENCE, SCHOOLS $150 $100 $150 $0 $150 $150 TOTAL CONTRACTUAL SERVICES $154 $103 $155 $0 $155 $155 MATERIAL & SUPPLIES 101 -42040 -311 OTHER MATERIAL & SUPPLIES $66 $0 $150 $0 $150 $150 TOTAL MATERIAL & SUPPLIES $66 $0 $150 $0 $150 $150 FIXED CHARGES 101 - 42040 -408 SUBSCRIPTIONS & MEMBERSHIPS $0 $89 $100 $0 $100 $100 $0 $89 $100 $0 $100 $100 TOTAL ARBORIST $11,965 $10,474 $15,530 $4,635 $15,530 $15,530 TREE REMOVAUPLANTING CONTRACTUAL SERVICES 10142520 -212 OTHER CONTRACTUAL SERVICES $16,150 $19,575 $20,000 $10,927 $25,000 $25,000 TOTAL CONTRACTUAL SERVICES $16,150 $19,575 $20,000 $10,927 $25,000 $25,000 TOTAL TREE REMOVAUPLANTING $16,150 $19,575 $20,000 $10,927 $25,000 $25,000 TOTAL TREE REMOVAL/PLANTING $28,115 $30,049 $35,530 $15,562 $40,530 $40,530 2007 FINAL BUDGET Page 33 SANITATION & SOLID WASTE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER EXPENSES 101 -42510 -920 TRANSFER TO UTILITY FUND $88,500 $88,500 $88,500 $44,250 $73,500 $73,500 TOTAL OTHER EXPENSES $88,500 $88,500 $88,500 $44,250 $73,500 $73,500 TOTAL SANITATION & WASTE $88,500 $88,500 $88,500 $44,250 $73,500 $73,500 2007 FINAL BUDGET Page 34 PARKS FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 101 -44010 -101 SALARIES OF REGULAR EMPLOYEES $16,934 $28,849 $34,725 $15,857 $38,135 $38,135 10144010 -102 SALARIES OF TEMPORARY EMPLOYEES $19,103 $9,174 $16,310 $6,699 $16,310 $16,310 10144010 -107 UNEMPLOYMENT $1,688 $0 $0 $0 $0 $0 TOTAL PERSONAL SERVICES $37,725 $38,023 $51,035 $22,556 $54,445 $54,445 CONTRACTUAL SERVICES 10144010 -201 POSTAGE $67 $97 $150 $48 $150 $150 10144010 -202 TELEPHONE $1,946 $2,036 $2,300 $933 $2,400 $2,400 10144010 -203 TRAVEL, CONFERENCE, SCHOOLS $365 $182 $400 $164 $540 $540 101 -44010 -206 UTILITIES $3,014 $3,485 $4,000 $1,923 $4,400 $4,400 101 - 44010 -207 MAINT. /REPAIR OF BUILDINGS /STRUCTURES $748 $2,329 $7,400 $0 $9,000 $9,000 10144010 -208 MAINTENANCE /REPAIR OF EQUIPMENT $304 $1,005 $1,500 $205 $1,500 $1,500 101 -44010 -209 MEETING PER DIEMS $700 $1,000 $1,500 $525 $1,500 $1,500 10144010 -212 OTHER CONTRACTUAL SERVICES $20,649 $24,284 $29,000 $6,830 $30,000 $30,000 TOTAL CONTRACTUAL SERVICES $27,793 $34,418 $46,250 $10,628 $49,490 $49,490 MATERIALS & SUPPLIES 101 -44010 -301 CHEMICAL SUPPLIES $0 $1,887 $1,600 $41 $1,600 $1,600 101-44010-302 CLEANING SUPPLIES $0 $0 $150 $0 $150 $150 10144010 -303 OFFICE SUPPLIES $34 ($1) $50 $15 $50 $50 101 -44010 -307 MOTOR FUELS & LUBRICANTS $221 $339 $450 $157 $550 $550 10144010 -308 SMALL TOOLS $176 $130 $200 $63 $1,000 $1,000 10144010 -311 OTHER MATERIALS & SUPPLIES $3,405 $5,373 $5,000 $2,437 $5,000 $5,000 101 -44010 -312 UNIFORMS $96 $136 $400 $24 $400 $400 TOTAL MATERIAL & SUPPLIES $3,932 $7,864 $7,850 $2,737 $8,750 $8,750 FIXED CHARGES 10144010 -403 RENT OF EQUIPMENT $79 $224 $1,400 $0 $500 $500 101 - 44010409 PERA CONTRIBUTION $918 $1,602 $2,085 $952 $2,385 $2,385 10144010 -410 FICA CONTRIBUTION $2,732 $2,849 $3,905 $1,693 $4,165 $4,165 101 - 44010 -417 LICENSE /REGISTRATION FEE $2 $0 $100 $3 $10 $10 TOTAL FIXED CHARGES $3,731 $4,675 $7,490 $2,648 $7,060 $7,060 2007 FINAL BUDGET Page 35 PARKS FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER EXPENSES 101 -44010 -940 GRANTS (HOCKEY ARENA) $15,000 $15,000 $15,000 $0 $15,000 $15,000 TOTAL OTHER EXPENSES $15,000 $15,000 $15,000 $0 $15,000 $15,000 'SEE BUDGETED PROJECTS AND EQUIPMENT REVOLVING FUND FOR PARK COMMISSION PROJECTS. TOTAL PARKS $88,181 $99,980 $127,625 $38,569 $134,745 $134,745 2007 FINAL BUDGET Page 36 COUNCIL CONTINGENCY FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER EXPENDITURES 101 -46000 -703 CONTINGENCIES $6,764 $6,652 $10,000 $3,577 $10,000 $10,000 TOTAL OTHER EXPENDITURES $6,764 $6,652 $10,000 $3,577 $10,000 $10,000 TOTAL COUNCIL CONTINGENCY $6,764 $6,652 $10,000 $3,577 $10,000 $10,000 2007 FINAL BUDGET Page 37 MISCELLANEOUS EXPENSE FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER EXPENDITURES 101 -47000 -504 OTHER IMPROVEMENTS $0 $21,000 $0 $0 $0 $0 TOTAL OTHER EXPENDITURES $0 $21,000 $0 $0 $0 $0 TOTAL COUNCIL CONTINGENCY $0 $21,000 $0 $0 $0 $0 2007 FINAL BUDGET Page 38 TRANSFERS OUT TO OTHER FUNDS FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED OTHER EXPENSES 101 -44444 -920 TRANSFERS OUT TO DEBT SERVICE FUND $0 $61,380 $0 $0 $0 $0 101 - 44444 -920 TRANSFERS OUT TO STREET RECONSTRUCTION $0 $100,000 $152,180 $76,090 $225,000 $225,000 101 -44444 -920 TRANSFERS OUT TO BUDGETED PROJECTS $224,800 $300,250 $118,000 $59,000 $268,000 $268,000 TOTAL OTHER EXPENSES $224,800 $461,630 $270,180 $135,090 $493,000 $493,000 The 2007 Proposed transfers out to the Budgeted Projects Fund Is as follows: Sealcoat, Crack Seal $146,500 Outside Storage Area $15,000 Parks: Park & Trail Improvements $25,000 Trail Maintenance $5,000 Building Maintenance $5,000 Police Vehicle $25,000 Public Works Vehicles $6,000 Furniture and Equipment: Computers - PC's $5,000 Computers - Network Server $12,000 Council Chamber Projector $1,200 Police Radio System $7,500 Municipal Building $10,000 Parks Machinery & Equipment $1,000 Street Equipment $3,800 Total $268,000 TOTAL TRANSFERS OUT TO OTHER FUNDS $224,800 $461,630 $270,180 $135,090 $493,000 $493,000 2007 FINAL BUDGET Page 39 WATER UTILITY FUND This fund provides for water services to the City, maintenance of the wells and pumphouses, as well as administrative costs that are associated with these services TOTAL WATER UTILITY FUND REVENUES $478,200 TOTAL WATER UTILITY FUND EXPENDITURES $598,615 WATER UTILITY FUND SURPLUS (DEFICIT) ($120,415) 2007 FINAL BUDGET Page 40 WATER UTILITY FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED SPECIAL ASSESSMENTS 705 - 32020 -000 SPECIAL ASSESSMENTS - CURRENT $207 $930 $0 $0 $0 $0 705 - 32030 -000 SPECIAL ASSESSMENTS - DELINQUENT $42 $0 $0 $0 $0 $0 705 - 32040 -000 SPECIAL ASSESSMENTS -P &I $89 $202 $0 $0 $0 $0 TOTAL SPECIAL ASSESSMENTS $338 $1,132 $0 $0 $0 $0 NON - BUSINESS LICENSES & PERMITS 705 - 34050 -000 WATER FD -NON BUS. LICENSE & PERMITS $3,815 $615 $1,000 $575 $800 $800 705 - 34060 -000 WATER FUND -WATER METERS $14,367 $4,350 $5,000 $4,674 $3,000 $3,000 TOTAL NON - BUSINESS LICENSE & PERMITS $18,182 $4,965 $6,000 $5,249 $3,800 $3,800 CHARGES FOR SERVICES 705 - 37050 -000 WATER FUND -OTHER SERVICES $106 $11,055 $600 $3,508 $3,000 $3,000 TOTAL CHARGES FOR SERVICES $106 $11,055 $600 $3,508 $3,000 $3,000 CUSTOMER COLLECTIONS 705 - 38230 -000 WATER FD- CHARGE SVC. -CUST. COLL. $364,601 $402,912 $405,000 $183,985 $445,500 $445,500 705 - 38270 -000 WATER FUND - PENALTIES $4,182 $3,812 $4,488 $1,773 $4,900 $4,900 TOTAL CUSTOMER COLLECTIONS $368,783 $406,724 $409,488 $185,758 $450,400 $450,400 MSSCELLANEOUS REVENUE 705 - 38010 -000 INTEREST ON INVESTMENTS $10,893 $15,750 $13,500 $10,135 $21,000 $21,000 TOTAL MISCELLANEOUS REVENUE $10,893 $15,750 $13,500 $10,135 $21,000 $21,000 TOTAL WATER UTILITY FUND REVENUES $398,302 $439,626 $429,588 $204,650 $478,200 $478,200 2007 FINAL BUDGET Page 41 WATER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 705 -48100 -101 SALARIES OF REGULAR EMPLOYEES $104,149 $121,937 $138,200 $64,828 $130,410 $130,410 705 -48100 -102 SALARIES OF TEMPORARY EMPLOYEES $5,112 $0 $0 $0 $0 $0 705 -48100 -103 PROFESSIONAL & CONSULTANT SERVICES $5,460 $4,297 $31,850 $18,700 $6,000 $6,000 705 -48100 -107 UNEMPLOYMENT $252 $0 $0 $0 $0 $0 TOTAL PERSONAL SERVICES $114,973 $126,234 $170,050 $83,528 $136,410 $136,410 CONTRACTUAL SERVICES 705 -48100 -201 POSTAGE $2,396 $2,215 $2,200 $1,170 $1,500 $1,500 705 -48100 -202 TELEPHONE $2,635 $3,104 $3,000 $1,408 $3,000 $3,000 705 -48100 -203 TRAVEL, CONFERENCE, SCHOOLS $257 $1,373 $1,400 $719 $1,900 $1,900 705 -48100 -205 PRINTING & PUBLISHING $248 $0 $500 $212 $250 $250 705 -48100 -206 UTILITIES $14,218 $12,887 $18,000 $6,482 $20,700 $20,700 705 -48100 -207 MAINTENANCE /REPAIR OF BLDGJSTRUCT $15 $68 $8,500 $0 $10,000 $10,000 705 -48100 -208 MAINTENANCE /REPAIR OF EQUIPMENT $403 $2,348 $3,000 $414 $3,300 $3,300 705 -48100 -212 OTHER CONTRACTUAL SERVICES $7,291 $34,547 $18,000 $9,937 $20,000 $20,000 TOTAL CONTRACTUAL SERVICES $27,463 $56,542 $54,600 $20,342 $60,650 $60,650 MATERIAL & SUPPLIES 705 -48100 -301 CHEMICAL SUPPLIES $1,355 $1,712 $2,000 $1,115 $2,400 $2,400 705 -48100 -303 OFFICE SUPPLIES $339 $298 $400 $108 $300 $300 705 -48100 -307 MOTOR FUELS & LUBRICANTS $1,500 $2,855 $2,300 $1,120 $3,300 $3,300 705 -48100 -308 SMALL TOOLS $628 $287 $200 $67 $500 $500 705 -48100 -311 OTHER MATERIAL & SUPPLIES $4,341 $5,616 $15,000 $5,368 $15,000 $15,000 705 -48100 -312 UNIFORMS $676 $973 $1,200 $172 $1,200 $1,200 TOTAL MATERIAL & SUPPLIES $8,839 $11,741 $21,100 $7,950 $22,700 $22,700 2007 FINAL BUDGET Page 42 WATER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED FIXED CHARGES 705 - 48100 -403 RENT OF EQUIPMENT $120 $20 $150 $0 $100 $100 705 - 48100 -404 INSURANCE ON BLDG. & CONTENT $2,867 $2,244 $2,400 $0 $2,660 $2,660 705 - 48100 -405 INSURANCE ON EQUIPMENT $731 $716 $635 $0 $830 $830 705 - 48100 -406 INSURANCE, WORKMANS COMP. $2,341 $2,255 $2,650 $2,712 $2,975 $2,975 705 - 48100 -408 SUBSCIPTION & MEMBERSHIP $140 $407 $250 $0 $250 $250 705 - 48100 -409 PERA CONTRIBUTION $5,912 $6,615 $8,295 $3,890 $8,150 $8,150 705 - 48100 -410 FICA CONTRIBUTION $9,061 $8,954 $10,575 $4,852 $9,085 $9,085 705 - 48100 -415 EMPLOYEE HOSPITAL & LIFE INSURANCE $23,630 $22,968 $24,140 $11,782 $23,560 $23,560 705 - 48100 -416 EMPLOYEE DISABILITY INSURANCE $505 $552 $640 $332 $740 $740 705 - 48100 -417 LICENSE & REGISTRATION FEES $1,223 $25 $1,500 $1,733 $2,000 $2,000 705 - 48100418 INSURANCE, GENERAL LIABILITY $4,978 $5,332 $5,550 $0 $5,600 $5,600 705 - 48100 -419 INSURANCE, UNBRELLA $1,404 $1,574 $1,640 $0 $1,655 $1,655 TOTAL FIXED CHARGES $52,912 $51,662 $58,425 $25,301 $57,605 $57,605 CAPITAL OUTLAY 705 -48100 -503 FURNITURE & EQUIPMENT $0 $2,921 $3,000 $341 $0 $0 TOTAL CAPITAL OUTLAY $0 $2,921 $3,000 $341 $0 $0 OTHER EXPENSES 70548100 -915 TRANSFER TO GENERAL FUND- ADMIN. FEE $24,565 $25,500 $21,175 $10,587 $22,950 $22,950 705 - 48100 -920 TRANS. TO BUDG. PROJ. FUND - VEHICLE PURCHASE $3,800 $3,800 $3,800 $1,900 $3,800 $3,800 705 -48100 -920 TRANS. TO BUDG. PROJ. FUND - COMPUTER $7,000 $7,000 $7,000 $3,500 $1,000 $1,000 705 - 48100 -920 TRANS. TO WATER REHAB WELL #2 $0 $0 $0 $0 $27,500 $27,500 705 -48100 -920 TRANS. TO WATER REHAB TOWER #1 $0 $0 $0 $0 $80,000 $80,000 705 -48100 -920 TRANS. TO WATER REHAB TOWER #2 $0 $0 $0 $0 $80,000 $80,000 705 -48100 -970 DEPRECIATION OF EXPENSES PURCHASED $12,022 $16,347 $12,025 $0 $17,000 $17,000 70548100 -975 DEPRECIATION OF EXPENSES CONTRIBUTED $82,393 $83,050 $87,450 $0 $89,000 $89,000 TOTAL OTHER EXPENSES $129,780 $135,697 $131,450 $15,987 $321,250 $321,250 TOTAL WATER UTILITY FUND EXPENDITURES $333,967 $384 $438,625 $153,449 $598 $598,615 2007 FINAL BUDGET Page 43 SEWER UTILITY FUND This fund provides for sanitary sewer services to the City, maintenance of the liftstations and sewer lines, as well as administrative costs that are associated with these services TOTAL SEWER UTILITY FUND REVENUES $724,500 TOTAL SEWER UTILITY FUND EXPENDITURES $710,920 SEWER UTILITY FUND SURPLUS (DEFICIT) $13,580 2007 FINAL BUDGET Page 44 SEWER UTILITY FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED SPECIAL ASSESSMENTS 706- 32020 -000 SPECIAL ASSESSMENTS- CURRENT $434 $1,598 $0 $0 $0 $0 706 - 32030 -000 SPECIAL ASSESSMENTS - DELINQUENT $88 $0 $0 $0 $0 $0 706 -32040 -000 SPECIAL ASSESSMENTS -P &I $187 $386 $0 $0 $0 $0 TOTAL SPECIAL ASSESSMENTS $709 $1,984 $0 $0 $0 $0 NON - BUSINESS LICENSES & PERMITS 706 - 34050 -000 SEWER FD -NON BUS. LICENSE & PERMITS $2,030 $595 $1,000 $260 $800 $800 TOTAL NON - BUSINESS LICENSES & PERMITS $2,030 $595 $1,000 $260 $800 $800 CHARGES FOR SERVICES 706 - 37050 -000 SEWER FUND -OTHER SERVICES $0 $0 $0 $3,218 $0 $0 TOTAL CHARGES FOR SERVICES $0 $0 $0 $3,218 $0 $0 CUSTOMER COLLECTIONS 706 - 38230 -000 SEWER FD- CHARGE SVC. -CUST. COLL. $557,401 $693,789 $671,000 $349,174 $698,000 $698,000 706 - 38270 -000 SEWER FUND - PENALTIES $7,142 $8,219 $7,750 $4,853 $9,700 $9,700 TOTAL SEWER $564,543 $702,008 $678,750 $354,027 $707,700 $707,700 MISCELLANEOUS REVENUE 706 - 38010 -000 INTEREST ON INVESTMENTS $6,405 $10,319 $7,800 $7,988 $16,000 $16,000 706- 38050 -000 SEWER FD -MISC. REV & OTHER REFUNDS $9,647 $870 $0 $0 $0 $0 TOTAL MISCELLANEOUS REVENUE $16,052 $11,189 $7,800 $7,988 $16,000 $16,000 TOTALSEWER UTILITY FUND REVENUES $583,334 $715,776 $687,550 $365,493 $724,500 $724,500 2007 FINAL BUDGET Page 45 SEWER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 706 -48200 -101 SALARIES OF REGULAR EMPLOYEES $72,934 $84,764 $92,590 $44,926 $82,335 $82,335 706 -48200 -102 SALARIES OF TEMPORARY EMPLOYEES $6,141 $0 $0 $0 $0 $0 706 -48200 -103 PROFESSIONAL & CONSULTANT SERVICES $2,000 $3,505 $19,350 $14,200 $4,000 $4,000 706 -48200 -107 LIMEMPLOYMENT $378 $0 $0 $0 $0 $0 TOTAL PERSONAL SERVICES $81,453 $88,269 $111,940 $59,126 $86,335 $86,335 CONTRACTUAL SERVICES 706 -48200 -201 POSTAGE $1,862 $1,807 $2,200 $899 $1,000 $1,000 706 -48200 -202 TELEPHONE $796 $784 $1,000 $368 $1,000 $1,000 706 -48200 -203 TRAVEL, CONFERENCE, SCHOOLS $1 $725 $1,250 $856 $1,750 $1,750 706 -48200 -205 PRINTING & PUBLISHING $0 $0 $150 $212 $250 $250 706 -48200 -206 UTILITIES $4,225 $5,099 $4,500 $2,099 $5,300 $5,300 706 -48200 -207 MAINTENANCE /REPAIR OF BLDGJSTRUCT $101 $0 $2,500 $0 $8,000 $8,000 706 -48200 -208 MAINTENANCE & REPAIR OF EQUIPMENT $242 $1,068 $1,200 $249 $1,500 $1,500 706 -48200 -212 OTHER CONTRACTUAL SERVICES $3,995 $9,845 $50,000 $13,803 $50,000 $50,000 706 -48200 -213 METRO SEWER SERVICE CHARGE $267,705 $292,590 $316,303 $158,151 $322,130 $322,130 TOTAL CONTRACTUAL SERVICES $278,927 $311,918 $379,103 $176,637 $390,930 $390,930 MATERIAL & SUPPLES 706 -48200 -301 CHEMICAL SUPPLIES $0 $0 $500 $0 $500 $500 706 -48200 -303 OFFICE SUPPLIES $287 $301 $300 $93 $100 $100 706 -48200 -307 MOTOR FUELS & LUBRICANTS $900 $1,454 $1,450 $672 $2,100 $2,100 706 -48200 -308 SMALL TOOLS $333 $132 $100 $25 $500 $500 706 -48200 -311 OTHER MATERIAL & SUPPLIES $630 $599 $1,300 $253 $1,300 $1,300 706 -48200 -312 UNIFORMS $406 $584 $750 $103 $750 $750 TOTAL MATERIAL & SUPPLIES $2,556 $3,070 $4,400 $1,146 $5,250 $5,250 I 2007 FINAL BUDGET Page 46 SEWER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED FIXED CHARGES 706 - 48200 -403 RENT OF EQUIPMENT $0 $0 $100 $0 $100 $100 706 - 48200 -404 INSURANCE ON BLDG. & CONTENTS $477 $499 $535 $0 $565 $565 706 -48200 -405 INSURANCE ON EQUIPMENT $439 $475 $380 $0 $585 $585 706 - 48200 -406 INSURANCE, WORKMANS COMP. $1,867 $1,771 $2,100 $2,158 $2,365 $2,365 706 - 48200 -408 SUBSCRIPTION & MEMBERSHIPS $10 $107 $170 $0 $170 $170 706 - 48200 -409 PERA CONTRIBUTION $4,144 $4,612 $5,555 $2,695 $5,145 $5,145 706 - 48200 -410 FICA CONTRIBUTION $6,467 $6,252 $7,085 $3,368 $6,300 $6,300 706 - 48200 -415 EMPLOYEE HOSPITAL & LIFE INSURANCE $15,273 $15,005 $15,945 $7,783 $15,230 $15,230 706 - 48200 -416 EMPLOYEE DISABILITY INSURANCE $352 $379 $440 $224 $470 $470 706 - 48200 -417 LICENSE/REGISTRATION FEE $32 $24 $70 $36 $50 $50 706 - 48200 -418 INSURANCE, GENERAL LIABILITY $4,979 $5,332 $5,550 $0 $5,600 $5,600 706 - 48200 -419 INSURANCE, UNBRELLA $1,404 $1,574 $1,640 $0 $1,655 $1,655 TOTAL FIXED CHARGES $35,444 $36,030 $39,570 $16,264 $38,235 $38,235 CAPITAL OUTLAY 706 - 48200 -505 MACHINERY & AUTO EQUIPMENT $0 $0 $10,000 $341 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $10,000 $341 $0 $0 OTHER EXPENSES 706 -48200 -915 TRANSFER OUT TO GENERAL FUND- ADMIN. FEE $44,275 $46,350 $39,200 $19,600 $37,170 $37,170 706 -48200 -920 TRANS. TO BUDG. PROJ. FUND - VEHICLE PURCHASE $3,800 $3,800 $3,800 $1,900 $3,800 $3,800 706 -48200 -920 TRANS. TO BUDG. PROJ. FUND - COMPUTER $7,000 $7,000 $7,000 $3,500 $1,000 $1,000 706 -48200 -920 TRANS. TO SEWER REHAB -LIFT STATIONS $0 $0 $0 $0 $35,000 $35,000 706 -48200 -920 TRANS. TO SEWER REHAB - GENERATOR $0 $0 $0 $0 $32,000 $32,000 706 -48200 -970 DEPRECIATION OF EXPENSES PURCHASED $2,950 $3,092 $3,000 $0 $3,200 $3,200 706 -48200 -975 DEPRECIATION OF EXPENSES CONTRIBUTED $71,630 $72,148 $76,700 $0 $78,000 $78,000 TOTAL OTHER EXPENSES $129,655 $132,390 $129,700 $25,000 $190,170 $190,170 TOTAL SEWER UTILITY FUND EXPENDITURES $528,035 $571,677 $674,713 $278,514 $710,920 $710,920 2007 FINAL BUDGET Page 47 STORM SEWER UTILITY FUND This fund provides for storm sewer services to the City, maintenance of the storm sewer and ponds, as well as administrative costs that are associated with these services TOTAL STORM SEWER UTILITY FUND REVENUES $77,750 TOTAL STORM SEWER UTILITY FUND EXPENDITURES $51,745 STORM SEWER UTILITY FUND SURPLUS (DEFICIT) $26,005 2007 FINAL BUDGET Page 48 STORM SEWER UTILITY FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED SPECIAL ASSESSMENTS 707 - 32020 -000 SPECIAL ASSESSMENTS - CURRENT $43 $173 $0 $0 $0 $0 707 - 32030 -000 SPECIAL ASSESSMENTS - DELINQUENT $8 $0 $0 $0 $0 $0 707 - 32040 -000 SPECIAL ASSESSMENTS -P &I $18 $72 $0 $0 $0 $0 TOTAL SPECIAL ASSESSMENTS $69 $245 $0 $0 $0 $0 NON - BUSINESS LICENSES & PERMITS 707 - 34050 -000 STORM SEWER -NON BUS. LICENSE & PERMITS $350 $0 $0 $50 $0 $0 TOTAL NON - BUSINESS LICENSES & PERMITS $350 $0 $0 $50 $0 $0 CUSTOMER COLLECTIONS 707 - 38230 -000 STORM SEWER- CHARGE SVC. -CUST. COLL. $69,810 $72,396 $72,770 $35,924 $72,000 $72,000 707 - 38270 -000 STORM SEWER - PENALITIES $1,068 $905 $1,400 $644 $1,300 $1,300 TOTAL CUSTOMER COLLECTIONS $70,878 $73,301 $74,170 $36,568 $73,300 $73,300 MISCELLANEOUS REVENUE 707 - 38010 -000 INTEREST ON INVESTMENTS $1,850 $3,183 $2,600 $2,216 $4,450 $4,450 TOTAL MISCELLANEOUS REVENUE $1,850 $3,183 $2,600 $2,216 $4,450 $4,450 TOTAL STORM SEWER UTILITY FUND REVENUES $73,147 $76,729 $76,770 $38,834 $77,750 $77,750 2007 FINAL BUDGET Page 49 STORM SEWER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED PERSONAL SERVICES 707 -48300 -101 SALARIES OF REGULAR EMPLOYEES $13,478 $14,478 $17,275 $7,925 $15,715 $15,715 707 -48300 -102 SALARIES OF TEMPORARY EMPLOYEES $214 $0 $0 $0 $0 $0 707 -48300 -103 PROFESSIONAL & CONSULTANT SERVICES $2,542 $407 $31,750 $22,500 $2,000 $2,000 TOTAL PERSONAL SERVICES $16,234 $14,885 $49,025 $30,425 $17,715 $17,715 CONTRACTUAL SERVICES 707 -48300 -201 POSTAGE $410 $374 $400 $199 $200 $200 707 -48300 -202 TELEPHONE $130 $130 $330 $75 $240 $240 707 -48300 -203 TRAVEL, CONFERENCE, SCHOOLS $0 $128 $100 $47 $100 $100 707 -48300 -205 PRINTING & PUBLISHING $0 $0 $0 $164 $100 $100 707 -48300 -208 MAINTENANCE /REPAIR OF EQUIPMENT $40 $212 $600 $41 $600 $600 707 -48300 -212 OTHER CONTRACTUAL SERVICES $13,597 $7,286 $20,000 $3,290 $20,000 $20,000 TOTAL CONTRACTUAL SERVICES $14,177 $8,130 $21,430 $3,816 $21,240 $21,240 MATERIAL & SUPPLIES 707 -48300 -303 OFFICE SUPPLIES $27 $263 $200 $74 $100 $100 707 -48300 -307 MOTOR FUELS & LUBRICANTS $150 $242 $230 $112 $350 $350 707 -48300 -308 SMALL TOOLS $55 $22 $150 $4 $200 $200 707 -48300 -311 OTHER MATERIAL & SUPPLIES $270 $311 $500 $53 $500 $500 707 -48300 -312 UNIFORMS $68 $97 $425 $17 $425 $425 TOTAL MATERIAL & SUPPLIES $570 $935 $1,505 $260 $1,575 $1,575 FIXED CHARGES 707 - 48300 -403 RENT OF EQUIPMENT $117 $0 $0 $0 $0 $0 707 - 48300 -409 PERA CONTRIBUTION $763 $800 $1,040 $476 $985 $985 707 - 48300 -410 FICA CONTRIBUTION $1,116 $1,089 $1,325 $595 $1,205 $1,205 707 - 48300 -415 EMPLOYEE HOSPITAL & LIFE INSURANCE $2,850 $2,780 $2,845 $1,389 $3,045 $3,045 707 - 48300 -416 EMPLOYEE DISABILITY INSURANCE $64 $71 $85 $42 $90 $90 707 - 48300 -417 LICENSE OR REGISTRATION FEE $2 $0 $50 $2 $10 $10 TOTAL FIXED CHARGES $4,912 $4,740 $5,345 $2,504 $5,335 $5,335 2007 FINAL BUDGET Page 50 STORM SEWER UTILITY FUND EXPENDITURES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CAPITAL OUTLAY 707 -48300 -503 FURNITURE & EQUIPMENT $0 $0 $200 $0 $0 $0 707 -48300 -505 OTHER IMPROVEMENTS $0 $0 $1,000 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $1,200 $0 $0 $0 OTHER EXPENSES 707 -48300 -915 TRANSFER TO GENERAL FUND- ADMIN.FEE $5,190 $5,460 $4,090 $2,045 $3,080 $3,080 707 -48300 -920 TRANS. TO BUDG. PROJ. FUND - VEHICLE PURCHASE $2,300 $2,300 $2,300 $1,150 $2,300 $2,300 707 -48300 -920 TRANS. TO BUDG. PROJ. FUND - COMPUTER $1,000 $1,000 $1,000 $500 $500 $500 TOTAL OTHER EXPENSES $8,490 $8,760 $7,390 $3,695 $5,880 $5,880 TOTAL STORM SEWER UTILITY FUND EXPENDITURES $44,383 $37,450 $85,895 $40,700 $51,745 $51,745 2007 FINAL BUDGET Page 51 SANITATION FUND This fund provides for sanitation services to the City. TOTAL SANITATION FUND REVENUES $170,650 TOTAL SANITATION FUND EXPENDITURES $152,700 SANITATION FUND SURPLUS (DEFICIT) $17,950 2007 FINAL BUDGET Page 52 SANITATION FUND REVENUES FIRST HALF 2004 2005 2006 2006 2007 2007 FUND ACTUAL ACTUAL BUDGETED RECEIVED REQUESTED AUTHORIZED SPECIAL ASSESSMENTS 708 - 32020 -000 SPECIAL ASSESSMENTS - CURRENT $153 $152 $0 $0 $0 $0 708 - 32030 -000 SPECIAL ASSESSMENTS - DELINQUENT $31 $0 $0 $0 $0 $0 708 - 32040 -000 SPECIAL ASSESSMENTS -P &I $66 $130 $0 $0 $0 $0 TOTAL SPECIAL ASSESSMENTS $250 $282 $0 $0 $0 $0 CUSTOMER COLLECTIONS 708 - 38230 -000 SANITATION - CUSTOMER COLLECTIONS $94,986 $94,944 $95,850 $47,308 $95,400 $95,400 708 - 38270 -000 SANITATION - PENALTIES $1,923 $1,633 $1,650 $855 $1,700 $1,700 TOTAL CUSTOMER COLLECTIONS $96,909 $96,577 $97,500 $48,163 $97,100 $97,100 MISCELLANEOUS REVENUE 708 - 38010 -000 INTEREST ON INVESTMENTS $0 $17 $0 $44 $50 $50 708 - 38050 -000 OTHER REFUNDS & REIMBURSEMENTS $446 $0 $0 $0 $0 $0 708 - 39470 -000 - SANITATION-TRANSFER IN FROM GENERAL FUND $88,500 $88,500 $88,500 $44,250 $73,500 $73,500 TOTAL MISCELLANEOUS REVENUE $88,946 $88,517 $88,500 $44,294 $73,550 $73,550 TOTAL SANITATION FUND REVENUES $186,105 $185,376 $186,000 $92,457 $170,650 $170,650 i 2007 FINAL BUDGET Page 53 SANITATION FUND EXPENDITURES FIRST HALF 2003 2004 2005 2005 2006 2006 FUND ACTUAL ACTUAL BUDGETED EXPENDED REQUESTED AUTHORIZED CONTRACTUAL SERVICES 708 -49100 -201 POSTAGE $0 $0 $400 $0 $0 $0 708 -49100 -205 PRINTING & PUBLISHING $0 $0 $300 $0 $0 $0 708 -49100 -210 CLEANING & WASTE REMOVAL $149,833 $147,120 $158,000 $47,352 $152,000 $152,000 TOTAL CONTRACTUAL SERVICES $149,833 $147,120 $158,700 $47,352 $152,000 $152,000 MATERIAL & SUPPLIES 708 -49100 -311 OTHER MATERIAL & SUPPLIES $0 $18 $2,000 $1,897 $100 $100 TOTAL MATERIAL & SUPPLIES $0 $18 $2,000 $1,897 $100 $100 OTHER EXPENSES 708 -49100 -704 RECYCLING AWARD $595 $604 $600 $223 $600 $600 708 -49100 -915 TRANSFER TO GENERAL FUND- ADMIN. FEE $16,830 $16,830 $0 $0 $0 $0 TOTAL OTHER EXPENSES $17,425 $17,434 $600 $223 $600 $600 TOTAL SANITATION FUND EXPENDITURES $167,258 $164,572 $161,300 $49,472 $152,700 $152,700 2007 FINAL BUDGET Page 54 DEBT SERVICE FUNDS SCHEDULE OF INDEBTEDNESS FINAL ISSUE PAYMENT INTEREST AUTHORIZED RETIRED OUTSTANDING DATE DATE RATE AND ISSUED TO DATE 1213112005 GENERAL DEBT G.O. REFUNDING BONDS OF 2002 11/1/2002 12/1/2006 2.19% $510,000 $445,000 $65,000 SPECIAL ASSESSMENT BONDS G.O. IMPROVEMENT BONDS OF 1998 10/1/1998 12/1/2013 4.19% $1,990,000 $990,000 $1,000,000 TOTALS $2,500,000 $1,435,000 $1,065,000 SERVICE PAYMENTS TO MATURITY G.O. REFUNDING G.O. IMPROVEMENT BONDS OF 2002 BONDS OF 1998 TOTAL BONDS PAYABLE $65,000 $1,000,000 $1,065,000 FUTURE INTEREST PAYABLE $1,722 $195,500 $197,222 TOTALS $66,722 $1,195,500 $1,262,222 PAYMENTS TO MATURITY: 2006 $66,722 $167,813 $234,535 2007 $0 $162,687 $162,687 2008 $0 $157,500 $157,500 2009 $0 $152,250 $152,250 2010 $0 $146,938 $146,938 2011 $0 $141,562 $141,562 2012 $0 $136,125 $136,125 2013 $0 $130,625 $130,625 TOTALS $66,722 $1,195,500 $1,262,222 2007 FINAL BUDGET Page 55 PARK AND RECREATION DEVELOPMENT FUND 2004 2005 2006 2007 2008 2009 FUND ACTUAL ACTUAL ESTIMATED ESTIMATED ESTIMATED ESTIMATED REVENUE 405 - 38010 -000 INTEREST ON INVESTMENTS $8,871 $11,692 $33,870 $28,000 $28,000 $29,000 405 - 38095 -000 LAND DEDICATION FEE $0 $22,952 $1,004,239 $0 $0 $0 TOTAL REVENUE $8,871 $34,644 $1,038,109 $28,000 $28,000 $29,000 EXPENDITURES 405 -44444 -103 PROFESSIONAL SERVICES $0 $0 $4,356 $1,000 $0 $0 405 -44444 -205 OTHER CONTRACTUAL SERVICES $0 $0 $31,030 $10,000 $0 $0 405 -44444 -311 OTHER MATERIAL & SUPPLIES $0 $0 $5,488 $1,000 $0 $0 405 - 44444 -403 RENT OF EQUIPMENT $0 $0 $0 $0 $0 $0 405 - 44444 -430 TAXES -DEED RECORDING $0 $0 $919 $0 $0 $0 405 - 44444 -501 LAND $0 $0 $278,980 $0 $0 $0 405 -44444 -502 BUILDING & STRUCTURES $0 $0 $250,000 $0 $0 $0 405 -44444 -503 FURNITURE & EQUIPMENT $0 $0 $0 $0 $0 $0 405 -44444 -504 OTHER IMPROVEMENTS $0 $0 $0 $0 $0 $0 405 -44444 -800 CONSTRUCTION $0 $0 $208,779 $206,453 $0 $0 TOTAL EXPENDITURES $0 $0 $779,552 $218,453 $0 $0 REVENUE OVER (UNDER) EXPENDITURE: $8,871 $34,644 $258,557 ($190,453) $28,000 $29,000 FUND BALANCE DECEMBER 31 $324,075 $358,719 $617,276 $426,823 $454,823 $483,823 2007 FINAL BUDGET Page 56 BUDGETED PROJECTS AND EQUIPMENT REVOLVING FUND SCHEDULE OF ACTIVITY 2006 2006 2006 2007 2007 2007 2005 PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECT BALANCE REVENUE EXPENSE BALANCE REVENUE EXPENSE BALANCE SEALCOAT /CRACK SEAL $151,351 $30,000 $94,827 $86,524 $146,500 $204,150 $28,874 OUTDOOR STORAGE $35,000 $0 $0 $35,000 $40,000 $50,000 $25,000 MUNICIPAL BUILDING $20,000 $10,000 $0 $30,000 $10,000 $0 $40,000 PARK BUILDING $100,000 $125,000 $0 $225,000 $0 $63,000 $162,000 PARK & TRAIL IMPROVEMENTS $110,074 $8,325 $37,067 $81,332 $25,000 $80,000 $26,332 TRAIL MAINTENANCE $0 $0 $0 $0 $5,000 $0 $5,000 PARK BUILDING MAINTENANCE $0 $0 $0 $0 $5,000 $0 $5,000 COMPREHENSIVE PLAN $28,750 $28,750 $0 $57,500 $0 $50,000 $7,500 COALITION OF UTILITY CITIES $16,000 $0 $0 $16,000 $0 $0 $16,000 TREES (PLANTING) $52,706 $73,827 $0 $126,533 $0 $1,500 $125,033 PUBLIC WORKS VEHICLES: GENERAL FUND $9,356 $6,000 $0 $15, $6,000 $0 $21,356 UTILITY FUND $33,923 $9,900 $0 $43,823 $9,900 $0 $53,723 TOTAL PUBLIC WORKS VEHICLES $43,279 $15,900 $0 $59,179 $15,900 $0 $75,079 POLICE VEHICLES $24,041 $25,000 $22,906 $26,135 $25,000 $30,000 $21,135 CIVIL DEFENSE $5,000 $5,000 $0 $10,000 $0 $0 $10,000 COMPUTERS: GENERAL FUND $51,118 $17,500 $53,000 $15,618 $17,000 $17,100 $15,518 UTILITY FUND $30,000 $15,000 $37,104 $7,896 $2, 500 $0 $10, TOTAL COMPUTERS $81,118 $32,500 $90,104 $23,514 $19,500 $17,100 $25,914 FURNITURE & EQUIPMENT: ADMINISTRATION $365 $0 $0 $365 $1,200 $1,200 $365 BUILDING INSPECTIONS $500 $0 $422 $78 $0 $0 $78 POLICE $1,625 $450 $770 $1,305 $0 $0 $1,305 STREETS $200 $0 $0 $200 $3,800 $4,000 $0 POLICE RADIO EQUIPMENT $29,000 $14,500 $0 $43,500 $7,500 $48,000 $3,000 PARKS MACHINERY & EQUIPMENT $0 $7,000 $7,000 $0 $1,000 $0 $1,000 UNALLOCATED $34,210 $191,012 $13,131 $212,091 $30,000 $25,000 $217,091 TOTALS $733,219 $567,264 $266,227 $1,034,256 $335,400 $573,950 $790,706 The 2007 Projected Revenue consists of transfers from the General Fund and the Utility Fund and interest earned. General Fund Transfer In $268,000 Utility Fund Transfer In $12,400 Reallocate Unallocated Interest to Outdoor Storage $25,000 Interest $30,000 2007 FINAL BUDGET Page 57