Attachment L-7 Cost Estimating Wookbook 11.21.19 FRFP-2.xlsx

XLSX spreadsheet 72 KB Posted

Attached to
Human Space Flight Technical Integration Contract (HSFTIC) Federal contract opportunity
Solicitation number
80JSC019R0023
Issued by
National Aeronautics and Space Administration Johnson Space Center

About this file

Written by GovTribe AI ·

The documents provide templates and instructions for responding to a solicitation from NASA's Johnson Space Center for a Human Space Flight Technical Integration Contract. The solicitation seeks proposals from small businesses to provide technical integration services. Key details include that the NAICS code is 541715 with a size standard of 1,250 employees, proposals are due by December 11, 2019, the period of performance covers five contract years, templates require information on proposed labor categories and pricing for the entire performance period, and all contractual questions must be submitted in writing.

View the file

Other files for this federal contract opportunity

Other files attached to Human Space Flight Technical Integration Contract (HSFTIC), newest first.
File Type Posted
FRFP Industry Questions and Responses 120419.pdf PDF
HSFTIC L Instructions 11.22.19 FRFP-2.docx DOCX document
SF30 - RFP - Amendment 2.pdf PDF
Attachment L-6 EPM Workbook 11.21.19 FRFP-2.xlsx XLSX spreadsheet
Attachment L-6 EPM Workbook MOD FRFP-1.xlsx XLSX spreadsheet
80JSC019R0023 HSFTIC RFP with MOD FRFP-1.docx DOCX document
HSFTIC Pre-Proposal Conference - Posting.pdf PDF
80JSC019R0023_Request_for_Proposal.pdf PDF
Attachment_L-7_Cost_Estimating_Workbook.xlsx XLSX spreadsheet
50104a.pdf PDF
SSP-50136_RevA.doc DOC document
SSP_50821.doc DOC document
APA_Style_Website_Ref.pptx PPTX presentation
CR_16052_ATTA_SSP_54353_54354_Baseline.docx DOCX document
MD_106_RB_FINAL.docx DOCX document
MD_1036_RA_FINAL_PIP_Charter.docx DOCX document
SSP_50869-Rev_A.docx DOCX document
SSP-57003_Rev_L.docx DOCX document
MD_1054_PSCB_Charter.pdf PDF
SSP_30234-RevH.docx DOCX document
SSP_42007-Part_1-RevK.pdf PDF
SSP_50318_RevJ.docx DOCX document
SSP_41162BA.pdf PDF
SSP41148_IRN.pdf PDF
CCT-REQ-1130_Rev_F.docx DOCX document
BASEPLATE-Mobile_Back-1.png PNG image
SSP_50908-Baseline.docx DOCX document
SSP_50420-HTV1-Baseline.docx DOCX document
Applicable_1.zip ZIP file
OrionProgramOrg.pdf PDF
SSP_42004_Part_2-Update_to_Cover.pdf PDF
SSP_50333-RevH.docx DOCX document
SSP_50406_Rev_B_.doc DOC document
SSP_42000-RevU.docx DOCX document
SSP50251P2.pdf PDF
MD_1034_RA_FINAL_2__RICB_Charter.docx DOCX document
SSP_42004_Part_1_Revision_L.docx DOCX document
SSP_50128-C3.doc DOC document
GRA_for_Gateway.xlsx XLSX spreadsheet
SSP_41140_P1_RF_final.pdf PDF
41004P1_H-1.pdf PDF
SSP_50627-RevA.docx DOCX document
SSP-50264.doc DOC document
19AA0613D_MAPI_Abstract_Blue_Book_Rev_EE.pdf PDF
SSP_50182.RTF RTF text file
Applicable_2.zip ZIP file
SSP_57000_Revision_S.docx DOCX document
MD_1015_RA_FINAL.docx DOCX document
DRAFT_HSFTIC_Cover_Letter.pdf PDF
Draft_HSFTIC_Request_for_Proposal.pdf PDF
Show all 50

Human Space Flight Technical Integration Contract (HSFTIC) has more files on GovTribe.

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.

TRT-SOW 10.0

TECHNICAL RESOURCES TEMPLATE (TRT)SOW 10.0
Prime Offeror Company Name:
COMBINED RESOURCES FOR THE ENTIRE TEAM -- PRIME OFFEROR AND ALL SUBCONTRACTORS (INCLUDING MINOR SUBCONTRACTORS)INSTRUCTIONS TO OFFERORS
This template is required from the Prime Offeror only. It is used to identify and summarize all proposed labor resources, by SLC, and all non-labor resources (NLRs) for all SOW sections for Contract Year (CY) 1. The format is automated and only requires the Prime Offeror to include source data (WYES and NLRs) in areas shaded in blue. Resources should be allocated to the appropriate SOW sections in accordance with your Management and Technical approach. The resources identified by the Prime Offeror are the combined resources for your entire team (Prime Offeror and ALL subcontractors). ***Note: The TRT templates function as a link between Volume I, Mission Suitability, and Volume III, Cost/Price***
Total CY 1Skill mix
Standard Labor Category (SLC)SOW 10.0 WYEsRatio
WYEs
Ex: Business Specialist 34.5
Analyst I0.00%
Analyst I - Overtime0.00%
Analyst II0.00%
Analyst III0.00%
Business Specialist I0.00%
Business Specialist II0.00%
Business Specialist III0.00%
Business Specialist IV0.00%
Clerk0.00%
Deputy Program Manager0.00%
Engineer I0.00%
Engineer II0.00%
Engineer III0.00%
Engineer IV0.00%
Engineer V0.00%
IT Professional I0.00%
IT Professional II0.00%
IT Professional III0.00%
IT Professional IV0.00%
Manager0.00%
Program Manager0.00%
Secretary0.00%
Supervisor0.00%
Support Specialist0.00%
Support Specialist - Overtime0.00%
Technical Professional I0.00%
Technical Professional III0.00%
Technical Professional III0.00%
Technical Professional IV0.00%
Other: (Specify)0.00%
Total WYE Prime and All Subs0.00.00%
Non-Labor Resources (NLR) Cost ($)Total CY 1 SOW 10.0 NLR Cost
Travel
Material
Other Direct Cost
Total NLR Cost$ - 0
NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.
Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

TRST

Technical Resources Summary Template (TRST)
Prime Offeror Company Name:
INSTRUCTIONS TO OFFERORS
COMBINED RESOURCES FOR THE ENTIRE TEAM -- PRIME OFFEROR AND ALL SUBCONTRACTORS (INCLUDING MINOR SUBCONTRACTORS)This template is required from the Prime Offeror only. It is used to summarize all proposed resources for CYs 1 - 5. The format is automated and only requires the Prime Offeror to include source data (Productive Hours per WYE and the Incumbent Retention %) for the areas shaded blue. ***Note: The TRST-CORE template funcations as a link between Volume I, Mission Suitability, and Volume III, Cost/Price***
Standard Labor CategoryIncumbent Retention % (CY 1 Only)Base PeriodOption Period 1Option Period 2Option Period 3
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total Contract (CYs 1 - 5)
Proposed WYEsProposed HoursProposed WYEsProposed HoursProposed WYEsProposed HoursProposed WYEsProposed HoursProposed WYEsProposed HoursProposed WYEsProposed Hours

Ex: Productive Hours per WYE Conversion Factor 1840 1840 1840 1840 1840

Ex: Business Specialist 3 100% 11.8 21,712 11.8 21,712 11.8 21,712 11.8 21,712 11.8 21,712 59.0 108,560

PRODUCTIVE HOURS PER WYE CONVERSION FACTOR

Analyst I- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Analyst I - Overtime- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Analyst II- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Analyst III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Specialist I- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Specialist II- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Specialist III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Specialist IV- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Clerk- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Deputy Program Manager- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Engineer I- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Engineer II- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Engineer III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Engineer IV- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Engineer V- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Professional I- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Professional II- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Professional III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Professional IV- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Manager- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Program Manager- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Secretary- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Supervisor- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Support Specialist- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Support Specialist - Overtime- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technical Professional I- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technical Professional III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technical Professional III- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technical Professional IV- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other: (Specify)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Totals- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Base PeriodOption Periods
Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total Contract (CYs 1 - 5)
Non-Labor Resources (NLR) Cost ($)Total NLR CostTotal NLR CostTotal NLR CostTotal NLR CostTotal NLR CostTotal NLR Cost
Travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total NLR Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Note: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.
Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

LPT

Labor Pricing Template (LPT)INSTRUCTIONS TO OFFERORS
This template is required from the Prime Offeror and each Major Subcontractor. It is used to identify the proposed productive hours that are compensated at staight-time direct labor rates, by SLC, per Contract Year. The format is partially automated and only requires the Offeror to link the areas shaded in blue to the appropriate tabs from the EPM Workbook (i.e., "TRST-CORE" and "IRAP"). See the example in red for for linking details.
Prime Offeror Company Name:
Major Subcontractor CompanyName:
CORE BASELINE EFFORT
STRAIGHT-TIME DIRECT LABOR COST
Base PeriodOption Period 1Option Period 2Option Period 3
Standard Labor Category (SLC)Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total (CYs 1 - 5)Ref.The hours and costs shown on this template shall support and reconcile to the hours and cost shown on either the Prime Offeror's Prime Cost Summary Template (PCST) or the Major Subcontractor's Major Subcontractor Cost Summary Template (MSCST). The hours shall also support and reconcile the proposed hours shown on the TRST-CORE tab.
Link From EPM Tab"TRST-CORE""TRST-CORE""TRST-CORE""TRST-CORE""TRST-CORE"
Ex: Business Specialist 321,71221,71221,71221,71221,712
STRAIGHT-TIME PRODUCTIVE HOURS
Analyst I- 0
Analyst I - Overtime- 0
Analyst II- 0
Analyst III- 0
Business Specialist I- 0
Business Specialist II- 0
Business Specialist III- 0
Business Specialist IV- 0
Clerk- 0
Deputy Program Manager- 0
Engineer I- 0
Engineer II- 0
Engineer III- 0
Engineer IV- 0
Engineer V- 0
IT Professional I- 0
IT Professional II- 0
IT Professional III- 0
IT Professional IV- 0
Manager- 0
Program Manager- 0
Secretary- 0
Supervisor- 0
Support Specialist- 0
Support Specialist - Overtime- 0
Technical Professional I- 0
Technical Professional III- 0
Technical Professional III- 0
Technical Professional IV- 0
Other: (Specify)- 0
Total Straight-Time Productive Hours- 0- 0- 0- 0- 0- 0
Link From EPM Tab"IRAP""IRAP""IRAP""IRAP""IRAP"
Proposed Rate of EscalationN/A2.80%2.80%2.80%2.80%
Ex: Business Specialist 3$27.17$27.93$28.71$29.51$30.34

Proposed Rate of Escalation N/A 0.00% 0.00% 0.00% 0.00%

STRAIGHT-TIME DIRECT LABOR RATES
Analyst I$0.00$0.00$0.00$0.00
Analyst I - Overtime$0.00$0.00$0.00$0.00
Analyst II$0.00$0.00$0.00$0.00
Analyst III$0.00$0.00$0.00$0.00
Business Specialist I$0.00$0.00$0.00$0.00
Business Specialist II$0.00$0.00$0.00$0.00
Business Specialist III$0.00$0.00$0.00$0.00
Business Specialist IV$0.00$0.00$0.00$0.00
Clerk$0.00$0.00$0.00$0.00
Deputy Program Manager$0.00$0.00$0.00$0.00
Engineer I$0.00$0.00$0.00$0.00
Engineer II$0.00$0.00$0.00$0.00
Engineer III$0.00$0.00$0.00$0.00
Engineer IV$0.00$0.00$0.00$0.00
Engineer V$0.00$0.00$0.00$0.00
IT Professional I$0.00$0.00$0.00$0.00
IT Professional II$0.00$0.00$0.00$0.00
IT Professional III$0.00$0.00$0.00$0.00
IT Professional IV$0.00$0.00$0.00$0.00
Manager$0.00$0.00$0.00$0.00
Program Manager$0.00$0.00$0.00$0.00
Secretary$0.00$0.00$0.00$0.00
Supervisor$0.00$0.00$0.00$0.00
Support Specialist$0.00$0.00$0.00$0.00
Support Specialist - Overtime$0.00$0.00$0.00$0.00
Technical Professional I$0.00$0.00$0.00$0.00
Technical Professional III$0.00$0.00$0.00$0.00
Technical Professional III$0.00$0.00$0.00$0.00
Technical Professional IV$0.00$0.00$0.00$0.00
Other: (Specify)$0.00$0.00$0.00$0.00
Weighted Average Straight-Time D. L. Rate

Ex: Business Specialist 3 $ 589,832 $ 606,347 $ 623,325 $ 640,778 $ 658,719

STRAIGHT-TIME DIRECT LABOR COST
Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst I - Overtime$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business Specialist I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business Specialist II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business Specialist III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business Specialist IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Clerk$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Deputy Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Engineer V$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IT Professional I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IT Professional II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IT Professional III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IT Professional IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Secretary$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Supervisor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Support Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Support Specialist - Overtime$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Professional I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Professional III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Professional III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Technical Professional IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other: (Specify)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Straight-Time Direct Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.
Please remember to remove the red highlighted examples from the templates in your official proposal submission.

MSCST

Major Subcontractor Cost Summary Template (MSCST)INSTRUCTIONS TO OFFERORS
This template is required for each Major Subcontractor. It is used to identify each Major Subcontractor's proposed hours, cost, and fee, by Contract Year, for the entire period of performance. A reference column has been provided on the template for the Offeror to use in identifying where the supporting data for each cost element is located in the Offeorr's Volume III, Cost/Price Proposal. The cost and price data submitted shall be clearly displayed and detailed so that the Government may fully understand the cost development and computations. Offeror's are to provide the cost and rate data (NLR cost, FCCOM and Fee rates, and any additional resources identified by the Offeror) and complete all links to the appropriate tabs in the Cost Estimating Workbook, or the EPM Workbook, as appropriate (i.e., "LPT", "OHT", "G&A", etc.) for all ares shaded in blue.
Major Subcontractor Company Name:
CORE BASELINE EFFORT
MAJOR SUBCONTRACTOR TOTAL COST AND FEE
BaseOption Period 1Option Period 2
Cost ElementContract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total Contract (CYs 1-5)Ref.
Direct Labor Hours:
Major Sub Straight-Time HoursLink to Major Subcontractor's "LPT" Tab- 0
Total Direct Labor Hours- 0- 0- 0- 0- 0- 0
Direct Labor Cost:
Major Sub Direct Labor CostLink to Major Subcontractor's "LPT" Tab$ - 0
Total Direct Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (OH) and Service Center (SC) Cost:
Major Sub OH or SC No. 1 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Major Subcontractor's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Major Sub OH or SC No. 2 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Major Subcontractor's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Major Sub OH or SC No. 3 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Major Subcontractor's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total OH and SC CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Non-Labor Resources (NLRs):
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Total NLR Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Sub-Total Cost ERROR:#VALUE! $ - 0 $ - 0 $ - 0 $ - 0 ERROR:#VALUE!

G&A Cost:
G&A Base***IMPORTANT*** Provide the formula used to calculate the G&A Base dollars
G&A RateLink to Major Subcontractor's "GAT" Tab
Total G&A CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Facilities Capital Cost of Money (FCCOM):
FCCOM Base***IMPORTANT*** Provide the formula used to calculate the FCCOM Base dollars
FCCOM Rate
Total FCCOM CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total Estimated CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Fee (identify type of fee):
Fee Base***IMPORTANT*** Provide the formula used to calculate the Fee Base dollars
Fee Rate
Total Fee DollarsERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total Major Sub Estimated Cost and FeeERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!

NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.

PCST

Prime Cost Summary Template (PCST)INSTRUCTIONS TO OFFERORS
This template is required for the Prime Offeror only. It is used to identify the Prime Offeror's proposed hours, cost, and fee, by Contract Year, for the entire period of performance. A reference column has been provided on the template for the Offeror to use in identifying where the supporting data for each cost element is located in the Offeorr's Volume III, Cost/Price Proposal. The cost and price data submitted shall be clearly displayed and detailed so that the Government may fully understand the cost development and computations. Offeror's are to provide the cost and rate data (Subcontractor and NLR cost, FCCOM and Fee rates, and any additional resources identified by the Offeror) and complete all links to the appropriate tabs in the Cost Estimating Workbook, or the EPM Workbook, as appropriate (i.e., "LPT", "OHT", "G&A", etc.) for all ares shaded in blue. ***IMPORTANT: The Prime Offeror's hours and cost identified in the PCST by the Prime Offeror for each Major Subcontractor should match the hours and cost identified in each Major Subcontractor's cost proposal. If not, differences MUST BE explained.
Prime Offerors Company Name:
CORE BASELINE EFFORT
PRIME OFFEROR TOTAL COST AND FEE
BaseOption Period 1Option Period 2
Cost ElementContract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Total Contract (CYs 1-5)Ref.
Direct Labor Hours:
Prime Contractor Straight-Time HoursLink to Prime Offeror's "LPT" Tab- 0
Major Subcontractor Straight-Time Hours- 0
Minor Subcontractor Straight-Time Hours- 0
Total Direct Labor Hours- 0- 0- 0- 0- 0- 0
Direct Labor Cost:
Prime Contractor Direct Labor CostLink to Prime Offeror's "LPT" Tab$ - 0
Total Direct Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (OH) and Service Center (SC) Cost:
Prime OH or SC No. 1 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Prime Offeror's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Prime OH or SC No. 2 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Prime Offeror's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Prime OH or SC No. 3 (identify by name)
Base***IMPORTANT*** Provide the formula used to calculate the Overhead or Service Center Base dollars
RateLink to Prime Offeror's appropriate indirect Tab (i.e., "OHT" or "GAT" or other indirect Tab created by the Offeror)
Sub-Total CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total OH and SC CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Subcontractor Cost:
Major Subcontractor No. 1 Cost (identify by name)$ - 0
Major Subcontractor No. 2 Cost (identify by name)$ - 0
Major Subcontractor No. 3 Cost (identify by name)$ - 0
Sub-Total Major Subcontractor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Minor Subcontractor No. 1 Cost (identify by name)$ - 0
Minor Subcontractor No. 2 Cost (identify by name)$ - 0
Minor Subcontractor No. 3 Cost (identify by name)$ - 0
Sub-Total Minor Subcontractor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Subcontractor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Non-Labor Resources (NLRs):
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Identify NLR Item (or remove excess rows)$ - 0
Total NLR Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Sub-Total Cost ERROR:#VALUE! $ - 0 $ - 0 $ - 0 $ - 0 ERROR:#VALUE!

G&A Cost:
G&A Base***IMPORTANT*** Provide the formula used to calculate the G&A Base dollars
G&A RateLink to Prime Offeror's "GAT" Tab
Total G&A CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Facilities Capital Cost of Money (FCCOM):
FCCOM Base***IMPORTANT*** Provide the formula used to calculate the G&A Base dollars
FCCOM Rate
Total FCCOM CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total Estimated CostERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Fee (identify type of fee):
Fee Base***IMPORTANT*** Provide the formula used to calculate the G&A Base dollars
Fee Rate
Total Fee DollarsERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!
Total Prime Estimated Cost and FeeERROR:#VALUE!$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!

NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.

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