Attch 5 - Labor Worksheet 1.xlsx

XLSX spreadsheet 41 KB Posted Nov 24, 2020

Attached to: JBMDL Base Telecommunications Systems Services Federal contract opportunity
Solicitation number: FA448421R0004
Issued by: Department of the Air Force Air Mobility Command

View the file

Other files for this federal contract opportunity

Other files attached to JBMDL Base Telecommunications Systems Services, newest first.
File	Type	Posted
Attch 12 - DBA NJ20200001 Burlington - Ocean County NJ.pdf	PDF	Dec 3, 2020
Questions and Answers BTS FA448421R0004.pdf	PDF	Dec 3, 2020
Solicitation Amendment FA448421R00040001 SF 30.pdf	PDF	Nov 24, 2020
Attch 2 - Quality Assurance Surveillance Plan 1.doc	DOC document	Nov 24, 2020
Attch 3 - Past Performance Questionnaire.docx	DOCX document	Oct 28, 2020
Attch 4 - List of Provisions.docx	DOCX document	Oct 28, 2020
Attch 5 - Labor Worksheet.xlsx	XLSX spreadsheet	Oct 28, 2020
Attch 6 - Fillable Pricing Table.xls	XLS spreadsheet	Oct 28, 2020
Attch 8 - Anti-Terrorism Guide.pdf	PDF	Oct 28, 2020
Attch 1 - Performance Work Statement 26 Jun 20.docx	DOCX document	Oct 28, 2020
Attch 7 - Security Forces Appendix.pdf	PDF	Oct 28, 2020
Solicitation - FA448421R0004.pdf	PDF	Oct 28, 2020
Attch 10 - WD Burlington County 2015-4191 Rev 12 dated 21 April 2020.pdf	PDF	Oct 28, 2020
Attch 11 - WD Ocean County 2015-4195 Rev 12 dated 21 April 2020.pdf	PDF	Oct 28, 2020
Attch 2 - Quality Assurance Surveillance Plan.doc	DOC document	Oct 28, 2020
Attch 9 - EIPS.docx	DOCX document	Oct 28, 2020

Show all 16

On GovTribe

Work with this file on GovTribe

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

Try for free Login

Text version

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

BASE YR

Solicitation No.:	FA448421R0004
Contract Title:	Base Telecommunications System Services
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

0001	Administrative Assistant	2000	$0.00	0	$0.00	80	0	$0.00	2000	$0.00	$4.41	$8,820.00	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,629.60	$96.30	$96.30	$9,822.19
0001	Cable Splicer (Burlington County)	2000	$0.00	0	$0.00	80	0	$0.00	2000	$0.00	$4.41	$8,820.00	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,629.60	$96.30	$96.30	$9,822.19
0001	Cable Splicer (Ocean County)	2000	$0.00	0	$0.00	80	0	$0.00	2000	$0.00	$4.41	$8,820.00	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,629.60	$96.30	$96.30	$9,822.19
0001	Telecommunications Mechanic I (Burlington County)	2000	$0.00	0	$0.00	80	0	$0.00	2000	$0.00	$4.41	$8,820.00	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,629.60	$96.30	$96.30	$9,822.19
0001	Telecommunications Mechanic I (Ocean County)	2000	$0.00	0	$0.00	80	0	$0.00	2000	$0.00	$4.41	$8,820.00	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,629.60	$96.30	$96.30	$9,822.19
0001	Telecomminications Mechanic II (Burlington County)
0001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

Page &P

Option 1

Solicitation No.:	FA448421R0004
Contract Title:	Base Telecommunications System Services
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

1001	Administrative Assistant	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
1001	Cable Splicer (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
1001	Cable Splicer (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
1001	Telecommunications Mechanic I (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
1001	Telecommunications Mechanic I (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
1001	Telecomminications Mechanic II (Burlington County)
1001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

Option 2

Solicitation No.:	FA448421R0004
Contract Title:	Lakehurst Vehicle Maintenance
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

2001	Administrative Assistant	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
2001	Cable Splicer (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
2001	Cable Splicer (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
2001	Telecommunications Mechanic I (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
2001	Telecommunications Mechanic I (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
2001	Telecomminications Mechanic II (Burlington County)
2001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

Option 3

Solicitation No.:	FA448421R0004
Contract Title:	Base Telecommunications System Services
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

3001	Administrative Assistant	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
3001	Cable Splicer (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
3001	Cable Splicer (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
3001	Telecommunications Mechanic I (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
3001	Telecommunications Mechanic I (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
3001	Telecomminications Mechanic II (Burlington County)
3001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

Option 4

Solicitation No.:	FA448421R0004
Contract Title:	Base Telecommunications System Services
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

4001	Administrative Assistant	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
4001	Cable Splicer (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
4001	Cable Splicer (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
4001	Telecommunications Mechanic I (Burlington County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
4001	Telecommunications Mechanic I (Ocean County)	2000	$0.00	0	$0.00	80	0	80	$0.00	2080	$0.00	$4.41	$9,172.80	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$9,982.40	$99.82	$99.82	$10,182.05
4001	Telecomminications Mechanic II (Burlington County)
4001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

6 Month Extension

Solicitation No.:	FA448421R0004
Contract Title:	Base Telecommunications System Services
Date:
Instructions:	Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.

Note:

The numbers below are a sample. Offerors should propose their rates.

Fringe Benefit Adjustment

Taxes

CLIN

Labor Categorey

Hourly Wage Rate

Productive Hours

Subtotal

OT Hours

Subtotal

Paid Vacation and holiday Hours

Other CBA-required Paid Leave

Total Paid non-Productive hours

Subtotal

Total Hours Worked

Total Gross Annual Wages**

Fringe Benefits (FB) Paid "Per Hour"

Non Taxable Subtotal

Additional "Cash Payment" of FB

Total " Wages" and "FB Paid in Cash"****

% FICA

Cap $7,000 / % FUTI

NJ Cap 33,500/ %SUTI

W/C %

Sub TOTAL

G&A

Profit

TOTAL (V+W+X)

0.0765

0.0008

0.024

0.0165

5001	Administrative Assistant	1000	$0.00	0	$0.00	40	0	40	$0.00	1040	$0.00	$4.41	$4,586.40	$0.00	$0.00	$0.00	$5.60	$0.00	$0.00	$4,592.00	$45.92	$45.92	$4,683.84
5001	Cable Splicer (Burlington County)	1000	$0.00	0	$0.00	40	0	40	$0.00	1040	$0.00	$4.41	$4,586.40	$0.00	$0.00	$0.00	$5.60	$804.00	$0.00	$5,396.00	$53.96	$53.96	$5,503.92
5001	Cable Splicer (Ocean County)	1000	$0.00	0	$0.00	40	0	40	$0.00	1040	$0.00	$4.41	$4,586.40	$0.00	$0.00	$0.00	$5.60	$0.00	$0.00	$4,592.00	$45.92	$45.92	$4,683.84
5001	Telecommunications Mechanic I (Burlington County)	1000	$0.00	0	$0.00	40	0	40	$0.00	1040	$0.00	$4.41	$4,586.40	$0.00	$0.00	$0.00	$5.60	$0.00	$0.00	$4,592.00	$45.92	$45.92	$4,683.84
5001	Telecommunications Mechanic I (Ocean County)	1000	$0.00	0	$0.00	40	0	40	$0.00	1040	$0.00	$4.41	$4,586.40	$0.00	$0.00	$0.00	$5.60	$0.00	$0.00	$4,592.00	$45.92	$45.92	$4,683.84
5001	Telecomminications Mechanic II (Burlington County)
5001	Telecommunications Mechanic II (Ocean County)

* If this is H&W hours if paid in a plan, the prices are not taxable.

** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.

*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.

**** Used this figure to calculate added tax if FB are paid in cash to employee.

File details come from the government source that posted it. Updated Nov 24, 2020.