HomeMy WebLinkAboutCORRESPONDENCE - GENERAL CORRESPONDENCE - COMPUTER CONSULTING SERVICESWORK ORDER FORM
PURSUANT TO AN AGREEMENT BETWEEN
THE NORTH FRONT RANGE TRANSPORTATION AND AIR QUALITY PLANNING COUNCIL
AND
COMPUTER CONSULTING SERVICES OF AMERICA INC.
DATED: October 20, 2002
Work Order Number: 3
Purchase Order Number: 330Y301 -_
Project Title:
Commencement Date:
Completion Date:
Maximum Fee:
Project Description:
Scope of Work:
Acceptance: _
User
VanGo Vanpool Management System Enhancements
August 11, 2003
September 30, 2003
Time and Reimbursable Direct Costs not to exceed Seven -Thousand -One -
Hundred -Twenty Eight Dollars and no cents ($7,128.00)
See Attached
See Attached
G� &�J
Professional agrees to perform the services
identified above and on the attached forms in
accordance with the terms and conditions
contained herein and in the Professional
Services Agreement between the parties. In the
event of a conflict between or ambiguity in the
terms of the Professional Services Agreement
and this work order (including the attached
forms) the Professional Services Agreement
shall control.
Professi nal:
By: p, U►� c(sn
Date: /�l�l//2oy3
The attached forms consisting of two (2) pages
are hereby accepted and incorporated herein, by
this reference, and Notice to Proceed is hereby
given.
North Front Range Transportation & Air
Quality PI ning Co + cil:
By:
Date: �-r
Purchasing -City of Ft. Collins: (if over $30,000)
By:
Date:
C �J I m 0` eV f1 9/13103
0
VanGo — Vanpool Management System ENHANCEMENTS
Project Description and Scope of Work
Submitted On 07/30/2003
Project Description:
The VanGo - Vanpool Management system that is currently being used by VANGO requires some
enhancements that will allow users to export vanpooler information that can be imported into
QuickBooks. Also the system needs to accept couple attributes about vanpoolers and vehicles.
Scope of Work:
TASKS
I. Analysis & Design (4 hours)
2. Database Changes (8 hours)
- Add new column to vanpooler table
- Vanpooler email address
- Vanpooler work phone extension number
- Add new columns to vehicle table
- Vehicle activation date
- Make
- Model
- Year
- Color
- VIN
- Vehicle Expense Type Reference Table
- Vehicle Operating Costs Table
- VMT Tracking Table
3. Application (102 hours)
1. Change Vanpooler form to accept email address
2. Change Vehicle form to accept the following
o Vehicle activation date
o Make
o Model
o Year
o Color
o VIN
3. Van Listing Report that prints the van attributes (Make, Model, Year, Color, Vin)
4. Provide capability to add new company details from Vanpooler screen.
5. Change Van Ridership report to include the following columns
- Email Address
- Work Phone Extension Number
- Other Phone Number
6. "Vehicle Revenue" Report
7. "How Heard" Report
8. "Subsidy Type" Report
9. "Length of Participation" Report
10. Vehicle Operating Cost Report
11. Report selection criteria from for the following report
- "Vehicle Revenue" Report
- "How Heard" Report
- "Subsidy Type" Report
"Length Of Participation" Report
12. Vehicle Operating Cost Tracking
While entering operating cost for the vehicle, the user will be allowed to enter the month's
revenue. Since we are not capturing payments received from the participants, we can arrive at
this number internally.
13. VMT Tracking
4. Testing (32 hours)
- Unit testing
- Integrated System testing
- Installation testing
5. Deployment & Training (4 hours)
Total estimated hours —150
Deliverables
1. Updated Application
2. Database
Cost
The cost will be computed at $45/hr and in conformance with the City of Fort Collins Award for CCSA.
This is a time and material engagement. Any changes to the scope (new forms, reports, queries, business
rules) or new complexities will have to be approved and purchase order modified accordingly.
No.
Deliverable
••. • ••lication
Cost
Travel
Hours
. �1 11
& Mileage (Estimated 2 trips during the project)
hours • •
Cost
S (roundtrip) and at er
1 11
Totalle
1: 11
11
Timeline
CCSA will begin work on this within ten working days upon receipt of notice to proceed. The application
will be delivered within 6 weeks from the time CCSA receives notification to proceed.
Bill►ne
CCSA will be paid on a cost reimbursement basis (i.e. stated rate of $45 per hour). Invoices will
be submitted monthly, with the final invoice to be submitted no later than September 30, 2003.
Maximum fee will not exceed $7,128.00
If you have any questions call on me at 303-300-1024 xl 1. Again, Thanks for providing us with this
opportunity to serve you and your department.
;9aaraman