Technical Exhibit D - Pricing Spreadsheet 25 July 2018.xls
XLS spreadsheet 140 KB Posted
- Solicitation number
- W9115126QA045
About this file
This is a pricing spreadsheet template for labor, materials, and contractor manpower costs associated with a follow-on alarm monitoring services contract at Fort Hood, Texas (Solicitation W9115126QA045). The template is designed for offerors to complete detailed cost proposals across a base year plus four option years, with separate sections for phase-in and phase-out periods as applicable.
The spreadsheet structure requires offerors to identify skill categories and classify them as full-time (FT), full-time equivalent (FTE), or part-time (PT) personnel, then designate each position as exempt or non-exempt labor. Labor cost calculations include direct salary, fringe benefits (holidays, vacation, sick leave, H&W), payroll taxes (FICA at 7.65%, FUTA at 0.60%), SUTA, and workers' compensation, with offerors responsible for providing supporting documentation for SUTA and workers' compensation rates. The template also accommodates materials, supplies, equipment (with capitalization thresholds), contractor manpower reporting (CMR), general and administrative (G&A) costs, and profit margins. Key instructions specify that exempt labor must be cross-walked to Bureau of Labor Statistics skill categories and non-exempt labor to Department of Labor Wage Determinations, with labor escalation recommended for exempt employees in years beyond the first contract year. Offerors must submit completed spreadsheets for each option year accompanied by a pricing narrative, with all formulas verified for accuracy. Subcontractor labor costs require the same detailed treatment as prime contractor costs across all applicable columns.
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
Summary
| Period | Amount |
| Phase-in | $ - 0 |
| Base | $ - 0 |
| Option 1 | $ - 0 |
| Option 2 | $ - 0 |
| Option 3 | $ - 0 |
| Option 4 | $ - 0 |
| Phase-out | $ - 0 |
| TOTAL | $ - 0 |
Phase-in
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Base Year
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Option 1
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Option 2
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Option 3
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Option 4
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
Phase-out
| SOLICITATION NO.: | |||||||||||||||||||||
| TOTAL AVAILABLE HOURS: | 0 | TOTAL PRODUCTIVE HOURS: | 0 | ||||||||||||||||||
| FT/ | E or NE | NO. | AVAIL | NET PROD | HR SALARY | DIRECT | HOL,VAC, & | H&W | FICA | FUTA | SUTA | WORK COMP | WORK COMP | WORK COMP | TOTAL FRINGE | SUBTOTAL | G&A | TOTAL | PROFIT | GRAND | |
| LABOR CATEGORY | PT | EMP. | HOURS | HOURS | RATE | LABOR | SICK | $ 4.13 | 7.65% | 0.60% | CODE | RATE | AMOUNT | BURDEN | COST | COST | TOTAL | ||||
| EXEMPT LABOR | 2080 | 1864 | $ 7,000 | $ 9,000 | PER $100 | ||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| NON-EXEMPT LABOR | |||||||||||||||||||||
| Position #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #2 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| Position #3 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL NON-EXEMPT | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL LABOR | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
| MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | ||||||||||||||||||||
| Material Handling Fee To be filled out by offeror) | 0% | $ - 0 | |||||||||||||||||||
| No G&A/Profit or other OH allowed | |||||||||||||||||||||
| TOTAL MATERIALS/SUPPLIES/EQUIPMENT - CAP | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||
| CONTRACTOR MANPOWER REPORT (CMR) | |||||||||||||||||||||
| Skill Category #1 | FT | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| TOTAL CMR | - 0 | - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| GRAND TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| Fill in yellow boxes. | |||||||||||||||||||||
| Revised 3 JUN 2016 |
INSTRUCTIONS
| Instructions to Offeror: |
| (1) Offeror shall replace Skill Category #1, #2 and so forth with the skill category being proposed in column A. |
| (2) Offeror shall indicate FT for full time employee, FTE for full time equivalent or PT for part time employee in column B. |
| (3) Offeror shall identify each skill category as Exempt or Non-Exempt in column C. |
| (4) Available hours are all hours including holidays, vacation, and sick leave. |
| (5) Net productive hours are the available hours less any holiday, vacation, or sick leave allowed by the offeror. |
| (6) It is each individual offeror's responsibility to apply its own percentage rate for SUTA. |
| (7) SUTA and Workers' Compensation (WC) certificates shall be provided to support the SUTA & WC rates proposed on this spreadsheet. Also if General Liability is proposed separate from G&A the offeror shall provide its General Liability certificate for this proposed rate. |
| (8) If an offeror has an overhead rate it may insert the necessary columns to calculate the overhead. However, a narrative must be provided to support the proposed overhead rate. |
| (9) It is each individual offeror's responsibility to apply its own percentage rate for G&A. |
| (10) It is each individual offeror's responsibility to apply its own percentage rate for profit. |
| (11) Although formulas are provided in the spreadsheet cells it is the responsibility of the offeror to make sure all formulas are correct. |
| (12) Spreadsheets shall be completed for each option year. |
| (13) A pricing narrative shall accompany the spreadsheets. |
| (14) Any labor costs provided by a sub-contractor shall be proposed in detail on the spreadsheet just as the prime contractor would. This means that the sub-contractor shall fill in columns A through U. |
| (15) Since the Fair Labor Standards Act does not apply to exempt employees, escalation of labor for exempt employees/personnel for each contract year beyond the first is recommended. |
| (16) Exempt labor shall be cross-walked to a Bureau of labor Statistics skill category. |
| (17) Non-exempt labor shall be cross-walked to a Department of Labor Wage Determination skill category. |
File details come from the government source that posted it. Updated .