HR001118S0032_Attachment_2_Cost_Summary_V2.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Blackjack
Solicitation number
HR001118S0032
Issued by

About this file

This document contains a cost summary template and notes for a proposal in response to Solicitation Number HR001118S0032 from the Defense Advanced Research Projects Agency. The proposal involves developing and demonstrating a low Earth orbit satellite constellation called Blackjack that will provide global persistent coverage. The cost summary template includes tables for labor hours and costs by task and phase, materials and equipment, and travel. Notes provide guidance on using the template and outline costs for phases 1 through 3 of the project as well as total projected costs for labor, materials, and travel.

Not Listed

View the file

Other files

File Type Posted
HR001118S0032-Amendment-01.pdf PDF
QandA_Round_3.docx DOCX document
QandA_Round_2.pdf PDF
QandA_Round_1.pdf PDF
HR001118S0032.pdf PDF
HR001118S0032_Attachment_1_SCG_Request_Form.pdf PDF
HR001118S0032_Attachment_4_Summary_Slides.PPTX PPTX presentation
HR001118S0032_Attachment_3_Proposal_Template_Adm_National_Policy_V3.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Example BAA LOE Template

Company name:
DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrMidJrTotalSubCConsltTotal
1<Phase 1 Task 1 name>615724068024944- 02001,144Notes
1.1<Subtask 1.1 name>57280280- 0360- 02005601Numbers are illustrative
1.2<Subtask 1.2 name>319516040024584- 0- 05842Numbers in blue are inputs; numbers in black are computed by formulas
2<Phase 1 Task 2 name>63851084001,8002,3081,400- 03,7083Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
2.1<Subtask 2.1 name>2984483201,6001,968600- 02,568Adding more tasks will require editing the Total Hours formulas
2.2<Subtask 2.2 name>4856080200340800- 01,1404Pasting into proposal as a picture will produce the best results; please also submit as excel
:::::::::::
Phase 1 Total Hours3481,0801,8243,2521,4002004,852
Phase 1 Costs Column "I" for prime, Column "J" isTravel$ 44,000$ 12,000$ 2,000$ 58,000
total subcontractor, Column "K" is total consultantMaterials & Equipment$ 8,000$ - 0$ - 0$ 8,000
1<Phase 2 Task 1 name>8100176560648001001001,000May delete these rows if not proposing Phase 2 ROM, or based on the level of detail of the proposed ROM
1.1<Subtask 1.1 name>7519624024360100100560
1.2<Subtask 1.2 name>41108032040440- 0- 0440
2<Phase 2 Task 1 name>64171805201,8002,5001,240- 03,740
2.1<Subtask 2.1 name>44351404001,2001,740400- 02,140
2.2<Subtask 2.2 name>419040120600760840- 01,600
:::::::::::
Option Total Hours3561,0801,8643,3001,3401004,740
(If needed) Phase 2 Costs Column "I" for prime, Column "J" isTravel$ 47,000$ 12,000$ 2,000$ 61,000
total subcontractor, Column "K" is total consultantMaterials & Equipment$ 4,000$ - 0$ - 0$ 4,000
Project Total Hours7042,1603,6886,5522,7403009,592
Project Total CostsTravel$ 91,000$ 24,000$ 4,000$ 119,000
Materials & Equipment$ 12,000$ - 0$ - 0$ 12,000
1<Phase 2 Option 1 Task 1 name>8100176560648001001001,000May delete these rows if not proposing Phase 2 Option 1 ROM, or based on the level of detail of the proposed ROM
1.1<Subtask 1.1 name>7519624024360100100560
1.2<Subtask 1.2 name>41108032040440- 0- 0440
2<Phase 2 Option 1 Task 1 name>64171805201,8002,5001,240- 03,740
2.1<Subtask 2.1 name>44351404001,2001,740400- 02,140
2.2<Subtask 2.2 name>419040120600760840- 01,600
:::::::::::
Option Total Hours3561,0801,8643,3001,3401004,740
(If needed) Phase 2 Costs Column "I" for prime, Column "J" isTravel$ 47,000$ 12,000$ 2,000$ 61,000
total subcontractor, Column "K" is total consultantMaterials & Equipment$ 4,000$ - 0$ - 0$ 4,000
Project Total Hours1,0603,2405,5529,8524,08040014,332
Project Total CostsTravel$ 138,000$ 36,000$ 6,000$ 180,000
Materials & Equipment$ 16,000$ - 0$ - 0$ 16,000
1<Phase 3 Task 1 name>8100176560648001001001,000May delete these rows if not proposing Phase 3 ROM, or based on the level of detail of the proposed ROM
1.1<Subtask 1.1 name>7519624024360100100560
1.2<Subtask 1.2 name>41108032040440- 0- 0440
2<Phase 3 Task 1 name>64171805201,8002,5001,240- 03,740
2.1<Subtask 2.1 name>44351404001,2001,740400- 02,140
2.2<Subtask 2.2 name>419040120600760840- 01,600
:::::::::::
Option Total Hours3561,0801,8643,3001,3401004,740
(If needed) Phase 3 Costs Column "I" for prime, Column "J" isTravel$ 47,000$ 12,000$ 2,000$ 61,000
total subcontractor, Column "K" is total consultantMaterials & Equipment$ 4,000$ - 0$ - 0$ 4,000
Project Total Hours1,0603,2405,5529,8524,08040013,932
Project Total CostsTravel$ 138,000$ 36,000$ 6,000$ 180,000
Materials & Equipment$ 16,000$ - 0$ - 0$ 16,000

Example Material Table

Company name:
BOM numberPhase numberPart NumberPart DescriptionManufacturerQuantity requiredUnit PriceTotal Cost
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Material$0.00

Example Travel Table

Company name:
Trip NumberPhase NumberDestinationPurpose of Trip#people#nightsTotal Cost

Total Travel $0.00

Example Constellation Cost

NOTE: ONLY include if applicable to your proposed approach, included Notes as needed to clearly explain what is included in your cost estimate
Company name:
Number of SatellitesCost per SatelliteNon Recurring costTotal CostNotes
2$0
5$0
10$0
20$0
Insert full Constellation satellite countERROR:#VALUE!

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