20210301 Part A RIPSA Cost Price Workbook.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
Screening Information Request (SIR) for Runway Incursion Prevention through Situational Awareness (RIPSA)
Solicitation number
693KA8-21-R-00000
Issued by

View the file

Other files

File Type Posted
J002 Labor Category and Skill Level Descriptions.pdf PDF
J011 RIPSA FA CDRL List.doc DOC document
J004 Predelivery Document Checklist.pdf PDF
J007 SAT Checklist - Copy.pdf PDF
J008 CAI Checklist.pdf PDF
J016 RIPSA Tech Description DIDs.doc DOC document
J005 FAT Checklist.pdf PDF
J001 Preliminary Program Requirements for RIPSA.pdf PDF
J013 RIPSA PM CDRL List.doc DOC document
J014 RIPSA PM DIDs.doc DOC document
J012 RIPSA FA DIDs.doc DOC document
J015 RIPSA Tech Desription CDRL List.doc DOC document
J010 Past Performance Questionnaire.doc DOC document
RIPSA SIR Final.docx DOCX document
J006 First Article Delivery Checklist.pdf PDF
J009 Field Checkout Checklist.pdf PDF
J003 Referenced Documents.pdf PDF
Show all 17

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cover Sheet

RUNWAY INCURSION PREVENTION THROUGH SITUATIONAL AWARENESS
(RIPSA)

Part A RIPSA COST/PRICE WORKBOOK

Instructions

No.TabInstructions
1GeneralThere is a Tab A for each site.

- Capital letter A designates T&M CLINs

- Lower case letter a designates San Antonio Airport

- Lower case letter b designates Daytona Airport

- Lower case letter c designates Tucson Airport

2Total Proposed PriceFor each proposed site, input the First Article proposed price.
3A-a, A-b, A-cPopulate T&M Rates Table for each Labor Category and for each proposed site - the T&M Rate Tables for each site are linked to the respective T&M CLINs within Tabs A, which are linked to the Total Proposed Price Tab. In accordance to SIR Section L3.2.1 Part B, Offerors must clearly explain and demonstrate the fully burdened rates buildup methodology and rationale used to develop the rates, inclusive of blended rates, if applicable.

Total Proposed Price Base Period

CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeSan AntonioDaytonaTucsonTotal Proposed Price
0001xC3.1Airport a/b/c - First Article (FA) System in accordance with (IAW) C3.1FP$ - 0$ - 0$ - 0$ - 0
0002xC3.1Airport a/b/c - Pre-Delivery DocumentationNSPNSPNSPNSPNSP
0003xC3.1Airport a/b/c - Factory Acceptance TestingNSPNSPNSPNSPNSP
0004xC3.1Airport a/b/c - First Article Equipment DeliveryNSPNSPNSPNSPNSP
0005xC3.1Airport a/b/c - Site Acceptance TestingNSPNSPNSPNSPNSP
0006xC3.1Airport a/b/c - Contractor Acceptance InspectionNSPNSPNSPNSPNSP
0007xC3.1Airport a/b/c - Field Checkout InspectionNSPNSPNSPNSPNSP
0008xC3.1, C3.2, C3.3Site Engineering Support - Program Management/Systems Engineering: Labor (for the total quantity of Airport a/b/c FA Systems) IAW SOW C3.1, C3.2, C3.3T&M$ - 0$ - 0$ - 0$ - 0
0009xC3.6Travel/Other Direct Costs (NTE)CR$ 20,000.00$ 20,000.00$ 20,000.00$ 60,000.00
0010xC3.2Program Management Reports IAW C3.2NSPNSPNSPNSPNSP
0011xC3.2Technical Meeting Reports IAW C3.2NSPNSPNSPNSPNSP
Total Period$ 20,000.00$ 20,000.00$ 20,000.00$ 60,000.00

Option Period 1

CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeSan AntonioDaytonaTucsonTotal Proposed Price
1008xC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 0$ - 0$ - 0$ - 0
1009xC3.6Travel/Other Direct Costs (NTE)CR$ 30,000.00$ 30,000.00$ 30,000.00$ 90,000.00
1010xC3.1, C3.2, C3.3Technical DocumentationNSPNSPNSPNSPNSP
Total Period$ 30,000.00$ 30,000.00$ 30,000.00$ 90,000.00

Option Period 2

CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeSan AntonioDaytonaTucsonTotal Proposed Price
2008xC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 0$ - 0$ - 0
2009xC3.6Travel/Other Direct Costs (NTE)CR$ 20,000.00$ 20,000.00$ 20,000.00$ 60,000.00
2010xC3.1, C3.2, C3.3Technical DocumentationNSPNSPNSPNSPNSP
Total Period$ 20,000.00$ 20,000.00$ 20,000.00$ 60,000.00

Total Price

Subtotal First Artice (FP CLINs)$ - 0$ - 0$ - 0$ - 0
Subtotal T&M CLINs$ - 0$ - 0$ - 0$ - 0
Subtotal (NTE Government Provided - CR CLINs)$ 70,000.00$ 70,000.00$ 70,000.00$ 210,000.00
Total Contract Price$ 70,000.00$ 70,000.00$ 70,000.00$ 210,000.00

&"Times New Roman,Bold"&12PART I - SECTION B &USUPPLIES OR SERVICES AND PRICE/COSTS &"Times New Roman,Bold"&12

&"Times New Roman,Bold"&12 PAGE B-&P

Tab A-a T&M CLINs San Antonio

T&M Labor Category Rates -- these rates will be used for the T&M CLINs for this contract. Separate fully loaded labor rates are identified for each year of the potential 3-year contract period of performance. The corresponding labor category definitions and minimum qualification requirements are included in contract Attachment J002. The following labor rates will be used for all T&M Labor Hour task orders issued under this contract.
San Antonio
Base Period - FY 21T&M Rates Table
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal PriceLabor CategoryFY21FY22FY23
0008aC3.1, C3.2, C3.3Site Engineering Support - Program Management/Systems Engineering: Labor (for the total quantity of Airport a FA Systems) IAW SOW C3.1, C3.2, C3.3T&M$ - 01Program Analyst - Level 6$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 02Program Analyst - Level 5$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate60$ - 0$ - 03Program Analyst - Level 4$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 04Program Analyst - Level 3$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate320$ - 0$ - 05Program Analyst - Level 2$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate240$ - 0$ - 06Program Analyst - Level 1$ - 0$ - 0$ - 0
Total Hours15607Technical Project Manager - Level 5$ - 0$ - 0$ - 0
Option Period 18Technical Project Manager - Level 4$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price9Technical Project Manager - Level 3$ - 0$ - 0$ - 0
1008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 010Technical Project Manager - Level 2$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 011Technical Project Manager - Level 1$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate40$ - 0$ - 012Systems Engineer - Level 6$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 013Systems Engineer - Level 5$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate160$ - 0$ - 014Systems Engineer - Level 4$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate400$ - 0$ - 015Systems Engineer - Level 3$ - 0$ - 0$ - 0
Total Hours154016Systems Engineer - Level 2$ - 0$ - 0$ - 0
Option Period 217Systems Engineer - Level 1$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price18Software Engineer - Level 6$ - 0$ - 0$ - 0
2008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 019Software Engineer - Level 5$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate240$ - 0$ - 020Software Engineer - Level 4$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate20$ - 0$ - 021Software Engineer - Level 3$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate480$ - 0$ - 022Software Engineer - Level 2$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate80$ - 0$ - 023Software Engineer - Level 1$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate190$ - 0$ - 024Systems Integrator/Field Technician - Level 6$ - 0$ - 0$ - 0
Total Hours101025Systems Integrator/Field Technician - Level 5$ - 0$ - 0$ - 0
Total T&M CLINs$ - 026Systems Integrator/Field Technician - Level 4$ - 0$ - 0$ - 0
27Systems Integrator/Field Technician - Level 3$ - 0$ - 0$ - 0
28Systems Integrator/Field Technician - Level 2$ - 0$ - 0$ - 0
29Systems Integrator/Field Technician - Level 1$ - 0$ - 0$ - 0

Tab A-b T&M CLINs Daytona

T&M Labor Category Rates -- these rates will be used for the T&M CLINs for this contract. Separate fully loaded labor rates are identified for each year of the potential 3-year contract period of performance. The corresponding labor category definitions and minimum qualification requirements are included in contract Attachment J002. The following labor rates will be used for all T&M Labor Hour task orders issued under this contract.
Daytona Beach
Base Period - FY 22T&M Rates Table
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal PriceLabor CategoryFY21FY22FY23
0008aC3.1, C3.2, C3.3Site Engineering Support - Program Management/Systems Engineering: Labor (for the total quantity of Airport b FA Systems) IAW SOW C3.1, C3.2, C3.3T&M$ - 01Program Analyst - Level 6$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 02Program Analyst - Level 5$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate60$ - 0$ - 03Program Analyst - Level 4$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 04Program Analyst - Level 3$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate320$ - 0$ - 05Program Analyst - Level 2$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate240$ - 0$ - 06Program Analyst - Level 1$ - 0$ - 0$ - 0
Total Hours15607Technical Project Manager - Level 5$ - 0$ - 0$ - 0
Option Period 18Technical Project Manager - Level 4$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price9Technical Project Manager - Level 3$ - 0$ - 0$ - 0
1008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 010Technical Project Manager - Level 2$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 011Technical Project Manager - Level 1$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate40$ - 0$ - 012Systems Engineer - Level 6$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 013Systems Engineer - Level 5$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate160$ - 0$ - 014Systems Engineer - Level 4$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate400$ - 0$ - 015Systems Engineer - Level 3$ - 0$ - 0$ - 0
Total Hours154016Systems Engineer - Level 2$ - 0$ - 0$ - 0
Option Period 217Systems Engineer - Level 1$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price18Software Engineer - Level 6$ - 0$ - 0$ - 0
2008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 019Software Engineer - Level 5$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate240$ - 0$ - 020Software Engineer - Level 4$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate20$ - 0$ - 021Software Engineer - Level 3$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate480$ - 0$ - 022Software Engineer - Level 2$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate80$ - 0$ - 023Software Engineer - Level 1$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate190$ - 0$ - 024Systems Integrator/Field Technician - Level 6$ - 0$ - 0$ - 0
Total Hours101025Systems Integrator/Field Technician - Level 5$ - 0$ - 0$ - 0
Total T&M CLINs$ - 026Systems Integrator/Field Technician - Level 4$ - 0$ - 0$ - 0
27Systems Integrator/Field Technician - Level 3$ - 0$ - 0$ - 0
28Systems Integrator/Field Technician - Level 2$ - 0$ - 0$ - 0
29Systems Integrator/Field Technician - Level 1$ - 0$ - 0$ - 0

Tab A-c T&M CLINs Tucson

T&M Labor Category Rates -- these rates will be used for the T&M CLINs for this contract. Separate fully loaded labor rates are identified for each year of the potential 3-year contract period of performance. The corresponding labor category definitions and minimum qualification requirements are included in contract Attachment J002. The following labor rates will be used for all T&M Labor Hour task orders issued under this contract.
Tucson
Base Period - FY 23T&M Rates Table
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal PriceLabor CategoryFY21FY22FY23
0008aC3.1, C3.2, C3.3Site Engineering Support - Program Management/Systems Engineering: Labor (for the total quantity of Airport c FA Systems) IAW SOW C3.1, C3.2, C3.3T&M$ - 01Program Analyst - Level 6$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 02Program Analyst - Level 5$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate60$ - 0$ - 03Program Analyst - Level 4$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 04Program Analyst - Level 3$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate320$ - 0$ - 05Program Analyst - Level 2$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate240$ - 0$ - 06Program Analyst - Level 1$ - 0$ - 0$ - 0
Total Hours15607Technical Project Manager - Level 5$ - 0$ - 0$ - 0
Option Period 18Technical Project Manager - Level 4$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price9Technical Project Manager - Level 3$ - 0$ - 0$ - 0
1008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 010Technical Project Manager - Level 2$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate420$ - 0$ - 011Technical Project Manager - Level 1$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate40$ - 0$ - 012Systems Engineer - Level 6$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate520$ - 0$ - 013Systems Engineer - Level 5$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate160$ - 0$ - 014Systems Engineer - Level 4$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate400$ - 0$ - 015Systems Engineer - Level 3$ - 0$ - 0$ - 0
Total Hours154016Systems Engineer - Level 2$ - 0$ - 0$ - 0
Option Period 217Systems Engineer - Level 1$ - 0$ - 0$ - 0
CLINIAW SOWSUPPLIES OR SERVICESCLIN TypeHoursRateTotal Price18Software Engineer - Level 6$ - 0$ - 0$ - 0
2008aC3.1, C3.2, C3.3Project Management/Engineering Support IAW C3.1, C3.2, C3.3T&M$ - 019Software Engineer - Level 5$ - 0$ - 0$ - 0
Program Analyst - Level 1T&M Rate240$ - 0$ - 020Software Engineer - Level 4$ - 0$ - 0$ - 0
Technical Project Manager - Level 2T&M Rate20$ - 0$ - 021Software Engineer - Level 3$ - 0$ - 0$ - 0
Systems Engineer - Level 1T&M Rate480$ - 0$ - 022Software Engineer - Level 2$ - 0$ - 0$ - 0
Software Engineer - Level 2T&M Rate80$ - 0$ - 023Software Engineer - Level 1$ - 0$ - 0$ - 0
Systems Integrator/Field Technician - Level 3T&M Rate190$ - 0$ - 024Systems Integrator/Field Technician - Level 6$ - 0$ - 0$ - 0
Total Hours101025Systems Integrator/Field Technician - Level 5$ - 0$ - 0$ - 0
Total T&M CLINs$ - 026Systems Integrator/Field Technician - Level 4$ - 0$ - 0$ - 0
27Systems Integrator/Field Technician - Level 3$ - 0$ - 0$ - 0
28Systems Integrator/Field Technician - Level 2$ - 0$ - 0$ - 0
29Systems Integrator/Field Technician - Level 1$ - 0$ - 0$ - 0

File details come from the government source that posted it. Updated .