Attch 6 - Labor Worksheet - Revised.xlsx
XLSX spreadsheet 45 KB Posted
- Solicitation number
- FA448426R0006
About this file
The document is a Labor Worksheet Excel template for Solicitation No. FA448426R0006 for Base Telecommunications System Services. The template provides a comprehensive framework for offerors to calculate labor costs, including hourly wage rates, productive and non-productive hours, fringe benefits, taxes, and overhead expenses. The worksheet is designed for four separate options and includes columns for tracking various labor-related financial components such as FICA, FUTI, SUTI, Workers' Compensation, General & Administrative (G&A) expenses, and profit calculations.
The associated federal contract opportunity is for telecommunications maintenance services at Joint Base McGuire-Dix-Lakehurst, NJ, issued by the Department of the Air Force Air Mobility Command. The requirements include providing personnel, equipment, and services to maintain base telecommunications systems, covering voice, video, and data services in a converged IP/UC/TDM architecture. The contract is a commercial acquisition with a base period from March 1-28, 2026, and four potential one-year option periods. It will be procured under NAICS code 517111 as a competitive 8(a) requirement, with prospective offerors required to be registered in the System for Award Management.
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.: | FA448426R0006 |
| 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. |
| 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 | ||
| 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% |
| $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 |
| $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 |
| $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 |
| $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 |
| $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 |
| * 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.: | FA448426R0006 |
| 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. |
| 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 | ||
| 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% |
| $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 |
| $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 |
| $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 |
| $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 |
| $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 |
| * 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.: | FA448426R0006 |
| 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. |
| 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 | ||
| 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% |
| $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 |
| $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 |
| $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 |
| $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 |
| $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 |
| * 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.: | FA448426R0006 |
| 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. |
| 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 | ||
| 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% |
| $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 |
| $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 |
| $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 |
| $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 |
| $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 |
| * 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.: | FA448426R0006 |
| 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. |
| 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 | ||
| 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% |
| $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 |
| $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 |
| $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 |
| $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 |
| $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 |
| * 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 .