Attachment_4__Excel_Cost_Proposal_Template.xlsx

XLSX spreadsheet 58 KB Posted Nov 2, 2016

Attached to: Joint Effects Model (JEM)
Solicitation number: W911SR17R0002
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

From the source

Attachment 4_ Excel Cost Proposal Template

View the file

Other files

File	Type	Posted
W911SR-17-R-0002-0001.pdf	PDF	Nov 9, 2016
Attachment_4__Excel_Cost_Proposal_Template_9_NOV_16.xlsx	XLSX spreadsheet	Nov 9, 2016
Exhibit_A_DD_Form_1423 _Contract_Data_Requirements_List_(CDRL).docx	DOCX document	Nov 9, 2016
Attachment_12_JEM_Questions_and_Answers_Q As.pdf	PDF	Nov 9, 2016
Attachment_11__Excel_Uncosted_Proposal_Template.xlsx	XLSX spreadsheet	Nov 2, 2016
W911SR-17-R-0002.pdf	PDF	Nov 2, 2016
Attachment_6__ProjectForge_Access_Request_Form_and_Non-Disclosure_Agreement.docx	DOCX document	Nov 2, 2016
Attachment_8_DD254_Contract_Security_Specification.pdf	PDF	Nov 2, 2016
W911SR_17_R_0002_Questions.xlsx	XLSX spreadsheet	Nov 2, 2016
Attachment_3_Past_Performance_Questionnaire.docx	DOCX document	Nov 2, 2016
Exhibit_A_DD_Form_1423 _Contract_Data_Requirements_List_(CDRL).docx	DOCX document	Nov 2, 2016
Attachment_2_Award_Fee_Plan_26JUL16.doc	DOC document	Nov 2, 2016
Attachment_1_Task_Order_0001_PWS.docx	DOCX document	Nov 2, 2016
Attachment_10_Facility_Clearance_(FCL)_Request_OCT15.pdf	PDF	Nov 2, 2016
Attachment_5_Defined_Labor_Categories.xlsx	XLSX spreadsheet	Nov 2, 2016
Attachment_9_Joint_Program_Executive_Office_For_Chemical_and_Biological_Defense_(JPEO-CBD)_Critical_Information_List_(CIL).pdf	PDF	Nov 2, 2016
Attachment_1_Task_Order_0001_PWS.docx	DOCX document	Oct 18, 2016
W911SR-17-R-0002.pdf	PDF	Oct 18, 2016
Attachment_6__ProjectForge_Access_Request_Form_and_Non-Disclosure_Agreement.docx	DOCX document	Oct 18, 2016
Attachment_5_Defined_Labor_Categories.xlsx	XLSX spreadsheet	Oct 18, 2016
Attachment_4__Excel_Cost_Proposal_Template.xlsx	XLSX spreadsheet	Oct 18, 2016
Attachment_11__Excel_Uncosted_Proposal_Template.xlsx	XLSX spreadsheet	Oct 18, 2016
Attachment_9_Joint_Program_Executive_Office_For_Chemical_and_Biological_Defense_(JPEO-CBD)_Critical_Information_List_(CIL).pdf	PDF	Oct 18, 2016
Attachment_2_Award_Fee_Plan_26JUL16.doc	DOC document	Oct 18, 2016
W911SR_17_R_0002_Questions.xlsx	XLSX spreadsheet	Oct 18, 2016
Exhibit_A_DD_Form_1423,_Contract_Data_Requirements_List_(CDRL).docx	DOCX document	Oct 18, 2016
Attachment_3_Past_Performance_Questionnaire.docx	DOCX document	Oct 18, 2016
Attachment_8_DD254_Contract_Security_Specification.pdf	PDF	Oct 18, 2016
Attachment_10_Facility_Clearance_(FCL)_Request_OCT15.pdf	PDF	Oct 18, 2016

Show all 29

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.

Task Order Price Summary

W911SR-17-R-0002, Attachment #4
Funding Type	Contract Type	Year 1	Year 2	Total
R&D	CPAF	CLIN 0001	(Option) CLIN 1001	$0
O&M	CPFF	(Option) CLIN 0002	(Option) CLIN 1002	$0
Procurement	CPFF	CLIN 0003	(Option) CLIN 1003	$0
FMS	CPFF	CLIN 0004	(Option) CLIN 1004	$0
	Hybrid (Total)	$0	$0	$0
Link Cells to "CLIN 000x and 100x Breakout" tabs

Labor Category Definitions

	Gov Labor Category	Offeror Labor Category	Education	Experience
Program Management	Program Manager		Bachelor's degree (or higher) in Chemical/Nuclear/Network Engineering, Physical Sciences, Mathematics, Management Information Systems, or Business.	Three (3) years as manager of Chemical Biological Radiological Nuclear (CBRN) hazard prediction software projects to include: system support, software development, software integration and programmatic support. Ten (10) years of program management experience, to include: technology assessments, systems design, systems analysis, programmatic support, acquisition planning, and budget planning. Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures relating to Acquisition Programs.
	Technical Lead		Bachelor's degree (or higher) in Chemical/Nuclear Engineering, Physical Sciences, Mathematics or Computer Science.	Fifteen (15) years software development experience. Five (5) years of direct work experience managing complex web-based software integration projects in an Agile development environment; which promotes adaptive planning, evolutionary development, early delivery, and continuous improvement, and encourages rapid and flexible response to change. Five (5) years direct work experience managing and coordinating workflow of CBRN hazard or other complex physics based, modeling software design, development, production, installation, and test & evaluation of fielded systems. Four (4) years as manager of software integration projects, to include: supervising project personnel and subcontractors, scheduling work, writing (technical) proposals and preparing bids cost estimates. Direct work experience with Command and Control Systems. Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures.
Engineering	Software Engineer V / Engineer/Scientist V		Bachelor's degree (or higher) in Chemical/Nuclear/Network Engineering, Physical Sciences, Mathematics or Computer Science.	Fifteen (15) years’ experience in software development, to include: technology analysis and assessment, web application development, enterprise system architecture and software design, systems analysis, and integration of disparate components within a complex software system. Minimum ten (10) years’ experience in system architecture and software design.
	Lead Test Engineer		Bachelor's degree (or higher) in Chemical/Nuclear/Network Engineering, Physical Sciences, Mathematics or Computer Science.	Ten (10) years’ experience in software development testing to include automated test tools, creating test procedures, defining and assessing test coverages, developing test cases and procedures to satisfy system requirements and verification and validation (V&V) of system components. Five (5) years’ experience across the project lifecycle for implementation(s) including test planning and execution and quality assurance. Five (5) years technical experience in support of CBRN hazard prediction modeling and/or simulation.
	Sr. Web Application Developer		Bachelor's degree (or higher)
Ten (10) years’ experience in developing web applications specializing in HTML, JavaScript, CSS, Java Frameworks for web applications; or similar application development technologies. Five (5) years’ experience in web application development for Java web server platforms.

	CBRN Hazard Modeling Subject Matter Expert (SME)	Bachelor's degree (or higher) in Chemical/Nuclear Engineering, Physical Sciences, Mathematics or Computer Science.	Fifteen (15) years’ experience in applying mathematical formulations to produce atmospheric dispersion modeling software that utilizes meteorological conditions, topography, and CBRN material properties to predict dosage and concentration levels at downwind locations. Five (5) years’ experience developing or integrating SCIPUFF or similar transport and dispersion model into an end-user application.
	Sr. Application Development Engineer	Bachelor's degree (or higher)
Ten (10) years’ experience with relevant software and operating systems, such as communications software, emulation software, relevant programming language(s), or operating system(s). Leads general programming activities to implement corrections or enhancements to application software. Uses computer programming, analyses and design knowledge for designing software and implementing changes to applications. Applies superior knowledge of development concepts, practices, and procedures to write moderate to complex specifications and design documents.

	Engineer Scientist V/Lead Software Architect	Bachelor's degree (or higher) in Chemical/Nuclear/Network/Systems Engineering, Physical Sciences, Mathematics or Computer Science.	Ten (10) years’ experience in software development, to include: technology analysis and assessment, web application development, enterprise system architecture and software design, systems analysis, and integration of disparate components within a complex software system.
	Engineer Scientist IV	Bachelor's degree (or higher) in Chemical/Nuclear/Network Engineering, Physical Sciences, Mathematics or Computer Science.	Ten (10) years of experience in "Relevant Technical Field", to include: Technology Analysis and Assessment, Design Definition, Development of Systems Specification, Systems Analysis, Systems Architecture, Systems/Equipment Integration, Test & Evaluation and Logistics support of C4ISR requirements. Five (5) years of technical experience in support of (CBRN Hazard prediction modeling).
	Engineer Scientist III/Software Engineer/Programmer	Bachelor's degree (or higher) in Chemical/Nuclear/Network Engineering, Physical Sciences, Mathematics or Computer Science.	Six (6) years of experience in "Relevant Technical Field", to include: Systems Analysis, Systems Architecture, Systems/Equipment Support, Test and Evaluation, and Logistics support of C4ISR requirements. Three (3) years of technical experience in support of (CBRN hazard prediction modeling, OSGi, CCMI).
Engineering (Continued)	Computer Programmer III	High School diploma (or higher). Completed the following certifications within one and a half year after assuming duties: Certified Software Development Professional (CSDP) (Previously known as Certified Software Engineering Professional (CSEP)), or with COR approval complete a vendor/platform specific certification (e.g., Microsoft Certified Solutions Developer (MCSD), Microsoft Certified Applications Developer (MCAD), Microsoft Certified Database Administrator (MCDBA), Sun Certified Professional (SCP), Red Hat Certification Program (RHCP), CISCO Certified Network Professional (CCNP), Oracle Certified Professional (OCP), other).	Six (6) years of experience, to include: Software Design, Development, and Test and Evaluation. Four (4) years of programming experience with current programming languages. Three (3) years of experience, to include: Database development, Web page design, Computer Based Training development, and using .NET tools and .net Integrated Development Environment tools, asp.net, SQL Server 2000, and HTML editor tools.
	Computer Programmer II	High School diploma or GED (or higher). Completed the following certifications within one and a half year after assuming duties: Certified Software Development Professional (CSDP) (Previously known as Certified Software Engineering Professional (CSEP)), or with COR approval complete a vendor/platform specific certification (e.g., Microsoft Certified Solutions Developer (MCSD), Microsoft Certified Applications Developer (MCAD), Microsoft Certified Database Administrator (MCDBA), Sun Certified Professional (SCP), Red Hat Certification Program (RHCP), CISCO Certified Network Professional (CCNP), Oracle Certified Professional (OCP), other).	Six (6) years of experience, to include: Software Design, Development, and Test and Evaluation. Four (4) years of programming experience with web application development programming languages. Three (3) years of experience, to include: Database development, Web page design, Computer Based Training development, and using .NET tools and .net Integrated Development Environment tools, asp.net, SQL Server 2000, and HTML editor tools. Note: Experience may be concurrent.
	Quality Assurance Analyst/Configuration Specialist	Bachelor's degree (or higher) or Associate's Degree plus 5 years total relevant experience

Five (5) years of experience. Experience across the project lifecycle for implementation(s) including test planning and execution and quality assurance. Analyzes systems requirements and implements test plans. Collects data to ensure system modules and programs are properly tested against requirements prior to implementation. Documents problems and performs analysis.
	Platform Configuration & Administration Specialist	Education: Bachelor's degree (or higher)	Five (5) years' experience in each of the following: Windows systems administration, web server configurations and DoD cybersecurity requirements.
	*Key Personnel

DL Ceiling Rates

Proposed Direct Labor Escalation (Percent)
	Year 1	Year 2	Year 3	Year 4	Year 5
Program Manager		$0.00	$0.00	$0.00	$0.00
Technical Lead		$0.00	$0.00	$0.00	$0.00
Software Engineer V / Engineer/Scientist V		$0.00	$0.00	$0.00	$0.00
Lead Test Engineer		$0.00	$0.00	$0.00	$0.00
Sr. Web Application Developer		$0.00	$0.00	$0.00	$0.00
CBRN Hazard Modeling Subject Matter Expert (SME)		$0.00	$0.00	$0.00	$0.00
Sr. Application Development Engineer		$0.00	$0.00	$0.00	$0.00
Engineer Scientist V/Lead Software Architect		$0.00	$0.00	$0.00	$0.00
Engineer Scientist IV		$0.00	$0.00	$0.00	$0.00
Engineer Scientist III/Software Engineer/Programmer		$0.00	$0.00	$0.00	$0.00
Computer Programmer III		$0.00	$0.00	$0.00	$0.00
Computer Programmer II		$0.00	$0.00	$0.00	$0.00
Quality Assurance Analyst/Configuration Specialist		$0.00	$0.00	$0.00	$0.00
Platform Configuration & Administration Specialist		$0.00	$0.00	$0.00	$0.00
*Key Personnel

CLIN 0001 and 1001 Breakout

	Base Period (CLIN 0001)			Option Year 1 (CLIN 1001)			Total
Key Personnel Direct Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Dollars
Technical Lead		$0.00	$0		$0.00	$0
Software Engineer V / Engineer/Scientist V		$0.00	$0		$0.00	$0
CBRN Hazard Modeling Subject Matter Expert (SME)		$0.00	$0		$0.00	$0
Subtotal, Program Management Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Program Management hours must equal 3,210			↑ Propose more hours. Total Program Management hours must equal 4,616

Engineering Direct Labor
Program Manager		$0.00	$0		$0.00	$0
Lead Test Engineer		$0.00	$0		$0.00	$0
Sr. Web Application Developer		$0.00	$0		$0.00	$0
Sr. Application Development Engineer		$0.00	$0		$0.00	$0
Engineer Scientist V/Lead Software Architect		$0.00	$0		$0.00	$0
Engineer Scientist IV		$0.00	$0		$0.00	$0
Engineer Scientist III/Software Engineer/Programmer		$0.00	$0		$0.00	$0
Computer Programmer III		$0.00	$0		$0.00	$0
Computer Programmer II		$0.00	$0		$0.00	$0
Quality Assurance Analyst/Configuration Specialist		$0.00	$0		$0.00	$0
Platform Configuration & Administration Specialist		$0.00	$0		$0.00	$0
Subtotal, Engineering Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Engineering hours must equal 19,540			↑ Propose more hours. Total Engineering hours must equal 25,969

Fringe & Overhead	Allocation base	rate		Allocation base	rate
Fringe	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Overhead	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subtotal, Fringe & Overhead			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Subcontracts
Subcontractor A (Ctr Type)
Subcontractor B (Ctr Type)
Subcontractor C (Ctr Type)
Subtotal, Subcontracts	0		$0	0		$0
Sub Handling		<rate>	ERROR:#VALUE!		<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subcontracts	0		ERROR:#VALUE!	0		ERROR:#VALUE!	ERROR:#VALUE!

Materials & Equipment
Materials & Equipment
Subtotal, Direct Materials		$0		$0
Material Handling	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!
Subtotal, Materials		ERROR:#VALUE!		ERROR:#VALUE!

Travel (Link to Travel tab)			$0			$0
	Base	Rate		Base	Rate
G&A	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!

Estimated Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Award Fee (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Cost Plus Award Fee		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!	←Link to "Task Order Price Summary" Tab
*Allocation pools & bases vary by offeror. Equations, pool names, etc. may need to be adjusted by offerors.

CLIN 0002 and 1002 Breakout

	Option Year 1 (CLIN 0002)			Option Year 2 (CLIN 1002)			Total
Program Management Direct Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Dollars
Technical Lead		$0.00	$0		$0.00	$0
Software Engineer V / Engineer/Scientist V		$0.00	$0		$0.00	$0
CBRN Hazard Modeling Subject Matter Expert (SME)		$0.00	$0		$0.00	$0
Subtotal, Program Management Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Program Management hours must equal 546			↑ Propose more hours. Total Program Management hours must equal 696

Engineering Direct Labor
Program Manager		$0.00	$0		$0.00	$0
Lead Test Engineer		$0.00	$0		$0.00	$0
Sr. Web Application Developer		$0.00	$0		$0.00	$0
Sr. Application Development Engineer		$0.00	$0		$0.00	$0
Engineer Scientist V/Lead Software Architect		$0.00	$0		$0.00	$0
Engineer Scientist IV		$0.00	$0		$0.00	$0
Engineer Scientist III/Software Engineer/Programmer		$0.00	$0		$0.00	$0
Computer Programmer III		$0.00	$0		$0.00	$0
Computer Programmer II		$0.00	$0		$0.00	$0
Quality Assurance Analyst/Configuration Specialist		$0.00	$0		$0.00	$0
Platform Configuration & Administration Specialist		$0.00	$0		$0.00	$0
Subtotal, Engineering Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Engineering hours must equal 3,324			↑ Propose more hours. Total Engineering hours must equal 3,915

Fringe & Overhead	Allocation base	rate		Allocation base	rate
Fringe	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Overhead	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subtotal, Fringe & Overhead			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Subcontracts
Subcontractor A (Ctr Type)
Subcontractor B (Ctr Type)
Subcontractor C (Ctr Type)
Subtotal, Subcontracts	0		$0	0		$0
Sub Handling		<rate>	ERROR:#VALUE!		<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subcontracts	0		ERROR:#VALUE!	0		ERROR:#VALUE!	ERROR:#VALUE!

Travel (Link to Travel tab) $0 $0

G&A	Base	Rate		Base	Rate
Non-Pass-Through G&A (Labor, Fringe, OH on Labor, Travel)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Pass-Through G&A (Subcontracts & resulting indirects)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
G&A			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Estimated Non-Pass-Through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Estimated Pass-through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Non-Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Cost Plus Fixed Fee		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!	←Link to "Task Order Price Summary" Tab
*Allocation pools & bases vary by offeror. Equations, pool names, etc. may need to be adjusted by offerors.

CLIN 0003 and 1003 Breakout

	Base Period (CLIN 0003)			Option Year 1 (CLIN 1003)			Total
Program Management Direct Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Dollars
Technical Lead		$0.00	$0		$0.00	$0
Software Engineer V / Engineer/Scientist V		$0.00	$0		$0.00	$0
CBRN Hazard Modeling Subject Matter Expert (SME)		$0.00	$0		$0.00	$0
Subtotal, Program Management Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Program Management hours must equal 273			↑ Propose more hours. Total Program Management hours must equal 348

Engineering Direct Labor
Program Manager		$0.00	$0		$0.00	$0
Lead Test Engineer		$0.00	$0		$0.00	$0
Sr. Web Application Developer		$0.00	$0		$0.00	$0
Sr. Application Development Engineer		$0.00	$0		$0.00	$0
Engineer Scientist V/Lead Software Architect		$0.00	$0		$0.00	$0
Engineer Scientist IV		$0.00	$0		$0.00	$0
Engineer Scientist III/Software Engineer/Programmer		$0.00	$0		$0.00	$0
Computer Programmer III		$0.00	$0		$0.00	$0
Computer Programmer II		$0.00	$0		$0.00	$0
Quality Assurance Analyst/Configuration Specialist		$0.00	$0		$0.00	$0
Platform Configuration & Administration Specialist		$0.00	$0		$0.00	$0
Subtotal, Engineering Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Engineering hours must equal 1,662			↑ Propose more hours. Total Engineering hours must equal 1957

Fringe & Overhead	Allocation base	rate		Allocation base	rate
Fringe	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Overhead	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subtotal, Fringe & Overhead			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Subcontracts
Subcontractor A (Ctr Type)
Subcontractor B (Ctr Type)
Subcontractor C (Ctr Type)
Subtotal, Subcontracts	0		$0	0		$0
Sub Handling		<rate>	ERROR:#VALUE!		<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subcontracts	0		ERROR:#VALUE!	0		ERROR:#VALUE!	ERROR:#VALUE!

G&A	Base	Rate		Base	Rate
Non-Pass-Through G&A (Labor, Fringe, OH on Labor, Travel)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Pass-Through G&A (Subcontracts & resulting indirects)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
G&A			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Estimated Non-Pass-Through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Estimated Pass-through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Non-Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Cost Plus Fixed Fee		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!	←Link to "Task Order Price Summary" Tab
*Allocation pools & bases vary by offeror. Equations, pool names, etc. may need to be adjusted by offerors.

CLIN 0004 and 1004 Breakout

	Base Period (CLIN 0004)			Option Year 1 (CLIN 1004)			Total
Program Management Direct Labor	Hours/Units	Rate	Dollars	Hours/Units	Rate	Dollars	Hours/Units	Dollars
Technical Lead		$0.00	$0		$0.00	$0
Software Engineer V / Engineer/Scientist V		$0.00	$0		$0.00	$0
CBRN Hazard Modeling Subject Matter Expert (SME)		$0.00	$0		$0.00	$0
Subtotal, Program Management Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Program Management hours must equal 91			↑ Propose more hours. Total Program Management hours must equal 696

Engineering Direct Labor
Program Manager		$0.00	$0		$0.00	$0
Lead Test Engineer		$0.00	$0		$0.00	$0
Sr. Web Application Developer		$0.00	$0		$0.00	$0
Sr. Application Development Engineer		$0.00	$0		$0.00	$0
Engineer Scientist V/Lead Software Architect		$0.00	$0		$0.00	$0
Engineer Scientist IV		$0.00	$0		$0.00	$0
Engineer Scientist III/Software Engineer/Programmer		$0.00	$0		$0.00	$0
Computer Programmer III		$0.00	$0		$0.00	$0
Computer Programmer II		$0.00	$0		$0.00	$0
Quality Assurance Analyst/Configuration Specialist		$0.00	$0		$0.00	$0
Platform Configuration & Administration Specialist		$0.00	$0		$0.00	$0
Subtotal, Engineering Direct Labor	0		$0	0		$0
	↑ Propose more hours. Total Engineering hours must equal 554			↑ Propose more hours. Total Engineering hours must equal 3915

Fringe & Overhead	Allocation base	rate		Allocation base	rate
Fringe	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Overhead	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subtotal, Fringe & Overhead			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Subcontracts
Subcontractor A (Ctr Type)
Subcontractor B (Ctr Type)
Subcontractor C (Ctr Type)
Subtotal, Subcontracts	0		$0	0		$0
Sub Handling		<rate>	ERROR:#VALUE!		<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Subcontracts	0		ERROR:#VALUE!	0		ERROR:#VALUE!	ERROR:#VALUE!

G&A	Base	Rate		Base	Rate
Non-Pass-Through G&A (Labor, Fringe, OH on Labor, Travel)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Pass-Through G&A (Subcontracts & resulting indirects)	<Sum>	<rate>	ERROR:#VALUE!	<Sum>	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
G&A			ERROR:#VALUE!			ERROR:#VALUE!	ERROR:#VALUE!

Estimated Non-Pass-Through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Estimated Pass-through Cost		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Non-Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Fixed Fee, Pass-Through Costs (use ceiling rate)	<rate>	ERROR:#VALUE!	<rate>	ERROR:#VALUE!	ERROR:#VALUE!
Cost Plus Fixed Fee		ERROR:#VALUE!		ERROR:#VALUE!	ERROR:#VALUE!	←Link to "Task Order Price Summary" Tab
*Allocation pools & bases vary by offeror. Equations, pool names, etc. may need to be adjusted by offerors.

Travel

CPAF(R&D), Base Year, CLIN 0001	Number of		Duration	R/T	Per Diem		Daily Car Rental	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
From <Origin> to Washington, DC	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to Dahlgren, VA	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to San Diego, CA	4	1	3						$0	$0	$0	$0	$0	$0
Base Year Travel Cost									$0	$0	$0	$0	$0	$0	← Link to "CLIN 0001 and 1001 Breakout" Tab

CPAF(R&D), Option Year, CLIN 1001	Number of		Duration	R/T	Per Diem		Car Rental per Day	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
From <Origin> to Washington, DC	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to Dahlgren, VA	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to San Diego, CA	4	1	3						$0	$0	$0	$0	$0	$0
Option Year Travel Costs									$0	$0	$0	$0	$0	$0	← Link to "CLIN 0001 and 1001 Breakout" Tab
CPFF(O&M), Base Year, CLIN 0002	Number of		Duration	R/T	Per Diem		Daily Car Rental	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
From <Origin> to Washington, DC	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to Dahlgren, VA	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to San Diego, CA	4	1	3						$0	$0	$0	$0	$0	$0
Base Year Travel Cost									$0	$0	$0	$0	$0	$0	← Link to "CLIN 0002 and 1002 Breakout" Tab

CPFF(O&M), Option Year, CLIN 1002	Number of		Duration	R/T	Per Diem		Car Rental per Day	Other per Trip	Total					Total Cost
	People	Trips	Days	Airfare	Lodging	M&IE			Airfare	Lodging	M&IE	Rental	Other
From <Origin> to Washington, DC	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to Dahlgren, VA	1	1	3						$0	$0	$0	$0	$0	$0
From <Origin> to San Diego, CA	4	1	3						$0	$0	$0	$0	$0	$0
Option Year Travel Costs									$0	$0	$0	$0	$0	$0	← Link to "CLIN 0002 and 1002 Breakout" Tab

File details come from the government source that posted it. Updated Nov 14, 2017.