#17-7216-WV (Metro Forecasting Models, LLC) FIRST AMENDMENT TO AGREEMENT
#17-7216-WV
FOR
COLLIER COUNTY INTERACTIVE GROWTH MODEL VER3 (CIGM VER3)
THIS AMENDMENT,made and entered into on this ?j*)^ day of Q,d Q.K1 bef 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 amuck-dough 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
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
adequate GIS capabilities and that information required from County staff is timely.
Page 2 of 4
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 1-910) $220,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 Consulting Planning 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
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 Cod T LORID
efkt` - ® By:
rr Andy Solis,Esq.,Chairman
Dated a. -.x.19 t b
(SEAL) Atter as to hair Ian's
sfgnature only.
Consultant's Witnesses: CONSULTANT
Metro Forecasting Models,LLC.
i
First Witness By: ,
Signature
Al\..cin --bc4-CU lice-SC
✓e/ 4' .,,, r;.:14.„.--
TTypel.�rint witness namet ✓'r?v"
TType/print signature and titlet
t «. zr C_1_-.? -----1__---)
- Second Witness /
./G,:/Z,,/�.
,
+ cL a..\ VL Y.4r Date,
tType/print witness namet
'proved as t,, Ft nd Legality:
"i / ...e-..- C
�i "•uty County Attorney
ce_4 tt- 2/2 7i.A_e--L
Print Name
1
Page 4 of 4 Oil