Attachment_L-7_Cost_Estimating_Workbook.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 ·

This document contains templates and instructions for responding to a solicitation from the National Aeronautics and Space Administration Johnson Space Center (NASA/JSC) for the Human Space Flight Technical Integration Contract (HSFTIC).

The solicitation is anticipated for release on or around November 1, 2019, with offers due on or around December 11, 2019. It is a total small business set-aside with a NAICS Code of 541715 and size standard of 1,250 employees. All responsible sources may submit offers which will be considered. The templates provide instructions for identifying proposed labor resources, costs, rates, and fees by contract year for the prime contractor and any major subcontractors. Templates include a technical resources template, labor pricing template, cost summary templates for the prime contractor and any major subcontractors, and indirect rate templates. The templates are to be completed with formulas and data in specified blue-shaded areas.

From the source

L-7 Cost Estimating Workbook

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
HSFTIC_J-4_Applicable_and_Reference_Document_List.xlsx XLSX spreadsheet
SSP_50035_Revision_C_Retired.docx DOCX document
SSP_50314-Rev_C.docx DOCX document
SSP41142P2_RD_CD_012045_2.pdf PDF
SSP-50803.doc DOC document
PPD_524_RB_FINAL_MRICB_Charter.docx DOCX document
GPO_Website_Ref.pptx PPTX presentation
SSP_50481-RevC.docx DOCX document
42124_P2_RC_.pdf PDF
SSP_50094-RevB.pdf PDF
SSP_50659_Rev_E.xlsx XLSX spreadsheet
IMPR_Package_Mar_Apr_18.pptx PPTX presentation
SSP_41167-RevJ.docx DOCX document
SSP_50835_Rev_E.doc DOC document
42097P1_RD.pdf PDF
SSP42003_P2_RevC.pdf PDF
Applicable_3.zip ZIP file
MD_101_RA_FINAL.docx DOCX document
SSP_50477-RevC.pdf PDF
SSP_50670-Rev_A-DCN001-Collated_Master.doc DOC document
SSP_50781-RevA-DCN_003.docx DOCX document
PPD_517.pdf PDF
SSP_41002-RevR.docx DOCX document
SSP_50901.docx DOCX document
SSP_54059_54060-Baseline.docx DOCX document
SSP5003.PDF PDF
SSP30559RD-Errata.pdf PDF
SSP_41000-RevCJ.pdf PDF
42137P1_RC_CD_012230.pdf PDF
SSP_41163-Rev_L.docx DOCX document
9.0.zip ZIP file
SSP_42001-RevW.docx DOCX document
SSP_50875.docx DOCX document
SSP41017p2rJ.pdf PDF
41143Pt2RD.pdf PDF
SSP_50489-Rev_G.docx DOCX document
41015P2RH.pdf PDF
SSP_42121_Part_2.pdf PDF
SSP_50309_Part_1.pdf PDF
SSP_50477-RevC_Joint_Crew_Provisioning_Catalog.pdf PDF
JSC_Form_1240.pdf PDF
SSP_41160-RevH.docx DOCX document
Increment_Utilization_Accomplishment_Report_Blank_Book_RevB(March_2019).docx DOCX document
SSP_50102.pdf PDF
SSP_50146-RevB-SSCD_15566.pdf PDF
SSP_50034_Revision_D.DOC DOC document
SSP_50227-RevC.docx DOCX document
SSP_50621-RevF-DCN001-Collated_Master.pdf PDF
SSP41004_P2_RJ.pdf PDF
DRAFT_HSFTIC_Work_Load_Indicators.xlsx XLSX spreadsheet
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
Transition Interface- 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
Transition Interface$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
Transition Interface$ - 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
Major Sub Overtime HoursLink to Major Subcontractor's "OPT" 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
Major Sub Overtime CostLink to Major Subcontractor's "OPT" 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
Prime Contractor Overtime HoursLink to Prime Offeror's "OPT" Tab- 0
Major Subcontractor Straight-Time Hours- 0
Major Subcontractor Overtime Hours- 0
Minor Subcontractor Straight-Time Hours- 0
Minor Subcontractor Overtime 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
Prime Contractor Overtime CostLink to Prime Offeror's "OPT" 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 .