Loading...
HomeMy WebLinkAboutOrdinance No. 11-2009ORDINANCE NO. 11 -2009 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, 2008, AND ENDING SEPTEMBER 30, 2009; 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, 2008, and ending September 30, 2009, 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 1st day December, 2009. Angela pperson =Clerk APP O ED AS TO FORM: Anthony A. Garganese, City Attorney Rocky Randels, Mayor FOR Bob Hoog Secon Buzz Petsos Motion Rocky Randels g Shannon Roberts X Betty Walsh X 00LIV Oi.�il l First Reading: 11/17/2009 Second Reading: 12/01/2009 ° m u j to R a Lnm Ln M O m n Ln N H 1l 0 0 m o o Ln m O N O m m a co It H O O m Tr 0 n H cP �.o rq 1- d Ln m o ' Ln o o Ln m m m m O M r O N N 00 m' O H' N m N M N d N N IM e w 14 m dam' N N N d 0 +- L71 0 ° . C o � � M a .ma W en CD a eq C L]p a a CM - E c° < O 0 M r-I Ln . 'a � N to m Q � M OJ 00 1 = p L= v o a m a L N o N r 4 � 0 a ro a p 00 o u 00 Q Li O CO m H U L O O �. N L E U V} 0 Lv x e �> C � a U L h � x to rp C z 0 C 0 m c 0 o a 66 a Ln M O m n Ln N H 1l 0 0 m o o Ln m O N O m m a co It H O O m Tr 0 n H cP �.o rq 1- d Ln m o ' Ln o o Ln m m m m O M r O N N 00 m' O H' N m N M N d N N IM e w 14 m dam' N N N d 0 +- W a t= � o. 4+ O c v m a ro 00 a N > a 0 Lv x e �> C � a U Ls LLI x � C rn 0 0 o`_ 0 o a 66 a a • n a Lf o O O Eo L a v a LL pp �, a X ++ a r4 4= u +� ? a N Ln j L N c O 0 F- @ M o a �- a sA G N _ u 3 v w° L D L Ln ID o o r1 d o o o 0 N N 0 o 5 i= N �t O n n H O 0 o o fn •O o 06 Ln o C E L!7 d' [i o C to o tD m m rn co ' O r - N N I .__+ .__. .__. N !` V Q . ¢ oc n ° Lx ii U 0 ea a u y Ln Ln Lx 00 0 In Liz Ln m O Ln H O Ln Ln ri O O H N N ri O O O Ln - O H Ql O LL[ O 1� N H O O N' N Oo Ln O m a - N 01 N H ci H ci Rzf m n ri r-I ri d' H H H N LL. O O N O O O r-I r-1 ri ri N r-1 r1 m V' m Ln m Ln m m -;I- H Ln 4 Ln H tD 00 m . O Ln O O n L M O r O b m m �t O n m 00 ' m m O f� O � N O P O O N H ri m O ' - O 'I �* r-1 LD r rI rI ri ri H o ri ri - m m N' m m m -gr t.0 1-1 to I- L O ro I I -i ri T 40 m m m m m m m m N r-1 m ri m Ln t7 Ln Ln Ln Ln a O a a r- ` 0 0 0 0 0 0 0 a o o •• H H H ri - O a a o 0 0 0 0 0 0 0 0 0 0 o a 0 0 0 0 a 0 0 0 0 0 0 0 0 0 0 0 0 a� . 0 0 0 0 .� ri A ri c-i H H ri ri ri ri A 0 H A f= ref r•I H H C 0 0 0 0 0 o O a o to 0 a 0 0 a a a a 0 a 0 0 0 0 o O O M a 0 0 0 0 O E o 0 0 o E M a a 0 cn m M m +- W t= � 4+ O c v m a ro a N > a 0 Lv x e �> C � a U Ls LLI x � C � a W E o`_ r�o a 66 O a • n a Lf o O O Eo L a v a LL pp �, a X ++ a r4 4= u +� ? a Ln j L c 0 0 F- @ aL o a �- a sA G _ u 3 v w° L D L U) ID o �a N N L° o 5 i= ,.°- C o N L O O O 0 U m fn •O r 06 � ` E 0 i7 V Q ¢ ¢ oc n ° Lx ii U 0 ea a u y Lx CL O Ln Ln O O O H N O ri O O O O O O O O LL[ O H N H O O N N Oo Ln O a a N a ci H ci Rzf m n ri r-I ri d' H H H N LL. O O O O O O r-I r-1 ri ri N r-1 r1 m V' m Ln m Ln m Ln m m -;I- H Ln 4 Ln H tD tD tD m . O Ln N tD O 00 O v i m m LrL m m m m m m m m m m m dT 7 c� LD O r-1 ri N H d' Ln Ln Ln m 'I �* r-1 LD r rI rI ri ri o ri ri H m m m m m -gr Ln Ln to Lo a " ri ri r9 40 m m m m m m m m m m m m m m t7 Ln Ln Ln Ln a O a a a 0 0 0 0 0 0 0 a o o •• H H H ri - O a a o 0 0 0 0 0 0 0 0 0 0 o a 0 0 0 0 a 0 0 0 0 0 0 0 0 0 0 0 0 0 . 0 0 0 0 .� ri A ri c-i H H ri ri ri ri A ri H A f= ref r•I H H C 0 0 0 0 0 o O a o a 0 a 0 0 a a a a 0 a 0 0 0 0 o O O o a 0 0 0 0 O E o 0 0 o E a a m -u W U IV In M < rh r O O N 1D O O Ln m W m O r♦ O d' m N Ln m c � N m W. O N O 0 Ln O O O rs m 0 m Ln O O O m m O m mt.0 N Ln r-I ZF Ln L6 N M rri N Ln L4 Ln r-L m It M CD o . ao 00 r- o an c o W M N �m cm O 0 0 ° o J m m m Q O Co Ln N w - L LSO rI M M r1 O1 °m m o LO - M ri c m -c O d O o M m 0 0 O O 0 N tea d ri N' rri � M 00 = to C i N m a [V - 7 ca � 00 0) r-L O o m Ln o N = o Ln Ln o n O C u n LLn O O .: r�-L w -. O 1 M O Ln m L N 1 N G c r: N .r o m ai r- N - - r - N d' - o N of rn� n' \ m - U) m Q ti m Qj 07 N _ Cc V L p Ln M O r ti - LMT! -_ (n 7 LA L Qi L Y � N to ro C � d r L ) ' u _ u C is LLI E u C LU co : CL to co C cn aJ +� Ol .Q O v> U 4J u a C [G @ y _} > N L �w, G Q7 d � CL Lu 4 - �- ra C In L]b 0 L w m c L " C U a U N C c C d6 C - y - j N Lv E C Y L Q� R r/i }+ `S 7 y+ v VI In w C7 L -C O_ ' d7 C 1 v L_7 L C w Y Y � 'a O x cr °J d a 7 O a L 6 L3 1 0) c C L 4! 6 'r- z a m C d - Q w Lu O 2 B . u x 4L Lu fre D CL L.d a- l'_7 Lu d d u c LL] ? x LU ° o ° o 0 ° O ° o ° o d 0 0 0 0 0 0 m ° o ° o ° o ° 0 ° o ° O z ' O N O O , y 0 0 m o N 0 N o O V 0 O 0 O 0 N 0 O 0 rq 0 0 �C .-3 r� LO 7 N Ln ci Ln cr m Ln I FA 2 0 1 d � r L � a) w m m Ln I Lo d' r, d' m 1 d Lp 3 m ri m r-I m r-I m ri ri N r+ N N N N N N N s., 4 N 4 N cr N 4 N 4 N d N E y L � L? T KI T Ll a T Ln V1 L 1 LtfL LA Ln Ln N V N O N O N O N O V y O O -O y Ln O Ln O Ln 0 y L.O O LD O Lo O LO O lD O LO O -a N 0 0 0 0 . 0 0 -� O O O . O 0 0 0 0 0 0 ri o ri 0 H O C d O o C m ri 0 ci 0 ri 0 G a H 0 H 0 ri 0 H 0 t-1 0 ri 0 C w 0 o 0 o o o E O o o E 0 0 0 0 0 0 E a a a a It City of Cape Canaveral Budget Transfer Summary for FY 2008/2009 - Amended 11/3/09 Legal Services 001-013-514-310000 Legal Services 001-013-514-312001 Specialized Legal Services 001-013-514-450000 General Insurance Amended Legal Services Expenditures Garbage Service 001-014-534-433000 Dumping Charges Amended Garbage Service Expenditures 60,000 32,800 92,800 25,000 3,500 8,000 36,500 300 300 600 44,600 3,200 (2,600) 600 (2,600) 5 10/1/2008 12/31/2008 3/31/2009 6/30/2009 9/30/2009 Adjusted Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend, Balance Streets. Department 001-007-541-120000 Salaries & Wages 296,639 (50,000) 9,000 255,639 001-007-541-210000 FICA Taxes 22,798 (3,825) 18,973 001-007-541-220000 7% Retirement Contribution 20,765 (3,500) 17,265 001-007-541-330000 Professional Services 3,500 (3,500) - 001-007-541-450000 General Insurance 30,845 (7,500) 23,345 001-007-541-630000 Capital -Infrastructure - 6,250 6,250 001-007-541-640000 Capital -Machinery and Equipment - 1,395 1,395 Amended Streets Department Expenditures (51,680) Parks. & Recreation 001-011-572-450000 General Insurance 14,465 (3,000) 11,465 001-011-572-462000 Equipment Maintenance 525 600 001-011-572-520000 Operating Supplies 7,000 3,100 3,700 1,125 13,800 001-011-572-520500 Athletic League Supplies 3,500 (1,500) 2,000 001-011-572-521100 Special Events 8,550 (600) (1,700) 6,250 001-011-572-521600 Summer Recreation Program 4,000 (196) 3,804 001-011-572-630000 Capital - 5,800 5,800 Amended Parks & Recreation Expenditures 6,204 Legal Services 001-013-514-310000 Legal Services 001-013-514-312001 Specialized Legal Services 001-013-514-450000 General Insurance Amended Legal Services Expenditures Garbage Service 001-014-534-433000 Dumping Charges Amended Garbage Service Expenditures 60,000 32,800 92,800 25,000 3,500 8,000 36,500 300 300 600 44,600 3,200 (2,600) 600 (2,600) 5 City of Cape Canaveral Budget Transfer Summary for FY 2008/2009 - Amended 11/3/09 Amended General Fund Revenues (1,396,994) Amended General Fund Expenditures (1,396,994) Beautification Fund Expenditures 105-015-541-632000 Capital -AIA Landscape 40,000 5,250 45,250 105-015-541-990000 Contingency 34,659 (5,250) 29,409 Amended Beautification Fund Expenditures O 10/1/2008 12/31/2008 3/31/2009 6/30/2009 9/30/2009 Adjusted Beginning Budget Budget Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Amend. Balance Cultural Development Board 001-016-515-480000 promotional Activities 6,000 5,000 11,000 Amended Commercial Dev. Board Expenditures 5,000 Non -Departmental 001-017-901-462000 Equipment Maintenance - 2,500 2,500 001-017-901-620000 Capital - Buildings - 5,000 5,000 001-017-901-630100 Capital - Streets 1,624,508 (174,000) (1,288,000) 162,508 001-017-901-990000 Contingency 130,325 (83,502) (32,867) 107,871 154,351 276,178 Amended Non -Departmental Expenditures (1,308,647) Amended General Fund Revenues (1,396,994) Amended General Fund Expenditures (1,396,994) Beautification Fund Expenditures 105-015-541-632000 Capital -AIA Landscape 40,000 5,250 45,250 105-015-541-990000 Contingency 34,659 (5,250) 29,409 Amended Beautification Fund Expenditures O City of Cape Canaveral Budget Transfer Summary for FY 2008/2009 - Amended 11/3/09 10/1/2008 12/31./2008 3/31/2009 6/30/2009 Beginning Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Capital Expansion Fund Revenues 302-000-300-300104 Cash Forward -Parks and Rec Amended Capital Expansion Fund Expenditures Capital Expansion Fund Expenditures 302-026-572-600720 Capital -Parks and Rec 302-026-572-990072 Contingency -Parks and Rec Amended Capital Expansion Fund Expenditures 1,500 2,600 1,500 7 1,500 3,500 (2,000) 9/30/2009 Budget Amend. Adjusted Budget Balance 3,500 600 City of Cape Canaveral Budget Transfer Summary for FY 2008/2009 - Amended 11/3/09 10/1/2008 12/31/2008 3/31/2009 6/30/2009 Beginning Budget Budget Budget Line Item Account Name Balance Amend. Amend. Amend. Sewer Enterprise Fund Revenues 401-000-343-343510 Utility Operating Income 401-000-361-361110 Interest Income - Expansion Funds 401-000-361-361140 Interest Income - Revenue Funds Amended Sewer Enterprise Fund Expenditures (60,000) Sewer Enterprise Fund Expenditures 401-010-535-314000 Physicals 401-010-535-340000 Contract Services 401-010-535-520000 Operating Supplies 401-010-535-520001 Safety Supplies 401-010-535-521000 Chemicals 401-010-535-540000 Memberships & Training 401-010-535-630800 Capital - Force Main 401-010-535-631000 Capital - Collection System 401-010-535-640000 Capital Equipment 401-010-535.990000 Contingency Amended Sewer Enterprise Fund Expenditures (60,000) 2,857,565 37,900 32,370 Soo 550 9,000 2,000 69,000 3,157 206,711 (23,000) (22,000) (15,000) 660 (800) 800 20,000 1,700 4,830 2,230 1,060 (8,120) (64,360) (20,000) 9/30/2009 Budget Amend. Adjusted Budget Balance 2,834,565 15,900 17,370 1,210 9,800 4,000 89,000 4,857 4,830 2,230 1,060 114,231 City of Cape Canaveral Budget Transfer Summary for FY 2008/2009 - Amended 11/3/09 10/1/2008 12/31/2008 3/31/2009 6/30/2009 Beginning Budget Budget Budget Line item Account Name Balance Amend. Amend. Amend. Stormwater Enterprise Fund Revenues 403-000-300-300100 Cash Forward 403-000-334-334361 SJRWMD Grants 403-000-361-361100 Interest Income from Investments Amended Stormwater Enterprise Fund Revenues Stormwater Enterprise Fund Expenditures 403-018-538-461000 System Maintenance 403-018-538-462000 Equipment Maintenance 403-018-538-630000 Capital -Infrastructure 403-018-538-631001 Capital -Canaveral Ditch 403-018-538-640000 Capital -Equipment 403-018-538-990000 Contingency Amended Stormwater Enterprise Fund Expenditures 102,600 115,000 24,000 (115,000) 6,800 (115,000) (6,800) 47,700 95,000 200 1,000 104,100 27,845 503,000 (240,000) - 1,100 29,316 (27,845) 125,000 (97,100) (115,000) i 9/30/2009 Budget Amend. Adjusted Budget Balance 109,400 17,200 142,700 1,200 131,945 263,000 1,100 29,371 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Descr�ptioh 200 Budget 'a: End';Balance Variance ' g° Collected or Used 10 Revenue 001 -000- 300 - 300100 Cash Forward (1,328,405) - (1,328,405) 0% 001-000-311-311111 Ad Valorem- Police Service (1,808,049) (1,808,160) 111 100% 001-000-311-311112 Ad Valorem - Fire/Rescue (1,622,853) (1,622,880) 27 100% 001 - 000 - 311 - 311115 Ad Valorem - Police - Delinquent (23,625) (30,084) 6, 459 127% 001-000-311-311125 Ad Valorem - Fire - Delinquent (21,100) (26,757) 5,657 127% 001 - 000 - 312 - 312410 Local Option Gas Tax (230,733) (275,700) 44,967 119% 001 -000- 313 - 313100 FPL Franchise Fees (736,132) (683,523) (52,609) 93% 001 -000- 313 - 313300 City Gas Corp Franchise Fees (32,000) (33,751) 1,751 105% 001- 000- 313 - 313700 Waste Mngt. Franchise Fees (30,000) (9,925) (20,075) 33% 001 -000- 314 - 314100 FPL Utility Tax (651,572) (675,207) 23,635 104% 001 -000 - 314 - 314400 Bottled Gas Utility Tax (30,000) (29,439) (561) 98% 001 - 000 -315- 315100 Communications Service Tax (595,362) (606,425) 11,063 102% 001- 000- 319 - 319122 Tax Penalty- Fire/Rescue (2 ,000) (3,737) 1,737 187% 001 - 000 -319- 319212 Tax Penalty - Police (1,500) (4,211) 2,711 281% 001 - 000 -321- 321100 Local Business Tax (67,000) (67,790) 790 101% 001- 000 - 321 - 321110 County Business Tax (6,000) (6,636) 636 111% 001 -000- 322 - 322100 Building Permits (75,000) (72,645) (2,356) 97% 001 -000- 329 - 329100 Fire Alarm Permits (2,000) (2,415) 415 121% 001 - 000 - 329 - 329200 Fire Inspection Fees (10,000) (13,960) 3,960 140% 001 - 000 -329- 329300 Community Appearance Fees (1,000) (480) (520) 48% 001 - 000 - 329 - 329301 Zoning Fees (1,000) (750) (250) 75% 001 -000 -331- 331500 Federal Disaster Relief - (24,458) 24,458 100% 001 -000- 334 - 334500 State Disaster Relief - (4,139) 4,139 100% 001 - 000 - 334 - 334700 Recreation Grant (112,497) (112,500) 3 100% 001 - 000.335- 335121 State Sales Tax Revenue Share (162,505) (159,225) (3,280) 98% 001 -000- 335 - 335122 Municipal Gas Tax (58,982) (57,792) (1,190) 98% 001 -000- 335 - 335140 Mobile Home Licenses (4,400) (5,023) 623 114/ 001 -000- 335 - 335150 Alcoholic Beverage License (9,500) (10,770) 1,270 113% 001 - 000 - 335 - 335180 Local 112 Cent Sales Tax (463,041) (465,221) 2,180 100% 001 - 000 -338- 338201 County EMS Revenue Share (35,000) (37,656) 2,656 108% 001 - 000 - 341 - 341300 Sales of Maps & Publications (100) (9) (91) 9% 001- 000 - 341 - 341400 Copies of Ord. & Photo Copies (200) (177) (23) 88% 001- 000 - 342 - 342101 Investigative Fees (30,000) (34,760) 4,760 116% 10 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Descr�ptorr 20 ©9 Budget - l End Balance Variance used 001 -000- 343 - 343400 Garbage Revenue (727,152) (715,336) (11,816) 98% 001- 000 - 343 - 343450 Recycling Fee Revenue (189,146) (175,647) (13 ,499) 93% 001 -000- 343 - 343901 Lot Clearing and Mowing Fees (500) (2,120) 1,620 424% 001- 000 -347- 347211 Recreation Programs (7,775) (11,594) 3,819 149% 001 -000- 347 - 347260 Tennis Court Rentals (5,250) (5,379) 129 102% 001 - 000- 347 - 347291 Racquetball Court Rentals (11,400) (4,030) (7,370) 35% 001 -000- 347 - 347292 Shuffleboard Court Rentals (2,175) (1,820) (355) 84% 001 - 000 -347- 347293 Tournament Income (9,500) (9,560) 60 101% 001 - 000 - 347 - 347295 Recreation Equipment Rentals (125) (71) (54) 56% 001- 000 - 347 - 347296 Tennis /Racquetball League Inc. (7,400) (5,837) (1,563) 79% 001 -000- 347 - 347297 Athletic League Income (11,550) (6,179) (5,371) 53% 001 -000- 347 - 347298 Summer Camp Registration (4,125) (4,635) 510 112% 001 -000- 347 - 347490 Recreation Special Events (100) (139) 39 139% 001 - 000 - 347 - 347590 Recreation Facility Rental (3,950) (4,855) 905 123% 001 - 000 - 351 - 351100 Fines & Forfeitures (20,517) (27,606) 7,089 135% 001 -000- 351 - 351101 Fines - Parking Tickets (8,283) (15,655) 7,372 189% 001 - 000 -354- 354100 Violations of Local ordinances (21,000) (28,378) 7,378 135% 001- 000 - 360- 360300 Recreation Retail Sales (300) (58) (242) 19% 001 -000- 360- 360400 Promotional Items For Resale (150) (6) (144) 4% 001 -000- 360- 360410 Concurrency Management Fees (1,000) (160) (840) 16% 001- 000 -361- 361100 Interest From Investment (122,000) (137,086) 15,086 112% 001 -000- 361- 361310 Interest Tax Coll - Police (3,000) (594) (2,406) 20% 001 -000 -361 - 361311 Interest Tax Coll - Fire (1,875) (533) (1,342) 28% 001 - 000 -364- 364490 Sale of Fixed Assets (2,000) (3,100) 1,100 155% 001 -000 -366- 366220 Contributions- Private Sources (3,598) (4,665) 1,067 130% 001 - 000 - 369 - 369100 Miscellaneous Income (3,000) (5,768) 2,768 192% 001 -000- 369- 369200 Plan Review Income (9,680) (14,609) 4,929 151% 001- 000 - 369- 369300 Refund of Prior Year Expense (1,000) (3,143) 2,143 314% 001 - 000- 380 - 380100 Transfer From Sewer Fund (125,000) (125,000) - 100% - 9,454,107 - 8,199,762 - 1,254,345 87% Less Cash Forward 1,328,405 -8,125,702 % Collected without Cash Fwd. 100.91% 11 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 { Collecaed or Account Number Description - 2009 Budget. Entl Balance Variance - _ uSEd There are a number of variances worth noting: Local Option Gas Tax, FPL Utility Tax and Communication Services Tax were collected above projections. The City received FEMA funding for Hurricane Fay The City received less than projected revenues for FPL Franchise Fees, Garbage and Recycling Revenues and Waste Management Franchise Fees. While the noted variances are material, when combined, they balance out and no changes will be made. Cash Forward is reduced as these funds were budgeted to provide the funding for the Ridgewood Avenue Project. This project has been pushed forward to the FY 09110 budget. 12 City or` Cape Canaveral Expense vs Budget Account Nu6:e, 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 -511- 493000 001 -001- 511 - 510000 001 - 001 -511- 520000 001 - 001 - 511 - 540000 001-001-511-640000 Quarter Ended 9/30/2009 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.. No adjustments made to this department. Legislative -:4o Cofleeted or �� 12,800.00 12,800.04 (0) 100% 979 979.2 (0) 100% 47 23.12 24 49% 7,000.00 2,020.26 4,980 29% 4,000.00 4,778.60 (779) 119% 540 506.24 34 94% 2,500.00 2,325.00 175 93% 43,375.00 41,607.52 1,767 96% 2,000.00 136.38 1,864 7% 7,000.00 2,960.30 4,040 42% 10,000.00 655.66 9,344 7% 4,000.00 3,462.20 538 87% 1,000.00 801.86 198 80% 5,000.00 5,801.49 (801) 116% 5,000.00 5,657.95 (658) 113% 2,915.00 3,133.37 (218) 107% 108,156 87,649 20,507 81% 13 City Of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Rescnpt�on - 2009 Budget = End'Balance` Variance � Collected or :. Used Administration 001 - 002 -513- 110000 Executive Salaries 287,759.00 302,615.15 (14,856) 105% 001 -002- 513 - 140000 Overtime 567 1,642.45 (1,075) 290% 001 002 - 513 - 210000 FICA Taxes 22,057.00 22,588.63 (532) 102% 001 -002 -513- 220000 7% Retirement Contribution 20,143.00 19,593.28 550 97% 001 - 002 - 513 - 220100 3% Retirement Match 8,633.00 6,493.88 2,139 75% 001 -002- 513 - 230000 Life & Health Insurance 33,198.00 30,820.42 2,378 93% 001 -002- 513 - 240000 Worker Compensation 1,036.00 784.74 251 76% 001 - 002 - 513 - 314000 Physicals 150 104 46 69% 001- 002 - 513 - 320000 Audit Expense 21,299.00 21,300.00 (1) 100% 001 - 002 - 513 - 340000 Contract Services 6,500.00 8,271.80 (1,772) 127% 001 - 002 -513- 400000 Travel & Per Diem 1,000.00 341.43 659 34% 001 - 002 -513- 410000 Communications Service 3,840.00 3,932.09 (92) 102% 001 -002 - 513 - 420000 Postage 4,000.00 2,630.39 1,370 663 001 -002- 513 - 430000 Utilities 9,380.00 6,749.36 2,631 72% 001 -002- 513 - 440000 Rentals And Leases 430 635.6 (206) 148% 001 - 002 - 513 - 450000 General Insurance 11,065.00 11,049.57 15 100/ 001- 002- 513 - 462000 Egvip.ment Maintenance 15,961.00 17,517.01 (1,556) 110% 001 -002- 513 - 470000 Printing 1,150.00 1,187.61 (38) 103% 001- 002 - 513 - 510000 Office Supplies 2,450.00 1,860.38 590 76% 001- 002- 513 - 520000 Operating Supplies 10,000.00 15,489.91 (5,490) 155% 001 -002 - 513 - 524000 Motor Fuel & Lubricants 500 265.41 235 53% 001- 002 - 513 - 540000 Memberships & Training 4,300.00 4,670.98 (371) 109/ 001 - 002 - 513 - 640000 Capital - Machinery and Equip.. 5,000.00 4,463.08 537 89% 470,418 485,007 (14,589) 103% Executive Salaries are increased to reflect the increase required for payout when the City Clerk resigned. Operating Supplies is increased to provide the funding to replace the computer for the Clerk's Office Administrative Assistant. 14 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Accaunt Ngmber Description 2009 Budget- End SaJance Variance Collected or Used Public Safety (Police) 001- 004 -521- 120000 001 -004 -521- 140000 001 -004- 521 - 210000 001 -004- 521 - 240000 001- 004 -521- 314000 001 - 004 -521- 340000 001 -004 - 521 - 341000 001 - 004- 521- 345000 001 -004- 521 - 345500 001 - 004 - 521 - 400000 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 Regular Salaries & Wages Overtime FICA Taxes Worker Compensation Physicals Contract Services - BCSO Community Policing Collection Surcharge State Attorney Dispositions Travel & Per Diem Communications Service Utilities General Insurance Operating Supplies Uniforms Memberships & Training Capital - Machinery and Equip 16,923 16,040 883 95% - 165 (165) 100/ 1,295 1,240 55 96% 825 510 315 62% 220 - 220 0% 2,589,143 2,564,569 24,574 99% 9,000 1,268 7,732 14% 4,000 9,320 (5,320) 233% 1,800 140 1,660 100% - 25 (25) 100% 960 484 476 50% 14,930 13,707 1,223 92% 29,665 29,964 (299) 101/ 3,000 510 2,490 17% 500 - 500 0% 200 - 200 0% 113,880 88,118 25,762 77% 2,786,341 2,726,061 60,280 98% The Contract has been reduced by $24,574 due to accumulated interest earnings incurred through the timing of usage of funds. 15 City of Cape Canaveral Expense vs Budget 001 - 005 - 522 - 240000 001 - 005 - 522 - 340000 001 - 005 -522- 341101 001 - 005 -522 - 341500 001 -005- 522 - 420000 001 -005- 522 - 441000 001 -005- 522 - 450000 001 -005- 522 - 462000 001 -005- 522 - 641000 001 -005- 522 - 642000 Worker Compensation Contract Services - CCVFD LOSAP Retirement Program Fire Engineering Fees Postage Fire Hydrant Rent General Insurance Equipment Maintenance Fire Fighting Equipment Capital - Machinery and Equip 44,000 24,728 19,272 56% 1,274,228 1,274,228 - 100% 10,000 5,895 4,105 59% 2,000 345 1,655 17% 750 326 424 44% 40,296 46,435 (6,139) 115% 36,000 32,592 3,408 91% 29,990 52,040 (22,050) 174% 22,000 20,187 1,813 92% 364,392 - 364,392 0% 1, 1,456,777 366,879 80% While this department budget is only expensed out at 80 %, in order to keep the Reserve funding intact the Equipment Maintenance account has been increased to fund charges from Brevard County Emergency Management for 800 MHz radio system maintenance. 16 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account 11fLmber gescriptan 2009 Budget Ehd BaEance ' Variance �° Co[fected or Used No adjustment made to this department. 17 Community Development 001 - 006- 524 - 120000 Regular Salaries & Wages 388,291 401,954 (13,663) 104% 001- 006 - 524 - 140000 Overtime 4,559 3,060 1,499 67% 001- 006 - 524 - 210000 FICA Taxes 30,053 30,842 (789) 103% 001 -006- 524 - 220000 7% Retirement Contribution 23,813 24,647 (834) 104% 001 -006 -524- 220100 3% Retirement Match 11,649 6,772 4,877 58% 001 -006- 524 - 230000 Life & Health Insurance 52,104 49,212 2,892 94% 001 - 006 -524- 240000 Worker Compensation 14,999 9,714 5,285 65% 001 -006- 524 - 310000 Legal Services 61,100 46,898 14,202 77% 001 - 006 - 524 - 314000 Physicals 300 - 300 0% 001 - 006 - 524 - 330000 Professional Services 55,000 44,760 10,240 81% 001- 006 - 524 - 400000 Travel & Per Diem 3,140 863 2,277 27% 001 -006- 524 - 410000 Communications Service 5,500 5,303 197 96% 001 -006- 524 - 420000 Postage 5,981 3,399 2,582 57% 001 - 006 - 524 - 430000 Utilities 4,300 4,712 (412) 110% 001 - 006 -524- 450000 General Insurance 6,935 7,923 (988) 114% 001 - 006 - 524 - 462000 Equip.ment Maintenance 12,355 14,557 (2,202) 118% 001 - 006 -524- 470000 Printing 3,600 1,334 2,266 37% 001 - 006 - 524 - 491000 Publishing 3,200 641 2,559 20% 001 - 006- 524 - 510000 Office Supplies 2,000 1,551 449 78% 001 - 006 - 524 - 520000 Operating Supplies 9,500 7,651 1,849 81% 001 - 006 - 524 - 523000 Uniforms 985 81 904 8% 001 -006- 524 - 524000 Motor Fuel & Lubricants 2,637 1,925 712 73% 001- 006 - 524 - 540000 Memberships & Training 4,925 3,245 1,680 66% 001 - 006 - 524 - 640000 Capital - Machinery and Equip.. 2,500 1,466 1,034 59% 709,426 672,508 36,918 95% No adjustment made to this department. 17 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account NumE er . 0estrip ion 2i}09`Sudget End Balance: Vana�ce , -% Collected or Use Streets 001- 007 - 541 - 120000 Regular Salaries & Wages 246,639 275,988 (29,349) 112% 001 -007- 541 - 140000 Overtime 1,376 1,565 (189) 114% 001 -007 -541- 210000 FICA Taxes 18,973 20,895 (1,922) 110% 001- 007 - 541 - 220000 7% Retirement Contribution 17,265 20,234 (2,969) 117% 001- 007 -541- 220100 3% Retirement Match 8,899 7,844 1,055 88% 001 -007 -541 - 230000 Life & Health Insurance 60,860 48,992 11 ,868 80% 001- 007 -541- 240000 Worker Compensation 22,715 12,519 10,196 55% 001 - 007 -541 - 340000 Contract Services - 1,710 (1,710) 100% 001- 007 -541- 400000 Travel & Per Diem 320 5 316 1% 001 - 007 - 541 - 410000 Communications Service 1,640 3,773 (2,133) 230% 001 - 007 - 541 - 420000 Postage 100 18 82 18% 001- 007 - 541 - 432000 Street Lights 63,500 66,344 (2,844) 104% 001 - 007 - 541 - 450000 General Insurance 23,345 23,552 (207) 101% 001 -007- 541 - 461000 Building & Grounds Maintenance 19,650 19,488 162 99% 001 - 007 -541- 462000 Equip.ment Maintenance 11,600 11,321 279 98% 001 - 007 - 541- 510000 Office Supplies 750 - 750 0% 001 - 007 - 541 - 520000 Operating Supplies 9,000 10,443 (1,443) 116% 001 -007- 541 - 523000 Uniforms 3,490 3,171 319 91% 001- 007 - 541 - 524000 Motor Fuel & Lubricants 12,000 10,979 1,021 91% 001 -007- 541 - 525000 Small Tools 1,200 1,091 109 91% 001 - 007 - 541 - 530000 Street Repairs 34,940 32,527 2,413 93% 001 - 007 - 541 - 532000 Traffic Light Repair 1,200 874 326 73% 001- 007 - 541 - 533000 Street Signs 1,700 2,368 (668) 139% 001- 007 - 541 - 540000 Memberships & Training 320 342 (22) 107% 001 - 007 -541- 630000 Capital - Infrastructure 6,250 - 6,250 0% 001 - 007 -541- 640000 Capital - Machinery and Equip.. 1,395 1,395 - 100% 569,127 577,438 (8,311 101% Salaries and Wages is increased to cover the excess over budget. 18 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number =Jsed Description 20119 Budget End Balance Variance %Collected or'; Parks and Recreation 001 - 011 - 572 - 120000 Regular Salaries & Wages 174,852 190,325 (15,473) 109% 001 -011- 572 - 140000 Overtime - 83 (83) 100% 001 - 011 -572- 210000 FICA Taxes 13,376 14,545 (1,169) 109% 001 - 011 - 572 - 220000 7% Retirement Contribution 12,240 9,960 2,280 81% 001 - 011 - 572- 220100 3% Retirement Match 5,246 3,984 1,262 76% 001 - 011 - 572 - 230000 Life & Health Insurance 21,627 20,948 679 97% 001 -011 -572- 240000 Worker Compensation 7,659 5,303 2,356 69% 001-011-572-314000 Physicals 150 145 5 97% 001 - 011 - 572 - 340000 Contract Services- Umpires 12,000 4,495 7,505 37% 001 - 011 -572- 343000 Lifeguard Contract 18,721 18,721 - 100% 001 -011- 572 - 400000 Travel & Per Diem 200 59 142 29% 001 - 011 - 572 - 410000 Communications Service 1,350 1,016 334 75% 001 - 011 -572- 420000 Postage 275 100 175 36% 001-011-572-430000 Utilities 12,000 11,971 29 100% 001 -011- 572- 450000 General Insurance 11,465 11,168 297 97% 001 - 011 -572- 461000 Building & Grounds Maintenance 4,100 2,395 1,705 58% 001 - 011 -572- 462000 Equipment Maintenance 1,125 1,549 (424) 138% 001 - 011 - 572 - 510000 Office Supplies 650 190 460 29% 001 - 011 - 572 - 520000 Operating Supplies 13,800 13,400 400 97% 001 -011- 572 - 520500 Athletic League Supplies 2,000 1,891 109 95% 001 - 011 - 572 - 521100 Special Events 6,250 6,798 (548) 109% 001 -011- 572 - 521600 Summer Recreation Program 3,804 3,478 326 91% 001 -011- 572 - 523000 Uniforms 350 - 350 0% 001- 011 -572- 524000 Motor Fuel & Lubricants 1,050 352 698 34% 001 - 011 - 572 - 528010 Tournament Expense 7,200 7,166 34 100% 001- 011 - 572 - 540000 Memberships & Training 400 456 (56) 114% 001- 011 - 572 - 630000 Capital - Infrastructure - 5,800 (5,800) 100% 001 - 011 - 572 - 631200 Capital - City Park 7,610 7,645 (35) 100% 339,500 343,941 (4,441) 1 0 1 % An unbudgeted replacement of the air conditioner at the Recreation Complex was required. Salaries were higher than budgeted due to the increased hours for Summer Recreation. No adjustment was done. 19 121,900 129,550 ( 106% Specialized Legal Services are increased to cover the actual expenditures. Solid Waste 001- 014- 534 - 342000 City of Cape Canaveral 727,152 700,343 26,809 Expense vs Budget 001- 014 - 534 - 342010 Contract Recycling Service 189,146 Quarter Ended 9/30/2009 19,148 90% Account 1Vumi�er Description 2049yBudget End Balance Vanance Collected or 77 87% 001 -014- 534 - 491000 Used 1,200 Legal Services 73 94% 001-013-514-310000 Legal Services 92,800 90,819 1,981 98% 001 - 013 -514- 312001 Specialized Legal Services 28,500 38,124 (9,624) 134% 001 - 013 -514- 450000 General Insurance 600 607 (7) 101% 121,900 129,550 ( 106% Specialized Legal Services are increased to cover the actual expenditures. Solid Waste 001- 014- 534 - 342000 Contract Garbage Service 727,152 700,343 26,809 96% 001- 014 - 534 - 342010 Contract Recycling Service 189,146 169,998 19,148 90% 001 -014- 534 - 433000 Dumping Charges 600 523 77 87% 001 -014- 534 - 491000 Publishing 1,200 1,127 73 94% 918,098 871,991 4 6,107 95% No adjustment made to this department. Business & Cultural Development 001 - 016 -515- 420000 Postage 300 13 287 4% 001 -016- 515 - 480000 Promotional Activities 11,000 5,714 5,286 52% 001-016-515-520000 Operating Supplies 350 134 216 38% 001- 016 -515•- 540000 Memberships & Training 500 903 (403) 181% 12,150 6, 764 5,386 56 No adjustment made to this department. 20 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Description, 2Ud9 Budge# _ Erid Balar�[a Variance %ColEected or ' . Used Non - Departmental 001 -017- 901 - 140010 Special Pays 10,000 - 10,000 0% 001- 017 - 901 - 330000 Professional Services 3,000 1,138 1,862 38% 001 - 017 - 901 - 462000 Equip.. Maint. - City Network 2,500 2,325 275 93% 001 -017- 901 - 490000 Miscellaneous 2,500 250 2,250 10% 001 -017- 901 - 620000 Capital - Building 5,000 4,510 490 90% 001 - 017 - 901 - 630100 Capital - Infrastructure 1,450,508 162,500 1,288,008 11% 001 -017- 901 - 990000 Contingency 121,827 - 121,827 0% 1,595,335 170,724 1,424, 611 11% The Ridgewood Avenue project has been moved to FY 09110 budget. Contingency has been reduced to provide the increased spending within the General Fund departments. 21 City.of Cape Canaveral Kevenue 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 101- 027 -521 - 990000 Contingency No adjustment made to this fund. (950) - (950) 0% (2,000) (2,946) 946 147% (50) (105) 55 210% (3,000) (3,051) 51 102% 2,950 - 2,950 0% 50 - 50 0% 3,000 - 3,000 0% Expenditures 102 - 022 -581- 990000 Contingency 1,920 _ 1,920 0% No adjustment made to this fund. 1,920 - 1,920 0% 22 102 -000- 361- 361100 Interest From Investment (420) (468) 48 111% 102 -000- 363 - 363225 Impact Fees (1,500) (508) (992) 34% (1,920) (976) (944) 51% City Of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 %Collected or: Account Narnloer Description 2D09 Sudgei End Baf ante. Variance l 4W:Q1!V 104 -000- 311 - 311100 104- 000 - 311 - 311105 104 -000- 319- 319120 104 - 000 -361- 361100 104 -000 -361 - 361300 Ad Valorem Taxes (57,818) (57,821) 3 100% Ad Valorem Tax - Delinquent - (962) 962 100% Tax Penalty Income (25) (135) 110 539% Interest From Investment (1,320) (1,851) 531 140% Interest - Tax Collections (100) (19) (81) 19% (59,263) (60,788) 1,525 103% Expenditures 104- 023 - 571 - 450000 General Insurance 104 - 023 - 571 - 461000 Building & Grounds Maintenance 104 -023- 571 - 520000 Operating Supplies 104- 023 -571 - 990000 Contingency No adjustment made to this fund. 51,470 33,979 17,491 66% 1,500 691 809 46% 1,000 184 816 18% 5,293 - 5,293 0% 59,263 34,854 24,409 59% 23 City of Cape Canaveral 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 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 Iltevenue 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 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 (337,320) - (337,320) 0% (425,919) (425,938) 19 100% - (7,096) 7,096 100% (575) (992) 417 172% (24,000) (19,154) (4,847) 80% (800) (140) (660) 17% - (4,760) 4,760 100% (788,614) (458,079) (330,535) 58% 40,511 42,384 (1,873) 105% 1,220 - 1,220 0% 3,192 3,225 (33) 101% 2,836 2,755 81 97/0 1,215 1,176 39 97% 5,555 4,282 1,273 77% 2,035 2,685 (650) 132% 241,386 218,647 22,739 91% 250 5 246 2% 560 334 226 60% 150 69 81 46% 1,250 896 354 72% 3,500 6,035 (2,535) 172% 900 1,097 (197) 122% 250 - 250 0% 18,700 17,209 1,491 92% 8,500 - 8,500 0% 3,175 2,884 291 91% 2,500 1,987 513 79% 1,000 526 474 53% 650 640 10 98% 170,000 5,550 164,450 3% 24 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Ac count N urrtber . :. 6e . tion - 2009 Budget" End Balance Variance Collected a jr Used 105 -015- 541 - 632000 Capital - A1A Landscaping 45,250 9,567 35,683 21% 105- 015 -541 - 635000 Capital - Ridgewood Avenue 167,320 - 167,320 0% 105 -015- 541 - 640000 Capital - Machinery and Equip.. 35,000 8,756 26,244 25/ 105 -015 -541 - 820000 Aid To Private Organizations 2,300 2,300 - 100% 105 - 015 - 541 - 990000 Contingency 29,409 - 29,409 0% 788,614 333,009 455,605 42% No adjustment made to this fund. 25 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 ACCOU.nt Nur»ler l)escr�pt�o� 2009 :,Budget . end Balance Variance° Collected or Used' Capital Expansion Fund Revenue 302 -000- 300- 300104 Cash Forward - Parks/Rec. (1,500) - (1,500) 0% 302 - 000 - 361- 361150 Interest - Police (1,800) (1,651) (149) 92% 302 -000- 361 - 361160 Interest - Fire /Rescue (1,560) (1,475) (85) 95% 302-000-361-361170 Interest - Parks & Rec (2,300) (2,452) 152 107% 302 -000- 361 - 361180 interest - Library (5,400) (5,976) 576 111% 302 -000 -361- 361190 Interest - Gen. Gov't. (6,000) (6,719) 719 112% 302 -000- 363- 363221 Cap.Exp. Fees - Police (3,500) (1,091) (2,409) 31% 302 -000- 363- 363222 Cap.Exp. Fees - Fire (700) (455) (245) 65% 302 - 000- 363- 363271 Cap.Exp. Fees - Library (160) (480) 320 300% 302 -000- 363- 363272 Cap.Exp.Fees - Parks (300) (909) 609 303% 302- 000 - 363- 363291 Cap.Exp.Fees - Gen Gov't. (4,500) (1,044) (3,456) 23% (27,72 (22,252) (5,468) 80% Expenditures 302- 026 -519 - 990019 Contingency - General Gov't. 10,500 - 10,500 0% 302 - 026- 521 - 990021 Contingency - Police 5,300 - 5,300 0% 302- 026- 522- 990022 Contingency - Fire 2,260 - 2,260 0% 302- 026 - 571 - 990071 Contingency- Library 5,560 - 5,560 0% 302- 026- 572 - 600720 Capital - ParkslRec 3,500 3,180 320 91% 302 - 026 -572- 990072 Contingency - Parks/Rec. 600 - 600 0% 27,720 3,180 24,540 11% No adjustment made to this fund. 26 City of Cape Canaveral =.:% Caliectedor Used 401 - 000 -300 - 300100 401 - 000 - 331 - 331500 401 - 000 - 334 - 334500 401 -000- 343 - 343510 401 -000- 343 - 343520 401- 000 - 343 - 343530 401 - 000 - 343 - 343531 401- 000 -361 - 361110 401 - 000 -361- 361140 401 -000 -361- 361141 401 - 000 -361- 361142 401 - 000 - 361- 361143 401 - 000.361- 361144 401 - 000 -369- 369100 401 - 000 -369- 369300 Kevenue Cash Forward Federal Disaster Relief State Disaster Relief Utility Operating Income Utility Penalty Income Sewer Assessment Fees Reuse Hook -Up Fees Interest - Expansion Fund Interest - Revenue Fund Interest - Water Reuse Escrow Interest - Water Reuse Reserve Interest - WWTP Escrow Interest - WWTP Reserve Miscellaneous Income Refund of Prior Year Expense (118,953) - (118,953) 0% Regular Salaries & Wages 401 - 010 - 535 - 140000 5,199 100% - (833) 833 100% (2,834,565) (2,907,203) 72,638 103% (52,320) (56,423) 4,103 108% (10,000) (21,737) 11,737 217% (5,700) (2,925) (2,775) 51% (15,900) (12,648) (3,252) 80% (17,370) (10,558) (6,812) 61% (1,470) (37) (1,433) 3% (1,190) (16) (1,174) 1% (3,985) (138) (3,847) 3% (4,485) (80) (4,405) 2% (100) (60) (40) 60% - (22) 22 100% (3,066,038) (3,017,878) (48,160) 98% Expenditures 401 -010- 535 - 110000 Executive Salaries 401- 010 - 535 - 120000 Regular Salaries & Wages 401 - 010 - 535 - 140000 Overtime 401-010-535-140010 Special Pays 401- 010 -535- 210000 FICA Taxes 401 - 010 - 535 - 220000 7% Retirement Contribution 401 -010- 535 - 220100 3% Retirement Match 401 - 010 - 535 - 230000 Life & Health Insurance 401 -010 -535- 240000 Worker Compensation 401- 010 - 535 - 310000 Legal Services 401- 010 - 535 - 313000 Engineering Fees 401- 010 - 535 - 314000 Physicals 401 -010- 535 - 320000 Audit Expense 401- 010 -535- 340000 Contract Services 401 - 010- 535- 400000 Travel & Per Diem 144,723 151,465 (6,742) 105% 772,954 792,847 (19,893) 103% 16,672 21,140 (4,468) 127% 10,000 - 10,000 0% 71,478 73,208 (1,730) 102% 64,237 64,875 (638) 101% 27,530 22,164 5,366 81% 128,287 120,295 7,992 94% 26,897 16,052 10,845 60% 4,000 1,469 2,531 37% 36,800 20,327 16,473 55% - 60 (60) 100% 21,299 21,300 (1) 100% 1,210 958 252 79% 3,500 118 3,383 3% 27 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Accoun t Nun�6er Descr�pt(on 2009 S udget!; End Balance rVar�ar�ce: % Colleted ar - _ used 401 - 010 - 535 - 410000 Communications Service 401 - 010 - 535 - 420000 401 -010 -535- 430000 401- 010 - 535 - 431000 401 -010 -535- 450000 401 -010 -535- 461000 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 - 630000 401 - 010 - 535 - 630800 401 -010- 535 - 631000 401- 010 - 535 - 640000 401 - 010 - 535 - 711000 401 - 010 -535- 711100 401 - 010.535- 720000 401 - 010 - 535 - 910000 401 -010- 535 - 990000 Postage Utilities Sludge Disposal Fees General Insurance Building & Grounds Maintenance Plant & Equip.ment 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 - Infrastructure Capital - Force Main Capital - Collection System Capital - Machinery and Equip SRLF CS120825020 Debt SRLF CS120825030 Debt SRLF Interest Transfer To General Fund Contingency No adjustment made to this fund. 5,500 5,775 (275) 105% 600 563 37 94% 206,252 210,310 (4,058) 102% 66,990 64,364 2,626 96% 213,610 164,181 49 ,429 77% 24,600 21,218 3,382 86% 88,873 86,197 2,676 97% 30,000 36,978 (6,978) 123% 1,500 163 1,337 11% 9,800 12,514 (2,714) 128% 4,000 3,461 539 87% 89,000 85,383 3,618 96% 5,984 5,446 538 91% 19,000 7,258 11,742 38% 2,000 1,059 941 53% 30,000 29,886 114 100% 10,500 7,076 3,424 67% 4,857 5,337 (480) 110% 7,650 7,950 (300) 104% 19,000 18,303 697 96% 4,830 3,463 1,367 72% 2,230 1,000 1,230 45% 1,060 1,059 1 100% 403,435 403,435 0 100% 114,478 114,478 0 100% 131,471 131,471 0 100% 125,000 125,000 - 100% 114,231 - 114,231 0% 3,066,038 2,859,603 206,435 93% w City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Description 2009 Budge #+ Enc1 Balance �farianee %Collected or USecE'. 403 -000- 300 - 300100 403 -000- 331 - 331500 403 - 000 -334- 334364 403 - 000 - 334 - 334500 403 -000- 343 - 343900 403- 000 - 361- 361100 Cash Forward Federal Disaster Relief Dept.of Environmental Protection State Disaster Relief Stormwater Utility Fees Interest From Investment (109,400) - (109,400) 0% - (35,273) 35,273 100% (143,000) (267,189) 124,189 187% - (5,644) 5,644 100% (334,200) (344,989) 10,789 103% (17,200) (16,849) (351) 98% (603,800) (669,944) 66,144 111% Expenditures 403- 018 - 538 - 120000 Regular Salaries & Wages 403 -018- 538 - 160000 Christmas Bonus Special Pay 403 -018- 538 - 210000 FICA Taxes 403 - 018 - 538 - 220000 7% Retirement Contribution 403 - 018 - 538 - 220100 3% Retirement Match 403 - 018 - 538 - 230000 Life & Health Insurance 403- 018 - 538 - 240000 Worker Compensation 403- 018 - 538 - 310000 Legal Services 403 - 018 - 538 - 330000 Professional Services 403 -018- 538 - 400000 Travel & Per Diem 403- 018 - 538 - 410000 Communications Service 403 - 018 -538- 420000 Postage 403 -018- 538 - 450000 General Insurance 403 - 018 -538- 461000 Systems Maintenance 403 -018- 538 - 462000 Equip.ment Maintenance 403 -018- 538 - 480100 Public Education 403 - 018 - 538 - 510000 Office Supplies 403 -018- 538 - 520000 Operating Supplies 403 - 018 - 538 - 523000 Uniforms 403- 018 - 538 - 524000 Motor Fuel & Lubricants 403 - 018- 538 - 525000 Small Tools 403 - 018 -538- 540000 Memberships & Training 403 - 018 - 538 - 630000 Capital - Infrastructure 403 - 018 -538- 631001 Capital.- Canaveral Ditch 14,292 14,296 (4) 100% 57 - 57 0% 1,093 1,087 6 99% 1,000 439 561 44% 429 428 1 100/ 1,863 5,693 (3,830) 306% 692 2,389 (1,697) 345% 5,700 - 5,700 0% 1,000 37 963 4% 100 - 100 0% 313 538 (225) 172% 100 190 (90) 190% 5,145 5,452 (307) 106% 142,700 110,899 31,801 78% 1,200 977 223 81% 200 - 200 0% 150 - 150 0% 700 1,347 (647) 192% 150 - 150 0% 800 1,006 (206) 126% 250 36 214 14% 450 721 (271) 160% 131,945 28,195 103,750 21% 263,000 393,308 (130,308) 150% 29 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 <9-i Collected or Account lVcarriherescnptron 2009'Bvdgef End Balance Variance Used 403 - 018 -538- 640000 Capital - Machinery and Equip.. 1,100 1,071 29 97% 403- 018 - 538 - 990000 Contingency 29,371 - 29,371 0% 603,800 568,109 35,691 94% No adjustment made to this fund. 30 City of Cape Canaveral Expense vs Budget Quarter Ended 9/30/2009 Account Number Descrtptia� 20D9 Bc�dgef End Balance Variance Collette d or Used No adjustment made to this fund. 31 Kevenue 602 - 000.300- 300100 Cash Forward (5,730) - (5,730) 0% 602 -000 -359- 359100 Contraband Income -State - (8,261) 8,261 100% 602- 000 - 361- 361100 Interest From Investment (1,200) (1,109) (91) 92% (6,930) (9,370) 2,440 135% Expenditures 602 -020 -521 - 341100 School Resource Officer 5,730 5,730 - 100% 602 -020- 521 - 990000 Contingency 1,200 - 1,200 0% 6,930 5,730 1,200 83% No adjustment made to this fund. 31