SWFRPC FY16/17 Adopted Work Plan & Budget ��N1 E S T pZ 0
moo -r
1400 Colonial Blvd.,Suite 1 Fort Myers,FL 33907 _, P:239.938.1813 I F:239.938.1817 www.swfrpc.org
?
0 o�p h
• ,J
,J.Su AN ' 4.%•
0 f'jj7
SUES
REAL sO�' or
August 2, 2016
By
Collier County Clerk of the Circuit Court—Finance
3299 Tamiami Trail E.,Ste.403
Naples, FL 34112-5746
RE: SWFRPC's FY16-17 Work Plan& Budget
Dear Sir or Madam:
At its June 16, 2016 meeting,the Southwest Florida Regional Planning Council(Council)adopted its
FY16-17 Work Plan and Budget, in accordance with the Council's Rule 291-1.007 Budget and Finances:
The Council shall cause to be prepared and shall adopt on or before August 15 of each
year a budget for the development and implementation of the planning and
development programs by such means and through such agencies as the Council shall
determine and shall certify a copy thereof to the Clerk of the governing body of each
local government that is a member.
Upon approval thereof by the governing body each member local government shall
include in its annual budget and cause the levy of a millage sufficient to produce the
amount necessary to fund its proportionate share of the Council's total budget for the
District,which, beyond minimums for individual membership established by the Council,
bears the same ratio to the total budget as the population of each member unit bears to
the total population of the District, all as determined annually by official population
forecasts by the state of Florida for the year preceding each budget determination.
Enclosed is a certified copy of the Council's FY16-17 Work Plan and Budget for your records. Please feel
free to contact me if I can be of further assistance.
Sincerely,
OUTHWEST FLORIDA REGIONAL PLANNING COUNCIL
Marga✓ uerst e,A P
Executi a irector
/nlg
Enclosure
hoJ•ct EST F04,
1400 Colonial Blvd.,Suite 1 Fort Myers,FL 33907 P:239.938.1813 I F:239.938.1817 www.swfrpc.org
m c,
o
pLArno- 4.0
s`ES' HEAL-
FOR A CERTIFIED COPY:
STATE OF FLORIDA
COUNTY OF LEE
On this 16 day of June, 2016, I attest that the attached document is a true, exact, complete,
and unaltered photocopy made by me, Southwest Florida Regional Planning Council, Records
Management Liaison Officer, of the"Southwest Florida Regional Planning Council Annual Budget
for Fiscal Year 2017 Budget,"as adopted by the Southwest Florida Regional Planning Council
on June16,2016. This document is a public record, and the Southwest Florida Regional
Planning Council is its official source.
ichole Gwi -tt
Southwest Florida Regional Planning Council
Records Management Liaison Officer
ADOPTED BUDGET
OCTOBER 1 , 2016 - SEPTEMBER 30, 2016
ADOPTED: JUNE 16, 2016
t
AMENDED: JULY 14, 2016
0 ' '-- '
7
SOUTHWEST FLORIDA
.',4. pLaNNN`(5)..•4 REGIONAL PLANNING COUNCIL
JJoREAL 5o`.
FY 17 PROPOSED BUDGET
OCTOBER 1, 2016 TO SEPTEMBER 30, 2017
Table of Contents
FY17 Proposed Budget Page 1
Revenue Sources(Charts) Page 2
Revenue Sources(Detail) Page 3
5 Year Budget Comparison Page 4
Salary Expenses-(A) Page 5
Health Insurance-(B) Page 6
Consultant Fees—(C) Page 7
Contractual-(D) Page 8
Equipment Rental—(E) Page 9
Insurance-(F) Page 10
Computer Related-(G) Page 11
Dues&Memberships-(H) Page 12
FY 17 PROPOSED BUDGET
OCTOBER 1. 2Q36 TO SEPTEMBER 30. 2017
Revenues SWFRPC General SWFRPC Special
Fund Revenue 2017 Budget Totals
Assessments $ 485,948 $ $ 485,948
Secured Federal/State Grants 96,934 96,934
*Program Development(Unsecured Grants/Contracts) 150,000 150,000
Secured Contractual 3,900 3,900
DRIB/NOPCs/Other Reviews 35,000 35,000
Interest/Mist 6,000 6,000
*`Fund Balance from Audit YE 9/30/15(FY14/15) 588,437 588,437
Total Income(Revenue) $ 1,080,385 $ 285,834 $ 1,366,219
Expenditures(Expenses)
Direct:
Salaries (A) $ 218,569 $ 207,472 $ 426,041
FICA 32,592
32,592
Unemployment --
Workers Compensation 3,687 - 3,687
Retirement 47,769 - 47,769:
Health Insurance (B) 63,090 - 63,090
Total Personnel Expenses $ 365,707 $ 207,472 $ 573,179
Expenses
Consultants (C) $ 33,100 $ $ 33,100
Grant/Consulting-Contractual (D) - -
Audit Fees 25,000 25,000
Travel 6,000 9,680 15,680
Telephone 5,100 5,100
Postage 1,500 125 1,625
Equipment Rental(E) 7,190 - 7,190
Insurance (F) 10,566 - 10,566
Repair/Maint.(Grounds/Bldg/Equip) 500500
Printing/Reproduction 2,581 100 2,681
Utilities(Elec/Internet) 13,200 - 13,200
Advertising 600 1,150 1,750
Other Miscellaneous 200200
•
Bank Service Charges -
-
Office Supplies 4,0004,000
Computer Related Expenses (G) 21,671 - 21,671
Dues and Memberships (H) 25,310 - 25,310
Publications 100 - 100
Professional Development 1,000 - 1,000
Meetings/Events 1,250 - 1,250
Capital Outlay-Operations 5,000 - 5,000
Capital Outlay-Building 1,000 - 1,000
Lease Long Term 42,000 - 42,000
**Fund Balance from Audit YE 9/30/15(FY14/15) 588,437 - 588,437
Operational Expense 5 795,305 $ 11,055 $ 806,360
Fringe/Indirect Allocation $ (67,307) $ 67,307 $ -
Utilized Reserve (13,320) (13,320)
Total Operational Expenses $ 714,678 $ 78,362 $ 793,040
Total Cash Outlays $ 1,080,385 $ 285,834 $ 1,366,219
Net Income/Loss $ 0 $ - $ 0
*This amount was determined based on three previous years budgets which brought in at least$100,000 in additional revenue after the budget was
adopted
**Fund Balance from Audit YE 9/30/15(FY14/15)-included in this fund is the investments,operating funds and net of all assets and liabilities as of
9/30/15.
REVENUE SOURCES
BUDGET REVENUES AMOUNT
County/City Assessments $ 485,948
Secured Federal/State Grants 96,934
Program Development(Unsecured Grants/Contracts) 150,000
Secured Contractual 3,900
DRIs/NOPCs/Other Reviews 35,000
Interest/Misc 6,000
Total Revenue $ 777,782
BUDGET REVENUES
35,000 `:County/City Assessments
3,900 6,000
_;Secured Federal/State Grants
Program Development
(Unsecured Grants/Contracts)
Secured Contractual
4010104A4- .. •DRIs/NOPCs/Other Reviews
Interest/Misc
CASH,CASH EQUIVALENTS, INVESTMENTS(as of May 30, 2016): AMOUNT
FineMark Bank-MM $ 534,576
Local Government Surplus-Fund A 135,912
Petty Cash 200
FineMark-Operating 88,556
Total Cash,Cash Equivalents,Investments $ 759,244
CASH,CASH EQUIVALENTS,INVESTMENTS
200 •FineMark Bank-MM
Local Government Surplus-
Fund A
Petty Cash
FineMark-Operating
FY 17 REVENUE SOURCES
OCTOBER 1, 2016 TO SEPTEMBER 30, 2017
GENERAL REVENUES SPECIAL REVENUES
Interest/Misc. $ 6,000 Federal/State Grants $ 96,934
Assessments $ 485,948 Contractual $ 188,900
$ 491,948 $ 285,834
Total Revenues $ 777,782
FY15 Fund Balance $ 588,437
Total Budget $ 1,366,219
MEMBER POPULATION 2015 (BEBR Estimates) ASSESSMENT
Charlotte County 167,141 $ 50,142
Collier County 343,802 103,141
Glades County 12,853 3,856
Hendry County 38,096 11,429
Lee County(Unicorporated) 367,608 110,282
City of Cape Coral 166,508 49,952
City of Fort Myers 72,395 21,719
Town of Fort Myers Beach 6,264 1,879
City of Bonita Springs 46,568 13,970
City of Sanibel 6,502 1,951
Sarasota County 392,090 117,627
Total Assessments 1,619,827 $ 485,948
Additional Revenue TOTAL
Interest/Misc. $ - $ 6,000
ABM Sponsorship - -
Total General Revenues $ 491,948
SPECIAL REVENUES FEDERAL/STATE GRANTS CONTRACTUAL TOTAL
DEM-Title III $ 44,250 $ - $ 44,250
FL CTD-Glades/Hendry TD 28,880 - 28,880
Collier Hazard Analysis 8,054 - 8,054
Economic Development 15,750 - 15,750
SCQG-Glades 3,900 3,900
DRI/NOPC Fees 35,000 35,000
Program Development(Unsecured 150,000 150,000
Grants/Contracts)
Total RPC Special Revenues $ 96,934 _ $ 188,900 $ 285,834
Assessments based upon official Bureau of Business and Economic Research population estimates.
Assessments are estimated at 30 cents/capita as provided for in the Council's Interlocal Agreement,adopted November 8,1973.
SWFRPC 5 YEAR BUDGET COMPARISON
Fiscal Year 2012-Fiscal Year 2016
Actual Actual Actual � Actual FY Budget
FY 2012 FY 2013 FY 2014 2015 FY 2016
I Amendment
Revenues _
Assessments $ 459,517 $ 462,218 $ 469,411 $ 472,879 $ 477,787
Federal/State/Local Funds/Contract. 1,890,422 1,839,113 1,581,167 399,968 557,025
Contractual 190,067 90,600
DRIs/NOPCs/Monitoring 93,546 42,625 41,265 88,523 35,000
Interest/Misc 9,565 24,732 39,057 4,347 6,372
Rental Income 28,750 15,000 1,250
Fund Balance 542,977 708,484 748,896 588,437 588,437
Total Income $ 2,996,027 $ 3,105,922 $ 2,894,796 $ 1,745,471 $ 1,755,221
Expenditures
,
Direct:
Salaries-Total $ 1,165,861 $ 1,006,838 $ 982,363 $ 609,843 $ 519,301
FICA/Workers Comp/Unemployment 101,321 83,783 76,524 49,691 43,414
Retirement 60,395 63,019 101,994 63,714 60,084
Health Insurance 127,272 118,764 136,255 98,290 79,799,
Total Personnel Services $ 1,454,849 $ 1,272,403 $ 1,297,136 $ 821,538 $ 702,598
Legal fees
Consultant Fees 59,430 87,014 35,525 57,588 54,843
Grant/Consulting Expense 63,533 92,384
NEP Contractual 275,454 326,993 356,951
NEP-Other
MPO Contractual 89,523
Audit Fees 44,430 43,543 41,000 36,820 30,000
Travel 32,500 42,369 48,185 27,273 40,000
Telephone 6,754 8,224 6,554 5,749 5,100
Postage 30,524 19,925 1,655 3,173 4,975
Equipment Rental 21,961 7 016 6,799 7,964 7,335
Insurance 21,559 25,091 20,683 22,970 17,207
Repair/Maint.(Grounds/Bldg/Equip) 15,668 17,497 19,499 10,311 5,000
Printing/Reproduction 53,373 73,954 5,539 6,431 8,571
Utilities(Elec,water,garb) 22,572 22,226 23,470 20,889 12,500
Advertising 10,018 3,218 2,827 7,766 2,750
Other Miscellaneous 9,897 3,979 4,923 5,162 1,000
Uncollectable Receivables 19,000
Bank Service Charges 1,133 2,745 2,200
Office Supplies 13,695 13,870 9,853 4,494 5,000
Computer Related Expenses 39,155 40,011 41.876 27,326 24,319
Publications 1,496 226 1,338 211 200
Bad debt 19,736
Dues and Memberships 32,659 35,484 14,037 25,510
Professional Development 37,486 3,225 3,000
Meetings/Events 22,333 20,580 3,065 26771 20,000
Mov,ng 42,500
Cap tal Outlay-Operations 15,056 27,792 15 375 6,000
Capital Outlay-Building 4,324 8,185 1 000
Long Term Debt(Building Loan) 127,751 127.751 127,751 127.751 21,292
Lease Long Term 31,500
Events 1.436
Reserve for Operations Expense 542,977 708,484 748,896 588,437 588,437
Total Cash Outlays $ Z972,919 $ 2,940,415 $ 2,854,384_$ 1,905,930 $ 1,755,221
Net Income/(Loss) $ 23,109 $ 165,507 $ 40,412 $ (160,459) $ -
SALARY EXPENSES
TABLE (A)
POSITION TITLE CLASSIFICATION 10/1/2015 HOURLY ANNUAL
CLASSIFICATION LEVEL SALARY RANGE RATE SALARY
Executive Director Exempt As determined by Council $ 57.13 $ 118,830
Regional Counsel Exempt 15,450
Planner IV (Environmental) Exempt 27.53 - 39.89 33.64 69,971
Planner II Exempt 20.07 - 31.74 26.29 54,683
Planner I Exempt 18.90 - 27.31 27.79 57,803
Planner I Exempt 18.90 - 27.31 19.57 40,706
GIS Manager Exempt 20.26 - 32.99 32.98 68,598
Total $ 426,041
HEALTH INSURANCE
TABLE (B)
INSURANCE TYPE COVERAGE AMOUNT
Health Employee Only $ 53,103
Dental Employee Only 2,609
Lincoln:Life and Disability(Short&Long
Terms) Employee Only 6,778
FSA Employee Only 600
Total $ 63,090
HEALTH INSURANCE
CHART(B)
$70,000
$60,000
$53,103
$50,000
$40,000
$30,000
$20,000
$10,000 6,778
2,609 600
111111
Health Dental Lincoln:Life and FSA
Disability(Short&Long
Terms)
CONSULTANT FEES
TABLE (C)
CONSULTANT DESCRIPTION AMOUNT
Hughes Snell &Co. CPA Firm-Review of Financials,Budget and Audit assistance $ 7,650
Trescott Planning Solutions,LLC Planning Services 12,000
WGCU Public Media Annual Report 4,800
Foster&Foster Annual preparation of OPEB obligation(Audit requirement) 3,150
Genesis IT- support/consulting 3,500
Clerk of Courts IT-support/consulting 2,000
Total $ 33,100
CONSULTANT FEES
CHART(C)
$14,000 12,000
$12,000
$10,000 -
$8,000 — $7,650
$6,000
$4,000 ____ 3150 3,500
2,000
$2,000 - _
$- 1e I
w m e e
To
U O w y « r
c Z d p E 0
c vii ac "- L. o c
ii a 00 T. O u { u
CQ . -1
N _ C O N
O r _A Q RIID a a
N 'O
O Oo.
cam;51 a 4 W a N N
m O p H
F
4,5 To
4..
u m 1.s5o
u
Hughes Snell & Trescott WGCU Public Foster&Foster Genesis Clerk of Courts
Co. Planning . Media
Solutions,LLC
CONTRACTUAL
TABLE (D)
GRANT DESCRIPTION AMOUNT
HMEP-Contract not received as of 6/2016
Total $
CONTRACTUAL
CHART(D)
r_____
51
si
51
51
5o i_..
50 1
$
HMEP-Contract not received as of 6/2016
EQUIPMENT RENTAL
TABLE (E)
DESCRIPTION
IKON Rioch copier $ 5,038
Mail Finance Postage Machine $ 1,852
Culligan Water Water Cooler $ 300
Total $ 7,190
f_______
EQUIPMENT RENTAL
CHART(E)
$6,000
$5,038
$5,000
$4,000
$3,000
$2,000 $1,852
$1,000
$300
$-
Rioch copier Postage Machine Water Cooler
IKON Mail Finance Culligan Water
INSURANCE
TABLE (F)
POLICY DESCRIPTION PREMIUM
Business Owners General Liability -$2,000,000 $ 3,434
Director's&Officers Liability $1,000,000 each occurrence 4,550
Auto Property Damage/Uninsured Motorist 2,152
Crime Employee dishonesty-$100,000 430
Total $ 10,566
INSURANCE
CHART(F)
$5,000 -4-550__.. ,.
$4,500 _
$4,000 $3,434
$3,500
$3,000
$2,500 2,152
$2,000
$1,500
$1,000 430
$500 ,
General Liability - $1,000,000 each Property Damage/ Employee dishonesty-
$2,000,000 occurrence ;' Uninsured Motorist $100,000
Business Owners Director's&Officers Auto Crime
Liability
COMPUTER RELATED
TABLE (G)
LICENSES AMOUNT
Sage Peachtree(Accounting Software) $ 2,217
REMI(Modeling Software) 4,500
ArcView(GIS) 8,650
VM 1,000
Bill Quick 1,750
Total Licenses $ 18,117
OTHER AMOUNT
Hardware&Misc. $ 2,527
Internet Connection-Clerk of Courts(Firewall) 1,027
Total Expenses $ 21,671
COMPUTER RELATED
CHART (G)
$20,000 $18,117
$18,000
$16,000
$14,000 - -
$12,000
$10,000
$8,000
$6,000
$4,000 $2,507
$2,000 1,027 —
S- ___11111111111
Total Licenses Hardware&Misc. Internet Connection-
aerk of Courts(Firewall)
e —J
DUES & MEMBERSHIPS
TABLE (H)
ORGANIZATION DESCRIPTION AMOUNT
FRCA Florida Regional Council Association $ 20,500
ULI Urban Land Institute 215
Florida Heartland Regional Economic Development
FHREDI Initiative 2,500
Misc. Misc. 500
Total $ 23,715
GRANT RELATED
SUBSCRIPTIONS DESCRIPTION AMOUNT
FEDC Florida Economic Development Council 300
IEDC IEDC 1,295
Total Grant Related $ 1,595
Total $ 25,310
DUES & MEMBERSHIPS
CHART (H)
$25,000
$20,500
$20,000
$15,000
$10,000 ./
$5,000 2,51311
215 500 300 1,295
Florida Regional, Urban Land Florida Misc. Florida IEDC
Council Institute Heartland Economic
Association Regional Development
Economic { Council
Development
Initiative
1 FRCA ULI FHREDI Misc. FEDC IEDC