Attachment_BreakdownWorksheet_W912C320R0001-RecycleServices-20200219.xls

XLS spreadsheet 135 KB Posted Feb 19, 2020

Attached to: Amendment 0007 issued to incorporate attachment. Solicitation receipt date remains unchanged: March 5, 2020; 10:00 am local PR time - Recycling Services at Fort Buchanan, Puerto Rico.
Solicitation number: W912C3-20-R-0001
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort Hood

About this file

Written by GovTribe AI · Dec 28, 2023

This spreadsheet template is for a federal solicitation seeking recycling services at Fort Buchanan in Puerto Rico. The Mission and Installation Contracting Command at Fort Buchanan is soliciting proposals for recycling services through firm-fixed price contracts. Offerors must provide all labor, personnel, equipment, supplies, facilities, transportation, tools, materials, permits, supervision and any other items necessary to perform recycling services. The North American Industry Classification System code is 562920 for this 100% small business set-aside requirement. Offerors must fill out the spreadsheet template providing labor categories, hours, wages, and fringe benefit rates to calculate pricing for the base period and four option years. Instructions are included for completing the template and additional documentation such as SUTA and workers' compensation certificates may be required.

View the file

Other files

File	Type	Posted
Amendment 0007-W912C320R0001-Recycling-20200219.pdf	PDF	Feb 19, 2020
Amend0006-W912C320R0001-Recycling-20200213.pdf	PDF	Feb 13, 2020
Amendment 0004 - W912C320R0001.pdf	PDF	Jan 15, 2020
Amend0005-W912C320R0001-Recycling-20200114.pdf	PDF	Jan 15, 2020
Amendment 0003 - W912C320R0001.pdf	PDF	Dec 20, 2019
Amendment 0002-W912C320R0001-Recycling-20191216.pdf	PDF	Dec 16, 2019
Amendment0001-W912C320R0001-Recycling-20191205.pdf	PDF	Dec 5, 2019
Solicitation _W912C320R0001_RecycleServices_20191121.pdf	PDF	Nov 21, 2019

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.

0001 BASE PERIOD

SOLICITATION NO.:	W912C320R0001, RECYCLING
TOTAL AVAILABLE HOURS:						TOTAL PRODUCTIVE HOURS:
	FT/	NO.	AVAIL	NET PROD	HR SALARY	TOTAL	H&W	FICA	FUTA	STATE UN	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	WAGES		7.65%	0.60%	0.64%	0.30%	CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
CLIN 0001
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0002
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0003
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 0004
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0005
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0006
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0007
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 0008
CONTRACTOR MANPOWER REPORT
Skill Category #4	PT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL ALL LABOR
OTHER DIRECT COST (ODC):
Supplies																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&CBy CLIN Spreadsheet

1001 FIRST PERIOD

SOLICITATION NO.:	W912C320R0001, RECYCLING
TOTAL AVAILABLE HOURS:						TOTAL PRODUCTIVE HOURS:
	FT/	NO.	AVAIL	NET PROD	HR SALARY	TOTAL	H&W	FICA	FUTA	STATE UN	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	WAGES		7.65%	0.60%	0.64%	0.30%	CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
CLIN 1001
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 1002
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 1003
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 1004
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 1005
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 1006
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 1007
CONTRACTOR MANPOWER REPORT
Skill Category #4	PT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL ALL LABOR
OTHER DIRECT COST (ODC):
Supplies																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&CBy CLIN Spreadsheet

2001 SECOND OPTION

SOLICITATION NO.:	W912C320R0001, RECYCLING
TOTAL AVAILABLE HOURS:						TOTAL PRODUCTIVE HOURS:
	FT/	NO.	AVAIL	NET PROD	HR SALARY	TOTAL	H&W	FICA	FUTA	STATE UN	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	WAGES		7.65%	0.60%	0.64%	0.30%	CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
CLIN 2001									$ 7,000	$ 7,000	$ 9,000	7219-320	PER $100
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 2002
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 2003
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 2004
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 2005
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 2006
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 2007
CONTRACTOR MANPOWER REPORT
Skill Category #4	PT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL ALL LABOR
OTHER DIRECT COST (ODC):
Supplies																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&CBy CLIN Spreadsheet

3001 THIRD OPTION

SOLICITATION NO.:	W912C320R0001, RECYCLING
TOTAL AVAILABLE HOURS:						TOTAL PRODUCTIVE HOURS:
	FT/	NO.	AVAIL	NET PROD	HR SALARY	TOTAL	H&W	FICA	FUTA	STATE UN	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	WAGES		7.65%	0.60%	0.64%	0.30%	CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
CLIN 3001
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 3002
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 3003
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 3004
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 3005
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 3006
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 3007
CONTRACTOR MANPOWER REPORT
Skill Category #4	PT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL ALL LABOR
OTHER DIRECT COST (ODC):
Supplies																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&CBy CLIN Spreadsheet

4001 FOURTH OPTION

SOLICITATION NO.:	W912C320R0001, RECYCLING
TOTAL AVAILABLE HOURS:						TOTAL PRODUCTIVE HOURS:
	FT/	NO.	AVAIL	NET PROD	HR SALARY	TOTAL	H&W	FICA	FUTA	STATE UN	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	WAGES		7.65%	0.60%	0.64%	0.30%	CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
CLIN 4001									$ 7,000	$ 7,000	$ 9,000	7219-320	PER $100
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 4002
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 4003
EXEMPT
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
CLIN 4004
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 4005
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 4006
EXEMPT:
Position #1	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #2	FT	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0
CLIN 4007
CONTRACTOR MANPOWER REPORT
Skill Category #4	PT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0
TOTAL ALL LABOR
OTHER DIRECT COST (ODC):
Supplies																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0		$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&CBy CLIN Spreadsheet

INSTRUCTIONS

(1) Offeror needs to replace Skill Category #1, #2 and so forth with the skill category being proposed in column A.

(2) Offeror needs to indicate FT for full time employee, FTE for full time equivalent or PT for part time employee in column B

(3) Available hours are all hours including holidays and vacation.

(4) Net productive hours are the available hours less any holiday or vacation allowed by the offeror.

(5) SUTA rate shown in column K on this spreadsheet is for sample spreadsheet estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for SUTA.

(6) SUTA and Workers' Compensation (WC) certificates need to be provided to support the SUTA & WC rates proposed on this spreadsheet. Also if General Liability is proposed separate from G&A we need the General Liability certificate for this proposed rate.

(7) If an offeror has an overhead rate it may insert the necessary columns to calculate the overhead. However, a narrative must be provided to support the proposed overhead rate.

(8) G&A rate shown in column Q on this spreadsheet is for estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for G&A.

(9) Profit rate shown in column S on this spreadsheet is for estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for profit.

(10) Although formulas are provided in the spreadsheet cells it is the responsibility of the offeror to make sure all formulas are correct.

(11) Spreadsheets must be completed for each option year.

(12) A pricing narrative should accompany the spreadsheets.

(13) Any labor costs provided by a sub-contractor need to be proposed in detail on the spreadsheet just as the prime contractor would. This means that the sub-contractor needs to fill in columns A through T.

File details come from the government source that posted it. Updated Feb 19, 2020.