HR001117S0011_1_Attachment_2_Cost_Summary_Spreadsheet.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- OFFensive Swarm Enabled Tactics (OFFSET) Amendment 5 - Swarm Sprint 4 Federal contract opportunity
- Solicitation number
- HR001117S0011
About this file
This document contains a cost proposal template and summary for a federal contract opportunity related to swarm system development. The template provides instructions and columns for estimating labor hours, costs, and materials for prime contractor, subcontractor, and consultant work over multiple phases and tasks. The related opportunity notice seeks proposals to advance swarm tactics through the design, development, and demonstration of a swarm system architecture encoded in a game-based environment and embodied in physical swarm platforms. The sponsor is the Defense Advanced Research Projects Agency. Proposals are due by the dates specified in Amendment 5 of solicitation HR001117S0011 for the OFFensive Swarm Enabled Tactics technical area. The template includes details to help applicants estimate costs for personnel, travel, materials, and equipment for the full project period.
Not Listed
View the file
Other files for this federal contract opportunity
Show all 50
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
Text version
Example BAA LOE Template
| 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; please replace with appropriate numbers per your cost proposal |
| 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,652 | |||||
| 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 | <Option Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | 100 | 1,000 | ||
| 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,640 | |||||
| (If needed) Option 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,292 | |||||
| Project Total Costs | Travel | $ 91,000 | $ 24,000 | $ 4,000 | $ 119,000 | |||||||
| Materials & Equipment | $ 12,000 | $ - 0 | $ - 0 | $ 12,000 |
Example Material Table
| BOM 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 Travel | $0.00 |
Example Travel Table
Trip Number Destination Purpose of Trip #people #nights Total Cost
Total Travel $0.00
File details come from the government source that posted it. Updated .