HR001118S0032_Attachment_2_Cost_Summary_V2.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Blackjack
- Solicitation number
- HR001118S0032
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 | ||
| QandA_Round_3.docx | DOCX document | |
| QandA_Round_2.pdf | ||
| QandA_Round_1.pdf | ||
| HR001118S0032.pdf | ||
| HR001118S0032_Attachment_1_SCG_Request_Form.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: | |||||||||||||
| Duration | Intensity | Labor Hours | |||||||||||
| SOW Task | (months) | (hrs/mo) | Sr | Mid | Jr | Total | SubC | Conslt | Total | ||||
| 1 | <Phase 1 Task 1 name> | 6 | 157 | 240 | 680 | 24 | 944 | - 0 | 200 | 1,144 | Notes | ||
| 1.1 | <Subtask 1.1 name> | 5 | 72 | 80 | 280 | - 0 | 360 | - 0 | 200 | 560 | 1 | Numbers are illustrative | |
| 1.2 | <Subtask 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 | |
| 2 | <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 | |
| 2.1 | <Subtask 2.1 name> | 2 | 984 | 48 | 320 | 1,600 | 1,968 | 600 | - 0 | 2,568 | Adding more tasks will require editing the Total Hours formulas | ||
| 2.2 | <Subtask 2.2 name> | 4 | 85 | 60 | 80 | 200 | 340 | 800 | - 0 | 1,140 | 4 | Pasting into proposal as a picture will produce the best results; please also submit as excel | |
| : | : | : | : | : | : | : | : | : | : | : | |||
| Phase 1 Total Hours | 348 | 1,080 | 1,824 | 3,252 | 1,400 | 200 | 4,852 | ||||||
| Phase 1 Costs Column "I" for prime, Column "J" is | Travel | $ 44,000 | $ 12,000 | $ 2,000 | $ 58,000 | ||||||||
| total subcontractor, Column "K" is total consultant | Materials & Equipment | $ 8,000 | $ - 0 | $ - 0 | $ 8,000 | ||||||||
| 1 | <Phase 2 Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | 100 | 1,000 | May 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> | 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 | <Phase 2 Task 1 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 | ||||||
| (If needed) Phase 2 Costs Column "I" for prime, Column "J" is | Travel | $ 47,000 | $ 12,000 | $ 2,000 | $ 61,000 | ||||||||
| total subcontractor, Column "K" is total consultant | Materials & Equipment | $ 4,000 | $ - 0 | $ - 0 | $ 4,000 | ||||||||
| Project Total Hours | 704 | 2,160 | 3,688 | 6,552 | 2,740 | 300 | 9,592 | ||||||
| Project Total Costs | Travel | $ 91,000 | $ 24,000 | $ 4,000 | $ 119,000 | ||||||||
| Materials & Equipment | $ 12,000 | $ - 0 | $ - 0 | $ 12,000 | |||||||||
| 1 | <Phase 2 Option 1 Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | 100 | 1,000 | May 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> | 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 | <Phase 2 Option 1 Task 1 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 | ||||||
| (If needed) Phase 2 Costs Column "I" for prime, Column "J" is | Travel | $ 47,000 | $ 12,000 | $ 2,000 | $ 61,000 | ||||||||
| total subcontractor, Column "K" is total consultant | Materials & Equipment | $ 4,000 | $ - 0 | $ - 0 | $ 4,000 | ||||||||
| Project Total Hours | 1,060 | 3,240 | 5,552 | 9,852 | 4,080 | 400 | 14,332 | ||||||
| Project Total Costs | Travel | $ 138,000 | $ 36,000 | $ 6,000 | $ 180,000 | ||||||||
| Materials & Equipment | $ 16,000 | $ - 0 | $ - 0 | $ 16,000 | |||||||||
| 1 | <Phase 3 Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | 100 | 1,000 | May 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> | 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 | <Phase 3 Task 1 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 | ||||||
| (If needed) Phase 3 Costs Column "I" for prime, Column "J" is | Travel | $ 47,000 | $ 12,000 | $ 2,000 | $ 61,000 | ||||||||
| total subcontractor, Column "K" is total consultant | Materials & Equipment | $ 4,000 | $ - 0 | $ - 0 | $ 4,000 | ||||||||
| Project Total Hours | 1,060 | 3,240 | 5,552 | 9,852 | 4,080 | 400 | 13,932 | ||||||
| Project Total Costs | Travel | $ 138,000 | $ 36,000 | $ 6,000 | $ 180,000 | ||||||||
| Materials & Equipment | $ 16,000 | $ - 0 | $ - 0 | $ 16,000 |
Example Material Table
| Company name: | |||||||
| BOM number | Phase number | Part Number | Part Description | Manufacturer | Quantity required | Unit Price | Total 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 Number | Phase Number | Destination | Purpose of Trip | #people | #nights | Total 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 Satellites | Cost per Satellite | Non Recurring cost | Total Cost | Notes |
| 2 | $0 | |||
| 5 | $0 | |||
| 10 | $0 | |||
| 20 | $0 | |||
| Insert full Constellation satellite count | ERROR:#VALUE! |
File details come from the government source that posted it. Updated .