EPW modified 031524- Attachment B.xlsx

XLSX spreadsheet 132 KB Posted Mar 15, 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 15, 2024

This is a combined synopsis and solicitation for commercial services to provide instrument maintenance and support for six Thermo Electron instruments used by the Research and Support Unit of the FBI Laboratory Division. Services required include annual instrument service and support as well as routine instrument maintenance to ensure the laboratory instrumentation remains operational. This is a lowest price technically acceptable acquisition to be evaluated according to FAR Part 13 simplified acquisition procedures. The solicitation number is 15F06724P0000418.

View the file

Other files

File	Type	Posted
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
EPW -Attachment B.xlsx	XLSX spreadsheet	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.

Instructions

Instructions to the Offeror:
1)	The Offeror shall populate the columns/rows shown in green on each worksheet tab
	a) The Offeror shall complete the green-highlighted "Service Contract Act" section (Columns AB:AE) for all labor categories identified as Non-Exempt in Column C
	b) The Offeror shall include all applicable indirect burdens, including profit/fee, in the proposed labor rates ("Rate/Hr")
	c) The Offeror may apply indirect burdens, as applicable, to proposed Parts and Travel cost (if a burden doesn't apply, leave the cell blank)
	d) The Offeror shall not apply profit/fee to proposed Parts and Travel cost
2)	The Offeror may modify the worksheet tabs by inserting additional rows, if needed
3)	The Offeror may modify existing formulas or insert additional formulas for added line items, as needed
4)	Red-highlighted data/information included in this Attachment is sample data only and must be removed before submitting the proposal
Notes on Instructions: The Offeror shall list all changes made to the worksheet tabs on the "Notes" tab in order to provide transparency for the Government's understanding and reference
The Offeror is responsible for the accuracy of the calculated proposed price - all formulas should be verified and edited as necessary

Summary

No data input is required on this tab; the tables will self-populate based on data contained in the blue CLIN tabs
- If modifications are made to any of the CLIN tabs, Offerors must edit formulas on that tab as well as in this Summary tab to accurately calculate proposed cost/price
- Offerors are responsible for the accuracy of the calculated proposed cost/price - all formulas should be verified and edited as necessary
PRICE/COST BY CLIN TABLES	PRICE/COST BY CLIN AND YEAR TABLES	FULLY BURDENED LABOR RATES (FBLR) BY LABOR CATEGORY AND YEAR TABLES	LABOR HOURS BY LABOR CATEGORY AND YEAR TABLES

Proposed Price by CLIN				Proposed Price by CLIN and Year								CLIN 0001 - Proposed Labor Rates by Labor Category and Year						CLIN 0004 - Proposed Labor Rates by Labor Category and Year						CLIN 0001 - Proposed Labor Hours by Labor Category and Year							CLIN 0004 - Proposed Labor Hours by Labor Category and Year
CLIN	CLIN Decription	Contract Type	Proposed	CLIN	CLIN Decription	BY	OY1	OY2	OY3	OY4	Total	Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Total	Labor Category	BY	OY1	OY2	OY3	OY4	Total
0001	Q Exactive	FFP	$1,461	0001	Q Exactive	$120	$198	$284	$378	$480	$1,461	LCAT 1	$18.00	$19.00	$20.00	$21.00	$22.00	LCAT 7	$12.00	$13.00	$14.00	$15.00	$16.00	LCAT 1	1	3	5	7	9	25	LCAT 7	1	3	5	7	9	25
0002	Delta V	FFP	$1,337	0002	Delta V	$111	$181	$259	$346	$440	$1,337	LCAT 2	$17.00	$18.00	$19.00	$20.00	$21.00	LCAT 8	$11.00	$12.00	$13.00	$14.00	$15.00	LCAT 2	2	4	6	8	10	30	LCAT 8	2	4	6	8	10	30
0003	Element 2	FFP	$1,211	0003	Element 2	$104	$165	$234	$311	$396	$1,211																			0							0
0004	IDX	FFP	$1,106	0004	IDX	$97	$151	$213	$283	$361	$1,106																			0							0
0005	IQX	FFP	$916	0005	IQX	$75	$121	$175	$237	$307	$916																			0							0
0006	iCap	FFP	$858	0006	iCap	$80	$118	$164	$218	$280	$858																			0							0
Total Proposed Price			$6,890	Total Proposed Price		$587	$935	$1,330	$1,773	$2,264	$6,890																			0							0
																														0							0
																														0							0
Proposed Price by CLIN and Cost Element				Proposed Labor Cost by CLIN and Year																										0							0
CLIN	CLIN Decription	Cost Element*	Proposed	CLIN	CLIN Decription	BY	OY1	OY2	OY3	OY4	Total													Total	3	7	11	15	19	55	Total	3	7	11	15	19	55
0001	Q Exactive	Labor	$1,110	0001	Q Exactive	$52	$129	$214	$307	$408	$1,110
0001	Q Exactive	Parts	$274	0002	Delta V	$46	$115	$192	$277	$370	$1,000
0001	Q Exactive	Travel	$77	0003	Element 2	$40	$101	$170	$247	$332	$890	CLIN 0002 - Proposed Labor Rates by Labor Category and Year						CLIN 0005 - Proposed Labor Rates by Labor Category and Year						CLIN 0002 - Proposed Labor Hours by Labor Category and Year							CLIN 0005 - Proposed Labor Hours by Labor Category and Year
Total CLIN 0001			$1,461	0004	IDX	$34	$87	$148	$217	$294	$780	Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Total	Labor Category	BY	OY1	OY2	OY3	OY4	Total
0002	Delta V	Labor	$1,000	0005	IQX	$28	$73	$126	$187	$256	$670	LCAT 3	$16.00	$17.00	$18.00	$19.00	$20.00	LCAT 9	$10.00	$11.00	$12.00	$13.00	$14.00	LCAT 3	1	3	5	7	9	25	LCAT 9	1	3	5	7	9	25
0002	Delta V	Parts	$280	0006	iCap	$22	$59	$104	$157	$218	$560	LCAT 4	$15.00	$16.00	$17.00	$18.00	$19.00	LCAT 10	$9.00	$10.00	$11.00	$12.00	$13.00	LCAT 4	2	4	6	8	10	30	LCAT 10	2	4	6	8	10	30
0002	Delta V	Travel	$58	Total Proposed Labor Cost		$222	$564	$954	$1,392	$1,878	$5,010																			0							0
Total CLIN 0002			$1,337																											0							0
0003	Element 2	Labor	$890																											0							0
0003	Element 2	Parts	$280	Proposed Parts Cost by CLIN and Year																										0							0
0003	Element 2	Travel	$41	CLIN	CLIN Decription	BY	OY1	OY2	OY3	OY4	Total																			0							0
Total CLIN 0003			$1,211	0001	Q Exactive	$53	$54	$55	$56	$57	$274																			0							0
0004	IDX	Labor	$780	0002	Delta V	$54	$55	$56	$57	$58	$280																			0							0
0004	IDX	Parts	$295	0003	Element 2	$56	$56	$56	$56	$56	$280																			0							0
0004	IDX	Travel	$30	0004	IDX	$57	$58	$59	$60	$61	$295													Total	3	7	11	15	19	55	Total	3	7	11	15	19	55
Total CLIN 0004			$1,106	0005	IQX	$42	$43	$44	$45	$46	$222
0005	IQX	Labor	$670	0006	iCap	$43	$44	$45	$46	$47	$227
0005	IQX	Parts	$222	Total Proposed Parts Cost		$305	$310	$315	$321	$326	$1,577	CLIN 0003 - Proposed Labor Rates by Labor Category and Year						CLIN 0006 - Proposed Labor Rates by Labor Category and Year						CLIN 0003 - Proposed Labor Hours by Labor Category and Year							CLIN 0006 - Proposed Labor Hours by Labor Category and Year
0005	IQX	Travel	$25									Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Labor Category	BY	OY1	OY2	OY3	OY4	Total	Labor Category	BY	OY1	OY2	OY3	OY4	Total
Total CLIN 0005			$916									LCAT 5	$14.00	$15.00	$16.00	$17.00	$18.00	LCAT 11	$8.00	$9.00	$10.00	$11.00	$12.00	LCAT 5	1	3	5	7	9	25	LCAT 11	1	3	5	7	9	25
0006	iCap	Labor	$560	Proposed Travel Cost by CLIN and Year								LCAT 6	$13.00	$14.00	$15.00	$16.00	$17.00	LCAT 12	$7.00	$8.00	$9.00	$10.00	$11.00	LCAT 6	2	4	6	8	10	30	LCAT 12	2	4	6	8	10	30
0006	iCap	Parts	$227	CLIN	CLIN Decription	BY	OY1	OY2	OY3	OY4	Total																			0							0
0006	iCap	Travel	$72	0001	Q Exactive	$15	$15	$15	$15	$15	$77																			0							0
Total CLIN 0006			$858	0002	Delta V	$12	$12	$12	$12	$12	$58																			0							0
Total Proposed Price			$6,890	0003	Element 2	$8	$8	$8	$8	$8	$41																			0							0
Totals by Cost Element				0004	IDX	$6	$6	$6	$6	$6	$30																			0							0
Labor			$5,010	0005	IQX	$5	$5	$5	$5	$5	$25																			0							0
Parts			$1,577	0006	iCap	$14	$14	$14	$14	$14	$72																			0							0
Travel			$303	Total Proposed Travel Cost		$61	$61	$61	$61	$61	$303																			0							0
Total Proposed Price			$6,890																					Total	3	7	11	15	19	55	Total	3	7	11	15	19	55
*Parts and Travel costs include applicable indirect burdens

0001 (Q Exactive) CLIN 0001 - Q Exactive

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 1	Exempt	1	$18.00	$18	3	$19.00	$57	5	$20.00	$100	7	$21.00	$147	9	$22.00	$198	25	$520
	LCAT 2	Non-Exempt	2	$17.00	$34	4	$18.00	$72	6	$19.00	$114	8	$20.00	$160	10	$21.00	$210	30	$590		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$52	7		$129	11		$214	15		$307	19		$408	55	$1,110	$1,110

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$50	$50	1	$51	$51	1	$52	$52	1	$53	$53	1	$54	$54	5	$260
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$50	1		$51	1		$52	1		$53	1		$54	5	$260	$260
Indirect Burdens	Material Handling	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3		$13
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$53			$54			$55			$56			$57		$274

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$5.00	$5	$4.00	$4		$3.00	$3	$2.00		$1	$1.00	$1	$14		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$5.00	$5	$4.00	$4		$3.00	$3	$2.00		$1	$1.00	$1	$14		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$5.00	$5	$4.00	$4		$3.00	$3	$2.00		$1	$1.00	$1	$14		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$5.00	$5	$4.00	$4		$3.00	$3	$2.00		$1	$1.00	$1	$14		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$5.00	$5	$4.00	$4		$3.00	$3	$2.00		$1	$1.00	$1	$14		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$14	OY1		$14	OY2		$14	OY3			$14	OY4			$14	Total	$70	$70
Indirect Burden	G&A		Rate	10.00%	$1	Rate	10.00%	$1	Rate	10.00%	$1		Rate	10.00%	$1		Rate	10.00%	$1		$7
Total Burdened Travel					$15			$15			$15				$15				$15		$77
																						Math Check
CLIN 0001 Total Proposed Price					$120			$198			$284				$378				$480		$1,461	$1,461

0002 (Delta V) CLIN 0002 - Delta V

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 3	Exempt	1	$16.00	$16	3	$17.00	$51	5	$18.00	$90	7	$19.00	$133	9	$20.00	$180	25	$470
	LCAT 4	Non-Exempt	2	$15.00	$30	4	$16.00	$64	6	$17.00	$102	8	$18.00	$144	10	$19.00	$190	30	$530		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$46	7		$115	11		$192	15		$277	19		$370	55	$1,000	$1,000

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$51	$51	1	$52	$52	1	$53	$53	1	$54	$54	1	$55	$55	5	$265
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$51	1		$52	1		$53	1		$54	1		$55	5	$265	$265
Indirect Burdens	Material Handling	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3		$13
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$54			$55			$56			$57			$58		$280

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$4.00	$4	$3.00	$3		$2.00	$2	$1.00		$1	$1.00	$1	$11		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$4.00	$4	$3.00	$3		$2.00	$2	$1.00		$1	$1.00	$1	$11		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$4.00	$4	$3.00	$3		$2.00	$2	$1.00		$1	$1.00	$1	$11		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$4.00	$4	$3.00	$3		$2.00	$2	$1.00		$1	$1.00	$1	$11		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$4.00	$4	$3.00	$3		$2.00	$2	$1.00		$1	$1.00	$1	$11		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$11	OY1		$11	OY2		$11	OY3			$11	OY4			$11	Total	$53	$53
Indirect Burden	G&A		Rate	10.00%	$1	Rate	10.00%	$1	Rate	10.00%	$1		Rate	10.00%	$1		Rate	10.00%	$1		$5
Total Burdened Travel					$12			$12			$12				$12				$12		$58
																						Math Check
CLIN 0002 Total Proposed Price					$111			$181			$259				$346				$440		$1,337	$1,337

0003 (Element 2) CLIN 0003 - Element 2

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 5	Exempt	1	$14.00	$14	3	$15.00	$45	5	$16.00	$80	7	$17.00	$119	9	$18.00	$162	25	$420
	LCAT 6	Non-Exempt	2	$13.00	$26	4	$14.00	$56	6	$15.00	$90	8	$16.00	$128	10	$17.00	$170	30	$470		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$40	7		$101	11		$170	15		$247	19		$332	55	$890	$890

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$53	$53	1	$53	$53	1	$53	$53	1	$53	$53	1	$53	$53	5	$265
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$53	1		$53	1		$53	1		$53	1		$53	5	$265	$265
Indirect Burdens	Material Handling	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3		$13
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$56			$56			$56			$56			$56		$280

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$3.00	$3	$2.00	$2		$1.00	$1	$1.00		$1	$1.00	$1	$8		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$3.00	$3	$2.00	$2		$1.00	$1	$1.00		$1	$1.00	$1	$8		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$3.00	$3	$2.00	$2		$1.00	$1	$1.00		$1	$1.00	$1	$8		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$3.00	$3	$2.00	$2		$1.00	$1	$1.00		$1	$1.00	$1	$8		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$3.00	$3	$2.00	$2		$1.00	$1	$1.00		$1	$1.00	$1	$8		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$8	OY1		$8	OY2		$8	OY3			$8	OY4			$8	Total	$38	$38
Indirect Burden	G&A		Rate	10.00%	$1	Rate	10.00%	$1	Rate	10.00%	$1		Rate	10.00%	$1		Rate	10.00%	$1		$4
Total Burdened Travel					$8			$8			$8				$8				$8		$41
																						Math Check
CLIN 0003 Total Proposed Price					$104			$165			$234				$311				$396		$1,211	$1,211

0004 (IDX)

CLIN 0004 - IDX

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 7	Exempt	1	$12.00	$12	3	$13.00	$39	5	$14.00	$70	7	$15.00	$105	9	$16.00	$144	25	$370
	LCAT 8	Non-Exempt	2	$11.00	$22	4	$12.00	$48	6	$13.00	$78	8	$14.00	$112	10	$15.00	$150	30	$410		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$34	7		$87	11		$148	15		$217	19		$294	55	$780	$780

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$54	$54	1	$55	$55	1	$56	$56	1	$57	$57	1	$58	$58	5	$280
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$54	1		$55	1		$56	1		$57	1		$58	5	$280	$280
Indirect Burdens	Material Handling	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3	Rate	5.00%	$3		$14
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$57			$58			$59			$60			$61		$295

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$2.00	$2	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$6		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$2.00	$2	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$6		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$2.00	$2	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$6		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$2.00	$2	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$6		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$2.00	$2	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$6		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$6	OY1		$6	OY2		$6	OY3			$6	OY4			$6	Total	$28	$28
Indirect Burden	G&A		Rate	10.00%	$1	Rate	10.00%	$1	Rate	10.00%	$1		Rate	10.00%	$1		Rate	10.00%	$1		$3
Total Burdened Travel					$6			$6			$6				$6				$6		$30
																						Math Check
CLIN 0004 Total Proposed Price					$97			$151			$213				$283				$361		$1,106	$1,106

0005 (IQX)

CLIN 0005 - IQX

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 9	Exempt	1	$10.00	$10	3	$11.00	$33	5	$12.00	$60	7	$13.00	$91	9	$14.00	$126	25	$320
	LCAT 10	Non-Exempt	2	$9.00	$18	4	$10.00	$40	6	$11.00	$66	8	$12.00	$96	10	$13.00	$130	30	$350		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$28	7		$73	11		$126	15		$187	19		$256	55	$670	$670

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$40	$40	1	$41	$41	1	$42	$42	1	$43	$43	1	$44	$44	5	$210
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$40	1		$41	1		$42	1		$43	1		$44	5	$210	$210
Indirect Burdens	Material Handling	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2		$11
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$42			$43			$44			$45			$46		$222

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$5		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$5		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$5		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$5		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$1.00	$1		$1.00	$1	$1.00		$1	$1.00	$1	$5		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$5	OY1		$5	OY2		$5	OY3			$5	OY4			$5	Total	$23	$23
Indirect Burden	G&A		Rate	10.00%	$0	Rate	10.00%	$0	Rate	10.00%	$0		Rate	10.00%	$0		Rate	10.00%	$0		$2
Total Burdened Travel					$5			$5			$5				$5				$5		$25
																						Math Check
CLIN 0005 Total Proposed Price					$75			$121			$175				$237				$307		$916	$916

0006 (iCap) CLIN 0006 - iCap

	LABOR																				SERVICE CONTRACT ACT
	Labor Category/Description	Exempt/
Non-Exempt	0001			1001			2001			3001			4001			TOTALS
			YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5						Wage Determination #	Wage Determination Labor Category	Portion of Proposed Rate Attributable To:
			Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Rate/Hr	Total	Hours	Cost				Fringe Benefits	Health & Welfare
	LCAT 11	Exempt	1	$8.00	$8	3	$9.00	$27	5	$10.00	$50	7	$11.00	$77	9	$12.00	$108	25	$270
	LCAT 12	Non-Exempt	2	$7.00	$14	4	$8.00	$32	6	$9.00	$54	8	$10.00	$80	10	$11.00	$110	30	$290		WD# 2015-4467 Rev 26	Code-Description	$10.00	$5.00
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0
					$0			$0			$0			$0			$0	0	$0	Math Check
	Total Labor		3		$22	7		$59	11		$104	15		$157	19		$218	55	$560	$560

PARTS
Description		0001			1001			2001			3001			4001			TOTALS
		YEAR 1			YEAR 2			YEAR 3			YEAR 4			YEAR 5
		Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Unit Price	Total	Quantity	Cost
Part Number & Description (Supplier)		1	$41	$41	1	$42	$42	1	$43	$43	1	$44	$44	1	$45	$45	5	$215
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0
				$0			$0			$0			$0			$0	0	$0	Math Check
Total Direct Parts		1		$41	1		$42	1		$43	1		$44	1		$45	5	$215	$215
Indirect Burdens	Material Handling	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2	Rate	5.00%	$2		$11
	G&A		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		10.00%	$0		$1
Total Burdened Parts				$43			$44			$45			$46			$47		$227

TRAVEL
		City/State				Travel Factors			Airfare		Rental Car			Lodging		Per Diem			Miscellaneous		Extended Cost
Purpose of Trip	PoP Year	Departure			Destination	# Trips	# Travellers	# Nights	Rate	Cost	Rate	Cost		Rate	Cost	Rate		Cost	Rate	Cost
Site Visit	BY	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$2.00	$2		$3.00	$3	$4.00		$2	$5.00	$5	$13		BY
Site Visit	OY1	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$2.00	$2		$3.00	$3	$4.00		$2	$5.00	$5	$13		OY1
Site Visit	OY2	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$2.00	$2		$3.00	$3	$4.00		$2	$5.00	$5	$13		OY2
Site Visit	OY3	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$2.00	$2		$3.00	$3	$4.00		$2	$5.00	$5	$13		OY3
Site Visit	OY4	Some City, ST			Another City, ST	1	1	1	$1.00	$1	$2.00	$2		$3.00	$3	$4.00		$2	$5.00	$5	$13		OY4
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0
										$0		$0			$0			$0		$0	$0	Math Check
Total Travel		BY			$13	OY1		$13	OY2		$13	OY3			$13	OY4			$13	Total	$65	$65
Indirect Burden	G&A		Rate	10.00%	$1	Rate	10.00%	$1	Rate	10.00%	$1		Rate	10.00%	$1		Rate	10.00%	$1		$7
Total Burdened Travel					$14			$14			$14				$14				$14		$72
																						Math Check
CLIN 0006 Total Proposed Price					$80			$118			$164				$218				$280		$858	$858

Notes

PRICING MODEL NOTES

List all changes made to all worksheets

#	Tab	List of Changes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

&"Calibri"&10&K000000 Booz Allen Hamilton Restricted&1#_x000D_

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