Loading...
HomeMy WebLinkAboutOrdinance No. 15-2010ORDINANCE NO. 15 -2010 AN ORDINANCE OF THE CITY OF CAPE CANAVERAL, BREVARD COUNTY, FLORIDA; ADOPTING THE AMENDMENTS TO THE ANNUAL GENERAL FUND, SEWER ENTERPRISE FUND, STORMWATER UTILITY FUND, SPECIAL REVENUE FUNDS, AND EXPENDABLE TRUST FUNDS BUDGETS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2009, AND ENDING SEPTEMBER 30, 2010; PROVIDING FOR AN EFFECTIVE DATE. BE IT RESOLVED by the City Council of the City of Cape Canaveral, Brevard County, Florida, as follows: SECTION 1. The Amendments to the Annual General Fund, Sewer Enterprise Fund, Stormwater Utility Fund, Special Revenue Funds, and Expendable Trust Funds Budgets which are attached hereto and by reference made a part hereof, of the City of Cape Canaveral, Florida for the fiscal year beginning October 1, 2009, and ending September 30, 2010, are hereby approved and adopted. SECTION 2. This Ordinance shall take effect immediately upon its adoption. ADOPTED BY the City Council of the City of Cape Canaveral, Florida, this 4th day November, 2010. Rocky Randels, Mayor FOR AGAINST Bob Hoog Second Buzz Petsos M otion Rocky Randels X APP V AS TO FORM: Anthony A. ta79anese, City Attorney Roberts, Shannon x Betty Walsh x First Reading: 10/19/2010 Second Reading: 11/04/2010 ATTEST'.- Angel -Apperson, Ci -/ lerk . . . a Rocky Randels, Mayor FOR AGAINST Bob Hoog Second Buzz Petsos M otion Rocky Randels X APP V AS TO FORM: Anthony A. ta79anese, City Attorney Roberts, Shannon x Betty Walsh x First Reading: 10/19/2010 Second Reading: 11/04/2010 ORD. NO. 15 -2010 Adopted I1 -04 -2010 Attachment CITY OF CAPE CANAVERAL FOURTH QUARTER BUDGET TRANSFERS ENDED 9/30/2010 FY 2009/2010 MEMO To: Honorable Mayor and Members of City Council via: David L. Greene, City Manager From: Andrea Bowers, City Treasurer /P Date: October 6, 2010 Re: Fourth Quarter Transfers for Fiscal Year 2009/10 ORD. NO. 15 -2010 Adopted 11 -04 -2010 Attachment The Fiscal Year 2009/2010 is now completed. The following pages represent a summary of the City's financial activities during the year and how they compare to the approved budget. The final numbers for the revenues and expenditures have, in some cases, been projected to provide timely reporting, and are included in the Budget vs. Actual spreadsheets, to give staff and Council a general idea of the final balances. By law, each department level budget must be maintained within the budgeted amounts. To that end, three departments require additional funding. These are the Administrative Department, the Community Development Department and the Non - Departmental accounts in the General Fund. Additional Ad Valorem revenue is recognized to provide the funding necessary for the department level adjustments. Revenues are collected in line with budget projections. When Cash Forward and the Stimulus Funds (pushed forward to be used in FY2010/11) are removed from the budgeted revenues, the total collected stands at approximately 103% of projections. The Administrative budget requires funding to cover the additional expenditures incurred with the departure of the previous City Manager and related transition expenses. 1 The Community Development Department requires additional funding for unplanned legal services, incurred due to the numerous ordinance revisions and Code Enforcement activity. Professional Services are also increased to handle the Visioning process, the Comp Plan changes and EAR -based amendments. Although approved by Council, the renovation of the Annex for the Sheriffs Department was not a budgeted expenditure. The funding for this project has been set aside in Reserve over the years in preparation. At this time the funds will be budgeted to cover the expenditures made this Fiscal Year, with the balance of the Project included in the first budget transfer for the 201 0111 Fiscal Year. Following is a projected accounting for the Fiscal Year ending September 30, 2010. Only those items representing a significant change in fiscal policy have been offered for adjustment. It is not the intent of these amendments to adjust each account to reflect actual activity. Most of these items have been previously approved, either through a previous quarter's transfer or during a Council Meeting, and the combined adjustment is made final using the ordinance. As the last Budget Transfer of the Fiscal Year 2009110, Staff requests that Ordinance #15 -2010, recognizing the budget amendments made, be approved. As always, please contact me 868 -1234, with any questions, concerns or suggestions. Attachments: Ordinance #15 -2010 Budget Transfer Summary for Fiscal Year 2009/2010 4th Quarter Budget vs. Actual ORD. NO. 15 -2010 Adopted 11 -04-20 10 Attachment 2 ORD. NO. 152010 City of Cape Canaveral Adopted 11 -04 -2010 Budget Transfer Summary for FY 2009/2010 Attachment 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2010 Adjusted Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance 001 -000- 300 - 300100 001 -000- 300 - 311115 001 - 000 - 300- 311125 001- 000 - 312 - 312410 001 - 000 -313 - 313100 001 -000- 313 - 313700 001 - 000 -314 - 314100 001 - 000 -315 - 315100 001 -000- 329- 329200 001 - 000- 331 - 331300 001- 000 - 333 - 343455 001- 000 -347- 347293 001 - 000 - 347 - 347490 001- 000 - 361- 361100 001 - 000 -366- 366220 001 -000- 369- 369100 001 -000- 369 - 369300 001 -000- 389 - 389401 Revenues Cash Forward Ad Valorem - Police - Deliquent Ad Valorem - Fire - Deliquent Local Option Gas Tax FPL Franchise Fees Waste Pro Franchise Fees FPL Utility Tax Communication Services Tax Fire Inspection Fees Army Corp of Engineers Waste Pro Billing Reimbursement Tournament Income Recreation Special Events Interest from Investments Contributions - Private Sources Miscellaneous Income Refund of Prior Year Expense Recreation Sponsorships Amended General Fund Revenue for Quarter 309,821 1,152,502 22,695 22,170 318,704 706,000 30,000 630,000 567,660 10,000 113,000 9,300 100 120,000 1,500 1,000 1,000 (41,700) Legislature ................ _ ._.. _..._- .._.__. (30,000) (22,000) 5 45,000 Promotional Activities 8,350 10,000 7,500 12,500 001 -001- 511 - 520000 (113,000) 11,760 2,600 22,600 238,950 1,436,317 40,000 40,000 40,000 40,000 277,004 676,000 8,000 675,000 586,010 30,000 20,000 2,846 2,900 2,150 4,500 _.... Amended Legislative Expenditures 29,500 11,760 11,900 22,700 140,000 4,346 3,900 3,150 4,500 Legislature ................ _ ._.. _..._- .._.__. 001 - 001 -511 -33000 Professional Services 5 001 - 001 - 511 - 480000 Promotional Activities 2,000 001 - 001 - 511 - 480100 Web Site Maintenance 600 500 001 -001- 511 - 520000 Operating Supplies 3,300 (500) Amended Legislative Expenditures 29,500 11,760 11,900 22,700 140,000 4,346 3,900 3,150 4,500 ORD. NO. 15 -2010 City of Cape Canaveral Adopted 11 -04-20 10 Budget Transfer Summary for FY 2009/2010 Attachment 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2010 Adjusted Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance Administration 001 -002- 513 - 110000 Executive Salaries - 15,000: 15,000 001- 002 - 513 - 210000 FICA Taxes - 1,148 1,148 001- 002 -513- 340000 Contract Services - 4,000 4,000 001- 002 - 513 - 150000 Automobile Allowance - 1,450 1,450 001 - 002 -513- 400000 Travel & Per Diem 500 1,000 1,500 001- 002 - 513 - 440000 Rentals & Leases 636 800 1,436 001 -002- 513 - 450000 General Insurance 13,355 (2,500) (800) 10,055 001 -002- 513 - 462000 Equipment Maintenance 14,030 1,500 ' 15,530 001 -002- 513 - 470000 Printing 750 500 1,250 001- 002 - 513 - 520000 Operating Supplies 1,040 2,500 1,500 5,040 001 - 002- 513 - 640000 Capital- Machinery and Equipment - 2,500 2,500 Amended Administration Expenditures 28,598 -- Public Safety _..... - ..._ ..._ __.._. 001 - 004 - 521 - 341000 Community Policing 9,000 _.. (7,000)' 2,000 001 -004- 521 - 450000 General Insurance 29,950 (3,700) 26,250 Amended Public Safety Expenditures (10,700) Community Development 001 - 006 - 524 - 120000 Regular Salaries & Wages 391,498 (38,800) 10,000: 362,698 001 - 006 - 524 - 210000 FICA Taxes 30,174 (2,970) 765 27,969 001- 006 - 524 - 220000 7% Retirement Contribution 24,037 (2,716) 4,000 25,321 001- 006 - 524- 220100 3% Retirement Match 11,745 (1,164) 10,581 001 -006- 524 - 230000 Life & health Insurance 54,689 (5,258) 49,431 001- 006 -524- 240000 Worker Compensation 7,378 (900) 6,478 001 -006- 524 - 310000 Legal Services 49,820 11,000 20,000 80,820 001 - 006 -524- 330000 Professional Services 17,500 2,895 20,395 001 -006- 524- 400000 Travel & Per Diem 2,556 (2,000) 556 001 -006 - 524- 450000 General Insurance 9,535 (2,436) 7,099 5 ORD. NO. 15-2010 City of Cape Canaveral Adopted 11 -04 -2010 Budget Transfer Summary for FY 2009/2010 Attachment Amended Community Development Expenditures (9,314) Streets Department 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2010 Adjusted 001- 007 - 541 - 340000 Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance 001- 006 - 524 - 462000 Equipment Maintenance 11,330 001 -007 -541- 432000 3,670 15,000 001- 006 -524- 470000 Printing 6,600 68,505 (3,500). 3,100 001 -006- 524 - 491000 Publishing 5,000 (5,000) (4,000) 1,000 001 - 006 -524- 640000 Capital- Machinery and Equipment - 2,100 4,500 2,100 Amended Community Development Expenditures (9,314) A Streets Department 001- 007 - 541 - 340000 Contract Services - 2,000 2,000 001 -007- 541 - 430000 Utilities - 6,925 6,925 001 -007 -541- 432000 Street Lights 70,800 (2,295), 68,505 001- 007 - 541 - 450000 General Insurance 23,000 (5,000) 18,000 001- 007 -541- 461000 Building & Grounds Maintenance 16,200 4,500 20,700 001 -007 - 541 - 450000 General insurance 25,000 (2,000) 23,000 001 - 007 -541- 520000 Operating Supplies 12,100 (300)' 11,800 001 -007- 541 - 525000 Small Tools 2,300 300 2,600 001 -011 - 572 - 532000 Traffic Light Repair & Maintenance 1,200 8,000 2,300 11,500 001 -007- 541 - 640000 Capital - Machinery & Equipment - 1,395 1,600 ' 2,995 Amended Streets Department Expenditures 17,425 _ . .......... - Parks & Recreation - - -- - - - - - -- -- - - _ .. _. - ........ ...... ......... _ _._ .. - _..- . . 001 -011- 572 - 314000 Physicals 150 750 900 001 -011- 572 - 520000 Operating Supplies 6,500 (750) 5,750 001 -011- 572 - 450000 General Insurance 12,000 (1,500) 10,500 001 -011- 572 - 462000 Equipment Maintenance 1,500 3,000 4,500 001- 011 - 572 - 521100 Special Events 6,385 17,000 23,385 001 -011- 572 - 528010 Tournament Expense 4,800 2,000 1,700 8,500 001 - 011 - 572 - 540000 Memberships & Training 270 1,500 150 1,920 001- 011 - 572- 620000 Capital - Buildings - 3,840 3,840 Amended Parks & Recreation Expenditures 27,690 A ORD. No. 15 -2010 City of Cape Canaveral Adopted 11 -04 -2010 Budget Transfer Summary for FY 2009/2010 Attachment Amended Commercial Dev. Board Expenditures 12,000 Nan- Departmental 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2010 Adjusted 1,183 Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance Cultural Development Board 16,700 001 - 017 -901- 990000 Contingency 4,531 2,260 17,961 7. 001- 016 - 515 - 330000 Professional Services - 4,500 Amended General Fund Revenues 4,500 001- 016 - 515 - 480000 Promotional Activities 6,000 5,000 10,000 (7,500); 13,500 Amended Commercial Dev. Board Expenditures 12,000 Nan- Departmental 001 - 017 -901- 330000 Professional Services - 1,183 1,183 001 - 017 - 901 - 620000 .Capital - Building - 79,650 238,950 318,600 001 -017- 901 - 630100 Capital - Infrastructure 1,238,565 (174,000)' 1,064,565 001 -017 -901- 640000 Capital Equipment - 16,700 16,700 001 - 017 -901- 990000 Contingency 4,531 2,260 17,961 2,831 29,087 56,670 Amended Non - Departmental Expenditures 214,622 Amended General Fund Revenues 309,821 Amended General Fund Expenditures 309,821 Libra Fund ': �, __ Library Fund Revenues 104- 000 - 300 - 300100 Cash Forward - 1,550 1,550 Amended Beautification Fund Expenditures 1,550 Library Fund Expenditures 101 -023- 571 - 461000 Building & Grounds Maintenance 1,500 7,500 9,000 104 -023- 571 - 520000 Operating Supplies 14,440 (7,500) 6,940 104 -023- 571 - 640000 Capital - Machinery & Equipment - 1,550 1,550 Amended Beautification Fund Expenditures 1,550 ►/ of Cape Canaveral ORD. No 15-2010 City p Adopted 11 -04 -2010 Budget Transfer Summary for FY 2009/2010 Attachment Line Item Account Name Beautification Fund Expenditures 105 -015- 541 - 340000 Contract Services 105 -015- 541 - 520000 Operating Supplies 105 - 015 - 541 - 990000 Contingency Amended Beautification Fund Expenditures - Capital Expansion Fund Revenues 302 -000- 300 - 300104 Cash Forward -Parks & Recreation 302 - 000 - 300 - 300105 Cash Forward - General Government Amended Capital Expansion Fund Revenues 1,811 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2010 Adjusted Beginning Budget Budget Budget Budget Budget Balance Amend. Amend. Amend. Amend. Balance 244,622 (5,340) 239,282 16,250 5,340 5,000 26,590 27,693 (5,000) 22,693 - 1,800 1,800 Capital Expansion Fund Expenditures 302 - 026 -519- 600190 Capital - Gen Government - 9,050 302 -026 - 519 - 990019 Contingency - General Gov't 7,250 (7,250) 302 -026- 572 - 600720 Capital - Parks /Rec - 3,016 302 -026- 572 - 990072 Contingency - Parks /Rec. 3,005 (3,005) Amended Capital Expansion Fund Expenditures 1,811 9,050 3,016 �;a Sewer Enterprise Fund Expenditures 401 -010- 535 - 314200 Banking Fees - 1,300 1,300 401 -010- 535 - 340000 Contract Services 420 680 1,100 401 -010- 535 - 420000 Postage 600 500 1,100 401 -010- 535 - 450000 General Insurance 165,000 (30,000) 135,000 401- 010 - 535 - 462100 Plant & Equipment Maintenance 85,873 15,000 5,000: 105,873 401 -010- 535 - 462200 Collection System Maintenance 32,200 7,500 10,000: 49,700 �;a ORD. NO. 15-2010 City of Cape Canaveral Adopted 11 -04 -2010 Budget Transfer Summary for FY 2009/2010 Attachment Amended Sewer Enterprise Fund Expenditures Storm Water Enterprise Fund Expenditures 10/1/2009 12/31/2009 3/31/2010 6/30/2010 9/30/2019 Aajusteu Legal Services - Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance 401 -010- 535 - 520000 Operating Supplies 9,000 403 - 018 -538- 990000 (500) 5,921 8,500 401- 010 - 535 - 520001 Safety Supplies 2,000 900 ' 2,900 401 -010- 535 - 526000 Lab Supplies 38,580 (500) 38,080 401- 010 -535- 640000 Capital Equipment 51,200 1,300 26,017 2,920 ' 81,437 401- 010- 535.990000 Contingency 288,551 (1,300) (19,997) (18,820) 248,434 Amended Sewer Enterprise Fund Expenditures 1,100 Storm Water Enterprise Fund Expenditures 403 - 018 - 538 - 314200 Banking Fees - 403 -018- 538 - 310000 Legal Services - 403- 018 - 538 - 330000 Professional Services - 403 -018- 538 - 461000 Systems Maintenance 208,300 403- 018 - 538 - 524000 Motor Fuel & Lubricants 800 403 -018- 538 - 450000 General Insurance 5,500 403 -018 - 538 - 631001 Capital - Canaveral Ditch 120,000 403 - 018 -538- 990000 Contingency 5,921 1,100 10,000 ` 31,290 10,465 (200) 900 (114,000) . (1,800) 62,245 1,100 10,000 31,290 218,765 600 6,400 6,000 66,366 Amended Storm Water Ent. Fund Expenditures 0' 10 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 Revenues 001- 000 - 300 - 300100 Cash Forward 1,197,367 - - 0% 1,197,367 100% 001-000-311-311111 Ad Valorem- Police Service 1,505,726 1,476,723 - 98% 29,003 2% 001 - 000 - 311 - 311112 Ad Valorem - Fire/Rescue 1,351,497 1,325,529 - 98% 25,968 2% 001- 000 - 311 - 311115 Ad Valorem - Police - Delinquent - 45,745 - 100% (45,745) 0% 001 -000- 311 - 311125 Ad Valorem - Fire- Delinquent - 40,907 - 100% (40,907) 0% 001- 000 - 312 - 312410 Local Option Gas Tax 277,004 238,285 47,657 103% (8,938) -3% 001 - 000 -313- 313100 FPL Franchise Fees 676,000 526,505 105,301 93% 44,194 7% 001 -000- 313 - 313300 City Gas Corp Franchise Fees 32,000 27,836 7,000 109% (2,836) -9% 001 -000- 313 - 313700 Waste Pro Franchise Fees 8,000 8,000 - 100% - 0% 001 -000- 314 - 314100 FPL Utility Tax 675,000 618,556 123,711 110% (67,267) -10% 001 - 000 - 314 - 314400 Bottled Gas Utility Tax 33,000 29,748 1,000 93% 2,252 7% 001 - 000 -315- 315100 Communications Service Tax 586,010 485,507 97,101 99% 3,402 1% 001- 000 - 319 - 319122 Tax Penalty - Fire/Rescue 1,500 2,189 - 146% (689) -46% 001 - 000 - 319 - 319212 Tax Penalty - Police 1,600 2,393 - 150% (793) -50% 001- 000 - 321 - 321100 Local Business Tax 67,000 65,836 - 98% 1,164 2% 001 -000- 321 - 321110 County Business Tax 6,000 6,930 - 115% (930) -15% 001 -000- 322 - 322100 Building Permits 72,500 74,170 - 102% (1,670) -2% 001 -000- 329 - 329100 Fire Alarm Permits 2,200 2,370 - 108% (170) -8% 001 -000- 329 - 329200 Fire Inspection Fees 30,000 30,350 - 101% (350) -1% 001- 000 - 329 - 329300 Community Appearance Fees 500 75 - 15% 425 85% 001 - 000 - 329 - 329301 Zoning Fees 400 1,750 - 438% (1,350) -338% 001 - 000 - 331 - 331250 Federal Stimulus Funds 181,563 - - 0% 181,563 100% 10 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 001 -000- 335 - 335121 State Sales Tax Revenue Share 160,438 134,162 13,365 92% 12,911 8% 001 -000- 335- 335122 Municipal Gas Tax 58,143 48,695 4,850 92% 4,598 8% 001 -000- 335 - 335140 Mobile Home Licenses 4,600 4,918 - 107% (318) -7% 001 -000- 335 - 335150 Alcoholic Beverage License 9,500 8,462 - 89% 1,038 11% 001 - 000 -335- 335180 Local 112 Cent Sales Tax 441,497 387,568 76,000 105% (22,071) -5% 001 - 000 -338- 338201 County EMS Revenue Share 24,500 26,359 - 108% (1,859) -8% 001 - 000 -341- 341300 Sales of Maps & Publications 25 - - 0% 25 100% 001- 000 - 341 - 341400 Copies of Ord. & Photo Copies 200 720 - 360% (520) -260% 001 - 000 -342- 342101 Investigative Fees 30,000 33,449 - 111% (3,449) -11% 001 - 000 - 343 - 343400 Garbage Revenue 690,000 670,887 60,000 106% (40,887) -6% 001- 000 - 343 - 343450 Recycling Fee Revenue 166,300 127,564 11,200 83% 27,536 17% 001- 000 - 343 - 343451 Recycled Product Revenue - 983 - 100% (983) 0% 001 - 000 -343- 343455 Waste Pro Billing Reimbursement 11,760 10,779 975 100% 6 0% 001 - 000 - 343 - 343901 Lot Clearing and Mowing Fees 2,000 1,480 - 74% 520 26% 001 - 000 - 347 - 347211 Recreation Programs 12,000 10,806 - 90% 1,194 10% 001- 000 - 347 - 347260 Tennis Court Rentals 5,500 5,564 - 101% (64) -1% 001 -000- 347- 347291 Racquetball Court Rentals 3,800 4,099 - 108% (299) -8% 001 -000- 347 - 347292 Shuffleboard Court Rentals 1,800 1,407 - 78% 393 22% 001- 000 - 347 - 347293 Tournament Income 11,900 11,816 - 99% 84 1% 001- 000 - 347 - 347295 Recreation Equipment Rentals 80 25 - 31% 55 69% 001- 000 - 347 - 347296 Tennis /Racquetball League Inc. 5,000 5,955 - 119% (955) -19% 001- 000 -347- 347297 Athletic League Income 5,600 5,848 - 104% (248) -4% 001- 000 - 347 - 347298 Summer Camp Registration 4,600 5,390 - 117% (790) -17% 001 - 000 - 347 - 347490 Recreation Special Events 22,700 10,731 - 47% 11,969 53% 11 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 001 -000- 347 - 347590 001 - 000 -351- 351100 001 - 000 - 351- 351101 001 -000- 354 - 354100 001 -000 - 360- 360300 001 -000- 360 - 360400 001 -000- 360 - 360410 001 - 000 - 361- 361100 001 - 000 - 361 - 361310 001 - 000 - 361- 361311 001 - 000 - 364 - 364490 001 - 000 -366- 366220 001- 000- 369 - 369100 001 -000- 369 - 369200 001 - 000 - 369 - 369300 001 - 000 - 380 - 380100 001 - 000 - 389 - 389401 Recreation Facility Rental Fines & Forfeitures Fines - Parking Tickets Violations of Local Ordinances Recreation Retail Sales Promotional Items For Resale Concurrency Management Fees Interest From Investment Interest Tax Coll - Police Interest Tax Coll - Fire Sale of Fixed Assets Contributions- Private Sources Miscellaneous Income Plan Review Income Refund of Prior Year Expense Transfer From Sewer Fund Recreation Sponsorships Removing Cash Forward Removing Grants pushed to FY 2010111 4,400 10,066 - 229% (5,666) -129% 29,000 25,534 - 88% 3,466 12% 10,000 13,720 - 137% (3,720) -37% 10,000 638 - 6% 9,363 94% 230 370 - 161% (140) -61% 25 23 - 91% 2 9% 250 100 - 40% 150 60% 140,000 146,084 - 104% (6,084) -4% 700 124 - 18% 576 82% 600 111 - 19% 489 81% 2,000 - - 0% 2,000 100% 4,346 173,196 - 3985% (168,850) -3885% 3,900 4,837 - 124% (937) -24% 15,725 14,534 - 92% 1,192 8% 3,150 1,611 - 51% 1,539 49% 125,000 125,000 - 100% - 0% 4,500 5,125 - 114% (625) -14% 8,730,636 7,048,140 548,160 87% 1,134,336 13% (1,197,367) (181,563) 7,351,706 103.33% 12 Projected Collection excluding Cash Forward and Grants (with final accruals) City of Cape Canaveral ORD. NO. 15-2010 Expense us. Budget Adopted 11 -04 -2010 p g Attachment Quarter Ended 09/30/10 Uu1 001 - 001 -511- 110000 001 -001- 511 - 210000 001 -001 -511- 240000 001 - 001 -511- 330000 001 -001 -511- 400000 001 -001 -511- 450000 001 - 001 -511- 462000 001 -001- 511 - 480000 001 -001 - 511 - 480100 001- 001 - 511 - 491000 001 - 001 -511- 492000 001 - 001 - 511493000 001 - 001 -511- 510000 001 - 001 -511- 520000 001 - 001 - 511 - 540000 001- 001- 511 - 640000 Legislative Executive Salaries FICA Taxes Worker Compensation Professional Services Travel & Per Diem General Insurance Equipment Maintenance Promotional Activities Web Site Maintenance Publishing Elections Awards And Recognitions Office Supplies Operating Supplies Memberships & Training Capital - Machinery and Equip. 12,800 12,800 - 100% (0) 0% 979 979 - 100% (0) 0% 28 19 - 69% 9 31% 27,000 28,391 - 105% (1,391) -5% 4,000 2,624 553 79% 822 21% 750 480 - 64% 270 36% 2,500 1,792 50 74% 658 26% 8,000 6,576 - 82% 1,424 18% 1,100 1,199 - 109% (99) -9% 3,000 3,631 - 121% (631) -21% 12,000 8,839 204 75% 2,957 25% 4,000 598 - 15% 3,402 85% 1,000 1,056 - 106% (56) -6% 4,800 5,504 - 115% (704) -15% 5,000 4,334 - 87% 666 13% 2,600 - - 0% 2,600 100% 89,557 78,823 807 89% 9,927 11% Less Unused Capital Budgeted from Reserves (2,600) 7,327 13 City of Cape Canaveral ORD. NO. 15 -2010 Adopted 11 -04-20 10 Expense vs. Budget Attachment Quarter Ended 09/30/10 City of Cape Canaveral ORD. NO. 15-2010 Adopted I1 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 002 Administration 001 - 002 -513- 110000 Executive Salaries 291,069 303,064 10,512 108% (22,507) -8% 001 -002- 513 - 140000 Overtime 876 1,290 - 147% (414) -47% 001- 002 - 513 - 150000 Automobile Allowance 1,450 858 110 67% 483 33% 001- 002 - 513 - 210000 FICA Taxes 22,334 22,187 800 103% (653) -3% 001 - 002 - 513 - 220000 7% Retirement Contribution 20,375 14,942 736 77% 4,697 23% 001 - 002 -513- 220100 3% Retirement Match 8,732 3,773 188 45% 4,771 55% 001- 002 - 513 - 230000 Life & Health Insurance 35,272 31,935 - 91% 3,337 9% 001 - 002 -513- 240000 Worker Compensation 633 419 - 66% 214 34% 001- 002- 513 - 314000 Physicals - 27 - 100% (27) 0% 001 - 002 - 513 - 314200 Banking Fees 9,000 8,353 - 93% 647 7% 001- 002 - 513 - 320000 Audit Expense 22,500 21,550 - 96% 950 4% 001 - 002 -513- 340000 Contract Services 5,140 8,445 - 164% (3,305) -64% 001- 002 - 513 - 350000 Vehicle Investigation Fees - 80 - 100% (80) 0% 001- 002 - 513- 400000 Travel & Per Diem 1,500 1,339 80 95% 81 5% 001 - 002 -513- 410000 Communications Service 3,840 3,462 - 90% 378 10% 001- 002 - 513 - 420000 Postage 4,000 2,971 17 75% 1,012 25% 001 -002 - 513 - 430000 Utilities 7,140 6,196 - 87% 944 13% 001 -002- 513 - 440000 Rentals And Leases 1,436 767 138 63% 531 37% 001- 002 - 513 - 450000 General Insurance 10,055 10,153 - 101% (98) -1% 001- 002 -513- 462000 Equipment Maintenance 15,530 17,749 63 115% (2,281) -15% 001 -002- 513 - 470000 Printing 1,250 1,155 1,600 220% (1,504) -120% 001- 002 - 513 - 510000 Office Supplies 2,450 2,473 50 103% (73) -3% 001- 002 - 513 - 520000 Operating Supplies 5,040 4,638 2 92% 400 8% 14 City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 ORD. NO. 15-2010 Adopted 11 -04 -2010 Attachment 475,422 472,486 14,295 102% (11,359) -2% Less Unused Capital Budgeted from Reserves (768) (12,127) FN7 001 - 002 - 513 - 524000 Motor Fuel & Lubricants 300 168 - 56% 132 44% 001 -002- 513 - 540000 Memberships & Training 3,000 2,760 - 92 % 240 8 % 001- 002- 513 - 640000 Capital - Machinery and Equip. 2,500 1,732 - 69% 768 31% Vu4 001 -004- 521 - 120000 001 - 004 - 521 - 210000 001- 004 - 521 - 240000 001 - 004 - 521 - 314000 001 -004- 521 - 340000 001 - 004 - 521 - 341000 001 -004- 521 - 341100 001 - 004 - 521 - 345000 001- 004 - 521 - 345500 001- 004 - 521 - 410000 001 - 004 -521- 430000 001- 004 - 521 - 450000 001 -004 -521- 520000 001 - 004 - 521 - 523000 001 -004- 521 - 540000 001 - 004 - 521 - 640000 Public Satety Regular Salaries & Wages FICA Taxes Worker Compensation Physicals Contract Services - BCSO Community Policing School Resource Officer Collection Surcharge State Attorney Dispositions Communications Service Utilities General Insurance Operating Supplies Uniforms Memberships & Training Capital - Machinery and Equip, 17,382 15,156 670 91% 1,556 9% 1,330 1,159 51 91% 120 9% 347 243 - 70% 104 30% 75 - - 0% 75 100% 2,451,440 2,451,436 - 100% 4 0% 2,000 395 - 20% 1,605 80% 6,780 6,780 - 100% - 0% 4,000 5,450 - 136% (1,450) -36% 1,000 700 - 70% 300 30% 960 174 - 18% 786 82% 13,110 11,241 - 86% 1,869 14% 26,250 26,204 - 100% 46 0% 1,000 1,000 - 100% - 0% 250 120 - 48% 130 52% 200 - - 0% 200 100% 51,900 48,298 - 93% 3,603 7% 2,578,024 2,568,356 721 100% 8,947 0% Less Unused Capital Budgeted from Reserves (3,603) 5,344 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 005 Fire Rescue 001 -005 -522- 240000 Worker Compensation 44,000 20,767 - 47% 23,233 53% 001 -005- 522 - 340000 Contract Services - CCVFD 1,266,798 1,266,798 - 100% - 0% 001- 005 - 522 - 341101 LOSAP Retirement Program 7,500 1,340 - 18% 6,161 82% 001 -005- 522 - 341500 Fire Engineering Fees 1,000 200 - 20% 800 80% 001 - 005 -522- 420000 Postage 500 687 25 142% (212) -42% 001- 005 - 522 - 441000 Fire Hydrant Rent 46,327 43,061 - 93% 3,266 7% 001 - 005 - 522 - 450000 General Insurance 39,600 30,419 - 77% 9,181 23% 001- 005 - 522 - 462000 Equipment Maintenance 26,000 27,874 - 107% (1,874) -7% 001- 005 - 522 - 641000 Fire Fighting Equipment 13,000 12,783 - 98% 217 2% 001 -005- 522 - 642000 Capital - Machinery and Equip. 300,698 - - 0% 300,698 100% 1,745,423 1,403,928 25 80% 341,470 20% Less Unused Capital Budgeted from Reserves (300,915) 40,555 IN City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 VUb Community Development 001 -006- 524 - 120000 Regular Salaries & Wages 352,698 352,809 11,668 103% (11,779) -3 % 001- 006 -524- 140000 Overtime 2,934 2,396 - 82% 538 18% 001- 006 - 524 - 210000 FICA Taxes 27,204 27,014 885 103% (695) -3% 001 -006- 524 - 220000 7% Retirement Contribution 25,321 25,515 817 104% (1,011) -4% 001 - 006- 524 - 220100 3% Retirement Match 10,581 6,781 208 66% 3,592 34% 001 - 006 - 524 - 230000 Life & Health insurance 49,431 48,463 - 98% 968 2 % 001 -006- 524 - 240000 Worker Compensation 6,478 5,139 - 79% 1,339 21% 001 -006 -524- 310000 Legal Services 60,820 71,518 10,000 134% (20,698) -34% 001- 006 - 524 - 330000 Professional Services 20,395 16,074 6,748 112% (2,426) -12% 001- 006 - 524 - 400000 Travel & Per Diem 556 107 - 19% 449 81% 001 - 006 - 524 - 410000 Communications Service 5,500 3,677 - 67% 1,823 33% 001 - 006 - 524 - 420000 Postage 4,000 3,861 25 97% 114 3% 001 -006 -524- 430000 Utilities 3,800 3,939 - 104% (139) -4% 001 - 006 -524- 450000 General Insurance 7,099 7,030 - 99% 69 1% 001 - 006 - 524 - 462000 Equipment Maintenance 15,000 13,811 208 93% 981 7% 001 -006- 524 - 470000 Printing 3,100 2,370 - 76% 730 24% 001- 006 - 524 - 491000 Publishing. 1,000 375 27 40% 599 60% 001- 006 - 524 - 510000 Office Supplies 1,500 676 25 47% 799 53% 001 - 006 - 524 - 520000 Operating Supplies 3,500 3,544 - 101% (44) -1% 001 - 006- 524 - 523000 Uniforms 400 - 322 81% 78 19% 001 -006- 524 - 524000 Motor Fuel & Lubricants 1,575 1,953 - 124% (378) -24% 001 -006- 524 - 540000 Memberships & Training 2,870 2,021 40 72 %u 809 28% 001 -006- 524 - 640000 Capital - Machinery and Equip. 2,100 1,578 - 75% 522 25% 2 City of Cape Canaveral ORD.NO. 15 -2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 19 ORD. No. 15 -2010 Adopted 11 -04 -2010 Attachment 607,862 600,650 30,973 104% (23,761) -4% Less Unused Capital Budgeted from Reserves (522) (24,283) 007 Streets 001 -007- 541 - 120000 Regular Salaries & Wages 274,738 262,917 9,638 99% 2,183 1 % 001 -007- 541 - 140000 Overtime 1,461 628 20 44% 813 56% 001 -007- 541 - 210000 FICA Taxes 21,129 19,779 724 97% 626 3% 001 -007- 541 - 220000 7% Retirement Contribution 19,232 17,017 675 92% 1,540 8% 001 - 007 - 541 - 220100 3% Retirement Match 8,242 7,173 247 90% 822 10% 001 -007- 541 - 230000 Life & Wealth Insurance 57,153 52,557 - 92% 4,596 8% 001 -007- 541 - 240000 Worker Compensation 14,197 9,742 - 69% 4,455 31% 001 -007- 541 - 314000 Physicals - 318 - 100% (318) 0% 001 -007- 541 - 330000 Professional Services 3,750 - 2,200 59% 1,550 41% 001 -007- 541 - 340000 Contract Services 2,000 1,260 1,200 123% (460) -23% 001 -007- 541 - 400000 Travel & Per Diem - 5 - 100% (5) 0% 001 - 007 -541- 410000 Communications Service 3,735 3,192 - 85% 543 15% 001- 007 - 541 - 420000 Postage 25 24 - 94% 1 6% 001 -007- 541 - 430000 Utilities 6,925 5,422 - 78% 1,503 22% 001- 007 - 541 - 432000 Street Lights 68,505 55,977 - 82% 12,528 18% 001 - 007 - 541 - 450000 General Insurance 18,000 17,480 - 97% 520 3% 001 -007- 541 - 461000 Building & Grounds Maintenance 20,700 21,151 1,944 112% (2,395) -12% 001- 007 - 541 - 462000 Equipment Maintenance 9,000 6,992 130 79% 1,878 21% 001- 007 - 541 - 510000 Office Supplies 250 223 - 89% 27 11% 001 -007- 541 - 520000 Operating Supplies 11,800 8,297 - 70% 3,503 30% 001 - 007 - 541 - 523000 Uniforms 1,990 2,065 501 129% (576) -29% 001 - 007 - 541 - 524000 Motor Fuel & Lubricants 10,000 10,856 - 109% (856) -9% 001 - 007 - 541 - 525000 Small Tools 2,600 2,464 - 95% 136 5% 20 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04-20 10 Expense vs. Budget Attachment Quarter Ended 09/30/10 City of Cape Canaveral ORD. No. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 001 -007- 541 - 530000 Street Repairs 28,000 14,177 - 51% 13,823 49% 001 - 007 - 541 - 532000 Traffic Light Repair & Maintenance 11,500 19,363 - 168% (7,863) -68% 001 -007- 541 - 533000 Street Signs 1,700 429 - 25% 1,271 75% 001 -007- 541 - 540000 Memberships & Training - 113 - 100% (113) 0% 001 - 007 -541- 630000 Capital - Infrastructure 116,000 45,042 21,569 57% 49,389 43% 001 -007- 541 - 640000 Capital - Machinery and Equip. 2,995 2,471 - 83% 524 17% 715,627 587,134 38,848 87% 89,644 13% Less Unused Capital Budgeted from Reserves (49,913) 39,731 21 Oil 001 -011- 572 - 120000 001 - 011 - 572 - 210000 001 -011- 572 - 220000 001 -011- 572 - 220100 001- 011 - 572 - 230000 001 - 011 -572- 240000 001 -011- 572 - 314000 001 - 011 - 572 - 340000 001 -011- 572- 343000 001 -011- 572 - 400000 001 -011- 572- 410000 001 - 011 -572- 420000 001 -011- 572 - 430000 001 -011- 572- 450000 001 -011- 572 - 461000 001 -011- 572 - 462000 001 - 011 -572- 510000 001 - 011 - 572 - 520000 001- 011 - 572 - 520500 001 -011- 572 - 521100 001 - 011 -572- 521600 001 - 011 - 572 - 524000 001 - 011 - 572 - 528010 Parks & Recreation Regular Salaries & Wages 189,572 183,940 6,005 100% (373) 0% FICA Taxes 14,502 14,031 459 100% 12 0% 7% Retirement Contribution 10,199 10,176 400 104% (377) -4% 3% Retirement Match 4,371 4,361 148 103% (138) -3% Life & Health Insurance 23,360 22,405 - 96% 955 4% Worker Compensation 5,460 4,763 - 87% 697 13% Physicals 900 892 - 99% 8 1% Contract Services- Umpires 6,100 4,553 - 75% 1,547 25% Lifeguard Contract 18,721 18,721 - 100% - 0% Travel & Per Diem 100 60 - 60% 40 40% Communications Service 850 590 - 69% 260 31% Postage 150 78 - 52% 72 48% Utilities 12,540 10,314 - 82% 2,226 18% General Insurance 10,500 10,222 - 97% 278 3% Building & Grounds Maintenance 3,740 3,415 - 91% 325 9% Equipment Maintenance 4,500 4,647 138 106% (285) -6% Office Supplies 400 384 8 98% 8 2% Operating Supplies 5,750 3,349 413 65% 1,988 35% Athletic League Supplies 2,250 732 - 33% 1,518 67% Special Events 23,385 21,315 395 93% 1,675 7% Summer Recreation Program 4,000 3,600 104 93% 296 7% Motor Fuel & Lubricants 700 411 - 59% 289 41% Tournament Expense 8,500 8,553 - 101% (53) -1% 22 City of Cape Canaveral ORD. NO. 15-2010 Adopted I1 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 ORD. NO. 15 -2010 Adopted 11 -04 -2010 Attachment 366,310 347,425 8,069 97% 10,816 3% Less Unused Capital Budgeted from Reserves (1,858) 8,958 23 001- 011 -572- 540000 Memberships & Training 1,920 3,928 - 205% (2,008) -105% 001 - 011 -572- 620000 Capital - Buildings 3,840 3,838 - 100% 2 0% 001 -011 -572- 630000 Capital - Infrastructure 10,000 8,145 - 81% 1,856 19% City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 ORD. NO. 15 -2010 Adopted 11 -04-20 10 Attachment 85,300 68,494 - 80% 16,806 20% 24 013 Legal Services 001 -013- 514- 310000 Legal Services 60,000 65,106 - 109% (5,106) -9% 001 - 013 -514- 312001 Specialized Legal Services 25,000 2,807 - 11% 22,193 89% 001- 013 - 514 - 450000 General Insurance 300 581 - 194% (281) -94% 014 Solid Waste 001 -014- 534 - 342000 Contract Garbage Service 690,000 619,325 1,750 90% 68,925 10% 001 - 014 -534- 342010 Contract Recycling Service 166,300 137,801 - 83% 28,499 17% 001 - 014 -534- 433000 Dumping Charges 800 946 - 118% (146) -18% 001 - 014 -534- 491000 Publishing 1,200 809 - 67% 391 33% 858,300 758,880 1,750 89% 97,670 11% 25 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 016 Business & Cultural Development 001 - 016 - 515 - 330000 Professional Services 4,500 001 - 016 -515- 400000 Travel & Per Diem 50 001 - 016 -515- 420000 Postage 50 001 -016 -515- 480000 Promotional Activities 13,500 001 - 016 -515- 520000 Operating Supplies 150 001-016-515-540000 Memberships & Training 880 4,250 - 94% 250 6% - - 0% 50 100% 290 - 579% (240) -479% 13,679 - 101% (179) -1% 51 - 34% 99 66% 478 - 54% 403 46% 19,130 18,748 - 98% . 382 2% 26 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 017 Non - Departmental 001 - 017 -901- 330000 Professional Services 1,183 1,183 - 100% 0 0% 001 - 017.901- 620000 Capital - Building 79,650 26,750 164,443 240% (111,543) -140% 001- 017 - 901 - 630100 Capital - Infrastructure 1,064,565 385,225 672,416 99% 6,924 1% 001 - 017 - 901 - 640000 Capital Equipment 16,700 15,260 291 93% 1,148 7% 001- 017 - 901 - 990000 Contingency 27,583 - - 0% 27,583 100% 1,189,681 428,418 837,150 106% (75,887) - 6% 27 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 Revenues 101 - 000 - 300- 300100 Cash Forward 101 - 000 - 351 - 351300 Police Education Income 101 - 000 -361- 361100 Interest From Investment Expenditures 101 -027- 521 - 810000 Education And Training 1,150 - - 0% 1,150 100% 2,800 3,867 - 138% (1,067) -38% 50 142 - 284% (92) -184% 4,000 4,009 - 100% (9) 0% 4,000 - - 0% 4,000 100% 4,000 - - 0% 4,000 100% City of Cape Canaveral ORD. NO. 15-2010 Expense us. Budget Adopted 11 -04 -2010 Ex P g Attachment Quarter Ended 09/30/10 City of Cape Canaveral ORD. NO. 15 -2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 Expenditures 102 -022- 581 - 990000 Contingency 1 477 - 48% 523 52% 1,000 - - 0% 1,000 100% 0% 1,000 100% 29 Kevenues 102 - 000 -361- 361100 Interest From Investment 400 477 - 119% (77) -19% 102 -000- 363- 363225 Impact Fees 600 - - 0% 600 100% City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 ORD. NO. 15 -2010 Adopted 11 -04 -2010 Attachment Revenues 103- 000 -351- 351505 103 -000- 361- 361100 Parking Fine Surcharge - 4,370 - 100% (4,370) 0% Interest Income - 17 - 100% (17) 0% 4,387 - 100% (4,387) 0% 30 104- 000- 301 - 301100 104- 000 - 311 - 311100 104- 000 - 311 - 311105 104- 000 - 319- 319120 104 - 000- 361 - 361100 104- 000 -361- 361300 Revenues Cash Forward Ad Valorem Taxes Ad Valorem Tax - Delinquent Tax Penalty Income Interest From Investment Interest - Tax Collections 1,550 Expenditures 104 - 023 -571- 450000 General Insurance 104- 023 -571- 461000 Building & Grounds Maintenance 104 - 023 - 571 - 520000 Operating Supplies 104- 023 - 571 - 640000 Capital - Machinery and Equip. 104- 023 - 571 - 990000 Contingency 1,550 - - 0% 1,550 100% 48,150 47,224 - 98% 926 2% - 1,458 - 100% (1,458) 0% 50 78 - 156% (28) -56% 1,836 2,110 - 115% (274) -15% 25 4 - 16% 21 84% 51,611 50,874 - 99% 737 1% 34,000 27,262 - 80% 6,738 20% 9,000 8,827 314 102% (141) -2% 6,940 175 - 3% 6,765 97% 1,550 1,550 - 100% - 0% 121 - - 0% 121 100% 51,611 37,814 314 74% 13,484 26% 31 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 105 - 000 - 301 - 301100 105- 000 - 311- 311100 105 -000 - 311- 311105 105 -000- 319 - 319120 105 - 000 - 361- 361100 105- 000 - 361- 361300 105 - 000 -366- 366100 105-015-541-120000 105 -015 -541 - 140000 105-015-541-210000 105 -015 -541- 220000 105 -015- 541 - 220100 105 -015 -541- 230000 105 -015 -541- 240000 105 -015- 541 - 340000 105- 015 -541- 400000 Revenues Cash Forward Ad Valorem Taxes Ad Valorem Tax - Delinquent Tax Penalty Income Interest From Investment Interest -Tax Collections Donations From Private Sources Expenditures Regular Salaries & Wages Overtime FICA Taxes 7% Retirement Contribution 3% Retirement Match Life & Health Insurance Worker Compensation Contract Services Travel & Per Diem 481,000 - - 0% 481,000 100% 354,695 347,882 - 98% 6,813 2% - 10,740 - - 100% (10,740) 0% - 578 - 100% (578) 0% 18,000 18,546 - 103% (546) -3% 200 29 - 15% 171 86% - 1,373 - 100% (1,373) 0% 239,282 202,359 15,399 91% 21,524 9% 853,895 379,148 - 44% 474,747 56% 41,235 40,881 - 99% 354 1% - 126 - 100% (126) 0% 3,154 3,101 - 98% 53 2% 2,886 2,556 - 89% 330 11% 1,237 1,275 - 103% (38) -3% 5,873 4,686 - 80% 1,187 20% 1,297 891 - 69% 406 31% 239,282 202,359 15,399 91% 21,524 9% 250 2 - 1% 249 99% M City of Cape Canaveral ORD. No. 15_2010 Adopted 11 -04 -2010 Expense us. Budget Attachment Quarter Ended 09/30/10 105 -015- 541 - 410000 105 -015- 541 - 420000 105 -015 -541 - 430000 105 -015- 541- 450000 105 -015 -541 - 493000 105 -015 -541 - 510000 105 -015- 541 - 520000 105-015-541-520100 105- 015 - 541 - 521000 105 - 015 -541- 524000 105 - 015 -541- 525000 105 -015- 541 - 540000 105 -015 -541 - 631101 105 - 015 -541- 633000 105-015-541-635000 105- 015 -541- 640000 105 -015- 541 - 820000 105 -015 -541 - 990000 Communications Service Postage Utilities General Insurance Awards And Recognitions Office Supplies Operating Supplies Operating - Bennix Chemicals Motor Fuel & Lubricants Small Tools Memberships & Training Capital - Bennix Landscaping Capital - Manatee Park Capital - Ridgewood Avenue Capital - Machinery and Equip. Aid To Private Organizations Contingency 560 309 - 55% 251 45% 100 61 - 61% 39 39% 913 948 - 104% (35) -4% 6,000 6,041 - 101% (41) -1% 1,750 1,835 239 119% (324) -19% 50 32 - 64% 18 36% 26,590 24,322 361 93% 1,907 7% 3,500 1,256 - 36% 2,244 64% 3,325 1,878 - 56% 1,447 44% 1,500 2,499 - 167% (999) -67% 250 298 - 119% (48) -19% 650 818 - 126% (168) -26% 165,000 55,803 - 34% 109,197 66% 7,500 - - 0% 7,500 100% 316,000 134,798 - 43% 181,202 57% - 269 - 100% (269) 0% 2,300 2,300 - 100% - 0% 22,693 - - 0% 22,693 100% 853,895 489,343 16,000 59% 348,552 41% 33 City of Cape Canaveral ORD. NO. 15-2010 Ex Expense us. Budget Adopted 11 -04 -2010 P g Attachment Quarter Ended 09/30/10 Expenditures 302 - 026 -519 - 600190 Capital - Gen Government 302 -026- 521 - 990021 Contingency - Police 302- 026 -522- 990022 Contingency - Fire 302 - 026 -571- 990071 Contingency - Library 9,050 9,525 Revenues (475) -5% 2,500 - - 0% 2,500 302- 000 - 300 - 300104 Cash Forward - Parks & Recreation 11 - - 0% 11 100% 302 - 000 - 300 - 300105 Cash Forward - Gen. Gov't 1,800 - - 0% 1,800 100% 302- 000 - 361- 361150 Interest - Police 1,600 1,695 - 106% (95) -6% 302 -000- 361 - 361160 Interest - Fire /Rescue 1,400 1,507 - 108% (107) -8% 302 - 000- 361 - 361170 Interest - Parks & Recreation 2,380 2,454 - 103% (74) -3% 302- 000 - 361- 361180 Interest - Library 5,700 6,073 - 107% (373) -7% 302- 000 - 361- 361190 Interest - Gen. Gov't. 6,400 6,660 - 104% (260) -4% 302 -000- 363- 363221 Cap.Exp. Fees - Police 900 257 - 29% 643 71% 302- 000 - 363- 363222 Cap.Exp. Fees - Fire 325 149 - 46% 176 54% 302- 000 - 363- 363271 Cap.Exp. Fees - Library 325 160 - 49% 165 51% 302 - 000 - 363 - 363272 Cap.Exp. Fees - Parks & Recreation 625 303 - 48% 322 52% 302 -000- 363- 363291 Cap.Exp. Fees - Gen Gov't. 850 211 - 25% 639 75% 22,316 19,469 - 87% 2,847 13% Expenditures 302 - 026 -519 - 600190 Capital - Gen Government 302 -026- 521 - 990021 Contingency - Police 302- 026 -522- 990022 Contingency - Fire 302 - 026 -571- 990071 Contingency - Library 9,050 9,525 - 105% (475) -5% 2,500 - - 0% 2,500 100% 1,725 - - 0% 1,725 100% 6,025 - - 0% 6,025 100% 34 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 City of Cape Canaveral Expense vs. Budget Quarter Ended 09/30/10 ORD. NO. 15 -2010 Adopted 11 -04 -2010 Attachment 22,316 12,733 - 57 % 9,583 43% 35 302 - 026 -572- 600720 Capita] - Parks & Recreation 3,016 3,208 - 106% (192) -6% Revenues 602 -000- 300 - 300100 Cash Forward 41,000 - - 0% 41,000 100% 602 -000- 359 - 359100 Contraband Income - State - 2,523 - 100% (2,523) 0% 602 -000- 361 - 361100 Interest From Investment - 230 - 100% (230) 0% 41,000 2,753 - 7% 38,247 93% Expenditures 602- 020- 521 - 341100 School Resource Officer 41,000 41,000 - 100% - 0% 41,000 41,000 - 100% - 0% 36 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 LS %64 t+bb'175£ %68 - £06'6WZ L4Z'£LZ'£ %00 4 00 4 %0 - - 00 4 %0 W 0 %00 l - 8£ 4 - %6Z L9 %ZL - E7 4 00Z %0 t60 %004 - 6E %84 L %£8 - ££ 07 %99 (049'9) % 994 - 049'94 000'04 %09 4£5`9 %017 - 76L'9 9Z£'174 %77 (5L8) %774 - 9L8'Z 000'Z %Z9 L98'L %817 - £E 4'L 000'9 4 %6 E67'9 %46 - L09179 000'09 %7 496'824 %96 - 486'ZE8'Z Z88'496'Z %004 OL9'60Z %0 - - OL9'60Z awooul snoauepaosin anJasa�:l d.LMM - ;saJa;ul MOJOS3 d1MM - IM91ul amesa�j asno�j JateM - [saia[ul MoJ063 asnaZ{ JaleM - tsojejuI pun3 enuana�j - tSGJatuI pund uoisuedx3 - asaaaaul soa3 dnlOOM esneH saa3 ;uauESSassy James auaooul Alleuad Aimin awooul 6upJado fgimn pJemlod 4se0 sanuanaa 00469£ - 69£ - 000 77449£ - 49£ £17449£ - 000 27449£ - 49£ - 000 47449£ - 49£ - 407 017449E - 49E - 000 - 4017 04449E 000 - 407 4£S£7£ - £V € - 4017 Oc9EVE -EVE- 000 -4017 OZ9E17£ - £17£ - 000 - 407 049£7£ 000 - 4017 00400£ 000 - 407 OZ /OE /60 papu3 aalaenl) Juowq I@Opng - SA asuadx3 0 [ oz [ I po}dopV oloz - sr •ou - ax o UDAe U e:) ad e:) jo Alit C City of Cape Canaveral ORD. NO. l5 -2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 Expenditures 401 -010 -535 - 110000 Executive Salaries 147,559 145,344 - 98% 2,215 2% 401 - 010- 535 - 120000 Regular Salaries & Wages 790,391 746,742 - 94% 43,649 6% 401 - 010.535- 140000 Overtime 19,981 9,543 - 48% 10,438 52% 401 -010 -535 - 150000 Car Allowance - 368 - 100% (368) 0% 401 -010 -535- 210000 FICA Taxes 73,282 68,280 - 93% 5,002 7% 401 -010- 535 - 220000 7% Retirement Contribution 65,657 59,362 - 90% 6,295 10% 401- 010 - 535 - 220100 3% Retirement Match 28,139 20,002 - 71% 8,137 29% 401 - 010 - 535 - 230000 Life & Health Insurance 137,486 131,897 - 96% 5,589 4% 401- 010 -535- 240000 Worker Compensation 19,074 12,872 - 67% 6,202 33% 401 -010- 535 - 250000 Unemployment Compensation - 4,675 - 100% (4,675) 0% 401 - 010 - 535 - 310000 Legal Services 4,000 854 - 21% 3,146 79% 401 -010 -535- 313000 Engineering Fees 20,100 12,439 804 66% 6,857 34% 401 - 010 - 535 - 314000 Physicals 800 813 - 102% (13) -2% 401- 010 - 535 - 314200 Banking Fees 1,300 959 - 74% 341 26% 401- 010 - 535 - 320000 Audit Expense 22,500 21,550 - 96% 950 4% 401 -010- 535 - 340000 Contract Services 1,100 962 - 87% 138 13% 401 -010 -535- 400000 Travel & Per Diem 3,500 149 83 7% 3,268 93% 401 -010- 535410000 Communications Service 5,196 4,519 - 87% 677 13% 401 -010- 535 - 420000 Postage 1,100 832 15 77% 253 23% 401 -010- 535 - 430000 Utilities 217,920 170,399 - 78% 47,521 22% 401 -010- 535 - 431000 Sludge Disposal Fees 69,600 50,235 - 72% 19,365 28% 401 -010 -535- 450000 General Insurance 135,000 134,680 - 100% 320 0% 401 - 010 - 535 - 461000 Building & Grounds Maintenance 23,050 16,827 2,478 84% 3,745 16% C City of Cape Canaveral ORD. NO. l5 -2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 401 - 010 - 535 - 462100 401 - 010 - 535 - 462200 401- 010 - 535 - 470000 401 - 010 - 535 - 520000 401 -010- 535 - 520001 401 -010- 535 - 521000 401 -010- 535 - 523000 401 - 010 - 535 - 524000 401- 010 - 535 - 525000 401 -010- 535 - 526000 401 -010- 535 - 528000 401 -010- 535 - 540000 401 -010 -535 - 541000 401 -010- 535 - 630500 401 - 010 - 535- 630800 401- 010 - 535 - 640000 401- 010- 535 - 711000 401 -010- 535 - 711100 401 -010- 535 - 720000 401 - 010- 535 - 910000 401 -010- 535 - 990000 Plant & Equipment Maintenance Collection System Maintenance Printing Operating Supplies Safety Supplies Chemicals Uniforms Motor Fuel & Lubricants Small Tools Lab Supplies Reclaimed Water Supplies Memberships & Training Operating Fees & Licenses Capital - Lift Station Capital - Force Main Capital - Machinery and Equip. SRLF CS120825020 Debt SRLF CS120825030 Debt SRLF Interest Transfer To General Fund Contingency 105,873 107,721 113 102% (1,961) -2% 49,700 46,098 - 93% 3,602 7% 1,500 237 - 16% 1,263 84% 8,500 7,504 272 91% 724 9% 2,900 3,325 - 115% (425) -15% 89,000 85,539 - 96% 3,461 4% 5,900 4,069 326 74% 1,505 26% 7,620 8,976 - 118% (1,356) -18% 2,000 1,275 - 64% 725 36% 38,080 29,671 - 78% 8,409 22% 6,000 4,228 894 85% 878 15% 3,157 3,042 - 96% 115 4% 7,600 6,675 - 88% 925 12% 48,000 47,539 - 99% 461 1% - 1,691 - 100% (1,691) 0% 81,437 78,997 300 97% 2,141 3% 422,340 415,942 - 98% 6,398 2% 117,903 117,903 - 100% (0) 0% 115,538 115,538 - 100% (0) 0% 125,000 125,000 - 100% - 0% 248,434 - - 0% 248,434 100% 3,273,217 2,825,271 5,285 86% 442,662 14% 39 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11- 04 -20I0 Expense vs. Budget Attachment Quarter Ended 09/30/10 Revenues 403 -000- 300 - 300100 Cash Forward 403 -000- 343 - 343900 Stormwater Utility Fees 403 -000- 361 - 361100 Interest From Investment 403 -018- 538 - 120000 403 -018- 538 - 210000 403 -018 -538- 220000 403 -018- 538 - 220100 403 -018 -538- 230000 403 - 018- 538 - 240000 403 -018- 538 - 310000 403-018-538-310100 403 -018- 538 - 314200 403 - 018 -538- 330000 403 -018- 538 - 410000 403 -018 -538- 420000 403 -018 -538- 450000 Expenditures Regular Salaries & Wages FICA Taxes 7% Retirement Contribution 3% Retirement Match Life & Health Insurance Worker Compensation Legal Services Engineering Fees Banking Fees Professional Services Communications Service Postage General Insurance 130,000 345,960 17,000 - 318,189 22,939 - 0% - 92% - 135% 130,000 27,771 (5,939) 100% 8% -35% 492,960 341,128 - 69% 151,832 31% 14,721 14,540 - 99% 181 1% 1,126 1,105 - 98% 21 2% 1,030 983 - 95% 47 5% 442 442 - 100% 0 0% 1,963 1,924 - 98% 39 2% 347 263 - 76% 84 24% 10,000 9,224 - 92% 776 8% - 27,054 3,575 100% (30,629) 0% 1,100 1,029 - 94% 71 6% 31,290 572 - 2% 30,718 98% 560 317 - 57% 243 43% 150 108 - 72% 42 28% 6,400 6,401 - 100% (1) 0% 21 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10 4U3 -U18- 538 - 461000 Systems Maintenance 218,765 109,618 81,934 88% 27,213 12% 403 - 018 - 538 - 462000 Equipment Maintenance 400 522 - 130% (122) -30% 403- 018 - 538 - 510000 Office Supplies 100 187 - 187% (87) -87% 403 -018- 538 - 520000 Operating Supplies 800 243 - 30% 557 70% 403 -018- 538 - 524000 Motor Fuel & Lubricants 600 427 - 71% 173 29% 403 -018- 538 - 525000 Small Tools 100 - - 0% 100 100% 403 -018- 538 - 540000 Memberships & Training 700 356 - 51% 344 49% 403- 018 - 538 - 630000 Capital - Infrastructure 130,000 109,954 - 85% 20,046 15% 403 - 018 - 538 - 631001 Capital.- Canaveral Ditch 6,000 6,000 - 100% - 0% 403 -018- 538 - 640000 Capital - Machinery and Equip. - 269 - 100% (269) 0% 403 - 018 -538- 990000 Contingency 66,366 - - 0% 66,366 100% 492,960 291,538 85,509 76% 115,913 24% 41 City of Cape Canaveral ORD. NO. 15-2010 Adopted 11 -04 -2010 Expense vs. Budget Attachment Quarter Ended 09/30/10