INCAS_BAA_proposal_LoE_table_template_SkillSets.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Influence Campaign Awareness and Sensemaking (INCAS) Federal contract opportunity
- Solicitation number
- HR001121S0008
About this file
This document contains a template for a proposal labor hours and cost table to respond to the Influence Campaign Awareness and Sensemaking (INCAS) program pre-solicitation. The template includes tables to outline tasks, labor hours by skill level, and associated costs over three phases of work for the prime contractor and any proposed subcontractors. The related federal contract opportunity notice provides additional context, with the Defense Advanced Research Projects Agency seeking to develop techniques and tools to help analysts detect, characterize, and track geopolitical influence campaigns through quantified analysis of online media content and narratives. Proposed work under the INCAS program should be outlined using the labor hour and cost template to develop capabilities enabling continual sensemaking of adversarial influence operations within vast online information environments.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HR001121S0008-Amendment-01.pdf | ||
| INCAS_CUI_Guide_Approved_DISTAR.pdf | ||
| HR001121S0008.pdf | ||
| INCAS_BAA_Attachment_Proposal_Summary_Chart_Template.pptx | PPTX presentation |
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
BAA LoE Example
| Duration | Intensity | Labor Hours | ||||||||||||||||||
| SOW Task | (months) | (hrs/mo) | Sr | Skill Set | Mid | Skill Set | Jr | Skill Set | Prime Total | SubC-Sr | Skill Set | SubC-Mid | Skill Set | SubC-Jr | Skill Set | Consult | Program Total | |||
| 1.1.0 | <Phase 1 Task 1 name> | 7 | 135 | 240 | 680 | 24 | 944 | - 0 | - 0 | - 0 | 200 | 1,144 | Notes | |||||||
| 1.1.1 | <Subtask 1.1.1 name> | 4 | 90 | 80 | Engineer | 280 | Engineer | - 0 | 360 | - 0 | 200 | 560 | 1 | Numbers are illustrative, see the second tab for a template without numbers | ||||||
| 1.1.2 | <Subtask 1.1.2 name> | 3 | 195 | 160 | Software Dev | 400 | Software Dev | 24 | Software Dev | 584 | - 0 | - 0 | 584 | 2 | Numbers in blue are inputs, numbers in black are computed by formulas | |||||
| 1.2.0 | <Phase 1 Task 2 name> | 6 | 385 | 108 | 400 | 1,800 | 2,308 | 1,400 | - 0 | - 0 | - 0 | 3,708 | 3 | Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines | ||||||
| 1.2.1 | <Subtask 1.2.1 name> | 3 | 656 | 48 | Data Scientist | 320 | Data Scientist | 1,600 | Data Scientist | 1,968 | 600 | Software Dev | - 0 | 2,568 | Adding more tasks will require editing the Total Hours formulas | |||||
| 1.2.2 | <Subtask 1.2.2 name> | 3 | 113 | 60 | SME III | 80 | SME II | 200 | SME I | 340 | 800 | Engineer | - 0 | 1,140 | 4 | Pasting into proposal as a picture will produce the best results | ||||
| : | : | : | : | : | : | : | : | : | : | : | 5 | If you have more than 12 tasks and subtasks per phase, you can break the table into | ||||||||
| Phase 1 Total Hours | 348 | 1,080 | 1,824 | 3,252 | 1,400 | - 0 | - 0 | 200 | 4,852 | into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page) | ||||||||||
| Phase 1 Costs First column is prime, second is | Travel | $ 44,000 | $ 12,000 | $ 2,000 | $ 58,000 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ 8,000 | $ - 0 | $ - 0 | $ 8,000 | |||||||||||||||
| 2.1.0 | <Phase 2 Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | - 0 | - 0 | 100 | 1,000 | ||||||||
| 2.1.1 | <Subtask 2.1.1 name> | 7 | 51 | 96 | Data Scientist | 240 | Data Scientist | 24 | Data Scientist | 360 | 100 | Engineer | 100 | 560 | ||||||
| 2.1.2 | <Subtask 2.1.2 name> | 4 | 110 | 80 | Software Dev | 320 | SME II | 40 | Software Dev | 440 | - 0 | - 0 | 440 | |||||||
| 2.2.0 | <Phase 2 Task 2 name> | 6 | 417 | 180 | 520 | 1,800 | 2,500 | 1,240 | - 0 | - 0 | - 0 | 3,740 | ||||||||
| 2.2.1 | <Subtask 2.2.1 name> | 4 | 435 | 140 | Data Scientist | 400 | Data Scientist | 1,200 | Data Scientist | 1,740 | 400 | Software Dev | - 0 | 2,140 | ||||||
| 2.2.2 | <Subtask 2.2.2 name> | 4 | 190 | 40 | SME II | 120 | Software Dev | 600 | SME II | 760 | 840 | Engineer | - 0 | 1,600 | ||||||
| : | : | : | : | : | : | : | : | : | : | : | ||||||||||
| Phase 2 Total Hours | 356 | 1,080 | 1,864 | 3,300 | 1,340 | - 0 | - 0 | 100 | 4,740 | |||||||||||
| Phase 2 Costs First column is prime, second is | Travel | $ 47,000 | $ 12,000 | $ 2,000 | $ 61,000 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ 4,000 | $ - 0 | $ - 0 | $ 4,000 | |||||||||||||||
| 3.1.0 | <Phase 3 Task 1 name> | 9 | 71 | 120 | 400 | 120 | 640 | 100 | - 0 | - 0 | 100 | 840 | ||||||||
| 3.1.1 | <Subtask 3.1.1 name> | 3 | 93 | 40 | Software Dev | 200 | Data Scientist | 40 | Data Scientist | 280 | 100 | Engineer | 100 | 480 | ||||||
| 3.1.2 | <Subtask 3.1.2 name> | 6 | 60 | 80 | Software Dev | 200 | SME II | 80 | Software Dev | 360 | - 0 | - 0 | 360 | |||||||
| 3.2.0 | <Phase 3 Task 2 name> | 6 | 460 | 160 | 800 | 1,800 | 2,760 | 1,200 | - 0 | - 0 | - 0 | 3,960 | ||||||||
| 3.2.1 | <Subtask 3.2.1 name> | 4 | 370 | 80 | SME II | 400 | Data Scientist | 1,000 | Data Scientist | 1,480 | 600 | Software Dev | - 0 | 2,080 | ||||||
| 3.2.2 | <Subtask 3.2.2 name> | 3 | 427 | 80 | SME II | 400 | Software Dev | 800 | SME II | 1,280 | 600 | Engineer | - 0 | 1,880 | ||||||
| : | : | : | : | : | : | : | : | : | : | : | ||||||||||
| Phase 3 Total Hours | 280 | 1,200 | 1,920 | 3,400 | 1,300 | - 0 | - 0 | 100 | 4,800 | |||||||||||
| Phase 3 Costs First column is prime, second is | Travel | $ 48,000 | $ 12,000 | $ 2,000 | $ 62,000 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| Project Total Hours | 984 | 3,360 | 5,608 | 9,952 | 4,040 | - 0 | - 0 | 400 | 14,392 | |||||||||||
| Total Project Costs First column is prime, second is | Total Travel | $ 139,000 | $ 36,000 | $ 6,000 | $ 181,000 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Total Materials & Equipment | $ 12,000 | $ - 0 | $ - 0 | $ 12,000 |
Template
| Duration | Intensity | Labor Hours | ||||||||||||||||||
| SOW Task | (months) | (hrs/mo) | Sr | Skill Set | Mid | Skill Set | Jr | Skill Set | Prime Total | SubC-Sr | Skill Set | SubC-Mid | Skill Set | SubC-Jr | Skill Set | Consult | Total | |||
| 1.1.0 | <Phase 1 Task 1 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | Notes | |||||||
| 1.1.1 | <Subtask 1.1.1 name> | n.a. | - 0 | - 0 | 1 | Numbers are illustrative, see the second tab for a template without numbers | ||||||||||||||
| 1.1.2 | <Subtask 1.1.2 name> | n.a. | - 0 | - 0 | 2 | Numbers in blue are inputs, numbers in black are computed by formulas | ||||||||||||||
| 1.2.0 | <Phase 1 Task 2 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 3 | Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines | ||||||
| 1.2.1 | <Subtask 1.2.1 name> | n.a. | - 0 | - 0 | Adding more tasks will require editing the Total Hours formulas | |||||||||||||||
| 1.2.2 | <Subtask 1.2.2 name> | n.a. | - 0 | - 0 | 4 | Pasting into proposal as a picture will produce the best results | ||||||||||||||
| : | : | : | : | : | : | : | : | : | : | : | 5 | If you have more than 12 tasks and subtasks per phase, you can break the table into | ||||||||
| Phase 1 Total Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page) | ||||||||||
| Phase 1 Costs First column is prime, second is | Travel | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| 2.1.0 | <Phase 2 Task 1 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 2.1.1 | <Subtask 2.1.1 name> | n.a. | - 0 | - 0 | ||||||||||||||||
| 2.1.2 | <Subtask 2.1.2 name> | n.a. | - 0 | - 0 | ||||||||||||||||
| 2.2.0 | <Phase 2 Task 2 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 2.2.1 | <Subtask 2.2.1 name> | n.a. | - 0 | - 0 | ||||||||||||||||
| 2.2.2 | <Subtask 2.2.2 name> | n.a. | - 0 | - 0 | ||||||||||||||||
| : | : | : | : | : | : | : | : | : | : | : | ||||||||||
| Phase 2 Total Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||
| Phase 2 Costs First column is prime, second is | Travel | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| 3.1.0 | <Phase 3 Task 1 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 3.1.1 | <Subtask 3.1.1 name> | n.a. | - 0 | - 0 | - 0 | |||||||||||||||
| 3.1.2 | <Subtask 3.1.2 name> | n.a. | - 0 | - 0 | - 0 | - 0 | ||||||||||||||
| 3.2.0 | <Phase 3 Task 2 name> | 0 | n.a. | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||
| 3.2.1 | <Subtask 3.2.1 name> | n.a. | - 0 | - 0 | - 0 | |||||||||||||||
| 3.2.2 | <Subtask 3.2.2 name> | n.a. | - 0 | - 0 | - 0 | |||||||||||||||
| : | : | : | : | : | : | : | : | : | : | : | ||||||||||
| Phase 3 Total Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||
| Phase 3 Costs First column is prime, second is | Travel | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| Project Total Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||
| Total Project Costs First column is prime, second is | Travel | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .