J.1 (b) Attachment 1 Cost Price Template (ASRS).xlsx

XLSX spreadsheet 69 KB Posted

Attached to
Aviation Safety Reporting System (ASRS) and Related Systems Federal contract opportunity
Solicitation number
80ARC023R0002
Issued by
National Aeronautics and Space Administration Ames Research Center

View the file

Other files for this federal contract opportunity

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

Text version

Exhibit 1 Proposing Entity:

SUMMARY OF PROPOSED PRICE

CLINDescriptionContract TypeProposed CostFixed Fee/ProfitFCCMTotal Cost/Price
0001Phase-in (from Exhibit 12)CPFF$ - 0--$ -
BASE PERIOD
0002ASRS Core Requirements - Contract Mgmt, ASRS, C3RS - Year 1 & 2 (from Exhibit 2)CPFF$ 149,480--$ 149,480
OPTION PERIOD 1
0003ASRS Core Requirements - Contract Mgmt, ASRS, C3RS - Year 3 & 4 (from Exhibit 2)CPFF$ 155,520--$ 155,520
OPTION PERIOD 2
0004ASRS Core Requirements - Contract Mgmt, ASRS, C3RS - Year 5 (from Exhibit 2)CPFF$ 80,100--$ 80,100
FAR 52.217-8 Pricing Assuming Not to Exceed Six Month Extension
FAR 52.217-8ASRS Core Requirements - Contract Mgmt, ASRS, C3RS - 1/2 of Year 5 (Exhibit 2)CPFF$ 40,050--$ 40,050
Total Evaluated Cost/Price for Selection Purposes (before probable cost adjustments)*$ 425,150

* Note: A cost/price evaluation will be conducted in accordance with FAR 15.305(a)(1) and NFS 1815.305(a)(1)(B). Total evaluated cost/price for selection purposes will be the amount in Cell G17, plus any probable cost adjustments from the FAR 15.305 (a)(1) proposal evaluation. No probable cost adjustments will be made to proposed Phase-in cost.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 1

Exhibit 2

Summary of Elements of Cost - ASRS Core Requirements - Contract Management, ASRS, C3RS (CPFF) (Required of Prime Offeror Only)
Proposing Entity: ____________________________________________
Base PeriodBase PeriodOption Period 1Option Period 1Option Period 2Grand Total
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5All Years
Productive Labor Hours55,78455,78455,78455,78455,784278,920
Prime-
Major Subcontractor #1 (from Exhibit 2a)-
Major Subcontractor #2 (from Exhibit 2b)-
Minor Subcontractors (from Exhibit 10)-
Total Productive Labor Hours------
Direct Labor Costs (Prime only)$ -$ -$ -$ -$ --
Fringe Benefits on Prime Labor-
Overhead on Prime Labor-
Subcontractor Total Cost and Profit:-
Major Subcontractor #1 (from Exhibit 2a)-
Major Subcontractor #2 (from Exhibit 2b)-
Minor Subcontractors (from Exhibit 10)-
Other Direct Costs:
Equipment/ Software32,00032,64033,29333,95934,638166,530
Travel22,00022,44022,88923,34723,814114,490
Occupancy------
Other20,00020,40020,80821,22421,648104,080
Subtotal74,00075,48076,99078,53080,100385,100
General & Administrative Expense-
Total Estimated Costs74,00075,48076,99078,53080,100385,100
Fixed Fee-
Facilities Capital Cost of Money-
Total Cost Plus Fixed Fee$ 74,000$ 75,480$ 76,990$ 78,530$ 80,100$ 385,100

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 2

Exhibit 2a

Summary of Elements of Cost - ASRS Core Requirements - Contract Management, ASRS, C3RS (CPFF) (Major Subcontractors)
Proposing Entity: ____________________________________________
Base PeriodBase PeriodOption Period 1Option Period 1Option Period 2Grand Total
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5All Years
Productive Labor Hours
Direct Labor Costs (Prime only)$ -
Fringe Benefits on Prime Labor$ -
Overhead on Prime Labor$ -
Material and/or Subcontract Handling$ -
Subtotal-----$ -
General & Administrative Expense$ -
Total Estimated Costs-----$ -
Fixed Fee$ -
Facilities Capital Cost of Money$ -
Total Cost Plus Fixed Fee$ -$ -$ -$ -$ -$ -

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 2a

Exhibit 3

RESERVED

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 3

Exhibit 4

Summary of Proposed Direct Labor Rates
( ) Prime Contractor: ________________________________
( ) Major Subcontractor: _____________________________
Proposed Direct Labor Rates
OptionOptionOption
Base PeriodPeriod 1Period 1Period 2
ContractContractContractContractContract
NASA Standard Labor CategoryOfferor's CategoryYear 1Year 2Year 3Year 4Year 5SourceStaffing
Example:Actual
Proposed Escalation Percentage (%)2.90%2.90%3.00%3.00%Salary Survey
DOL2005-2516Incumbent
Senior Aerospace EngineerEngineer IV$ 52.00$ 53.51$ 55.06$ 56.71$ 58.41CBANon-incumbent

Proposed Escalation Percentage (%)

Core Requirements
ASRS
ASRS Project Manager$ - 0$ - 0$ - 0$ - 0
ASRS Domain Assistant$ - 0$ - 0$ - 0$ - 0
ASRS Research Coordinator$ - 0$ - 0$ - 0$ - 0
ASRS Expert Analysts - Aviation$ - 0$ - 0$ - 0$ - 0
ASRS Assistant Analysts - Aviation$ - 0$ - 0$ - 0$ - 0
C3RS
C3RS Project Manager$ - 0$ - 0$ - 0$ - 0
C3RS Domain Assistant$ - 0$ - 0$ - 0$ - 0
C3RS Research Coordinator$ - 0$ - 0$ - 0$ - 0
C3RS Expert Analyst - Rail$ - 0$ - 0$ - 0$ - 0
Program Management
Program Manager$ - 0$ - 0$ - 0$ - 0
IT Manager$ - 0$ - 0$ - 0$ - 0
Business/Financial Support$ - 0$ - 0$ - 0$ - 0
Administrative Support$ - 0$ - 0$ - 0$ - 0
IT System Administrator$ - 0$ - 0$ - 0$ - 0
Database Administrator / IT Specialist$ - 0$ - 0$ - 0$ - 0
Web Admin / Publications$ - 0$ - 0$ - 0$ - 0
Special Studies
Database Administrator / IT Specialist$ - 0$ - 0$ - 0$ - 0
ASRS Expert Analysts - Aviation$ - 0$ - 0$ - 0$ - 0
ASRS Assistant Analysts - Aviation$ - 0$ - 0$ - 0$ - 0
C3RS Expert Analyst - Rail$ - 0$ - 0$ - 0$ - 0
Web Admin / Publications$ - 0$ - 0$ - 0$ - 0
Research Coordinator/Human Factors$ - 0$ - 0$ - 0$ - 0

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 4

Exhibit 5

DIRECT LABOR COST SUMMARY - ASRS CORE REQUIREMENTS - CONTRACT MANAGEMENT, ASRS, C3RS (CPFF) (Required of Prime Offeror and Major Subcontractors)

Base Period; Contract Year 1Base Period; Contract Year 2Option Period 1; Contract Year 3Option Period 1; Contract Year 4
Labor CategoryTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor Cost
ASRS
ASRS Project Manager1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
ASRS Domain Assistant1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
ASRS Research Coordinator1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
ASRS Expert Analysts - Aviation8,835$ - 0$ - 08,835$ - 0$ - 08,835$ - 0$ - 08,835$ - 0$ - 0
ASRS Assistant Analysts - Aviation9,300$ - 0$ - 09,300$ - 0$ - 09,300$ - 0$ - 09,300$ - 0$ - 0
C3RS
C3RS Project Manager1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
C3RS Domain Assistant1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
C3RS Research Coordinator1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
C3RS Expert Analyst - Rail7,440$ - 0$ - 07,440$ - 0$ - 07,440$ - 0$ - 07,440$ - 0$ - 0
Program Management
Program Manager1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
IT Manager1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
Business/Financial Support558$ - 0$ - 0558$ - 0$ - 0558$ - 0$ - 0558$ - 0$ - 0
Administrative Support1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
IT System Administrator1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
Database Administrator / IT Specialist4,650$ - 0$ - 04,650$ - 0$ - 04,650$ - 0$ - 04,650$ - 0$ - 0
Web Admin / Publications1,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 01,860$ - 0$ - 0
Special Studies
Database Admin/IT Specialist372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0
ASRS Expert Analysts - Aviation1,165$ - 0$ - 01,165$ - 0$ - 01,165$ - 0$ - 01,165$ - 0$ - 0
ASRS Assistant Analysts - Aviation1,700$ - 0$ - 01,700$ - 0$ - 01,700$ - 0$ - 01,700$ - 0$ - 0
C3RS Expert Analyst - Rail560$ - 0$ - 0560$ - 0$ - 0560$ - 0$ - 0560$ - 0$ - 0
Web Admin / Publications372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0
Research Coordinator/Human Factors372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0372$ - 0$ - 0
Total Labor Hours and Costs55,784$ - 055,784$ - 055,784$ - 055,784$ - 0

scroll down for contract year 5

Option Period 2; Contract Year 5
Labor CategoryTotal Labor HoursLabor RateTotal Labor Cost
ASRS
ASRS Project Manager1,860$ - 0$ - 0
ASRS Domain Assistant1,860$ - 0$ - 0
ASRS Research Coordinator1,860$ - 0$ - 0
ASRS Expert Analysts - Aviation8,835$ - 0$ - 0
ASRS Assistant Analysts - Aviation9,300$ - 0$ - 0
C3RS
C3RS Project Manager1,860$ - 0$ - 0
C3RS Domain Assistant1,860$ - 0$ - 0
C3RS Research Coordinator1,860$ - 0$ - 0
C3RS Expert Analyst - Rail7,440$ - 0$ - 0
Program Management
Program Management1,860$ - 0$ - 0
IT Lead1,860$ - 0$ - 0
Business/Financial Support558$ - 0$ - 0
Administrative Support1,860$ - 0$ - 0
IT System Administrator1,860$ - 0$ - 0
Database Administrator /IT Specialist4,650$ - 0$ - 0
Web Admin / Publications1,860$ - 0$ - 0
Adhoc Work
Database Admin/IT Specialist372$ - 0$ - 0
ASRS Expert Analysts - Aviation1,165$ - 0$ - 0
ASRS Assistant Analysts - Aviation1,700$ - 0$ - 0
C3RS Expert Analyst - Rail560$ - 0$ - 0
Web Admin / Publications372$ - 0$ - 0
Research Coordinator/Human Factors372$ - 0$ - 0
Total Labor Hours and Costs55,784$ - 0

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 5

Exhibit 6

RESERVED

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 6

Exhibit 7 Summary of Indirect Cost Rates

( ) Prime Contractor: ______________________________
( ) Major Subcontractor ___________________________
Fringe Benefits *Overhead**G&A
Example:
Portion of Contractor FY 21 From: 11/1/21 to 4/30/2246.00%4.50%7.00%
Portion of Contractor FY 22 From: 5/1/22 to 10/31/2244.00%3.50%5.00%
Base Period Weighted Average45.00%4.00%6.00%
Phase-in Period
Contractor FY Ending: ______________________
Base Period, Contract Year 1:
Portion of Contractor FY ___ From: _______ to _______
Portion of Contractor FY ___ From: _______ to _______
Base Period, Contract Year 1 Average
Base Period, Contract Year 2:
Portion of Contractor FY ___ From: _______ to _______
Portion of Contractor FY ___ From: _______ to _______
Base Period, Contract Year 2 Average
Option Period 1, Contract Year 3:
Portion of Contractor FY ___ From: _______ to _______
Portion of Contractor FY ___ From: _______ to _______
Option Period 1, Contract Year 3 Average
Option Period 1, Contract Year 4:
Portion of Contractor FY ___ From: _______ to _______
Portion of Contractor FY ___ From: _______ to _______
Option Period 1, Contract Year 4 Average
Option Period 2, Contract Year 5:
Portion of Contractor FY ___ From: _______ to _______
Portion of Contractor FY ___ From: _______ to _______
Option Period 2, Contract Year 5 Average
* Disregard if it is your normal accounting practice to include fringe benefits with overhead.
** If you plan to propose more than one overhead rate (e.g., Contractor Site OH and Customer Site OH), modify this
exhibit by adding the necessary additional number of columns to display all proposed overhead rates.
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.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 7

Exhibit 8

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 _______________.
Historical ActualForecast
Prior Yr 3Prior Yr 2Prior Yr 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20XX20XX20XX20XX20XX20XX20XX20XX
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
Application Base ($)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contractor FY Rate (%)

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 8

Exhibit 9

General and Administrative Expense (G&A)
( ) Prime Contractor: ______________________________
( ) Major Subcontractor: ___________________________Base of Application = ________________________________

OFFEROR'S FISCAL YEAR BEGINS _____________ AND ENDS _______________.

Historical ActualForecast
Prior Yr 3Prior Yr 2Prior Yr 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractor
the G&A Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20XX20XX20XX20XX20XX20XX20XX20XX

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
Distribution Base Dollars:
Existing Business Base
This Contract Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Forecasted Business Base
Total Distribution Base $
Calculated G&A Rates (%)

80ARC022R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 9

Exhibit 10 Prime Contractor:

MINOR SUBCONTRACTORS

Minor SubcontractorNASA Standard Labor CategoryBase PeriodOption Period 1Option Period 2Option Period 3
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$92.89$125,833
Technician 21,395$56.00$78,1201,395$57.68$79,6821,395$59.41$81,2761,395$61.19$82,9021,395$61.19$82,902
Safety Manager930$79.00$73,470450$81.37$36,261- 0$83.81$0- 0$86.32$0- 0$86.32$0
Technician 33,720$58.00$215,7601,500$59.74$88,740- 0$61.53$0- 0$63.38$0- 0$63.38$0
Total XYZ:7,440$485,9254,740$325,6302,790$204,6412,790$208,7342,790$208,735
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$48.08$89,429
Technician 33,720$62.00$230,6401,395$63.86$89,085- 0$65.78$0- 0$67.75$0- 0$67.75$0
Safety Manager930$71.00$66,030450$73.13$32,909- 0$75.32$0- 0$77.58$0- 0$77.58$0
Total ABC:6,510$378,5103,705$206,2891,860$86,8251,860$89,4291,860$89,429
$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.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 10

Exhibit 11

Incumbency Assumptions

[ ] Prime Contractor: _______________________
[ ] Major Subcontractor: _______________________

This exhibit provides the Government visibility into the Offeror's intentions regarding the hiring of incumbent contractor employees.

In the yellow box, state the percentage of incumbents intended/expected to be retained: %

Labor RatesThe Government understands that a non-incumbent Offeror may only be able to estimate the salary
cost of current incumbents; however, the Government must evaluate the Offeror's intentions
regarding pay for these employees if retained.
Notwithstanding the rates estimated and proposed by the Offeror, upon receiving contract award,
do you intend to pay retained incumbents at their current salaries/wages? Offerors shall select only
one of the options below.

[ ] Yes. No further response is required.

[ ] No. If you check this box, explain (in the space below and use additional pages if necessary)
what salaries/wages you intend to offer to incumbents and how this will allow you to achieve the
intended/expected incumbent retention percentage stated above.
Length of ServiceDo you intend to recognize incumbent employees' service time under predecessor contracts, in
the performance of similar work, for purposes of fringe benefits computations (such as the
amount of paid-time-off received)? Offerors shall select only one of the options below.

[ ] Yes. No further response is required.

[ ] No. If you check this box, explain (in the space below and use additional pages if necessary) your
policy regarding length of service of incumbents, as it relates to fringe benefits computations (such as
the amount of paid-time-off received), and how this will allow you to achieve the intended/expected
incumbent retention percentage stated above.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1)

Exhibit 12 Proposing Entity: ___________________________________

PHASE-IN (CPFF)

Cost ElementHoursRateCost
Prime Offeror Direct Labor (DL):
Skill mix: (identify labor category)
*Example: Technician 1100$ 10.00$1,000
1.$0
2.
3.
4.
Total Prime Offeror Direct Labor Cost- 0$0
Prime Offeror Fringe and/or Overhead on Labor:
*Example: Overhead10%$100
1.
2.
Total Fringe/Overhead$0
Major/Minor Subcontractor Total Cost (list)
1.
2.
3.
4.
Total Major/Minor Subcontractor Cost$0
Prime Offeror Other Direct Costs (ODCs):
Material/Supplies/Equipment
Travel
Facility Configuration and Set-Up Costs
Occupancy
Other
Total Other Direct Costs$0
Subtotal DL, Major/Minor Subs, OH & ODCs$0
Prime Offeror Total G&A Cost
Subtotal Estimated Cost$0
Prime Offeror Fee
Prime Offeror Facilities Capital Cost of Money

Total Phase-in Cost Plus Fixed-Fee $0

*Remove example from official submission, it 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.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 12

Exhibit 13 Schedule of Major and Minor Subcontracts

[ ] Prime Contractor: _________________________________

Description of Work/PWS Reference:

Number of quotes solicitied/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

Affiliation with Prime: ***

Cost/Price Analysis Performed by
Prime? (Yes or No): ****
* 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 analysis was not performed and how
the Offeror determined that the proposed subcontract price was reasonable.

80ARC023R0002 Aviation Safety Reporting System (ASRS) and Related Systems Attachment J.1(b)(1) Exhibit 13

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