Lee County Board Of County Commissioners Agenda Item Summary Blue Sheet No. dooY/ (

1. REOUESTED MOTION:

ACTION REOUESTED: Present for information purposes.

WHY ACTION IS NECESSARY: To provide interim reporting on selected funds and revenues of the Lee County County Commissioners. Included in the report in compliance with Chapter 218.415 Florida Statues, Local Govemnx Investment policies, is the stated and fair market value of the investments managed by the Clerk’s Office. Additional In pursuant to Lee County Ordinance 02-28 activity for the Driver’s Education Safety Trust Funds.

WHAT ACTION ACCOMPLISHES: The purpose of this report is to convey to you the financial status of selected significant funds of the Lee County Board of County Commissioners and the status of specific revenues as of the stat’ and the market value of the investments managed by the Clerk’s Office on behalf of the Board

c IS& 3. MEETING DATE:

O/-OyI~~ 4. AGENDA: 5. REOUIREMENT/PURPOSE: 6. REOUESTOR OF INFORMATI~

(SpeW ~ CONSENT x X STATUTE 218.415 A. COMMISSIONER ~ ADMINISTRATIVE X ORDINANCE 02-28 B. DEPARTMENT Clerk of Circuit

APPEALS ADMIN. C. DIVISION Finance/Record CODE

PUBLIC OTHER WALK ON

BY: Donna G-k

TIME REQUIRED: 7. -GROUND:

8. MANAGEMENT RECOMMENDATIONS:

9. RECOMMENDED APPROVAL:

A B C D E F C Department Purchasing Human Other County Budget Services County F

Director or Resources Attorney Contracts

OA ( OM ( Risk 1 GC

lb. &MMISSI~N ACTION:

APPROVED DENIED DEFERRED OTHER

Lee County, Florida Lee County, Florida FINANCIAL REPORT TO THE BOARD OF COUNTY COMMISSIONERS FINANCIAL REPORT TO THE BOARD OF COUNTY COMMISSIONERS

Statistical Information for the Month of November. ZOO4 Statistical Information for the Month of November. ZOO4

,Tliis report cant&ins si@ifi&nt fi&cial data fqr the stated period, which may be, of interest to the Board’ of County &i”mi&io&& (SO&) atid ih& &t&e@ of $+ Comxty. Comments on variances, which’m&a predetermined threshold, arc ‘prov@l for reserves, rev&i& a&$ &q~e~&&&s. This report is prepared and reviewed by the Lee County Clerk of Court, ,,,, ,, ;+&iBf:A&xmting office, F&r@ a&d Records Department. ,, ,,, ,,

Significaixt ?ati&ic$ Data($&~,~~- 3) : .’ Eese,pageS show data colle&~,~&&ughout the Finance Department for the reported month of the current and prior year, c”re?t,yea~~tbdate,, and p,ri$ y&to-date. Items reported are interest’collectcd, total outstanding bonded debt, interes a$+ p,$i$p&lp?&I;,~$al dp$y$ paid, and the number of processed invoices, and payroll totals and the number of employees

ItBp@ ~y+jP-Y the st+sz~~l.:dyta for a visual picture. ~: .,,, ,., ,“, .., ~$@@i+n@~n&i-C&h a”d~+&S (page 4) ~~~@&~ows, by fun& a~,;, .:; h e C” and investments balance at the end of the reported month, original budgeted reserves, ‘prior xWi$fh bud$ted r&se$& &dance, current month budgeted reserve balance, and a month-&month comparison (variance)&c budgeted reseti&:’ A distinction is made between governmental and business-type activities. Comments are made on ati$ increase (d&@&e) 9 budgeted reserves from the prior month to the current month.

,. ,‘: ,’ .,, :i ‘, .,’ ;:,.I. Sig”ifica&Wwwes (p.zige:eS)i:.: :’ This page :@bws budget@ $+rities;by rev&me source for current year and prior year, current year-to-date actual, prior ,,, year-to-date &chlal, purent,ofactual-to-budget variance for current year a”d prior year, and a variance on the change from prior ye+&-date to curient’ year-to-date. A distinction is made between governmental and business-type activities. Comments are based o”$,~ar@i& of at least 15%, up or down.

,,,. Expenditu& By Sig”ificant.,D~~artment (page 6) ‘This page shows the, adc$&d ,operating budget by depatiemt,, amended operating budget’ ye&-to-date; year-to-date operating,~,~penditures foilcurrent and prior year. The variance is batid on the change from prior to,current’year-to-dnte expenditur& A,di#i”cti@‘&@ade betwe& &overnmental andbtisiness-type activities. Comments are based on a variance of at least 15% and $5OO,OOU,‘~tip~or down. ‘:I,, ,.,,

Signifitiant~fiojects (page 7) This page shows for the listed projects the projected cost, cunwlative expenditures frown prior years, current year :.,, expenditures, total expenditures-W+?, and funding source(s). Expenditures include all capital and operating expenses associated with each project. A comparison is not made for this report. The criteria used for selecting projects to report are based on total projected project c&of $15 millio” or more a”d include capital projects only. This report is updated annually for selected projects and funding,$~~?,&. 1, .,.,,

%iv:Fr Education Safety Trust Fund (page 8) %:@ge shows year-to-date revenues collected and expenditures made to identified parties as required by Lee County $?z$$iiii~~~:oz-28. ,,y., :,

Inv.&ent:Summary @ages,?,+:lD)-, These pages contain ctirrent BOCC investment data. This information is divided into three c+gories: (1) Government Bills, Notes and Bonds, (2) Mahiied/Sold Investm@nts, atid (3) S urnmary of Investments for repor,$“g month., This info&&n is required, to, be prepared monthly pursuant to Administrative Code 3-13, Itivesttient Policy,,for’, the B?ard”of County Co”imissioners.

Key Terms

Very Tr y Yours,

~~

Bocc Board of county Colnmissio”ers Cash and rni~eifmcnt\ Balance a, rnc’n,h end r!m Lee comy P”” .A”lh”rlty

rn, 1’:

Reserier Ad”lmd budge, anlO”nl se, aside for Iu~II”cB,ion by the Board as needed during ,hf Year 10 tund unexpected oprrations or uvents

/ I!&! O”fStanding Bonded Debt -Outstanding ptincipal ba,;incc “la,, dct’, incurred h) iSsua”Ce orrcirnue and special aJsrsimenl bun&

Charlie Green Clerk of the Circuit Court CG/MS/ga

?’ r

t

I

,,.:,

,.’ :,

Lee County, Florida

SIGNIFICANT STATISTICAL DATA For the period covering Fiscal Years 2004 and 2005

Prior year data C”“frS October elruugtl sqmnber Current year data ‘““cm October through <,,rrent reportrng peri”d

Interest Collected

November Year-To-Date

November Year-to-Date

FYo5

FY0.l

$2,663,851 $5,373,647

$2,507,202 $5,078,181

NW Interest $135,541 Interest and Principal Paid Year-To-Date Interest YTD $18,227,680 Nov Principal $200,000 Principal YTD

November Paid YTD Paid

538,862,570 $335,541 512”.““0.000

$57,090,250 Bl00,“uo”00 $80,“0”,cm

FYo4 .%6”.0”“.000

Nov Interest ~40,“WlWll

$193,636 ~*“.“oo.mo Interest l-m $18,216,901 8o Nov Principal ,UnP .A”guS1 Principal YTD November Paid YTD Paid

Total Outstanding Bonded Debt

November NO5 51,180,000,000

61,134,365,048 51,170,000,000 51,160,000,000

FYo4 $1,150,000,000 Noxvmber $1,117,802,900 51,140,000,000

$1,130,000,000 51,~120,0@0,cOo $1, I 1 o,ooo,ooo 51,100,000,000 51,090,000,000

Lee County, Florida

SIGNIFICANT STATISTICAL DATA For the period covering Fiscal Years 2004 and 2005

Prior year data C”“CTS odobcr through September Current )w”’ data covers odober through current reporting period

Vendor Dollars/Invoices - BOCC and Port Authority FY05-November

BOCC Port Total BOCC Invoices Pxxessed 9,914 788 10,702 7,317 Dollars Paid 541,X39,065 $1,377,490 $42,566,555 $20,280,092 ~~~~,~-~~ ~~~~~~~~~~~ ~~~~~~~~~

FYOCNovember POti Total 732 8,049 $1,419,082 $21,699,174

Payroll - BOCC and Port Authority FY05-November FY04-November

BOCC POti Total BOCC Port Total Full-Time Employees 2,163 273 2,436 2,067 263 2,330

Part-Time Employees 348 13 361 454 15 469 Payroll Total 57,804,042 $972,715 $8,776,757 $6,684,795 $951,244 $7,636,039

Lee County, Florida

SIGNIFICANT FUNDS - CASH AND RESERVES As of November 30,2004

(in dollars)

GOVERNMENTAL ACTIVITIES

General Fund

MSTU

Library

Tourist Tax

Transportation Tnzst

Impact Fees

Community Parks

Regional Parks

Koads

Emergency Medical Services (EMS)

Capital lmp’OYements’

Transportation Capital Improvements

54,503,602 70,075,472 70,075,472 69,534,107

66,253,575 59,093,843 59,093,843 58,9x3,843

50,536,461 17,794,407 11,794,407 11,794,407

3,515,134 1,352,065 1,352,065 1,352,065

8,581,046 6,453,332 6,453,332 79,908,332

19,454,868 3,614,706 3,614,706 3,614,706

8501,549 38 38 38

84,362,~178 28,926,508 28,&46,505 28,846,508

829,875 460,155 460,155 460,155

126,067,074 25,0&1.547 24,284,547 23,344,547

71,093,224 5,630,615 4,973,234 4,973,?34

BUSINESS-TYPE ACTIVITIES

Solid Waste 81,861,724

Transportation Facilities 7,423,590

Water and Wastewater 25,052,801

Transit 7,465,007

Port Authority 14,822,778

53,922,621

382,357

27,700,503

3,875,093

10,211,642

(541,365)I

(ls5,000)2

3 13,455,ooo

(940,000)4

53,922,621 53.422,621 5 (500,OcO)

382,357 382,357

27,700,503 27,700,503

3,875,093 3,875,093

10,211,642 10,211,642

COMMENTS 1. Reserves decreased due to a transfer to Transit to provide paratransit services with county personnel (replacing the current

provider, Goodwheels) and to the funding of two kiosks and paneling for the County Administration building. 2. Reserves decreased due to a transfer for consulting sewices for the Blasting Study for Lee County. 3. Reserves increased due to a Florida DOT Local Agency Natural Disaster Emergency Contract providing reimbursement funds

for damages incurred by Hurricane Charley for debris removal,signs, and signals on federal-aid routes in the county. 4. Reserves decreased due to a tranfer into the Boca Grande Historic Buildings project to advance the Teacherage Building Remodeling

and D&hong Bawen Improvements and to a transfer to the Newton Beach Park project in the Town of Fort Myers Beach. 5. Reserves decreased due to hurricane-related debris removal expenditures for Upper Captiva.

*Included in Capital Improvements are Conservation 2020 and TDC Beach Renourishment sub-funds.

4

%lZ- kL8'9~L) *%z- bOl’F) %5- (ELO’OZ I)

%ooI- bZ9ZS9'P) jaol- bsZ'66L'b~

%Sl 9OL’SlS L%El t 10’SQ 9%8El DO6'E9Z'Z

%P (ZXE'S 1~)

V/N L86’PZS %9L 890'8Ll

I%9 S6SfZ8Z

%EL 8s9'98P c%sL El1'9SE s%09 PSP'z2 s%Ezl lE6’lPl’E *%Lot- kS9'ZOL) b%LE OSZ'S9Z E%Ll 8E8’9Pl z%L 5ZL’ll

%ll LSL'EZ %Ol f709'W %ll US'99 %8 9SO'SE %E EE9‘12 %P SSL'OL %S SS8'611 %LZ ESE'96L

:,zz 802'600'9

% LL 98l’VS’E % 01 LPZ’981 % LIP LOP’LIP’Z

% 81 DZ9'LS9'P % 81 oSZ'66L'P

% 82 SlZ'XZP'E % LZ Z86'Z9E'E % n CS9'It9'1

% LI 896'882

%O 0 % Pl PLE%EZ % 11 SEO'SL9'P

% PZ bSL'L99 % LZ 6EE'LLP % Zl 99E’6E %/,n 1ES’vSS’Z % 61 6t.Z‘96 % 91~ 981'6lL %8 6PSL88 %8 ZSL‘LLl % L ZL6’0lZ % L 16L’ZW % L lOl’lZ9 % 8 998'ZZV % 01 PEO'SW % LL W6'SS9'1 % 8 Z99'LW'Z % 91 6877‘PZS'F % 51 6fC’l9Z’LZ

SEL'ZS9'lZ 150'916 LO9'6SP'Vl

98Z'EPL'9Z 8CS9L0'9Z

WO'LIP'ZI 001’0r~‘zr 000'89O'L

SEO'EEL'I

lW'9LS'9 Z86'0L9'1 WL'9ZS'Zb

% 11 llE’8Z8’Z % 91~ 9El'ESl %8 SZE‘L6Z‘Z

%O 0 %O 0

%6Z IZ6'EW'E %6Z Z6626L% % W 8SS'SO6%

%Zl 98S'ELZ

%Ll L86'DZ28 %EZ ZSE’llC %OI OE9'096'P

S3I.LIAIL.X’ &IhL-SSiINISfHl

OOO’ZSL’Z oOQ’osL’l OOO’OZE 000’0~0’21 000’00s 86S%SP‘P EEP‘Sll’lL DZI’SLZ’Z L6L‘I66‘Z ZO6’9LS’9 000'6lE'S E6l‘ZSP‘S 000'~002'9 000'0'26'6 000'000% 6CO'LlP'16Z 09L’l9E’LLl

%ZE LZb‘b51’1 %EE ZSP'EES %PlE lSS’Z9 %ZE Z9V969'S %I- @0op'9) %81 L95’P86 %8 88E'PEO'l %9 9OS'681 %8 669'PEZ %8 S6E’LSP %8 LL6’L89 %8 ZZ6‘LSP %Ol L99’999 %91 6lL’9ZL’I %L LIS’L9L’Z %Ll ZW'OZ9'P %9L LSS’OLZ’EE

SLNiW!W03

u,*op JO dn ‘%SI~ 1=a, w :iISNVIxV*

OSP'E69'SZ suo!ssaJ"rJ

OL9’8ZL’t *a&J as&,xn?“+J pue s,l2$ua>,

ZZL’Z9P‘6Z saag Jar*

LLIlIOH.LflV LXOd hLNllO.3 33-l

wo’osP’Lz Buyemdo maen,aase~

OOO’OOS’LZ su!pxado ‘alEM

PIXLShS H3LVMUSVM 5’ XLLVM

OW'OClS'El ,e!roua~q +u!odp!m 000'006'Zl ,emgade>

000'001'9 W!U"S ‘SKLIlISVrl NOILVLLHOdSNVXL

86P'E6Z‘Z

OS9’069’L W6’L9L’l ZbO'ES6'8l7

cm'LL9'E ooo'oos'z 000'02 000'6E0'8L 000'09P WS'SSE'S 000'029'2L bSS'69O'E HE‘690'E f46'6PZ'9 MZ'SES'R 056'EbS'S 692‘188'9 I tS’56L’Ot 066'ZOZ'SE lOL’9LS’LZ 618’629’201

Lee County, Florida

EXPENDITURES BY SIGNIFICANT DEPARTMENT As of November 30,2004

(in dollars)

GOVERNMENTAL ACTIVITIES

County Commissioners 1,193,865 1,193,865 157,086 1,082,416 153,632 3,454 2%

County hlanagrr 1,245,638 1,257,141 178,533 1,0%,994 159,640 18,893 12%

Medical Examiner 1,X18,065 1,8~18,065 38~1,785 1,531,476 137,482 244,303 178%

Visitor & Convention Bureau 8,079,144 8,079,144 618,785 7,918,615 699,542 (80,757) -12%

Public Safety 37,867,119 37,867,119 5,128,995 40,413,749 3,989,801 1,139,194 29%’

Library 25,163,610 25,~149,376 2,420,229 21,135,302 2,177,764 242,465 11%

Parks &Recreation 23220,978 23,220,978 3,118,594 21,875,902 2,306,615 811,979 35%2

Economic Dwelopment 1,671,352 1,671,352 260,094 1,562,791 253,597 6,497 3%

Animal Services 3,444,375 3,444,375 304,468 3,086,685 309,004 (4.536) -1%

Community Development 21,033,609 2LO33.609 2,141,152 l&681,149 ZO29.947 111,205 5%

Public Works Administration 1,669,583 1,669,583 201,856 1,637,363 192,570 9,286 5%

Construction & Design 12,113,078 12,113,078 1,717,802 10.184,200 1,257,372 460,430 37%

Natural Resources 4,760,638 4,760,638 576,169 4,366,275 553,830 22,339 4%

Tra”Sp&ihO” 28,820,840 28.820.840 3,280,221 30,106,040 3,276,637 43,584 1%

Solid Waste 90,852,430 YO,852,430

Transportation Facilities (Tolls) 15.859.981 15,859,981

Water and Wastewater 88,040,489 88,040,489

Transit 17,218,028 17,894,612

Port Authority 88,402,546 88,402,546

VARIANCE: At least 15% and 5500,000, up or down

COMMENTS

BUSINESS-TYPE ACTIVITIES

93,4+1,210

17,342,889

61,362,619

15,016,176

58,280,882

3,733,711

2,385,287

6,971,344

1,742,105

5,934,901

1,042,321 2,691,390

2,191,757 193,530

6,050,285 921,059

1,459,373 282,732

5,292,727 642,174

1. Public Safety increased due to the purchase of ambulances and aviation liability insurance. 2. Parks & Recreation increased due to vegetation removal from Lakes Regional Park and hurricane-related repairs. 3. Solid Waste increased due to hurricane debris removal expenses. 4. Water and Wastewater increased due to the purchase of two trucks with mounted sewer machines

258%3

9%

15%4

19%

12%

Lee County, Florida SIGNIFICANT PROJECTS

As of November 30.2004

Midfield Terminal

conservation 2020

Sanibel Bridge Replacement - A, B & C

Solid Waste Processing Equipment

Justice Center Expansion

Correctional Facilities

North Lee County Water Treatment Plant

Bicycle/Pedestrian Facilties

Summerlin 63 San Carlos to Gladiolus

Three Oaks Parkway Extension South

Summerlin @Boy Scout to Cypress Lake

Burnt Store Road Four Laning

Airport Sewer District

South Fort Myers Community Park

Ten Mile Linear Regional Park

Estero Parkway Extension

Gasparilla Island Beach Restoration

Three Oaks Parkway Widening

Lakes Regional Library

Desalination Plant Transmission Mains

Northwest Regional Librav

Three Oaks Parkway Extension North

Estero Island Beach Restoration

Alice Road Multilaning

437,871,114 321,606,644 0

192,610,476 70,664,761 0

114,761,003 9,757,85X 3,135,121

83,000,000 4,102,538 (36,385)

77,056;i 20 24,899,008 478,995

44,303,787 42,846,835 62

43,307,227 23,933,14X 886,735

33,587,205 7,558,928 5,386

33,274,692 4,142,643 228,096

33,158,069 10,925,454 35,316

25,034,OOO 1,554,616 1,206

23,301,000 0 0

21.444.567 5,122,756 31,177

20,302,4LHl 2,695,003 0

19,967,650 145,745 55,502

19,410,701 1,192,549 0

18,604,704 477,385 0

18,378,000 4,345,633 935,428

l&335,896 4,909,720 407,876

18,195,500 0 0

18,057,130 21,114 0

17,122,362 ~1,940,418 0

16,555,015 524,786 0

~,5,897,105 ~10,035,931 178,487

321,606,644 D,E,G

70,664,761 A

~12,892,979 D.S

4,066,153 D,E

25,378,003 AD

42,846,897 D,G

24,819,883 D,E

7,564,314 GT.1

4370,739 A,D,GT,I

10,960,770 A,GT,I,S

1,555,822 A,GT,I

0 E

5,153,933 D,E

2,695,tM3 A,l-C,S

201,247 I-R

1,192,549 A,GT,I,S

477,385 &G

5,281,061 A,D,GT,I

5,317,596 LA

0 E

21,114 LA

1,940,418 A,D,GT,I

524,786 G,S,T

10,214,418 A,GT,I

i

Lee County, Florida

DRIVER EDUCATION SAFETY TRUST FUND As of November 30,2004

(in dollars)

93,611 192,025 11,243 192,000 0 192,000 93,636

PaytY Amount Paid

TOTAL YEAR-TO-DATE 50

8

INVESTMENT SUMMARY FOR THE MONTH OF NOVEMBER 2004

DEFINITIONS

1”