Attachment_1_BAA_proposal_WB_table_template.xlsx

XLSX spreadsheet 21 KB Posted Jun 5, 2019

Attached to: Air Combat Evolution (ACE) Federal contract opportunity
Solicitation number: HR001119S0051
Issued by: Defense Advanced Research Projects Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a template for a Statement of Work (SOW) and budget table for responding to a Broad Agency Announcement (BAA) from the Defense Advanced Research Projects Agency (DARPA). The template includes sections for task descriptions, durations, labor categories and hours by phase and task for the prime contractor and subcontractors. It also includes a section for total project costs by labor category and expenses. The related federal contract opportunity is a pre-solicitation notice for the Air Combat Evolution (ACE) program, which seeks to increase trust in combat autonomy by automating within-visual-range aerial maneuvering from modeling and simulation to small unmanned aerial vehicles and operational aircraft. Proposals are solicited but no pricing, response dates or award dates are included.

From the source

Not Listed

View the file

Other files for this federal contract opportunity

Other files attached to Air Combat Evolution (ACE), newest first.
File	Type	Posted
HR001119S0051-Amendment-03.pdf	PDF	Jul 11, 2019
HR001119S0051-Amendment-02.pdf	PDF	Jun 7, 2019
HR001119S0051-Amendment-01.pdf	PDF	Jun 6, 2019
HR001119S0051.pdf	PDF	Jun 5, 2019

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.

BAA WB Template

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC-Sr	SubC-Mid	SubC-Jr	Conslt	Total
1.1.0	<Phase 1 Task 1 name>	7	135	240	680	24	944	- 0			200	1,144		Notes
1.1.1	<Subtask 1.1.1 name>	4	90	80	280	- 0	360	- 0			200	560	1	Numbers are illustrative, see the second tab for a template without numbers
1.1.2	<Subtask 1.1.2 name>	3	195	160	400	24	584	- 0			- 0	584	2	Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0	<Phase 1 Task 2 name>	6	385	108	400	1,800	2,308	1,400			- 0	3,708	3	Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1	<Subtask 1.2.1 name>	3	656	48	320	1,600	1,968	600			- 0	2,568		Adding more tasks will require editing the Total Hours formulas
1.2.2	<Subtask 1.2.2 name>	3	113	60	80	200	340	800			- 0	1,140	4	Pasting into proposal as a picture will produce the best results
:	:	:	:	:	:	:	:	:			:	:	5	If you have more than 12 tasks and subtasks per phase, you can break the table into
			Phase 1 Total Hours	348	1,080	1,824	3,252	1,400			200	4,652		into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
			Phase 1 Costs First column is prime, second is			Travel	$ 44,000	$ 12,000			$ 2,000	$ 58,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 8,000	$ - 0			$ - 0	$ 8,000
2.1.0	<Phase 2 Task 1 name>	8	100	176	560	64	800	100			100	1,000
2.1.1	<Subtask 2.1.1 name>	7	51	96	240	24	360	100			100	560
2.1.2	<Subtask 2.1.2 name>	4	110	80	320	40	440	- 0			- 0	440
2.2.0	<Phase 2 Task 2 name>	6	417	180	520	1,800	2,500	1,240			- 0	3,740
2.2.1	<Subtask 2.2.1 name>	4	435	140	400	1,200	1,740	400			- 0	2,140
2.2.2	<Subtask 2.2.2 name>	4	190	40	120	600	760	840			- 0	1,600
:	:	:	:	:	:	:	:	:			:	:
			Phase 2 Total Hours	356	1,080	1,864	3,300	1,340			100	4,640
			Phase 2 Costs First column is prime, second is			Travel	$ 47,000	$ 12,000			$ 2,000	$ 61,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 4,000	$ - 0			$ - 0	$ 4,000
3.1.0	<Phase 3 Task 1 name>	9	71	120	400	120	640	100			100	840
3.1.1	<Subtask 3.1.1 name>	3	93	40	200	40	280	100			100	480
3.1.2	<Subtask 3.1.2 name>	6	60	80	200	80	360	- 0			- 0	360
3.2.0	<Phase 3 Task 2 name>	6	460	160	800	1,800	2,760	1,200			- 0	3,960
3.2.1	<Subtask 3.2.1 name>	4	370	80	400	1,000	1,480	600			- 0	2,080
3.2.2	<Subtask 3.2.2 name>	3	427	80	400	800	1,280	600			- 0	1,880
:	:	:	:	:	:	:	:	:			:	:
			Phase 3 Total Hours	280	1,200	1,920	3,400	1,300			100	4,800
			Phase 3 Costs First column is prime, second is			Travel	$ 48,000	$ 12,000			$ 2,000	$ 62,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ - 0	$ - 0			$ - 0	$ - 0
			Project Total Hours	984	3,360	5,608	9,952	4,040			400	14,092
			Total Project Costs First column is prime, second is			Travel	$ 139,000	$ 36,000			$ 6,000	$ 181,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 12,000	$ - 0			$ - 0	$ 12,000

Template no numbers

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC-Sr	SubC-Mid	SubC-Jr	Conslt	Total
1.1.0	<Phase 1 Task 1 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0		Notes
1.1.1	<Subtask 1.1.1 name>		n.a.			- 0	- 0	- 0				- 0	1	Numbers are illustrative, see the second tab for a template without numbers
1.1.2	<Subtask 1.1.2 name>		n.a.				- 0	- 0			- 0	- 0	2	Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0	<Phase 1 Task 2 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0	3	Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1	<Subtask 1.2.1 name>		n.a.				- 0				- 0	- 0		Adding more tasks will require editing the Total Hours formulas
1.2.2	<Subtask 1.2.2 name>		n.a.				- 0				- 0	- 0	4	Pasting into proposal as a picture will produce the best results
:	:	:	:	:	:	:	:	:			:	:	5	If you have more than 12 tasks and subtasks per phase, you can break the table into
			Phase 1 Total Hours	- 0	- 0	- 0	- 0	- 0			- 0	- 0		into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
			Phase 1 Costs First column is prime, second is			Travel						$ - 0
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment		$ - 0			$ - 0	$ - 0
2.1.0	<Phase 2 Task 1 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0
2.1.1	<Subtask 2.1.1 name>		n.a.				- 0					- 0
2.1.2	<Subtask 2.1.2 name>		n.a.				- 0	- 0			- 0	- 0
2.2.0	<Phase 2 Task 2 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0
2.2.1	<Subtask 2.2.1 name>		n.a.				- 0				- 0	- 0
2.2.2	<Subtask 2.2.2 name>		n.a.				- 0				- 0	- 0
:	:	:	:	:	:	:	:	:			:	:
			Phase 2 Total Hours	- 0	- 0	- 0	- 0	- 0			- 0	- 0
			Phase 2 Costs First column is prime, second is			Travel
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment		$ - 0			$ - 0	$ - 0
3.1.0	<Phase 3 Task 1 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0
3.1.1	<Subtask 3.1.1 name>		n.a.				- 0					- 0
3.1.2	<Subtask 3.1.2 name>		n.a.				- 0	- 0			- 0	- 0
3.2.0	<Phase 3 Task 2 name>		n.a.	- 0	- 0	- 0	- 0	- 0			- 0	- 0
3.2.1	<Subtask 3.2.1 name>		n.a.				- 0				- 0	- 0
3.2.2	<Subtask 3.2.2 name>		n.a.				- 0				- 0	- 0
:	:	:	:	:	:	:	:	:			:	:
			Phase 3 Total Hours	- 0	- 0	- 0	- 0	- 0			- 0	- 0
			Phase 3 Costs First column is prime, second is			Travel
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ - 0	$ - 0			$ - 0	$ - 0
			Project Total Hours	- 0	- 0	- 0	- 0	- 0			- 0	- 0
			Total Project Costs First column is prime, second is			Travel					$ - 0	$ - 0
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ - 0	$ - 0			$ - 0	$ - 0

File details come from the government source that posted it. Updated Dec 27, 2023.