EPW -Attachment B.xlsx

XLSX spreadsheet 36 KB Posted Mar 11, 2024

Attached to: Thermo Electron Multi-Instrument Support and Maintenance Services
Solicitation number: NOI-15F06724P0000418
Issued by: Department of Justice Federal Bureau of Investigation Headquarters Division

About this file

Written by GovTribe AI · Mar 11, 2024

This document provides a pricing template for a federal contract solicitation seeking instrument maintenance and support services. The solicitation seeks annual instrument service, support, and routine maintenance for six Thermo Electron instruments used by the Research and Support Unit of the FBI Laboratory Division to ensure instrumentation remains operational. Required services include instrument service, support, and routine maintenance to prevent inaccurate measurements that could lead to delays in reporting results and decreased confidence in the laboratory. Offerors should complete the template with proposed labor categories and rates, hours, travel and material costs, and notes on any changes made to the template. The contracting agency is the Department of Justice Federal Bureau of Investigation Headquarters Division.

View the file

Other files

File	Type	Posted
EPW modified 031524- Attachment B.xlsx	XLSX spreadsheet	Mar 15, 2024
Request for Quote.docx	DOCX document	Mar 11, 2024
SF-1149 - Exhibit 1.pdf	PDF	Mar 11, 2024
PPQ - Attachment C.docx	DOCX document	Mar 11, 2024
Statement of Objectives - Attachment A.docx	DOCX document	Mar 11, 2024

On GovTribe

Work with this file

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

Try for free Login

Text version

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

Burdened Labor Rates

CALCULATION OF PROPOSED BURDENED LABOR RATES

INSTRUCTIONS TO OFFERORS:

1. Populate the cells highlighted in green with the proposed labor categories, direct labor rates, and indirect rates which reflect the requirements of the applicable TOPR/SOW.

NOTE: Offerors shall propose Initial No. of Personal for Base and All Options. If Surge positions are identified after contract award they will be proposed at that time. NOTE: Offerors shall propose labor escalation in accordance with company policy.

2. Offerors should not delete unused rows.

3. Only populate the green-highlighted cells for the years applicable to the PWS.

4. Labor categories, direct labor rates, and indirect rates highlighted in RED FONT in the tables below are SAMPLE DATA ONLY and MUST BE REMOVED before submitting the proposal.

5. Offerors shall edit the proposed indirect pools, bases, and applicable indirect burden calculation formulas to be in accordance with their accounting system and to reflect the requirements of the

applicable TOPR/SOW.

6. Subcontractors shall provide a similar worksheet within their unsanitized proposal. Subcontractors may provide an unsanitized proposal directly to the Government.

	Base Year						PROPOSED LABOR BURDENS
Labor Category	Direct Labor Rate	Fringe	Overhead	G&A	Proposed Burdened Labor Rate		Indirect Pool	Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4
Program Manager	$10.00	$0.10	$0.20	$0.31	$10.61	Base Year	Fringe	1.00%
Systems Engineer-5	$11.00	$0.11	$0.22	$0.34	$11.67	Base Year	Overhead	2.00%
Systems Engineer-4	$12.00	$0.12	$0.24	$0.37	$12.73	Base Year	G&A	3.00%
Systems Engineer-4	$13.00	$0.13	$0.26	$0.40	$13.79	Base Year	FCCOM on Labor	4.00%
Systems Analyst-3	$14.00	$0.14	$0.28	$0.43	$14.86	Base Year	Profit/Fee	5.00%
		$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	Base Year
		$0.00	$0.00	$0.00	$0.00	Base Year
		$0.00	$0.00	$0.00	$0.00	Base Year
		$0.00	$0.00	$0.00	$0.00	Base Year
		$0.00	$0.00	$0.00	$0.00	Base Year

	Option Year 1						Calculation of Escalation Applied
Labor Category	Direct Labor Rate	Fringe	Overhead	G&A	Proposed Burdened Labor Rate
Program Manager		$0.00	$0.00	$0.00	$0.00	Option Year 1	-100%
Systems Engineer-5		$0.00	$0.00	$0.00	$0.00	Option Year 1	-100%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 1	-100%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 1	-100%
Systems Analyst-3		$0.00	$0.00	$0.00	$0.00	Option Year 1	-100%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 1	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 1	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 1	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 1	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 1	0%

	Option Year 2						Calculation of Escalation Applied
Labor Category	Direct Labor Rate	Fringe	Overhead	G&A	Proposed Burdened Labor Rate
Program Manager		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
Systems Engineer-5		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
Systems Analyst-3		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 2	0%

	Option Year 3						Calculation of Escalation Applied
Labor Category	Direct Labor Rate	Fringe	Overhead	G&A	Proposed Burdened Labor Rate
Program Manager		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
Systems Engineer-5		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
Systems Analyst-3		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 3	0%

	Option Year 4						Calculation of Escalation Applied
Labor Category	Direct Labor Rate	Fringe	Overhead	G&A	Proposed Burdened Labor Rate
Program Manager		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
Systems Engineer-5		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
Systems Engineer-4		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
Systems Analyst-3		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00		0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%
0		$0.00	$0.00	$0.00	$0.00	Option Year 4	0%

Pricing Worksheet

PRICING WORKSHEET

INSTRUCTIONS TO OFFERORS:

1. Populate the cells highlighted in green with the proposed prime labor hours and subcontractor labor hours and rates, as applicable, which reflect the requirements of the applicable TOPR/SOW.

Note: Subcontractor fields should be completed with as much information as possible. Subcontractors may provide an unsanitized proposal directly to the Government. Subcontractors should provide a similar worksheet within their unsanitized proposal.

2. Offerors should not delete unused rows.

3. For travel and material, populate the cells highlighted in green with the plug numbers stated in the TOPR.

Note: Fee on Travel and Materials/ODCs shall be established as directed by the TOPR. Indirect rates may be applied to travel and/or material/ODCs but the total proposed amount should not exceed the plug numbers as stated in the TOPR.

4. Only populate the green-highlighted cells for the years applicable to the TOPR/SOW.

5. Prime/Subcontractor labor hours and subcontractor rates highlighted in RED FONT below are SAMPLE DATA ONLY and MUST BE REMOVED before submitting the proposal.

6. Offerors shall edit the proposed bases and calculation formulas to be in accordance with their accounting system and to reflect the requirements of the applicable TOPR/SOW.

		Base Year			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Total
	Labor Category	Hours	Base Labor Rate	Total	Hours	Base Labor Rate	Total	Hours	Base Labor Rate	Total	Hours	Base Labor Rate	Total	Hours	Base Labor Rate	Total	Total
Hours	Total
	Program Manager	480	$10.00	$4,800		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	480	$4,800
	Systems Engineer-5	1920	$11.00	$21,120		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	1,920	$21,120
	Systems Engineer-4	1920	$12.00	$23,040		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	1,920	$23,040
	Systems Engineer-4	1920	$13.00	$24,960		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	1,920	$24,960
	Systems Analyst-3	1920	$14.00	$26,880		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	1,920	$26,880
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0		$0.00	$0	0	$0
	Total Labor	8160		$100,800	0		$0	0		$0	0		$0	0		$0	8,160	$100,800

	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:
Fringe	$100,800	1.00%	$1,008	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$1,008
Overhead	$101,808	2.00%	$2,036	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$2,036
Total Labor (exclusive of G&A)			$103,844			$0			$0			$0			$0	$103,844

Subcontractor	Hours:	Rate:	Cost:	Hours:	Rate:	Cost:	Hours:	Rate:	Cost:	Hours:	Rate:	Cost:	Hours:	Rate:	Cost:
System Analyst-3	1920	$10.00	$19,200			$0			$0			$0			$0	1,920	$19,200
System Analyst-2	1920	$10.00	$19,200			$0			$0			$0			$0	1,920	$19,200
Total Subcontractor	3840		$38,400	0		$0	0		$0	0		$0	0		$0	3,840	$38,400

	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:	Base:	Rate:	Cost:
G&A	$142,244	3.00%	$4,267	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$4,267

Cost Basis for Profit/Fee
Profit/Fee	$146,511	5.00%	$7,326	$0	0.00%	$0.00	$0	0.00%	$0.00	$0	0.00%	$0.00	$0	0.00%	$0.00	$7,326
Subtotal			$153,837			$0			$0			$0			$0	$153,837

Travel (Use Plug Number Stated in TOPR)																$0
Material/ODCs (Use Plug Number Stated in TOPR)																$0
FCCOM on Labor	$100,800	4.00%	$4,032	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$0	0.00%	$0	$4,032

Total Price $157,869 $0 $0 $0 $0 $157,869

Pricing Model Notes

PRICING MODEL NOTES

INSTRUCTIONS TO OFFERORS:

1. Offerors shall list all of the changes made to the worksheet in order to provide transparency for the Government's understanding and reference.

File details come from the government source that posted it. Updated Mar 11, 2024.