SWFRPC FY16 Adopted Budget SOUTHWEST FLORIDA REGIONAL
PLANNING COUNCIL
FY1 • ADOPTED 6UDET
Ocituix,r 1, 2015 fa- SerhFr 30, 2016
I
SNNEST F z 0
ce 9/0
1926 Victoria Avenue!Fort Myers,FL 33901 m P:239.338.2550 F:239.338.2560 !www swfrpc org
V
0 .z.
S.is. °LANN"N�' SAC
St,ES •RE Al.S°-
1
August 11,2015 up o r`?
- n c1, t-
In
Collier County Clerk of the Circuit Court—Finance =C r'�=-
3299 Tamiami Trail E., Ste.403 ° co _ci n
Naples, FL 34112-5746 c-)
O
1 +'
RE: SWFRPC's FY2016 Work Plan& Budget o �
- , w
cn •
Dear Sir or Madam:
At its August 6,2015 meeting,the Southwest Florida Regional Planning Council(Council)adopted its
FY2016 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 FY2016 Work Plan and Budget for your records. Please feel
free to contact me if I can be of further assistance.
Sincerely,
OUTHWEST FLORIDA REGIO AL PLANNING COUNCIL
Margaret uerstle,AICP
Executiv erector
/nlg
Enclosure
hoJ�N.4esr F[oq,�
1926 Victoria Avenue I Fort Myers,FL 33901 T P.239.338.2550 I F:239.338.2560 www.swfrpc.org
O
•S` 04.9�•LANt4%. `OM
ss`ES•REAL01"
FOR A CERTIFIED COPY:
STATE OF FLORIDA
COUNTY OF LEE
On this 11 day of August,2015, 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 2016 Budget,"as adopted by the Southwest Florida Regional Planning Council
on August 6,2015. This document is a public record, and the Southwest Florida Regional
Planning Council is its official source.
.■ /AO,
Nichole Gwi °ett
Southwest Florida Regional Planning Council
Records Management Liaison Officer
"\N EST p
,<ST• '0,9
• ..epok •
-J
m G
0 ......./..„
....----,.... :,
„.„......:„...,_ ,,, ..-_„.
s-
• REAL -
SOUTHWEST FLORIDA REGIONAL PLANNING COUNCIL
ADOPTED BUDGET
FY 2016
OCTOBER 1, 2015 TO SEPTEMBER 30, 2016
VII I (r1 , • --
, ...
„,,,,,- - \ -T---:-,
„ .„- \ .. ,
ir
7„., -
i
., .4:44-''/' ./• , . .
1
N
* ——
oe .
, ......
k
. 1
a ,
_.,'...-ti-
N.;'.....
. .
•
\ . ,
-/
_. _•d- t
. .
..
.. r
,04 / i F.: : .
,.../. . i .. .
.
. . -.4
"--.
.
4 / . - . -
--_ ...,...•
...-----■-.... •••• /
14.'4, ,,:.4"40,,,,i j
. i '
: . le'.' . ;;• ',,., .,
-„,
,,,.
. -... --...,, . 4 ,,
1
.. , , ;
— -
„ ...
\ ' .
. ,
■ . ,....1.,.. ., 4.:2
FY 16 PROPOSED BUDGET
OCTOBER 1,2015 TO SEPTEMBER 30,2016
Table of Contents
FY16 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 16 ADOPTED BUDGET
OCTOBER 1, 2015 TO SEPTEMBER 30, 2016
Revenues SWFRPC General SWFRPC Special 2016 Budget Totals
Fund Revenue
Assessments $ 477,787 $ - $ 477,787
Secured Federal/State Grants 187,266 187,266
*Program Development(Unsecured Grants/Contracts) 100,000 100,000
Secured Contractual - 70,150 70,150
DRIB/NOPCs/Other Reviews - 35,000 35,000
Rental/Interest/Mist 1,500 - 1,500
Fund Balance 640,816 - 640,816
Total Income(Revenue) $ 1,120,103_$ 392,416_$ 1,512,519
Expenditures(Expenses)
Direct:
Salaries (A) $ 316,875 $ 170,223 $ 487,098
FICA 37,263 - 37,263
Unemployment -
Workers Compensation 3,687 - 3,687
Retirement 35,084 - 35,084
Health Insurance (B) 79,799 79,799
Total Personnel Expenses $ 472,708 $ 170,223 $ 642,931
Expenses
Consultants (C) $ 21,100 $ 12,000 $ 33,100
Contractual (D) - 18,100 18,100
Audit Fees 32,000 32,000
Travel 2,500 10,460 12,960
Telephone 5,100 5,100
Postage 2,000 15 2,075
Equipment Rental(E) 7,335 7,335
Insurance (F) 23,207 23,207
Repair/Maint.(Grounds/Bldg/Equip) 5,000 5,000
Printing/Reproduction 2,000 580 2,580
Utilities(Elec,water,garb) 21,500 21,500
Advertising 1,900 850 2,750
Other Miscellaneous 2,000 150 2,150
Bank Service Charges 2,700 2,700
Office Supplies 4,000 4,000
Computer Related Expenses (G) 22,969 22,969
Publications 200 200
Professional Development 1,000 2,000 3,000
Dues and Member,hips (H) 23,915 1,595 25,510
Meetings/Events 1,000 250 1,250
Capital Outlay-Operations 5,000 5,000
Capital Outlay-Building 4,000 4,000
Long Term Debt 128,000 128,000
Fund Balance 640,816 640,816
Operational Expense _ $ 959,242 $ 46,060 $ 1,005,302
Fringe/Indirect Allocation $ (176,133) $ 176,133 $ -
Utilized Reserve $ (135,714) $ (135,714)
Total Operational Expenses $ 647,395 $ 222,193 $ 869,588
Total Cash Outlays _ $ 1,120,103 $ 392,416_ $ 1,512,519
Net Income/Loss $ (0) $ - $ (0)
'This amount was determined based on three previous years budgets which brought in at least$100,000 n additional revenue after the budget was
adopted Page 1 of 12
REVENUE SOURCES
BUDGET REVENUES AMOUNT
County/City Assessments $ 477,787
Secured Federal/State Grants 187,266
Program Development(Unsecured Grants/Contracts) 100,000
Secured Contractual 70,150
DRIs 35,000
Rental/Interest/Misc 1,500
Total Revenue $ 871,703
BUDGET REVENUES
35,000 County/City Assessments
70,150
1,500 •Secured Federal/State Grants
100,000
Program Development
(Unsecured Grants/Contracts)
Secured Contractual
DRIB
Rental/Interest/Mist
CASH,CASH EQUIVALENTS, INVESTMENTS(as of June 30, 2015): AMOUNT
Iberia Bank-MM $ 318,813
Local Government Surplus-Fund A 134,496
Petty Cash 200
Bank of America-Operating 27,509
Total Cash,Cash Equivalents,Investments $ 481,018
CASH,CASH EQUIVALENTS, INVESTMENTS
27,509
200
Iberia Bank MM
Local Government Surplus-
Fund A
Petty Cash
Bank of Amer ca Operating
Page 2 of 12
FY 16 REVENUE SOURCES
OCTOBER 1, 2015 TO SEPTEMBER 30, 2016
GENERAL REVENUES SPECIAL REVENUES
Rental/Interest/Misc. $ 1,500 Federal/State Grants $ 187,266
Assessments $ 477,787 Contractual $ 205,150
$ 479,287 $ 392,416
Total Revenues $ 871,703
Prior Year Fund Balance $ 640,816
Total Budget $ 1,512,519
MEMBER POPULATION (2014 BEBR Estimates) ASSESSMENT
Charlotte County $ 164,467 $ 49,340
Collier County 336,783 101,035
Glades County 12,852 3,856
Hendry County 37,895 11,369
Lee County 525,489 157,647
City of Fort Myers 45,819 13,746
Town of Fort Myers Beach 69,437 20,831
City of Bonita Springs 6,250 1,875
City of Sanibel 6,490 1,947
Sarasota County 387,140 116,142
Total Assessments $ 1,592,622 $ 477,787
Additional Revenue TOTAL
Rental/Interest/Misc. $ 1,500
ABM Sponsorship $ -
-
Total General Revenues $ 479,287
SPECIAL REVENUES FEDERAL/STATE GRANTS CONTRACTUAL TOTAL
DEM-Title III $ 48,000 $ 48,000
DEM-HMEP Planning&Training 22,000 22,000
FL CTD-Glades/Hendry TD 38,573 38,573
MARC 6,000 6,000
Hazard Analysis 9,693 9,693
Economic Development 63,000 63,000
City of Bonita Springs-Spring Creek 30,000 30,000
Visit Florida 4,000 4,000
Mangrove Loss 32,250 32,250
SQG-Glades 3,900 3,900
DRI/NOPC Fees 35,000 35,000
Program Development(Unsecured
Grants/Contracts) 100,000 100,000
-
Total RPC Special Revenues $ 187,266 $ 205,150 $ 392,416
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.
Page 3 of 12
SWFRPC 5 YEAR BUDGET COMPARISON
Fiscal Year 2011- Fiscal Year 2015
Budget Budget
Actual Actual Actual Actual FY 2015 Amendment
FY 2011 FY 2012 FY 2013 FY 2014 FY 2015
(Amended)
(Proposed)
Revenues
Assessments $ 466,669 $ 459,517 $ 462,218 $ 469,411 $ 472,941 472,941
Federal/State/Local Funds/Contract. 2,591,297 1,890,422 1,839,113 1,581,167 358,630 428,894
Contractual 199,169 123,881
DRIs 215,357 93,546 42,625 41,265 74,510
Interest/Misc 14,813 9,565 24,732 39,057 1,541
Rental Income 28,750 15,000 7,500
Fund Balance 519,868 542,977 708..484 748,896 748,895 748,895
Total Income $ 3,808,004 $ 2,996,027 $ 3,105,922 $ 2,894,796 $ 1,787,135 $ 1,850,662
Expenditures
Direct
Salar es-Total $ 1,785,396 $ 1,165,861 $ 1,006,838 $ 982,363 $ 694,945 $ 576,520
FICA/Workers Comp/Unemployment 135,632 101,321 _ 83,783 76,524 55,538 48,517
Retirement 170,332 60,395 63,019 101,994 56,166 56,166
Health Insurance 176,024 127,272 118,764 136,255 125,579 100,884
Total Personnel Services $ 2,267,385 $ 1,454,849 $ 1,272,403 $ 1,297,136 $ 932,228 $ 782,087
Legal fees 0 0
Consultant Fees 64 094 59,430 87,014 35,525 46,850 46,850
Contractual 54,396 54,396
NEP Contractual 233,995 275,454 326,993 356,951 0
NEP-Other
MPO Contractual 246,699 89,523
Audit Fees 46,220 44,430 43,543 41,000 40,000 34,620
Travel 39,442 .32,500 42,369 48,185 35,670 24,670
Telephone 12,093 6,754 8,224 6,554 5.100 5,100
Postage 23,767 30,524 19,925 1,655 4,287 4,287
Equipment Rental 29,253 21,961 7,016 6,799 7,015 7,015
Insurance 19,820 21,559 25,091 20,683 22,500 22,500
Repair/Maint.(Grounds/Bldg/Equip) 20,937 15,668 17,497 19,499 15,000 10,000
Printing/Reproduction 93,224 53,373 73,954 5,539 6,190 6,190
Utilities(Elec,water,garb) 24,411 22,572 22,226 23,470 23,200 20,700
Advertising 16,558 10,018 3,218 2,827 2,454 2,454
Other Miscellaneous 4,491 9,897 3,979 4,923 4,500 3,000
Uncollectable Receivables 19,000 7,233 0
Bank Service Charges 1,133 2,745 7,700 2,700
Office Supplies 17,637 13,695 13,870 9,853 5.175 3,175
Computer Related Expenses 56,993 39,155 40,011 41,876 27,070 24,070
Publications 2,476 1.496 226 1,338 461 14.700
Dues and Memberships 38,109 32,659 35,484 29,700 461
Professional Development 37,486 3,225 10,256 4,256
Meetings/Events 54,966 22,333 20,580 3,065 11,616 8,616
Capital Outlay-Operations 8,037 15,056 27,792 15,375 7,500 0
Capital Outlay-Building 4,324 8,185 35,150 0
Long Term Debt(Building Loan) 127,751 127,751 127,751 127,751 128,000 128,000
Events 1,436 0
Reserve for Operations Expense 519,868 542,977 708,484 748,896 748,895 748,895
Total Cash Outlays $ 3,968,226 $ 2,972,919 $ 2,940,415 $ 2,854,384 $ 2,213,146 $ 1,958,742
Net Income/(Loss) $ (160,222) $ 23,109 $ 165,507 $ 40,412 -$426,011 $ (108,080)
Page 4 of 12
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 $ 55.47 $ 115,378
Regional Counsel Exempt 15,000
Deputy Director/Economic
Development Program Mgr. Exempt 31.08 42.62 35.32 73,466
Planner IV (Environmental) Exempt 27.53 - 39.89 32.66 67,933
Planner II Exempt 20.07 - 31.74 25.52 53,082
Planner I Exempt 18.90 - 27.31 26.98 56,118
Planner I Exempt 18.90 - 27.31 19.00 39,520
GIS Manager Exempt 20.26 - 32.99 32.02 66,602
Total $ 487,098
Page ti of 17
HEALTH INSURANCE
TABLE (B)
INSURANCE TYPE COVERAGE AMOUNT
Health Employee Only $ 67,620
Dental Employee Only 3,044
Life Employee Only 1,757
FSA Employee Only 780
Short Term Disability Employee Only 3,688
Long Term Disability Employee Only 2,910
Total $ 79,799
HEALTH INSURANCE
CHART(B)
$70,000 —$677620—
$60,000
$50,000 —
$40,000
$30,000
$20,000
$10,000
3,044 3,688 2,910
1,757 780
s-
Health Dental Life FSA Short Term Long Term
Disability Disability
NOTE Coverage-Employee Only
Page 6 of 12
CONSULTANT FEES
TABLE (C)
CONSULTANT DESCRIPTION AMOUNT
Hughes Snell &Co. Review of Financials,Budget and Audit assistance $ 7,650
Trescott Planning Solutions, LLC Planning Services 12,000
WGCU Public Media Annual Report 4,800
Annual preparation of OPEB obligation(Audit
Foster&Foster requirement) 3,150
Genesis IT- support/consulting 3,500
Clerk of Courts IT-support/consulting 2,000
o
Total $ 33,100
CONSULTANT FEES
CHART(C)
$14,000 12,000
r 00
00
7650--00 3,150 3,500
2,000
$2,000 — _
$-
C u w e C C
O N c v c N T. gCp
m C j C C C Q
iR V, -- C iV t
o c a
MS c Y a
I. N a o.
ii o 0 C H
I O
Q m -•
c to
Q
o
Hughes Snell & Trescott WGCU Public Foster&Foster Genesis 'Clerk of Courts
Co. Planning Media I
I Solutions,LLC ! I
i
Page 7 of 12
CONTRACTUAL
TABLE (D)
GRANT DESCRIPTION AMOUNT
DEM-HMEP Training Exercises $ 15,000
Visit Florida Marketing Grant 3,100
Total $ 18,100
CONTRACTUAL
CHART(0)
$16,000 — $15,090 —_
$14,000 -- _-
$12,000
$10,000 -
$8,000
—
$6,000 -- —
$4,000 _. 3,100
$2,000 _
Training Exercises Marketing Grant
DEM-HMEP Visit Florida
Page 8 of 12
EQUIPMENT RENTAL
TABLE (E)
DESCRIPTION
IKON Rioch copier $ 5,038
Mail Finance Postage Machine $ 1,852
Culligan Water Water Cooler _$ 445
Total $ 7,335
EQUIPMENT RENTAL
CHART(E)
$6,000
$5,038
$5,000
$4,000 -- -
$3,000 ---G ? -—
$2,000 -- $1,852
$1,000
$44�
Rioch copier Postage Machine Water Cooler
IKON Mail Finance Culligan Water
Page 9 of 12
•
INSURANCE
TABLE (F)
POLICY DESCRIPTION PREMIUM
Commercial Property Building- $1,442,000 $ 12,440
Business Owners General Liability -$2,000,000 3,794
Director's&Officers Liability $1,000,000 each occurrence 4,550
Auto Property Damage/Uninsured Motorist 1,993
Crime Employee dishonesty-$100,000 430
Total $ 23,207
INSURANCE
CHART (F)
$14,000
$12,440
$12,000
$10,000
$8,000 — — —_-.
$6,000 4,550
$4,000 3,794
1,993
$2,000
- 430
Building- General Liability $1,000,000 each Property Damage A Employee
$1,442,000 $2,000,000 occurrence Uninsured dishonesty-
Motorist $100,000
Commercial Business Owners Director's& Auto Crime
Property Officers Liability
Page 10 of 12
COMPUTER RELATED
TABLE (G)
LICENSES AMOUNT
Peachtree(Accounting Software) $ 1,567
REMI(Modeling Software) 4,500
ArcView(GIS) 8,650
VM 1,000
Bill Quick 1,644
Total Licenses $ 17,361
OTHER AMOUNT
Hardware&Misc. $ 2,527
Internet Connection 3,082
Total Expenses $ 22,969
COMPUTER RELATED
CHART(G)
$20,000 - — - _ _ - _ —
$18,000 $17,361
$16,000 _. _ ._. _ _ —
$14,000
$12,000 _ _
$10,000 ---
$8,000
$6,000
$4,000 _ $l,SL1 3,027
$2,000
Total Licenses Hardware&Misc. Internet Connection
Page 11 of 12
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
SWFLN Southwest Florida Library Network 200
Misc. Misc. 500
Total $ 23,915
GRANT RELATED
SUBSCRIPTIONS DESCRIPTION AMOUNT
FEDC Florida Economic Development Council 300
IEDC IEDC 1,295
Total Grant Related $ 1,595
Total $ 25,510
DUES& MEMBERSHIPS
CHART(H)
$25,000
$20,500
$20,000 -
$15,000 - _ _ - - __
$10000
, --�_
I
$5,000 7,SU0 -
' 215 200 500 300 1,295
L $- _
Florida Urban Land Florida ! Southwest Misc. f Florida IEDC
Regional Institute Heartland I Florida Economic
Council Regional Library Development
Association Economic Network Council
Development!
Initiative ■
FRCA ULI FHREDI SWFLN Misc. I FEDC IEDC
Page 12 of 12