Amended CASS II RFP - Section L Attachment L-1 - Excel Pricing Model.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Center Administrative Support Services (CASS II) - RFP Amendment P00003 Federal contract opportunity
Solicitation number
80MSFC20R0009
Issued by
National Aeronautics and Space Administration Marshall Space Flight Center

View the file

Other files for this federal contract opportunity

Other files attached to Center Administrative Support Services (CASS II) - RFP Amendment P00003, newest first.
File Type Posted
CASS II - Amendment 003 (executed).pdf PDF
FINAL RFP Amendment 003 11.05.2020.docx DOCX document
040. Amendment 002 - 80MSFC20R0009P00002 10.30.2020 Signed.pdf PDF
015. Amended Attachment L-5 - CASS II Forecasted Workforce Distro Chart.docx DOCX document
SF1449 with continuation sheet.pdf PDF
Amendment 002 - 80MSFC20R0009P00002 10.30.2020.pdf PDF
Purchase Order 80MSFC20P0045 SF 1449.pdf PDF
FINAL RFP Amendment 002 for Review 10.30.2020.docx DOCX document
Amendment 1 - CASS II - 80MSFC20R0009P00001 10.23.2020.pdf PDF
CASS II Virtual Industry Day - Presentation Slides 09.30.20.pptx PPTX presentation
Virtual Industry Day Registration Participants.xlsx XLSX spreadsheet
CASS II RFP - Section L Attachment L-1 - Excel Pricing Model (EPM) DIA.xlsx XLSX spreadsheet
CASS II RFP - Section L Attachment L-1 - Excel Pricing Model (EPM) DIALocked.xlsx XLSX spreadsheet
FINAL CASS II RFP 80MSFC20R0009_.pdf PDF
Attachment L-1 - CASS II RFP - Section L Attachment L-1 - Excel Pricing Model (EPM) DIA.xlsx XLSX spreadsheet
Show all 15

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

INDEX

Index
Tab PASummary of Total Evaluated Price - CASS IIThis tab is designed to summarize the total price (Mission Services and IDIQ) for the entire contract effort. Offerors shall input the applicable burden rate(s) to be applied to the IDIQ other direct costs (ODCs) (i.e., travel and training). ODC burden rates shall not include profit. This tab is linked to other tabs within the workbook. Most of this tab will automatically fill in once the other tabs have been completed. The NASA-provided ODC values are pre-populated in this tab. Offerors shall fill in the areas highlighted in yellow.

Tab PB Computation of Fixed Price Labor by PWS This tab is used to calculate the fully burdened labor dollars using the proposed WYEs multiplied by the proposed fully burdened labor rates (provided in Tab PC) and the productive factor generated from the available hours for each contract period. The worksheet automatically calculates hours and dollars from other tabs completed within this workbook. Offerors shall fill in the areas highlighted in yellow.

Offerors must fill in the holiday, sick, and vacation hours in order for the tab to calculate the productive factors.

Tab PC Summary of Proposed Fully Burdened Labor Rates (including Profit) applied to IDIQ Hours This tab summarizes proposed fully burdened labor rates (FBR) by labor category. Offerors are required to provide the detail (i.e., base labor rate per hour, indirect rates per hour (including overhead and fringes), G&A rate per hour and profit per hour) used to calculate their individually proposed fully burdened labor rate for each labor category specified, by year. The NASA-provided IDIQ labor hours are pre-populated in columns AB through AF. Columns AH through AL compute the IDIQ price by year that is linked to the summary sheet, Tab PA. These rates must include all anticipated subcontract rates as well as the offeror's handling and profit rates. Offerors shall fill in the areas highlighted in yellow.

Offerors shall populate the fully burdened labor rates from these tables into Attachment J-4, Schedule of Fully Burdened IDIQ Labor Burden Rates.

Tab PA Company Name Summary of Total Evaluated Price - CASS II

Price ElementsBase YearOption 1Option 2Option 3Option 4Total
Total WYE70.270.270.270.270.2351.0
Fully Burdened Labor (Mission Services Price)$0$0$0$0$0$0
IDIQ Other Direct Costs (ODCs)
Travel and Training$20,000$20,000$20,000$20,000$20,000
Burden %0.00%0.00%0.00%0.00%0.00%
Burden Amount$0$0$0$0$0$0
Total IDIQ ODC Burdens$0$0$0$0$0$0
Total Mission Services Price + IDIQ ODC Burdens$0$0$0$0$0$0

Total IDIQ Labor Computed $0 $0 $0 $0 $0 $0

Total Evaluated Price $0 $0 $0 $0 $0 $0

Areas in Yellow Require Manual Input

Tab PB

Company NameSummary by PWS
Labor WYE, Hours and Dollars by PWS
Base YearOption 1Option 2Option 3Option 4
Start of the contract period04/01/2104/01/2204/01/2304/01/2404/01/25
End of contract period03/31/2203/31/2303/31/2403/31/2503/31/26
Hours in a Contract Year20882088208020882088
Less Indirect Hrs (paid time off (PTO), holiday, other)- 0- 0- 0- 0- 0Areas in Yellow Require Manual Input
Productive Exempt HoursEXEMPT20882088208020882088
Less Indirect Hrs (paid time off (PTO), holiday, other)- 0- 0- 0- 0- 0
Productive Service Contract Labor Standards (SCLS) HoursSCA20882088208020882088
Year 1WYEYear 2WYEYear 3WYEYear 4WYEYear 5WYE
Year 1TotalPWSPWSTotalPWSPWSTotalPWSPWSTotalPWSPWSTotalPWSPWS
Labor CategoriesTypeWYE1.02.0WYE1.02.0WYE1.02.0WYE1.02.0WYE1.02.0
Program ManagerExempt1.01.01.01.01.01.01.01.01.01.0
Secretary IISCA33.0- 033.033.0- 033.033.0- 033.033.0- 033.033.0- 033.0
Secretary IIISCA22.0- 022.022.0- 022.022.0- 022.022.0- 022.022.0- 022.0
Secretary II - MAFSCA1.0- 01.01.0- 01.01.0- 01.01.0- 01.01.0- 01.0
Secretary III - MAFSCA1.0- 01.01.0- 01.01.0- 01.01.0- 01.01.0- 01.0
Executive Assistant ISCA1.0- 01.01.0- 01.01.0- 01.01.0- 01.01.0- 01.0
Executive Assistant IIExempt2.0- 02.02.0- 02.02.0- 02.02.0- 02.02.0- 02.0
Personnel Assistant IIISCA1.2- 01.21.2- 01.21.2- 01.21.2- 01.21.2- 01.2
Administrative Specialist IExempt7.0- 07.07.0- 07.07.0- 07.07.0- 07.07.0- 07.0
Secretary/Administrative Specialist Combination - MAFExempt1.0- 01.01.0- 01.01.0- 01.01.0- 01.01.0- 01.0
Total70.21.069.270.21.069.270.21.069.270.21.069.270.21.069.2
HoursHoursHoursHoursHoursHours
Year 1TotalPWSPWSTotalPWSPWSTotalPWSPWSTotalPWSPWSTotalPWSPWS
Labor CategoriesTypeHours1.02.0Hours1.02.0Hours1.02.0Hours1.02.0Hours1.02.0
Program ManagerExempt2,088.02,088.0- 02,088.02,088.0- 02,080.02,080.0- 02,088.02,088.0- 02,088.02,088.0- 0
Secretary IISCA68,904.0- 068,904.068,904.0- 068,904.068,640.0- 068,640.068,904.0- 068,904.068,904.0- 068,904.0
Secretary IIISCA45,936.0- 045,936.045,936.0- 045,936.045,760.0- 045,760.045,936.0- 045,936.045,936.0- 045,936.0
Secretary II - MAFSCA2,088.0- 02,088.02,088.0- 02,088.02,080.0- 02,080.02,088.0- 02,088.02,088.0- 02,088.0
Secretary III - MAFSCA2,088.0- 02,088.02,088.0- 02,088.02,080.0- 02,080.02,088.0- 02,088.02,088.0- 02,088.0
Executive Assistant ISCA2,088.0- 02,088.02,088.0- 02,088.02,080.0- 02,080.02,088.0- 02,088.02,088.0- 02,088.0
Executive Assistant IIExempt4,176.0- 04,176.04,176.0- 04,176.04,160.0- 04,160.04,176.0- 04,176.04,176.0- 04,176.0
Personnel Assistant IIISCA2,505.6- 02,505.62,505.6- 02,505.62,496.0- 02,496.02,505.6- 02,505.62,505.6- 02,505.6
Administrative Specialist IExempt14,616.0- 014,616.014,616.0- 014,616.014,560.0- 014,560.014,616.0- 014,616.014,616.0- 014,616.0
Secretary/Administrative Specialist Combination - MAFExempt2,088.0- 02,088.02,088.0- 02,088.02,080.0- 02,080.02,088.0- 02,088.02,088.0- 02,088.0
Total146,577.62,088.0144,489.6146,577.62,088.0144,489.6146,016.02,080.0143,936.0146,577.62,088.0144,489.6146,577.62,088.0144,489.6
DollarsDollarsDollarsDollarsDollarsDollarsDollars
Year 1PWSPWSPWSPWSPWSPWSPWSPWSPWSPWS
Labor CategoriesTypeDollars1.02.0Dollars1.02.0Dollars1.02.0Dollars1.02.0Dollars1.02.0
Program ManagerExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Secretary IISCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Secretary IIISCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Secretary II - MAFSCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Secretary III - MAFSCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Executive Assistant ISCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Executive Assistant IIExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Personnel Assistant IIISCA$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Administrative Specialist IExempt$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Secretary/Administrative Specialist Combination - MAFExempt$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

TAB PC

Company Name
Summary of Proposed Fully Burdened Labor Rates (including Profit) applied to IDIQ Hours
Fully Burdened Labor RatesIDIQ Hours provided by NASAIDIQ Labor Computed
Base YearFully Burdened RateOption Year 1Fully Burdened RateOption Year 2Fully Burdened RateOption Year 3Fully Burdened RateOption Year 4Fully Burdened RateBase YearOption 1Option 2Option 3Option 4Base YearOption 1Option 2Option 3Option 4
Base DL Rate per HrIndirect Rate per HrG&A per HrProfit Per HrBase DL Rate per HrIndirect Rate per HrG&A per HrProfit Per HrBase DL Rate per HrIndirect Rate per HrG&A per HrProfit Per HrBase DL Rate per HrIndirect Rate per HrG&A per HrProfit Per HrBase DL Rate per HrIndirect Rate per HrG&A per HrProfit Per Hr
Program Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Secretary II$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Secretary III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Secretary II - MAF$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Secretary III - MAF$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Executive Assistant I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Executive Assistant II$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Personnel Assistant III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Administrative Specialist I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Secretary/Administrative Specialist Combination - MAF$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
General Clerk I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00100100100100100$0$0$0$0$0
Secretary I$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00100100100100100$0$0$0$0$0
Executive Assistant III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00100100100100100$0$0$0$0$0
Personnel Assistant II$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00100100100100100$0$0$0$0$0
Administrative Specialist III$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00100100100100100$0$0$0$0$0
$0$0$0$0$0
Areas in Yellow Require Manual Input
Note: The Government-provided pre-populated IDIQ hours are provided only as a means of establishing a total evaluated price for evaluation purposes. Offerors shall ensure that fully-burdened labor rates are provided for all labor categories, for all periods (i.e., years of performance).

File details come from the government source that posted it. Updated .