Backup Documents 11/13/2018 Item #16A27 ORIGINAL DOCUMENTS CHECKLIST & ROUTI U P 16 A 2 7
TO ACCOMPANY ALL ORIGINAL DOCUMENTS SE J
THE BOARD OF COUNTY COMMISSIONERS OFFICE FOR SIGNATUUVED
Print on pink paper. Attach to original document. The completed routing slip and original documents are to be forwarded rney
Office at the time the item is placed on the agenda. All completed routing slips and original documents must be received in t e ot ey
Office no later than Monday preceding the Board meeting.
**NEW** ROUTING SLIP Risk Management
Complete routing lines#1 through#2 as appropriate for additional signatures,dates,and/or information needed. If the document is already complete with
the exception of the Chairman's signature,draw a line through routing lines#1 through#2,complete the checklist,and forward to the County Attorney Office.
Route to Addressee(s) (List in routing order) Office Initials Date
1. Risk Risk Management I i )17
2. County Attorney Office County Attorney Office
4. BCC Office Board of County
Commissioners vN4SJ
4. Minutes and Records Clerk of Court's Office l4 ttS4 tt.
5. Procurement Services Procurement Services
PRIMARY CONTACT INFORMATION
Normally the primary contact is the person who created/prepared the Executive Summary. Primary contact information is needed in the event
one of the addressees above,may need to contact staff for additional or missing information.
Name of Primary Staff Ana Reynoso/PURCHASING Contact Information 239-252-8950
Contact/ Department
Agenda Date Item was November 13,2018 / Agenda Item Number 16.A.27.
Approved by the BCC
Type of Document AMENDMENT Number of Original 2
Attached Documents Attached
PO number or account N/A 17-7216-WV Metro Metro Forecasting
number if document is Forecasting Models, Models,LLC. ►/
to be recorded LLC
INSTRUCTIONS & C
Initial the Yes column or mark"N/A"in the Not Applicable 5 u • hi.hever is Yes N/A(Not
appropriate. (Initial) Applicable)
1. Does the document require the chairman's original signatur• STAMP OK N/A
2. Does the document need to be sent to another agency for adc'tional signa . If yes, N/A
provide the Contact Information(Name;Agency;Address;Pho - s an attached sheet.
3. Original document has been signed/initialed for legal sufficiency. (All documents to be AR
signed by the Chairman,with the exception of most letters,must be reviewed and signed
by the Office of the County Attorney.
4. All handwritten strike-through and revisions have been initialed by the County Attorney's N/A
Office and all other parties except the BCC Chairman and the Clerk to the Board
5. The Chairman's signature line date has been entered as the date of BCC approval of the AR
document or the final negotiated contract date whichever is applicable.
6. "Sign here"tabs are placed on the appropriate pages indicating where the Chairman's AR
signature and initials are required.
7. In most cases(some contracts are an exception),the original document and this routing slip N/A
should be provided to the County Attorney Office at the time the item is input into SIRE.
Some documents are time sensitive and require forwarding to Tallahassee within a certain
time frame or the BCC's actions are nullified. Be aware of your deadlines!
8. The document was approved by the BCC on 08/25/2018 and all changes made during N/A is not
the meeting have been incorporated in the attached document. The Cous1y an option for
Attorney's Office has reviewed the changes,if applicable. — 3' ' this line.
9. Initials of attorney verifying that the attached document is the version approved by the N/A is not
BCC,all changes directed by the BCC have been made,and the document is ready for the r tin option for
Chairman's signature.
16A27
MEMORANDUM
Date: November 16, 2018
To: Ana Reynoso,
Procurement Services
From: Teresa Cannon, Sr. Deputy Clerk
Minutes & Records Department
Re: Contract #17-7216-WV "Collier County Interactive
Growth Model VER3 (CIGM VER3)"
Contractor: Metro Forecasting Models, LLC
Attached for your records is an original of each referenced document above,
(Item #16A27) adopted by the Board of County Commissioners on Tuesday,
November 13, 2018.
The Board's Minutes & Records Department has kept an original as part of the
Board's Official Records.
If you have any questions, please feel free to contact me at 252-8411.
Thank you.
Attachment
FIRST AMENDMENT TO AGREEMENT 1 6 A 2 7
#17-7216-WV
FOR
COLLIER COUNTY INTERACTIVE GROWTH MODEL VER3 (CIGM VER3)
THIS AMENDMENT,made and entered into on this t'3 ' day of k•W Q.h(lbef 2018,by
and between Metro Forecasting Models, LLC., (the "Consultant") and Collier County, a political
subdivision of the State of Florida, (the "County"):
WHEREAS, on November 14, 2017 (Agenda Item 16.A.16), the County entered into an
Agreement with Consultant to update the current Collier Inter-Active Growth Model (CIGM Ver3) for a
lump sum cost of$220,000; and
WHEREAS, the parties desire to amend the Agreement to; i) include Time and Material
language to Section 4.1 Price Methodology; ii) Add Work Task 8.1- Develop Utility Sub-Models to
Exhibit A-Scope of Services; iii)extend the schedule of services; and iv)Amend Exhibit B Fee Schedule
to add Work Task 8.1-Develop Utility Sub-Models and Work Task 10.0-General Consulting Services,
increase Total Fee from$220,000 to $288,000, and include consulting services hourly rates.
NOW, THEREFORE, in consideration of the mutual promises and covenants herein
contained, it is agreed by the parties as follows:
Words Struek4hrough are deleted; Words Underlined are added
* * * * *
4.1 Price Methodology:
Lump Sum (Fixed Price): A firm fixed total price offering for a project; the risks are transferred
from the County to the Consultant; and, as a business practice there are no hourly or material
invoices presented, rather, the Consultant must perform to the satisfaction of the County's project
manager before payment for the fixed price contract is authorized.
Time and Material: The County agrees to pay the contractor for the amount of labor time spent by
the contractor's employees and subcontractors to perform the work (number of hours times hourly
rate), and for materials and equipment used in the project (cost of materials plus the contractor's
markup). This methodology is generally used in projects in which it is not possible to accurately
estimate the size of the project, or when it is expected that the project requirements would most
likely change. As a general business practice, these contracts include back-up documentation of
costs;invoices would include number of hours worked and billing rate by position(and not company
(or subcontractor) timekeeping or payroll records), material or equipment invoices, and other
reimbursable documentation for the project.
* * * * *
Page 1 of 4
EXHIBIT A 1 6 A 2 7
Scope of Services
* * * * *
Work Task 8.1-Develop Utility Sub-Models
The COUNTY, in consultation with the CONSULTANT,will organize a staff task force for the development
and implementation of the Collier Interactive Growth Model (CIGM) Utility Sub- Model with additional
services for wastewater pump station basin analysis. The COUNTY, will appoint staff members and
representatives on an as needed basis. One member assigned to the staff task force will be a staff
member with experience in Geographic Information System (GIS). The purpose of the task force is to
assist the CONSULTANT in identifying and collecting pertinent data that are instrumental to the modeling
and analysis of the COUNTY'S Utility System(s).
The additional Tasks are outlined below:
Zone Geometry Alignment: The CONSULTANT, with assistance from the COUNTY, will identify CIGM
zones to be subdivided for conformity with CCWSD sewer basin boundaries. CONSULTANT will also
subdivide those additional zones identified by COUNTY as having a significant number of residents who
will never receive water or waste water service (i.e. will always have well, septic, both). The
CONSULTANT will subdivide these additional zones where requested to approximate the actual area
served.
Waste Water Basins and Regional Areas: Based on the Zone Geometry Alignment, the
CONSULTANT, with assistance from COUNTY, will create sewer basin clusters and five wastewater
reclamation facility clusters for modeling.
Staff Training: The CONSULTANT will train COUNTY'S staff up to 6 hours as follows:
• Review Potable Water demand input variables
• Review Waste Water generation input variables
• Review Per Capita and Demand Location analysis methods
• Review Model Calibration Methods
• Accessing model reports and downloading
Schedule of Services
CONSULTANT shall complete the Scope of Services within one year of the
commencement date identified in a written notice to proceed.
* * * * *
Work Task 9.0 — CIGM Alternative Scenarios
* * * * *
C. Schedule of Services: The Consultant, upon a written Notice to Proceed, shall complete the
work described under Scope of Services within twelve (12) Months and may be extended
administratively to run currently with Task 8.1. This time estimate assumes that the County has
(tic,
adequate GIS capabilities and that information required from County staff is timely.
Page 2 of 4
I 6 A 2 7
EXHIBIT B
FEE SCHEDULE
The Consultant proposes a lump sum fee of $220,000 (Two Hundred Twenty Thousand Dollars) and a
Time and Material (not to exceed) $68,000 (Sixty-Eight Thousand Dollars), billable monthly based on a
percent of completion of the task(s) found under Exhibit A - Scope of Service in the monthly invoices.
Payments will be made in accordance with the following Schedule; however, the payment of any task
item noted below shall not be due until completed to the County's satisfaction.
Work Description Time & Lump Sum Payment
Task Material Fee Schedule
1.0 Develop Baseline Database $30,000 Monthly Upon
2.0 Develop Buildout Database $30,000 Percent
3.0 Develop Population and Housing Model $30,000 Complete of
4.0 Develop Commercial Sub Model $20,000 Task
5.0 Develop Industrial Sub Model $10,000
6.0 Develop Hotel/Motel Sub Model $10,000
7.0 Develop Government Sub Models $30,000
8.0 Develop Specialty Sub Models $40,000
8.1 Develop Utility Sub-Models $48,000*
9.0 Develop CIGM Alternative Scenarios $20,000
10.0 General Consulting Services $20,000*
SUB-TOTAL FEE (Tasks 1410) $ 000
$68,000* $220,000
TOTAL FEE (Tasks 1-10) $288,000
*Additional general consulting services will be provided on a Time and Material basis, not to exceed
$68,000, to more accurately define sewer basin boundaries and create sewer basin and wastewater
reclamation facility clusters, and to assist staff in using CIGM data and providing detailed analysis of
population growth, demographics including demand for housing, commercial lands, industrial lands and
other services provided by the County to the residents and visitors.
General Consultin• Plannin• Services Rates
Principal Planner $250/hr
Senior Planner $175/hr
Senior Data Analyst $125/hr
Staff Planner $100/hr
Model Technician $85/hr
* * * * *
Page 3 of 4
1 6 A 2 7
IN WITNESS WHEREOF,the parties hereto,have each,respectively,by an authorized person or agent,have
executed this Amendment on the date and year first written above.
ATTEST:
Crystal K.Kinzel,Clerk of Courts& BOARD OF CO TY COMMISSIONERS
Comptroller COLLIER 4 . ,FLORID '
,s
- ' A
By: ' '• :': . % ' ' 1 --- By . ...."
, ... Andy Solis,Esq.,Chairman
..,.
i 14 61, 91Z
Dated:
(SEAL)/ '',.;1 to Chairman's
only.
Consultant's Witnesses: CONSULTANT
n Metro Forecasting Models,LLC.
i I
It\ 1
\----.-1:-
l'...._ Q--
First Witness By:
Signature
A\‘k a)(1 TA-4-7-CO rIC e-S( -0
TType,rint witness name. 1:37v,414 k ,-,1;1-;;-/../,,---
,......' .- TType/print signature and thief
..,..--77 Second Witness /
c\ A /61/Z//
t.:, ,_)OLC a-Ki\ Viirlfc;kir- Date'
i
TType/print witness nameT
pprov7iiase/and Legality:
epuCounty Attorney
cspe
C.Att k --L-1---
Print Name
Item# /HOT
Agenda
Date I I (3 (8
Date 1141, . ,
i
Page 4 of 4 11111, 0
.0:7;put-TCTeTr-2-2---
- -... .