8. Labor Worksheet 2.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
JBMDL - Above and Underground Tank Maintenance and Repair
Solicitation number
FA448426R0016
Issued by

About this file

This is a Labor Worksheet pricing template for the AST & UST Tank Services contract (Solicitation No. FA448426R0016) at Joint Base McGuire-Dix-Lakehurst. The worksheet provides a standardized format for offerors to submit labor costs across a base year and four option years, with instructions to complete highlighted areas and round all figures to two decimal places.

The template covers two Service Contract Act (SCA) labor categories and one management position: SCA 23311 Fuel Distribution System Mechanic (sample rate $41.49/hour), SCA 23312 Fuel Distribution System Operator (sample rate $35.03/hour), and Site Supervisor (management, sample rates ranging from $50.00 to $70.00/hour across option years). For each position, offerors must provide productive hours (1,856 hours in the sample), overtime hours, paid vacation and holiday hours (168 hours), and other SCA/CBA-required paid leave (56 hours), totaling 2,080 hours worked annually. The worksheet calculates total gross annual wages, fringe benefits paid per hour (including non-taxable and taxable components), and applies tax adjustments for FICA, FUTI, SUTI, and Workers' Compensation at fixed percentages (7.65%, 0.08%, 3.39%, and 1.76% respectively). Final calculations include a 1% G&A markup and 1% profit margin, resulting in a loaded hourly wage that represents the fully-burdened cost per labor hour. All sample figures are provided for reference only, with offerors expected to propose their own rates based on prevailing wage requirements and market conditions.

View the file

Other files

Show all 13

On GovTribe

Work with this file

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

Text version

BASE YR Labor

Solicitation No.:FA448426R0016
Contract Title:AST & UST Tank Services
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act and Management for period of performance. Round to two decimal places.Note: The non-taxable fringe benefit is usally the H&W required by SCA purchased in a plan
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
SCA #Labor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther SCA/CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional Taxable"Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap $46,400 %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)Loaded Hourly Wage
0.07650.00080.03390.01761%1%
SCA
23311Fuel Distribution System Mechanic$41.491856$77,005.440$0.0016856224$9,293.762080$86,299.20$5.42$11,273.60$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,272.11$1,072.72$1,072.72$109,417.56$52.60
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.42$11,273.60$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,570.91$925.71$925.71$94,422.33$45.40

Grand total $199,843.03

Management/Admin
N/ASite Supervisor$50.001856$92,800.000$0.0016856224$11,200.002080$104,000.00$5.42$11,273.60$0.00$104,000.00$7,956.00$5.60$1,572.96$1,830.40$126,638.56$1,266.39$1,266.39$129,171.33$62.10
Grand total$126,638.56
* If this is H&W hours only are for 2080 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 YR 1 Labor

Solicitation No.:FA448426R0016
Contract Title:AST & UST Tank Services
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act and Management for period of performance. Round to two decimal places.Note: The non-taxable fringe benefit is usally the H&W required by SCA purchased in a plan
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
SCA #Labor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther SCA/CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional Taxable"Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap $46,400 %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)Loaded Hourly Wage
0.07650.00080.03390.01761%1%
SCA
23311Fuel Distribution System Mechanic$41.491856$77,005.440$0.0016856224$9,293.762080$86,299.20$5.42$11,273.60$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,272.11$1,072.72$1,072.72$109,417.56$52.60
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.42$11,273.60$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,570.91$925.71$925.71$94,422.33$45.40

Grand total $199,843.03

Management/Admin
N/ASite Supervisor$55.001856$102,080.000$0.0016856224$12,320.002080$114,400.00$5.42$11,273.60$0.00$114,400.00$8,751.60$5.60$1,572.96$2,013.44$138,017.20$1,380.17$1,380.17$140,777.54$67.68
Grand total$138,017.20
* If this is H&W hours only are for 2080 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 YR 2 Labor

Solicitation No.:FA448426R0016
Contract Title:AST & UST Tank Services
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act and Management for period of performance. Round to two decimal places.Note: The non-taxable fringe benefit is usally the H&W required by SCA purchased in a plan
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
SCA #Labor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther SCA/CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional Taxable"Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap $46,400 %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)Loaded Hourly Wage
0.07650.00080.03390.01761%1%
SCA
23311Fuel Distribution System Mechanic$41.491856$77,005.440$0.0016856224$9,293.762080$86,299.20$5.42$11,273.60$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,272.11$1,072.72$1,072.72$109,417.56$52.60
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.42$11,273.60$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,570.91$925.71$925.71$94,422.33$45.40

Grand total $199,843.03

Management/Admin
N/ASite Supervisor$60.001856$111,360.000$0.0016856224$13,440.002080$124,800.00$5.42$11,273.60$0.00$124,800.00$9,547.20$5.60$1,572.96$2,196.48$149,395.84$1,493.96$1,493.96$152,383.76$73.26
Grand total$149,395.84
* If this is H&W hours only are for 2080 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 YR 3 Labor

Solicitation No.:FA448426R0016
Contract Title:AST & UST Tank Services
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act and Management for period of performance. Round to two decimal places.Note: The non-taxable fringe benefit is usally the H&W required by SCA purchased in a plan
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
SCA #Labor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther SCA/CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional Taxable"Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap $46,400 %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)Loaded Hourly Wage
0.07650.00080.03390.01761%1%
SCA
23311Fuel Distribution System Mechanic$41.491856$77,005.440$0.0016856224$9,293.762080$86,299.20$5.42$11,273.60$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,272.11$1,072.72$1,072.72$109,417.56$52.60
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.42$11,273.60$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,570.91$925.71$925.71$94,422.33$45.40

Grand total $199,843.03

Management/Admin
N/ASite Supervisor$65.001856$120,640.000$0.0016856224$14,560.002080$135,200.00$5.42$11,273.60$0.00$135,200.00$10,342.80$5.60$1,572.96$2,379.52$160,774.48$1,607.74$1,607.74$163,989.97$78.84
Grand total$160,774.48
* If this is H&W hours only are for 2080 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 YR 4 Labor

Solicitation No.:FA448426R0016
Contract Title:AST & UST Tank Services
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act and Management for period of performance. Round to two decimal places.Note: The non-taxable fringe benefit is usally the H&W required by SCA purchased in a plan
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
SCA #Labor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther SCA/CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional Taxable"Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap $46,400 %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)Loaded Hourly Wage
0.07650.00080.03390.01761%1%
SCA
23311Fuel Distribution System Mechanic$41.491856$77,005.440$0.0016856224$9,293.762080$86,299.20$5.42$11,273.60$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,272.11$1,072.72$1,072.72$109,417.56$52.60
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.42$11,273.60$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,570.91$925.71$925.71$94,422.33$45.40

Grand total $199,843.03

Management/Admin
N/ASite Supervisor$70.001856$129,920.000$0.0016856224$15,680.002080$145,600.00$5.42$11,273.60$0.00$145,600.00$11,138.40$5.60$1,572.96$2,562.56$172,153.12$1,721.53$1,721.53$175,596.18$84.42
Grand total$172,153.12
* If this is H&W hours only are for 2080 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 .