MMPS_RFP_Amendment_2_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx
XLSX spreadsheet 190 KB Posted
- Attached to
- George C. Marshall Space Flight Center (MSFC) and Michoud Assembly Facility (MAF) Protective Services (MMPS)
- Solicitation number
- NNM17558047R
About this file
MMPS RFP Amendment 2 - NNM17558047R - Attachment L-1 MMPS Price Related Worksheets
View the file
Other files
Show all 26
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
Index Company XYZ, Inc.
Attachment L-1, MMPS Price Related Worksheets
| Tab | Title | Specific Instruction |
| Tab PA | Summary of Total Price | This table summarizes the total proposed price for the contract effort. The offeror should include all subcontract expense and other direct costs proposed. Note that the fully burdened direct labor price is automatically populated from the appropriate Tab PB with profit included. The proposed profit line included in the summary table should reflect the profit to be added to subcontract expense and other direct costs. |
| Tab PB | Summary of WYE, Hours and Dollars Proposed | This tab require manual input for proposed WYE by PWS. The offeror is required to select a labor type from the drop down list provided in column B. By selecting a labor type and inputting WYEs the worksheet will calculate hours and dollars depending on the input to Tabs PC and PD. |
| Tab PC | Summary of IDIQ Fully Burdened Rates (including Profit) | This tab maps the government identified labor categories to the offerors labor categories. In addition, the Offeror must provide the detail used to calculate its individually proposed fully burdened labor rates for each of the labor categories specified. The tab includes typical indirect categories (e.g. fringe, overhead, G&A) and profit. This tab develops the IDIQ Fully Burdened Rates. The rationale for composition of burden rates and basis of application is required in Tab PE. |
| Tab PD | Productive Factor | Specify the number of Productive Hours per WYE for each contract year. Specify in the notes area how the figure was calculated (e.g. 2080 hours per year - 100 hours vacation - 40 hours sick - 80 hours holiday = 1860 Productive hours). |
| Tab PE | Schedule of Overhead, G&A and Other Indirect Rates | This tab is designed to present a summary level computation for overhead, G&A and other indirect rates (material handling, and/or subcontract handling) proposed by the Offeror in accordance with its disclosed accounting practices. Provide a written explanation of the the the allocation base for each rate computed, (reference tab PE line 11, 25 and 38) |
| Tab PF | Fringe Benefits/Hourly H&W benefits | This tab requires input for development of the fringe rate, payroll additive rate and the fringe per hour calculation. |
| Tab PG | Phase-In | This tab summarizes proposed phase-in cost. |
| Tab PH | Staffing Approach | This tab requires input by the offeror designating the intended mix of offeror and subcontractors for each category by PWS by year. The Offeror may add columns to account for all members of their team. |
&F
Attachment L-1, &A &P
Tab PA
| Summary of Total Price | ||||||||
| MMPS | ||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Subtotal | Extension | Total | |
| WYE | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Fully Burdened Direct Labor with Profit | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Shift Premium & O.T. Premium | $0 | $0 | $0 |
| Subcontractor | $0 | $0 | $0 | |||||
| Subcontractor | $0 | $0 | $0 | |||||
| Other Direct Costs | ||||||||
| Vehicles | $0 | $0 | $0 | |||||
| Vendor Services - e.g. Locksmith, Shred | $0 | $0 | $0 | |||||
| Materials, Equipment, Supplies | $0 | $0 | $0 | |||||
| Uniforms | $0 | $0 | $0 | |||||
| Misc - Ammo, badging, etc.. | $0 | $0 | $0 | |||||
| G&A\Burden on ODC | $0 | $0 | $0 | |||||
| Profit on Premiums, Other Direct Costs and Burden | $0 | $0 | $0 | |||||
| Total Price | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| The accuracy of the total price is the responsibility of the Offeror. | ||||||||
| Provide a BOE detailing the estimates for ODC and Exempt Labor. |
&F
Attachment L-1, &A
Tab PB Summary of WYE, Hours, and Dollars Proposed
MMPS
| Year 1 - Base | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||
| WYE | Labor Type | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | |
| MSFC | Mapping | |||||||||||||||||||||
| Program Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Project Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Security Police Officer Captain | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Physical Security Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Technology Protection Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Emergency Management Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Training Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatch Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Physical Security Specialist– Investigator | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Subtotal MSFC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| MAF | ||||||||||||||||||||||
| Project Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Physical Security Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Training Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||
| Subtotal MAF | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| Year 1 - Base | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||
| HOURS | Labor Type | Total WYE | 2.1 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | |
| MSFC | ||||||||||||||||||||||
| Program Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Project Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Security Police Officer Captain | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Physical Security Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Technology Protection Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Emergency Management Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Training Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Security Police Officer Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Dispatch Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Physical Security Specialist – Investigator | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Subtotal MSFC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| MAF | ||||||||||||||||||||||
| Project Manager | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Security Police Officer Supervisor | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Physical Security Specialist – Investigator | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Physical Security Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Emergency Management Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Training Specialist | Exempt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| Subtotal MAF | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
| Year 1 - Base | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||
| Dollars | Labor Type | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | Total WYE | Total PWS 2 | Total PWS 3 | Total PWS 4 | |
| MSFC | ||||||||||||||||||||||
| Program Manager | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Project Manager | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Security Police Officer Captain | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Physical Security Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Technology Protection Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Emergency Management Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Training Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Security Police Officer Supervisor | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Dispatch Supervisor | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Physical Security Specialist – Investigator | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal MSFC | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
| MAF | ||||||||||||||||||||||
| Project Manager | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Security Police Officer Supervisor | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Physical Security Specialist – Investigator | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Physical Security Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Emergency Management Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Training Specialist | Exempt | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal MAF | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Note: Offeror are not to add any additional labor categories. | ||||||||||||||||||||||
| You must chose a labor type for the hours and dollars to generate automatically. |
&F
Attachment L-1, &A - Page &P
Tab PC Summary of IDIQ Fully Burdened Rates
MMPS
| Areas in Yellow require manual input other areas contain formulas that can be edited | |||||||||||
| Yr 1 | Burdens | Yr 1 | |||||||||
| NASA Labor Category | Offeror's Labor Category | Base DL Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | IDIQ FBR | |||
| Labor Type | Fringe $ | OH1 $ | OH2 $ | Subtotal | G&A $ | Total before Profit | Profit $ | ||||
| MSFC | |||||||||||
| Program Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Project Manager | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Security Police Officer Captain | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Technology Protection Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Dispatch Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 |
| MAF | |||||||||||
| Project Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Summary of IDIQ Fully Burdened Rates |
MMPS
| Areas in Yellow require manual input other areas contain formulas that can be edited | |||||||||||
| Escalation | Yr 2 | Burdens | Yr 2 | ||||||||
| NASA Labor Category | Offeror's Labor Category | 0.00% | Base DL Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | IDIQ FBR | ||
| Labor Type | Fringe $ | OH1 $ | OH2 $ | Subtotal | G&A $ | Total before Profit | Profit $ | ||||
| MSFC | |||||||||||
| Program Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Project Manager | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Security Police Officer Captain | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Technology Protection Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Dispatch Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 |
| MAF | |||||||||||
| Project Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Emergency Management Specialist | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Summary of IDIQ Fully Burdened Rates |
MMPS
| Areas in Yellow require manual input other areas contain formulas that can be edited | |||||||||||
| Escalation | Yr 3 | Burdens | Yr 3 | ||||||||
| NASA Labor Category | Offeror's Labor Category | 0.00% | Base DL Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | IDIQ FBR | ||
| Labor Type | Fringe $ | OH1 $ | OH2 $ | Subtotal | G&A $ | Total before Profit | Profit $ | ||||
| MSFC | |||||||||||
| Program Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Project Manager | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Security Police Officer Captain | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Technology Protection Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Dispatch Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| MAF | |||||||||||
| Project Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Emergency Management Specialist | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Summary of IDIQ Fully Burdened Rates |
MMPS
| Areas in Yellow require manual input other areas contain formulas that can be edited | |||||||||||
| Escalation | Yr 4 | Burdens | Yr 4 | ||||||||
| NASA Labor Category | Offeror's Labor Category | 0.00% | Base DL Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | IDIQ FBR | ||
| Labor Type | Fringe $ | OH1 $ | OH2 $ | Subtotal | G&A $ | Total before Profit | Profit $ | ||||
| MSFC | |||||||||||
| Program Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Project Manager | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Security Police Officer Captain | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Technology Protection Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Dispatch Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| MAF | |||||||||||
| Project Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Emergency Management Specialist | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Summary of IDIQ Fully Burdened Rates |
MMPS
| Areas in Yellow require manual input other areas contain formulas that can be edited | |||||||||||
| Escalation | Yr 5 | Burdens | Yr 5 | ||||||||
| NASA Labor Category | Offeror's Labor Category | 0.00% | Base DL Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | IDIQ FBR | ||
| Labor Type | Fringe $ | OH1 $ | OH2 $ | Subtotal | G&A $ | Total before Profit | Profit $ | ||||
| MSFC | |||||||||||
| Program Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Project Manager | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Security Police Officer Captain | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Technology Protection Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Emergency Management Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 316) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | Public Safety Dispatcher (SPFPA) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Dispatch Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | I&R /Personnel Sec Clerk (AFL-CIO) | MSFC CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| MAF | |||||||||||
| Project Manager | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Security Police Officer | Security Police Officer (Local 711) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Security Police Officer Supervisor | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Dispatcher | 01060 - Dispatcher, Motor Vehicle | SCLS | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Physical Security Specialist – Investigator | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Physical Security Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 | |
| Personnel Security Specialist | Identity Management Clerk(AFL-CIO) | MAF CBA | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
| Emergency Management Specialist | Exempt | $2.00 | $0.00 | $0.00 | $0.00 | $2.00 | $0.00 | $2.00 | $0.00 | $2.00 | |
| Training Specialist | Exempt | $1.00 | $0.00 | $0.00 | $0.00 | $1.00 | $0.00 | $1.00 | $0.00 | $1.00 |
&F
Attachment L-1, &A - Page &P
Tab PD Company XYZ, Inc.
Productive Factor
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
| Start | 5/1/17 | 5/1/18 | 5/1/19 | 5/1/20 | 5/1/21 | |
| End | 4/30/18 | 4/30/19 | 4/30/20 | 4/30/21 | 4/30/22 | |
| Hours in Contract Period | 2088 | 2088 | 2096 | 2088 | 2080 | |
| Select | ||||||
| Exempt Productive Factor | ||||||
| Less: | Holidays | |||||
| Sick | ||||||
| Vacation | ||||||
| Other | ||||||
| Exempt | 2088 | 2088 | 2096 | 2088 | 2080 |
| CBA Productive Factor | ||||||
| Less: | Holidays | 0 | ||||
| Sick | ||||||
| Vacation | ||||||
| Other | ||||||
| MSFC CBA | 2088 | 2088 | 2096 | 2088 | 2080 |
| CBA Productive Factor | ||||||
| Less: | Holidays | |||||
| Sick | ||||||
| Vacation | ||||||
| Other | ||||||
| MAF CBA | 2088 | 2088 | 2096 | 2088 | 2080 |
| SCA Productive Factor | ||||||
| Less: | Holidays | |||||
| Sick | ||||||
| Vacation | ||||||
| Other | ||||||
| SCLS | 2088 | 2088 | 2096 | 2088 | 2080 | |
| The above labor designations are linked to the Tab PA. The work hours will be generated from the information provided by each designation. |
| Notes: |
| Areas in Yellow Require Manual Input. |
&F
Attachment L-1 - &A
Tab PE Company XYZ, Inc.
| Schedule of Overhead, G&A and Other Indirect Rates | |||||
| Areas in Yellow Require Manual Input | |||||
| Offeror Fiscal Year | Contract Year | Period | Conversion in days | ||
| Begins | 10/1/16 | 5/1/17 | 1st Fiscal Yr | 212 | 58% |
| Ends | 9/30/17 | 4/30/18 | 2nd Fiscal Yr | 153 | 42% |
| G&A Basis: | Input Allocation Base Here | |||||||
| Historical | Historical | Projected | Projected | Projected | Projected | Projected | Projected | |
| Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | |
| 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |
| Pool | $1 | $1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Base | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 |
| This contract effort | ||||||||
| Other Forecasted effort | ||||||||
| Total Base | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 |
| Rate | 10.0% | 10.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
Conversion to Contractor FY Rate used in FBR 0.00% 0.00% 0.00% 0.00% 0.00%
| Overhead Basis: | Input Allocation Base Here | |||||||
| Historical | Historical | Projected | Projected | Projected | Projected | Projected | Projected | |
| Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | Quoter Fiscal Year | |
| 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2021 | |
| Pool | $1 | $1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Base | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 |
| This contract effort | ||||||||
| Other Forecasted effort | ||||||||
| Total Base | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 |
| Rate | 12.0% | 10.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| Conversion to Contractor FY | Rate used in FBR | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| Other Indirect Rate Basis: | Input Allocation Base Here | |||||||
| Historical | Historical | Projected | Projected | Projected | Projected | Projected | Projected | |
| Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | Offeror Fiscal Year | |
| 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2021 | |
| Pool | $1 | $1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Base | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Rate | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| Conversion to Contractor FY | Rate used in FBR | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| Instructions: |
| A - Include the Pool cost proposed by year |
| B - Include the allocation base cost for each indirect rate |
| C - Compute the Burden Rate percentage - this should be an automatic calculation. Changes to the formula are permitted in order to insure accuracy |
| Note: |
| The Offeror is responsible for completion of this form in its entirety. |
&F
Attachment L-1 - &A
Tab PF
| Fringe Benefits/Hourly H&W benefits | |||||
| Areas in Yellow Require Manual Input | |||||
| Company XYZ, Inc. | |||||
| Part A | |||||
| Fringe Benefits/Payroll Additives | |||||
| FRINGE RATE DEVELOPMENT | |||||
| REAL YEAR DOLLARS | |||||
| Pool Elements | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| GROUP HEALTH INSURANCE | |||||
| GROUP LIFE INSURANCE | |||||
| RETIREMENT | |||||
| SHORT TERM DISABILITY | |||||
| LONG TERM DISABILITY | |||||
| PROFESSIONAL LIABILITY INS. | |||||
| OTHER (SPECIFY) | |||||
| Employee Awards | |||||
| Health and Welfare | |||||
| Training | |||||
| Holidays | |||||
| Sick Leave | |||||
| Vacation/Personal Leave | |||||
| OTHER (SPECIFY) | |||||
| OTHER (SPECIFY) | |||||
| TOTAL EXPECTED COST OF FB | $0 | $0 | $0 | $0 | $0 |
| Base | |||||
| Projected Direct Labor Base this contract | $0 | $0 | $0 | $0 | $0 |
| Indirect (OH & GA) Labor Base | $0 | $0 | $0 | $0 | $0 |
| Other contracts Direct Labor Base | $0 | $0 | $0 | $0 | $0 |
| TOTAL LABOR BASE | $0 | $0 | $0 | $0 | $0 |
| Fringe Rate before Payroll Additive | 0% | 0% | 0% | 0% | 0% |
| Payroll Additive Rate | 0% | 0% | 0% | 0% | 0% |
| FRINGE BENEFIT RATE | 0% | 0% | 0% | 0% | 0% |
Please Describe the Labor Base: (e.g. 90% DL, 10% Indirect Labor)
Company XYZ, Inc.
| Part B | ||||||||
| Indicate Hourly Health & Welfare cost by Employee Category (per yr) | ||||||||
| * Please be sure to review CBA agreements when completing this form. | ||||||||
| TOTAL | ||||||||
| NASA Labor Category | # of | H&W - | Pension | Personal Leave | Other | Hourly* | ||
| WYE Year 1 | Health Ins | Plan | Vaction | Holidays | Benefits | H&W COST | ||
| MSFC | ||||||||
| Program Manager | ||||||||
| Project Manager | ||||||||
| Security Police Officer Captain | ||||||||
| Physical Security Specialist | ||||||||
| Technology Protection Specialist | ||||||||
| Emergency Management Specialist | ||||||||
| Training Specialist | ||||||||
| Security Police Officer | ||||||||
| Security Police Officer Supervisor | ||||||||
| Dispatcher | ||||||||
| Dispatch Supervisor | ||||||||
| Physical Security Specialist – Investigator | ||||||||
| Personnel Security Specialist | ||||||||
| MAF | ||||||||
| Project Manager | ||||||||
| Security Police Officer | ||||||||
| Security Police Officer Supervisor | ||||||||
| Dispatcher | ||||||||
| Physical Security Specialist -Investigator | ||||||||
| Physical Security Specialist | ||||||||
| Personnel Security Specialist | ||||||||
| Emergency Management Specialist | ||||||||
| Training Specialist |
&F
Attachment L-1 - &A &"Times New Roman,Bold"
Tab PG
| Company XYZ, Inc. |
| Phase-In Form (PIF) |
[ ] Prime Contractor: _____________
| Labor Hours | |
| Regular | |
| Total Hours | 0 |
| Labor Dollars | |
| Regular | |
| Total Phase-in Labor | $0 |
| Labor Burdens | |
| Fringe | |
| Labor Overhead | |
| Total Labor Burdens | $0 |
| ODC | |
| Travel | |
| Training | |
| Supplies, Material, & Equipment | |
| Other | |
| Total ODCs | $0 |
| Subtotal | $0 |
| G&A | |
| Fee | |
| TOTAL PHASE-IN | $0 |
| Less Company Investment | -$150,000 |
| TOTAL PHASE-IN | $150,000 |
&F
Attachment L-1 - &A
Tab PH
| STAFFING APPROACH WYE MATRIX | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||
| Total WYE Prime and Subs | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | PWS 2 | ||||||||||
| WYE | WYE | WYE | WYE | WYE | ||||||||||||||||
| Add Names of Prime and Subs | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total |
| MSFC | ||||||||||||||||||||
| Program Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Captain | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Technology Protection Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatch Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| MAF | ||||||||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | ||||||||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| STAFFING APPROACH WYE MATRIX | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||
| Total WYE Prime and Subs | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | PWS 3 | ||||||||||
| WYE | WYE | WYE | WYE | |||||||||||||||||
| Add Names of Prime and Subs | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | WYE | Total | Prime | Sub | Sub | Total | ||
| MSFC | Prime | Sub | Sub | |||||||||||||||||
| Program Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Captain | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatch Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Technology Protection Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| MAF | ||||||||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | ||||||||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| STAFFING APPROACH WYE MATRIX | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||
| Total WYE Prime and Subs | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | PWS 4 | ||||||||||
| WYE | WYE | WYE | WYE | WYE | ||||||||||||||||
| Add Names of Prime and Subs | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total | Prime | Sub | Sub | Total |
| MSFC | ||||||||||||||||||||
| Program Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Captain | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatch Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Technology Protection Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| MAF | ||||||||||||||||||||
| Project Manager | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Security Police Officer Supervisor | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Dispatcher | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist – Investigator | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Physical Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Personnel Security Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Emergency Management Specialist | ||||||||||||||||||||
| Training Specialist | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||
| Total WYE Prime and Subs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
&F
Attachment L-1 - &A - Page &P
File details come from the government source that posted it. Updated .