Loading...
08 08-09FY Year End Adjustments• • GENERAL FUND - CITY OF OKEECHOBEE RECAPITULATION - REVENUE AND EXPENSES 9/30/2009 FN Beginning Fund Balance REVENUES 97% AD VALOREM 6.7432 OTHER FEES INTERGOVERNMENTAL CHARGES FOR SERVICES FINES, FORFEITURES & PENALTIES USES OF MONEY & PROPERTY OTHER REVENUES TOTAL REVENUES EXPENDITURES LEGISLATIVE EXECUTIVE CITY CLERK FINANCIAL SERVICES LEGAL COUNCIL GENERAL SERVICES LAW ENFORCEMENT FIRE PROTECTION ROAD & STREET FACILITIES 2008 -2009 AMENDED $ 9,142,016 2008/2009 PROPOSED $ 9,142,016 BUDGET TO BUDGET $ 2,161,691 $ 2,131,154 $ (30,537) $ 1,407202 $ 1,472,752 $ 65,550 $ 1,094,824 $ 1,032,297 $ (62,527) $ 475,364 $ 509,637 $ 34,273 $ 30,280 $ 33,049 $ 2,769 $ 71,500 $ 31,657 $ (39,843) $ 196,720 $ 164,991 $ (31,729) $ 5,437,581 $ 5,375,537 $ (31,507) $ 150.239 $ 143,134 $ (7,105) $ 166,346 $ 159,614 $ (6,732) $ 186,953 $ 176,837 $ (10,116) $ 204,339 $ 198,422 $ (5,917) $ 125,432 $ 148,499 $ 23,067 $ 487,075 $ 459,277 $ (27,798) $ 1,816,437 $ 1,780.754 $ (35,683) $ 1,235,345 $ 1,218,875 $ (16,470) $ 1,070,188 $ 1,038,344 $ (31,844) VEHICLE - CAP PROJECTS FUND TRANSFER TOTAL EXPENDITURES $ 5,442,354 $ 5,323,756 $ (118,598) TRANSFERS - IN CDBG Fund (Transfer -In) Impact Fees Capital Project Impr (Transfer -In) Public Facilities Improvement (Transfer -In) TOTAL TRANSFERS - OUT CDGB - Indust Pk Capital Project Building & Improvements Capital Project Vehicle TOTAL FISCAL YEAR ENDING FUND BALANCE $ 1,725 $ 337,929 $ 339,654 $ 6,934,489 $ 118,452 $ 7,052,941 $ 2,428,729 $ (7,632) $ 1,725 $ 337,929 $ 332,022 $ 6,934,489 $ 118,452 $ 7,052,941 $ 2,804,900 EXHIBIT 13 i by 3, 2009 To: From: RE: Date: E,)( �3 MEMORANDUM ?',€uiW4 ri -3 -09 ncek-043 Mayor and Council Members Brian Whitehall, City Administrator India Riedel, Finance Dept. End of Year Budget Adjustments November 3rd, 2009 • Please note, the Summary Page (page 1) reflected an error in the calculation of the difference in Revenues from the previous amended budget to the proposed budget. • Revenues updated based on receipted amounts. Account receivable amounts should increase actual totals; some will come in as late as December. • Actual dollars spent in each department were less than budgeted. General Fund Expenses based on this amended budget is a 2 % decrease, from budget and a 6 % decrease of expenditures from last year. • Amending the proposed adjustments of the Impact Fee and Capital Improvement Funds GENERAL FUND - CITY OF OKEECHOBEE RECAPITULATION - REVENUE AND EXPENSES 9/30/2009 F/Y Beginning Fund Balance REVENUES 97% AD VALOREM 6.7432 OTHER FEES INTERGOVERNMENTAL CHARGES FOR SERVICES FINES, FORFEITURES & PENALTIES USES OF MONEY & PROPERTY OTHER REVENUES TOTAL REVENUES EXPENDITURES LEGISLATIVE EXECUTIVE CITY CLERK FINANCIAL SERVICES LEGAL COUNCIL GENERAL SERVICES LAW ENFORCEMENT FIRE PROTECTION (ROAD & STREET FACILITIES 2008 -2009 AMENDED $ 9,142,016 2008/2009 PROPOSED $ 9,142,016 BUDGET TO BUDGET $ 2,161,691 $ 2,131,154 $ (30,537) $ 1,407,202 $ 1,472,752 $ 65,550 $ 1,094,824 $ 1,032,297 $ (62,527) $ 475,364 $ 509,637 $ 34,273 $ 30,280 $ 33,049 $ 2,769 $ 71,500 $ 31,657 $ (39,843) $ 196,720 $ 164,991 $ (31,729) $ 5,437,581 $ 5,375,537 $ (62,044) $ 150,239 $ 143,134 $ (7,105) $ 166,346 $ 159,614 $ (6,732) $ 186,953 $ 176,837 $ (10,116) $ 204,339 $ 198,422 $ (5,917) $ 125,432 $ 148,499 $ 23,067 $ 487,075 $ 459,277 $ (27,798) $ 1,816,437 $ 1,780,754 $ (35,683) $ 1,235,345 $ 1,218,875 $ (16,470) $ 1,070,188 $ 1,038,344 $ (31,844) VEHICLE - CAP PROJECTS FUND TRANSFER TOTAL EXPENDITURES $ 5,442,354 $ 5,323,756 $ (118,598) TRANSFERS - IN CDBG Fund (Transfer -In) 1 $ (7,632) Impact Fees Capital Project Impr (Transfer -In) 1 $ 1,725 $ 1,725 Public Facilities Improvement (Transfer -In) 1 $ 337,929 $ 337,929 TOTAL $ 339,654 $ 332,022 TRANSFERS - OUT CDGB - Indust Pk Capital Project Improvements Fund 1 $ 7,052,941 TOTAL f $ 7,052,941 FISCAL YEAR ENDING FUND BALANCE �$ 2,428,729 Page 1 $ 7,044,941 $ 7,044,941 $ 2,812,900 Page 1 ` GENERAL FUND - CITY OF OKEECHOBEE RECAPITULATION - REVENUE AND EXPENSES 9/30/2 ©09 FN BEGINNING FUND BALANCE (REVENUES I TAXES: 1311 -1000 97% AD VALOREM ft 6.7432 I TOTAL I (OTHER FEES: 1312 -5100 Fire Insurance Premium 1312 -5200 Casualty Insurance Prem Tax (Police) 1001- 323.10 Franchise - Electric 1323 -7000 Franchise -Solid Waste 1314 -1000 Utility Tax - Electric 1314 -2000 Utility Tax/Franchise Telecommunications 314 -8000 Utility Tax/Propane 319 -0000 Public Service Fee 320 -000 Taxi Cab 321 -0000 Prof & Occupational License 321 -1000 Bus. Prof.. Occu. Reg Fees TOTAL INTERGOVERNMENTAL REVENUES: 335 -1210 335 -1400 335 -1500 335 -1800 312 -6000 335 -2300 338 -2000 SRS Cigarette Tax Mobile Home Licenses Alcoholic Beverage Licenses 1/2 Cent Sales Tax 1 Cent Sales Surtax Firefighters Supplement County Business Licenses TOTAL (CHARGES FOR CURRENT SERVICES 1 1322 -0000 Building & Inspections Fees 329 -0000 Plan Review Fees 322 -1000 Exception & Zoning Fees 341 -2000 Alley /Street Closing Fees 341 -3000 Map Sales 341 -4000 Photocopies 343 -4010 Solid Waste Collection Fees -Resd. TOTAL 2008/2009 AMENDED $ 9,142,016 2008.02009 1 BUDGET PROPOSED+ TO BUDGET $ 2,161,691 $ 2,131,154 1 $ (30,537) $ 2,161,691 $ 2,131,154 1 $ (30,537) $ 59,520 $ 51,613 $ (7,907) $ 121,320 $ 83,891 $ (37,429) $ 402,951 $ 438,822 $ 35,871 $ 67,009 $ 85,130 $ 18,121 $ 360,700 $ 406,557 $ 45,857 $ 312,967 $ 317,871 $ 4,904 $ 27,729 $ 26,612 $ (1,117) $ 13,500 $ 10,900 $ (2,600) $ $ 41,356 $ 51,356 $ 10,000 $ 150 $ (150) $ 1,407,202 $ 1,472,752 $ 65,550 $ 184,916 $ 184,916 $ - $ 28,637 $ 28,174 $ (463) $ 4,850 $ 4.975 $ 125 $ 302,380 $ 278.665 $ (23.715) $ 569.441 $ 527.332 $ (42.109) $ 600 $ 600 $ $ 4,000 $ 7,635 $ 3.635 $ 1,094,824 $ 1,032,297 $ (62,527) $ 89,411 $ 95,861 $ 6,450 $ 20,253 $ 17.539 $ (2.714) $ 15,500 $ 16.141 $ 641 $ 500 $ 500 $ $ 100 $ 20 $ (80) $ 50 $ 26 $ (24) $ 349,550 $ 379,550 $ 30,000 $ 475,364 $ 509,637 $ 34,273 1 IGENERAL FUND - CITY OF OKEECHOBEE RECAPITULATION - REVENUE AND EXPENSES 913012009 FINES, FORFEITURES & PENALTIES: 351 -1000 351 -2000 351 -3000 351 -4000 351 -5000 354 -1000 Court Fines Radio Comm. Fee Law Enforcement Education Investigation Cost Reimbursement Unclaimed Evidence Ordinance Violation Fines TOTAL USES OF MONEY & PROPERTY: 361 -1000 361.3 364 -1000 Interest Earnings Investment Earninqs Surplus City Property TOTAL (OTHER REVENUES: 334 -2000 334 -3000 343 -9000 343 -9100 343 -9200 369 -1000 369 -3000 369 -3000 Public Safety Grant Special Purpose Grant DOT Hwy Maint.Landscape /Mowinq DOT Master Traffic Signals Maint. DOT Maint. Lights & Lights Contract Miscellaneous Code Enforcement Fine Police Accident Reports TOTAL OPERATING TRANSFER -IN: 381 -1000 Capital Proiect Improvements (Transfer -In) CDBG Fund (Transfer -In) Public Facilities Improvement (Transfer -In) TOTAL OPERATING TRANSFERS - OUT CDGB - Indust Pk Capital Project Building & Improvements Capital Project Vehicles TRANSFERS OUT TOTAL REVENUE & OTHER FUNDING SOURCES 2008/2009 1 2008/2009 1 BUDGET AMENDED PROPOSED +TO BUDGET $ 22,680 $ 22,680 $ - $ 5,000 $ 6,271 $ 1.271 $ 1,500 $ 2,692 $ 1,192 $ 1,000 $ 1,166 $ 166 $ - $ - $ $ 100 $ 240 $ 140 $ 30,280 $ 33,049 $ 2,769 $ 71,500 $ 71,038 $ (462) $ (39,381) $ (39.381) $ 71,500 $ 31,657 $ (39,843) $ 21,057 $ 21,057 $ - $ 49,214 $ 44,375 $ (4,839) $ 21,003 $ 21,003 $ - $ 6,990 $ 7,416 $ 426 $ 16,817 $ 18,292 $ 1,475 $ 79,714 $ 50,522 $ (29.192) $ 1,425 $ 1,525 $ 100 $ 500 $ 801 $ 301 $ 196,720 $ 164,991 $ (31,729) $ 1,725 $ - $ (1,725) $ $ $ 337,929 $ 306,067 $ (31,862) $ 339,654 $ 306,067 $ (33,587) $ 6,934,489 $ 118,452 $ 7,052,941 TOTAL PROPOSED REVENUES AND BALANCES $ 6,934,489 $ 118,452 $ 7,052,941 1 !Worksheet #: 11 I Edited Date: 19/30/2009 I Edited By: I India Riedel EPT{IN 6ENERALFUND 'PERSONNEL COST: 1100 1200 1201 1202 1300 1400 1401 1402 1403 1501 1510 1520 1540 2100 2200 2300 2400 2500 EXECUTIVE SALARIES REGULAR SALARIES HOLIDAY PAY OFF HOLIDAY PAY OTHER SALARY OVERTIME OVERTIME PAY /ANNUAL & SICK DISPATCHER OVERTIME OFFICERS OVERTIME PAY AUXILIARY & VOLUNTEER PAY LONGEVITY /SERVICE INCENTIVE OFFICERS LONGEVITY /SERVICE CAREER EDUCATION FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION UNEMPLOYMENT TAXES TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3100 3102 3103 3200 3300 3400 3401 4000 4100 4300 4400 4500 4600 4609 4700 4900 4901 4902 4905 4903 4909 5100 5101 5102 5200 5201 5202 5203 5204 5204 5205 5300 5400 6300 6400 6401 7000 7100 8100 8200 8201 8202 PROFESSIONAL SERVICES PROF SERVICES (PHYS FOR SCBA) MUNICIPAL CODE & WELLNESS PR ACCOUNTING & AUDIT LEGAL COST OTHER CONTRACT SERVICES GARBAGE COLLECTION FEE TRAVEL AND PER DIEM COMM. & FREIGHT UTILITIES RENTALS AND LEASES INSURANCE R&M VEHICLES R&M EQUIPMENT PRINTING ADVERTISING /OTHER CHARGES EDUCATION - RESTRICTED EDUCATION - NON - RESTRICTED TRAINING & MATERIALS CODE ENFORCEMENT MISCELLANEOUS OFFICE SUPPLIES DETECTIVE SUPPLIES INVESTIGATION FEES OPERATING SUPPLY FUEL AND OIL OPERATING SUPPLIES (TIRES) UNIFORMS/PATCHES POSTAGE & SUPPLIES DUMPING FEES MOSQUITO CONTROL ROAD MATERIALS/SUPPLIES BOOKS, PUBLICATIONS, ETC IMPROVEMENTS EQUIPMENT (5750 OR MORE) MICRO FILM EQUIPMENT PRINCIPAL -CAD SYSTEM INTEREST -CAD SYSTEM SHARED SERVICES AID TO PRIVATE ORGANIZATIONS INTERLOCAL PART. w/IRCC ECONOMIC DEV GRANT TOTAL SUPPLIES AND OTHER SERVICES 2008/2009 1 20082009 1 AMENDED I PROPOSED 1 460.082 1.865,169 21.591 25.068 78,453 36.192 44,824 9.902 64,000 12.420 1.500 250 12.600 200.586 361,323 329.945 81,454 0 459.959 1,853,204 21,555 25,065 72.667 29,075 45,323 6,977 55,666 11,968 1,500 250 12,598 197,080 371,311 327.402 80,361 0 3,605,3591 3,571,961 295,158 4,000 7,600 31,100 75,000 159,022 342,664 31,050 51.906 65,231 16,715 130.756 30.010 101.140 2,500 20,000 27,966 7,500 3,000 14,000 1 1,775 14,716 3,500 2,000 40,332 80,590 11,000 23,275 7,000 1,000 0 10,400 11,800 49,124 57,691 0 35,312 9,074 8,000 20,000 9,088 15,000 1,836,995 'TOTAL COST: 5,442,3541 257,164 3.645 7.774 28,800 100,445 146,380 346,598 21,868 45.174 60,610 16,790 133,645 23,726 54,028 2,296 13,600 17,238 4,161 2,032 12,858 7,498 11,681 3,201 1,606 40,222 86,388 9,884 20,688 6,406 859 0 14,503 9,999 35,469 108,085 0 35,312 9.074 8,000 20,000 9,088 15,000 1,751,795 5,323,7561 Page 4 BUDGET TO BUDGET -1231 - 11,9651 -361 -31 - 5,7861 - 7,1171 4991 - 2,9251 -8,334 -452 0 0 -2 -3.506 9,988 -2,543 -1.093 0 - 33,3981 - 37,994 -355 174 -2,300 25,445 - 12,642 3,934 -9,182 -6,732 -4,621 75 2,889 -6,284 - 47,112 -204 -6,400 - 10,728 -3,339 -968 -1,142 -4,277 -3,035 -299 -394 -110 5,798 -1,116 -2,587 -594 -141 0 4,103 -1,801 - 13,655 50,394 0 0 0 0 0 0 1 - 85,2001 - 118,5981 4 GENERAL FUND EXPENSE LINE ITEM DETAIL Worksheet #: 11 Edited Date: 19/30/2009 Edited By: !India Riedel PERSONNEL COST: 1100 1510 2100 2200 2300 2400 EXECUTIVE SALARIES LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3400 4000 4100 4500 4901 4909 5400 8100 8200 8201 8202 OTHER CONTRACT SERVICES TRAVEL AND PER DIEM COMM. & FREIGHT INSURANCE EDUCATION MISCELLANEOUS BOOKS, PUBLICATIONS, ETC SHARED SERVICES AID TO PRIVATE ORGANIZATIONS INTERLOCAL PART. w/IRCC ECONOMIC DEV. GRANT TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST 1 2008/2009 AMENDED 36100 750 2762 3452 16945 207 60216 2008/2009 PROPOSED 36150 750 2796 3654 16535 207 60092 30,000 25,007 2400 1345 250 250 2585 2598 500 150 1000 495 1200 1109 8000 8000 20000 20000 9088 9088 15000 15000 90,023 83,042 150,239 143,134 Page 5 GENERAL FUND EXPENSE LINE ITEM DETAIL 1 Worksheet #: 11 Edited Date: 19/30/2009 Edited By: 'India Riedel 51i<EXECl1TIVExW PERSONNEL COST: 1100 1200 1510 2100 2200 2300 2400 EXECUTIVE SALARIES REGULAR SALARIES LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 4000 4100 4500 4600 4609 4901 4909 5100 5200 5201 5400 6400 TRAVEL AND PER DIEM COMM. & FREIGHT INSURANCE R &M VEHICLES R &M EQUIPMENT EDUCATION MISCELLANEOUS OFFICE SUPPLIES OPERATING SUPPLY FUEL AND OIL BOOKS, PUBLICATIONS, ETC EQUIPMENT ($750 OR MORE) TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST: 2008/2009 AMENDED Page 6 2008/2009 PROPOSED 79,462 79,335 33,423 33,672 0 0 8,674 8,806 12,649 12,649 10,500 10,429 557 557 145,265 145,448 2,500 1,462 4,580 3,303 3,285 3,303 400 400 1,700 1,350 1,500 250 500 70 1,116 756 1,500 802 1,500 1,109 1,500 1,361 1,000 21,081 14,166 166,346 159,614 Page 6 GENERAL FUND EXPENSE LINE ITEM DETAIL Worksheet #: 11 Edited Date: 19/30/2009 Edited By: 'India Riedel 2512 MCITY'.CLERKs PERSONNEL COST: 1100 1200 1300 1510 2100 2200 2300 2400 EXECUTIVE SALARIES REGULAR SALARIES OTHER SALARIES LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3103 3400 4000 4100 4500 4609 4900 4901 4909 5100 5200 5400 6400 6401 MUNICIPAL CODE OTHER CONTRACTUAL SERVICES TRAVEL AND PER DIEM COMM. & FREIGHT INSURANCE R &M EQUIPMENT ADVERTISING /OTHER CHARGES EDUCATION MISCELLANEOUS/ELECTION OFFICE SUPPLIES OPERATING SUPPLIES BOOKS, PUBLICATIONS, ETC EQUIPMENT ($750 OR MORE) MICRO FILM EQUIPMENT TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST: 2008/2009 2008/2009 AMENDED1PROPOSED 52,305 52,305 32,440 33,148 13,695 13,067 250 250 7,536 7,483 9,509 9,509 11,200 10,995 398 398 127,333 127,155 3,500 3,894 9,000 8,800 4,000 2,983 2,850 2,582 3,925 3,945 3,570 4,159 20,000 13,600 1,500 1,100 5,775 4,997 1,500 1,263 0 315 2,000 2,044 2,000 0 0 0 59,620 49,682 186,953 1 176,837 Page 7 Page 7 IGENERAL FUND EXPENSE LINE ITEM DETAIL I Worksheet #: 11 I Edited Date: 19/30/2009 IEdited By: lindia Riedel 1`513'INA1!1 PERSONNEL COST: 1100 1200 1510 2100 2200 2300 2400 2500 EXECUTIVE SALARIES REGULAR SALARIES LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION UNEMPLOYMENT TAXES TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3200 3400 4000 4100 4500 4609 4901 4909 5100 5200 5400 6400 ACCOUNTING & AUDIT OTHER CONTRACTUAL SERVICES TRAVEL AND PER DIEM COMM. & FREIGHT INSURANCE R&M EQUIPMENT EDUCATION MISCELLANEOUS OFFICE SUPPLIES OPERATING SUPPLY BOOKS, PUBLICATIONS, ETC EQUIPMENT ($750 OR MORE) TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST: 2008/2009 I 2008/2009 AMENDEDt PROPOSED 37,729 37,729 64,067 64,067 0 0 7,841 7,512 11,345 11,345 16,300 15,926 587 587 137,869 137,166 31,100 28,800 250 150 1,750 1,960 3,180 2,769 5,190 5,217 9,950 8,507 1,400 1,381 250 10 2,400 1,811 9,300 8,981 700 625 1,000 1,045 66,470 61,256 204,339 Page 8 198,422 Page 8 GENERAL FUND EXPENSE LINE ITEM DETAIL' 11 1 19/30/2009 1 'India Riedel 1 'Worksheet #: 1 Edited Date: 'Edited By: PERSONNEL COST: ALL SERVICES & SUPPLIES: 2300 3100 3300 4000 4100 4609 4901 5100 5400 HEALTH INSURANCE PROFESSIONAL SERVICES LEGAL COST TRAVEL AND PER DIEM COMM. AND FREIGHT SERVICES R &M EQUIPMENT EDUCATION OFFICE SUPPLIES MEMBERSHIP & SUBSCRIPTIONS TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST: 2008/2009 Revised Page 9 2008/2009 PROPOSED 4,900 4,885 41,412 3,9,595 75,000 100,445 700 651 1,500 1,264 270 251 750 750 400 346 500 312 125,432 148,499 125,432 148,499 Page 9 'GENERAL FUND EXPENSE LINE ITEM DETAIL 1 1 Worksheet #: 11 (Edited Date: 19/30/2009 (Edited By: !India Riedel sNERAL s �:,SERVICES-. ' PERSONNEL COST: 1200 1300 1400 1510 2100 2200 2300 2400 REGULAR SALARIES OTHER SALARY OVERTIME LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3100 3400 4000 4100 4300 4400 4500 4600 4609 4901 4909 5100 5200 5201 5204 5400 6400 PROFESSIONAL SERVICES OTHER CONTRACTUAL SERVICES TRAVEL AND PER DIEM COMM. & FREIGHT UTILITIES RENTALS AND LEASES INSURANCE R &M VEHICLES R &M EQUIPMENT EDUCATION MISCELLANEOUS OFFICE SUPPLIES OPERATING SUPPLY FUEL AND OIL POSTAGE & SUPPLIES BOOKS, PUBLICATIONS, ETC EQUIPMENT ($750 OR MORE) TOTAL SUPPLIES AND OTHER SERVICES TOTAL COST: 2008/2009 AMENDED 33,846 15,758 0 0 3,775 3,795 5,100 325 62,599 2008/2009 PROPOSED 33,846 14,806 0 0 3,726 3,795 5,064 325 61,562 208,125 182,368 111,772 1 10,660 5,000 3,585 3,380 2,895 12,300 11,865 4,764 5,974 15,280 15,353 500 108 50,000 2,500 500 250 500 250 2,300 1,945 1,000 2,290 655 166 7,000 6,406 400 100 1,000 51,000 424,476 397,715 487,075 459,277 Page 10 Page 10 A GENERAL FUND EXPENSE LINE ITEM DETAIL BY DEPARTMENT Worksheet #: 11 Edited Date: 19/30/2009 Edited By: llndia Riedel 62i it l ifigNFORDENIENT ial ngf PERSONNEL COST: 1100 1200 1201 1202 1300 1400 1403 1501 1510 1520 1530 1540 2100 2200 2300 2400 EXECUTIVE SALARIES REGULAR SALARIES HOLIDAY PAY OFFICERS HOLIDAY PAY OTHER SALARY OVERTIME OFFICERS OVERTIME PAY AUXILIARY PAY LONGEVITY /SERVICE INCENTIVE OFFICERS LONGEVITY /SERVICE INCENTIVE CAREER EDUCATION FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3100 4000 4100 4300 4400 4500 4600 4609 4700 4901 4902 4909 5100 5101 5102 5200 5201 5202 5203 5400 6400 8300 7000 7100 PROFESSIONAL SERVICES TRAVEL AND PER DIEM COMM. & FREIGHT UTILITIES RENTALS AND LEASES INSURANCE R&M VEHICLES R&M EQUIPMENT PRINTING EDUCATION - RESTRICTED EDUCATION - NON - RESTRICTED MISCELLANEOUS OFFICE SUPPLIES DETECTIVE SUPPLIES INVESTIGATION FEES OPERATING SUPPLY FUEL AND OIL OPERATING SUPPLIES (TIRES) UNIFORMS/PATCHES BOOKS, PUBLICATIONS, ETC EQUIPMENT (5750 OR MORE) PUBLIC SERVICE GRANT Principal -CAD System Interest -CAD System TOTAL SUPPLIES AND OTHER SERVICES 2008/2009 AMENDED 2008/2009 PROPOSED 63,836 63,935 851,235 840,235 O 400 25,068 25,065 24,000 17,442 9,300 6,409 64,000 55.666 L200 1,200 O 0 250 2501 O 01 12,000 11,9981 80,994 79,651 203,542 203,542 143,300 142,997 28,900 28,307 1,507,625 1,477,097 21,421 18,135 7,200 6,839 20,266 19,121 16,726 15,788 6,951 6,7541 37,207 39,945 8,110 5,703 8.000 9,205 2.000 1,7961 5,816 2,540 6,000 2,880 1,500 546 5,000 3,927 3,500 3,201 2.000 1,606 15,441 15,400 49,513 53,932 5,000 4,582 10,275 8,769 1,500 1,255 31,000 37,347 35,312 35,3121 9,074 9,0741 308,812 303,657 TOTAL COST: 1,816,437 1,780,754 Page 11 GENERAL FUND EXPENSE LINE ITEM DETAIL BY DEPARTMENT 'Worksheet #: 11 'Edited Date: 19/30/2009 'Edited By: Ilndia Riedel 152V,FIRE PROTE ION = _ ." .. r PERSONNEL COST: 1100 1200 1201 1300 1400 1401 1402 1501 1510 1540 2100 2200 2300 2400 EXECUTIVE SALARIES REGULAR SALARIES HOLIDAY PAY OTHER SALARY OVERTIME OVERTIME PAY /ANNUAL & SICK DISPATCHER OVERTIME VOLUNTEER PAY LONGEVITY /SERVICE INCENTIVE CAREER EDUCATION FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: 'SUPPLIES AND OTHER SERVICES: 3100 PROFESSIONAL SERVICES 3102 PROF SERV (PHYS FOR SCBA) 3103 WELLNESS PROGRAM 4000 TRAVEL AND PER DIEM 4100 COMM. & FREIGHT 4300 UTILITIES 4400 RENTALS AND LEASES 4500 INSURANCE 4600 R &M VEHICLES 4609 R&M EQUIPMENT 4700 PRINTING 4901 EDUCATION 4902 PUBLIC EDUCATION & FIRE PREV. 4903 CODE ENFORCEMENT 4905 TRAINING & MATERIALS 4909 MISCELLANEOUS 5100 OFFICE SUPPLIES 5200 OPERATING SUPPLY 5201 FUEL AND OIL 5202 OPERATING SUPPLIES (TIRES) 5203 UNIFORMS/PATCHES 5400 BOOKS, PUBLICATIONS, ETC 6400 EQUIPMENT ($750 OR MORE) TOTAL SUPII Health Insnrance Increase by 15% TOTAL COST: 2008/2009 Revised 60,760 595,901 21,591 25,000 21,892 44,824 9,902 11,220 500 600 59,015 72,794 71,100 31,550 1,026,649 9,200 4,000 4,100 6,000 9,700 14,680 5,000 31,184 17,000 16,100 500 15,000 1,500 14,000 3,000 750 1,500 11,091 9,900 3,000 7,500 3,500 20,491 208,696 1,235,345 Page 12 2008/2009 I PROPOSED 1 60,6331 594,419 21,155 27,352 19,617 45,323 6,977 10,768 500 600 58,586 82,580 70,886 31,050 1,030,446 8.966 3,645 3,880 2,497 8,725 13,265 3,599 31,184 14,947 15,576 500 10.4821 1,281 12,858 2,032 998 1,377 10.8421 11,5321 2,547 7,249 2,880 17,567 188,429 1,218,875 Page 12 1 (GENERAL FUND EXPENSE LINE ITEM DETAIL IWorksheet #: 11 (Edited Date: 19/30/2009 I Edited Bv: !India Riedel I5411BOAD:AM ESDP,AGi81TtES s PERSONNEL COST: 1100 1200 1400 1510 2100 2200 2300 2400 EXECUTIVE SALARIES REGULAR SALARIES OVERTIME LONGEVITY /SERVICE INCENTIVE FICA RETIREMENT LIFE AND HEALTH INSURANCE WORKERS COMPENSATION TOTAL PERSONNEL COSTS: SUPPLIES AND OTHER SERVICES: 3100 3400 3401 4000 4100 4300 4400 4500 4600 4609 4901 4909 5100 5200 5201 5202 5203 5204 5205 5300 5400 6300 6400 PROFESSIONAL SERVICES OTHER CONTRACTUAL SERVICES GARBAGE COLLECTION FEE TRAVEL AND PER DIEM COMM. & FREIGHT UTILITIES RENTALS AND LEASES INSURANCE R &M VEHICLES R &M BUILDING & EQUIPMENT EDUCATION MISCELLANEOUS OFFICE SUPPLIES OPERATING SUPPLY FUEL AND OIL OPERATING SUPPLIES (TIRES) UNIFORMS DUMPING FEES MOSQUITO SPRAYING ROAD MATERIALS /SUPPLIES BOOKS, PUBLICATIONS, ETC IMPROVEMENTS EQUIPMENT ($750 OR MORE) TOTAL SUPPLIES AND OTHER SERVICES: TOTAL COST: 2008/2009 Revised 129,890 254.257 5,000 0 29,989 44,237 50,600 18,930 532,903 2008/2009 PROPOSED 129,872 253,817 3,049 0 28,520 44,237 49,685 18,930 528,110 15,000 8,100 8,000 1,763 342,664 346,598 1.500 546 6,200 4,265 21.525 19,692 0 463 32,100 32,100 4,000 2,568 11,550 12,480 1,000 335 1,500 132 500 256 2,000 1,592 19,022 19,649 3,000 2,755 5,500 4,670 1,000 859 0 0 10,400 14,503 500 313 49,124 35,469 1,200 1,126 537,285 510,234 1,070,188 1,038,3441 Page 13 Page 13 l 1 3 9/30/2 1.1PUBLIC FACILITIES FUND RECAPITULATION - REVENUE AND EXPENSES F/Y BEGINNING FUND BALANCE REVENUES 301 - 313.4100 301- 313.4200 301 - 335.1220 301- 312.3000 301- 335.4100 301- 361.1000 301 - 361.3000 301 - 369.1000 LOCAL OPTION GAS TAX LOCAL ALTER, FUEL USER FEE SRS EIGHT CENT MOTOR FUEL NINETH CENT FUEL TAX MOTOR FUEL TAX REBATE INTEREST EARNINGS INVESTMENT EARNINGS MISCELLANEOUS EXPENDITURES 301 - 549.3100 301 -549 -3400 301 -549 -4300 301 -549 -4609 301 -549 -5300 301 -549 -6300 301 - 549.6302 301 - 549.6400 301 - 549.9100 TOTAL REVENUE PUBLIC FAC.- PROFESSIONAL SER. PUBLIC FAC. CONTRACTUAL SERVICES PUBLIC FAC. UTILITIES REPAIR & MAINTENANCE PUBLIC FAC. ROAD & MATERIALS PUBLIC FAC. IMPROVEMENTS PUBLIC FAC. BEAUTIFICATION PUBLIC FAC. MACHINERY & EQUIP TOTAL EXPENDITURES REVENUES LESS EXPENSES TRANSFER OUT TO GENERAL FUND F/Y ENDING FUND BALANCE Cost changes and Proposed Protects Included In above cost Page 14 2008/2009 AMENDED $ 782,413 2008/2009 PROPOSED $ 782,413 349,478 $ 131,151 $ 62,335 $ 56,802 $ 1,650 $ 19,500 $ - $ 620,916 $ 2,500 $ 69,630 $ 92,742 $ 26,096 $ 333,955 $ 10,000 $ 200,000 $ 734,923 $ 337,929 $ 444,484 339,229 143,317 72,851 61,314 2,310 3,800 (6,907) 615,914 1,649 66,935 82,911 2,250 27,306 95,531 7,676 284,258 306,067 $ 476,346 Page 14 J 1 L CDBG FUND - CITY OF OKEECHOBEE RECAPITULATION - REVENUE AND EXPENSES F/Y BEGINNING FUND BALANCE REVENUES 302 - 331.3200 302 - 331.3900 302 - 361.1000 302 - 381.0000 CDBG GRANT (STATE) CDBG GRANT E -10 Interest Earnings TRANSFER IN - GENERAL FUND RESERVES TOTAL REVENUES EXPENDITURES 302 - 2552.3100 302 - 2552.4609 302 - 2552.4909 302 - 2552.6300 302 - 2652 -3100 302 - 2652.3400 302 - 2652.6302 302 - 2652.6304 302 - 2652.6306 PROFESSIONAL SERVICES COMMERCIAL BUILDING REHAB MISCELLANEOUS SIDEWALKS & PEDESTRIAN MALLS PROFESSIONAL SERVICES E -10 ENGINEERING SERVICES E -10 SEWER LINES CDBG E -10 WATER FACILITIES E -10 STREET IMPROVEMENTS TOTAL EXPENDITURES REVENUES LESS EXPENSES TRANSFER OUT TO GENERAL FUND F/Y ENDING FUND BALANCE Page 15 $ 2008/2009 BUDGET 6,574 2008/2009 PROPOSED $ 6,574 6,574 $ 7,007 7,007 7,007 7,007 6,574 A s 4 IMPACT FEE CAPITAL PROJ IMPROVEMENTS RECAPITULATION - REVENUE AND EXPENSES F/Y BEGINNING FUND BALANCE REVENUES 303 - 341.0000 303 - 361.1000 303 - 363.2201 303 - 363.2202 303 - 363.2400 ADMINISTRATION COST FOR IMPACT FEES INTEREST EARNINGS LAW ENFORCEMENT IMPACT FEES FIRE PROTECTION IMPACT FEES TRANSPORTATION IMPACT FEES TOTAL REVENUE EXPENDITURES 303 -0521 -6400 303 - 0522 -6400 303 - 0541 -6300 303 - 0541 -6400 303 -549 -6400 303 - 381.000 2008/2009 REVISED $ 718,600 LAW ENF. CAPITaL PROJECTS S FIRE PROTECTION CAPITAL PROJECTS $ TRANSPORTATION IMPROVEMENTS TRANSPORTATION CAPITAL PROJECTS OTHER CAPITAL IMPROVEMENT PROJECT /COST TOTAL EXPENDITURES $ TRANSFER OUT TO GENERAL FUND TRANSFER OUT TO CAPITAL IMPROVEMENT TOTAL TRANSFER OUT DUE TO CAPITAL ASSETS DUE FROM IMPACT FEE REVENUES F/Y ENDING FUND BALANCE 2008/2009 PROPOSED $ 49,194 600 $ 1,125 $ 750 $ 1,250 $ 2,300 $ 6,025 $ 74,000 74,000 1,725 1,725 55,100 55,100 $ 648,900 1,529 435 1,745 2,721 3,470 9,900 22,412 $ 22,412 $ 1,725 $ 1,725 $ 34,957 J h * 1`9/30 0 CAPITAL PROJECTS IMPROVEMENT FUND RECAPITULATION - REVENUE AND EXPENSES F/Y BEGINNING FUND BALANCE 1 REVENUES 304 - 383.0000 304 - 364.1000 304 - 361.1000 CAPITOL LEASE PROCEEDS DISPOSITION OF FIXED ASSETS INTEREST EARNINGS TOTAL REVENUE EXPENDITURES 304 -512 -6400 304 -513 -6400 304 -519 -6400 304 - 521 -6400 304 -522 -6400 304 - 541 -6400 304 -549 -6400 304 - 584.4909 304 - 584.6400 304 - 2512 -6400 304 - 584.7100 304 - 584.7200 ADMINISTRATION CAPITAL FINANCE CAPITAL GENERAL SERVICES CAPITAL LAW ENFORCEMENT CAPITAL FIRE PROTECTION CAPITAL PUBLIC WORKS CAPITAL OTHER CAPITAL PROJECTS MISCELLANEOUS CAPITAL LEASE/PURCHASE CLERK CAPITAL PRINCIPAL INTEREST TOTAL EXPENDITURES Transfer In FROM GENERAL FUNDS F/Y ENDING FUND BALANCE TOTAL TRANSFER IN Page 17 2008/2009 AMENDED 9,220 2008/2009 PROPOSED $ 669,406 457,193 $ 456,000 $ 913,193 $ 457,193 429,000 2,000 888,193 $ $ $ $ $ - $ $ 63,405 $ $ - $ 71,092 $ - $ $ 69,500 $ 50,200 $ - $ $ 510,231 $ 510,231 $ 507,014 $ 507,014 $ 20,774 $ 22,549 $ 1,170,924 $ 1,161,086 $ 7,052,941 $ 7,044,941 $ 7,052,941 $ 7,044,941 1 $ 6,804,430 $ 7,441,454 19/30/ 0.09 LAW ENFORCEMENT SPECIAL FUND RECAPITULATION - REVENUE AND EXPENSES F/Y BEGINNING FUND BALANCE REVENUES 601 - 351.1000 601- 351.2000 601- 361.1000 601- 369 -1000 ADMINISTRATIVE FEES CONFISCATED PROPERTY INTEREST EARNINGS Misc. EXPENDITURES 601 - 529.4909 601 - 549.6300 601 - 549.6400 TOTAL REVENUE LAW ENF. SPECIAL MISC. LAW ENF. SPECIAL IMPROVEMENT LAW ENF. SPECIAL MACH & EQUIP TOTAL EXPENDITURES F/Y ENDING BALANCES 2008/2009 AMENDED $ 3,127 $ $ 10 $ 10 $ 3,137 Page 18 2008 -2009 PROPOSED $ 3,127 $ 10 $ 10 $ 3,137