Loading...
HomeMy WebLinkAboutCHANGE ORDER - RFP - P934CHANGE ORDER NO. 1 ,j arm C.f� Year v PROJECT TITLE: Smarttrips.org Website Redesign CONTRACTOR: Pacific Intermedia PROJECT NUMBER: 4007.5262 PURCHASE ORDER #: 21 DESCRIPTION: Change in Scope of Work 1. Reason for Change: Change site from static HTML to a GIS-based interactive portal 2. Description of Change: See attached 3. Change in Contract Cost: $19,781.00 4. Change in Contract Time: None ORIGINAL CONTRACT COST: $ 40,000.00 TOTAL APPROVED CHANGE ORDERS: $ TOTAL PENDING CHANGE ORDERS: $ _ TOTAL THIS CHANGE ORDER: $ 19,781.00 TOTAL % OF ORIGINAL CONTRACT, THIS C.O.: 49.45% TOTAL % OF ORIGINAL CONTRACT, ALL C.O.'S.: 49.45% ADJUSTED CONTRACT COST $ 59,781.00 (Assuming all change orders approved) ACCEPTED BY: �' �`�"'� DATE: Contractor's Representative ACCEPTED BY: oyt, ALM DATE: $ !4 d Project Mafiager - Margie Jo OFRMPO REVIEWED BY: DATE: /o NaWe PTitle Gayle Foos, NFRMPO Financial Manager APPROVED BY: - DATE: 31mA Na e / Title - ayle Foos, NFRMPO Financial Manager APPROVED BY: DATE: Purchasing Agent over $30,000 cc: Purchasing u:\forms\Pacific Intermedia - Change Order #1 8/18/2004 nac. is ter�neciia SmartTrips Platform Enhancement Recommendations and Cost PROPOSAL 5. Hour, Cost and Timeline Estimate for Phase 1 5.1. Hours 5.1.1. Discovery 5.1.2. Design, Front End 5.1.3. Design, Back End 5.1.4. Development Released Under Confidentiality to City of Fort Collins. Page 9 of 12 August 5, 2004 Copyright 0 2004. All Rights Reserved. Pacific Intermedia, Inc. i n teredia SmartTrips Platform Enhancement Recommendations and Cost PROPOSAL DELIVERABLES Reviews, Database ORIGINAL HOURS ADDITIONAL HOURSTO TAL Savings Calculators) 13 0 13 MileMapper 33 7 40 Carpool Matching 8 0 8 Alpha Release & QA Testing 13 10 23 Beta Release and Acceptance Testing 20 10 30 Subtotal 126 66 193 5.1.5. Deployment DELIVERABLES OROURS ADDIT10HAL System Documentation 5 3 8 Delivery Final System Code 10 0 10 Post -Release Support 15 0 15 Subtotal 30 3 33 5.1.6. Project Management/Change Management Released Under Confidentiality to City of Fort Collins. Page 10 of 12 August5,2004 Copyright 0 2004. All Rights Reserved. Pacific Intennedia, Inc. cd1{l s Pa _ mtermectia 3P SmartTrips Platform Enhancement Recommendations and Cost 5.2. Costs DELIVERABLESORIGINAL Discovery COSTD 4,500 • •TOTAL 2,500 7,000 Design, Front -End 7,955 7,125 15,080 Design, Back -End 6,000 3,375 9,375 Development 12,675 8250 20,925 Deployment 1,370 375 1,745 Project/Change Management 7,500 4,750 12,250 Subtotal $40,000 $26,375 $66,375 Custom Marketing Campaign Elements Creation (Gratis) 0 $2,500 Value Gratis Total $40,000 $26,375 $66,375 Less "Strategic Project" Discount 25% ($6,594) Adjusted Total $19,781 $59,781 PROPOSAL As this project is a "Strategic Project' for PI, a one time discount of 25% on "Additional Work" cost is extended. Released Under Confidentiality to City of Fort Collins. Page 11 of 12 August 5, 2004 Copyright* 2004. All Rights Reserved. Pacific Intennedia, Inc. pacific �..3_ intern-tedia SmartTrips Platform Enhancement Recommendations and Cost 6. Schedule See PDF attachment. PROPOSAL Released Under Confidentiality to City of Fort Collins. August5,2004 Page 12 of 12 Copyright® 2004. All Rights Reserved. Pacific Intermedia, Inc. ..._. ;n= pacific Intermedia STATEMENT OF PROPOSAL City of Fort Collins SmartTripsTm Platform Enhancements Recommendations and Cost August 5, 2004 Released Under Confidentiality to City of Fort Collins. Page 1 of 12 April 4, 2004 Copyright® 2004. All Rights Reserved. Pacific Intennedia, Inc. 14 a V. pacific SmartTrips Platform Enhancement Recommendations and Cost intermedia PROPOSAL Submitted by: Michael Clark Vice President Business Development Pacific Intermedia, Inc. Signature Corporation: Date The information in this Proposal shall not be disclosed outside the Client's organization and shall not be duplicated, used or disclosed in whole or in part for any purpose other than to evaluate the Proposal, provided that if a contract is awarded to Pacific intermedle as a result of or in connection with the submission of this Proposal, the Client shag have the right to duplicate, use or disclose the information to the extent provided by the contract. This restriction does not limit the right of the Client to use information contained in the Proposal if it is obtained from another source without restriction. Released Under Confidentiality to City of Fort Collins. Page 2 of 12 August 5,2004 Copyright 0 2004. All Rights Reserved. Pacific Internedia, Inc. pacific .. intermcdia Table of Contents SmartTrips Platform Enhancement Recommendations and Cost PROPORAI 1. Executive Summary ..................................................................................................................................4 2. Phase 1: Functional Enhancements in the Initial Website Launch...........................................................5 3. Phase 2: Integration of GIS Routes..........................................................................................................8 4. Phase 3: Multi -Modal Itinerary Planning...................................................................................................8 5. Hour, Cost and Timeline Estimate for Phase 1.........................................................................................9 5.1. Hours.....................................................................................................................................................9 5.2. Costs....................................................................................................................................................11 6. Schedule.................................................................................................................................................12 Released Under Confidentiality to City of Fort Collins. Page age 3 of 12 Copyright 0 2004. All Rights Reserved. Pacific Intennedia, Inc. DI M.mipacifc .,L SmartTrips Platform Enhancement Recommendations and Cost 1. Executive Sum During the Discovery phase of the SmartTrips Website Redesign project, several key subject matter expert (SME) requests indicated that specific enhancements of the original scope of work are highly recommended. It makes sense for these enhancements take place now as costs and timelines will increase from 20% to 30% if delayed and done under a separate project phase. Key requirements driving this recommendation include: • A single user database to support both the MileMapper and the Carpool Matching Applications. • Integration of GIS mapping capabilities provided via the Carpool Matching Application's ArcIMS map server. • Major enhancement of the MileMapper both in the "benefit offerings" it provides the prospective user, and the amount and type of data it captures and reports. • Major enhancement in the content editor interface to allow community SmartTrips personnel to add, modify and delete programs, events and promotions listed for their community, thus increasing the content of the site without adding personnel burden to the regional office. We propose enhancements to the original scope of work in three phases. • Phase 1: Functional enhancements in the initial website launch. • Phase 2: Integration of GIS bike routes, transit routes and road construction/incident locations. • Phase 3: Advanced GIS multi -modal itinerary planning. This proposal summarizes the scope of work and costs associated with Phase 1. Released Under Confidentiality to City of Fort Collins. Page age 4 of 12 Copyright 02004. All Rights Reserved. Pacific Intermedia, Inc. t_ Pacific ermedia SmartTrips Platform Enhancement Recommendations and Cost P oononlzm 2. Phase 1: Functional Enhancements in the Initial Website Launch The following are recommended for immediate implementation with the phase 1 redesign • Creation of a common master registration database with unified user tables to support both the MileMapper and the Carpool Matching Application. • Integration of the MileMapper and Carpool applications through a seamless user form that allows enrollment and tracking of carpool miles as well as user profile. ORIGINAL SCOPE SmartTrips MileMapper and Carpool Matching Applications would each be supported by a unique user database with its own registration and user tables, and each generating unique usage reports. ADDITIONAL SCOPE Establish a common master registration database with a unified user table on the SmartTrips platform. Develop a web service that validates users before sending them to the Carpool Matching Application forth data to the Carpool Matching Application. Automatically create MileMapper accounts for carpool users, and track usage through one reporting mechanism. I Reduces duplication of agency development efforts. Reduces internal the NFRMPO personnel costs needed to manipulate and align data from two different sources. Reduces user confusion in dealing with two distinct applications asking for the same data input. Increases the accuracy of report data by capturing a user only once. Builds a single database repository of users for future geocoding applications to support marketing analysis and promotional campaigns • Major enhancement of the MileMapper portal that allows us to customize the site to a specific user profile and offer features that would encourage use of the tool. • Additional email listsery functionality. ORIGINAL SCOPE ADDITIONAL SCOPE BENEFITS User-friendly log -in to existing Custom user portal that presents Encourages increased use by system. promotions, events, and programs offering more benefits. applicable to the user's At -a -glance cumulative totals transportation mode(s) of choice and Establishes automated email (number of days, type of mode, community of residence. calories burned, etc). notifications, reducing personnel work -hours currently applied to Automatic tracking of miles saved, contacting users. costs saved, calories burned and pollution reductions specific to the Establishes ongoing contact with user. Also automatic tracking of miles logged to a miles -based incentive users through email campaigns. promotion. Released Under Confidentiality to City of Fort Collins. Page 5 of 12 August 5, 2004 Copyright 0 2004. All Rights Reserved. Pacific Intennedia, Inc. 0 pacific rt unterntedia SmartTrips Platform Enhancement Recommendations and Cost PROPOSAL ORIGINAL SCOPEDD•SCOPE BENEFITS Automatic email notification of the above information, new promotions, and road construction conditions. Automatic email notification if the account has not been used with a set period of time. • Major enhancement of the MileMapper reporting mechanism to include information required by CDOT for funding purposes. ORIGINAL SCOPE ADDITIONAL SCOPE BENEFITS This feature was reduced in scope to Automated regional and community- Better analysis of data captured. meet budget of $40K. No specific specific reports, exported to Excel, requirements in the contract scope of and containing at a minimum: work. - new users: total, by mode, and by program, event or campaign - new users who previously commuted via SOV: total, by mode, and by program, event or campaign - miles logged: total, by mode, and by program, event or campaign participation - miles logged by new vs. established users - trips logged: total, by mode, and by program, event or campaign participation - registration trend: increase/ decrease new users by month - usage trend: increase/ decrease miles by month - usage trend: increase/descrease trips by month - user profiles ODBC access for data mining by communities. Released Under Confidentiality to City of Fort Collins. Page 6 of 12 August 5, 2004 Copyright 0 2004. All Rights Reserved. Pacific Interrnedia, Inc. Pacific SmartTrips Platform Enhancement Recommendations and Cost PROPOSAL A more robust site content editor than originally planned so to allow more dynamic content entered by community users for custom campaigns and additions, enhancements, and edits. ORIGINAL SCOPE ADDITIONAL SCOPE BENEFITS An off -the -shelve product such as Inline WYSIWYG editor for all Increases site content and value to Macromedia Contribute can serve as regional static content pages, such the user because community management tool, with minor as "About SmartTrips." administrators will be able to add customization. more information. Interactive fortes that allow community administrators to enter, Increases site accuracy because modify or delete programs, events community administrators will be and promotional campaigns listed for able to update their own information. their community. These fortes are backed with templates for each Decreases site maintenance costs. category. Interactive forms that allow Decreases manual labor by regional administrator since community community administrators to enter, administrators are controlling their modify or delete case studies, FAQs own content. and/or testimonials. • Integration with the available ArcIMS server and initial definition of community GIS boundaries for orientation of users, events, promotions and programs. None Integration with the ArcIMS server Proactive planning for eventual provided to the site by Walsh integration of features requiring GIS- hosting. based mapping functionality. See Phase 2 and 3. • Text -Only interface for mobile -device access and enhanced ADA. 508 ADA compliance as tested via I Text -only version of the interface I Adherence to ADA compliance for all BOBBI text -based browsers (exceeding 508 compliance). Text -only access for easy and quick access to mobile devices which are a quickly evolving market for travlers and commuters. Released Under Confidentiality to City of Fort Collins. Page age 7 of 72 Copyright 0 2004. All Rights Reserved. Pacific Internedia, Inc. •rN pacific interniedia SmartTrips Platform Enhancement Recommendations and Cost PROPOSAL 3. Phase 2: Integration of GIS Routes Once the initial site is in place, we recommend integrating current GIS data sets, and creating any required new GIS data sets, to implement: • Dynamic GIS-based bike routes • Dynamic GIS-based transit routes • Dynamic GIS-based road construction and incident maps 4. Phase 3: Multi -Modal Itinerary Planning Once GIS data sets have been created, we propose that the next step for SmartTrips is a multi -model transit planner. This transit planner would require GIS routing functionality. The intention would be to allow users to plan routes using a combination of all modes: • Walking • Biking • Transit • Vanpool • Carpool Released Under Confidentiality to City of Fort Collins. Page 8 of 12 August 5, 2004 Copyright 0 2004. All Rights Reserved. Pacific Intermedia, Inc.