B08 - Solicitation Attachment D - Level of Effort (LOE) Spreadsheet v.2_ 7.1.21.xlsx

XLSX spreadsheet 230 KB Posted Jul 7, 2021

Attached to: Machining, Welding, Painting and Fabrication Services Contract
Solicitation number: W91CRB-21-R-0029
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Dec 31, 2023

This document package includes a solicitation for machining, welding, painting and fabrication services. The U.S. Army Aberdeen Test Center is seeking these services on-site at Aberdeen Proving Ground in Maryland through a follow-on five-year IDIQ contract with both CPFF and FFP task orders. The requirement is set aside for small businesses under NAICS 333992 with a size standard of 1,250 employees. Interested offerors must submit proposals electronically by the deadline following the instructions in section L of the solicitation. Any amendments to the RFP will be posted at the same website, which potential offerors should monitor regularly.

View the file

Other files

File	Type	Posted
B08 - Solicitation Attachment D - Level of Effort (LOE) Spreadsheet v.3_6.30.21.xlsx	XLSX spreadsheet	Jul 8, 2021
B08 - Amendment 0002_W91CRB-21-R-0029.pdf	PDF	Jul 8, 2021
B08 - Amendment 0001_W91CRB-21-R-0029.pdf	PDF	Jul 7, 2021
B08 - Attachment 7 - Wage Determination 2015-2165 Rev. 15, 20210414.pdf	PDF	Jul 7, 2021
B08 - Attachment 5 - Training Matrix.xlsx	XLSX spreadsheet	Jun 15, 2021
B08 - PWS Exhibit A - CDRLs A001-A004.pdf	PDF	Jun 15, 2021
B08 - RFP - W91CRB-21-R-0029_FINAL 20210615.pdf	PDF	Jun 15, 2021
B08 - Attachment 3 - DD Form 254.pdf	PDF	Jun 15, 2021
B08 - Solicitation Attachment D - Level of Effort (LOE) Spreadsheet.xlsx	XLSX spreadsheet	Jun 15, 2021
B08 - Attachment 6 - Government Furnished Property Listing.xlsx	XLSX spreadsheet	Jun 15, 2021
B08 - Attachment 4 - Collective Bargaining Agreement.pdf	PDF	Jun 15, 2021
B08 - Attachment 1 - Quality Assurance Surveillance Plan (QASP).docx	DOCX document	Jun 15, 2021
B08 - Attachment 3a - DD Form 254 - Support Documents.pdf	PDF	Jun 15, 2021
B08 - Solicitation Attachment B - OCI Certification.docx	DOCX document	Jun 15, 2021
B08 - Attachment 2 - Labor Categories and Qualifications.docx	DOCX document	Jun 15, 2021
B08 - Solicitation Attachment A - Past Performance Evaluation Form.docx	DOCX document	Jun 15, 2021
B08 - Solicitation Attachment C - Purchasing System Review.xlsx	XLSX spreadsheet	Jun 15, 2021

Show all 17

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
Solicitation Number: W91CRB-21-R-0029
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
	Government Inputs
	Solicitation Number:	W91CRB-21-R-0029
	Name of Action:	Machine Shop Re-Compete
	Period of Performance:
	Annual Productive Hours:	1920
	Offeror Inputs
	Prime Contractor/Subcontractor Name/Division:

Section B

Section B - Supplies or Services Prices

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

(The format below is a sample. Propose in the actual format of the Section B contained in the solicitation)

Transition-In
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
0001	Phase-In	1	Each	$ - 0
	FFP				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Profit=		$ - 0	From Price Summary Worksheet
			Price + Profit =		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
0002	FFP Task Orders	1	Each	$ - 0
	FFP				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Profit=		$ - 0	From Price Summary Worksheet
			Price + Profit =		$ - 0

Base Period
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
1001	Base Period	1	Each	$ - 0
	Labor - CPFF				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Fee=		$ - 0	From Price Summary Worksheet
			Price + Fee=		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
1002	ODCs & Travel	1	Each	$ - 0
	COST		Estimated price=		$ 280,000.00	From Price Summary Worksheet
			Burden/G&A =	0.00%	$ - 0	From Price Summary Worksheet and ODC Detail Worksheet
			Subtotal		$ 280,000.00

Year 2
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
2001	Year 2	1	Each	$ - 0
	Labor - CPFF				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Fee=		$ - 0	From Price Summary Worksheet
			Price + Fee=		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
2002	ODCs & Travel	1	Each	$ - 0
	COST		Estimated price=		$ 280,000.00	From Price Summary Worksheet
			Burden/G&A =	0.00%	$ - 0	From Price Summary Worksheet and ODC Detail Worksheet
			Subtotal		$ 280,000.00

Year 3
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
3001	Year 3	1	Each	$ - 0
	Labor - CPFF				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Fee=		$ - 0	From Price Summary Worksheet
			Price + Fee=		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
3002	ODCs & Travel	1	Each	$ - 0
	COST		Estimated price=		$ 280,000.00	From Price Summary Worksheet
			Burden/G&A =	0.00%	$ - 0	From Price Summary Worksheet and ODC Detail Worksheet
			Subtotal		$ 280,000.00

Year 4
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
4001	Year 4	1	Each	$ - 0
	Labor - CPFF				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Fee=		$ - 0	From Price Summary Worksheet
			Price + Fee=		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
4002	ODCs & Travel	1	Each	$ - 0
	COST		Estimated price=		$ 280,000.00	From Price Summary Worksheet
			Burden/G&A =	0.00%	$ - 0	From Price Summary Worksheet and ODC Detail Worksheet
			Subtotal		$ 280,000.00

Year 5
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
5001	Year 5	1	Each	$ - 0
	Labor - CPFF				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Fee=		$ - 0	From Price Summary Worksheet
			Price + Fee=		$ - 0

CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
5002	ODCs & Travel	1	Each	$ - 0
	COST		Estimated price=		$ 280,000.00	From Price Summary Worksheet
			Burden/G&A =	0.00%	$ - 0	From Price Summary Worksheet and ODC Detail Worksheet
			Subtotal		$ 280,000.00

Transition-Out
CLIN	SUPPLIES/SERVICES	QTY	UNIT	UNIT PRICE	AMOUNT
6001	Phase-out	1	Each	$ - 0
	FFP				$ - 0	From Price Summary Worksheet
			Estimated price=		$ - 0
			Profit=		$ - 0	From Price Summary Worksheet
			Price + Profit =		$ - 0

TOTAL
	TOTAL
		Estimated price=	$ 1,400,000.00
	Profit/Fee=		$ - 0
	Total Price=		$ 1,400,000.00

Double check figure	$ 1,400,000.00	CLIN Totals
Double check figure	$ 1,400,000.00	Price Summary Total
Double check figure	$ 1,400,000.00	Individual Worksheet Total

Price Summary

Price Summary Spreadsheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

Machine Shop Re-Compete	Base Period	Year 2	Year 3	Year 4	Year 5	TOTAL
Labor & Subcontract Labor Hours	78,720	78,720	78,720	78,720	78,720	393,600	From Labor Detail Worksheet
Direct & Indirect Labor & Subcontract Labor (less G&A)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
G&A	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
Direct & Indirect Labor & Subcontract Labor (Less Fee)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Labor & Subcontract Labor OT Hours	2,362	2,362	2,362	2,362	2,362	11,808	From Labor Detail Worksheet
OT Direct & Indirect Labor & Subcontract Labor (less G&A)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
OT G&A	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
OT Direct & Indirect Labor & Subcontract Labor (Less Fee)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OT Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From Labor Detail Worksheet
OT Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
FFP Task Orders	$ - 0					$ - 0
Phase-In	$ - 0					$ - 0
Phase-Out					$ - 0	$ - 0
ODCs (Less Burden)	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 1,400,000.00	From ODC Detail Sheet
G&A Burden on ODCs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	From ODC Detail Sheet
ODCs	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 1,400,000.00
Total Labor & ODC	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 280,000.00	$ 1,400,000.00

Direct Labor Rate Schedule

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

CLIN 0001: FFP Base Period				CLIN 1001: Year 2					CLIN 2001: Year 3			CLIN 3001: Year 4			CLIN 4001: Year 5
Labor Categories	Proposed Labor Rate	OT Rate	Basis for Rate Proposed	Labor Categories	SCA Identifier	Labor Type	Proposed Labor Rate	OT Rate	Escalation	Proposed Labor Rate	OT Rate	Escalation	Proposed Labor Rate	OT Rate	Escalation	Proposed Labor Rate	OT Rate
Government Site				Government Site
Welder Working Leader		$ - 0		Welder Working Leader	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Journeyperson Machinist		$ - 0		Journeyperson Machinist	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Journeyperson Welder		$ - 0		Journeyperson Welder	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
General Laborer		$ - 0		General Laborer	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Gunsmith Machinist		$ - 0		Gunsmith Machinist	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Material/Supply		$ - 0		Material/Supply	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
CNC Operator Technician		$ - 0		CNC Operator Technician	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Sheetmetal Worker		$ - 0		Sheetmetal Worker	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
CNC Cutting Table		$ - 0		CNC Cutting Table	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Computer Aided Manufacturing Programmer Working Leader		$ - 0		Computer Aided Manufacturing Programmer Working Leader	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Experimental Welder		$ - 0		Experimental Welder	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Painter		$ - 0		Painter	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Painter Leader		$ - 0		Painter Leader	n/a	Professional		$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Please enter all the corresponding labor categories proposed in the labor detail spreadhseets.

Indicate the basis of the proposed rates and provide documentation to substantiate the rates, such as pay stubs, signed employee letters of intent, etc. If the rates are based on estimates please provide salary survey data and other data to corroborate the rates.

Please provide the basis of escalation.

Labor Detail

Labor Detail Spreadsheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

Annual Productive Hours: 1920

Direct Labor

Indirect Labor

CLIN 0001: FFP Base Period

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

Total Productive Hours

Hourly Base Pay Rate (Note 5)

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	3,840.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	26,880.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				78,720	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 1001: Year 2

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

Total Productive Hours

Hourly Base Pay Rate (Note 5)

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	3,840.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	26,880.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				78,720	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 2001: Year 3

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

Total Productive Hours

Hourly Base Pay Rate (Note 5)

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	3,840.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	26,880.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				78,720	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 3001: Year 4

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

Total Productive Hours

Hourly Base Pay Rate (Note 5)

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	3,840.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	26,880.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				78,720	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 4001: Year 5

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

Total Productive Hours

Hourly Base Pay Rate (Note 5)

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	3,840.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	26,880.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	5,760.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	11,520.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	1,920.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				78,720	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Total:	393,600	0	0	0	0	0	0	0	0	0	0
Weighted Average:		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#REF!

OT Labor Detail

Labor Detail Spreadsheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

Annual Productive Hours: 1920

Direct Labor

Indirect Labor

CLIN 0001: FFP Base Period

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

OT Hours

OT Hourly Base Pay

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	115.20	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	806.40	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				2,362	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 1001: Year 2

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

OT Hours

OT Hourly Base Pay

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	115.20	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	806.40	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				2,362	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 2001: Year 3

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

OT Hours

OT Hourly Base Pay

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	115.20	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	806.40	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				2,362	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 3001: Year 4

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

OT Hours

OT Hourly Base Pay

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	115.20	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	806.40	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				2,362	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Direct Labor

Indirect Labor

CLIN 4001: Year 5

0.00%

WD or DB Identifier

Labor Type

Labor Categories (Note 2)

Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)

If Col e=S, Enter Name of Subcontractor(s) (Note 2)

OT Hours

OT Hourly Base Pay

Fringe (Note 6a)

Overhead (Note 6b)

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A (Note 8)

Total Price Before Profit

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

l = i + j+ k

m = h x l

o = m + n

q = o + p

r = q/h

s = r/i

	Professional	Welder Working Leader	Enter P or S	115.20	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Journeyperson Welder	Enter P or S	806.40	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	General Laborer	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Gunsmith Machinist	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Material/Supply	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Operator Technician	Enter P or S	172.80	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Sheetmetal Worker	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	CNC Cutting Table	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Computer Aided Manufacturing Programmer Working Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Experimental Welder	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter	Enter P or S	345.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Professional	Painter Leader	Enter P or S	57.60	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total:				2,362	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Weighted Average:				1	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#DIV/0!

Total:	11,808	0	0	0	0	0	0	0	0	0	0
Weighted Average:		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#REF!

ODC Detail

ODC Detail Spreadsheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

CLIN	Description	ODCs (Note 10)	Burden/G&A Rate	G&A	Total ODC
a	b	c	d	e = c x d	f = c + e
0002	ODCs Base Year	$ 280,000.00		$ - 0	$ 280,000.00
1002	ODCs Year 2	$ 280,000.00		$ - 0	$ 280,000.00
2002	ODCs Year 3	$ 280,000.00		$ - 0	$ 280,000.00
3002	ODCs Year 4	$ 280,000.00		$ - 0	$ 280,000.00
4002	ODCs Year 5	$ 280,000.00		$ - 0	$ 280,000.00
	Total	$ 1,400,000.00		$ - 0	$ 1,400,000.00
					(To Section B)

Indirect Rate Summary

Indirect Rate Summary Spreadsheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

Entity	Contract Type	Fringe Rate	Overhead Rate	G&A Rate	Proposed Profit Rate	% of Effort Performed by Prime and Subs Based on Labor Hours
Base Year
PRIME CONTRACTOR		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 2
PRIME CONTRACTOR		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 3
PRIME CONTRACTOR		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 4
PRIME CONTRACTOR		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%
Year 5
PRIME CONTRACTOR		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Fringe Worksheet

Fringe Rate Worksheet
Solicitation Number: W91CRB-21-R-0029
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Fringe Expenses:	FY2018 Actual	FY2019 Actual	FY2020 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated Year 5
Indirect payroll	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vacation (PTO)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Holiday	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Sick Leave	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Health/Disability Ins	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Workmans Compensation/Defense Base Act	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Bonuses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Retention Pay	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
401k Match	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Mil Leave	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Breavement	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Insurance	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Pool	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Less: FAR 31 Unallowable Cost
Entertainment, etc.	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Allowable Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Labor Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OH Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
B&P Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Labor Base	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Worksheet

Overhead Rate Worksheet
Solicitation Number: W91CRB-21-R-0029
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Overhead Expenses:	FY2018 Actual	FY2019 Actual	FY2020 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated Year 5
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Less: FAR 31 Unallowable Cost
Entertainment, etc.	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Allowable Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Labor Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OH Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
B&P Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Labor Base	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Worksheet

G&A Rate Worksheet

Solicitation Number: W91CRB-21-R-0029

Name of Action: Machine Shop Re-Compete

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

G&A Expenses:	FY2018 Actual	FY2019 Actual	FY2020 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated Year 5
Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fringe	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subscriptions	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Postage	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Printing	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Supplies	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Telephone	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Travel	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Misc	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Recruiting	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Maint	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Consultants	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Prof fees	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Filings	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Legal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total G&A	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Less: FAR 31 Unallowable Costs
Interest	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Contributions	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Advertising, etc.	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
G&A Pool After Deducting Unallowable Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Allocation Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fringe	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Overhead (including any unallowable cost)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Direct Costs (inclusing any unallowable cost)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total G&A Allocation Base	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Microsoft_Word_Document.docx General

Each offeror is to provide a price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the price analysis.

Overall Instructions

1. The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

2. The worksheet tabs shaded green have inputs required on that worksheet.

3. More detailed instructions follow number 9 below.

4. Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

5. Please enter the requested data in the green shaded areas on the Direct Labor Rate Schedule, which includes the proposed labor rates, the basis for the rate proposed and the escalation rate used. The direct rate information feeds into the Labor Detail worksheet.

6. Please enter the requested data in the green shaded areas on the Labor Detail worksheet, which includes which entity will be performing the work (columns D and E). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

7. Please enter the requested data in the green shaded areas on the ODC Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

8. Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet.

9. Please enter the requested data in the green shaded areas on the Fringe, Overhead, and G&A worksheets. These worksheets assist in calculating the indirect rates. This will enable the price evaluation team to analyze the indirects. PLEASE NOTE: The rates at the bottom DO NOT carry over to the Indirect Rate Summary.

Section B Worksheet

The Section B worksheet imports data from the Price Summary, Labor Detail, and ODC Detail worksheets and is used as a basis for the proposed formal Section B. Please note that there are three cells that may turn green. THESE ARE NOT INPUTS. It is a different shade of green and is only used as a check to ensure the final price on the Section B worksheet agrees with the summations pulled from the other worksheets.

Price Summary Worksheet

This worksheet is for Government analysis purposes. It is populated from the Labor Detail and ODC Detail worksheets.

Direct Labor Rate Schedule Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for price analysis and contract administration purposes.

Labor Detail Worksheet

NOTE 1: NOT USED.

NOTE 2: Column C of the Labor Detail worksheet contains several labor categories. During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a ‘P’ in column D if the effort is to be performed by the prime contractor and a ‘S’ if performed by another division or subcontractor. Enter the name of the division or subcontractor in column E. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the FTEs in column F and the hours in columns G and H for the individual category in column C for the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours provided by the Government for the respective labor category.

NOTE 3: For the purposes of this solicitation, the hours worked under a FTE shall consist of the hours worked by an individual employee and not multiple employees (i.e. 1 FTE = 1 employee). One FTE shall not be split among two or more employees.

NOTE 4: Do not modify the productive hour amounts in this column. The productive hours in this column are estimated productive hours that may or may not be ordered by the Government during the contract and are based on a 1,920 hour work year per FTE. Productive hours are the total hours in a work year less any days not actually worked (i.e. not including holidays, sick days, vacations, etc). Productive hours are hours that will actually be worked and billed to the contract. For the purposes of this solicitation please assume a 40 hour work week NOT to include overtime or uncompensated overtime.

NOTE 5: The hourly base pay rate copies over from the Direct Labor Rate Schedule. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. Escalation on wages in out years for Service Contract Act positions is unallowable except where the Collective Bargaining Agreement and/or Wage Determinations indicate otherwise.

NOTE 6a: Apply fringe to prime offeror derived rates. ‘Fringe Worksheet’ provides a sample to be used to compute the fringe rate. Provide a schedule and describe all elements included in the fringe benefit rate. Fringe shall include social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc). If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 6b: Apply overhead to prime offeror derived rates. ‘Overhead Worksheet’ provides a sample to be used to compute the overhead rate. Provide a schedule and describe all elements included in the overhead rate. If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 7: This field will automatically calculate the prime hourly burdened rate before the application of G&A and fee. If the prime is proposing the use of a subcontractor, please enter the subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime G&A expense and fixed fee. Therefore, the rate calculated for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in column k is as follows: rate = sub base rate + sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).

NOTE 8: Provide a schedule and describe the G&A rate pool, and allocation base. The rate will carry over from the Indirect Rate Summary.

ODC Detail Worksheet

(NOTE 10): Enter the requested data in the green shaded cells. An estimated normalized amount for other direct cost (ODC) and travel has been specified for proposal purposes for all periods. Each offeror is to include this amount in their proposal. Any material handling and/or G&A is to be applied as appropriate. Since this is an estimated amount that may or may not occur, no fixed fee will be authorized.

Indirect Rate Summary Worksheet

Please provide the indirect rates by year, and proposed percentage of performance by labor hour for the prime offeror and each division or subcontractor proposed to perform effort on this solicitation.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jul 7, 2021.