8. Labor Worksheet 2.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 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 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.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 |
| 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.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/A | Site Supervisor | $50.00 | 1856 | $92,800.00 | 0 | $0.00 | 168 | 56 | 224 | $11,200.00 | 2080 | $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 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.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 |
| 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.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/A | Site Supervisor | $55.00 | 1856 | $102,080.00 | 0 | $0.00 | 168 | 56 | 224 | $12,320.00 | 2080 | $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 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.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 |
| 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.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/A | Site Supervisor | $60.00 | 1856 | $111,360.00 | 0 | $0.00 | 168 | 56 | 224 | $13,440.00 | 2080 | $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 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.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 |
| 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.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/A | Site Supervisor | $65.00 | 1856 | $120,640.00 | 0 | $0.00 | 168 | 56 | 224 | $14,560.00 | 2080 | $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 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.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 |
| 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.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/A | Site Supervisor | $70.00 | 1856 | $129,920.00 | 0 | $0.00 | 168 | 56 | 224 | $15,680.00 | 2080 | $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 .