Attachment_2_-_Cost_Workbook.xlsx

Instructions GTFS-Realtime Services RFP Event ID 0000032011

ATTACHMENT 2 - COST WORKBOOK

1. Enter Bidder Name in Cell A2 above.

2. The Bidder is required to provide pricing on the subsequent worksheets to meet the requirements of the RFP. This Cost Workbook contains three (3) worksheets for the Bidder to complete to indicate all costs associated with its proposal. No other costs will be considered for the proposal outside of this Cost Workbook.

- Worksheet A: GTFS-Realtime Services

- Worksheet B: On-Vehicle Devices and Contractor Standard Installation Services

- Worksheet C: Hourly Rate Sheet

3. The Bidder shall add appropriate pricing in locations in each sheet as per the instructions. The Bidder shall only enter information in cells that are highlighted in yellow. The Bidder must not reformat any part of this Workbook, any reformatting may be cause for rejection of the proposal.

4. Costs will be evaluated using the Estimated Total Cost of Ownership (which is based on the bid prices), found at the bottom of the "Estimated TCO Calc" worksheet. See RFP Section 6 for complete information on the bid scoring methodology.

End of Sheet. Go to Next Tab.

A. GTFS-Realtime Services GTFS-Realtime Services RFP Event ID 0000032011

ATTACHMENT 2 - COST WORKBOOK

Worksheet A: GTFS-Realtime Services

1. In cell C5 in the table below, the Bidder must provide its Implementation Base Fee for its GTFS-Realtime Services. The Implementation Base Fee shall be a one-time fee charged to the Transit Provider in conjunction with the Implementation Variable Fee (see item #2 below), subject to the terms in Exhibit B - Budget Detail and Payment Provisions.

2. In cells C6 and C7 in the table below, the Bidder must provide its Implementation Variable Fee for its GTFS-Realtime Services, which shall be expressed as both a one-time fee per vehicle (C6) and a one-time fee per route (C7). The Implementation Variable Fee in either cell C6 or C7 shall be multiplied by the number of vehicles or routes to which the GTFS-Realtime Services will be deployed, as specified in the User Agreement, and whichever calculation yields the lowest cost to the Transit Provider, that amount shall be charged as a one-time fee to the Transit Provider in conjunction with the Implementation Base Fee (see item #1 above), subject to the terms in Exhibit B - Budget Detail and Payment Provisions.

3. In cell C8 in the table below, the Bidder must provide its Ongoing Monthly Base Fee for its GTFS-Realtime Services. The Ongoing Monthly Base Fee shall be charged monthly to the Transit Provider in conjunction with the Ongoing Monthly Variable Fee (see item #4 below), subject to the terms in Exhibit B - Budget Detail and Payment Provisions.

4. In cells C9 and C10 in the table below, the Bidder must provide its Ongoing Monthly Variable Fee for its GTFS-Realtime Services, which shall be expressed as both a monthly fee per vehicle (C9) and a monthly fee per route (C10). The Ongoing Monthly Variable Fee in either cell C9 or C10 shall be multiplied by the number of vehicles or routes to which the GTFS-Realtime Services are deployed, as specified in the User Agreement, and whichever calculation yields the lowest cost to the Transit Provider, that amount shall be charged monthly to the Transit Provider in conjunction with the Ongoing Monthly Base Fee (see item #3 above), subject to the terms in Exhibit B - Budget Detail and Payment Provisions.

5. Collectively, the Implementation Base Fee, Implementation Variable Fee, Ongoing Monthly Base Fee, and Ongoing Monthly Variable Fee provide compensation to the Contractor for the full scope of GTFS-Realtime Services (refer to Exhibit A.1, Section 1) including Customer Support for GTFS-Realtime Services (refer to Exhibit A.1, Section 3).

B. On-Vehicle Devices GTFS-Realtime Services RFP Event ID 0000032011

ATTACHMENT 2 - COST WORKBOOK

Worksheet B: On-Vehicle Devices and Contractor Standard Installation Services

1. In the table below, the Bidder must provide prices for its On-Vehicle Devices and Contractor Standard Installation Services (refer to Exhibit A.1, Section 2). Bidders must list proposed devices in ascending order from lowest to highest cost, with the lowest cost device listed as Device #1. Only the lowest cost device meeting the On-Vehicle Device Requirements (refer to Exhibit A.3) will be scored.

2. For each On-Vehicle Device proposed, the Bidder must identify the Brand (Column C), Model (Column D), Manufacturer Part Number (MPN) (Column E), and the Unit Cost and On-Vehicle Device Contractor Standard Installation Fee in the two rows immediately below these inputs (in Column F). The On-Vehicle Device Unit Cost shall be multiplied by the number of devices deployed, as specified in the User Agreement, which shall be a one-time sales charge to the Transit Provider subject to the terms in Exhibit B - Budget Detail and Payment Provisions.

3. The Contractor Standard Installation Fee shall only be charged if the User Agreement specifies that the installation is a Contractor Standard Installation (refer to Exhibit A.1, Section 2.3). The User Agreement will specify for each On-Vehicle Device whether the installation shall be a Transit Provider Installation, Contractor Standard Installation, or Contractor Custom Installation. If the installation is a Transit Provider Installation, there shall be no charge to the Transit Provider. If the installation is a Contractor Custom Installation, the pricing on Worksheet C (Hourly Rate Sheet) for Contractor Custom Installation shall apply.

4. The Bidder may add additional rows to this worksheet to include more than six (6) devices in its offering.

End of Sheet. Go to Next Tab.

C. Hourly Rate Sheet GTFS-Realtime Services RFP Event ID 0000032011

ATTACHMENT 2 - COST WORKBOOK

Worksheet C: Hourly Rate Sheet

1. In cell C5 in the table below, the Bidder must provide an hourly rate for its GTFS-Realtime Services Additional Support to be provided on an as-needed, if-needed basis (refer to Exhibit A.1, Section 1.6).

2. In cell C6 in the table below, the Bidder must provide an hourly rate for its On-Vehicle Devices Additional Support to be provided on an as-needed, if-needed basis (refer to Exhibit A.1, Section 2.7), if the Bidder is including On-Vehicle Devices Additional Support services in its proposal. This hourly rate will not be evaluated.

3. In cell C7 in the table below, the Bidder must provide an hourly rate for its Contractor Custom Installation Services, which shall apply if a Contractor Custom Installation is specified as the installation type in the User Agreement (refer to Exhibit A.1, Section 2.3).

4. All hourly rate fees shall be subject to the terms in Exhibit B - Payment and Budget Provisions.

5. The State of California shall not guarantee any minimum or maximum amount of the Contractor’s services that may be required under the User Agreement.

Estimated TCO Calc GTFS-Realtime Services RFP Event ID 0000032011

ATTACHMENT 2 - COST WORKBOOK

Estimated Total Cost of Ownership (TCO) Calculation (For evaluation purposes only)