HR001117S0011_3_Attachment_4_Cost_Summary.xlsx
XLSX spreadsheet 99 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 cost proposal templates for a federal contract opportunity related to advancing swarm tactics through game-based simulation and physical platform demonstration. The templates include tables for cost summary by program category and phase, level of effort by labor hours and task, bill of materials, and travel. Contractors should complete the templates to detail their proposed costs for the base effort and optional acceleration and include them in their proposal along with a cost volume and cover sheet. The Defense Advanced Research Projects Agency is the contracting agency. Contractors should structure their cost proposals according to the templates, which include formulas and formatting instructions to ensure consistency and ease of review.
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-3 &"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-3 | &"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-3 &"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-3 &"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 .