11. RFP-L_Attachment 2_Pricing Matrix.xlsx

XLSX spreadsheet 169 KB Posted

Attached to
Test Engineering and Analysis Services (TEAS) DRAFT RFP Federal contract opportunity
Solicitation number
W91151-24-R-0030
Issued by
Department of the Army

About this file

This document is an attachment to a Request for Proposal (RFP) for Test Engineering and Analysis Services (TEAS). The attachment is a pricing matrix that provides a format for offerors to submit pricing for the contract including base and option years. Key details include:

The contract will be a Combination Contract with Cost-Plus-Fixed-Fee (CPFF) and Completion Fixed-Price Contract Line Items (CLINs). The CPFF CLIN is for test engineering and analysis services, and the Completion Fixed-Price CLINs are for Contract Data Requirements List (CDRLs) and Manpower Reporting. There is also a CLIN for travel and materials with a Not to Exceed amount. The Period of Performance spans 5 base and option years as well as a 6-month extension. The pricing matrix provides detailed labor categories, hours, and fully burdened labor rates for both prime and subcontractor personnel. Offerors are instructed to complete the pricing matrix and link it to their detailed cost proposal.

View the file

Other files for this federal contract opportunity

Show all 14

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

Total Proposed Price

CLINCLIN TypeCLIN DescriptionPhase-InBase Year CostBase Year FeeBase Year TotalOption 1 CostOption 1 FeeOption 1 TotalOption 2 CostOption 2 FeeOption 2 TotalOption 3 CostOption 3 FeeOption 3 TotalOption 4 CostOption 4 FeeOption 4 Total6-Mo Ext of Svcs Cost6-Mo Ext of Svcs Fee6-Mo Ext of Svcs TotalTotal Proposed Price
X001CPFFTest Engineering and Analysis Services$696,560.96$32,449.60$729,010.56$780,762.64$36,321.12$817,083.76$804,149.28$37,466.96$841,616.24$831,838.40$38,739.20$870,577.60$853,135.84$39,758.16$892,894.00$426,567.92$19,879.08$446,447.00$4,597,629.16
X002CRTravel and Materials$1,507,180.00$0.00$1,507,180.00$1,582,539.00$0.00$1,582,539.00$1,661,666.00$0.00$1,661,666.00$1,744,749.00$0.00$1,744,749.00$1,831,987.00$0.00$1,831,987.00$915,993.50$0.00$915,993.50$9,244,114.50
Material Handling and/or G&A Rate
X003FFPCDRLS$0.00$0.00
X004FFPManpower Reporting$0.00$0.00
0005FFPPhase-In$0.00
Grand Total$2,203,740.96$32,449.60$2,236,190.56$2,363,301.64$36,321.12$2,399,622.76$2,465,815.28$37,466.96$2,503,282.24$2,576,587.40$38,739.20$2,615,326.60$2,685,122.84$39,758.16$2,724,881.00$1,342,561.42$19,879.08$1,362,440.50$13,841,743.66
New Mexico Gross Recipts Tax (NMGRT) Rate6.50%6.50%6.50%6.50%6.50%6.50%
NMGRT Amount$145,352.39$155,975.48$162,713.35$169,996.23$177,117.27$88,558.63$899,713.35
Grand Total$2,381,542.95$2,555,598.24$2,665,995.59$2,785,322.83$2,901,998.27$1,450,999.13$14,741,457.01
Notes:
For CLINs X001, the Total Proposed Price Tab will auto-populate based on the total proposed price under the Base and Option Year Tabs.

The Not to Exceed (NTE) amounts have been provided for CLINs X002 (Travel & Materials); 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, K4, N4 and/or Q4. 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 CLINs X003 and X004 in Columns G, J, M, P, and S, rows 5 and 6 respectively.

Include your proposed amount for the Phase-In CLIN (0005) in Cell D7

Base

CLIN 0001DescriptionWDPrime / SubFTEs11 Month - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularEngineer IIIAExempt$0.00The amounts included in this Matrix should not be hard input, but should
Engineer IIIBExempt$0.00be linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExemptSub1.001728.00$33.66$34.33$58,164.48$1,157.76$59,322.24This is an example to use when the contract between the Prime and Subcontractor
Operations Specialist IIExemptSub1.001728.00$40.80$41.62$70,502.40$1,416.96$71,919.36will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Patriot Info Leader IIExempt$0.00many of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Program Analyst IIExempt$0.00shall submit a separate spreadsheet with the labor rates and fringes proposed and the
Program Analyst IIIExempt$0.00basis for these rates.
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExemptSub4.006,912.00$41.86$44.79$289,336.32$20,252.16$309,588.48This is an example to use when the contract between the Prime and Subcontractor
Technical Specialist IIExemptSub1.001,728.00$46.97$50.26$81,164.16$5,685.12$86,849.28will be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Technical Specialist IIIExempt$0.00shall submit a separate cost proposal with the same level of information that is
Test Support Analyst IExempt$0.00required from the Prime
Test Support Analyst IIIExempt$0.00
Information Specialist II01113Prime1.001,712.00$59.56$60.75$101,966.72$2,037.28$104,004.00
Word Processor II01612Prime1.001,712.00$55.74$56.85$95,426.88$1,900.32$97,327.20
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total9.0015,520.00$696,560.96$32,449.60$729,010.56
OvertimeEngineer IIIAExempt$0.00
Engineer IIIBExempt$0.00
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExempt$0.00
Operations Specialist IIExempt$0.00
Patriot Info Leader IIExempt$0.00
Program Analyst IIExempt$0.00
Program Analyst IIIExempt$0.00
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExempt$0.00
Technical Specialist IIExempt$0.00
Technical Specialist IIIExempt$0.00
Test Support Analyst IExempt$0.00
Test Support Analyst IIIExempt$0.00
Information Specialist II01113$0.00
Word Processor II01612$0.00
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total0.000.00$0.00$0.00$0.00
Grand Total9.0015,520.00$696,560.96$32,449.60$729,010.56
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

Opt 1

CLIN 1001DescriptionWDPrime / SubFTEs12 Month - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularEngineer IIIAExempt$0.00The amounts included in this Matrix should not be hard input, but should
Engineer IIIBExempt$0.00be linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExemptSub1.001880.00$34.67$35.36$65,179.60$1,297.20$66,476.80This is an example to use when the contract between the Prime and Subcontractor
Operations Specialist IIExemptSub1.001880.00$42.02$42.86$78,997.60$1,579.20$80,576.80will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Patriot Info Leader IIExempt$0.00many of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Program Analyst IIExempt$0.00shall submit a separate spreadsheet with the labor rates and fringes proposed and the
Program Analyst IIIExempt$0.00basis for these rates.
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExemptSub4.007,520.00$43.12$46.13$324,262.40$22,635.20$346,897.60This is an example to use when the contract between the Prime and Subcontractor
Technical Specialist IIExemptSub1.001,880.00$48.38$51.77$90,954.40$6,373.20$97,327.60will be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Technical Specialist IIIExempt$0.00shall submit a separate cost proposal with the same level of information that is
Test Support Analyst IExempt$0.00required from the Prime
Test Support Analyst IIIExempt$0.00
Information Specialist II01113Prime1.001,864.00$61.35$62.58$114,356.40$2,292.72$116,649.12
Word Processor II01612Prime1.001,864.00$57.41$58.56$107,012.24$2,143.60$109,155.84
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total9.0016,888.00$780,762.64$36,321.12$817,083.76
OvertimeEngineer IIIAExempt$0.00
Engineer IIIBExempt$0.00
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExempt$0.00
Operations Specialist IIExempt$0.00
Patriot Info Leader IIExempt$0.00
Program Analyst IIExempt$0.00
Program Analyst IIIExempt$0.00
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExempt$0.00
Technical Specialist IIExempt$0.00
Technical Specialist IIIExempt$0.00
Test Support Analyst IExempt$0.00
Test Support Analyst IIIExempt$0.00
Information Specialist II01113$0.00
Word Processor II01612$0.00
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total0.000.00$0.00$0.00$0.00
Grand Total9.0016,888.00$780,762.64$36,321.12$817,083.76
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

Opt 2

CLIN 2001DescriptionWDPrime / SubFTEs12 Month - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularEngineer IIIAExempt$0.00The amounts included in this Matrix should not be hard input, but should
Engineer IIIBExempt$0.00be linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExemptSub1.001880.00$35.71$36.42$67,134.80$1,334.80$68,469.60This is an example to use when the contract between the Prime and Subcontractor
Operations Specialist IIExemptSub1.001880.00$43.29$44.16$81,385.20$1,635.60$83,020.80will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Patriot Info Leader IIExempt$0.00many of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Program Analyst IIExempt$0.00shall submit a separate spreadsheet with the labor rates and fringes proposed and the
Program Analyst IIIExempt$0.00basis for these rates.
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExemptSub4.007,520.00$44.41$47.52$333,963.20$23,387.20$357,350.40This is an example to use when the contract between the Prime and Subcontractor
Technical Specialist IIExemptSub1.001,880.00$49.82$53.31$93,661.60$6,561.20$100,222.80will be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Technical Specialist IIIExempt$0.00shall submit a separate cost proposal with the same level of information that is
Test Support Analyst IExempt$0.00required from the Prime
Test Support Analyst IIIExempt$0.00
Information Specialist II01113Prime1.001,864.00$63.19$64.45$117,786.16$2,348.64$120,134.80
Word Processor II01612Prime1.001,864.00$59.13$60.31$110,218.32$2,199.52$112,417.84
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total9.0016,888.00$804,149.28$37,466.96$841,616.24
OvertimeEngineer IIIAExempt$0.00
Engineer IIIBExempt$0.00
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExempt$0.00
Operations Specialist IIExempt$0.00
Patriot Info Leader IIExempt$0.00
Program Analyst IIExempt$0.00
Program Analyst IIIExempt$0.00
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExempt$0.00
Technical Specialist IIExempt$0.00
Technical Specialist IIIExempt$0.00
Test Support Analyst IExempt$0.00
Test Support Analyst IIIExempt$0.00
Information Specialist II01113$0.00
Word Processor II01612$0.00
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total0.000.00$0.00$0.00$0.00
Grand Total9.0016,888.00$804,149.28$37,466.96$841,616.24
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

Opt 3

CLIN 3001DescriptionWDPrime / SubFTEs12 Month - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularEngineer IIIAExempt$0.00The amounts included in this Matrix should not be hard input, but should
Engineer IIIBExempt$0.00be linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExemptSub1.001888.00$36.78$37.52$69,440.64$1,397.12$70,837.76This is an example to use when the contract between the Prime and Subcontractor
Operations Specialist IIExemptSub1.001888.00$44.58$45.47$84,167.04$1,680.32$85,847.36will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Patriot Info Leader IIExempt$0.00many of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Program Analyst IIExempt$0.00shall submit a separate spreadsheet with the labor rates and fringes proposed and the
Program Analyst IIIExempt$0.00basis for these rates.
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExemptSub4.007,552.00$45.75$48.95$345,504.00$24,166.40$369,670.40This is an example to use when the contract between the Prime and Subcontractor
Technical Specialist IIExemptSub1.001,888.00$51.32$54.91$96,892.16$6,777.92$103,670.08will be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Technical Specialist IIIExempt$0.00shall submit a separate cost proposal with the same level of information that is
Test Support Analyst IExempt$0.00required from the Prime
Test Support Analyst IIIExempt$0.00
Information Specialist II01113Prime1.001,872.00$65.08$66.38$121,829.76$2,433.60$124,263.36
Word Processor II01612Prime1.001,872.00$60.90$62.12$114,004.80$2,283.84$116,288.64
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total9.0016,960.00$831,838.40$38,739.20$870,577.60
OvertimeEngineer IIIAExempt$0.00
Engineer IIIBExempt$0.00
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExempt$0.00
Operations Specialist IIExempt$0.00
Patriot Info Leader IIExempt$0.00
Program Analyst IIExempt$0.00
Program Analyst IIIExempt$0.00
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExempt$0.00
Technical Specialist IIExempt$0.00
Technical Specialist IIIExempt$0.00
Test Support Analyst IExempt$0.00
Test Support Analyst IIIExempt$0.00
Information Specialist II01113$0.00
Word Processor II01612$0.00
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total0.000.00$0.00$0.00$0.00
Grand Total9.0016,960.00$831,838.40$38,739.20$870,577.60
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

Opt 4

CLIN 4001DescriptionWDPrime / SubFTEs12 Month - Productive HoursFBLR Without FeeFBLR With FeeTotal CostFixed Fee AmountTotal Amount CPFFEXAMPLE FIGURES ONLY!!
RegularEngineer IIIAExempt$0.00The amounts included in this Matrix should not be hard input, but should
Engineer IIIBExempt$0.00be linked to the Offeror's cost breakdown spreadsheet; See Example Tabs
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExemptSub1.001880.00$37.88$38.64$71,214.40$1,428.80$72,643.20This is an example to use when the contract between the Prime and Subcontractor
Operations Specialist IIExemptSub1.001880.00$45.92$46.84$86,329.60$1,729.60$88,059.20will be T&M or LH; See "e.g. - Subk Costs - T&M or LH" Tab. In addition, since
Patriot Info Leader IIExempt$0.00many of the employees are classified as professional (FAR 52.222-46) the Subcontractor
Program Analyst IIExempt$0.00shall submit a separate spreadsheet with the labor rates and fringes proposed and the
Program Analyst IIIExempt$0.00basis for these rates.
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExemptSub4.007,520.00$47.12$50.42$354,342.40$24,816.00$379,158.40This is an example to use when the contract between the Prime and Subcontractor
Technical Specialist IIExemptSub1.001,880.00$52.86$56.56$99,376.80$6,956.00$106,332.80will be CPFF; See "e.g. - Subk Costs CPFF" Tab. In addition, the Subcontractor
Technical Specialist IIIExempt$0.00shall submit a separate cost proposal with the same level of information that is
Test Support Analyst IExempt$0.00required from the Prime
Test Support Analyst IIIExempt$0.00
Information Specialist II01113Prime1.001,864.00$67.03$68.37$124,943.92$2,497.76$127,441.68
Word Processor II01612Prime1.001,864.00$62.73$63.98$116,928.72$2,330.00$119,258.72
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total9.0016,888.00$853,135.84$39,758.16$892,894.00
OvertimeEngineer IIIAExempt$0.00
Engineer IIIBExempt$0.00
Lead Technical Manager IIExempt$0.00
Lead Technical Manager IIIExempt$0.00
Microsoft Administrator IIExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IExempt$0.00
Mobile Flight Mission Simulator - Simulations Analyst IIExempt$0.00
Operations Manager IIExempt$0.00
Operations Specialist IExempt$0.00
Operations Specialist IIExempt$0.00
Patriot Info Leader IIExempt$0.00
Program Analyst IIExempt$0.00
Program Analyst IIIExempt$0.00
Range Scheduler IIExempt$0.00
Scientific Programmer IIIExempt$0.00
Supervisory EditorExempt$0.00
System Analyst IExempt$0.00
System Analyst IIExempt$0.00
System Analyst IIIExempt$0.00
Technical Specialist IExempt$0.00
Technical Specialist IIExempt$0.00
Technical Specialist IIIExempt$0.00
Test Support Analyst IExempt$0.00
Test Support Analyst IIIExempt$0.00
Information Specialist II01113$0.00
Word Processor II01612$0.00
Word Processor III01613$0.00
Data Librarian II13047$0.00
Media Specialist III13063$0.00
Computer Operator I / Data Collector14041$0.00
Instructor II15095$0.00
Access Monitor / Escort I27101$0.00
Access Monitor27101$0.00
Engineering Tech I30081$0.00
Engineering Tech II30082$0.00
Technical Writer I30461$0.00
Technical Writer II30462$0.00
Technical Writer III30463$0.00
Sub Total0.000.00$0.00$0.00$0.00
Grand Total9.0016,888.00$853,135.84$39,758.16$892,894.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
POP1 March 2025 - 31 January 20262411928
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
000143%4%$0.002%
Information Specialist II1.001,928.00216.001,712.00$40.05$17.22$57.27$2.29$59.56$0.00$59.56$1.19$60.75$101,966.72$2,037.28$104,004.00
Word Processor II1.001,928.00216.001,712.00$37.48$16.12$53.60$2.14$55.74$0.00$55.74$1.11$56.85$95,426.88$1,900.32$97,327.20
3,856.00432.003,424.00$197,393.60$3,937.60$201,331.20
Option 1Available WorkDaysHours
POP1 February 2026 - 31 January 20272612088Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
100143%4%$0.002%
Information Specialist II1.002,088.00224.001,864.00$41.25$17.74$58.99$2.36$61.35$0.00$61.35$1.23$62.58$114,356.40$2,292.72$116,649.12
Word Processor II1.002,088.00224.001,864.00$38.60$16.60$55.20$2.21$57.41$0.00$57.41$1.15$58.56$107,012.24$2,143.60$109,155.84
4,176.00448.003,728.00$221,368.64$4,436.32$225,804.96
Option 2Available WorkDaysHours
POP1 February 2027 - 31 January 20282612088Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
200143%4%$0.002%
Information Specialist II1.002,088.00224.001,864.00$42.49$18.27$60.76$2.43$63.19$0.00$63.19$1.26$64.45$117,786.16$2,348.64$120,134.80
Word Processor II1.002,088.00224.001,864.00$39.76$17.10$56.86$2.27$59.13$0.00$59.13$1.18$60.31$110,218.32$2,199.52$112,417.84
4,176.00448.003,728.00$228,004.48$4,548.16$232,552.64
Option 3Available WorkDaysHours
POP1 February 2028 - 31 January 20292622096Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
300143%4%$0.002%
Information Specialist II1.002,096.00224.001,872.00$43.76$18.82$62.58$2.50$65.08$0.00$65.08$1.30$66.38$121,829.76$2,433.60$124,263.36
Word Processor II1.002,096.00224.001,872.00$40.95$17.61$58.56$2.34$60.90$0.00$60.90$1.22$62.12$114,004.80$2,283.84$116,288.64
4,192.00448.003,744.00$235,834.56$4,717.44$240,552.00
Option 4Available WorkDaysHours
POP1 February 2029 - 31 January 20302612088Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&ASubtotalPMO RateFBLR without FeeFeeFBLR with FeeTotal CostTotal FeeTotal Amount
400143%4%$0.002%
Information Specialist II1.002,088.00224.001,864.00$45.07$19.38$64.45$2.58$67.03$0.00$67.03$1.34$68.37$124,943.92$2,497.76$127,441.68
Word Processor II1.002,088.00224.001,864.00$42.18$18.14$60.32$2.41$62.73$0.00$62.73$1.25$63.98$116,928.72$2,330.00$119,258.72
4,176.00448.003,728.00$241,872.64$4,827.76$246,700.40
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 Base and Opt 1 - Opt 4 Tabs

The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19, B27, B35

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.

e.g. - Subk Costs CPFF

Base YearAvailable WorkDaysHours
POP1 March 2025 - 31 January 20262411928
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%$0.002.00%
Technical Specialist I4.007,712.00800.006,912.00$41.00$2.05$43.05$0.86$43.91$0.00$43.91$0.88$44.79$41.86$289,336.32$20,252.16$309,588.48
Technical Specialist II1.001,928.00200.001,728.00$46.00$2.30$48.30$0.97$49.27$0.00$49.27$0.99$50.26$46.97$81,164.16$5,685.12$86,849.28
5.009,640.001,000.008,640.00$370,500.48$25,937.28$396,437.76
Option 1Available WorkDaysHours
POP1 February 2026 - 31 January 20272612088Escalation3%
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%
Technical Specialist I4.008,352.00832.007,520.00$42.23$2.11$44.34$0.89$45.23$0.00$45.23$0.90$46.13$43.12$324,262.40$22,635.20$346,897.60
Technical Specialist II1.002,088.00208.001,880.00$47.38$2.37$49.75$1.00$50.75$0.00$50.75$1.02$51.77$48.38$90,954.40$6,373.20$97,327.60
5.0010,440.001,040.009,400.00$415,216.80$29,008.40$444,225.20
Option 2Available WorkDaysHours
POP1 February 2027 - 31 January 20282612088Escalation3%
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
20015.00%2.00%$0.002.00%
Technical Specialist I4.008,352.00832.007,520.00$43.50$2.18$45.68$0.91$46.59$0.00$46.59$0.93$47.52$44.41$333,963.20$23,387.20$357,350.40
Technical Specialist II1.002,088.00208.001,880.00$48.80$2.44$51.24$1.02$52.26$0.00$52.26$1.05$53.31$49.82$93,661.60$6,561.20$100,222.80
5.0010,440.001,040.009,400.00$427,624.80$29,948.40$457,573.20
Option 3Available WorkDaysHours
POP1 February 2028 - 31 January 20292622096Escalation3%
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
30015.00%2.00%$0.002.00%
Technical Specialist I4.008,384.00832.007,552.00$44.81$2.24$47.05$0.94$47.99$0.00$47.99$0.96$48.95$45.75$345,504.00$24,166.40$369,670.40
Technical Specialist II1.002,096.00208.001,888.00$50.26$2.51$52.77$1.06$53.83$0.00$53.83$1.08$54.91$51.32$96,892.16$6,777.92$103,670.08
5.0010,480.001,040.009,440.00$442,396.16$30,944.32$473,340.48
Option 4Available WorkDaysHours
POP1 February 2029 - 31 January 20302612088Escalation3%
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
40015.00%2.00%$0.002.00%
Technical Specialist I4.008,352.00832.007,520.00$46.15$2.31$48.46$0.97$49.43$0.00$49.43$0.99$50.42$47.12$354,342.40$24,816.00$379,158.40
Technical Specialist II1.002,088.00208.001,880.00$51.77$2.59$54.36$1.09$55.45$0.00$55.45$1.11$56.56$52.86$99,376.80$6,956.00$106,332.80
5.0010,440.001,040.009,400.00$453,719.20$31,772.00$485,491.20
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 Base and Opt 1 - Opt 4 Tabs

This is only an example; the Prime is not required to propose any G&A or Fee on the subcontractor costs.

The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19, B27, B35

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.

e.g. Subk Costs -T&M or LH

Base YearAvailable WorkDaysHours
POP1 March 2025 - 31 January 20262411928
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
00012.00%$0.002.00%
Operations Specialist I1.001,928.00200.001,728.00$33.00$0.66$33.66$0.00$33.66$0.67$34.33$58,164.48$1,157.76$59,322.24
Operations Specialist II1.001,928.00200.001,728.00$40.00$0.80$40.80$0.00$40.80$0.82$41.62$70,502.40$1,416.96$71,919.36
2.003,856.00400.003,456.00$128,666.88$2,574.72$131,241.60
Option 1Available WorkDaysHours
POP1 February 2026 - 31 January 20272612088Escalation3%
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%
Operations Specialist I1.002,088.00208.001,880.00$33.99$0.68$34.67$0.00$34.67$0.69$35.36$65,179.60$1,297.20$66,476.80
Operations Specialist II1.002,088.00208.001,880.00$41.20$0.82$42.02$0.00$42.02$0.84$42.86$78,997.60$1,579.20$80,576.80
2.004,176.00416.003,760.00$144,177.20$2,876.40$147,053.60
Option 2Available WorkDaysHours
POP1 February 2027 - 31 January 20282612088Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
20012.00%$0.002.00%
Operations Specialist I1.002,088.00208.001,880.00$35.01$0.70$35.71$0.00$35.71$0.71$36.42$67,134.80$1,334.80$68,469.60
Operations Specialist II1.002,088.00208.001,880.00$42.44$0.85$43.29$0.00$43.29$0.87$44.16$81,385.20$1,635.60$83,020.80
2.004,176.00416.003,760.00$148,520.00$2,970.40$151,490.40
Option 3Available WorkDaysHours
POP1 February 2028 - 31 January 20292622096Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
30012.00%$0.002.00%
Operations Specialist I1.002,096.00208.001,888.00$36.06$0.72$36.78$0.00$36.78$0.74$37.52$69,440.64$1,397.12$70,837.76
Operations Specialist II1.002,096.00208.001,888.00$43.71$0.87$44.58$0.00$44.58$0.89$45.47$84,167.04$1,680.32$85,847.36
2.004,192.00416.003,776.00$153,607.68$3,077.44$156,685.12
Option 4Available WorkDaysHours
POP1 February 2029 - 31 January 20302612088Escalation3%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursSubcontractor FBLR With FeePrime G&ASubtotalPMO RatePrime FBLR Without FeePrime FeePrime FBLR With FeeTotal CostTotal FeeTotal Amount
40012.00%$0.002.00%
Operations Specialist I1.002,088.00208.001,880.00$37.14$0.74$37.88$0.00$37.88$0.76$38.64$71,214.40$1,428.80$72,643.20
Operations Specialist II1.002,088.00208.001,880.00$45.02$0.90$45.92$0.00$45.92$0.92$46.84$86,329.60$1,729.60$88,059.20
2.004,176.00416.003,760.00$157,544.00$3,158.40$160,702.40
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 Base and Opt 1 - Opt 4 Tabs

This is only an example; the Prime is not required to propose any G&A or Fee on the subcontractor costs.

The Available Work Days and Hours are based on the Period of Performance included in Cells B3, B11, B19, B27, B35

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.

PMO Rate

Base YearAvailable WorkDaysHours
POP1 March 2025 - 31 January 20262411928
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
0%0%
Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00
Deputy Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00
Quality & Sharepoint Administrator0.000.00$0.00$0.00$0.00$0.00$0.00
Security Specialist I0.000.00$0.00$0.00$0.00$0.00$0.00
Contract Finance Manager0.000.00$0.00$0.00$0.00$0.00$0.00
HR Specialist0.000.00$0.00$0.00$0.00$0.00$0.00
Business Programmer III0.000.00$0.00$0.00$0.00$0.00$0.00
Information System Analyst III0.000.00$0.00$0.00$0.00$0.00$0.00
Property Specialist II0.000.00$0.00$0.00$0.00$0.00$0.00
0.000.000.000.00$0.00
Option 1Available WorkDaysHours
POP1 February 2026 - 31 January 20272612088Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
0%0%
Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Deputy Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Quality & Sharepoint Administrator0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Specialist I0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Finance Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
HR Specialist0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Business Programmer III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Information System Analyst III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Property Specialist II0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
0.000.000.000.00$0.00
Option 2Available WorkDaysHours
POP1 February 2027 - 31 January 20282612088Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
0%0%
Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Deputy Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Quality & Sharepoint Administrator0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Specialist I0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Finance Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
HR Specialist0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Business Programmer III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Information System Analyst III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Property Specialist II0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
0.000.000.000.00$0.00
Option 3Available WorkDaysHours
POP1 February 2028 - 31 January 20292622096Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
0%0%
Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Deputy Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Quality & Sharepoint Administrator0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Specialist I0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Finance Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
HR Specialist0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Business Programmer III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Information System Analyst III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Property Specialist II0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
0.000.000.000.00$0.00
Option 4Available WorkDaysHours
POP1 February 2029 - 31 January 20302612088Escalation0%
CLINLabor CategoryFTEsTotal HoursNon-Productive HoursProductive HoursLabor RateFringe RateSubtotalG&AFBLR Without FeeTotal PMO Amount
0%0%
Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Deputy Program Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Quality & Sharepoint Administrator0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Specialist I0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Finance Manager0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
HR Specialist0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Business Programmer III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Information System Analyst III0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
Property Specialist II0.000.00$0.00$0.00$0.00$0.00$0.00$0.00
0.000.000.000.00$0.00
PMO RateBaseOption 1Option 2Option 3Option 4
Total PMO Amount$0.00$0.00$0.00$0.00$0.00
Base - Direct Labor Hours15,520.0016,888.0016,888.0016,960.0016,888.00
PMO Amount / Labor Hour$0.00$0.00$0.00$0.00$0.00
Notes:
The Available Work Days and Hours are based on the Period of Performance included in Cells B2, B18, B34, B50, B66
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 .