HomeMy WebLinkAboutIndependence Enterprises - Oracle Reports Development -2006 05 09
...
..
2.JJ~
IIa! .ft+ePJI~
4381 W Dogwood Lane, Cedar Hills, UT 84062
801-796-6148
City of Winter Springs, Florida - Oracle Reports Development
DATE:
May 9, 2006
It is our pleasure to offer the following proposal to assist you with various Oracle reports and
SQL scripts development.
I. General Description of project.
This is a 'not-to-exceed' proposal. The following tasks are identified as part of this proposal.
However, there may be other reports or scripts identified by the City that are to be completed
under this agreement.
SOL scripts
1. Create database triggers to automatically generate re-inspection fees and condition of
approval based on failure of inspection
2. Create database triggers to automatically sign-off condition of approval upon payment of
re- inspection fee
3. Upgrade County Land Download program (landload72.sql) to deal with situation where
an address is on a permit but not in the Address database
4. Develop program to automatically expire a permit 180 days after the occurrence of any
activity. For example, if an electrical inspection was done on November 1, 2005 and it is
now May 1, 2006, then the permit should be flagged as expired since no additional
activity has occurred during this period.
Oracle Reports
1. Cover Page Report for Permit Folders
II. Cost Estimate
All work done will be billed on an hourly basis at a rate of$130.00 per hour. A
minimum of 8 hours per day will be billed for on-site work. Off-site work will be
billed by the hour. Travel expenses will be billed at actual cost. Travel expenses
include airfare, car rental, hotel, and $46.00 per Diem. Time for travel will not be
billed, however the per diem will be billed for all on-site and travel days.
The following is a cost estimate for this project:
Item Quantity Cost
Off-Site work 77 hours $10,010.00
Total $10, 010.00
III. Assumptions
Winter Springs will provide:
· Personnel assistance wherever necessary.
· Perform the final test of the completed reports prior to installing on the
production database.
independence enterprises:
· Develop reports in OracleReports and test them against a local copy of the
Winter Springs database.
· Deliver the reports to the City for final testing.
IV. Payment Schedule
· All time will be billed on a time and materials basis.
· All invoices are due net 30 days from the date the invoice is received. Interest
will be charged for all invoices past due at an annual interest charge of 24%.
All payments are to be made in U.S. funds.
V. General Notes
1. The client is responsible for expenses incurred at the client's site. They
include, but are not limited to, air and ground transportation, lodging, and per
diem. All expenses will be reimbursed as submitted from actual receipts.
2. All reports not part of the original Kiva DMS product as delivered by Accela
will remain the property of independence enterprises, Inc.
3. This project is governed by any licensing agreements currently in affect
between Accela and the City of Winter Springs, Florida.
VI. Terms of Agreement
· This agreement shall commence on the date of execution indicated herein and
terminate upon completion of the agreed upon hours.
VII. Attorney's Fees
· In the event any litigation or controversy arises out of or in connection with
this Agreement between the parties hereto, each party shall bear their own
attorney's fees and costs.
2
VIII. Governing Law and Venue.
· This Agreement shall be construed and enforced in accordance with the laws
of the State of Florida. The parties further agree that in any dispute between
them relating to this Agreement, exclusive jurisdiction shall be in the trial
courts located in Seminole County, Florida, any objections as to jurisdiction
or venue in such courts being expressly waived.
IX. Assignability
· This contract may be transferred, assigned or sold by independent enterprises,
inc. only with the express written consent of the City Commission of the City
of Winter Springs.
X. Licensing and insurance
· independence enterprises inc. is fully licensed and insured as required by the
governing laws of the State of Utah.
AGREEMENT ACCEPTANCE
Steph . Roberts, President
independence enterprises, Inc.
t; / 1.2/ {Jb
Date
;(~~. '1n//
City of Winter Springs, Florida
~
s-- 7--u&
Date
3