HR001117S0011_5_Attachment_4_Cost_Summary.xlsx
XLSX spreadsheet 103 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 package includes cost proposal templates and instructions for a federal contract opportunity related to developing swarm system architecture and autonomous platforms. The templates require proposers to provide cost and pricing details for labor, travel, materials, and other direct costs for the base effort and two option periods. Costs must be presented by task and labor category in the templates for the prime contractor and any subcontractors or consultants. Proposers are also instructed to complete tables detailing levels of effort by labor category and task, bills of materials, and an itemized travel summary. The related opportunity notice seeks proposals to design, develop and demonstrate swarm tactics and integration through a game-based environment and physical platforms, to advance innovation in swarm systems. Proposals are due by amendment to the Defense Advanced Research Projects Agency for the OFFensive Swarm Enabled Tactics program.
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
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-5 &"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-5 | &"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-5 &"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-5 &"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. Updated .