Attachment 0005 - Cost-Price Matrix.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Fort Riley, KS EAGLE Task Order Federal contract opportunity
Solicitation number
W52P1J20R0050
Issued by
Department of the Army Materiel Command Joint Munitions Command

View the file

Other files for this federal contract opportunity

Other files attached to Fort Riley, KS EAGLE Task Order, newest first.
File Type Posted
Attachment 0005 - Cost-Price Matrix - 8 April 2021.xlsx XLSX spreadsheet
W52P1J-20-R-0050 Amendment 0003 - 9 April 2021.pdf PDF
W52P1J-20-R-0050 Amendment 0002 - 6 April 2021.pdf PDF
Attachment 0002 - Staffing and Labor Mix - 30 March 2021.xlsx XLSX spreadsheet
Attachment 0005 - Cost-Price Matrix - 6 April 2021.xlsx XLSX spreadsheet
Attachment 0007 - DoL WD 2015-5337 Rev 12 - 21 Dec 2020.pdf PDF
Attachment 0005 - Cost_Price Matrix - 18 March 2021.xlsx XLSX spreadsheet
Attachment 0002 - Staffing and Labor Mix - 11 March 2021.xlsx XLSX spreadsheet
Attachment 0001 - PWS - 24 March 2021.pdf PDF
W52P1J-20-R-0050 Amendment 0001 - 26 March 2021.pdf PDF
Appendix B - UME - RESERVED.docx DOCX document
Appendix A - PAAT.DOCX DOCX document
Exhibit B - Fort Riley CDRL Portfolio.pdf PDF
Attachment 0006 - SF1408 Preaward Survey of Prospective Contractor Accounting System 07OCT2020.pdf PDF
Appendix D - SLA.DOCX DOCX document
Annex A Maintenance PRS.docx DOCX document
Attachment 0015 - Subcontractor Cost Information Submission 07OCT2020.docx DOCX document
Attachment 0011 - Contract References Spreadsheet 07OCT2020.xlsx XLSX spreadsheet
Attachment 0009 - Fort Riley Purchasing Invoicing Guide 07OCT2020.pdf PDF
Attachment 0001 Fort Riley PWS.pdf PDF
Annex B Supply PRS.docx DOCX document
Annex C Transportation PRS.docx DOCX document
Annex D Environmental Requirements.docx DOCX document
Attachment 0010 - Blocked File Extensions 07OCT2020.pdf PDF
Attachment 0007 - DOL Wage Determination 30JUN2020.pdf PDF
Attachment 0004 - Letter of Consent 07OCT2020.docx DOCX document
Annex E Definitions Acronyms Abbreviations.docx DOCX document
Appendix C - Tactical SSA.DOCX DOCX document
Appendix E - All Army Excess.docx DOCX document
Annex F Publications and Forms Update 7-15.docx DOCX document
Attachment 0003 - Performance Questionnaire 07OCT2020.docx DOCX document
Attachment 0002 - Staffing and Labor Mix 12NOV2020.xlsx XLSX spreadsheet
W52P1J-20-R-0050 - issued 4 March 2021.pdf PDF
Show all 33

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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cost_Price_Abstract_Tab_1a

Fort Riley, Kansas
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

FFP Transition In 0001 $0 0 0 0 0 $0

CPFFInstallation Maintenance Division (IMD)0002$0$0$0$0$0$0
Maintenance Support - Labor$0$0$0$0$0
Maintenance Support - Fee$0$0$0$0$0
CPFFInstallation Supply Division (ISD)0003$0$0$0$0$0$0
Supply Support - Labor$0$0$0$0$0
Supply Support - Fee$0$0$0$0$0
CPFFInstallation Transportation Division (ITD)0004$0$0$0$0$0$0
Transportation Support - Labor$0$0$0$0$0
Transportation Support - Fee$0$0$0$0$0

FFP Project Management Office (PMO) 0006 $0 $0 $0 $0 $0 $0

Subtotal - Proposed Labor / Fee$0$0$0$0$0$0
** COMPLIANCE WARNING ** If CELL I21 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1a) does not equal CELL F9 (Total Proposed Labor/Fee on Teaming Matrix Tab 2), then per L.5.1.8(a), the Offeror's proposal will be non-compliant.

Cost Other Direct Costs (ODC) 0005 $961,811 $994,026 $1,023,847 $1,054,563 $1,086,199 $5,120,446

NSPContractor Manpower Reporting Requirement0007
NSPContract Data item list (CDRLS)0008
Option to Extend Service IAW clause 52.217-8$543,100
Total Proposed Price$961,811$994,026$1,023,847$1,054,563$1,086,199$5,663,546

&D&T &A &F &Z&F

Allocation_Tab_1b

OFFEROR:CAGE CODE:
Fort Riley, Kansas
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

FFP Transition In 0001 $0 $0 $0 $0 $0

CPFFInstallation Maintenance Division (IMD)0002$0$0$0$0$0$0
ASC BASE SUPPORT MAINTENANCE LABOR0002AA
ASC BASE SUPPORT MAINTENANCE FEE0002AA
ASC MAINTENANCE PASSBACK LABOR0002AB
ASC MAINTENANCE PASSBACK FEE0002AB
MAINTENANCE AIDP REIM LABOR0002AC
MAINTENANCE AIDP FEE0002AC
1ID UME REIM LABOR0002AD
1ID UME REIM FEE0002AD
IMD Fee0002EA
IMD Labor0002EA
IMD Fee0002FA
IMD Fee0002FA
IMD Labor0002GA
IMD Fee0002GA
IMD Labor0002HA
IMD Fee0002HA
CPFFInstallation Supply Division (ISD)0003$0$0$0$0$0$0
ASC CENTRAL ISSUE FACILITY LABOR0003AA
ASC CENTRAL ISSUE FACILITY FEE0003AA
ASC SUBSISTENCE SUPPLY MANAGEMENT OFFICE LABOR0003AB
ASC SUBSISTENCE SUPPLY MANAGEMENT OFFICE FEE0003AB
ASC CONSOLIDATED PBO LABOR0003AC
ASC CONSOLIDATED PBO FEE0003AC
ASC INSTALLATION SUPPLY SUPPORT ACTIVITY LABOR0003AD
ASC INSTALLATION SUPPLY SUPPORT ACTIVITY FEE0003AD
ASC HAZARDOUS MATERIAL MANAGEMENT PROGRAM LABOR0003AE
ASC HAZARDOUS MATERIAL MANAGEMENT PROGRAM FEE0003AE
ASC POL OPERATIONS LABOR0003AF
ASC POL OPERATIONS FEE0003AF
ASC AMMUNITION SUPPLY POINT LABOR0003AG
ASC AMMUNITION SUPPLY POINT FEE0003AG
1ID PAAT REIM LABOR0003AH
1ID PAAT REIM FEE0003AH
1ID SLA REIM LABOR0003AJ
1ID SLA REIM FEE0003AJ
1ID MAT REIM LABOR0003AK
1ID MAT REIM FEE0003AK
ASC ALL ARMY EXCESS LABOR0003AL
ASC ALL ARMY EXCESS FEE0003AL
ASC FSE MAINTENANCE LABOR0003AM
ASC FSE MAINTENANCE FEE0003AM
CPFFInstallation Transportation Division (ITD)0004$0$0$0$0$0$0
ASC PERSONAL PROPERTY OPERATIONS LABOR0004AA
ASC PERSONAL PROPERTY OPERATIONS Fee0004AA
ASC TMP LABOR0004AB
ASC TMP FEE0004AB
ASC CARGO MOVEMENTS LABOR0004AC
ASC CARGO MOVEMENTS FEE0004AC
ASC CONTAINER YARD OPERATIONS LABOR0004AD
ASC CONTAINER YARD OPERATIONS FEE0004AD
ITD Labor0004EA
ITD Fee0004EA
ITD Labor0004FA
ITD Fee0004FA
ITD Labor0004GA
ITD Fee0004GA
ITD Labor0004HA
ITD Fee0004HA
FFPProject Management Office (PMO)0006$0
PMO QMNT LABOR0006AAPMO allocation will be applied at AWARD by the Government.
PMO QMNT FEE0006AA
PMO QSUP LABOR0006AB
PMO QSUP FEE0006AB
PMO QTRN LABOR0006AC
PMO QTRN FEE0006AC
PMO AIDP REIMB LABOR0006AD
PMO AIDP REIMB FEE0006AD
PMO 1ID REIM LABOR0006AE
PMO 1ID REIM FEE0006AE
PMO sub Clin0005LA
PMO sub Clin0005MA
PMO sub Clin0005NA
Subtotal - Proposed Labor / Fee$0$0$0$0$0$0
CostOther Direct Costs (ODC)0005$961,811$994,026$1,023,847$1,054,563$1,086,199$5,120,446
ASC BASE SUPPORT MAINTENANCE ODC0005AA$780,000$803,400$827,502$852,327$877,897
ASC INSTALLATION SUPPLY SUPPORT ACTIVITY ODC0005AB$100,000$103,000$106,090$109,273$112,551
MAINTENANCE AIDP REIM ODC0005AC$45,909$47,286$48,705$50,166$51,671
1ID PAAT REIM ODC0005AD$22,487$25,267$26,025$26,806$27,610
1ID SLA REIM ODC0005AE$2,123$2,385$2,457$2,530$2,606
1ID MAT REIM ODC0005AF$11,292$12,688$13,068$13,461$13,864
ODC sub clin0006GA
ODC sub clin0006HA
ODC sub clin0006JA
ODC sub clin0006KA
ODC sub clin0006LA
ODC sub clin0006MA
ODC sub clin0006NA
ODC sub clin0006PA
NSPContractor Manpower Reporting Requirement0007
NSPContract Data item list (CDRLS)0008
Option to Extend Service IAW clause 52.217-8$543,100
Total Proposed Price$961,811$994,026$1,023,847$1,054,563$1,086,199$5,663,546

Teaming_Matrix_Tab_2

Company NameCage CodeRoleFunctional area(s) to performProposed Labor / FeePercentage of participationCost Information Submittal MethodSECRET Facility ClearancePerforming ASP
1BOA HolderPDIRYES
2Subcontractor 1
3Subcontractor 2
4Subcontractor 3
5Subcontractor 4
6Subcontractor 5
7Subcontractor 6
*Total:$0100%
Subtotal-Proposed Labor/Fee from Tab 1a (Cell I21)$0** COMPLIANCE WARNING ** If CELL F9 (Total Proposed Labor/Fee on Teaming Matrix Tab 2) does not equal yellow CELL I21 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1a), then per L.5.1.7(a), the Offeror's proposal will be non-compliant.
(A) Offeror may NOT add or delete rows to accommodate the total number of participants.

(B) Company Name: list the name of the Offeror and all proposed subcontractors.

(C) CAGE Code: list the corresponding CAGE code for the Offeror and all proposed subcontractors. The listed CAGE Code shall remain consistent throughout the Offeror’s entire proposal.

(D) Role: fill in with either: P, S or an O (defined below) for each participant.
P - Offeror (Defaut for BOA Holder)
S - Major Subcontractor performing 20% or more for the total value of the contract.
O - Other Subcontractor performing less than 20% for the total value of the contract.
(E) Offeror to identify which functional area(s) will be performed for each participant as follows:
M - Maintenance
S - Supply
T - Transportation
MS - Maintenance and Supply
ST - Supply and Transportation
MT - Maintenance and Transportation
MST - Maintenance, Supply and Transportation
(F) Proposed Labor / Fee for each participant for the entire Period of Performance (excluding ODCs and the option to extend.)
* Formatting is set to only allow for whole dollars (no cents (i.e. decimals) are allowed)
* The Tab 2 Total in column F is a locked cell with a SUM formula of the values entered in the column F blue cells.
(G) Percentage of participation for each participant for the entire Period of Performance. The total in this column should equal 100%.
* Formatting is set to only allow for whole percentages
(H) Offeror to identify cost information Submittal Method each Subcontractor as follows:
D I R - Subcontractor submitting independently, Default for BOA Holder.
W I O S - Subcontractor submitting cost information within Offeror’s submission
(I) Offeror to identify each participant performing contract requirements which necessitate SECRET facility clearance as follows:
YES - Offeror/Subcontractor will perform contract requirements that necessitiate SECRET facility clearance
NO - Offeror/Subcontractor will NOT perform contract requirements that necessitiate SECRET facility clearance
(J) Offeror to identify which participants will perform critical performance task Ammunition Supply Point (ASP).
YES - Offeror/Subcontractor will perform ASP tasks.
NO - Offeror/Subcontractor will NOT perform ASP tasks.

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