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
Issued by

About this file

MMPS RFP Amendment 2 - NNM17558047R - Attachment L-1 MMPS Price Related Worksheets

View the file

Other files

File Type Posted
MMPS_Source_Selection_Statement.pdf PDF
MMPS_RFP_Amendment_3_-_NNM17558047R.docx DOCX document
MMPS_RFP_Amendment_2_-_NNM17558047R.docx DOCX document
MMPS_RFP_Amendment_1_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx XLSX spreadsheet
MMPS_RFP_Amendment_1_-_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx XLSX spreadsheet
MMPS_RFP_Amendment_1_-_NNM17558047R.docx DOCX document
MMPS_RFP_-_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx XLSX spreadsheet
MMPS_RFP_-_NNM17558047R_Attachment_L-4A_-_MSFC_Security_Police_Officers_CBA.PDF PDF
MMPS_RFP_-_NNM17558047R_-_MMPS_SF1449_Phase-In_PO.pdf PDF
MMPS_RFP_-_NNM17558047R_Attachment_L-4C_-_MSFC_ID_Registration_and_Personnel_Security_Clerks_CBA.PDF PDF
MMPS_RFP_-_NNM17558047R.docx DOCX document
MMPS_RFP_-_NNM17558047R_Attachment_L-4E_-_MAF_Identity_Management_Clerks_CBA.PDF PDF
MMPS_RFP_-_NNM17558047R_Attachment_L-4B_-_MSFC_Public_Safety_Dispatchers_CBA.PDF PDF
MMPS_RFP_-_NNM17558047R_Attachment_L-4D_-_MAF_Security_Police_Officers_CBA.PDF PDF
MMPS_RFP_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx XLSX spreadsheet
MMPS_Industry_Day_Virtual_Meeting_Attendees.xlsx XLSX spreadsheet
MMPS_Industry_Day_Virtual_Meeting_charts_12052016.pdf PDF
MMPS_DRFP_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx XLSX spreadsheet
MMPS_DRFP_NNM17558047R_-_MMPS_DRFP.docx DOCX document
MMPS_DRFP_NNM17558047R_Attachment_J-7B_-_MSFC_Public_Safety_Dispatchers_CBA.PDF PDF
MMPS_DRFP_NNM17558047R_Attachment_J-7A_-_MSFC_Security_Police_Officers_CBA.PDF PDF
MMPS_DRFP_NNM17558047R_Attachment_J-7E_-_MAF_Identity_Management_Clerks_CBA.pdf PDF
MMPS_DRFP_NNM17558047R_Attachment_J-7D_-_MAF_Security_Police_Officers_CBA.PDF PDF
MMPS_DRFP_NNM17558047R_-_MMPS_SF1449_Phase-In_PO.pdf PDF
MMPS_DRFP_NNM17558047R_Attachment_J-7C_-_MSFC_ID_Registration_and_Personnel_Security_Clerks_CBA.PDF PDF
MMPS_DRFP_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx XLSX spreadsheet
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

TabTitleSpecific Instruction
Tab PASummary of Total PriceThis 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 PBSummary of WYE, Hours and Dollars ProposedThis 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 PCSummary 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 PDProductive FactorSpecify 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 PESchedule of Overhead, G&A and Other Indirect RatesThis 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 PFFringe Benefits/Hourly H&W benefitsThis tab requires input for development of the fringe rate, payroll additive rate and the fringe per hour calculation.
Tab PGPhase-InThis tab summarizes proposed phase-in cost.
Tab PHStaffing ApproachThis 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 1Year 2Year 3Year 4Year 5SubtotalExtensionTotal
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 - BaseYear 2Year 3Year 4Year 5
WYELabor TypeTotal WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4
MSFCMapping
Program ManagerExempt- 0- 0- 0- 0- 0
Project ManagerExempt- 0- 0- 0- 0- 0
Security Police Officer CaptainExempt- 0- 0- 0- 0- 0
Physical Security SpecialistExempt- 0- 0- 0- 0- 0
Technology Protection SpecialistExempt- 0- 0- 0- 0- 0
Emergency Management SpecialistExempt- 0- 0- 0- 0- 0
Training SpecialistExempt- 0- 0- 0- 0- 0
Security Police OfficerSecurity Police Officer (Local 316)MSFC CBA- 0- 0- 0- 0- 0
Security Police Officer SupervisorExempt- 0- 0- 0- 0- 0
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA- 0- 0- 0- 0- 0
Dispatch SupervisorExempt- 0- 0- 0- 0- 0
Physical Security Specialist– InvestigatorExempt- 0- 0- 0- 0- 0
Personnel Security SpecialistI&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 ManagerExempt- 0- 0- 0- 0- 0
Security Police OfficerSecurity Police Officer (Local 711)MAF CBA- 0- 0- 0- 0- 0
Security Police Officer SupervisorExempt- 0- 0- 0- 0- 0
Dispatcher01060 - Dispatcher, Motor VehicleSCLS- 0- 0- 0- 0- 0
Physical Security Specialist – InvestigatorExempt- 0- 0- 0- 0- 0
Physical Security SpecialistExempt- 0- 0- 0- 0- 0
Personnel Security SpecialistIdentity Management Clerk(AFL-CIO)MAF CBA- 0- 0- 0- 0- 0
Emergency Management SpecialistExempt- 0- 0- 0- 0- 0
Training SpecialistExempt- 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 - BaseYear 2Year 3Year 4Year 5
HOURSLabor TypeTotal WYE2.1Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4
MSFC
Program ManagerExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project ManagerExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Police Officer CaptainExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Physical Security SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technology Protection SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Emergency Management SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Training SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Police OfficerSecurity 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 SupervisorExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
DispatcherPublic 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 SupervisorExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Physical Security Specialist – InvestigatorExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Personnel Security SpecialistI&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 ManagerExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Police OfficerSecurity 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 SupervisorExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Dispatcher01060 - Dispatcher, Motor VehicleSCLS- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Physical Security Specialist – InvestigatorExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Physical Security SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Personnel Security SpecialistIdentity 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 SpecialistExempt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Training SpecialistExempt- 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 - BaseYear 2Year 3Year 4Year 5
DollarsLabor TypeTotal WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4Total WYETotal PWS 2Total PWS 3Total PWS 4
MSFC
Program ManagerExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Project ManagerExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Security Police Officer CaptainExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Physical Security SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Technology Protection SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Emergency Management SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Training SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Security Police OfficerSecurity 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 SupervisorExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
DispatcherPublic 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 SupervisorExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Physical Security Specialist – InvestigatorExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Personnel Security SpecialistI&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 ManagerExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Security Police OfficerSecurity 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 SupervisorExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Physical Security Specialist – InvestigatorExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Physical Security SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Personnel Security SpecialistIdentity 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 SpecialistExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Training SpecialistExempt$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 1BurdensYr 1
NASA Labor CategoryOfferor's Labor CategoryBase DL Rate0.00%0.00%0.00%0.00%0.00%IDIQ FBR
Labor TypeFringe $OH1 $OH2 $SubtotalG&A $Total before ProfitProfit $
MSFC
Program ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Project ManagerExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Security Police Officer CaptainExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Technology Protection SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Emergency Management SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatch SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistI&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 ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistIdentity 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 SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$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
EscalationYr 2BurdensYr 2
NASA Labor CategoryOfferor's Labor Category0.00%Base DL Rate0.00%0.00%0.00%0.00%0.00%IDIQ FBR
Labor TypeFringe $OH1 $OH2 $SubtotalG&A $Total before ProfitProfit $
MSFC
Program ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Project ManagerExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Security Police Officer CaptainExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Technology Protection SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Emergency Management SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatch SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistI&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 ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistIdentity 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 SpecialistExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Training SpecialistExempt$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
EscalationYr 3BurdensYr 3
NASA Labor CategoryOfferor's Labor Category0.00%Base DL Rate0.00%0.00%0.00%0.00%0.00%IDIQ FBR
Labor TypeFringe $OH1 $OH2 $SubtotalG&A $Total before ProfitProfit $
MSFC
Program ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Project ManagerExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Security Police Officer CaptainExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Technology Protection SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Emergency Management SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatch SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistI&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 ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistIdentity 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 SpecialistExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Training SpecialistExempt$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
EscalationYr 4BurdensYr 4
NASA Labor CategoryOfferor's Labor Category0.00%Base DL Rate0.00%0.00%0.00%0.00%0.00%IDIQ FBR
Labor TypeFringe $OH1 $OH2 $SubtotalG&A $Total before ProfitProfit $
MSFC
Program ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Project ManagerExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Security Police Officer CaptainExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Technology Protection SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Emergency Management SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatch SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistI&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 ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistIdentity 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 SpecialistExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Training SpecialistExempt$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
EscalationYr 5BurdensYr 5
NASA Labor CategoryOfferor's Labor Category0.00%Base DL Rate0.00%0.00%0.00%0.00%0.00%IDIQ FBR
Labor TypeFringe $OH1 $OH2 $SubtotalG&A $Total before ProfitProfit $
MSFC
Program ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Project ManagerExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Security Police Officer CaptainExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Technology Protection SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Emergency Management SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Training SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
DispatcherPublic Safety Dispatcher (SPFPA)MSFC CBA$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatch SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistI&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 ManagerExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Security Police OfficerSecurity 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 SupervisorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Dispatcher01060 - Dispatcher, Motor VehicleSCLS$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security Specialist – InvestigatorExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Physical Security SpecialistExempt$1.00$0.00$0.00$0.00$1.00$0.00$1.00$0.00$1.00
Personnel Security SpecialistIdentity 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 SpecialistExempt$2.00$0.00$0.00$0.00$2.00$0.00$2.00$0.00$2.00
Training SpecialistExempt$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 1Year 2Year 3Year 4Year 5
Start5/1/175/1/185/1/195/1/205/1/21
End4/30/184/30/194/30/204/30/214/30/22
Hours in Contract Period20882088209620882080
Select
Exempt Productive Factor
Less:Holidays
Sick
Vacation
Other
Exempt20882088209620882080
CBA Productive Factor
Less:Holidays0
Sick
Vacation
Other
MSFC CBA20882088209620882080
CBA Productive Factor
Less:Holidays
Sick
Vacation
Other
MAF CBA20882088209620882080
SCA Productive Factor
Less:Holidays
Sick
Vacation
Other
SCLS20882088209620882080
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 YearContract YearPeriodConversion in days
Begins10/1/165/1/171st Fiscal Yr21258%
Ends9/30/174/30/182nd Fiscal Yr15342%
G&A Basis:Input Allocation Base Here
HistoricalHistoricalProjectedProjectedProjectedProjectedProjectedProjected
Offeror Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal Year
20152016201720182019202020212022
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
Rate10.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
HistoricalHistoricalProjectedProjectedProjectedProjectedProjectedProjected
Quoter Fiscal YearQuoter Fiscal YearQuoter Fiscal YearQuoter Fiscal YearQuoter Fiscal YearQuoter Fiscal YearQuoter Fiscal YearQuoter Fiscal Year
20152016201720182019202020212021
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
Rate12.0%10.0%0.0%0.0%0.0%0.0%0.0%0.0%
Conversion to Contractor FYRate used in FBR0.00%0.00%0.00%0.00%0.00%
Other Indirect Rate Basis:Input Allocation Base Here
HistoricalHistoricalProjectedProjectedProjectedProjectedProjectedProjected
Offeror Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal YearOfferor Fiscal Year
20152016201720182019202020212021
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
Rate0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
Conversion to Contractor FYRate used in FBR0.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 ElementsYear 1Year 2Year 3Year 4Year 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 Additive0%0%0%0%0%
Payroll Additive Rate0%0%0%0%0%
FRINGE BENEFIT RATE0%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# ofH&W -PensionPersonal LeaveOtherHourly*
WYE Year 1Health InsPlanVactionHolidaysBenefitsH&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 Hours0
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 MATRIXYear 1Year 2Year 3Year 4Year 5
Total WYE Prime and SubsPWS 2PWS 2PWS 2PWS 2PWS 2PWS 2PWS 2PWS 2PWS 2PWS 2
WYEWYEWYEWYEWYE
Add Names of Prime and SubsPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotal
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 MATRIXYear 1Year 2Year 3Year 4Year 5
Total WYE Prime and SubsPWS 3PWS 3PWS 3PWS 3PWS 3PWS 3PWS 3PWS 3PWS 3PWS 3
WYEWYEWYEWYE
Add Names of Prime and SubsPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotalWYETotalPrimeSubSubTotal
MSFCPrimeSubSub
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 MATRIXYear 1Year 2Year 3Year 4Year 5
Total WYE Prime and SubsPWS 4PWS 4PWS 4PWS 4PWS 4PWS 4PWS 4PWS 4PWS 4PWS 4
WYEWYEWYEWYEWYE
Add Names of Prime and SubsPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotalPrimeSubSubTotal
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 .