No preview available
HomeMy WebLinkAboutC19-373 Modern CodecraftAirport Scheduler
 SOW - 001 Version 1.0 October 14, 2019 Presented by: Josh Morris m code dern craft DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Introduction PROFESSIONAL SERVICES AGREEMENT This Statement of Work is incorporated into that certain Professional Services Agreement dated May 2nd, 2019 by and between Eagle County Airport (“Client”) and Modern Codecraft LLC (“Company”) (the “Agreement”). This Statement of Work describes Services and Deliverables to be performed and provided by Company pursuant to the Agreement. If any item in this Statement of Work is inconsistent with the Agreement prior to such incorporation, the terms of this Statement of Work will control, but only with respect to the Services to be performed under this Statement of Work. All capitalized terms used and not expressly defined in this Statement of Work will have the meanings given to them in the Agreement. SCOPE OF WORK Problem Client receives spreadsheets from various airlines with their expected flight schedules. These schedules need to be aggregated and scheduled across the available gates using a predefined set of rules and priorities. Airport employees need the capability to manually make modifications to the schedule in an ad-hoc fashion. This schedule should be printable, sharable in a digital form outside of the airport, and viewable by employees on site. Solution Company will provide a solution to automate this process using Google Cloud Platform and G-Suite. For more details, see the Specifications portion of this document. SERVICES •Architecture and Development •Perform QA Testing •Support UAT Testing •Training •Deploy and Launch DELIVERABLES •GCP Project-based Server Agent to Build Calendars DELIVERY TIMEFRAME The delivery of the Software into QA is currently planned for mid-to-late November with a production release before December. DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 CLIENT OBLIGATIONS The client will provide the GCP and G-Suite environments for development, testing, and production releases. Client will provide answers to questions or validate assumptions posed by the Company in a timely and accurate fashion. The responses provided may impact the timeline, effort/cost to deliver, and/or the scope of the project; possibly requiring a change order to this STATEMENT OF WORK. INITIAL QUESTIONS These requirements describe the desired behaviors and capabilities of the deliverable. •Can the document include data to specify whether a flight is an Existing Scheduled Service? •Can the document include data to specify whether a flight belongs to a Signatory Airline? •Can the document include data to specify whether a flight belongs to an airline that offers year- round service? •Can the document include data to specify whether a flight uses an aircraft with special considerations, such as Narrow Body Aircraft? •Can we determine Originating vs Terminating vs Through flight from the spread sheet data using Origin and Destination airport codes? •Can the document include data to specify whether a flight, if any, are RON. •What is the full list of Airplane Design Group considerations the software must handle and their priority or gate restrictions? ASSUMPTIONS •The sample data is missing some of the attributes required. This has been discussed and we should receive an updated document. For example: there are no departure times. •Each gate will be configured within the software with any necessary information to evaluate its suitability for a flight. •Configuration is performed through build files. In order to change configurations, a new build must be run and deployed. •Performance and availability will be predicated upon Google Drive and Calendar API characteristics.
 DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Specifications In addition to the software deliverable, MCC will provide the initial training session and support the usability testing by Eagle. REQUIREMENTS These requirements describe the desired behaviors and capabilities of the deliverable. •Software will be configured to look at a specific folder in Google Drive and ingest CSV files found in it within a configured interval. •Files will be renamed to show their current state, such as complete or processing. •Files with a configured phrase in their name, such as simulation, will be processed, but not actually write records to the calendar. It will still generate the error report. •Software will load the files provided within the interval and merge them into a single job to run. •Software will report any conflicts it cannot resolve automatically in a spreadsheet that will be made available in a configured folder. •Software can send an email notification, if SendGrid is enabled. •Each gate will be given a calendar and configured within the software with any necessary information to evaluate its suitability for a flight. •Software will create invites on each gate’s calendar for each flight that was successfully scheduled. It will not double-book any calendar. •This will allow the airport to schedule maintenance or windows of unavailability for each gate at their discretion. The software will not schedule a flight during any of these times that are on the calendar at the time of ingestion. •Software will leave a configured period of time between invites. •Software will use a GCP service account to read/write calendar entries. The software relies upon the availability and functionality of Google Calendar to process and schedule the flights. RULES Primary Rules of Priority 1.Existing Scheduled Service by Signatory Airlines shall have Level 1 priority. 2.New Scheduled Service by Signatory Airlines shall have Level 2 priority. 3.Existing Scheduled Service by Non-Signatory Airlines shall have Level 3 priority. 4.New Scheduled Service by Non-Signatory Airlines shall have Level 4 priority. DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Secondary Rules of Priority
 Flights having the same primary priority level shall be assigned to Gates (and conflicts among or between Airlines shall be resolved) in accordance with the secondary rules of priority. 1.Flights will be assigned in order of most restrictive Airplane Design Group to least (i.e., in most cases, largest aircraft to smallest). 2. Flights will be assigned in order of largest seating capacity to smallest. 3.Through flights will be assigned before a RON aircraft. 4.Flights of airlines offering year-round service will be assigned before flights of airlines offering seasonal service.
 DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Fees In consideration for Company’s performance of the Services and providing of the Deliverables, Company will be compensated as follows: MILESTONE FEE BASIS Fees payable in accordance with the table immediately below and the DEVELOPMENT SCHEDULE in this STATEMENT OF WORK. MILESTONES RELATED EXPENSES There are no additional related expenses. WARRANTY MCC warrants that the Services will be performed in a workmanlike and professional manner by individuals who have the skill and experience commensurate with the requirements of the Services. MCC does not warrantee the resulting product. Any defects or issues discovered after acceptance can be addressed through future services and deliverables defined in future SOWs.
 Phase Fee M1 - Project Start $11,000 M2 - Feature Complete Development, Start of QA $11,000 M3 - Production Release $3,000 DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Acceptance and Authorization IN WITNESS WHEREOF, the parties hereto each acting with proper authority have executed this Statement of Work. Eagle County Airport Modern Codecraft LLC Full name Full name Title Title Signature Signature Date Date DocuSign Envelope ID: 53C8CFD5-B7BF-41A9-85CD-362CBFDEE2A9 Josh Morris CEO, Managing Member 11/12/2019 County Manager 11/12/2019 Jeff Shroll