DRAFT_Jb_Att_3_PESS_II_Cost_Template_Workbook.xlsx

XLSX spreadsheet 230 KB Posted

Attached to
Project and Engineering Support Services II (PESS II)
Solicitation number
80ARC018R0003
Issued by

About this file

From the source

Draft Jb Att 3 80ARC018R0003 PESS II Cost Template Workbook

View the file

Other files

File Type Posted
Repost_PESS_II_QA.pdf PDF
PESS_II_Q&A_to_post.pdf PDF
DRAFT_Ja_Att_1_PESS_II_SOW.pdf PDF
7._PESS_II_Industry_Day_Project_Support_Reqmts.pdf PDF
4._PESS_II_Industry_Day_Charts_Procurement_Information.pdf PDF
DRAFT_Ja_Att_4_Government_Property_List.pdf PDF
DRAFT_Ja_Att_2_PESS_IIDOL_WD_15-5641,_Rev_6.pdf PDF
DRAFT_Jb_Att_4Form_CASB-CMF.pdf PDF
DRAFT_Jb_Att_10_PESS_II_Terms_of_Reference.pdf PDF
8._PESS_II_Industry_Day_-_RM.pdf PDF
DRAFT_Jb_Att_9_PESS_II__Sample_Work_Package.pdf PDF
DRAFT_Jb_Att_1_PESS_II_Cost_Staffing_and_Position_Descriptions_Qualifications.pdf PDF
PESS_II_Industry_Day_Attendee_List.pdf PDF
DRAFT_Jb_Att_6_Preaward_Survey_of_Prospective_Contractor_Accounting_System_Che.._.pdf PDF
DRAFT_Jb_Att_2PESS_II_Current_JA_Form_038.pdf PDF
DRAFT_Jb_Att_8_PESS_II_Past_Performance_Cover_Letter_and_Questionnaire.pdf PDF
DRAFT_Jb_Att_5_DD_1861.pdf PDF
DRAFT_80ARC018R0003.pdf PDF
3._PESS_II_Industry_Day_ARC_small_business_office_slides.pdf PDF
2._PESS_II_ARC_Overview.pdf PDF
1._PESS_II_Industry_Day_Opening_Slide.pdf PDF
DRAFT_Jb_Att_7_NF533M_PESS_II.pdf PDF
DRAFT_Ja_Att_3_PESS_II_DRL.pdf.pdf PDF
DRAFT_Ja_Att_1_PESS_II_SOW_-_Att_1_EPCRA.pdf PDF
Show all 24

On GovTribe

Work with this file

  • 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 Proposing Entity: _________________________________________

SUMMARY OF PROPOSED PRICE

CLINDescriptionEstimated CostFixed FeeTotal Cost/Price
0001Phase-in (from Exhibit 11)N/AN/A$0
BASE PERIOD 1
0002PESS II Core Requirements; Contract Year 1 (from Exhibit 2)$ 4,200,000-$ 4,200,000
0002PESS II Core Requirements; Contract Year 2 (from Exhibit 2)$ 4,200,000-$ 4,200,000
OPTION PERIOD 1
TBDPESS II Core Requirements; Contract Year 3 (from Exhibit 2)$ 4,200,000-$ 4,200,000
OPTION PERIOD 2
TBDPESS II Core Requirements; Contract Year 4 (from Exhibit 2)$ 4,200,000-$ 4,200,000
OPTION PERIOD 3
TBDPESS II Core Requirements; Contract Year 5 (from Exhibit 2)$ 4,200,000-$ 4,200,000
Total Evaluation Price for Selection Purposes*$21,000,000

* A cost/price evaluation will be conducted in accordance with FAR 15.305(a)(1) and NFS 1815.305(a)(1)(B).

Exhibit 2 Summary of Elements of Cost - PESS II Core Requirements (Prime Offeror)

Proposing Entity: _________________________________________

Base PeriodBase PeriodOption Period 1Option Period 2Option Period 3Grand
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total
Productive Labor Hours
Prime------
Subcontractor #1------
Subcontractor #2------
Total Productive Labor Hours------
Direct Labor Costs (Prime only)$ -$ -$ -$ -$ -$ -
Fringe Benefits on Prime Labor------
Overhead on Prime Labor------
Subcontractor Total Cost and Fee:
Subcontractor #1------
Subcontractor #2------
Other Direct Costs:
Hardware/Software/Maintenance4,000,0004,000,0004,000,0004,000,0004,000,00020,000,000
Travel/Training/Other200,000200,000200,000200,000200,0001,000,000
Total Other Direct Costs4,200,0004,200,0004,200,0004,200,0004,200,00021,000,000
Material and/or Subcontract Handling------
Subtotal4,200,0004,200,0004,200,0004,200,0004,200,00021,000,000
G&A Expense------
Total Cost$ 4,200,000$ 4,200,000$ 4,200,000$ 4,200,000$ 4,200,000$ 21,000,000
Fixed Fee------
Facilities Capital Cost of Money------
Total Cost Plus Fixed Fee$ 4,200,000$ 4,200,000$ 4,200,000$ 4,200,000$ 4,200,000$ 21,000,000

Exhibit 2a Summary of Elements of Cost - PESS II Core Requirements (Major Subcontractors)

Proposing Entity: _________________________________________

Base PeriodBase PeriodOption Period 1Option Period 2Option Period 3Grand
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total

Productive Labor Hours - - - - - -

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

Exhibit 3 Summary of Proposed Direct Labor Rates

[ ] Prime Contractor: _____________________________________
[ ] Major Subcontractor: __________________________________
Proposed Direct Labor Rates
Base PeriodOpt Period 1Opt Period 2Opt Period 3
NASA Standard Labor CategoryOfferor's CategoryContract Yr1Contract Yr2Contract Yr3Contract Yr4Contract Yr5SourceStaffing
Example:
Proposed Escalation Percentage (%)2.9%2.9%3.0%3.0%ActualIncumbent
Salary SurveyOfferor's employee
Senior Aerospace EngineerEngineer IV$52.00$53.51$55.06$56.71$58.41DOL2005-2516New hire

Proposed Escalation Percentage (%)

$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
$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
$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
$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
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.

Exhibit 4 Summary of Key Personnel Direct Labor Rates

[ ] Prime Contractor:
[ ] Major Subcontractor:
Actual Rates Projected
Labor CategoryNames of Key PersonnelCurrent Rates*Phase-in PeriodBase Period 1Base Period 2Option Period 1Option Period 2Option Period 3

* Date of current rates is payroll of:

Exhibit 5

[ ] Prime Contractor:
[ ] Major Subcontractor:

DIRECT LABOR COST SUMMARY - PESS II CORE REQUIREMENTS

Labor CategoryBase Period; Contract Yr1Base Period; Contract Yr2Option Period 1; Contract Yr3
Total Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor Cost
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
$0$0$0
Total Labor Hours and Costs- 0$0- 0$0- 0$0
[ ] Prime Contractor:
[ ] Major Subcontractor:

DIRECT LABOR COST SUMMARY - PESS II CORE REQUIREMENTS

Labor CategoryOption Period 2; Contract Yr4Option Period 3; Contract Yr5
Total Labor HoursLabor RateTotal Labor CostTotal Labor HoursLabor RateTotal Labor Cost
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
Total Labor Hours and Costs- 0$0- 0$0

Exhibit 6 Summary of Indirect Cost Rates

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: __________________________________
Fringe Benefits*Overhead**G&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%
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 Average
Base Period, Contract Year 2:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 1 Average
Option Period 1, Contract Year 3:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 2 Average
Option Period 2, Contract Year 4:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 3 Average
Option Period 3, 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.
** 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 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.

Exhibit 7 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 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 ($)
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!

Exhibit 8 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 withinContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead 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
Forecasted Business Base
Total Distribution Base $$ - 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!

Exhibit 9 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$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.

Exhibit 10 Incumbency Assumptions

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

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

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 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 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.

Exhibit 11

PHASE-IN
Company Name:
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 Subcontractor Total Cost (list)
1.
2.
3.
4.
Total Major Subcontractor Cost$0
Minor Subcontractor Total Cost
1.
2.
3.
Total Minor Subcontractor Costs$0
Prime Offeror Non-Labor Resources (NLR):
Material/Supplies/Equipment
Travel/Training
Service Agreements, Outsourcing & Consultant Fees
Other
Total Non-Labor Cost$0
Subtotal DL$, Major & Minor Subs$, OH$ & NLR$$0
Prime Offeror Total G&A Cost
Subtotal Estimated Cost$0
Prime Offeror Profit$0
Prime Offeror Facilities Capital Cost of Money

Total Phase-in Firm Fixed Price $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.

Exhibit 12 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.

File details come from the government source that posted it.