Attachment_4_-_Cross_Reference_Matrix.xlsx

XLSX spreadsheet 61 KB Posted

Attached to
SBEAS FINAL REQUEST FOR PROPOSAL Federal contract opportunity
Solicitation number
FA8771-17-R-1000
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Maxwell Air Force Base

View the file

Other files for this federal contract opportunity

Other files attached to SBEAS FINAL REQUEST FOR PROPOSAL, newest first.
File Type Posted
Amendment_02_19_Oct_2017.pdf PDF
5_-_Self_Scoring_Worksheet_Amendment_01.xlsx XLSX spreadsheet
4_-Cross_Reference_Matrix_Amendment_01.xlsx XLSX spreadsheet
Final_RFP_QAs_General_Statement.pdf PDF
PPN_and_TN_Submission_Template.docx DOCX document
Base_Access_Information.pdf PDF
JVA_Confirmations.pdf PDF
SBEAS_Summary_of_Changes.pdf PDF
Attachment_5_-_Self_Scoring_Worksheet.xlsx XLSX spreadsheet
SBEAS_Final_Request_for_Proposal_(RFP)_FA8771-17-R-1000.pdf PDF
Schedule_Update_18_Aug_2017.pdf PDF
2nd_Draft_RFP_Questions_and_Responses_FBO.pdf PDF
8._SBEAS_CDRLs.pdf PDF
2nd_Draft_Request_for_Proposal_SBEAS_June_2017.pdf PDF
ppi_tool.accdb —
DRAFT_Attachment_10_PPI_Tool_Instructions.pdf PDF
SBEAS_Update_24_May_2017.pdf PDF
JV_Agreement_Criteria_Fillable_24_May_17.pdf PDF
SBEAS_JV_Update_22_May_17.pdf PDF
JV_Agreement_Criteria_Fillable.pdf PDF
JV_Agreement_Criteria_Amendment_1.pdf PDF
10_April_Industry_Day_Vendor_Sign_In_Redacted.pdf PDF
JV_Agreement_Criteria_1_May_2017.pdf PDF
Joint_Venture_Agreement_Cover_Letter_1_May_2017_Signed.pdf PDF
http://www.gunter.af.mil/units/hicdivision-enterpriseservicesdivision/sbeas.asp ASP file
Post_Industry_Week_Update_24_April_17.pdf PDF
Vendor_Industry_Day_Slides_for_10_Apr_17.pdf PDF
Industry_Partner_Invite_v4_Amendment_2.pdf PDF
JV_Memo_3_April_17.pdf PDF
Draft_RFP_Cover_Letter__SBEAS_Amended.pdf PDF
Draft_RFP_SBEAS.pdf PDF
Industry_Partner_Invite_Vendor_Industry_Week_Amendment_1.pdf PDF
Industry_Partner_Invite_Vendor_Industry_Week.pdf PDF
2nd_IndustryDay_SBEAS-Agenda.pdf PDF
Statement_of_Objectives_Q_&_A_Feb_2017.pdf PDF
Flyer_2nd_Industry_Day.pdf PDF
SBEAS_SOO_Comment_Resolution_Matrix.xlsx XLSX spreadsheet
SOO_Cover_Letter.pdf PDF
SB_Enterprise_Application_Solutions_SOO_v1.pdf PDF
Q_&_As_to_RFI.pdf PDF
Industry_Day_Questions_Responses.pdf PDF
Mentor_Protege_Program.pptx PPTX presentation
Industry_Day_Registration_Log.pdf PDF
SBEAS_RFI_Worksheet_30Nov2016_Amendment.xlsx XLSX spreadsheet
VID_Feedback_Prep.pptx PPTX presentation
IndustryDay_SBEAS_30Nov16.pdf PDF
SBEAS_RFI_Worksheet_30Nov2016.xlsx XLSX spreadsheet
VID_Agenda.pdf PDF
RFI_Cover_Letter.pdf PDF
Industry_Partner_Invite_v2.pdf PDF
Show all 50

SBEAS FINAL REQUEST FOR PROPOSAL has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

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

Text version

Instructions

SBEAS Cross Reference Matrix Instructions
Note 1: Only enter responses in columns B through G

Note 2: A "Sample CRM" worksheet is provided for reference on entering information required only. No evaluation implications are intended by the examples given.

Note 3: Information entered into cells B3 - G8 will automatically populate into cells B50 - G55.

Note 4: The cells with zeros (0) in them are an internal check. The zeros mean the cells below are empty. Once a reference is typed in the cell, the zero is changed to identify how many cells are "not blank". A space, with no text, will cause the cell to count as filled.

Step 1: Enter the Offeror name in Row 1 of the "CRM For Submission" Worksheet
Step 2: Enter the Contract Information:

In Row 3 Contract Number:

-Enter the contract number being used for each contract used in the Technical Volume. Include the task order number(s) as applicable; expand the row if necessary -If an offeror submits less than six (6) contract references in the technical volume, enter "NOT USED" in the remaining cells for Row 3.

In Row 4 Customer/Organization Name:

- Enter the Customer and Organization's name who can confirm the work performed for the contract..

In Row 5 Project Title:

- Provide a short but detailed descriptive narrative (in plain English) of the project that informs the reader of the project’s purpose and intent.

In Row 6 Period of Performance (PoP):

- Enter the PoP in the following format: Day-Month-Year through Day-Month-Year DD-MMM-YY through DD-MMM-YY. If the work is still in progress, the end of the PoP may be replace with "present". See the sample CRM.

In Row 7 Customer Phone Number:

- Enter the phone number, with area code, of the customer identified in row 4. Example: (###) ###-#### In Row 8 Customer E-mail

- Enter the email address of the customer identified in row 4.

Step 3: Complete the Factor 1 TECHNICAL EXPERIENCE Cross-Reference -In rows 12 through 47, insert the page and paragraph number in columns B through G, indicating where the experience for the Column A TECHNICAL ELEMENT is demonstrated in the TECHNICAL NARRATIVE section of the Technical Volume.

Step 4: Verify the Contract Information in Rows 50 - 55:

- If less than six (6) contract references are used in the Technical volume (in Row 3), use the additional cells in Rows 50 - 55, with the Contract Number now titled "NOT USED" to insert the additional contract information for references used for the PAST PERFORMANCE volume. *Note, it is permissible to have more contract references for Past Performance than used for Technical Experience; however all contract references used for Technical Experience shall also be used for Past Performance.

Step 5: Complete the Factor 2 PAST PERFORMANCE Sub-Factor Cross-Reference -In rows 58 - 77, insert the page and paragraph number in columns B through G, indicating where the experience for the Column A PAST PERFORMANCE ELEMENT is demonstrated in the PAST PERFORMANCE NARRATIVE section of the Past Performance Volume.

Section J Attachment 4 Cross-Reference Matrix (CRM) Instructions

FA8771-17-R-1000

Page &P of &N

SAMPLE CRM

SBEAS CROSS-REFERENCE MATRIX (Offeror: )
Technical NarrativeTechnical NarrativeTechnical NarrativeTechnical NarrativeTechnical NarrativeTechnical Narrative
Contract NumberFA8771-14-D-0007, 0100, 0125, 0138FA8772AB1234XX0001NOT USEDNOT USED
Customer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization Name
Project TitleProject TitleProject TitleProject TitleProject TitleProject TitleProject Title
Period of Performance07-Apr-15 through 06-Apr-1701-Jun-16 through present23-Feb-15 through present17-Aug-16 through 16 Aug-17Period of PerformancePeriod of Performance
Customer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone Number
Customer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mail
FACTOR 1: TECHNICAL EXPERIENCE
Life-cycle SW Svc (Element #1):121100
1(a) Provided development services for an Information System (IS)
1(b)(1) Re-EngineeringPages 1-3 paragraphs 4-3Page 4, paragraphs 3-4
1(c)(2) MigrationPage 4, paragraph 3
1(d)(3) ModernizationPage 7, paragraph 4
1(e) ERPPage 12, paragraphs 5-6
Cybersecurity (Element #2):010100
2(a) Assess software application vulnerabilities and threats using RMFPage 13, paragraph 2
2(b) Risk Management Principles and Information Security RequirementsPage 4, paragraphs 3-4
IT Business Analysis (Element #3):001200
3(a) Requirements AnalysisPage 13, paragraph 3
3(b) Testing, Validation and VerificationPage 16, paragraphs 2-4
3(c) Service DeskPage 8, paragraph 3
3(d) Functional Business Area Expert (FBAE)
Programming Lang/Frameworks (Element #4):101000
4(a) Any 2: Java, COBOL, PowerBuilder, .NET, ColdFusion, C#Page 7, paragraphs 3-5
4(b) Any 2: JavaScript, Perl, SQL, PYTHON, PHPPage 4, paragraph 2
4(c) Any 1: SWIFT, Ruby On Rails, JavaScript MV* Frameworks, Spark
Tools/Dev Method (Element #5):101000
5(a) Security
5(b) QualityPage 3, paragraph 4
5(c) Testing
5(d) Development MethodologyPage 6, paragraph 1
Platform/Environ (Element #6):000000
6(a) Mainframe, Mid-tier/Client-server, Web Services
6(b) Customer's facility
6(c) Commercial, Non-commercial, Hybrid Cloud
6(d) DISA DECC or DoD computing facility
Database Comp (Element #7):000000
7(a) RDBMS
7(b) NoSQL
7(c) Data store support for RDBMS or NoSQL
Mobile/IoT (Element #8):000000
8(a) New Mobile Application Development
8(b) Redesigned legacy system to work or on mobile device
8(c) Automatic Identification Technology (AIT)
Server Operating Systems (Element #9):Page 7, paragraph 4
COTS/GOTS/FOSS Software (Element #10):
Past Performance NarrativePast Performance NarrativePast Performance NarrativePast Performance NarrativePast Performance NarrativePast Performance Narrative
Contract NumberFA8771-14-D-0007, 0100, 0125, 0138FA8772AB1234XX0001NOT USEDNOT USED
Customer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization Name
Project TitleProject TitleProject TitleProject TitleProject TitleProject TitleProject Title
Period of Performance07-Apr-15 through 06-Apr-1701-Jun-16 through present23-Feb-15 through present17-Aug-16 through 16 Aug-17Period of PerformancePeriod of Performance
Customer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone Number
Customer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mail
FACTOR 2: PAST PERFORMANCE
Sub-Factor 1:
Life-Cycle Software Services245221
1(a) System Architect and DesignPage 16, paragraph 2
1(b) Technical Solution, Design, Creation and ImplementationPage 2, paragraph 3Page 4, paragraph 1Page 6, paragraph 3Page 17, paragraph 1
1(c) Software Development MethodologiesPage 4, paragraph 3Page 4, paragraphs 1-2Page 6, paragraph 1Page 19, paragraph 4
1(d) Information Web Services Development and Testing
1(e) Mobile or Internet of Things (IoT)
1(f) Information Display Solutions and ServicesPage 6, paragraph 3
1(g) Database Development or ConversionPage 7, paragraphs 3-5
1(h) Automated Integration Testing and Implementation
1(i) Data or System MigrationPage 4, paragraph 3
1(j) Application/System/Database/Interface AdministrationPage 12, paragraph 8
1(k) Modification of F3I or Interface an In-Service Configuration Item
1(l) Hardware Technology RefreshPage 13, paragraph 3
1(m) Software ModernizationPage 3, paragraphs 3-4Page 7, paragraph 4
1(n) Decommission Planning and Execution
Sub-factor 2: Cybersecurity010111
2(a) Confidentiality, Integrity, and AvailabilityPage 4, paragraphs 3-5
2(b) Authentication, Authorization, and Accountability (nonrepudiation))Page 12, paragraph 6;
Page 13, paragraph 2Page 16, paragraph 3Page 20, paragraph 2
Sub-Factor 3: IT Business Analysis001111
3(a) Functional Business Area Expertise (FBAE) in two (2) areasPage 13, paragraph 3Page 16, paragraph 6
3(b) Service desk, field and technical supportPage 8, paragraph 3Page 22, paragraph 3

Section J Attachment 4 Cross-Reference Matrix (CRM) Sample

Page &P of &N

CRM For Submission

SBEAS CROSS-REFERENCE MATRIX (Offeror: )
Technical NarrativeTechnical NarrativeTechnical NarrativeTechnical NarrativeTechnical NarrativeTechnical Narrative
Contract NumberContract NumberContract NumberContract NumberContract NumberContract NumberContract Number
Customer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization Name
Project TitleProject TitleProject TitleProject TitleProject TitleProject TitleProject Title
Period of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of Performance
Customer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone Number
Customer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mail
FACTOR 1: TECHNICAL EXPERIENCE
Life-cycle SW Svc (Element #1):000000
1(a) Provided development services for an Information System (IS)
1(b)(1) Re-Engineering
1(c)(2) Migration
1(d)(3) Modernization
1(e) ERP
Cybersecurity (Element #2):000000
2(a) Assess software application vulnerabilities and threats using RMF
2(b) Risk Management Principles and Information Security Requirements
IT Business Analysis (Element #3):000000
3(a) Requirements Analysis
3(b) Testing, Validation and Verification
3(c) Service Desk
3(d) Functional Business Area Expert (FBAE)
Programming Lang/Frameworks (Element #4):000000
4(a) Any 2: Java, COBOL, PowerBuilder, .NET, ColdFusion, C#
4(b) Any 2: JavaScript, Perl, SQL, PYTHON, PHP
4(c) Any 1: SWIFT, Ruby On Rails, JavaScript MV* Frameworks, Spark
Tools/Dev Method (Element #5):000000
5(a) Security
5(b) Quality
5(c) Testing
5(d) Development Methodology
Platform/Environ (Element #6):000000
6(a) Mainframe, Mid-tier/Client-server, Web Services
6(b) Customer's facility
6(c) Commercial, Non-commercial, Hybrid Cloud
6(d) DISA DECC or DoD computing facility
Database Comp (Element #7):000000
7(a) RDBMS
7(b) NoSQL
7(c) Data store support for RDBMS or NoSQL
Mobile/IoT (Element #8):000000
8(a) New Mobile Application Development
8(b) Redesigned legacy system to work or on mobile device
8(c) Automatic Identification Technology (AIT)
Server Operating Systems (Element #9):
COTS/GOTS/FOSS Software (Element #10):
Past Performance Narrative 1Past Performance Narrative 2Past Performance Narrative 3Past Performance Narrative 4Past Performance Narrative 5Past Performance Narrative 6
Contract NumberContract NumberContract NumberContract NumberContract NumberContract NumberContract Number
Customer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization NameCustomer/Organization Name
Project TitleProject TitleProject TitleProject TitleProject TitleProject TitleProject Title
Period of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of PerformancePeriod of Performance
Customer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone NumberCustomer Phone Number
Customer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mailCustomer E-mail
FACTOR 2: PAST PERFORMANCE
Sub-Factor 1: Life-cycle Software Services000000
1(a) System Architect and Design
1(b) Technical Solution, Design, Creation and Implementation
1(c) Software Development Methodologies
1(d) Information Web Services Development and Testing
1(e) Mobile or Internet of Things (IoT)
1(f) Information Display Solutions and Services
1(g) Database Development or Conversion
1(h) Automated Integration Testing and Implementation
1(i) Data or System Migration
1(j) Application/System/Database/Interface Administration
1(k) Modification of F3I or Interface an In-Service Configuration Item
1(l) Hardware Technology Refresh
1(m) Software Modernization
1(n) Decommission Planning and Execution
Sub-factor 2: Cybersecurity000000
2(a) Confidentiality, Integrity, and Availability
2(b) Authentication, Authorization, and Accountability (nonrepudiation))
Sub-Factor 3: IT Business Analysis000000
3(a) Functional Business Area Expertise (FBAE) in two (2) areas
3(b) Service desk, field and technical support

Section J Attachment 4 Cross-Reference Matrix (CRM) Submission

Page &P of &N

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