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 includes cost tables and templates for a proposal response to a federal contract solicitation. The solicitation seeks proposals for the OFFensive Swarm Enabled Tactics program to design, develop and demonstrate a swarm system architecture encoded in a game environment and embodied in physical swarm platforms. The cost tables require proposers to provide labor hours and costs by task for the base effort and any option periods, along with materials, travel and subcontractor costs. The templates provide guidance on the level of detail required for items like staff qualifications, bills of materials, and travel plans. Proposers are instructed to complete the templates and include them along with a cost proposal in response to the solicitation.
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 .