8. Labor Worksheet.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 is designed for offerors to propose labor rates and calculate fully-loaded hourly wages for Service Contract Act (SCA)-covered positions and management staff across a five-year contract period (Base Year plus four option years).

The worksheet requires offerors to populate labor categories, hourly wage rates, productive hours, overtime hours, paid leave, and fringe benefits for two SCA positions—Fuel Distribution System Mechanic (SCA 23311) and Fuel Distribution System Operator (SCA 23312)—plus a Site Supervisor management position. Each labor category shows 1,856 productive hours and 224 total paid non-productive hours annually for a total of 2,080 hours worked. The template calculates gross annual wages, fringe benefits (both non-taxable and taxable cash payments), and applies fixed tax percentages for FICA (7.65%), FUTI (0.08%), SUTI (3.39%), and Workers' Compensation (1.76%), plus 1% each for G&A and profit markups. The Site Supervisor hourly rate escalates across the option years from $50.00 (Base Year) to $70.00 (Option Year 4), while SCA labor rates remain constant. The resulting loaded hourly wages range from $45.53 to $84.55 depending on labor category and contract year.

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.55$11,544.00$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,542.51$1,075.43$1,075.43$109,693.37$52.74
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.55$11,544.00$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,841.31$928.41$928.41$94,698.14$45.53

Grand total $200,383.83

Management/Admin
N/ASite Supervisor$50.001856$92,800.000$0.0016856224$11,200.002080$104,000.00$5.55$11,544.00$0.00$104,000.00$7,956.00$5.60$1,572.96$1,830.40$126,908.96$1,269.09$1,269.09$129,447.14$62.23
Grand total$126,908.96
* 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.55$11,544.00$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,542.51$1,075.43$1,075.43$109,693.37$52.74
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.55$11,544.00$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,841.31$928.41$928.41$94,698.14$45.53

Grand total $200,383.83

Management/Admin
N/ASite Supervisor$55.001856$102,080.000$0.0016856224$12,320.002080$114,400.00$5.55$11,544.00$0.00$114,400.00$8,751.60$5.60$1,572.96$2,013.44$138,287.60$1,382.88$1,382.88$141,053.35$67.81
Grand total$138,287.60
* 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.55$11,544.00$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,542.51$1,075.43$1,075.43$109,693.37$52.74
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.55$11,544.00$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,841.31$928.41$928.41$94,698.14$45.53

Grand total $200,383.83

Management/Admin
N/ASite Supervisor$60.001856$111,360.000$0.0016856224$13,440.002080$124,800.00$5.55$11,544.00$0.00$124,800.00$9,547.20$5.60$1,572.96$2,196.48$149,666.24$1,496.66$1,496.66$152,659.56$73.39
Grand total$149,666.24
* 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.55$11,544.00$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,542.51$1,075.43$1,075.43$109,693.37$52.74
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.55$11,544.00$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,841.31$928.41$928.41$94,698.14$45.53

Grand total $200,383.83

Management/Admin
N/ASite Supervisor$65.001856$120,640.000$0.0016856224$14,560.002080$135,200.00$5.55$11,544.00$0.00$135,200.00$10,342.80$5.60$1,572.96$2,379.52$161,044.88$1,610.45$1,610.45$164,265.78$78.97
Grand total$161,044.88
* 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.55$11,544.00$0.00$86,299.20$6,601.89$5.60$1,572.96$1,518.87$107,542.51$1,075.43$1,075.43$109,693.37$52.74
23312Fuel Distribution System Operator$35.031856$65,015.680$0.0016856224$7,846.722080$72,862.40$5.55$11,544.00$0.00$72,862.40$5,573.97$5.60$1,572.96$1,282.38$92,841.31$928.41$928.41$94,698.14$45.53

Grand total $200,383.83

Management/Admin
N/ASite Supervisor$70.001856$129,920.000$0.0016856224$15,680.002080$145,600.00$5.55$11,544.00$0.00$145,600.00$11,138.40$5.60$1,572.96$2,562.56$172,423.52$1,724.24$1,724.24$175,871.99$84.55
Grand total$172,423.52
* 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 .