A0001_RFP_Attachment 4_Pricing Matrix_07Apr2025.xlsx

XLSX spreadsheet 103 KB Posted

Attached to
West Desert Test Center (WDTC) Mission Support Services (MSS) Follow On Solicitation W51EW725RA001 Amendment 0003
Solicitation number
W51EW725RA001
Issued by

About this file

The file is a comprehensive Pricing Matrix spreadsheet for the West Desert Test Center (WDTC) Mission Support Services (MSS) Follow On Solicitation W51EW725RA001. The pricing structure includes multiple Contract Line Item Numbers (CLINs) with a base period of 4 years and 10 months and an option period of 2 years, covering labor, overtime, other direct costs, service contract reporting, and contract data requirements. The matrix provides detailed cost breakdown templates for prime and subcontractor labor categories, with provisions for various roles such as Information Specialists, Word Processors, Technical Specialists, and Program Managers.

The pricing document includes cost calculation mechanisms for different labor categories, with specific attention to productive and non-productive hours, fringe rates, G&A rates, and fixed fee calculations. The matrix accommodates two additional scenarios (Scenario 1 and Scenario 2) and allows for a 6-month extension of services. The Total Evaluated Probable Cost/Price (TEPCP) calculation methodology is outlined, with a note that some pricing elements may be counted for evaluation purposes without impacting the contract's ceiling value. The document is structured to allow offerors to link their own cost breakdown spreadsheets and provide detailed labor rate and cost information for the Department of the Army contract opportunity.

View the file

Other files

File Type Posted
A0003_SF 30_W51EW725RA0010003_22Apr2025.pdf PDF
SF 30_W51EW725RA0010002_18Apr2025.pdf PDF
A0001_TE K_TB 43-180_01Feb2025.pdf PDF
A0001_RFP_Attachment 1_PWS_07Apr2025.pdf PDF
SF30_W51EW725RA0010001.pdf PDF
A0001_TE A_GFP_26Mar2025.xlsx XLSX spreadsheet
A0001_RFP_Attachment 2_PPQ_17Mar2025.docx DOCX document
A0001_RFP_Attachment 8_Scenario 2_SPD CWO_07Apr2025.pdf PDF
A0001_RFP_Attachment 5_Historical Hours_25Mar2025.xlsx XLSX spreadsheet
W51EW725RA001_QandA_07Apr2025_Posted_FINAL.xlsx XLSX spreadsheet
W51EW725RA001_QandA_07Apr2025_Posted_FINAL.xlsx XLSX spreadsheet
W51EW725RA001_QandA_02Apr2025_Posted.xlsx XLSX spreadsheet
W51EW725RA001_QandA_01Apr2025_Posted.xlsx XLSX spreadsheet
W51EW725RA001_QandA_28Mar2025_Posted.xlsx XLSX spreadsheet
W51EW725RA001_QandA_27Mar2025_Posted.xlsx XLSX spreadsheet
TE D_DoDD 8140-01_21Feb2025.pdf PDF
TE I_MIL-STD-810_21Feb2025.pdf PDF
TE C_DoDI 5230.24_21Feb2025.pdf PDF
TE F_DoD 5220.22-M_21Feb2025.pdf PDF
TE A_GFP_19Feb2025.xlsx XLSX spreadsheet
TE G_DoDD 5105.21v1-3_21Feb2025.pdf PDF
TE J_PRS_21Feb2025.pdf PDF
RFP_Attachment 5_Historical Hours_21Feb2025.xlsx XLSX spreadsheet
TE H_DoDD 5205.07_21Feb2025.pdf PDF
RFP_Attachment 2_PPQ_17Mar2025.pdf PDF
Solicitation - W51EW725RA001.pdf PDF
RFP_Attachment 1_PWS_20Feb2025.pdf PDF
TE B_DD254_COR signed 11Sep2024.pdf PDF
RFP_Attachment 4_Pricing Matrix_21Feb2025.xlsx XLSX spreadsheet
RFP_Attachment 8_Scenario 2_SPD CWO_20Feb2025.pdf PDF
RFP_Attachment 7_Scenario 1_Chem Test CWO_20Feb2025.pdf PDF
TE E_DoD 8570.01M_21Feb2025.pdf PDF
RFP_Attachment 6_DD1423_CDRLs.pdf PDF
RFP_Attachment 3_WD 2015-5489_23Dec2024.pdf PDF
Show all 34

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

TEPCP

Total Evaluated Probable Cost/Price
CLINType
CLINCLIN DescriptionPhase-InBase Period CostBase Period FeeBase Period TotalOption Period
CostOption Period
FeeOption Period
TotalTotal Proposed Price
X001CPFFLabor - Base Period (4 years 10 months), Option Period (2 years)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002CPFFOvertime - Base Period (4 years 10 months), Option Period (2 years)
Material Handling and/or G&A Rate
X003CROther Direct Costs
X004NSPService Contract Reporting
X005FFPContract Data Requirements List - CDRLs
X006FFPPhase-In
Sub Total$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
FAR 52.217-8 Option to Extend Services (J11)
Scenario 1 (G12)
Scenario 2 (G13)

Grand Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Notes:
IAW M.5.4.4.6, the sum of all the CLINs’ evaluated price (Base and Options) plus the evaluated price for the “6-Month Extension of Services” plus the evaluated price of Scenarios 1 and 2* represents the TEPC/P.

*The Government acknowledges calculating Scenario pricing into the TEPC/P effectively “double counts” this scope of work already incorporated as a portion of the total CLIN 0001 costs, however, the TEPC/P does not impact the ceiling value established under the proposed IDIQ contract and is done for evaluation purposes only.

For CLINs X001, the Total Proposed Price Tab should auto-populate based on the total proposed price under the Base and Option Period Tabs.

The Not to Exceed (NTE) amounts have been provided for CLINs 0003 and 1003; do not adjust these amounts. If a Material Handling or G&A rate will be applied to the CR CLINs, then include the percentage rate in Cell(s) E4 & H4. Include 0% if no indirect rate will be applied. The rate will become part of the contract and will not be adjusted during the life of the Task Order.

Include your proposed amount for the Phase-In CLIN (0006) in Cell D09
a. CLIN 0003: $18,069,267
b. CLIN 1003: $8,460,213

Total Proposed Price

CLINType
CLINCLIN DescriptionPhase-InBase Period CostBase Period FeeBase Period TotalOption Period
CostOption Period
FeeOption Period
TotalTotal Proposed Price
X001CPFFLabor - Base Period (4 years 10 months) - Option Period (2 years)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
X002CPFFOvertime - Base Period (4 years 10 months) - Option Period (2 years)
Material Handling and/or G&A Rate
X003CROther Direct Costs
X004NSPService Contract Reporting
X005FFPContract Data Requirements List - CDRLs
X006FFPPhase-In
Sub Total$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Grand Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Notes:
For CLINs X001, the Total Proposed Price Tab should auto-populate based on the total proposed price under the Base and Option Period Tabs.

The Not to Exceed (NTE) amounts have been provided for CLINs 0003 and 1003; do not adjust these amounts. If a Material Handling or G&A rate will be applied to the CR CLINs, then include the percentage rate in Cell(s) E4 & H4. Include 0% if no indirect rate will be applied. The rate will become part of the contract and will not be adjusted during the life of the Task Order.

Include your proposed amount for the Phase-In CLIN (0006) in Cell D08
a. CLIN 0003: $18,069,267
b. CLIN 1003: $8,460,213

For note purposes...

Base

Base
CLIN
0001DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularSenior Test Manager - CTDThe amounts included in this Matrix should not be hard input, but should
Senior Test Manager - SPDbe linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist IIExemptPrime19,880.0$34.66$35.35$342,440.80$6,817.20$349,258.00This is an example to use when the contract between the Prime and Subcontractor
Project Scientist IIISub0.0$0.00$0.00$0.00$0.00$0.00will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Chemist Imany of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Chemist IIshall submit a separate spreadsheet with the labor rates and fringes proposed and the
Assistant Scientist Ibasis for these rates.
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs eachThis is an example to use when the contract between the Prime and Subcontractor
Junior Project Manager - CTDwill be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Junior Project Manager - SPDshall submit a separate cost proposal with the same level of information that is
Contractor Support Specialistrequired from the Prime for subcontracts over $5,000,000. For subcontracts under
Clerk - BTD$5,000,000, the Subcontractor shall submit a separate spreadsheet with the labor rates
Clerk - CTDand fringes proposed and the basis for these rates to evaluate IAW FAR 52.222-46.
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - Regular Time19,880.0$342,440.80$6,817.20$349,258.00
CLIN
0002DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFF
OvertimeSenior Test Manager - CTD
Senior Test Manager - SPD
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist II
Project Scientist III
Chemist I
Chemist II
Assistant Scientist I
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs each
Junior Project Manager - CTD
Junior Project Manager - SPD
Contractor Support Specialist
Clerk - BTD
Clerk - CTD
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - OverTime00.0$0.00$0.00$0.00
Grand Total19,880.0$342,440.80$6,817.20$349,258.00
Notes:
Under Column D, the Offeror is to include the name or initials of the company that is performing that labor category; do not just include the words Prime or Sub.

It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct

Option

Option
CLIN
1001DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularSenior Test Manager - CTDThe amounts included in this Matrix should not be hard input, but should
Senior Test Manager - SPDbe linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist IIExemptPrime19,880.0$34.66$35.35$342,440.80$6,817.20$349,258.00This is an example to use when the contract between the Prime and Subcontractor
Project Scientist IIISub00.0$0.00$0.00$0.00$0.00$0.00will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Chemist Imany of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Chemist IIshall submit a separate spreadsheet with the labor rates and fringes proposed and the
Assistant Scientist Ibasis for these rates.
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs eachThis is an example to use when the contract between the Prime and Subcontractor
Junior Project Manager - CTDwill be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Junior Project Manager - SPDshall submit a separate cost proposal with the same level of information that is
Contractor Support Specialistrequired from the Prime for subcontracts over $5,000,000. For subcontracts under
Clerk - BTD$5,000,000, the Subcontractor shall submit a separate spreadsheet with the labor rates
Clerk - CTDand fringes proposed and the basis for these rates to evaluate IAW FAR 52.222-46.
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - Regular Time19,880.0$342,440.80$6,817.20$349,258.00
CLIN
1002DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFF
OvertimeSenior Test Manager - CTDExempt
Senior Test Manager - SPD
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist II
Project Scientist III
Chemist I
Chemist II
Assistant Scientist I
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs each
Junior Project Manager - CTD
Junior Project Manager - SPD
Contractor Support Specialist
Clerk - BTD
Clerk - CTD
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - OverTime00.0$0.00$0.00$0.00
Grand Total19,880.0$342,440.80$6,817.20$349,258.00
Notes:
Under Column D, the Offeror is to include the name or initials of the company that is performing that labor category; do not just include the words Prime or Sub.

It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct e.g. - Prime Costs

Base YearAvailable WorkDaysHours
POP23 December 2025 - 22 October 2030126010080
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
000143%4%$1.002%
01113Information Specialist II1.0010,080.00216.009,864.00$17.38$7.47$24.85$0.99$25.84$1.00$26.84$0.54$27.38$264,749.76$5,326.56$270,076.32
01612Word Processor II1.0010,080.00216.009,864.00$18.14$7.80$25.94$1.04$26.98$1.00$27.98$0.56$28.54$275,994.72$5,523.84$281,518.56
20,160.00432.0019,728.00$540,744.48$10,850.40$551,594.88
BaseAvailable WorkDaysHoursExemptNon-Exempt
POP23 December 2025 - 22 October 2030126010080Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
000243%4%$0.002%
01113Information Specialist II1.0010,080.00224.009,856.00$17.38$7.47$24.85$0.99$25.84$0.00$25.84$0.52$26.36$254,679.04$5,125.12$259,804.16
01612Word Processor II1.0010,080.00224.009,856.00$18.14$7.80$25.94$1.04$26.98$0.00$26.98$0.54$27.52$265,914.88$5,322.24$271,237.12
20,160.00448.0019,712.00$520,593.92$10,447.36$531,041.28
OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
100143%4%$0.002%
01113Information Specialist II1.004,184.00224.003,960.00$17.38$7.47$24.85$0.99$25.84$0.00$25.84$0.52$26.36$102,326.40$2,059.20$104,385.60
01612Word Processor II1.004,184.00224.003,960.00$18.14$7.80$25.94$1.04$26.98$0.00$26.98$0.54$27.52$106,840.80$2,138.40$108,979.20
8,368.00448.007,920.00$209,167.20$4,197.60$213,364.80
OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
100243%4%$0.002%
01113Information Specialist II1.004,184.00224.003,960.00$17.38$7.47$24.85$0.99$25.84$0.00$25.84$0.52$26.36$102,326.40$2,059.20$104,385.60
01612Word Processor II1.004,184.00224.003,960.00$18.14$7.80$25.94$1.04$26.98$0.00$26.98$0.54$27.52$106,840.80$2,138.40$108,979.20
8,368.00448.007,920.00$209,167.20$4,197.60$213,364.80
Notes:
This is only an example; the Offeror should propose in accordance with their accounting system. This example is only to demonstrate how to link the Offeror's Cost Breakdown spreadsheets to the Phase In, Base and Option Tabs
The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19
It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct
The Offeror shall provide unit prices (FBLRs Without Fee and With Fee) that when multiplied by the quantity (Hours) equal an extended price that does not require rounding beyond a whole penny/cent. See Example above.

If proposing uncompensated overtime, the adjusted labor hourly rate shall be applied to all proposed hours (regular and overtime), in accordance with FAR 52.237.10 e.g. - Subk Costs CPFF

BaseAvailable WorkDaysHours
POP23 December 2025 - 22 October 2030126010080
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR Without FeeSubcontractor FeeSubcontractor FBLR With FeePrime G&ASubtotalPMO RateSubtotalPrime FeePrime FBLR With FeePrime FBLR Without FeeTotal CostTotal FeeTotal Amount
00015.00%2.00%$1.002.00%
ExemptTechnical Specialist I4.0040,320.00800.0039,520.00$41.00$2.05$43.05$0.86$43.91$1.00$44.91$0.90$45.81$42.86$1,693,827.20$116,584.00$1,810,411.20

4.00 40,320.00 800.00 39,520.00 $1,693,827.20 $116,584.00 $1,810,411.20

BaseAvailable WorkDaysHoursExemptNon-Exempt
POP23 December 2025 - 22 October 2030126010080Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR Without FeeSubcontractor FeeSubcontractor FBLR With FeePrime G&ASubtotalPMO RateSubtotalPrime FeePrime FBLR With FeePrime FBLR Without FeeTotal CostTotal FeeTotal Amount
00025.00%2.00%$0.002.00%
ExemptTechnical Specialist I4.0040,320.00832.0039,488.00$42.23$2.11$44.34$0.89$45.23$0.00$45.23$0.90$46.13$43.12$1,702,722.56$118,858.88$1,821,581.44

4.00 40,320.00 832.00 39,488.00 $1,702,722.56 $118,858.88 $1,821,581.44

OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR Without FeeSubcontractor FeeSubcontractor FBLR With FeePrime G&ASubtotalPMO RateSubtotalPrime FeePrime FBLR With FeePrime FBLR Without FeeTotal CostTotal FeeTotal Amount
10015.00%2.00%$0.002.00%
ExemptTechnical Specialist I4.0016,736.00832.0015,904.00$43.50$2.18$45.68$0.91$46.59$0.00$46.59$0.93$47.52$44.41$706,296.64$49,461.44$755,758.08

4.00 16,736.00 832.00 15,904.00 $706,296.64 $49,461.44 $755,758.08

OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR Without FeeSubcontractor FeeSubcontractor FBLR With FeePrime G&ASubtotalPMO RateSubtotalPrime FeePrime FBLR With FeePrime FBLR Without FeeTotal CostTotal FeeTotal Amount
10025.00%2.00%$0.002.00%
ExemptTechnical Specialist I4.0016,736.00832.0015,904.00$44.81$2.24$47.05$0.94$47.99$0.00$47.99$0.96$48.95$45.75$727,608.00$50,892.80$778,500.80
4.0016,736.00832.0015,904.00$727,608.00$50,892.80$778,500.80
Notes:
This is only an example; the Offeror should propose in accordance with their accounting system. This example is only to demonstrate how to link the Offeror's Cost Breakdown spreadsheets to the Phase In, Base and Option Tabs
The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19
It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct
The Offeror shall provide unit prices (FBLRs Without Fee and With Fee) that when multiplied by the quantity (Hours) equal an extended price that does not require rounding beyond a whole penny/cent. See Example above.

If proposing uncompensated overtime, the adjusted labor hourly rate shall be applied to all proposed hours (regular and overtime), in accordance with FAR 52.237.10 e.g. Subk Costs -T&M or LH

BaseAvailable WorkDaysHours
POP23 December 2025 - 22 October 2030126010080
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
00012.00%$1.002.00%
ExemptOperations Specialist I1.0010,080.00200.009,880.00$33.00$0.66$33.66$1.00$34.66$0.69$35.35$342,440.80$6,817.20$349,258.00

1.00 10,080.00 200.00 9,880.00 $342,440.80 $6,817.20 $349,258.00

BaseAvailable WorkDaysHoursExemptNon-Exempt
POP23 December 2025 - 22 October 2030126010080Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
00022.00%$0.002.00%
ExemptOperations Specialist I1.0010,080.00208.009,872.00$33.99$0.68$34.67$0.00$34.67$0.69$35.36$342,262.24$6,811.68$349,073.92

1.00 10,080.00 208.00 9,872.00 $342,262.24 $6,811.68 $349,073.92

OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
10012.00%$0.002.00%
ExemptOperations Specialist I1.004,184.00208.003,976.00$35.01$0.70$35.71$0.00$35.71$0.71$36.42$141,982.96$2,822.96$144,805.92

1.00 4,184.00 208.00 3,976.00 $141,982.96 $2,822.96 $144,805.92

OptionAvailable WorkDaysHoursExemptNon-Exempt
POP23 October 2030 - 22 October 20325234184Escalation3%0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
10022.00%$0.002.00%
ExemptOperations Specialist I1.004,184.00208.003,976.00$36.06$0.72$36.78$0.00$36.78$0.74$37.52$146,237.28$2,942.24$149,179.52
1.004,184.00208.003,976.00$146,237.28$2,942.24$149,179.52
This is only an example; the Offeror should propose in accordance with their accounting system. This example is only to demonstrate how to link the Offeror's Cost Breakdown spreadsheets to the Phase In, Base and Option Tabs
The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19
It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct
The Offeror shall provide unit prices (FBLRs Without Fee and With Fee) that when multiplied by the quantity (Hours) equal an extended price that does not require rounding beyond a whole penny/cent. See Example above.
If proposing uncompensated overtime, the adjusted labor hourly rate shall be applied to all proposed hours (regular and overtime), in accordance with FAR 52.237.10

PMO Rate

BaseAvailable WorkDaysHours
POP23 December 2025 - 22 October 203012601960
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
000110%10%
Program Manager11,9602401,720$150.00$15.00$165.00$16.50$181.50$312,180.00
Senior Business Manager
Quality Control Manager
Facility Security Officer (FSO)
Project Manager (CTD Only)
Project Manager (SPD Only)
Security Custodian/Assistant Special Security Officer (SPD)
Safety Officer
Contract Finance Manager
HR Specialist
Contract Manager

1 1,960 240 1,720 $312,180.00

BaseAvailable WorkDaysHours
POP23 December 2025 - 22 October 203012601,960Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
000210%10%
Program Manager11,960101,950$10.00$1.00$11.00$1.10$12.10$23,595.00
Senior Business Manager
Quality Control Manager
Facility Security Officer (FSO)
Project Manager (CTD Only)
Project Manager (SPD Only)
Security Custodian/Assistant Special Security Officer (SPD)
Safety Officer
Contract Finance Manager
HR Specialist
Contract Manager

1 1,960 10 1,950.00 $23,595.00

OptionAvailable WorkDaysHours
POP23 October 2030 - 22 October 20325231960Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
100110%10%
Program Manager11,960101,950$10.00$1.00$11.00$1.10$12.10$23,595.00
Senior Business Manager
Quality Control Manager
Facility Security Officer (FSO)
Project Manager (CTD Only)
Project Manager (SPD Only)
Security Custodian/Assistant Special Security Officer (SPD)
Safety Officer
Contract Finance Manager
HR Specialist
Contract Manager

1 1,960 10 1,950.00 $23,595.00

OptionAvailable WorkDaysHours
POP23 October 2030 - 22 October 20325231960Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
100210%10%
Program Manager11,960101,950$10.00$1.00$11.00$1.10$12.10$23,595.00
Senior Business Manager
Quality Control Manager
Facility Security Officer (FSO)
Project Manager (CTD Only)
Project Manager (SPD Only)
Security Custodian/Assistant Special Security Officer (SPD)
Safety Officer
Contract Finance Manager
HR Specialist
Contract Manager

1 1,960 10 1,950.00 $23,595.00

PMO RateBase CLIN 0001Base CLIN 0001Option CLIN 1001Option CLIN 1002
Total PMO Amount$312,180.00$23,595.00$23,595.00$23,595.00
Base - Direct Labor Hours9,880.00
PMO Amount / Labor Hour$1.00
Notes:
The Available Work Days and Hours are based on the Period of Performance included in Cells B2, B34, B66
It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct

Scenario 1

Scenario 1DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularSenior Test Manager - CTDThe amounts included in this Matrix should not be hard input, but should
Senior Test Manager - SPDbe linked to the Offeror's cost breakdown spreadsheet;
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist IIExemptPrime19,880.0$34.66$35.35$342,440.80$6,817.20$349,258.00This is an example to use when the contract between the Prime and Subcontractor
Project Scientist IIISub0.0$0.00$0.00$0.00$0.00$0.00will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Chemist Imany of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Chemist IIshall submit a separate spreadsheet with the labor rates and fringes proposed and the
Assistant Scientist Ibasis for these rates.
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs eachThis is an example to use when the contract between the Prime and Subcontractor
Junior Project Manager - CTDwill be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Junior Project Manager - SPDshall submit a separate cost proposal with the same level of information that is
Contractor Support Specialistrequired from the Prime for subcontracts over $5,000,000. For subcontracts under
Clerk - BTD$5,000,000, the Subcontractor shall submit a separate spreadsheet with the labor rates
Clerk - CTDand fringes proposed and the basis for these rates to evaluate IAW FAR 52.222-46.
Clerk - DMD
Clerk - METNOTES:
Clerk - SPD
Clerk - TSDOfferors shall delete/add labor categories as deemed appropriate to support requirements
Property Clerk - BTDof Scenario 1. See L.3.3.4.1.5
Property Clerk - CTD
Property Clerk - DMDPMO Personnel and hours supporting the Scenario shall be proposed/identified, as
Property Clerk - METapplicable, however, the PMO rates are excluded from the Scenario 1 TEPC/P calculation.
Property Clerk - OPSSee L.3.3.4.5.1 and M.5.4.4.5.
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - Regular Time19,880.0$342,440.80$6,817.20$349,258.00
Scenario 1DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFF
OvertimeSenior Test Manager - CTD
Senior Test Manager - SPD
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist II
Project Scientist III
Chemist I
Chemist II
Assistant Scientist I
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs each
Junior Project Manager - CTD
Junior Project Manager - SPD
Contractor Support Specialist
Clerk - BTD
Clerk - CTD
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - OverTime00.0$0.00$0.00$0.00
Grand Total19,880.0$342,440.80$6,817.20$349,258.00
Notes:
Under Column D, the Offeror is to include the name or initials of the company that is performing that labor category; do not just include the words Prime or Sub.

It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct

Scenario 2

Scenario 2DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularSenior Test Manager - CTDThe amounts included in this Matrix should not be hard input, but should
Senior Test Manager - SPDbe linked to the Offeror's cost breakdown spreadsheet;
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist IIExemptPrime19,880.0$34.66$35.35$342,440.80$6,817.20$349,258.00This is an example to use when the contract between the Prime and Subcontractor
Project Scientist IIISub0.0$0.00$0.00$0.00$0.00$0.00will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Chemist Imany of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Chemist IIshall submit a separate spreadsheet with the labor rates and fringes proposed and the
Assistant Scientist Ibasis for these rates.
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs eachThis is an example to use when the contract between the Prime and Subcontractor
Junior Project Manager - CTDwill be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Junior Project Manager - SPDshall submit a separate cost proposal with the same level of information that is
Contractor Support Specialistrequired from the Prime for subcontracts over $5,000,000. For subcontracts under
Clerk - BTD$5,000,000, the Subcontractor shall submit a separate spreadsheet with the labor rates
Clerk - CTDand fringes proposed and the basis for these rates to evaluate IAW FAR 52.222-46.
Clerk - DMD
Clerk - METNOTES:
Clerk - SPD
Clerk - TSDOfferors shall delete/add labor categories as deemed appropriate to support requirements
Property Clerk - BTDof Scenario 2. See L.3.3.4.1.5
Property Clerk - CTD
Property Clerk - DMDPMO Personnel and hours supporting the Scenario shall be proposed/identified, as
Property Clerk - METapplicable, however, the PMO rates are excluded from the Scenario 2 TEPC/P calculation.
Property Clerk - OPSSee L.3.3.4.5.1 and M.5.4.4.5.
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - Regular Time19,880.0$342,440.80$6,817.20$349,258.00
CLIN
0002DescriptionWDPrime / SubFTEsMonths - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFF
OvertimeSenior Test Manager - CTD
Senior Test Manager - SPD
Senior Test Manager - TSD
Test Manager - Field
Test Manager - SPD
Spectrum Manager
Computer Programmer - DMD
Project Scientist I
Project Scientist II
Project Scientist III
Chemist I
Chemist II
Assistant Scientist I
Assistant Scientist II
Associate Scientist I
Associate Scientist II
Senior Scientist - BTD
Senior Scientist - SPD - INTERMITTENT - 240 Hrs each
Junior Project Manager - CTD
Junior Project Manager - SPD
Contractor Support Specialist
Clerk - BTD
Clerk - CTD
Clerk - DMD
Clerk - MET
Clerk - SPD
Clerk - TSD
Property Clerk - BTD
Property Clerk - CTD
Property Clerk - DMD
Property Clerk - MET
Property Clerk - OPS
Property Clerk - Overall
Property Clerk - SPD
Property Clerk - TSD
Supply Technician
HVAC Mechanic - Overall
Welder - Overall
Electrician - TSD
Senior Electronic Technician - CTD
Senior Electronic Technician - MET
Senior Electronic Technician - TSD
Electronic Technician - Overall
Master Mechanical Technician
Senior Mechanical Technician - CTD
Senior Mechanical Technician - SPD
Senior Mechanical Technician - TSD
Mechanical Technician - Overall
Mechanical Technician - SPD
Range Controllers
Drafter - TSD
GIS Technician - OPS
Explosive Handler - SPD - INTERMITTENT - 240 Hrs each
Photographer - TSD
Photographer (Scientific and Technical)
Audio Visual Specialist - TSD
Heavy Duty Equipment Operator - Overall
Heavy Duty Equipment Operator - TSD
POL/Hazardous Waste Technician - OPS
Flight Operations/Aviation Technician - OPS
Field Technician - Overall
Laboratory Technician I - CTD
Laboratory Technician II - CTD
Laboratory Technician III - CTD
Laboratory Analyst I - CTD
Laboratory Analyst II - CTD
Air Monitoring Technician
Air Monitoring Operator (Safety)
Training Coordinator I
Training Coordinator II
Training Coordinator I - INTERMITTENT - 240 Hrs each
SubTotal - OverTime00.0$0.00$0.00$0.00
Grand Total19,880.0$342,440.80$6,817.20$349,258.00
Notes:
Under Column D, the Offeror is to include the name or initials of the company that is performing that labor category; do not just include the words Prime or Sub.

It is the Offeror's responsibility to ensure that any formulas included in this spreadsheet are correct

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