HomeMy WebLinkAboutUNI GeoTree - Agreement-12/18/2017Contract Agreement
Awarding Institution/Organization Name: City of
Waterloo, henceforth "Owner"
Receiving Institution/Organization Name: University of
Northern Iowa GeoTREE, henceforth "Contractor"
Agreement Number:
UNI-GeoTREE 001
Funding Source (if federal, indicate CFDA #):
Period of Performance:
Start Date: February 1, 2018
End Date: June 30, 2018
Funding:
Amount this Action: $ 11,880
Cumulative for Agreement: $ 17,280
Project Title: Development and Populating of an Address point Layer in a Geodatabase
Financial and Technical Reporting Requirements: See Attachment 4
Financial Terms (check one):
Cost Reimbursable (all budget changes require Owner approval)
Firm Fixed Price Deliverables Based
X
Firm Fixed Price Unit Based
Time and Materials (all budget changes require Owner approval)
Other (describe):
1. General Statement: This
Terms
Contract for Services,
scope of work provided
entity and
of the project without
found in Attachment
pay Contractor an amount
for the work and activities
standard invoice
in Attachment 4. At a
as to truth and
contact no later than
shall be directed
costs and expenditures
in violation of applicable
prior to the start date
Controls: Contractor
and Conditions
henceforth referred to as "Contract", is between Owner and
in Attachment 5. In performing the Contract scope of work,
not an employee or agent of Owner. The Contractor shall not
prior written approval by Owner Administrative Contact and
3A.
not to exceed that listed above and as detailed in Attachment 5.
described and budgeted for in Attachment 5. Payments will be
and after Owner's acceptance of Contractor's progress reports per
minimum, invoices must include: Contract number, billing period,
accuracy of invoice. A final invoice marked "Final" will be
90 days after the end date of this Contract. Invoices and
to the financial contacts per Attachments 3A and 3B.
shall follow Contractor's financial acquisition and expensing
Iowa Code and the Iowa Administrative Code. No costs shall be
or after the end date of this Contract.
hereby certifies that it has financial internal controls in place
and adherence to industry standard cost accounting
audit report reflects material shortcomings in Contractor's internal
to require more rigorous financial accountability, reporting, or
use of the Owner funds, or terminate Contract.
technical performance should be directed to the Owner
Progress report format, required content, and frequency are
and conditions of this Contract must be done so by written
between the Contracting parties.
Contractor
Contractor
subcontract
Principal Investigator,
2. Invoicing:
to complete the
shall be an independent
any aspects
as
Owner shall
to shall be
on Contractor's
conditions
and certification
Owner financial
to invoicing
Costs: Allowable
All payments
made based
the terms and
invoice number,
submitted to
questions related
3. Allowable
policies and shall not be
incurred under this Contract
4. Contractor Financial Internal
that ensure industry applicable
systems. Contractor agrees
control systems, Owner
otherwise take actions to
5. Technical Reporting: Matters
may
safeguard
in
4.
regulatory compliance
that if a third party
alter this Contract
the appropriate
concerning Contractor's
Attachments 3A.
Changes to the terms
mutual agreement
Project Director, as shown
described in Attachment
6. Administrative Requests:
amendment and must be by
Contract tf: UNI-GeoTREE 001
7. Indemnification: Each party shall be responsible for its negligent acts or omissions and the negligent acts or
omissions of its employees, officers, directors, and agents to the extent allowed by Iowa law.
8. Copyright: All copyrightable materials developed during the implementation of this contract's scope of work, such
as but not limited to audiovisuals, computer programs, software, publications, curricula, research materials,
training materials, etc. shall be vested with Owner. Owner hereby grants to Contractor a royalty -free, non-
exclusive, and irrevocable license to reproduce, publish, or otherwise use copyrighted materials for the
Contractor's normal scholarly operations.
9. Intellectual Property: Title to all intellectual property developed during and resulting from the work performed
under this Contract shall be vested to Owner. Owner hereby grants Contractor royalty -free, non-exclusive, and
irrevocable right to reproduce, publish, or otherwise use intellectual property resulting from work performed under
this Contract for Contractor's normal scholarly purposes.
a. For the purpose of this Contract intellectual property shall mean data arising from or collected during the
implementation of the Contract and all copyrightable material developed, inventions and/or discoveries
conceived and/or reduced to practice during the performance of this Contract.
b. Neither party shall lay claim to preexisting intellectual property held another party regardless of whether
or not the preexisting intellectual property contributed to the performance of this Contract or if the
preexisting intellectual property resulted in new intellectual property by way of the work performed under
this Contract, or both.
10. Termination: Either party may terminate this Contract with thirty days written notice sent to the appropriate
party's Administrative Contact and Authorizing Official, as found in Attachments 3A and 3B. In the event the
source funding for this project becomes unavailable, for any reason, Owner may immediately suspend Contract
activity with 5 working days written notice. In the event the Contract is terminated Owner shall pay all allowable
and budgeted expenses incurred by Contractor through the end date of the written termination letter.
11. Integration: This Contract, including any attachments, exhibits and provisions incorporated by reference,
constitutes the entire Contract between the parties hereto and supersedes all prior contracts, understandings and
arrangements, oral or written, with respect to the subject matter of this Contract. All substantive terms and
conditions of this Contract are included in this Contract document and referenced attachments.
12. Special Conditions: In addition to the above terms and conditions certain special conditions, flow through
conditions, and other stipulations may apply.
13. [Left Blank]
By an Authorized Official of Owner
0
\ 9VI Eli'l
Date
Title
By an Authorized Official of Contractor:
Name
Title
Date
2
Contract if: UNI-GeoTREE 001
Attachment 1
Certifications and Assurances
By signing this Contract, the authorized official of Contractor certifies, to the best of his/her knowledge and belief
that:
Non -Discrimination
In accordance with federal and state law and internal policy, Contractor agree not to discriminate against any
person on the basis of sex, race, creed, national origin, color, religious belief, age, disability, sexual orientation,
gender identity or status as a disabled veteran or veteran of the Vietnam era in the performance of this Contract.
Conflict of Interest
Contractor certifies that both parties has established written policy guidelines on conflict of interest and the
avoidance thereof and that in performing the work related to this Contract shall adhere to and monitor its own
policy.
Debarment, Suspension, and Other Responsibility Matters
Contractor certifies by signing this Contract that neither it nor its principals are presently debarred, suspended,
proposed for debarment, declared ineligible or voluntarily excluded from participation in this transaction by any
federal, state, or local agency.
Attachment 2
Special Conditions
1. Equipment. Title to all nonexpendable tangible property purchased by the Contractor with funds related to this
Contract shall be owned by the Contractor upon purchase without further obligation to Owner. Owner has the
right to stipulate special conditions that limit the management of such equipment within this agreement or by
reference to attachments to this Contract or readily available, accessible, and established rules or guidelines.
3
Contract #: UNI-GeoTREE 001
Attachment 3A
Owner Contacts and Reporting Information
Administrative Contact
Name:
Title:
Address:
Country: United States of America
Telephone:
Fax:
E-mail:
DUNS Number: p1- 5-8 `-1 _ 1 LA `1
EIN Number: 42— GOD 327
Congressional District: iso �h5 re—CS I.enaQ, w�
Registered in System for Award Management (SAM.gov)?
Yes_x_ No
Address as listed in SAM.gov if different from above
Address:
Principal Investigator/Project Direct
Name:
Title:
Address:
Telephone:
Fax:
E-mail:
Primary Performance Location if different from above
Address:
Financial Contact
Name:
Title:
Address:
Country: United States of America
Telephone:
Fax:
E-mail:
Authorized Official
Name:
Title:
Address:
Telephone:
Fax:
E-mail:
Prime award information (if applicable):
4
Contract #: UNI-GeoTREE 001
Attachment 3B
Contractor Contacts and Reporting Information
Administrative Contact
Name:
Title: Postaward Services Coordinator
Address: 213 East Bartlett Hall,
Cedar Falls, IA 50614-0394
Country: United States of America
Telephone: 319-273-4321
Fax:
E-mail: rsp@uni.edu
DUNS Number: 07-313-2623
EIN Number: 42-6004333
Human Subjects Assurance No. : 00002159
CAGE Code: OFV12
Congressional District: 1S1 Congressional, Iowa
Registered in System for Award Management (SAM.gov)?
Yes_x_ No
Address as listed in SAM.gov if different from above
Address:
122 Lang Hall
Cedar Falls, IA. 50614
Principal Investigator/Project Direct
Name: John DeGroote
Title: Director GeoTREE
Address: ITT 214, University of Northern Iowa, Cedar Falls, IA 50614
Telephone: 319-273-6158
Fax:
E-mail: john.deproote@uni.edu
Primary Performance Location if different from above
Address:
Financial Contact
Name:
Title: Accounts Specialist
Address: 213 East Bartlett Hall
Cedar Falls, Iowa 50614-0394
Country: United States of America
Telephone: 319-273-7054
Fax:
E-mail: rsp@uni.edu
Authorized Official
Name: Tolif Hunt
Title: Director, RSP
Address: 213 East Bartlett Hall
Cedar Falls, Iowa 50614-0394
Telephone: 319-273-3025
Fax:
E-mail: tolif.hunt@uni.edu
Contractor Institution Type:
Public/State Controlled Institution of Higher Education
5
Contract #: UNI-GeoTREE 001
Attachment 4
Technical & Financial Reporting Requirements
1. Technical Reporting:
All final project products and reports shall be due to Owner by Contractor no later than 30 days after the end date of
this agreement. Further details related to technical reporting requirements can be found in Attachment 5 of this
agreement.
2. Financial Reporting:
Please reference Paragraph 2 of this agreement for invoicing instructions. No special conditions to financial
reporting is required.
Payment from Owner to Contractor shall be mailed to:
University of Northern Iowa
Attn. Cashier
Office of Business Operations
103 Gilchrist Hall
Cedar Falls, IA. 50614-0008
Incremental Funding: This project is subject to incremental funding based on two distinct project sections.
Base Option: $11,880. The Base Option is exercised by execution of this agreement.
Funding for the Base Option of this project mainly will consist of supporting the time spent creating the address
feature class, as further described in Attachment 5. The cost for the Base Option of this agreement is below, which
are based on an estimated 30,000 addresses in the City of Waterloo:
• Planning, consultation with City of Waterloo, geodatabase design, address point creation, attribution, and
quality control including final field checking of any address of concern using ArcGIS Address Field Verification
template (http://solutions.arcois.com/local-government/help/address-field-verifications
o 550 hours @ $20/hour = $11,000
• UNI Indirect Overhead ($11,000 * 1.08) based on UNI's rate of 8% = $880
• Total estimated cost = $11,880
Option 1. $5,400. Exercising Option 1 shall be by bilateral amendment of this agreement only.
A bilateral amendment to this agreement shall be made to add an amount not to exceed $5,400. The amendment
shall also, if needed, extend the period of performance beyond the stated end date of this agreement for an amount
of time appropriate to complete the tasks outlined in the section titled "Optional Project" in the Attachment 5 of this
agreement. The full scope of work for Option 1 is found in Attachment 5, below is the budget for Option 1:
• Scan all address forms and create a hyperlink to scanned documents. We would automate the creation of this
hyperlink creation using a Python script with manual quality control checks. This part depends on the number
of address forms to scan. Each form will take approximately two to three minutes to scan, name, and save.
The below estimate assumes up to 5,000 address forms.
o 250 hours @ $20/hour = $5000
• UNI Indirect Overhead (total above * 1.08) based on UNI's rate of 8% = $400
• Total estimated cost = $5,400
6
Contract Amendment # 01
Awarding Institution/Organization Name: City of
Waterloo, henceforth "Owner"
Receiving Institution/Organization Name: University of
Northern Iowa GeoTREE, henceforth "Contractor"
Agreement Number:
UNI-GeoTREE001
Amendment Number
01
Agreement Period:
Start Date: February 1, 2018
End Date: June 30, 2018
New Agreement Period:
Start Date:
End Date:
Funding:
Amount this Action: $ 5,400
Cumulative for Agreement: $ 17,280
Project Title: Option Period 1, Development and Populating of and Address Point Layer in a Geodatabase
Summary of Changes: Exercise Option Period 1, adding $5,400 to the currently funded $11,880 of this incrementally
funded agreement and adding the scope of work as described in Attachment 4 Section 2 under the section titled
"Incremental Funding"
1. General Statement:
Amendment Terms
Unless noted in this agreement
all attachments, as well as all subsequent
Change 1: Add $5,400 to the
and Conditions
amendment all terms and conditions related to the prime
amendments preceding this amendment, if
currently awarded funds to fully fund the project at the
Work as described in Attachment 4 of the agreement.
agreement, including
applicable, remain unchanged.
2. Terms and Conditions
originally agreed upon not -to -exceed amount of $17,280.
3. Terms and Conditions Change 2: Exercise Scope of
-No further changes -
By an Authorized Official of Owner
2
ev�rl -j �;--� ' �l S /11
Name Date
VkLUAs
Title
Signature
By an Authorized Official of Contractor:
_Tolif R. Hunt
Name
1/24/18
Date
_Director Research & Sponsored Programs
Title
Signat re