Agenda 04/25/2019 PELICAN BAY SERVICES DIVISION
Municipal Services Taxing and Benefit Unit
NOTICE OF PUBLIC MEETING THURSDAY, APRIL 25, 2019
THE BUDGET COMMITTEE OF THE PELICAN BAY SERVICES DIVISION
WILL MEET ON THURSDAY, APRIL 25th AT 9:00 AM AT THE PBSD
OFFICE LOCATED AT 801 LAUREL OAK DRIVE, SUITE 302, NAPLES,
FL.
AGENDA
1. Pledge of Allegiance
2. Roll call
3. Agenda approval
4. Approval of 4/09/2019 and 4/18/2019 meeting minutes
5. FY 2020 carry forward funds recap
6. *FY 2020 budget review & approval
a. Budget Summary
b. Expenditure Analysis
c. Revenue Analysis
7. Old Business
8. New Business
9. Audience Comments
10. Adjourn
*indicates possible action item
ANY PERSON WISHING TO SPEAK ON AN AGENDA ITEM WILL RECEIVE UP TO THREE(3)MINUTES
PER ITEM TO ADDRESS THE BOARD. THE BOARD WILL SOLICIT PUBLIC COMMENTS ON
SUBJECTS NOT ON THIS AGENDA AND ANY PERSON WISHING TO SPEAK WILL RECEIVE UP TO
THREE (3) MINUTES. THE BOARD ENCOURAGES YOU TO SUBMIT YOUR COMMENTS IN WRITING
IN ADVANCE OF THE MEETING. ANY PERSON WHO DECIDES TO APPEAL A DECISION OF THIS
BOARD WILL NEED A RECORD OF THE PROCEEDING PERTAINING THERETO, AND THEREFORE
MAY NEED TO ENSURE THAT A VERBATIM RECORD IS MADE, WHICH INCLUDES THE TESTIMONY
AND EVIDENCE UPON WHICH THE APPEAL IS TO BE BASED. IF YOU ARE A PERSON WITH A
DISABILITY WHO NEEDS AN ACCOMMODATION IN ORDER TO PARTICIPATE IN THIS MEETING
YOU ARE ENTITLED TO THE PROVISION OF CERTAIN ASSISTANCE. PLEASE CONTACT THE
PELICAN BAY SERVICES DIVISION AT (239) 597-1749 OR VISIT
PELICANBAYSERVICESDIVISION.NET.
BUDGET COMMITTEE
PELICAN BAY SERVICES DIVISION
APRIL 9,2019
The Budget Committee of the Pelican Bay Services Division met on Tuesday, April 9 at 9:00
a.m. at the SunTrust Bank Building, located at 801 Laurel Oak Drive, Suite 302, Naples, Florida
34108. In attendance were:
Budget Committee Ken Dawson
Scott Streckenbein, Acting Chair (ex-officio) Nick Fabregas
Joe Chicurel Rick Swider
Pelican Bay Services Division Staff Mary McCaughtry, Operations Analyst
Neil Dorrill, Administrator Barbara Shea, Recording Secretary (absent)
Lisa Jacob, Interim Operations Manager
Also Present Susan O'Brien, PBSD Board
Denise McLaughlin, PBSD Board Michael Weir, PBSD Board
APPROVED AGENDA (AS AMENDED)
1. Pledge of Allegiance
2. Roll call
3. Agenda approval
a. Designation of a new committee chair (add-on)
4. Audience comments
5. Recap of existing budget to actual
6. Preliminary FY 2020 budget review
7. Proposed Fleet replacements and capital equipment list
8. Proposed capital projects—additions/deletions
9. Other Business
a. Assessment methodology (add-on)
10. New Business
11. Adjourn
ROLL CALL
All members were present and a quorum was established
AGENDA APPROVAL
Mr.Dawson motioned,Dr.Chicurel seconded to approve the agenda as amended.
The motion carried unanimously.
1
Budget Committee of the Pelican Bay Services Division
April 9,2019 Minutes
DESIGNATION OF A NEW COMMITTEE CHAIR(ADD-ON)
Mr. Streckenbein appointed Mr. Swider chair of the Budget Committee. Mr. Swider
accepted the appointment.
AUDIENCE COMMENTS
Ms. O'Brien commented that given we have three new board members,two with extensive
financial backgrounds,that we consider having a board workshop, after April 18, on the proposed
FY20 budget, which would allow the board to be ready to take action on the budget on May 8.
This would enable board members to have had an opportunity to have all their questions answered
at the workshop.
Ms. O'Brien commented that we need additional information on our new projects, with
specific FY20 financial requirements, and how they will be financed. She suggested that in funds
109 and 778, it looks like we will have significant surplus of funds at the end of the fiscal year,
which needs to be accounted for in the FY20 budgeting process.
Ms. McLaughlin commented that she is interested in understanding the facilities
replacement issues.
RECAP OF EXISTING BUDGET TO ACTUAL
The committee reviewed the budget to actual schedules for all PBSD funds, provided in
the agenda packet.
PRELIMINARY FY20 BUDGET REVIEW
Ms. McCaughtry prepared and provided a preliminary FY20 operating budget,included in
the agenda packet. Ms. McCaughtry commented that the budgeted operating expenses are pretty
standard but that budgeted capital expenditures may change. She commented that the PBSD has
a Hurricane Irma project fund of approximately$1.2 million for specific hurricane-related projects.
The new FY20 budget includes no allocations for hurricane expenses. Mr. Streckenbein
commented that it is important that we keep our commitment to the public to reduce the assessment
in FY20. Mr. Dawson commented that our deferred maintenance projects need to be completed.
Ms. O'Brien commented that our preliminary FY20 budget with an associated assessment
of$718 does not include any funds for sidewalk replacement. She suggested that we consider
taking some of our surplus and designating it for a specific purpose.
Ms. O'Brien suggested that the committee decide which of our large unfunded projects are
going to get done in FY20 and then determine the method of financing. Mr. Dorrill commented
that we have discussed a 10-year line of credit financing and a possible conversion to a lump sum
20-year bond for a larger bundling of projects. Mr. Dorrill commented that we could undertake
phase one construction of our sidewalk project and the beach dune swale project in FY20.
Mr. Dorrill reported that he met with First Integrity Bank personnel yesterday who
indicated that they need to take a look at their County contract for banking services to see if they
are able to do a line of credit for us under this existing contract or the County may want to
competitively bid this out separately(which would take approximately six months).
Mr. Dorrill suggested that we complete an analysis of available cash after we account for
the reserve requirements that we have. This cash would be available to pay for(1) the first phase
of the sidewalks, and(2) some lake bank remediation projects (depending on the remaining cash).
2
Budget Committee of the Pelican Bay Services Division
April 9, 2019 Minutes
Mr. Dorrill commented that staff will attempt to obtain updated estimates for the beach
dune swale, storm water pipes, and other projects wherever possible. He commented that we need
best estimates for all of our proposed projects to size a combined 20-year bond issue, taking into
account the County contributions (for sidewalk replacement and maintenance) during the first ten
years (estimated at $300,000/year), to determine what the annual principal and interest payment
would be. It is hoped that a County commitment for $300,000/year can be obtained prior to the
2019 budget workshops.
Mr. Dorrill commented that we will complete the beach dune swale project in FY20 at a
current estimated cost of$1.5 million. He suggested including $100,000 in the FY20 budget for
boat ramp installations.
PROPOSED FLEET REPLACEMENTS AND CAPITAL EQUIPMENT LIST
The committee reviewed the schedule entitled "FY2020 Vehicle & Equipment
Replacement List"prepared by the County and included in the agenda packet.
PROPOSED CAPITAL PROJECTS—ADDITIONS/DELETIONS
The committee reviewed the schedule entitled "Capital Projects Planning Estimate"
prepared by Ms. McCaughtry and included in the agenda packet.
ASSESSMENT METHODOLOGY (ADD-ON)
Mr. Dawson commented that The Club golf course has a current designation as
"unimproved land" and is assessed at 1 times acreage times the ERU assessment rate, while all of
the other commercial properties are assessed at 5.75 times acreage times the ERU assessment rate.
There has been no change in the PBSD assessment methodology since 1992. He suggested that a
golf course is not unimproved land.
Mr. Fabregas commented that almost all of the commercial properties receive very few
PBSD services, while The Club does receive PBSD services (maintenance of their lakes) and
enjoys a much lower rate of assessment. He suggested that the PBSD Board needs to weigh in on
this disparity in the methodology of commercial property assessments as well as whether to
continue to assess all residents equally or change to an assessment based on taxable value.
Mr. Swider suggested that the reality is that The Club golf course has been subsidized over
the last 20 years by PB residents; it is developed property. He suggested that the methodology be
changed to a more equitable formula.
Mr. Weir suggested that The Club golf course gives immense value to hundreds of homes
in Pelican Bay at no cost to them.
Mr. Dorrill commented that if the assessment methodology is going to be revised, you
would need the Board of County Commissioners to approve a resolution. He suggested that we
review what is in the backup behind the executive summary in which the current methodology was
put in place in 1992. This may provide important information.
Mr. Streckenbein suggested that we ask for The Club's perspective on this issue, followed
by further PBSD Board discussion.
Ms. O'Brien suggested that we not put the funding mechanism discussion on the PBSD
Board May 8 agenda, but rather focus on approving a FY20 budget at that meeting.
NEW BUSINESS
None
3
Budget Committee of the Pelican Bay Services Division
April 9,2019 Minutes
ADJOURNMENT
Fhe meeting was adjourned at 11:35 a.m.
Scott Streckenbein,Acting Chair (ex-officio)
Minutes approved [ ] as presented OR [ ] as amended ON [ ] date
4
BUDGET COMMITTEE
PELICAN BAY SERVICES DIVISION
APRIL 18,2019
The Budget Committee of the Pelican Bay Services Division met on Thursday,April 18 at 9:00
a.m. at the SunTrust Bank Building, located at 801 Laurel Oak Drive, Suite 302,Naples, Florida
34108. In attendance were:
Budget Committee Ken Dawson
Rick Swider, Chairman Nick Fabregas
Joe Chicurel Scott Streckenbein (ex-officio)
Pelican Bay Services Division Staff Mary McCaughtry, Operations Analyst
Neil Dorrill, Administrator Barbara Shea, Recording Secretary
Lisa Jacob, Interim Operations Manager
Also Present Susan O'Brien, PBSD Board
Michael Fogg, PBSD Board
APPROVED AGENDA (AS PRESENTED)
1. Pledge of Allegiance
2. Roll call
3. Agenda approval
4. Approval of 12/03/2018 meeting minutes
5. *FY 2020 budget review& approval
6. *Assessment methodology
7. Audience comments
8. Old Business
9. New Business
10. Adjourn
ROLL CALL
All members were present and a quorum was established
AGENDA APPROVAL
Mr. Dawson motioned, Mr. Streckenbein seconded to approve the agenda as
presented. The motion carried unanimously.
APPROVAL OF 12/03/2018 MEETING MINUTES
Mr. Dawson motioned, Mr. Streckenbein seconded to approve the 12/03/2018
meeting minutes as presented. The motion carried unanimously.
1
Budget Committee of the Pelican Bay Services Division
April 18,2019 Minutes
CHAIRMAN'S OVERVIEW
Mr. Swider provided an overview of his personal work experience and his view of the
PBSD budget process. He commented on his difficulty in reading and understanding our financial
statements and suggested that the format of the financial statements needs to change. He suggested
that there is no accountability in the existing financial statement format.
Mr. Dorrill commented that the County accounting function is performed by the Clerk of
Circuit Court. He explained that in the past, former Clerk Dwight Brock had assisted the PBSD
in formatting the existing financial statements. He suggested that we meet with the current Clerk,
Ms. Crystal Kinzel to discuss this issue. Mr. Dorrill commented that all County departments
receive and monitor budget to actual reports (by fund and cost center) on a monthly basis.
FY2020 BUDGET REVIEW & APPROVAL
The committee reviewed a new preliminary edition of the FY20 budget prepared by staff,
as included in the agenda packet. Ms. McCaughtry commented that this budget version includes
a new environmental specialist position as well as three new landscape maintenance positions,
which had been approved by the PBSD Board last year, but not filled in FY19.
Mr. Fabregas suggested that we specifically identify reserves earmarked for hurricane
recovery. Similarly, Mr. Dorrill suggested that we specifically identify reserves for cash flow(to
allow for operations during the first two months of the fiscal year prior to collection of
assessments).
Ms. Jacob commented that per our engineer,phase 1 sidewalk replacement construction is
estimated at approximately $2.3 million. Mr. Dorrill and the committee agreed that we should
plan for completion of phase 1 sidewalk replacement and provide for it in our FY20 budget,
including the County contribution,the amount financed through our line of credit, and an amount
of cash on hand budgeted for this purpose. Mr. Dorrill commented that he would provide sources
of funds for FY20 sidewalk construction at the next meeting. The committee agreed that a line of
credit would be used to finance phase 1 sidewalks and the beach dune swale project in FY20.
The committee discussed using funds from fund 778 for sidewalk replacement, but
ultimately decided to preserve these funds for future streetlight replacement.
Mr. Streckenbein and Ms. O'Brien stressed the importance of going forward with taking
out a line of credit to begin funding our long-term projects. Ms. O'Brien commented that at last
September's BCC budget hearings, the PBSD pledged to the Commissioners that the FY20
assessment would be lower than the FY19 assessment.
Mr. Shepherd reminded the committee that they will need to budget for repayment of
principal and interest in FY20, if projects are funded via a line of credit. Mr. Swider asked staff
to determine what the FY20 repayment amount would be.
The committee agreed to meet again on April 25 to finalize and vote on an FY20 budget.
ASSESSMENT METHODOLOGY
The committee discussed the current assessment methodology whereby The Club golf
course,the County Park, and the PBSD water plant property are assessed as unimproved land at a
preferred multiplier rate of one(times acreage); all other commercial properties are assessed using
a multiplier rate of 5.75. Schedules of the ERU's for all 18 commercial members calculated using
both multiplier rates were included in the agenda packet. Mr. Swider suggested that all commercial
members should be assessed equally.
2
Budget Committee of the Pelican Bay Services Division
April 18,2019 Minutes
Mr. Fogg commented that The Club is different from other commercial properties as it
provides a water management facility to the entire community. Mr. Streckenbein suggested that
we obtain some input from the County on this issue. Dr. Chicurel commented that he is not ready
to bring any change in assessment methodology to the full board.
Mr. Dorrill suggested, and the committee agreed, that he would explore the golf course
assessment methodologies used by other communities similar to Pelican Bay (including Tiburon,
Pelican Marsh, & Lely). Mr. Dorrill suggested that the committee consider raising the multiplier
for The Club to somewhere between 1.0 and 5.75. He also commented that due to time constraints,
it would not be feasible to change assessment methodology between now and the June budget
hearings. Mr. Swider agreed and concluded that the committee would focus on the FY20 budget
at next week's committee meeting and that a possible change to the assessment methodology
would be further discussed by the committee at a later date.
AUDIENCE COMMENTS
Ms. O'Brien expressed her agreement with getting more data on ERU's and suggested that
the whole community needs to be informed of any changes to the assessment methodology. She
suggested that our immediate focus be on approving a FY20 budget.
Mr. Shepherd commented that due to past politically expedient financial management of
the PBSD,we currently have a lack of funds to complete all of our deferred maintenance projects,
and suggested that we need to communicate to our residents our intentions of becoming a more
responsible steward going forward.
Mr. Fogg agreed with Mr. Shepherd. He asked whether the committee has intentions to
review and discuss the issue of ad valorem vs. non-ad valorem collection of annual assessments.
Mr. Fabregas responded that this would be a discussion for the future. Mr. Fogg requested that
when the board is presented with a proposed FY20 budget that a FY19 year-to-date budget is
included with the materials provided.
OLD BUSINESS
Mr. Steckenbein questioned when an orientation tour for new board members would be
scheduled for. Mr. Dorrill commented that he is planning for an end of May orientation tour.
NEW BUSINESS
None
ADJOURNMENT
The meeting was adjourned at 11:11 a.m.
Rick Swider, Chairman
Minutes approved [ 1 as presented OR [ 1 as amended ON [ 1 date
3
14)
Z
w
0
a)
wa)
a3 01
a@
c n-
a)
rn
Q
00 0 0 0 0 0 0 0 0
0
c-i GO M to 01 Ln O O en
,.i O O' 00 O O M
01
n � N M M 00 ,--1Ln 0�o 4''
i-- �N-1 M r 1' N
0
I-
1.4 V} V)• th t/} t/} VI- in- t/>
0 0 0 0 0 0
Lr) 00 t N N O
NI,
00
N M O MO LNi c-iNI cn co c-I 1-1N
LL '0
o L
C
i!} V} V' V} V} V)•
SZ 'O oo aJ
Q " C N O v)
a) N N in "a v)
U 0 OM 000 O� 00) 00) •ct -a C V
Z N to r� of ai `N'' CU t a Li •v
C4 D M N I--1 Q o = y r., O
O U. CO M 1< v L O N i3.
Z V} V1 t/1 i.e). V} t!} M > LL O >
v; ° a` 0
L.L. O O O O O O O O .O .O V) f0 CO
o p in tD 01 00 01 O N 00 fl- a c
N
Z CO SCh N 0-o M O 0011 00 a (1) 4)
N O tD (.0 .-i h v 0 'a X v1 rui-
ns
>. LL
Li. N c-I c-I rl cu ..Q to C d L
i/? VS VY tn• VT V? VT V} O> 01C Oo U (0
U 0 •••-'
0 C ›- O
0 0 0 0 0 0 0 0 0 O co 2 -0
m
000 100 0 NN 0 0 0 0 014 4-' C 0- -C C a
N U aJ
Z 0 M 00 Ln O O MO NN in 01 N
U. vl 'V 00p
�••I 00 M 'cF N N �-i d' 01 d' C a
LL Ln .4.` e-i CU C c '47.-, o0 "o .0
t0
V} tn. VI- V} V? V} V} V} V} N a) C +L, (0
V) v) Q 0 C .Q +'C• a
LU LU "D '3 �i
0O o: 4-- o (1) C N
W W
VI
• C W W C O a) .Q ., N
L c CC CY a) > .Q
N 7 • J v _ 'n o
iF13 "
a C COa) H Z -a = to -C •v) OU .0
CU C C O aJ N 4-, N a) v N
> Q LL O F— O U aJ sa ns
U U
cc W +-, U 1W-' a co ate-, N aJ
—
ut '
>✓
°' +� C O o U * L = C U y 0- cr
4-4 N V1 m o a' C H v) v1 a ,Q aJ t a)
c0 co W aJ to o N co aJ E ' h "
aU) a") m v) v co C L1 W t' •- N o Q. o
o o C 7 O Q 0 y O v1 1n v1 C o C
t0 t0 0 W ns CL v U U U co o co � c0 O. >' L)
0 0 LL W CC 0 0 0 a0-, o o O v@ N
F- H U t 4- 4- 4- o '~' O 0 co
01 01 O 0 0 a) aJ aJ •aJ a) , 00 a
,-f .-i N N +-+ v1 U N aJ C C
C
N N N N
v
a v er s '^ co a .� o
LL LLs_ LL. LL C OC o` * O* 4 4 4 a
-, .O 4- CO
Agenda item#5
Page 2 of 4
Fund Detail Proforma Summary Grouped By Account Minor
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Actual Adopted Amended Forecast, Current Expanded Budget %Change
109 Pelican Bay Beautification MSTBUIII
1
Expenditures
500 Personal Services 1,431,172 1,639,700 0 1,701,000 1,856,000 73,800 1,929,800 17.69
600 Operating Expense 1,814,107 2,377,300 0 2,241,900 2,385,600 0 2,385,600 0.35
610 Indirect Cost Reimburs 119,200 119,100 0 119,100 119,300 0 119,300 0.17
700 Capital Outlay 195,481 214,900 0 130,500 168,000 2,300 170,300 -20.75
855f Trans to Property Appraiser 59,816 71,000 0 62,000 71,000 0 71,000 0.00
855h Trans to Tax Collector 78,354 125,800 0 114,900 125,800 0 125,800 0.00
961 Trans to 408 Water/Sewer Fd 13,600 17,200 0 17,200 17,200 0 17,200 0.00
981g Trans to 506 IT Capital 5,500 0 0 0 0 0 0 0.00
991 Reserves for Contingencies 0 385,000 0 0 130,500 0 130,500 -66.10
993 Reserves for Capital 0 200,000 0 0 200,000 0 200,000 0.00
998 Reserves for Cash Flow 0 420,000 0 0 420,000 0 420,000 0.00
999 Reserves for Attrition 0 -25,700 0 0 -29,000 0 -29,000 12.84
Revenues
307 Delinquent Ad Valorem Taxes 147 0 0 0 0 0 0 0.00
325a Special Assessments 3,918,172 4,176,200 0 4,009,100 4,176,200 0 4,176,200 0.00
340 Charges For Services 3,145 1,500 0 0 0 0 0 100.00
360 Miscellaneous Revenues 26,071 0 0 12,100 0 0 0 0.00
361 Interest/Misc 38,612 6,900 0 27,500 7,300 0 7,300 5.80
392d Trans frm Property Appraiser 38,072 0 0 0 0 0 0 0.00
392h Trans frm Tax Collector 31,903 0 0 31,900 0 0 0 0.00
459 Trans fm 320 Clam Bay Cap Fd 0 34,500 0 34,500 36,900 0 36,900 6.96
499u Carry Forward 1,385,800 1,534,400 0 1,724,700 1,453,200 76,100 1,529,300 -0.33
499z Less 5%Required By Law 0 -209,200 0 0 -209,200 0 -209,200 0.00
Fund Total Expenditure: 3,717,230 5,544,300 0 4,386,600 5,464,400 76,100 5,540,500 -0.07
Fund Total Revenue: 5,441,922 5,544,300 0 5,839,800 5,464,400 76,100 5,540,500 -0.07
Fund Balance: 1,724,693 0 0 1,453,200 0 0 0 0.00
111 Unincorp General Fund
Expenditures
600 Operating Expense 116,967 150,000 0 193,600 150,000 0 150,000 0.00
Fund Total Expenditure: 116,967 150,000 0 193,600 150,000 0 150,000 0.00
Fund Total Revenue: 0 0 0 0 0 0 0 0.00
Fund Balance: -116,967 -150,000 0 -193,600 -150,000 0 -150,000 0.00
GovMax 1 4/22/2019
Agenda item#5
Page 3 of 4
Fund Detail Proforma Summary Grouped By Account Minor
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Actual Adopted Amended Forecast Current Expanded Budget %Change
320 Clam Bay Restoration
Expenditures
600 Operating Expense 146,756 181,400 272,404 272,500 150,100 0 150,100 -17.25
855f Trans to Property Appraiser 2,183 3,800 3,800 3,800 3,300 0 3,300 -13.16
855h Trans to Tax Collector 3,094 6,100 6,100 6,000 6,000 0 6,000 -1.64
903 Trans to 109 PB MSTUBU Fd 0 34,500 34,500 34,500 36,900 0 36,900 6.96
Revenues
325a Special Assessments 154,702 225,100 225,100 216,100 198,600 0 198,600 -11.77
361 Interest/Misc 2,424 500 500 1,600 100 0 100 -80.00
392d Trans fun Property Appraiser 2,040 0 0 0 0 0 0 0.00
392h Trans frm Tax Collector 1,260 0 0 0 0 0 0 0.00
499u Carry Forward 98,200 11,500 102,503 106,600 7,500 0 7,500 -34.78
499z Less 5%Required By Law 0 -11,300 -11,300 0 -9,900 0 -9,900 -12.39
Fund Total Expenditure: 152,032 225,800 316,804 316,800 196,300 0 196,300 -13.06
Fund Total Revenue: 258,626 225,800 316,803 324,300 196,300 0 196,300 -13.06
Fund Balance: 106,593 0 -1 7,500 0 0 0 0.00
322 Pelican Bay kr & Lndscp
Expenditures
600 Operating Expense 637,153 1,666,100 3,464,991 3,423,300 975,000 0 975,000 -41.48
700 Capital Outlay 207,456 390,000 523,451 512,500 1,650,000 0 1,650,000 323.08
855f Trans to Property Appraiser 10,110 56,000 56,000 56,000 38,300 0 38,300 -31.61
855h Trans to Tax Collector 14,328 93,000 93,000 93,000 76,600 0 76,600 -17.63
873z Advance/Repay to 778 Pel Bay 0 1,000,000 1,000,000 0 0 0 0 100.00
Light
Revenues
325a Special Assessments 716,515 3,333,700 3,333,700 3,200,400 2,553,800 0 2,553,800 -23.39
360 Miscellaneous Revenues 161,711 0 0 0 0 0 0 0.00
361 Interest/Misc 18,742 5,000 5,000 11,800 3,100 0 3,100 -38.00
392d Trans frm Property Appraiser 30,213 0 0 0 0 0 0 0.00
392h Trans frm Tax Collector 5,834 0 0 5,800 0 0 0 0.00
496z Trans fm 778 Pel Bay Lighting(H. 0 0 1,000,000 0 0 0 0 0.00
Irma)
499u Carry Forward 1,113,500 33,300 965,641 1,177,500 310,700 0 310,700 833.03
499z Less 5%Required By Law 0 -166,900 -166,900 0 -127,700 0 -127,700 -23.49
Fund Total Expenditure: 869,047 3,205,100 5,137,442 4,084,800 2,739,900 0 2,739,900 -14.51
Fund Total Revenue: 2,046,514 3,205,100 5,137,441 4,395,500 2,739,900 0 2,739,900 -14.51
Fund Balance: 1,177,467 0 -1 310,700 0 0 0 0.00
GovMax 2 4/22/2019
Agenda item#5
Page 4 of 4
Fund Detail Proforma Summary Grouped By Account Minor
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Actual Adopted Amended Forecast Current Expanded Budget %Change
778 Pelican Bay Light
Expenditures ..
500 Personal Services 151,480 127,200 0 125,400 121,200 0 121,200 -4.72
600 Operating Expense 179,357 290,900 0 270,000 272,800 0 272,800 -6.22
610 Indirect Cost Reimburs 11,000 11,200 0 11,200 10,000 0 10,000 -10.71
700 Capital Outlay 0 0 0 0 1,000 0 1,000 0.00
855f Trans to Property Appraiser 0 11,900 0 2,100 9,100 0 9,100 -23.53
855h Trans to Tax Collector 10,914 14,900 0 13,900 14,900 0 14,900 0.00
993 Reserves for Capital 0 1,338,500 0 0 1,625,200 0 1,625,200 21.42
998 Reserves for Cash Flow 0 150,000 0 0 150,000 0 150,000 0.00
Revenues
306 Ad Valorem Taxes 543,550 585,000 0 561,600 608,800 0 608,800 4.07
307 Delinquent Ad Valorem Taxes 32 0 0 0 0 0 0 0.00
360 Miscellaneous Revenues 4,253 0 0 0 0 0 0 0.00
361 Interest/Misc 20,654 2,500 0 14,900 7,300 0 7,300 192.00
392h Trans frm Tax Collector 4,444 0 0 4,500 0 0 0 0.00
396w Advance/Repay fm 322 Pel Bay 0 1,000,000 0 0 0 0 0 100.00
Cap
499u Carry Forward 1,240,300 386,500 0 1,460,500 1,618,900 0 1,618,900 318.86
499z Less 5%Required By Law 0 -29,400 0 0 -30,800 0 -30,800 4.76
Fund Total Expenditure: 352,751 1,944,600 0 422,600 2,204,200 0 2,204,200 13.35
Fund Total Revenue: 1,813,233 1,944,600 0 2,041,500 2,204,200 0 2,204,200 13.35
Fund Balance: 1,460,482 0 0 1,618,900 0 0 0 0.00
GovMax 3 4/22/2019
Cl
N0 0 0 0 0 0 0 O 0 0 0 0 0 O o 0 0 0 0 0 0 0 0 0 0
0 0 69 0 0 0 0 O O p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lfl co co ,4 Vw 00 O\ \O d: ON CT M Oh [,CO V'�N 01 O O N O1 01'fit N d.,cn 0
N * "O VD t o N t` O 00 Oi •-+ 69 N en O V) N N 'O N N '�t' 1/4D 00
9k o cC O � .--. en N en co Vl N � 69 69 69 'd' G9 69 ,-, en 69 69 69 69 69 69
E a+ O d' 69 69 en h � O 69 69 69
'0. -' 0 O GT. en EA r" O ifl 69
< CO a E" d 69 69
4..
0
ao c'
0 0 0 0 0 0 0
.+7, 0 0 69 69 0 0 0
a) N -• Noo 0
a)
',"' O� 69 NVl en
V en -, kr) N
rn a'•,-, 69 ......./N 6N9
a U a.
0
W
co)
U
a.s
.c
0
Ai
° 000000 0 0
• _� 0 0 69 68 0 0 0 O
O. 'O rn o
U os
CO oi y 69 668 rn ON been
49', 69 69
0
U
on
q 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"F�..,•,-,
O 0 0 64 69 0 0 0 0 0 0 0 0 o 0 0 0 o 6.9 O 69 69 69 0 69 69
N +... 1 01 M 00 00 N. N 0 O 00 en 0 In 00 0 '1 ct. CO
w( CD 0 ''Ci 0 4 CO N o oo v o 0 69 b9 M 69 M N 69 GS
69
Q ... v 69 M
93 .69 Nw
GS 0
Ut CI
� �, 5 b
a) 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 as
.i..l '� GI $. w � D 00696900 0 0 690 0000000690000000 m
- , , C. 6� -. '-0 V1 ---- .T 00 O 00 O O\ en M Vl co in O N N N ^-- O in a
O M •"0 way s,. p U o Vi �D ^ N l6 N ce .-i ,--, .-, .-. N v'i et
V " p y , , 0 69 kr) n.
EA
69 69 !a9 '9 FA 69 69 69 69 69
CI 0 CD O 0 69 669- 69 GS
CD
dl ' 0 0 0 0 0 0 O 0 0 O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 O
y 0 0 69 O 0 0 0 O 0 0 69 0 0 0 0 0 O 0 0 0 0 0 0 0 0
00 N a. 00 'd;, in 0 cn ON N N. N. Cel V1 Cl, N Vt N N. o VI V., VI
0 00 N V N' •e O� 00 Oi M 69 N en -' •-.. N Vi' •-..-% r-' cn
t�3 a0 � � 668669 Nke) en — 48 6969X69696969 6969696969
3 `° 69
as 69 64
0
0
6.0
pO cll
c� a) o cu a G.,�
.a o 0 a> W Q
O Q
vs
a NV 69 O'N U UI •.0 O .ON ••
cn 0N U R' OU
CC ) h 00
p i '� 0> o d G79 , F. 0 QQ 0.0 k. () W a
0 a> v, ..:4 C4 �L OG 2 W i s0. a 0 '0 -a bA 4) a9i ° E 'v, ;d ti CO 0
0 0 N o c 3 a� a up A 0 b .?,C7 E" in o . �;)
U H ° +... o •0 En 0 (,) ,-:. 0 o a) a� Li 0 a> 00 ,-. > 0 0.,.= c>. 0
4 •S 't1 a) �' d ca o O � U 0 0 0 0 O' 0 ++. .Y 0 d ° 0 w 0 .�
d 0 'i. CT .11 ti ti bn k cg EI). .G PU W V cd �Q 48 1-1,-,1-.
'
M O N 0 a}i > tu
O i. •C °� W R. E N N alai ti G 4.Y U U C%)
C cd y 4a 0 a> 0 O a) a> L0 4-+ 2 0 -. 4-, p v�
C � . aa� x ¢ aa, � ,5o v� E- F a wx � a� aavoow
.y g Q Q w
W
Agenda item#6a
e1 Page 2 of 3
N o O O O O O O O O O O 0 0 O 0 0 0 0 0 0 O O O O O O O O O O
O O O O O O O O O O O O 0 0 0 0 0 69 O O O O O O 0 0 0 0 0 0
N o kn., O .—, \O ,-, .-+ ON ON., 0 b 00 O t N kr) d�M O ---, M kh '1t co O ,-+ O) O
N .-. '- o o N .-i Oi 00.-' \fl N 00) 0 c*l \O — Cr, cn vi N l:.-• N ,- ,-, v1\O O
0 6A \O 00 69 69 \O O\ O -� �t 69 N N 6 Con EA 00 c') r 64 64 VI 69 69 .4 rl
.--' m 69 69 69 69 •-+ Co N 64 69 ,-, 69 69 69 69
.Q GS GS � 69ER 6969 6R Co 69
d
4-
0
oa
C
O O O 0 0
GS 0 0 0 0 O0
CU
0 0 0 v-, o
0 O 0 r cn
Lr) Lel r, , ,-,
E9 69 Co 69
69
0 0 0 CD CD
CD CD
O O O
O O
\O VI Cr, Co Co
6') Co 6A
0 O 0 O 0 0 0 O 0 O O O 0 O O O O O O O 0 O O O O 0 0 0 0 O
O 69 O O 69 69 69 0 69 69 69 O 64 6R O O O 69 O 69 69 69 O 69 O 69 69 69 O O
0 O 00 'C'.. 00 01 M kr) ":1• 00 00 kr) O
O O 6R .- ,-7 GS .-�6.1 CO ..-4 \O 69 0
64 668 6699 Co Co &9 M
4-
O
N
0 0 O O 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N
Co 69 69 O O O O O 69 0 0 0 0 69 O O O 69 0 0 0 0 0 0 0 0 0 0 0 69 bA
M 1/40 .. .-, 1/40 00 ' l '0 r 1/4.0,. c:71,'n O O O .-, h kn., .--. 00 0 v) d
1/46 64 64 N M � \NO 64 N '-
Co ,-' 69 M r 69 69 ,--1 64 .-, .-+ ,-.
.--4 .-• 69 64 69 69 6R .--, 64 69 69
ER 69 69 69 69 69
O O O O 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O 64 O 69 64 O 0 O 69 0 0 0 0 0 0 0 69 6'A O 64 69 69 64 O 69 69 0 O 64
O Vl 0), O r 0l kr) --+ O\ 00 kr) kr) kr) c•l V \O O
O
'-+ .--, 00 0\ .-+ 0\ C•1'In O 64 M b9 0\ M c.-;l
EA _
,N-i 69 69 669N EA GS 69 � 49 M ER 64
69 69 69
O
O
O
00
M
69
CD O o N
CD CD O
CD Cy 4.4
Q 0 o C N p p 0 °� rn
O O 0 t-- 69 y 69 1p 69 0 o O .) o N N tn
O ,U 69 y gQ 69 0) id cd vi +, g 2
N 'a-, O (C/3 �O +' ak., (1] UuI
jI
N 'n f-LI .. ci P
P id
y cod —, N O a) G9 O by'N y O 0 0 -a L
IP; 1iO
R
M •�� 3 d 00ax 0 8OmaH4 0 wary .. �� 0 '• '5 0 0 5 b4
o w a. w0 aaHP.1 Hal .-lel g C.) H .8 , goE>-, wwcn W;-1w � w ;-a
In....
L
Agenda item#6a
r-1 Page 3 of 3
N O O O O O O 0 0 0 0 o o 0 N M N ON '
O O O O O O EA 0 0 O 0 O O • 00 N 00 M
LA O V'1 O O\O M O vl N (1 S. ON . V
O ) u) et
N S.Ce'l O N O •-• 0 0 L') cn — O b o H O O
EA VI .-. O N N N NN+ 00 00 N CYN EA 0 69 v
•L 69 69 N 6~9 V) 69 CL ,00� EA 69 0
EAQ
4-
O
bA
Eo O o 0
d 0 O a.
NN GS GS N • M
N ti V)
69 VD M
r MEA
'MV N C
— IN V) 1/40
N
09 61 u N
O O O
O O O
0 M M
VD cs VD N Ol
O
69 el ,--tr NEA .-.
'C
0
0
•N
R
Y
0 0 0 0 0 0 0 0 0 0 U
0 69 69 0 0 0 O 0 0 CD . N
CO '0 O 0 N N N N- N O 0' •^
VI 69 VOl O N ) V) V) 0 0 CO0.O,
GD 00 00 0
O O O O
� �O 69 N C b M
69 N 0 0 O O OCD
4-
69 69 ti cri U O
MI M
0 0 0 0 0 0 0 0 0 0 0 .p O110A
0 0 0 0 0 0 0 0 0 0 0
N. If O M O O tt O — N 0 0, 1f) co
Q.
69 .-i
EA O� 6 tr> a am VO 00 dam' 00 V) o
64 69 N •--' 69 69 CO ,..,4N 0
CO
69 N eM9 S. 0
41
O ^ 0
M d. O 0 69
CO O O cn
y
0 0 0 0 0 0 0 0 0 0 0 'd' II) O
00 69 690 00 0 00 0 0 0 N — EA v 5
en • O
.-, 00 .O O- O t--.".-. Oi N 00
.-i — {A GS G9609 , 0 a0
640,9 69 ,.,� � 0 o 00
O EA
U CA
• H
o O w
M0 d 40'
VI
69 cin °' bn
IX ^_
V/
E' o 0 6 Ewa
• v 0 �2i y Oth
ca
" t.69 ea
1) a a
v > EA ' C o • 3 'v cr F Ra. is p S's d
a Cd a 0 o EA o o w Q a ty °*'' 0 0
0 A 0 .-• d . 00
N v ..) Gi. 00 as v > °) W cd N = Q
Vl 71".29 U o O O T/ . 4 p o• w o 0 to 0 Q G v •o 0 o 8
0 E000 [i. w )y �, ww 1.. a? d 4) f4 A o Z
VI
°1 4z � pa H N 07 a) °� N o . u u
p 1 U 0p U pQ QQ U U �010. 0 � = CI O b
a� ca 6 0 0 4 cd I-. a' 1.. 1, u u 0
O• aaE-' WCOU cUaP4w' E . w Wa a Q Q E_,
v.L R!
6, 3'
a.,
Agenda item#6b
Page 1 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU
182601-109 Water Management Administration
500 Personal Services
512100 Regular Salaries 53,924 89,518 91,200 91,237 49,692 140,929 57.43
512600 ER 457 Deferred Comp 0 165 0 165 0 165 0.00
514100 Overtime 129 0 0 0 0 0 0.00
515000 Vacation Sell Back 0 220 200 225 0 225 2.27
519100 Reserve For Salary Adjustment 0 1,789 0 2,523 1,514 4,037 125.66
521100 Social Security Matching 3,890 7,009 7,000 7,196 3,913 11,109 58.50
522100 Retirement Regular 4,336 8,011 7,000 8,517 4,638 13,155 64.21
523150 Health Insurance 12,969 21,746 21,700 21,746 13,100 34,846 60:24
523152 Dental Insurance 486 814 800 830 500 1,330 63.39
523153 Short Term Disability Ins 90 166 200 166 100 266 60.24
523154 Long Term Disability Ins 189 332 300 332 200 532 60.24
523160 Life Insurance Short-Long Term 153 257 300 263 143 406 57.98
524100 Workers Compensation Regular 64 73 100 100 0 100 36.99
500 Personal Services 76,231 130,100 128,800 133,300 73,800 207,100 59.19
600 Operating Expense
634207 IT Capital Allocation 1,200 200 200 200 0 200 0.00
634210 Info Tech Automation Allocation 7,500 8,100 8,100 4,600 0 4,600 -43.21
634211 IT Billing Hours Allocation 0 0 0 200 0 200 100.00
634805 Emergency Maint And Repair 0 3,500 0 3,500 0 3,500 0.00
634980 Interdept Payment For Sery 34 0 0 0 0 0 0.00
634999 Other Contractual Services 39,368 52,200 38,900 53,900 0 53,900 3.26
641150 Telephone Beepers Base Cost 280 2,200 350 200 0 200 -90.91
641400 Telephone Direct Line 2,546 3,000 2,100 2,200 0 2,200 -26.67
641950 Postage Freight And Ups 1,012 1,200 950 1,200 0 1,200 0.00
644100 Rent Buildings 12,573 12,600 13,300 13,300 0 13,300 5.56
644600 Rent Equipment 1,257 2,700 1,400 1,500 0 1,500 -44.44
645100 Insurance General 900 1,000 1,000 1,200 0 1,200 20.00
647110 Printing Binding Outside Vendors 162 1,800 400 700 0 700 -61.11
649000 Sales Tax Expense 1 0 0 0 0 0 0.00
649030 Clerks Recording Fees Etc 464 1,000 800 1,000 0 1,000 0.00
649100 Legal Advertising 162 1,000 1,500 1,200 0 1,200 20.00
651110 Office Supplies General 486 1,500 500 1,500 0 1,500 0.00
652910 Minor Operating Equipment 661 0 0 0 0 0 0.00
652990 Other Operating Supplies 826 0 0 0 0 0 0.00
654360 Other Training Ed Exp 367 2,000 1,600 1,500 0 1,500 -25.00
600 Operating Expense 69,799 94,000 71,100 87,900 0 87,900 -6.49
610 Indirect Cost Reimburs
634970 Indirect Cost Reimbursement 119,200 119,100 119,100 119,300 0 119,300 0.17
610 Indirect Cost Reimburs 119,200 119,100 119,100 119,300 0 119,300 0.17
700 Capital Outlay
764990 Other Machinery And Equipment 1,000 1,000 0 1,000 2,300 3,300 230.00
700 Capital Outlay 1,000 1,000 0 1,000 2,300 3,300 230.00
182601-109 Water Management Administration 266,230 344,200 319,000 341,500 76,100 417,600 21.32
182602-109 Water Management Field Operations
500 Personal Services
512100 Regular Salaries 91,776 90,595 90,700 84,981 0 84,981 -6.20
512500 Auto Use Benefit 257 0 0 0 0 0 0.00
512600 ER 457 Deferred Comp 665 665 1,000 500 0 500 -24.81
514100 Overtime 17,858 18,500 18,000 18,500 0 18,500 0.00
515000 Vacation Sell Back 0 505 200 210 0 210 -58.42
GovMax 1 4/23/2019
Agenda item#6b
Page 2 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU
182602-109 Water Management Field Operations
500 Personal Services
519100 Reserve For Salary Adjustment 0 1,811 0 2,337 0 2,337 29.04
521100 Social Security Matching 7,888 8,568 8,400 8,140 0 8,140 5.00
522100 Retirement Regular 8,791 8,133 8,700 9,420 0 9,420 15.82
523150 Health Insurance 20,043 20,043 20,000 20,043 0 20,043 0.00
523152 Dental Insurance 750 750 800 765 0 765 2.00
523153 Short Term Disability Ins 138 153 200 153 0 153 0.00
523154 Long Term Disability Ins 291 306 300 306 0 306 0.00
523160 Life Insurance Short-Long Term 253 260 300 245 0 245 -5.77
524100 Workers Compensation Regular 4,403 4,911 4,900 5,300 0 5,300 7.92
528200 Allowance Vehicle -257 0 0 0 0 0 0.00
500 Personal Services 152,856 155,200 153,500 150,900 0 150,900 -2.77
600 Operating Expense
631400 Engineering Fees 66,353 120,000 90,400 120,000 0 120,000 0.00
634210 Info Tech Automation Allocation 400 700 700 500 0 500 -28.57
634251 Flood Control Swale Maint 70,789 226,900 216,600 201,900 0 201,900 -11.02
634254 Flood Control Replant Prog -2,416 9,500 600 9,500 0 9,500 0.00
634300 Plan Review Service Util Div 1,200 1,500 0 1,500 0 1,500 0.00
634980 Interdept Payment For Sery 32,646 22,100 20,800 20,800 0 20,800 -5.88
634999 Other Contractual Services 1,807 13,000 7,400 11,900 0 11,900 -8.46
639967 Temporary Labor 71,765 79,700 87,400 79,700 0 79,700 0.00
640200 Mileage Reimbursement Regular 17 0 0 0 0 0 0.00
640410 Motor Pool Rental Charge 21 0 100 0 0 0 0.00
641700 Cellular Telephone 1,711 2,100 1,500 2,100 0 2,100 0.00
641950 Postage Freight And Ups 8 0 0 0 0 0 0.00
643100 Electricity 51 0 0 0 0 0 0.00
643300 Trash and Garbage Disposal 1,593 5,900 2,400 5,900 0 5,900 0.00
645100 Insurance General 2,800 3,000 3,000 3,500 0 3,500 16.67
645260 Auto Insurance 1,000 500 500 500 0 500 0.00
646110 Building R And M Outside Vendors 486 500 0 500 0 500 0.00
646319 Tree Trimming 129,946 25,400 38,400 38,000 0 38,000 49.61
646410 Autos/Trucks Rm Outside Vendors 39 1,500 700 1,500 0 1,500 0.00
646430 Fleet Maint ISF Labor And Overhead 11,832 7,400 7,400 16,200 0 16,200 118.92
646440 Fleet Maint ISF Parts and Sublet 6,628 3,700 20,000 8,400 0 8,400 127.03
646445 Fleet Non Maint ISF Parts and Sublet 2,578 1,200 7,000 2,700 0 2,700 125.00
646810 Boat R And M 217 1,500 400 1,500 0 1,500 0.00
646970 Other Equip Repair Maintenance 6,364 1,500 4,100 1,500 0 1,500 0.00
651110 Office Supplies General 15 0 0 0 0 0 0.00
652130 Clothing And Uniform Rental 1,932 1,600 3,000 1,600 0 1,600 0.00
652140 Personal Safety Equipment 908 1,000 900 1,000 0 1,000 0.00
652310 Fertilizer Herbicides And Chemicals 27,400 139,300 119,800 139,300 0 139,300 0.00
652490 Fuel and Lubricants ISF Billings 1,723 2,100 4,300 1,700 0 1,700 -19.05
652910 Minor Operating Equipment 798 0 0 0 0 0 0.00
652990 Other Operating Supplies 4,839 2,600 2,800 3,000 0 3,000 15.38
600 Operating Expense 445,448 674,200 640,200 674,700 0 674,700 0.07
700 Capital Outlay
764110 Autos And Trucks 0 34,000 0 35,000 0 35,000 2.94
764990 Other Machinery And Equipment 0 7,500 8,000 80,000 0 80,000 966.67
700 Capital Outlay 0 41,500 8,000 115,000 0 115,000 177.11
182602-109 Water Management Field Operations 598,304 870,900 801,700 940,600 0 940,600 8.00
182900-109 Right Of Way Beautification i
GovMax 2 4/23/2019
Agenda item#6b
Page 3 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU
182900-109 Right Of Way Beautification i
500 Personal Services
512100 Regular Salaries 55,108 37,975 38,400 38,663 0 38,663 1.81
512600 ER 457 Deferred Comp 0 170 0 170 0 170 0.00
514100 Overtime 133 0 0 0 0 0 0.00
515000 Vacation Sell Back 0 94 0 95 0 95 1.06
519100 Reserve For Salary Adjustment 0 759 0 1,047 0 1,047 37.94
521100 Social Security Matching 3,974 2,977 2,900 3,055 0 3,055 2.62
522100 Retirement Regular 4,433 3,395 3,200 3,607 0 3,607 6.24
523150 Health Insurance 13,231 8,908 8,900 8,908 0 8,908 0.00
523152 Dental Insurance 496 334 300 340 0 340 1.80
523153 Short Term Disability Ins 92 68 100 68 0 68 0.00
523154 Long Term Disability Ins 193 136 100 136 0 136 0.00
523160 Life Insurance Short-Long Term 155 108 100 111 0 111 2.78
524100 Workers Compensation Regular 66 76 100 100 0 100 31.58
500 Personal Services 77,882 55,000 54,100 56,300 0 56,300 2.36
600 Operating Expense
634207 IT Capital Allocation 0 0 0 200 0 200 100.00
634210 Info Tech Automation Allocation 300 500 500 11,100 0 11,100 2,120.00
634805 Emergency Maint And Repair 87 4,500 3,300 4,500 0 4,500 0.00
634999 Other Contractual Services 38,567 50,000 40,000 55,000 0 55,000 10.00
639964 Storage Contractor 661 900 700 900 0 900 0.00
640300 Out Of County Travel Prof Devel 449 0 0 0 0 0 0.00
641150 Telephone Beepers Base Cost 356 2,200 400 300 0 300 -86.36
641400 Telephone Direct Line 2,552 3,000 2,500 2,300 0 2,300 -23.33
641950 Postage Freight And Ups 1,153 2,000 1,500 1,500 0 1,500 -25.00
644100 Rent Buildings 12,892 13,000 13,700 13,800 0 13,800 6.15
644600 Rent Equipment 1,564 2,800 2,000 1,500 0 1,500 -46.43
645100 Insurance General 500 500 500 400 0 400 -20.00
647110 Printing Binding Outside Vendors 487 2,300 1,500 1,200 0 1,200 -47.83
649030 Clerks Recording Fees Etc 1,248 1,200 1,000 1,200 0 1,200 0.00
649100 Legal Advertising 395 1,200 600 1,200 0 1,200 0.00
651110 Office Supplies General 2,164 2,100 1,300 2,100 0 2,100 0.00
654360 Other Training Ed Exp 2,700 8,000 2,900 5,000 0 5,000 -37.50
600 Operating Expense 66,075 94,200 72,400 102,200 0 102,200 8.49
700 Capital Outlay
764990 Other Machinery And Equipment 1,000 1,000 0 1,000 0 1,000 0.00
700 Capital Outlay 1,000 1,000 0 1,000 0 1,000 0.00
182900-109 Right Of Way Beautification 144,956 150,200 126,500 159,500 0 159,500 6.19
182901-109 Right Of Way Beautification-77E1
Field
500 Personal Services
512100 Regular Salaries 610,185 665,657 757,500 784,491 0 784,491 17.85
512500 Auto Use Benefit 265 0 0 0 0 0 0.00
512600 ER 457 Deferred Comp 2,030 3,170 2,800 3,000 0 3,000 -5.36
512800 Taxable Deposit 25-30 10,851 0 0 0 0 0 0.00
514100 Overtime 154,610 200,900 180,000 200,900 0 200,900 0.00
515000 Vacation Sell Back 0 3,154 3,000 3,303 0 3,303 4.72
518100 Termination Pay 1,711 0 0 0 0 0 0.00
519100 Reserve For Salary Adjustment 0 13,309 0 28,875 0 28,875 116.96
521100 Social Security Matching 55,248 67,789 72,200 78,074 0 78,074 15.17
522100 Retirement Regular 60,044 58,551 62,200 80,985 0 80,985 38.32
522800 Allowable Taxable Deposit 25-30 -10,851 0 0 0 0 0 0.00
GovMax 3 4/23/2019
Agenda item#6b
Page 4 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU -1
182901-109 Right Of Way Beautification -Field 1
500 Personal Services
523150 Health Insurance 193,094 232,394 232,400 271,694 0 271,694 16.91
523152 Dental Insurance 7,223 8,693 8,700 10,370 0 10,370 19.29
523153 Short Term Disability Ins 1,327 1,774 1,800 2,074 0 2,074 16.91
523154 Long Term Disability Ins 2,801 3,548 3,500 4,148 0 4,148 16.91
523160 Life Insurance Short-Long Term 1,696 1,910 1,900 2,286 0 2,286 19.69
524100 Workers Compensation Regular 34,235 38,551 38,600 45,300 0 45,300 17.51
528200 Allowance Vehicle -265 0 0 0 0 0 0.00
500 Personal Services 1,124,204 1,299,400 1,364,600 1,515,500 0 1,515,500 16.63
600 Operating Expense
634207 IT Capital Allocation 1,200 200 200 400 0 400 100.00
634210 Info Tech Automation Allocation 13,500 19,500 19,500 18,400 0 18,400 -5.64
634212 IT Microsoft Office Allocation 0 0 0 900 0 900 100.00
634253 Flood Control Water Use Chg 92,098 0 108,200 116,800 0 116,800 100.00
634805 Emergency Maint And Repair 0 3,300 0 3,300 0 3,300 0.00
634990 Landscape Incidentals 359 2,500 1,000 2,600 0 2,600 4.00
634999 Other Contractual Services 37,785 53,700 107,200 16,300 0 16,300 -69.65
639966 Pest Control 0 1,100 100 1,100 0 1,100 0.00
639967 Temporary Labor 395,153 469,100 374,000 377,600 0 377,600 -19.51
640410 Motor Pool Rental Charge 0 600 300 0 0 0 -100.00
641700 Cellular Telephone 2,734 4,500 2,600 4,500 0 4,500 0.00
641950 Postage Freight And Ups 20 0 0 0 0 0 0.00
643100 Electricity 2,140 3,500 2,100 5,000 0 5,000 42.86
643300 Trash and Garbage Disposal 2,816 17,700 6,400 17,700 0 17,700 0.00
644600 Rent Equipment 3,800 5,500 5,600 5,500 0 5,500 0.00
645100 Insurance General 10,300 12,300 12,300 11,900 0 11,900 -3.25
645260 Auto Insurance 12,700 11,600 11,600 11,600 0 11,600 0.00
645920 Insurance Claims 291 0 0 0 0 0 0.00
646110 Building R And M Outside Vendors 1,126 500 600 500 0 500 0.00
646311 Sprinkler System Maintenance 18,476 25,000 31,800 35,000 0 35,000 40.00
646314 Maintenance Landscaping 89,865 75,000 78,000 77,100 0 77,100 2.80
646319 Tree Trimming 255,365 303,300 253,800 297,100 0 297,100 -2.04
646320 Landscape Materials 66,545 160,500 158,500 162,500 0 162,500 1.25
646381 Road And Bikepath Repairs 2,842 7,800 4,700 7,800 0 7,800 0.00
646410 Autos/Trucks Rm Outside Vendors 0 100 0 0 0 0 -100.00
646430 Fleet Maint ISF Labor And Overhead 44,640 32,300 32,300 39,000 0 39,000 20.74
646440 Fleet Maint ISF Parts and Sublet 19,030 16,500 16,500 20,000 0 20,000 21.21
646445 Fleet Non Maint ISF Parts and Sublet 7,465 2,600 2,600 8,800 0 8,800 238.46
646970 Other Equip Repair Maintenance 6,945 6,500 6,000 6,500 0 6,500 0.00
649000 Sales Tax Expense 8 0 0 0 0 0 0.00
649010 Licenses And Permits 921 1,700 1,200 1,500 0 1,500 -11.76
651110 Office Supplies General 495 0 0 0 0 0 0.00
652130 Clothing And Uniform Rental 6,798 12,000 10,400 13,500 0 13,500 12.50
652140 Personal Safety Equipment 3,015 5,200 3,600 5,200 0 5,200 0.00
652310 Fertilizer Herbicides And Chemicals 76,739 144,000 106,000 144,000 0 144,000 0.00
652490 Fuel and Lubricants ISF Billings 35,840 42,900 25,200 35,800 0 35,800 -16.55
652910 Minor Operating Equipment 4,524 12,000 11,800 11,000 0 11,000 -8.33
652990 Other Operating Supplies 13,844 11,400 10,900 11,400 0 11,400 0.00
652999 Painting Supplies 0 500 0 500 0 500 0.00
653710 Traffic Signs 3,000 50,000 53,200 50,000 0 50,000 0.00
654360 Other Training Ed Exp 408 0 0 0 0 0 0.00
600 Operating Expense 1,232,785 1,514,900 1,458,200 1,520,800 0 1,520,800 0.39
700 Capital Outlay
GovMax 4 4/23/2019
Agenda item#6b
Page 5 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU i
182901-109 Right Of Way Beautification -Field
700 Capital Outlay
764110 Autos And Trucks 110,447 40,000 38,900 31,000 0 31,000 -22.50
764990 Other Machinery And Equipment 83,034 131,400 83,600 20,000 0 20,000 -84.78
700 Capital Outlay 193,481 171,400 122,500 51,000 0 51,000 -70.25
182901-109 Right Of Way Beautification-Field 2,550,470 2,985,700 2,945,300 3,087,300 0 3,087,300 3.40
919010-109 Reserves
991 Reserves for Contingencies
991000 Reserve For Contingencies 0 385,000 0 130,500 0 130,500 -66.10
991 Reserves for Contingencies 0 385,000 0 130,500 0 130,500 -66.10
993 Reserves for Capital
994500 Reserve For Future Construction And Improv 0 200,000 0 200,000 0 200,000 0.00
993 Reserves for Capital 0 200,000 0 200,000 0 200,000 0.00
998 Reserves for Cash Flow
998000 Reserve For Cash Balance(Ch 129.01 F.S. 0 420,000 0 420,000 0 420,000 0.00
998 Reserves for Cash Flow 0 420,000 0 420,000 0 420,000 0.00
999 Reserves for Attrition
992100 Reserve For Attrition-Salary Savings 0 -25,700 0 -29,000 0 -29,000 12.84
999 Reserves for Attrition 0 -25,700 0 -29,000 0 -29,000 12.84
919010-109 Reserves 0 979,300 0 721,500 0 721,500 -26.32
929010-109 Transferil
961 Trans to 408 Water/Sewer Fd
914080 Transfer To 408 Water/Sewer Op 13,600 17,200 17,200 17,200 0 17,200 0.00
961 Trans to 408 Water/Sewer Fd 13,600 17,200 17,200 17,200 0 17,200 0.00
981q Trans to 506 IT Capital
915060 Transfer To 506 Information Tech Capital 5,500 0 0 0 0 0 0.00
981g Trans to 506 IT Capital 5,500 0 0 0 0 0 0.00
929010-109 Transfer 19,100 17,200 17,200 17,200 0 17,200 0.00
959010-109 Transfers-Elected Officers
855f Trans to Property Appraiser
930600 Budget Transfers Property Appraiser 59,816 71,000 62,000 71,000 0 71,000 0.00
855f Trans to Property Appraiser 59,816 71,000 62,000 71,000 0 71,000 0.00
855h Trans to Tax Collector
930700 Budget Transfers Tax Collector 78,354 125,800 114,900 125,800 0 125,800 0.00
855h Trans to Tax Collector 78,354 125,800 114,900 125,800 0 125,800 0.00
959010-109 Transfers-Elected Officers 138,170 196,800 176,900 196,800 0 196,800 0.00
109 Pelican Bay Beautification MSTBU 3,717,230 5,544,300 4,386,600 5,464,400 76,100 5,540,500 -0.07
111 Unincorp General Fund 1
183801-111 Pelican Bay-Clam Pass Ecosystem Enhance`
600 Operating Expense
634980 Interdept Payment For Sery 7,555 0 0 0 0 0 0.00
634999 Other Contractual Services 109,412 150,000 193,600 150,000 0 150,000 0.00
600 Operating Expense 116,967 150,000 193,600 150,000 0 150,000 0.00
183801-111 Pelican Bay-Clam Pass Ecosystem 116,967 150,000 193,600 150,000 0 150,000 0.00
Enhance
111 Unincorp General Fund 116,967 150,000 193,600 150,000 0 160,000 0.00
GovMax 5 4/23/2019
Agenda item#6b
Page 6 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
320 Clam Bay Restoration II
183800-320 Clam Bay Restoration 11
600 Operating Expense
631400 Engineering Fees 46,117 90,000 157,900 61,000 0 61,000 -32.22
634999 Other Contractual Services , 0 45,800 86,400 51,100 0 51,100 11.57
646319 Tree Trimming 91,918 34,000 14,100 34,000 0 34,000 0.00
646970 Other Equip Repair Maintenance 1,121 2,000 2,500 2,000 0 2,000 0.00
647210 Photo Processing 7,600 0 0 0 0 0 0.00
652990 Other Operating Supplies 0 9,600 11,600 2,000 0 2,000 -79.17
600 Operating Expense 146,756 181,400 272,500 150,100 0 150,100 -17.25
183800-320 Clam Bay Restoration 146,756 181,400 272,500 150,100 0 150,100 -17.25
929010-320 Transfer
903 Trans to 109 PB MSTUBU Fd
911090 Transfer To 109 Pei Bay MSTUBU 0 34,500 34,500 36,900 0 36,900 6.96
903 Trans to 109 PB MSTUBU Fd 0 34,500 34,500 36,900 0 36,900 6.96
929010-320 Transfer 0 34,500 34,500 36,900 0 36,900 6.96
959010-320 Transfers-Elected Officers)
855f Trans to Property Appraiser
930600 Budget Transfers Property Appraiser 2,183 3,800 3,800 3,300 0 3,300 -13.16
855f Trans to Property Appraiser 2,183 3,800 3,800 3,300 0 3,300 -13.16
855h Trans to Tax Collector
930700 Budget Transfers Tax Collector 3,094 6,100 6,000 6,000 0 6,000 -1.64
855h Trans to Tax Collector 3,094 6,100 6,000 6,000 0 6,000 -1.64
959010-320 Transfers-Elected Officers 5,276 9,900 9,800 9,300 0 9,300 -6.06
320 Clam Bay Restoration 152,032 225,800 316,800 196,300 0 196,300 -13.06
322 Pelican Bay Irr& Lndscp
183825-322 Hardscape&Landscape Improvements
600 Operating Expense
631400 Engineering Fees 44,644 0 143,700 0 0 0 0.00
634251 Flood Control Swale Maint 0 500,000 500,400 500,000 0 500,000 0.00
634999 Other Contractual Services 454,144 860,000 2,412,400 300,000 0 300,000 -65.12
644600 Rent Equipment 1,800 0 100 0 0 0 0.00
646311 Sprinkler System Maintenance 5,469 0 0 0 0 0 0.00
646320 Landscape Materials 126,130 231,100 270,400 175,000 0 175,000 -24.28
652990 Other Operating Supplies 4,966 0 300 0 0 0 0.00
653710 Traffic Signs 0 75,000 96,000 0 0 0 -100.00
600 Operating Expense 637,153 1,666,100 3,423,300 975,000 0 975,000 -41.48
700 Capital Outlay
763100 Improvements General 207,456 390,000 512,500 1,650,000 0 1,650,000 323.08
700 Capital Outlay 207,456 390,000 512,500 1,650,000 0 1,650,000 323.08
183825-322 Hardscape&Landscape Improvements 844,609 2,056,100 3,935,800 2,625,000 0 2,625,000 27.67
929010-322 Transferil
873z Advance/Repay to 778 Pel Bay Light
927780 Adv/Repay to 778 Pel Bay Light 0 1,000,000 0 0 0 0 -100.00
873z Advance/Repay to 778 Pel Bay Light 0 1,000,000 0 0 0 0 -100.00
929010-322 Transfer 0 1,000,000 0 0 0 0 -100.00
959010-322 Transfers-Elected Officers
GovMax 6 4/23/2019
Agenda item#6b
Page 7of9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
322 Pelican Bay Irr& Lndscp r
959010-322 Transfers-Elected Officers 1
855f Trans to Property Appraiser
930600 Budget Transfers Property Appraiser 10,110 56,000 56,000 38,300 0 38,300 -31.61
855f Trans to Property Appraiser 10,110 56,000 56,000 38,300 0 38,300 -31.61
855h Trans to Tax Collector
930700 Budget Transfers Tax Collector 14,328 93,000 93,000 76,600 0 76,600 -17.63
855h Trans to Tax Collector 14,328 93,000 93,000 76,600 0 76,600 -17.63
959010-322 Transfers-Elected Officers 24,438 149,000 149,000 114,900 0 114,900 -22.89
322 Pelican Bay kr&Lndscp 869,047 3,205,100 4,084,800 2,739,900 0 2,739,900 -14.51
778 Pelican Bay Light i
182700-778 Street Lighting Operations
500 Personal Services
512100 Regular Salaries 53,924 36,876 38,200 37,525 0 37,525 1.76
512600 ER 457 Deferred Comp 0 165 200 165 0 165 0.00
514100 Overtime 129 0 0 0 0 0 0.00
515000 Vacation Sell Back 0 91 0 92 0 92 1.10
519100 Reserve For Salary Adjustment 0 736 0 1,071 0 1,071 45.52
521100 Social Security Matching 3,890 2,890 2,900 2,965 0 2,965 2.60
522100 Retirement Regular 4,336 3,295 3,100 3,500 0 3,500 6.22
523150 Health Insurance 13,100 8,646 8,600 8,646 0 8,646 0.00
523152 Dental Insurance 491 324 300 330 0 330 1.85
523153 Short Term Disability Ins 91 66 100 66 0 66 0.00
523154 Long Term Disability Ins 191 132 100 132 0 132 0.00
523160 Life Insurance Short-Long Term 154 106 100 108 0 108 1.89
524100 Workers Compensation Regular 64 73 100 100 0 100 36.99
500 Personal Services 76,370 53,400 53,700 54,700 0 54,700 2.43
600 Operating Expense
634210 Info Tech Automation Allocation 300 500 500 200 0 200 -60.00
634999 Other Contractual Services 31,247 36,300 33,900 36,000 0 36,000 -0.83
639964 Storage Contractor 661 800 700 800 0 800 0.00
641100 Telephone Base Cost 0 2,200 300 300 0 300 -86.36
641150 Telephone Beepers Base Cost 280 0 0 0 0 0 0.00
641400 Telephone Direct Line 1,786 3,000 1,300 3,000 0 3,000 0.00
641950 Postage Freight And Ups 0 1,500 500 500 0 500 -66.67
644100 Rent Buildings 12,573 12,600 12,600 13,800 0 13,800 9.52
644600 Rent Equipment 1,257 2,700 1,200 2,000 0 2,000 -25.93
645100 Insurance General 400 400 400 400 0 400 0.00
651110 Office Supplies General 486 800 800 800 0 800 0.00
600 Operating Expense 48,991 60,800 52,200 57,800 0 57,800 -4.93
610 Indirect Cost Reimburs
634970 Indirect Cost Reimbursement 11,000 11,200 11,200 10,000 0 10,000 -10.71
610 Indirect Cost Reimburs 11,000 11,200 11,200 10,000 0 10,000 -10.71
700 Capital Outlay
764990 Other Machinery And Equipment 0 0 0 1,000 0 1,000 100.00
700 Capital Outlay 0 0 0 1,000 0 1,000 100.00
182700-778 Street Lighting Operations 136,361 125,400 117,100 123,500 0 123,500 -1.52
182701-778 Street Lighting Field Operations
500 Personal Services
512100 Regular Salaries 47,216 47,014 46,000 40,496 0 40,496 -13.86
GovMax 7 4/23/2019
Agenda item#6b
Page 8 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
778 Pelican Bay Light
182701-778 Street Lighting Field Operations 1
500 Personal Services
512500 Auto Use Benefit 257 0 300 300 0 300 100.00
512600 ER 457 Deferred Comp 165 165 200 200 0 200 21.21
514100 Overtime 7,799 5,200 5,200 5,200 0 5,200 0.00
515000 Vacation Sell Back 0 398 0 99 0 99 -75.13
519100 Reserve For Salary Adjustment 0 938 0 1,173 0 1,173 25.05
521100 Social Security Matching 3,939 4,102 4,000 3,188 0 3,188 -22.28
522100 Retirement Regular 4,410 4,227 4,200 3,780 0 3,780 -10.57
523150 Health Insurance 9,563 9,563 9,600 9,563 0 9,563 0.00
523152 Dental Insurance 358 358 400 365 0 365 1.96
523153 Short Term Disability Ins 66 73 100 73 0 73 0.00
523154 Long Term Disability Ins 139 146 100 146 0 146 0.00
523160 Life Insurance Short-Long Term 131 135 100 117 0 117 -13.33
524100 Workers Compensation Regular 1,324 1,481 1,500 1,800 0 1,800 21.54
528200 Allowance Vehicle -257 0 0 0 0 0 0.00
500 Personal Services 75,110 73,800 71,700 66,500 0 66,500 -9.89
600 Operating Expense
631400 Engineering Fees 0 20,000 12,400 20,000 0 20,000 0.00
634210 Info Tech Automation Allocation 200 300 300 200 0 200 -33.33
634805 Emergency Maint And Repair 0 9,600 0 9,600 0 9,600 0.00
634999 Other Contractual Services 627 800 800 800 0 800 0.00
639967 Temporary Labor 32,001 41,000 42,000 41,600 0 41,600 1.46
641700 Cellular Telephone 1,766 1,800 1,600 1,800 0 1,800 0.00
643100 Electricity 32,165 40,000 34,400 38,400 0 38,400 -4.00
644600 Rent Equipment 0 1,800 700 1,800 0 1,800 0.00
645100 Insurance General 900 1,700 1,700 1,300 0 1,300 -23.53
645260 Auto Insurance 900 900 900 900 0 900 0.00
646110 Building R And M Outside Vendors 240 500 200 500 0 500 0.00
646430 Fleet Maint ISF Labor And Overhead 2,232 3,400 3,400 1,900 0 1,900 -44.12
646440 Fleet Maint ISF Parts and Sublet 1,237 5,700 1,200 1,200 0 1,200 -78.95
646445 Fleet Non Maint ISF Parts and Sublet 347 0 5,500 2,300 0 2,300 100.00
646970 Other Equip Repair Maintenance 0 500 200 500 0 500 0.00
652140 Personal Safety Equipment 784 800 800 800 0 800 0.00
652490 Fuel and Lubricants ISF Billings 794 900 900 900 0 900 0.00
652990 Other Operating Supplies 416 0 400 500 0 500 100.00
652992 Electrical Contractors 25,953 62,200 99,900 60,000 0 60,000 -3.54
652993 Light Bulbs Ballast 29,804 38,200 10,500 30,000 0 30,000 -21.47
600 Operating Expense 130,366 230,100 217,800 215,000 0 215,000 -6.56
182701-778 Street Lighting Field Operations 205,476 303,900 289,500 281,500 0 281,500 -7.37
919010-778 Reserves
993 Reserves for Capital
993000 Reserve For Capital Outlay 0 80,000 0 90,000 0 90,000 12.50
994500 Reserve For Future Construction And Improv 0 1,258,500 0 1,535,200 0 1,535,200 21.99
993 Reserves for Capital 0 1,338,500 0 1,625,200 0 1,625,200 21.42
998 Reserves for Cash Flow
998000 Reserve For Cash Balance(Ch 129.01 F.S. 0 150,000 0 150,000 0 150,000 0.00
998 Reserves for Cash Flow 0 150,000 0 150,000 0 150,000 0.00
919010-778 Reserves 0 1,488,500 0 1,775,200 0 1,775,200 19.26
959010-778 Transfers -Elected Officers)
855f Trans to Property Appraiser
GovMax 8 4/23/2019
Agenda item#6b
Page 9 of 9
Expenditure Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
778 Pelican Bay Light II
959010-778 Transfers-Elected Officers 1
855f Trans to Property Appraiser
930600 Budget Transfers Property Appraiser 0 11,900 2,100 9,100 0 9,100 -23.53
855f Trans to Property Appraiser 0 11,900 2,100 9,100 0 9,100 -23.53
855h Trans to Tax Collector
930700 Budget Transfers Tax Collector 10,914 14,900 13,900 14,900 0 14,900 0.00
855h Trans to Tax Collector 10,914 14,900 13,900 14,900 0 14,900 0.00
959010-778 Transfers-Elected Officers 10,914 26,800 16,000 24,000 0 24,000 -10.45
778 Pelican Bay Light 352,751 1,944,600 422,600 2,204,200 0 2,204,200 13.35
Report Total 5,208,026 11,089,800 9,404,400 10,754,800 76,100 10,830,900 -2.16
•
GovMax 9 4/23/2019
Agenda item#6c
Page 1 of 5
•
Revenue Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU i
182601-109 Water Management Administration
307 Delinquent Ad Valorem Taxes
311200 Delinquent Ad Valorem Taxes 147 0 0 0 0 0 0.00
307 Delinquent Ad Valorem Taxes 147 0 0 0 0 0 0.00
325a Special Assessments
325100 Special Assessments 973,565 1,097,100 1,053,200 1,224,400 0 1,224,400 11.60
325a Special Assessments 973,565 1,097,100 1,053,200 1,224,400 0 1,224,400 11.60
340 Charges For Services
341920 Plan Review Billings Bcc 0 1,500 0 0 0 0 -100.00
340 Charges For Services 0 1,500 0 0 0 0 -100.00
361 Interest/Misc
361320 Interest Tax Collector 51 0 400 0 0 0 0.00
361 Interest/Misc 51 0 400 0 0 0 0.00
182601-109 Water Management Administration 973,764 1,098,600 1,053,600 1,224,400 0 1,224,400 11.45
182602-109 Water Management Field Operations
340 Charges For Services
341490 Miscellaneous 3,145 0 0 0 0 0 0.00
340 Charges For Services 3,145 0 0 0 0 0 0.00
360 Miscellaneous Revenues
369130 Ins Co Refunds 821 • 0 3,100 0 0 0 0.00
360 Miscellaneous Revenues 821 0 3,100 0 0 0 0.00
182602-109 Water Management Field Operations 3,966 0 3,100 0 0 0 0.00
182900-109 Right Of Way Beautification)
325a Special Assessments
325100 Special Assessments 2,944,606 3,079,100 2,955,900 2,951,800 0 2,951,800 -4.13
325a Special Assessments 2,944,606 3,079,100 2,955,900 2,951,800 0 2,951,800 -4.13
361 Interest/Misc
361320 Interest Tax Collector 155 0 1,200 0 0 0 0.00
361 Interest/Misc 155 0 1,200 0 0 0 0.00
182900-109 Right Of Way Beautification 2,944,761 3,079,100 2,957,100 2,951,800 0 2,951,800 -4.13
182901-109 Right Of Way Beautification Field) ,
360 Miscellaneous Revenues
364410 Surplus Furniture Fixtures Equip Sale 21,400 0 8,100 0 0 0 0.00
365900 Other Scrap And Surplus Sales 1,300 0 0 0 0 0 0.00
369130 Ins Co Refunds 1,821 0 0 0 0 0 0.00 j
369300 Reimbursement For Prior Year Exp 729 0 900 0 0 0 0.00
360 Miscellaneous Revenues 25,250 0 9,000 0 0 0 0.00
182901-109 Right Of Way Beautification-Field 25,250 0 9,000 0 0 0 0.00
919010-109 Reserves 1
499u Carry Forward
489200 Carryforward 1,385,800 1,534,400 1,724,700 1,453,200 76,100 1,529,300 -0.33
499u Carry Forward 1,385,800 1,534,400 1,724,700 1,453,200 76,100 1,529,300 -0.33
499z Less 5%Required By Law i
489900 Less 5%Required By Law 0 -209,200 0 -209,200 0 -209,200 0.00
499z Less 5%Required By Law 0 -209,200 0 -209,200 0' -209,200 0.00
919010-109 Reserves 1,385,800 1,325,200 1,724,700 1,244,000 76,100 1,320,100 -0.38
929010-109 Transfer
GovMax 1 4/24/2019
.
i ' ,
Agenda item#6c
Page 2 of 5
Revenue Service Level Analysis grouped by Fund,Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
109 Pelican Bay Beautification MSTBU I
929010-109 Transfer
459 Trans fm 320 Clam Bay Cap Fd
481320 Transfer From 320 Clam Bay Restoration 0 34,500 34,500 36,900 0 36,900 6.96
459 Trans fm 320 Clam Bay Cap Fd 0 34,500 34,500 36,900 0 36,900 6.96
929010-109 Transfer 0 34,500 34,500 36,900 0 36,900 6.96
959010-109 Transfers Elected Officers`
392d Trans frm Property Appraiser
486600 Transfer From Property Appraiser 38,072 0 0 0 0 0 0,00
392d Trans frm Property Appraiser 38,072 0 0 0 0 0 0.00
392h Trans frm Tax Collector
486700 Transfer From Tax Collector 31,903 0 31,900 0 0 0 0.00
392h Trans frrn Tax Collector 31,903 0 31,900 0 0 0 0.00
959010-109 Transfers-Elected Officers 69,975 0 31,900 0 0 0 0.00
989010-109 Interest
361 Interest/Misc
361170 Interest SBA 12,916 0 0 0 0 0 0.00
361180 Investment Interest 25,491 6,900 25,900 7,300 0 7,300 5.80
361 Interest/Misc 38,407 6,900 25,900 7,300 0 7,300 5.80
989010-109 Interest 38,407 6,900 25,900 7,300 0 7,300 5.80
109 Pelican Bay Beautification MSTBU 5,441,922 5,544,300 5,839,800 5,464,400 76,100 5,540,500 -0.07
320 Clam Bay Restoration h
183800-320 Clam Bay Restoration
325a Special Assessments
325200 Special Assessment-Capital 0 225,100 216,100 198,600 0 198,600 -11.77
325a Special Assessments 0 225,100 216,100 198,600 0 198,600 -11.77
183800-320 Clam Bay Restoration 0 225,100 216,100 198,600 0 198,600 -11.77
183805-320 Clam Bay Ecosystem Enhancement
325a Special Assessments
325100 Special Assessments 154,702 0 0 0 0 0 0.00
325a Special Assessments 154,702 0 0 0 0 0 0.00
361 Interest/Misc
361320 Interest Tax Collector 8 0 0 0 0 0 0.00
361 Interest/Misc 8 0 0 0 0 0 0.00
183805-320 Clam Bay Ecosystem Enhancement 154,710 0 0 0 0 0 0.00
919010-320 Reserves
499u Carry Forward
489200 Carryforward 98,200 11,500 106,600 7,500 0 7,500 -34.78
499u Carry Forward 98,200 11,500 106,600 7,500 0 7,500 -34.78
499z Less 5%Required By Law
489900 Less 5%Required By Law 0_ -11,300 0 -9,900 0 -9,900 -12.39
499z Less 5%Required By Law 0 -11,300 0 -9,900 0 -9,900 -12.39
919010-320 Reserves 98,200 200 106,600 -2,400 0 -2,400 -1,300.00
959010-320 Transfers-Elected Officers)
392d Trans frm Property Appraiser
486600 Transfer From Property Appraiser 2,040 0 0 0 0 0 0.00
GovMax 2 4/24/2019
Agenda item#6c
Page 3 of 5
Revenue Service Level Analysis grouped by Fund, Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
320 Clam Bay Restoration 1
959010-320 Transfers-Elected Officers
392d Trans frm Property Appraiser 2,040 0 0 0 0 0 0.00
392h Trans frm Tax Collector
486700 Transfer From Tax Collector 1,260 0 0 0 0 0 0.00
392h Trans frm Tax Collector 1,260 0 0 0 0 0 0.00
959010-320 Transfers-Elected Officers 3,299 0 0 0 0 0 0.00
989010-320 Interest
361 Interest/Misc
361170 Interest SBA 782 0 0 0 0 0 0.00
361180 Investment Interest 1,634 500 1,600 100 0 100 -80.00
361 Interest/Misc 2,416 500 1,600 100 0 100 -80.00
989010-320 Interest 2,416 500 1,600 100 0 100 -80.00
320 Clam Bay Restoration 258,626 225,800 324,300 196,300 0 196,300 -13.06
322 Pelican Bay Irr& Lndscp b
183825-322 Hardscape&Landscape Improvements r
325a Special Assessments
325100 Special Assessments 716,515 3,333,700 3,200,400 2,553,800 0 2,553,800 -23.39
325a Special Assessments 716,515 3,333,700 3,200,400 2,553,800 0 2,553,800 -23.39
360 Miscellaneous Revenues
369130 Ins Co Refunds 141,745 0 0 0 0 0 0.00
369802 Reimburse For Current Year Exp 19,966 0 0 0 0 0 0.00
360 Miscellaneous Revenues 161,711 0 0 0 0 0 0.00
361 Interest/Misc
361320 Interest Tax Collector 38 0 0 0 0 0 0.00
361 Interest/Misc 38 0 0 0 0 0 0.00
392h Trans frm Tax Collector
486700 Transfer From Tax Collector 0 0 5,800 0 0 0 0.00
392h Trans frm Tax Collector 0 0 5,800 0 0 0 0.00
183825-322 Hardscape&Landscape Improvements 878,263 3,333,700 3,206,200 2,553,800 0 2,553,800 -23.39
919010-322 Reserves
499u Carry Forward
489200 Carryforward 1,113,500 33,300 1,177,500 310,700 0 310,700 833.03
499u Carry Forward 1,113,500 33,300 1,177,500 310,700 0 310,700 833.03
499z Less 5%Required By Law
489900 Less 5%Required By Law 0 -166,900 0 -127,700 0 -127,700 -23.49
499z Less 5%Required By Law 0 -166,900 0 -127,700 0 -127,700 -23.49
919010-322 Reserves 1,113,500 -133,600 1,177,600 183,000 0 183,000 -236.98
959010-322 Transfers-Elected Officers.'
392d Trans frm Property Appraiser
486600 Transfer From Property Appraiser 30,213 0 0 0 0 0 0.00
392d Trans frm Property Appraiser 30,213 0 0 0 0 0 0.00
392h Trans frm Tax Collector
486700 Transfer From Tax Collector 5,834 0 0 0 0 0 0.00
392h Trans frm Tax Collector 5,834 0 0 0 0 0 0.00
959010-322 Transfers-Elected Officers 36,047 0 0 0 0 0 0.00
989010-322 Interest •II
GovMax 3 4/24/2019
{
Agenda item#6c
Page 4 of 5
Revenue Service Level Analysis grouped by Fund,Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
322 Pelican Bay Irr& Lndscp
989010-322 Interest
361 Interest/Misc
361170 Interest SBA 5,837 0 0 0 0 0 0.00
361180 Investment Interest 12,868 5,000 11,800 3,100 0 3,100 -38.00
361 Interest/Misc 18,705 5,000 11,800 3,100 0 3,100 -38.00
989010-322 Interest 18,705 5,000 11,800 3,100 0 3,100 -38.00
322 Pelican Bay Irr&Lndscp 2,046,514 3,205,100 4,395,500 2,739,900 0 2,739,900 -14.51
778 Pelican Bay Light 1
182700-778 Street Lighting Operations 1
306 Ad Valorem Taxes
311100 Current Ad Valorem Taxes 543,550 585,000 561,600 608,800 0 608,800 4.07
306 Ad Valorem Taxes 543,550 585,000 561,600 608,800 0 608,800 4.07
307 Delinquent Ad Valorem Taxes
311200 Delinquent Ad Valorem Taxes 32 0 0 0 0 0 0.00
307 Delinquent Ad Valorem Taxes 32 0 0 0 0 0 0.00
361 Interest/Misc
361320 Interest Tax Collector 32 0 300 0 0 0 0.00
361 Interest/Misc 32 0 300 0 0 0 0.00
182700-778 Street Lighting Operations 643,613 585,000 561,900 608,800 0 608,800 4.07
182701-778 Street Lighting Field Operations
360 Miscellaneous Revenues
369130 Ins Co Refunds 4,253 0 0 0 0 0 0.00
360 Miscellaneous Revenues 4,253 0 0 0 0 0 0.00
182701-778 Street Lighting Field Operations 4,253 0 0 0 0 0 0.00
919010-778 Reserves 1
499u Carry Forward
489200 Carryforward 1,240,300 386,500 1,460,500 1,618,900 0 1,618,900 318.86
499u Carry Forward 1,240,300 386,500 1,460,500 1,618,900 0 1,618,900 318.86
499z Less 5%Required By Law
489900 Less 5%Required By Law 0 -29,400 0 -30,800 0 -30,800 4.76
499z Less 5%Required By Law 0 -29,400 0 -30,800 0 -30,800 4.76
919010-778 Reserves 1,240,300 357,100 1,460,500 1,588,100 0 1,588,100 344.72
929010-778 Transfer 1
396w Advance/Repay fm 322 Pel Bay Cap
482322 Adv/Repay from 322 Pelican Bay Capital 0 1,000,000 0 0 0 0 -100.00
396w Advance/Repay fm 322 Pel Bay Cap 0 1,000,000 0 0 0 0 -100.00
929010-778 Transfer 0 1,000,000 0 0 0 0 -100.00
959010-778 Transfers -Elected Officers)
392h Trans frm Tax Collector
486700 Transfer From Tax Collector 4,444 0 4,500 0 0 0 0.00
392h Trans frm Tax Collector 4,444 0 4,500 0 0 0 0.00
959010-778 Transfers-Elected Officers 4,444 0 4,500 0 0 0 0.00
989010-778 Interest
361 Interest/Misc
361170 Interest SBA 6,381 0 0 0 0 0 0.00
GovMax 4 4/24/2019
Agenda item#6c
Page 5of5
•
Revenue Service Level Analysis grouped by Fund,Fund Center
Collier County Government Fiscal Year 2020
FY 2018 FY 2019 FY 2019 FY 2020 FY 2020 FY 2020 Adopted
Object Code and Account Name Actual Adopted Annualized Current Expanded Total %Change
778 Pelican Bay Light
989010-778 Interest
361 Interest/Misc
361180 Investment Interest 14,242 2,500 14,600 7,300 0 7,300 192.00
361 Interest/Misc 20,623 2,500 14,600 7,300 0 7,300 192.00
989010-778 Interest 20,623 2,500 14,600 7,300 0 7,300 192.00
778 Pelican Bay Light 1,813,233 1,944,600 2,041,500 2,204,200 0 2,204,200 13.35
Report Total 9,560,295 10,919,800 12,601,100 10,604,800 76,100 10,680,900 -2.19
. j
GovMax 5 4/24/2019
o,
N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 o o o o 0 0 0
co 0 0 00 000000000000000
Lff �' d' co a1 co .p a\ a\ M a\ l n 00 N CT O O N 01 O� d� N d' kr) O
N C N .O N N O o0 O\d' •-, 69 N m O kr, N N .O •-, N N - .O 00
"eal � dw 64 M 00 O d' 69 69 69 69 69 b~9 en 69 69 69 69 64 69
Q H
44 frAy4-
O
to
., 0 0 0 0 0 0 0
wQ N O 69 69 O 00,
SU
2 U V O� 6R N M
a) M 69 O, N
m •GL'0 FA 69 6-
= "Ca'
U RS 9
a
O
Z 4
U
a)
0
J..
Po
et
00 0 0 0 0 0 0
t0. .„ co O En 69 co co co co
V, '-' CT .O M 01
pa
U 5 n 69 O, co .o
69 ER O, O, en
69
5 ?a69
CO)C
U
C
Q to, . rqw c5. . _. r 4 W„a_«, ,,,. .sr„ .:Y',4 *s,IXV,4 .` ' 'z€"a.&:c.covItorlufelzkNt.
an
r aA O O O co co O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
r•+ Q co O 69 69 O O O 0 O O 0 0 0 0 0 0 0 69 O 69 69 69 O 69 69
CA N 4+ rn On en o0 0o N N 0 0 0o en 0 v, oo O d- �h 00
cU C:'
y ,-5. 00 l- 0 00 d0 N o.O in. 69 M 69 M N 69 69 69
,, bA '. 0 69 en co co N ,--, en 69 ,--, 69
U . 69 N 69 64 69 m
t ca
v� a 69 69 0
CD = = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a
•1••I '., C.C! 4, 4. Z o o 69 69 o 0 0 0 69 O 0 0 0 0 0 0 0 69 0 0 0 0 0 0 0 b.
— C� .1.' 1n .--, d: oo O co o O, en en v)oo kn d• O N N N +--- O v
r.I C� O V O V7 .p .-+ .--, N Vi 69 b9 N �--, M �--� 69 — �-4 — •--i N 4- d• d
y N.69 d• v, 00 ,n 69 69 ea 69 en 69 69 69 69 69 69
Cm) o Q rn 00 ea 69 69
`/ �r y E : ,-•i 69
el tip
V ( U ea 69 69
CU 1:1
Pi u r"' O O O O O O O O O O O O O O O O O O O O O O O O O
y 0 0 6R O O O O O O O 69 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O 00 N O, 00 d• t, O M a, N N N rn to N N to t` N O v., to In
++ d 4 00 N •0 N d• Oi 00 O�M 69 N rn ,--I .-1 N Vi 69 .-,ri r. r+ M
Cd +' ti) 4) 69 en , o, N 1r) t .-, kr) ER ER .-, 69 69 .-, 6 6
9 EIS 9 (n 69 69
i. d' 69 EA Cl, .O en .-, 69 69 69
c a 69 — - 69 69
IM., 0 69 69
O
0
O
•
y u)
o
o o
v a 0 o o w > W a0
= M N ad a)
as L a) Q., c) O Tvi p4
o _
cs O
j0c o 0 F, o069 S ot o o
ao 0 0 . 0 ) N 5 0,
O M O = - Oa * U 5 �. 8O O AYN a) O CCU a) 6 a+9 vi
-' dHo � oo 8as n W
' t) a - wo s-, y 5b0
o o'>� ;� ° v
s c aa 5 , a "d C 4 PCo Q —
a) r 0 o 4 CU p4 .� 1 o >1
a)0 OC] Oz "' • ti ° OUy .; .O P . U aUU = ° 0"' oY — O ' N C .
O -. ao 0 ! IUIIBIilI 14 „Cn 0 > . ) En . 4 0 •o 4.1 "O
� iii 4 wP.P. -cs4 rnHE a, ww4 4aa000W 15
L a <t Q w
v
>
G1
0
N o 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O OO O O O O O O O O O 69 O O O O O O O O O O O O
In O O •--t 10 r-, r+ 01 01 00 O dt 10 0o O l� Ln .1- M0 •--t M v� �t 0o O .-, 0\ O
N ,--, ,--, O O N r-, 01 00 , 10 t,00 M O M 1p r-, M M tri N N •--, N N h \O O
O 69 10 00 64 69 10 01 O r-I 6R N N •-, •-1 Ln 'd' 00 M l 69 69 vl 64 .--, r. .--i M
•. N 64 69 M d' N — M 64 69 ER 69 r-, 64 N 69 64 r-, 64 64 64 64
Q..69 69 ER 6R 69 6R 69 64 69
Q
0
OA
r.r. OO O O
41 O O O O
C O O tri
O
G O O — k
ER 69 69 69
O O O O O
O O O O O
O •--, O O O
.-r .-, d' N N-
in
V> M 69 69
64 69 64
i __._.,_ hike $7•44...>,,,,,,,,,,,,,,,.,,,,,,,J.„.,>kii 4. 4 !- -.W., t -„wY 7,, 1.5.3.;,717A ; eTt . b� r ,g+
O O O O O O O O O 0 0 0 0 0 0 O O O O O 0 0 0 0 0 0 0 0 0 0
O 64 O O 64 64 69 O 64 69 69 O 64 69 0 O O 64 O ER 69 64 0 64 069 64 6R O O
O O 00 10 00 01 M Vl 00 00 VI O
O O 64 ,--i ,-1 69 •--i 69 0,5' .--, 1p 64O
N V'J '71- 64 69 M 69 69 M
69 69 69 64 6R m
.a.
0
N
0 O O P 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 41
69 69 69 O O O O O 64 O O O O 64 O O O 64 0 0 0 0 0 0 0 0 0 0 0 69 110R
M %.,0 •-I •-1 10 00 Ln kr) 1--- \0 01 O O n --
O .--, Lkn.,, , 00 O V')
.--, .-i 64 V' N in .— O N •--- M •--1 0.
ER 64 01 N l0 69 .--- — .--- fR tF M N 64 69 .-- 69 .--, .--, .-r
69 N M .-. .-. 69 ER ER ,-I ER 69 r-+ 64 64 64
64 64 ER 64 6R 64
O O O O O O O O O O O O O O O O 0 O O 0 O O O O 0 O O 0 O O
0 O 69 O 69 69 O O O 64 0 0 0 0 0 0 0 69 69 0 6R 64 69 64 0 ER 64 O 0 69
0 V1 01 0 al N.--1 01 00 in WI kr) M. in 10 O
O .-, •--I 01 .--, 01 N Ln O 64 M 6R 01 M •-, M
N._ 69 64 'MER' N N ER 69 69 E14 69 .My 69 69
EA
64 69 69
0
0
O
00
M
64
CD O p N
O p o
O O a O O N w
Ci 0 O M
M . .,
s 74
O r
N
O 6~4 N N 69 0 .� 64 10 64 U U 0O .0 00j 'cd 0 ti
O ,U 64 y MI 4,s ; a g U b ti U �--• g 2 �,
N• '° o o '° W 0 w . ci ni ccl iII �Ui ID a) .sem1 °. N al .-+ N .V-,i :o m °' °o ' H = 0 E -fl ai 0 3 =w° b-ca
at O W C o °° opo U o > nj y 5 as cd 0 z as ca,,.q — p' ¢' ' 0 a) v +a)' a) as a vi o •—, •-, '� 0
on 3 U o a) 0 �, o 3 A a� v2 e U °
$. a > �' E P U 64 0 v] ''CA ,z PJ, ai Q,F, A 0 as a) 0 �' s`n'� �, y O.'d c� N ,a,0
y y > 0 o --. 6 W o _ , b d s' U N Y c� a U U :° ° 0 as N as 0 0 >,O Pa
+' (�i s� O En ai U f--� U 0 b0 m A. y O y ti y 3�, U +�-' .'" U .Q" .-, 'cJ O
es ° Y O x -ci aa) ;-, X Ova A H ani Pa �) Pa es g ;, al e 0, -0 > 'Q 0 .0 0 o .5 .= ,,
o• w a, w0 aaHw Haq aUH3 � . aaHwwcA , w ,I 'z woa
L
a)
o,
o = • .. 0
N 0 0 0 0 0 0 co O O co O O O 01
M N O�
O O o o o o ER O 0 O O o OO N Vo 00
1A O h O O\ O m O V1 N M r 01122 r
N t--7 Q')- o NO — o o rn M r-, o G o 0
64 rn O N N M N NNN 00 N N O M M
•L 69 6R 64 64 ER. 64 00 64 64 .--, ER H s.-.,
i
Q. ,--i 01 H1
Q 64 64
W
0
O
p CD O O O
1/40 en
W
C p .O o0 C p� N
C N 6 ES N. �
64 •-•1 00
64 k.p N
N GS
• M o CC
r-1
kr• r N
VP
ES GS ER 7
O O O
O O co
co M M O.
1O M v3 Nr
6- 64 O\ O
E!3 - N
N N ,_..i
6R
b
" 1,7:4 'o xo'.z F. :4,..v•,•L S,d ... . ,.,- ,x3,. .,.,. ,�.-'.3."-e.,..,35,,,,,,,,11,11,...,,1.6411,.. •.-1
O O O O O O O O O O U
O 69 EA O O O O O O O0 N
00 >.O O O N O1 N N N N O 'O^+
69Cfs'
69 N O 0�0 OMO 0�0 O O 0,
ES .--, 64 N O O O O O -O M
GS •_..; N O O O O O y y_
64 64 .-ti U 0
"C7 M
O 0 0 0 O O O O 0 0 0 "0 bA
0 0 0 0 O O O O O O O CO
N r!1 O M O O d• O ,—+ N O p" i d
tri 64 O M N .-, O 00 O1 +--, ei — O
64 ON - 00 N 00 - N O
Op O
ER N C O
69 N• O ^ 0 ,�-i
M • O 64
O O O N
0 0 0 0 O 0 0 0 O O O M v O
00 6R 64 69 O C O O O O O N 69 F/] .9
r-i O\ N N '-0 O
64 69 .--, �,,,�� U N
69 y� 4, a,
0
O 64
U
H
0 o 0 Y
M O 6)
69 M V]
WGS 00 O ot g Ca N V]
•.. 3 0 , odi CO tin " '-='
Q
o o � � o � oo ° o — ° W _ U E 0
E _
�"' S.' Y CO: ..T.-,-, O 64 ° . CPI Y 3 •° 6' CLI ev y O1 b4 U
1+ O N �+ N
s� cd O 00 C O o o an W d G a O a Q >
p" o N $, „, •O� k" z +, rn t. d w g N ^
-la'
0 N O .� �. -5, 'tom (A w .. FQj
W s: Y s 3i O m ¢ d y (�
a •• .0 7' 5 O N H F+ 3 N . P-i , p cd �y •w F 6) • v+ . Q+
Q H N 42 le
d d PG A
�°� QCQU UU o
m oa N a 3UUU "a o VV Vj.. ° o
CO2O o o
- H
• EN ea d CC N N N y a" s" s. Cl Cl
0N d 7" WW P. d d H04P, HWPaU oUg4 W . HF
.L
g O it
w
>
CO
Ixx�' or Na 000 ( r 0v
O U N N a CO 0, a 0
N ( 0WO 1— rnmO
46 N N O O r ci to(N
0.1 04
69 60
-x-O a a- 2' N ('1 <0 (0
N Q 2 (0 N t
N d 2 O
Q .
J
0 0 N N <0 ro
N 0 0 O N N O N (00 n O. CO CO N 0 M N
O
O O N N N CO• O V N N O I0 CO •N-
ry 0 0) .- N- N.CO m NFA N N 0 69 69
_ d N N ^ m CO
G
u ❑ 2 t
Fn
m
T JJ
O {�
O O O N M ON or •F 0 0 0, 0
cci. Lei
8 O (n a- •- f7 N m N C) <0 1� N to N-
co— N N
CI 2 C
O
LL
J
I
pU0' CO . 0,
V 0 ON N coO <(1 mN
0
pW N N 4 co co oi W m O N (>
O rn O O N NO O N
COgn O N N 4- Nq
• N N co j N N
O ro
• N o
C LL
fl �_ J
LL Y
T u
Y
<00
C YO UN O M N ( <0Oi N
2 7 O . V hO• m 0 0 N N N N
CO m O M 0FN Cs< UN
61Tc ' Z' Z' N 4]4 60
(6 w CO j CO
ra
V c <a > (
t4 U-
✓ T J 1
a
O W 0 0 (0 N 0
a d' N N <t <0 (O N CO N
CO CO
O V O NO 4 V M N O a; orp01 cD N
O 2 N N (O (0 M rn O
pO ,0 07 (NA N N fA MOO
O a 2' 'L' — co c0
• at co co , to
m a it
d
LL
J
J
I
1
W
a
N
g
co F
N
ti I 2
N
d
E I w 1- .
> U N O Ci
Ov U
0
2 m W Z; a
o n W
(
(N n 2
m 0, E
m N it ❑ m v 0
C O u' 1 0 E N
1
t 2' 0I Id c m c
E > 2' v ot0 8 du cr Gi
o Q m Q
a '� U D: K mo?,
I', la v 2 m F. E ❑ � rn'.0,1
.0 0, u dI0 0 0
2 I-- ((/J 0 LL. Q Q 2F- ❑ F- U C=1 N 2 'Q