Attachment III - Master Fixed Rate Table.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Research and Development and Developmental Test and Evaluation (RDDT&E) Technical Support Services Federal contract opportunity
Solicitation number
70RSAT23R00000009
Issued by
Department of Homeland Security Office of Procurement Operations

About this file

This document contains a pricing template and instructions for a request for proposal for research and development technical support services. The pricing template includes labor categories, hourly rates, labor hours, and other direct costs for a base year and four option years. Offerors are instructed to provide fully burdened hourly rates by labor category for the performance of applied research, developmental test and evaluation, and applied research for detection, vulnerability, and mitigation assessment services. The template also includes a breakdown of hourly labor rates by wage, fringe, overhead, G&A, and profit percentages for prime and subcontractor labor. The request is issued by the Department of Homeland Security's Science and Technology Directorate, Transportation Security Laboratory for RDDT&E III technical support services.

View the file

Other files for this federal contract opportunity

Other files attached to Research and Development and Developmental Test and Evaluation (RDDT&E) Technical Support Services, newest first.
File Type Posted
Attachment IV - TSL RDDTE Reading Room Registration Form _ Rev 10 09Feb23.pdf PDF
Attachment II Recommended Labor Category Descriptions and Basic Qualifications.pdf PDF
RFP 70RSAT23R00000009 RDDTE 09Feb2023_Final.pdf PDF
Attachment V - Questions and Answers from Draft Solicitation.xlsx XLSX spreadsheet
Attachment I Statement of Work.pdf PDF

On GovTribe

Work with this file on GovTribe

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

Text version

Instructions for Pricing Tabs

Instructions for completing the Total R&D T&E Tech Support and Breakdown by Element Tabs

Total R&D T&E Tech Support tab

1. Offerors shall insert their proposed labor rates for all categories and contract periods in the highlighted yellow cells. For purposes of this submission assume a performance start date of XX, although the actual start date may vary.

2. The proposed rates apply to both prime and subcontract effort.

3. The worksheet will automatically compute the total evaluated price by multiplying the offerors inputted fully burdened labor hour rates for those categories which have assigned labor hours.

4. Note only those labor categories with assigned hours are considered in the total evaluated price. Categories without assigned hours are not considered in the total evaluated price, however they are considered for award.

5. The assigned hours by labor category are for price evaluation purposes only and do not represent the awarded hours under the contract.

6. The prefilled ODC amounts represent an estimate for Material, ODCs, and indirect burdens. They are not included in the Total Evaluated price. These amounts shall not be adjusted by the offerors.

Breakdown by Price Element tab

The purpose of this worksheet is to breakdown the offeror's proposed fully burdened hourly rate from the Total R&D T&E Tech Support tab by price element to include Wages, Fringe, Overhead, G&A, and Profit. Accordingly, the "Fixed Hourly Rate" for each labor category should reconcile to the rates shown on the Total R&D T&E Tech Support tab. This information may be used to evaluate the Price Realism of the offerors proposed fully burdened labor hour rates.

1. For each labor category indicate the proposed percentage of prime and subcontract effort for each period in the columns entitled "Percentage of Prime Effort" and "Percentage of Subcontract Effort".

2. For each labor category enter the proposed hourly wage rate under the "Wage" column. If proposing a mix of prime and subcontract effort for a particular category, the amount shall represent a weighted average. This information is required for each contract period.

3. If applicable, for each labor category enter the proposed hourly fringe rate under the "Fringe" column. The fringe amount shall be expressed as an hourly dollar rate component of the proposed fully burdened fixed labor rate. If proposing a mix of prime and subcontract effort for a particular category, the amount shall represent a weighted average. This information is required for each contract period.

4. If applicable, for each labor category enter the proposed hourly overhead rate under the "Overhead" column. The overhead amount shall be expressed as an hourly dollar rate component of the proposed fully burdened fixed labor rate. If proposing a mix of prime and subcontract effort for a particular labor category, the amount shall represent a weighted average. This information is required for each contract period.

5. If applicable, for each labor category enter the proposed hourly general and administrative rate under the "G&A" column. The G&A amount shall be expressed as an hourly dollar rate component of the proposed fully burdened fixed labor rate. If proposing a mix of prime and subcontract effort for a particular labor category, the amount shall represent a weighted average. This information is required for each contract period.

6. For each labor category enter the proposed hourly profit rate under the "Profit" column. The Profit amount shall be expressed as an hourly dollar rate component of the proposed fully burdened fixed labor rate. If proposing a mix of prime and subcontract effort for a particular labor category, the amount shall represent a weighted average. This information is required for each contract period.

7. The fully burdened "Fixed Hourly Rate" will automatically compute based on the hourly dollar rate by price element data entered for the Wages, Fringe, Overhead, G&A and Profit.

Total R&D T&E Tech Support

Attachment III - Research & Development and Developmental Test & Evaluation (RDT&E) III Technical Support
Master Fixed Rate Table
YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5Total Estimate
CONTRACTOR LABOR CATEGORYHoursFixed Hourly RatePriceHoursFixed Hourly RatePriceHoursFixed Hourly RatePriceHoursFixed Hourly RatePriceHoursFixed Hourly RatePriceHoursPrice
Clerical/ admin support (offsite)1,410$0.001,410$0.001,410$0.001,410$0.001,410$0.007,050$0.00
Clerical/ admin support (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Documentation Specialist (offsite)1,410$0.001,410$0.001,410$0.001,410$0.001,410$0.007,050$0.00
Documentation Specialist (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Engineer 1 (offsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Engineer 1 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Engineer 2 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 2 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 3 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 3 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Engineer 4 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 4 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Engineer 5 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 5 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 6 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 6 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Engineer 7 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer 7 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Jr. Engineering Technicial (offsite)1,410$0.001,410$0.001,410$0.001,410$0.001,410$0.007,050$0.00
Jr. Engineering Technicial (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Engineering Technician 1 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineering Techician 1 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Engineering Technician 2 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Engineer Technician 2 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Explosives Specialist (offsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Explosives Specialist (onsite)1,410$0.001,410$0.001,410$0.001,410$0.001,410$0.007,050$0.00
Financial/ Program Analyst (offsite)1,410$0.001,410$0.001,410$0.001,410$0.001,410$0.007,050$0.00
Financial/ Program Analyst (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Laboratory Technician 1 (offsite)470$0.00470$0.00470$0.00470$0.00470$0.002,350$0.00
Laboratory Technician 1 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Laboratory Technician 2 (offsite)470$0.00470$0.00470$0.00470$0.00470$0.002,350$0.00
Laboratory Technician 2 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Program/Project Manager (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Program/Project Manager (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Scientist 1 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 1 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Scientist 2 (offsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Scientist 2 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 3 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientst 3 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Scientist 4 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 4 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Scientist 5 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 5 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Scientist 6 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 6 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 7 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Scientist 7 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Senior Blast Engineer (offsite)470$0.00470$0.00470$0.00470$0.00470$0.002,350$0.00
Senior Blast Engineer (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 1 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 1 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 2 (offsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 2 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 3 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 3 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 4 (offsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 4 (onsite)3,760$0.003,760$0.003,760$0.003,760$0.003,760$0.0018,800$0.00
Software/Computer Engineer 5 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 5 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 6 (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 6 (onsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Software/Computer Engineer 7 (offsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Software/Computer Engineer 7 (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Statistician (offsite)470$0.00470$0.00470$0.00470$0.00470$0.002,350$0.00
Statistician (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00
Technical Writer (offsite)1,880$0.001,880$0.001,880$0.001,880$0.001,880$0.009,400$0.00
Technical Writer (onsite)- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00- 0$0.00

Total Contractor Labor 104,810 $ - 0 104,810 $0.00 104,810 $ - 0 104,810 $ - 0 104,810 $ - 0 524,050 $0.00

* Proposed Hourly Rate Applies to Prime and Subcontractor Effort

Other Direct Costs (ODC) - INDIRECT BURDEN APPLIED TO MATERIAL COST is included in this estimateQuantityUnit CostCostQuantityUnit CostCostQuantityUnit CostCostQuantityUnit CostCostQuantityUnit CostCost
Materials1$1,310,000.00$1,310,000.001$1,349,300.00$1,349,300.001$1,389,779.00$1,389,779.001$1,431,472.37$1,431,472.371$1,474,416.54$1,474,416.54$6,954,967.91
Travel1$100,000.00$100,000.001$100,000.00$100,000.001$100,000.00$100,000.001$100,000.00$100,000.001$100,000.00$100,000.00$500,000.00
Total ODCs$1,410,000.00$1,449,300.00$1,489,779.00$1,531,472.37$1,574,416.54$7,454,967.91

Grand Total $1,410,000.00 $1,449,300.00 $1,489,779.00 $1,531,472.37 $1,574,416.54 $7,454,967.91

&"Arial,Bold"&16PRICING TEMPLATE - TIME AND MATERIALS COMPETITIVE MODEL

Page &P of &N

Breakdown by Price Element Attachment III - Price Breakdown - Research & Development and Developmental Test & Evaluation (RDT&E) III Technical Support

Base Year - Composition of Fully Burdened Labor Hour RateOption Year 1 - Composition of Fully Burdened Labor Hour RateOption Year 2 - Composition of Fully Burdened Labor Hour RateOption Year 3 - Composition of Fully Burdened Labor Hour RateOption Year 4 - Composition of Fully Burdened Labor Hour Rate
CONTRACTOR LABOR CATEGORYPercentage of Prime EffortPercentage of Subcontractor EffortWageFringeOverheadG&AProfitFixed Hourly RatePercentage of Prime EffortPercentage of Subcontractor EffortWageFringeOverheadG&AProfitFixed Hourly RatePercentage of Prime EffortPercentage of Subcontractor EffortWageFringeOverheadG&AProfitFixed Hourly RatePercentage of Prime EffortPercentage of Subcontractor EffortWageFringeOverheadG&AProfitFixed Hourly RatePercentage of Prime EffortPercentage of Subcontractor EffortWageFringeOverheadG&AProfitFixed Hourly Rate
Clerical/ admin support (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Clerical/ admin support (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Documentation Specialist (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Documentation Specialist (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 1 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 1 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 2 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 2 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 3 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 3 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 4 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 4 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 5 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 5 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 6 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 6 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 7 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer 7 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Jr. Engineering Technicial (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Jr. Engineering Technicial (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Technician 1 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Techician 1 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineering Technician 2 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer Technician 2 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Explosives Specialist (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Explosives Specialist (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Financial/ Program Analyst (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Financial/ Program Analyst (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Laboratory Technician 1 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Laboratory Technician 1 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Laboratory Technician 2 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Laboratory Technician 2 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Program/Project Manager (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Program/Project Manager (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 1 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 1 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 2 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 2 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 3 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientst 3 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 4 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 4 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 5 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 5 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 6 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 6 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 7 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Scientist 7 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Blast Engineer (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Blast Engineer (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 1 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 1 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 2 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 2 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 3 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 3 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 4 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 4 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 5 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 5 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 6 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 6 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 7 (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Software/Computer Engineer 7 (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Statistician (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Statistician (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Writer (offsite)$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Writer (onsite)$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0

&"Arial,Bold"&16PRICING TEMPLATE - TIME AND MATERIALS COMPETITIVE MODEL

Page &P of &N

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