HR001117S0011_6_Attachment_4_Cost_Summary.xlsx

XLSX spreadsheet 98 KB Posted Sep 26, 2019

Attached to: OFFensive Swarm Enabled Tactics (OFFSET) Sprint 5
Solicitation number: HR001117S0011-06
Issued by: Defense Advanced Research Projects Agency

About this file

From the source

Not Listed

View the file

Other files

File	Type	Posted
HR001117S0011-06-Amendment-01.pdf	PDF	Nov 7, 2019
HR001117S0011_6_Attachment_7_Cost_Proposal_Template.docx	DOCX document	Sep 26, 2019
HR001117S0011_6_Attachment_2_Proposal_Cover_Sheet.pdf	PDF	Sep 26, 2019
HR001117S0011-06.pdf	PDF	Sep 26, 2019
HR001117S0011_6_Attachment_8_Accelerator.docx	DOCX document	Sep 26, 2019
HR001117S0011_6_Attachment_6_Tech_Proposal_Template.docx	DOCX document	Sep 26, 2019
HR001117S0011_6_Attachment_3_Summary_Slide.pptx	PPTX presentation	Sep 26, 2019
HR001117S0011_6_Attachment_5_Admin_National_Policy.docx	DOCX document	Sep 26, 2019
HR001117S0011_6_Attachment_1_Attachments_Checklist_V2.docx	DOCX document	Sep 26, 2019

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.

TABLE 1 Cost Summary

PROPOSER NAME:

PROPOSER ORGANIZATION:

TABLE 1: Cost Summary
	Base Effort					Option 1					Option 2 (Accelerator)					Total Program
Category	Labor	Travel	Mats & Equip	Other ODC	Total Base	Labor	Travel	Mats & Equip	Other ODC	Total O1	Labor	Travel	Mats & Equip	Other ODC	Total O2	Labor	Travel	Mats & Equip	Other ODC
Prime Performer (no sub costs included)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Subcontractor 1 (no prime costs included)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Subcontractor 2 (no prime costs included)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Subcontractor 3 (no prime costs included)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Independent Consultant 1 (no prime/sub costs included)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total by Phase	$0					$0					$0					$0

&"Times New Roman,Regular"&12&K000000Source Selection Information — see FAR 2.101 & 3.104

&"Times New Roman,Regular"&12&K000000BAA# HR001117S0011-6 &"Times New Roman,Regular"&12&K000000OFFensive Swarm-Enabled Tactics (OFFSET) &"Times New Roman,Regular"&12&K000000Page &P of &N

Notes

1-Numbers are illustrative

2-Numbers in blue are inputs; numbers in black are computed by formulas

3-Prime and subcontractor/consultant costs should not be combined on lines in the Cost Summary Table

4-Add or subtract rows/columns depending on number of subcontractors/consultants proposed for the effort

5-Total Program Costs should be consistent throughout worksheets (Table 1 and Table 2), Cost Volume, and Cover Sheet

6-Pasting into proposal as a picture will produce the best results; please also submit as excel

7-Phase totals should include G&A and fee

TABLE 2 Level-of-Effort

TABLE 2: Level of Effort, By Hours/By Task
		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC	Ind. Conslt	Total
1	<Phase 1 Task 1 name>	6	157	240	680	24	944	- 0	200	1,144
1.1	<Subtask 1.1 name>	5	72	80	280	- 0	360	- 0	200	560
1.2	<Subtask 1.2 name>	3	195	160	400	24	584	- 0	- 0	584
2	<Phase 1 Task 2 name>	6	385	108	400	1,800	2,308	1,400	- 0	3,708
2.1	<Subtask 2.1 name>	2	984	48	320	1,600	1,968	600	- 0	2,568
2.2	<Subtask 2.2 name>	4	85	60	80	200	340	800	- 0	1,140
			Phase 1 Total Hours	348	1,080	1,824	3,252	1,400	200	4,852

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC	Ind. Conslt	Total
1	<Option Task 1 name>	8	100	176	560	64	800	100	100	1,000	May zero-out blue entries if not proposing an Option
1.1	<Subtask 1.1 name>	7	51	96	240	24	360	100	100	560
1.2	<Subtask 1.2 name>	4	110	80	320	40	440	- 0	- 0	440
2	<Option Task 2 name>	6	417	180	520	1,800	2,500	1,240	- 0	3,740
2.1	<Subtask 2.1 name>	4	435	140	400	1,200	1,740	400	- 0	2,140
2.2	<Subtask 2.2 name>	4	190	40	120	600	760	840	- 0	1,600
			Option Total Hours	356	1,080	1,864	3,300	1,340	100	4,740
			Project Total Hours	704	2,160	3,688	6,552	2,740	300	9,592

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC	Ind. Conslt	Total
1	<Accelerator Option Task 1 name>	8	100	176	560	64	800	100	100	1,000	May zero-out blue entries if not proposing an Option
1.1	<Subtask 1.1 name>	7	51	96	240	24	360	100	100	560
1.2	<Subtask 1.2 name>	4	110	80	320	40	440	- 0	- 0	440
2	<Accelerator Option Task 2 name>	6	417	180	520	1,800	2,500	1,240	- 0	3,740
2.1	<Subtask 2.1 name>	4	435	140	400	1,200	1,740	400	- 0	2,140
2.2	<Subtask 2.2 name>	4	190	40	120	600	760	840	- 0	1,600
			Option Total Hours	356	1,080	1,864	3,300	1,340	100	4,740
			Project Total Hours	1,060	3,240	5,552	9,852	4,080	400	13,932

&"Times New Roman,Regular"&12Source Selection Information — see FAR 2.101 & 3.104

&"Times New Roman,Regular"&12BAA# HR001117S0011-6	&"Times New Roman,Regular"&12
OFFensive Swarm-Enabled Tactics (OFFSET)	&"Times New Roman,Regular"&12Page &P of &N

Notes

1-Numbers are illustrative

2-Numbers in blue are inputs; numbers in black are computed by formulas

3-Total Program Costs should be consistent throughout worksheets (Table 1 and Table 2), Cost Volume, and Cover Sheet

4-In the Task table, lines roll-up subtask numbers, so each Total Hours row should only sum the task lines

5-Adding more tasks will require editing the Total Hours formulas

6-Pasting into proposal as a picture will produce the best results; please also submit as excel

TABLE 3 Bill of Materials

TABLE 3: Bill of Materials
BASE	BOM number	Part Number	Part Description	Manufacturer	Quantity required	Unit Price ($)	Total Cost
							$0.00
							$0.00
							$0.00
							$0.00
							$0.00
					Base Material Cost		$0.00

OPTION 1	BOM number	Part Number	Part Description	Manufacturer	Quantity required	Unit Price ($)	Total Cost
							$0.00	May delete entries if not proposing an Option
							$0.00
							$0.00
							$0.00
							$0.00
					Option 1 Material Cost		$0.00

OPTION 2	BOM number	Part Number	Part Description	Manufacturer	Quantity required	Unit Price ($)	Total Cost
							$0.00	May delete entries if not proposing an Option
							$0.00
							$0.00
							$0.00
							$0.00
					Option 2 Material Cost		$0.00

TOTAL MATERIAL COSTS $0.00

&"Times New Roman,Regular"&12Source Selection Information — see FAR 2.101 & 3.104

&"Times New Roman,Regular"&12BAA# HR001117S0011-6 &"Times New Roman,Regular"&12OFFensive Swarm-Enabled Tactics (OFFSET) &"Times New Roman,Regular"&12Page &P of &N

Notes

1-Part Descriptions should be explanatory and not be designated as "General" or "MISC"

TABLE 4 Travel

TABLE 4: Travel Summary Table
Purpose of Trip	From (Originating Location)	To (Destination Location)	Prime (P) or Subcontractor (S)	No. Staff	No. Mtg Days Per Trip	No. Nights Per Trip	Airfare/Rail ($)	Ground Trans/Day ($)	Meals / Day ($)	Lodging / Day ($)	Cost Per Person ($)	Total ($)	COMPLETE TRAVEL TABLE
											$0	$0
											$0	$0
											$0	$0
											$0	$0
											$0	$0
										Total Travel		$0.00

Purpose of Trip	From (Originating Location)	To (Destination Location)	Prime (P) or Subcontractor (S)	No. Staff	No. Mtg Days Per Trip	No. Nights Per Trip	Airfare/Rail ($)	Ground Trans/Day ($)	Meals / Day ($)	Lodging / Day ($)	Cost Per Person ($)	Total ($)	EXAMPLE TABLE/ILLUSTRATIVE
TIM1	New York, NY	Arlington, VA	P	2	2	1	$325	$20	$35	$200	$635	$1,270
TIM1	Princeton, NJ	Arlington, VA	S	1	2	1	$250		$40	$200	$530	$530
TIM2	New York, NY	Arlington, VA	P	2	2	1	$325	$20	$35	$200	$635	$1,270
TIM2	Princeton, NJ	Arlington, VA	S	1	2	1	$250		$40	$200	$530	$530
										Total Travel		$3,600.00

&"Times New Roman,Regular"&12Source Selection Information — see FAR 2.101 & 3.104

&"Times New Roman,Regular"&12BAA# HR001117S0011-6 &"Times New Roman,Regular"&12OFFensive Swarm-Enabled Tactics (OFFSET) &"Times New Roman,Regular"&12Page &P of &N

Notes

1-For each Purpose of Trip, please use individual lines for Prime personnel (P) and Subcontractor personnel (S) with associated costs, so that total travel costs match those cited in the Cost Volume.

2-It is expected that conference costs are not allowable for this effort

3-Purpose of Trip may include Technical Exchange Meetings and/or other relevant Sprint events proposed

4-For Locations, please use City/State. If outside of US, please use City/Country

Dashboard

&"Times New Roman,Regular"&12Source Selection Information — see FAR 2.101 & 3.104

&"Times New Roman,Regular"&12BAA# HR001117S0011-3 &"Times New Roman,Regular"&12OFFensive Swarm-Enabled Tactics (OFFSET) &"Times New Roman,Regular"&12Page &P of &N image1.emf image2.emf image3.emf image4.emf image5.emf image6.emf image7.emf image8.emf image9.emf image10.emf

File details come from the government source that posted it.