Attch 6 - Labor Worksheet.xlsx
XLSX spreadsheet 51 KB Posted
- Solicitation number
- FA448426R0006
About this file
This is a Labor Worksheet Excel template for multiple contract opportunities, primarily for Base Telecommunications System Services and one for Lakehurst Vehicle Maintenance. The template is designed for offerors to fill out detailed labor cost information, including hourly wage rates, productive and non-productive hours, fringe benefits, and various tax calculations for different Contract Line Item Numbers (CLINs).
The worksheet includes columns for calculating total hours worked, gross annual wages, fringe benefits, and various tax components such as FICA, FUTI, SUTI, and Workers' Compensation. The template provides spaces for five different options or contract periods, with sample rows for offerors to input their specific labor category rates and hours. The related federal contract opportunity is for Base Telecommunications System Maintenance at Joint Base McGuire-Dix-Lakehurst, NJ, with a base period from March 1-28, 2026, and four additional one-year option periods, classified under NAICS code 517111 and expected to be issued as a competitive 8(a) requirement.
View the file
Other files
Show all 21
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
| Solicitation No.: | |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| CLIN | Labor Category | 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 | 1% | 1% |
| 0001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 0001 | |||||||||||||||||
| 0001 |
| * 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.: | FA448420R0011 |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| 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 | 1% | 1% |
| 1001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 1001 | |||||||||||||||||
| 1001 |
| * 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.: | FA448419RA020 |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| 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 | 1% | 1% |
| 2001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2001 | |||||||||||||||||
| 2001 |
| * 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.: | FA448420R0011 |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| 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 | 1% | 1% |
| 3001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 3001 | |||||||||||||||||
| 3001 |
| * 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.: | FA448420R0011 |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| 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 | 1% | 1% |
| 4001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 4001 | |||||||||||||||||
| 4001 |
| * 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.: | FA448420R0011 |
| 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 | |||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | O | Q | R | S | T | U | V | W | X | Y | |||
| 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 | 1% | 1% |
| 5001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5001 | $0.00 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 5001 | |||||||||||||||||
| 5001 |
| * 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 .