SIEVE_BAA_proposal_LoE_table_template_SkillSets.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Securing Information for Encrypted Verification and Evaluation (SIEVE) Federal contract opportunity
- Solicitation number
- HR001119S0076
About this file
This document contains a template for a Statement of Work (SOW) table along with a related Broad Agency Announcement (BAA) opportunity notice. The SOW template outlines tasks, durations, labor hours and costs for three phases of work on securing information for encrypted verification and evaluation (SIEVE). It includes details for prime contractor and subcontractor labor in various skill categories. The related BAA from the Defense Advanced Research Projects Agency seeks innovative research proposals in zero-knowledge proofs for complex Department of Defense capabilities. Proposals are due through the Federal Business Opportunities and Grants.gov websites, and any awards will follow procedures under the Federal Acquisition Regulation and involve a scientific review process.
LoE Template Skill Sets
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HR001119S0076-Amendment-01.pdf | ||
| SIEVE_CUI_Guide_v1.pdf | ||
| HR001119S0076.pdf | ||
| SIEVE_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 .