Attachment_0005_-_Cost-Price_Matrix.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
Amendment 04
Solicitation number
W52P1J-16-R-0157
Issued by

About this file

Attachment 0005 Cost-Price Matrix

View the file

Other files

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

Cost_Price_Matrix_Tab_1

OFFEROR:CAGE CODE:
Installation Name
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

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

CPFFInstallation Maintenance Division (IMD)0002$0$0$0$0$0$0
LRC Maint - Labor0002AA
LRC Maint - Fee0002AA
JMTC Support- Labor0002AB
JMTC Support - Fee0002AB
Base Ops Support- Labor0002AC
Base Ops Support - Fee0002AC
CPFFInstallation Supply Division (ISD)0003$0$0$0$0$0$0
LRC Hazmat - Labor0003AA
LRC Hazmat - Fee0003AA
CPFFInstallation Transportation Division (ITD)0004$0$0$0$0$0$0
LRC Transporation Personal Property & Material Movements (307) - Labor0004AA
LRC Transporation Personal Property & Material Movements (307) - Fee0004AA
Transportation Motor Pool (308) - Labor0004AB
Transportation Motor Pool (308) - Fee0004AB
Transportation Motor Pool (Reimbursable) - Labor0004AC
Transportation Motor Pool (Reimbursable) - Fee0004AC
JMTC Support Material Movements (Reimbursable) - Labor0004AD
JMTC Support Material Movements (Reimbursable)- Fee0004AD
Base Ops Support Material Movements (Reimbursable) - Labor- Labor0004AE
Base Ops Support Material Movements (Reimbursable) - Labor- Fee0004AE
Subtotal - Proposed Labor / Fee$0$0$0$0$0$0
** COMPLIANCE WARNING ** If CELL I32 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1) does not equal CELL F12 (Total Proposed Labor/Fee on Teaming Matrix Tab 2), then per L.5.1.8(a), the Offeror's proposal will be non-compliant.
CostOther Direct Costs (ODC)0005$620,300.00$659,100.00$683,600.00$708,800.00$735,100.00$3,406,900.00
Base OPS Maint and Transport Support0005AA$6,400.00$7,100.00$7,500.00$7,500.00$7,800.00
Base Ops Repair Parts0005AB$23,100.00$24,300.00$25,500.00$26,800.00$28,100.00
JMTC Maint and Transport Support0005AC$101,900.00$115,600.00$119,000.00$122,600.00$126,300.00
JMTC Repair Parts0005AD$175,000.00$183,800.00$193,000.00$202,700.00$212,800.00
LRC Hazmat Support0005AE$6,400.00$7,200.00$7,500.00$7,700.00$7,900.00
LRC Maint and Transport Support0005AF$38,600.00$43,800.00$45,100.00$46,500.00$47,900.00
LRC Repair Parts0005AG$18,900.00$19,800.00$20,800.00$21,800.00$22,900.00
JMTC Lease Tractor/Trailer0005AH$250,000.00$257,500.00$265,200.00$273,200.00$281,400.00
NSPContractor Manpower Reporting Requirement0006
NSPContract Data item list (CDRLS)0007
Option to Extend Service IAW clause 52.217-8$367,550
Total Proposed Price$620,300$659,100$683,600$708,800$735,100$3,774,450

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

Teaming_Matrix_Tab_2

Company NameCage CodeRoleFunctional area(s) to performProposed Labor / FeePercentage of participationCost Information Submittal Method
1BOA HolderIND
2Teammate/Subcontractor 1
3Teammate/Subcontractor 2
4Teammate/Subcontractor 3
5Teammate/Subcontractor 4
6Teammate/Subcontractor 5
7Teammate/Subcontractor 6
8Teammate/Subcontractor 7
9Teammate/Subcontractor 8
10Teammate/Subcontractor 9
*Total:$0100%
Subtotal-Proposed Labor/Fee from Tab 1 (Cell I32)$0** COMPLIANCE WARNING ** If CELL F12 (Total Proposed Labor/Fee on Teaming Matrix Tab 2) does not equal CELL F13 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1), then per L.5.1.8(a), the Offeror's proposal will be non-compliaint.
(A) Offeror may NOT add or delete rows to accommodate the total number of participants.

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

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

(D) Role: fill in with either: P, T, S or an O (defined below) for each participant.
P - Offeror
T - Approved Teammate (via BOA Attachment 0002 Team Arrangement)
S - Major Subcontractor (Not on BOA Attachment 0002 Team Arrangement performing 20% or more for thetotal value of the contract.)
O - Other Subcontractor (Not on BOA Attachment 0002 Team Arrangement performing less than 20% for thetotal 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 Teammate/Subcontractor as follows:
I N D - Teammate/Subcontractor submitting independently, Default for BOA Holder.
W I P - Teammate/Subcontractor submitting cost information within Offeror’s submission

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