FastNICs_BAA_proposal_LoE_table_template_SkillSets.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Fast Networks Interface Cards (FastNICs) Federal contract opportunity
- Solicitation number
- HR001119S0082
About this file
This document contains a Level of Effort template and Statement of Work for a proposed research project in response to Solicitation HR001119S0082 from the Defense Advanced Research Projects Agency. The template provides an example for estimating labor hours, costs, and skill sets required across three phases of work involving tasks in software development, data science, and subject matter expertise. The nine-month project would utilize prime, subcontractor, consultant, and materials resources. Key personnel identified include senior engineers, mid-level and junior software developers and data scientists, and senior and mid-level subject matter experts. The first phase focuses on program setup, the second on analysis and design, and the third on implementation and testing. Total projected costs are estimated at $181,000 for prime labor, $36,000 for travel, $6,000 for subcontractor effort, and $12,000 for materials and equipment.
Not Listed
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HR001119S0082-Amendment-02.pdf | ||
| HR001119S0082-Amendment-01.pdf | ||
| FastNICs_CUI_Guide__-_Final.pdf | ||
| FastNICs_BAA_Attachment_Proposal_Summary_Chart_Template.pptx | PPTX presentation | |
| HR001119S0082.pdf |
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 .