8. Labor Worksheet.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- FA448426R0016
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 Adjustment | Taxes | ||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | ||||
| SCA # | Labor Categorey | Hourly Wage Rate | Productive Hours | Subtotal | OT Hours | Subtotal | Paid Vacation and holiday Hours | Other SCA/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 Taxable"Cash Payment" of FB | Total " Wages" and "FB Paid in Cash"**** | % FICA | Cap $7,000 / % FUTI | NJ Cap $46,400 %SUTI | W/C % | Sub TOTAL | G&A | Profit | TOTAL (V+W+X) | Loaded Hourly Wage |
| 0.0765 | 0.0008 | 0.0339 | 0.0176 | 1% | 1% | ||||||||||||||||||||
| SCA | |||||||||||||||||||||||||
| 23311 | Fuel Distribution System Mechanic | $41.49 | 1856 | $77,005.44 | 0 | $0.00 | 168 | 56 | 224 | $9,293.76 | 2080 | $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 |
| 23312 | Fuel Distribution System Operator | $35.03 | 1856 | $65,015.68 | 0 | $0.00 | 168 | 56 | 224 | $7,846.72 | 2080 | $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/A | Site Supervisor | $50.00 | 1856 | $92,800.00 | 0 | $0.00 | 168 | 56 | 224 | $11,200.00 | 2080 | $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 Adjustment | Taxes | ||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | ||||
| SCA # | Labor Categorey | Hourly Wage Rate | Productive Hours | Subtotal | OT Hours | Subtotal | Paid Vacation and holiday Hours | Other SCA/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 Taxable"Cash Payment" of FB | Total " Wages" and "FB Paid in Cash"**** | % FICA | Cap $7,000 / % FUTI | NJ Cap $46,400 %SUTI | W/C % | Sub TOTAL | G&A | Profit | TOTAL (V+W+X) | Loaded Hourly Wage |
| 0.0765 | 0.0008 | 0.0339 | 0.0176 | 1% | 1% | ||||||||||||||||||||
| SCA | |||||||||||||||||||||||||
| 23311 | Fuel Distribution System Mechanic | $41.49 | 1856 | $77,005.44 | 0 | $0.00 | 168 | 56 | 224 | $9,293.76 | 2080 | $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 |
| 23312 | Fuel Distribution System Operator | $35.03 | 1856 | $65,015.68 | 0 | $0.00 | 168 | 56 | 224 | $7,846.72 | 2080 | $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/A | Site Supervisor | $55.00 | 1856 | $102,080.00 | 0 | $0.00 | 168 | 56 | 224 | $12,320.00 | 2080 | $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 Adjustment | Taxes | ||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | ||||
| SCA # | Labor Categorey | Hourly Wage Rate | Productive Hours | Subtotal | OT Hours | Subtotal | Paid Vacation and holiday Hours | Other SCA/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 Taxable"Cash Payment" of FB | Total " Wages" and "FB Paid in Cash"**** | % FICA | Cap $7,000 / % FUTI | NJ Cap $46,400 %SUTI | W/C % | Sub TOTAL | G&A | Profit | TOTAL (V+W+X) | Loaded Hourly Wage |
| 0.0765 | 0.0008 | 0.0339 | 0.0176 | 1% | 1% | ||||||||||||||||||||
| SCA | |||||||||||||||||||||||||
| 23311 | Fuel Distribution System Mechanic | $41.49 | 1856 | $77,005.44 | 0 | $0.00 | 168 | 56 | 224 | $9,293.76 | 2080 | $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 |
| 23312 | Fuel Distribution System Operator | $35.03 | 1856 | $65,015.68 | 0 | $0.00 | 168 | 56 | 224 | $7,846.72 | 2080 | $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/A | Site Supervisor | $60.00 | 1856 | $111,360.00 | 0 | $0.00 | 168 | 56 | 224 | $13,440.00 | 2080 | $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 Adjustment | Taxes | ||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | ||||
| SCA # | Labor Categorey | Hourly Wage Rate | Productive Hours | Subtotal | OT Hours | Subtotal | Paid Vacation and holiday Hours | Other SCA/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 Taxable"Cash Payment" of FB | Total " Wages" and "FB Paid in Cash"**** | % FICA | Cap $7,000 / % FUTI | NJ Cap $46,400 %SUTI | W/C % | Sub TOTAL | G&A | Profit | TOTAL (V+W+X) | Loaded Hourly Wage |
| 0.0765 | 0.0008 | 0.0339 | 0.0176 | 1% | 1% | ||||||||||||||||||||
| SCA | |||||||||||||||||||||||||
| 23311 | Fuel Distribution System Mechanic | $41.49 | 1856 | $77,005.44 | 0 | $0.00 | 168 | 56 | 224 | $9,293.76 | 2080 | $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 |
| 23312 | Fuel Distribution System Operator | $35.03 | 1856 | $65,015.68 | 0 | $0.00 | 168 | 56 | 224 | $7,846.72 | 2080 | $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/A | Site Supervisor | $65.00 | 1856 | $120,640.00 | 0 | $0.00 | 168 | 56 | 224 | $14,560.00 | 2080 | $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 Adjustment | Taxes | ||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | ||||
| SCA # | Labor Categorey | Hourly Wage Rate | Productive Hours | Subtotal | OT Hours | Subtotal | Paid Vacation and holiday Hours | Other SCA/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 Taxable"Cash Payment" of FB | Total " Wages" and "FB Paid in Cash"**** | % FICA | Cap $7,000 / % FUTI | NJ Cap $46,400 %SUTI | W/C % | Sub TOTAL | G&A | Profit | TOTAL (V+W+X) | Loaded Hourly Wage |
| 0.0765 | 0.0008 | 0.0339 | 0.0176 | 1% | 1% | ||||||||||||||||||||
| SCA | |||||||||||||||||||||||||
| 23311 | Fuel Distribution System Mechanic | $41.49 | 1856 | $77,005.44 | 0 | $0.00 | 168 | 56 | 224 | $9,293.76 | 2080 | $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 |
| 23312 | Fuel Distribution System Operator | $35.03 | 1856 | $65,015.68 | 0 | $0.00 | 168 | 56 | 224 | $7,846.72 | 2080 | $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/A | Site Supervisor | $70.00 | 1856 | $129,920.00 | 0 | $0.00 | 168 | 56 | 224 | $15,680.00 | 2080 | $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 .