VLTD_RFP_J.1(b)_Attachment_4_Cost_Template_Workbook_101017.xlsx

XLSX spreadsheet 213 KB Posted

Attached to
Vertical Lift Technology Development - 80ARC018R0005 Federal contract opportunity
Solicitation number
80ARC018R0005
Issued by
National Aeronautics and Space Administration Ames Research Center

About this file

From the source

VLTD RFP J.1(b) Attachment 4 Cost Template Workbook

View the file

Other files for this federal contract opportunity

Other files attached to Vertical Lift Technology Development - 80ARC018R0005, newest first.
File Type Posted
Signed_SourceSelectionStatementVLTD_11.29.18.pdf PDF
SF_30,_80ARC018R0005-02.pdf PDF
80ARC018R0005,_Final_RFP_Q&A_Set_2.pdf PDF
80ARC018R0005,_Final_RFP_Q&A_Set_1.pdf PDF
SF_30,_80ARC018R0005-01.pdf PDF
VLTD_RFP_J.1(b)_Attachment_8_Past_Performance_Questionnaire.pdf PDF
VLTD_RFP_J.1(b)_Attachment_7_NF533M.pdf PDF
VLTD_RFP_J.1(a)_Attachment_6_Task_Order_Award_Procedures.pdf PDF
VLTD_Final_RFP_80ARC018R0005.pdf PDF
VLTD_RFP_J.1(b)_Attachment_3_JA038_Proposal_Cover_Sheet.docx DOCX document
VLTD_RFP_J.1(a)_Attachment_1_SOW_20171220.pdf PDF
VLTD_RFP_J.1(b)_Attachment_5_Estimated_Staffing_Matrix.pdf PDF
VLTD_RFP_J.1(b)_Attachment_6_NF533Q.pdf PDF
VLTD_RFP_J.1(b)_Attachment_2__DD1861.pdf PDF
VLTD_RFP_J.1(b)_Attachment_1_Form_CASB-CMF.pdf PDF
VLTD_RFP_J.1(a)_Attachment_2_CDRLs.pdf PDF
VLTD_RFP_J.1(b)_Attachment_9_Task_Order_to_be_awarded_upon_contract_award.pdf PDF
VLTD_RFP_J.1(a)_Attachment_5_DD254.pdf PDF
Show all 18

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.

Exhibit 1 Summary of Elements of Cost (Prime Offeror)

Proposing Entity: _________________________________________

Contract Year 1 Contract Year 2 Contract Year 3 Contract Year 4 Contract Year 5 Total

Productive Labor Hours
Prime- 0- 0- 0- 0- 0- 0
Subcontractor #1- 0
Subcontractor #2- 0
Total Productive Labor Hours- 0- 0- 0- 0- 0- 0
Direct Labor Costs (Prime only)$0$0$0$0$0$0
Fringe Benefits on Prime Labor- 0
Overhead on Prime Labor- 0
Subcontractor Total Cost and Fee:
Subcontractor #1- 0
Subcontractor #2- 0
Other Direct Costs:
Travel- 0
Other- 0
Total Other Direct Costs- 0- 0- 0- 0- 0- 0
Material and/or Subcontract Handling- 0
Subtotal- 0- 0- 0- 0- 0- 0
G&A Expense- 0
Total Cost$0$0$0$0$0$0
Fixed Fee- 0
Facilities Capital Cost of Money- 0
Total Cost Plus Fixed Fee$0$0$0$0$0$0

80ARC018R0005 J.1(b) Attachment 4 Exhibit 1

Page &P of &N

Exhibit 1a Summary of Elements of Cost (Major Subcontractors)

Proposing Entity: _________________________________________

Contract Year 1 Contract Year 2 Contract Year 3 Contract Year 4 Contract Year 5 Total

Productive Labor Hours - 0 - 0 - 0 - 0 - 0 - 0

Direct Labor Costs$0$0$0$0$0$0
Fringe Benefits- 0
Overhead- 0
Other Direct Costs- 0
Material and/or Subcontract Handling- 0
Subtotal- 0- 0- 0- 0- 0- 0
G&A Expense- 0
Total Cost$0$0$0$0$0$0
Fee or Profit- 0
Facilities Capital Cost of Money- 0
Total Cost and Fee/Profit$0$0$0$0$0$0

80ARC018R0005 J.1(b) Attachment 4 Exhibit 1a

Page &P of &N

Exhibit 2 Summary of Proposed Direct Labor Rates

[ ] Prime Contractor:
[ ] Major Subcontractor:

Year 1 Proposed Labor Rate

LABOR CATEGORY
Proposed Direct Labor Rates
NASA Standard Labor CategoryOfferor's CategoryYr2Yr3Yr4Yr5SourceStaffing
Example:
Proposed Escalation Percentage (%)3.2%3.0%3.0%3.0%Incumbent
Offeror's employee
Senior Aerospace EngineerEngineer IV$52.00$53.66$55.27$56.93$58.64Salary SurveyNew hire

Proposed Escalation Percentage (%)

Junior Aeronautical Engineer$0.00$0.00$0.00$0.00
Senior Aeronautical Engineer$0.00$0.00$0.00$0.00
Senior Human Factors Psychologist$0.00$0.00$0.00$0.00
Junior Computer Scientist$0.00$0.00$0.00$0.00
Senior Computer Scientist$0.00$0.00$0.00$0.00
Senior Systems/Mission Analyst$0.00$0.00$0.00$0.00
Senior Project Manager$0.00$0.00$0.00$0.00
Offeror shall remove examples when submitting its proposal.
The example is provided to demonstrate formatting and how the data is to be submitted. The data in the example is not real and should not be interpreted as such.
Summary of Proposed Direct Labor Rates
[ ] Prime Contractor:
[ ] Major Subcontractor:

Year 1 Base Period Proposed Labor Rate

LABOR CATEGORY
Proposed Direct Labor Rates
NASA Standard Labor CategoryOfferor's CategoryYr2Yr3Yr4Yr5SourceStaffing

Proposed Escalation Percentage (%)

GSFC IDIQ
Administrative Specialist II$0.00$0.00$0.00$0.00
Computer Operator II$0.00$0.00$0.00$0.00
Programmer Analyst/Developer II$0.00$0.00$0.00$0.00
Programmer Analyst/Developer III$0.00$0.00$0.00$0.00
Network Specialist III$0.00$0.00$0.00$0.00
Program Manager II$0.00$0.00$0.00$0.00
Technical Manager III$0.00$0.00$0.00$0.00
System Administrator I$0.00$0.00$0.00$0.00
System Administrator II$0.00$0.00$0.00$0.00
System Administrator III$0.00$0.00$0.00$0.00
Technical Writer III$0.00$0.00$0.00$0.00
Information Security Analyst III$0.00$0.00$0.00$0.00
Facilities Engineer I$0.00$0.00$0.00$0.00
Facilities Engineer 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$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

80ARC018R0005 J.1(b) Attachment 3 Exhibit 2

Exhibit 3

[ ] Prime Contractor:
[ ] Major Subcontractor:

DIRECT LABOR COST SUMMARY

Labor CategoryContract Year 1Contract Year 2Contract Year 3
Number of WYEs per YearTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor Cost
Junior Aeronautical Engineer1$ - 0$0$ - 0$0$ - 0$0
Senior Aeronautical Engineer1$ - 0$0$ - 0$0$ - 0$0
Senior Human Factors Psychologist1$ - 0$0$ - 0$0$ - 0$0
Junior Computer Scientist1$ - 0$0$ - 0$0$ - 0$0
Senior Computer Scientist1$ - 0$0$ - 0$0$ - 0$0
Senior Systems/Mission Analyst1$ - 0$0$ - 0$0$ - 0$0
Senior Project Manager1$ - 0$0$ - 0$0$ - 0$0
Total Labor Hours and Costs7- 0$0- 0$0- 0$0
Labor CategoryContract Year 4Contract Year 5
Number of WYEs per YearTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor Cost
Junior Aeronautical Engineer1$ - 0$0$ - 0$0
Senior Aeronautical Engineer1$ - 0$0$ - 0$0
Senior Human Factors Psychologist1$ - 0$0$ - 0$0
Junior Computer Scientist1$ - 0$0$ - 0$0
Senior Computer Scientist1$ - 0$0$ - 0$0
Senior Systems/Mission Analyst1$ - 0$0$ - 0$0
Senior Project Manager1$ - 0$0$ - 0$0
Total Labor Hours and Costs7- 0$0- 0$0
Hours in this exhibit should be direct productive labor hours. One productive WYE is defined as the total available hours for procductive work in a year (i.e., 52 weeks
x 40 hours/week = 2,080 hours), excluding overtime and less paid time off (vacation, sick leave, holiday, etc.)

80ARC018R0005 J.1(b) Attachment 4 Exhibit 3

Page &P of &N

Exhibit 4 Summary of Indirect Cost Rates

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: __________________________________
Fringe Benefits*OverheadG&A
Example:
Portion of Contractor FY 13 From: _11/1/12_ to _4/30/13_46.00%4.50%7.00%
Portion of Contractor FY 14 From: _5/1/13_ to _10/31/1344.00%3.50%5.00%
Base Period Weighted Average45.00%4.00%6.00%
Contract Year 1
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Base Period Average
Contract Year 2
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 1 Average
Contract Year 3
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 2 Average
Contract Year 4
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 3 Average
Contract Year 5
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 4 Average
* Disregard if it is your normal accounting practice to
include fringe benefits with overhead.
Offeror shall remove examples when submitting its proposal.
The example is provided to demonstrate formatting and how the data is to be submitted. The data in the example is not real and should not be interpreted as such.

80ARC018R0005 J.1(b) Attachment 4 Exhibit 4

Page &P of &N

Exhibit 5 Overhead and/or Fringe Benefits (Composition of Burden Pool)

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: _________________________________Overhead or Service Center Pool* = ___________________
Base of Application = __________________________

* Specify Type of Overhead Burden: Fringe Benefits, Labor, Onsite, Offsite, Engineering, Procurement, Service Center(s), etc.

OFFEROR'S FISCAL YEAR BEGINS ____________ AND ENDS ____________.

ActualForecast
Prior Yr 3Prior Year 2Prior Yr 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20xx20xx20xx20xx20xx20xx20xx20xx20xx
Payroll Taxes
FICA (Social Security)
HIT (Medicare)
FUI (Federal Unemployment)
SUI (State Unemployment)
WC (Workers Comp)
Fringes:
Retirement
Health/Life Insurance
Paid Leave
Other
Other (Identify)
Facilities
Depreciation
Total Overhead Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Application Base ($)
Contractor FY Rate (%)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

80ARC018R0005 J.1(b) Attachment 4 Exhibit 5

Page &P of &N

Exhibit 6 General and Administrative Expense (G&A)

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: _________________________________Base of Application = __________________________

OFFEROR'S FISCAL YEAR BEGINS ____________ AND ENDS ____________.

ActualForecast
Prior Yr 3Prior Year 2Prior Yr 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20xx20xx20xx20xx20xx20xx20xx20xx20xx

Labor: (Identify)

Labor Related Cost: (Taxes & Fringes Etc.)

B&P
IR&D
Corporate Allocations:
Other (Specify):
Facilities
Depreciation
Total G&A Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Distribution Base Dollars:
Existing Business Base
This Contract Base
Forecasted Business Base
Total Distribution Base $$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Calculated G&A Rates (%)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

80ARC018R0005 J.1(b) Attachment 4 Exhibit 6

Page &P of &N

Exhibit 7 Prime Contractor:

MINOR SUBCONTRACTORS

Minor SubcontractorNASA Standard Labor Category
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5
HoursSFBRTotalHoursSFBRTotalHoursSFBRTotalHoursSFBRTotalHoursSFBRTotal
Examples:
XYZ CompanyEngineer 31,395$85.00$118,5751,395$87.55$120,9471,395$90.18$123,3651,395$92.89$125,8331,395$95.68$128,349
Technician 21,395$56.00$78,1201,395$57.68$79,6821,395$59.41$81,2761,395$61.19$82,9021,395$63.03$84,560
Safety Manager930$79.00$73,470450$81.37$36,261- 0$83.81$0- 0$86.32$0- 0$88.91$0
Technician 33,720$58.00$215,7601,500$59.74$88,740- 0$61.53$0- 0$63.38$0- 0$65.28$212,909
Total XYZ:7,440$485,9254,740$325,6302,790$204,6412,790$208,7342,790$425,818
ABC Tool & DieEngineer 11,860$44.00$81,8401,860$45.32$84,2951,860$46.68$86,8251,860$48.08$89,4291,860$49.52$92,107
Technician 33,720$62.00$230,6401,395$63.86$89,085- 0$65.78$0- 0$67.75$0- 0$69.78$0
Safety Manager930$71.00$66,030450$73.13$32,909- 0$75.32$0- 0$77.58$0- 0$79.91$0
Total ABC:6,510$378,5103,705$206,2891,860$86,8251,860$89,4291,860$92,107
$173,650
Offeror shall remove examples when submitting its proposal.
The example is provided to demonstrate formatting and how the data is to be submitted. The data in the example is not real and should not be interpreted as such.

80ARC018R0005 J.1(b) Attachment 4 Exhibit 7

Page &P of &N

Exhibit 8 Schedule of Subcontracts

[ ] Prime Contractor: ______________________________________

Description of Work:

Number of quotes solicted/received
Subcontractor selected:Subcontract (1) Name and AddressSubcontract (2) Name and AddressSubcontract (3) Name and AddressSubcontract (4) Name and Address

Basis of Selection:*

Type of Subcontract:**

Cost
Fee/Profit
Total Amount Proposed$ - 0$ - 0$ - 0$ - 0
Affiliation with Prime:***

Cost/Price Analysis Performed by Prime:****

* Lowest price, teaming partner, technical qualifications, etc.
** FFP, CPAF, CPFF, T&M, etc.
*** Subcontractor, subsidiary, interdivisional, etc.
**** FAR 15.404-3(b) requires that contractors conduct appropriate cost or price analyses to establish the reasonableness of proposed subcontract prices
and include the results of these analyses in the price proposal. If response above is "No", explain why cost or price analyis was not performed and how
the Offeror determined that the proposed subcontract price was reasonable.

80ARC018R0005 Attachment J.1(b)4 Exhibit 8

Page &P of &N

File details come from the government source that posted it.