HR001119S0023_Att_3_Task_Staffing_Summary_Template.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Digital RF Battlespace Emulator (DRBE) Federal contract opportunity
- Solicitation number
- HR001119S0023
About this file
This document contains a task staffing summary template and related federal contract opportunity notice for the Digital RF Battlespace Emulator (DRBE) program. The template outlines a multi-phase staffing plan involving senior, mid-level, and junior staff across technical skill sets such as engineering, software development, and systems architecture. Staffing levels and costs are broken down by phase and subtasks. The related opportunity seeks the development of a new high-performance computing system balancing computational throughput with low latency to virtually emulate radiofrequency environments and interactions between systems such as radars. The Defense Advanced Research Projects Agency is the contracting agency. The anticipated contract type is not specified.
Not Listed
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HR001119S0023.pdf | ||
| HR001119S0023_Att1_Proposer_Checklist.pdf | ||
| HR001119S0023_Att_2_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
Task Staffing Summary Template
Phase 1
| Duration | Intensity | Labor Hours | ||||||||||||||||||
| SOW Task | (months) | (hrs/mo) | Senior | skill set | Mid | skill set | Junior | skill set | Total | Sub#1 Sr | skill set | Sub #1 Mid | skill set | Sub #1 Jr | skill set | Conslt | Total | |||
| 1.1.0 | <Phase 1 Task 1 name> | 7 | 135 | 240 | 680 | 24 | 944 | - 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 | All data entreis are illustrative only | ||||||
| 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 | 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 | Syst. Arch | 320 | Comp. Arch | 1,600 | Comp. design | 1,968 | 600 | Software Dev | - 0 | 2,568 | 4 | 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 | 5 | Keep sub-contractors separate; insert an additional copy of columns M-R for each additional sub-contractor | ||||
| : | : | : | : | : | : | : | : | : | : | : | 4 | Pasting into proposal as a picture will produce the best results | ||||||||
| Phase 1 Total Hours | 348 | 1,080 | 1,824 | 3,252 | 1,400 | 200 | 4,652 | 5 | If you have more than 12 tasks and subtasks per phase, you can break the table into | |||||||||||
| Phase 1 Costs First column is prime, second is total for | Travel | $ 44,000 | $ 12,000 | $ 2,000 | $ 58,000 | into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page) | ||||||||||||||
| subcontractor #1, third is total consultant, fourth is total | Materials & Equipment | $ 8,000 | $ - 0 | $ - 0 | $ 8,000 | |||||||||||||||
| Phase 2 |
| 2.1.0 | <Phase 2 Task 1 name> | 8 | 100 | 176 | 560 | 64 | 800 | 100 | 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 | 3,740 | ||||
| 2.2.1 | <Subtask 2.2.1 name> | 4 | 435 | 140 | Syst. Arch | 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 | 100 | 4,640 | |||||||
| Phase 2 Non-Labor Costs | Travel | $ 47,000 | $ 12,000 | $ 2,000 | $ 61,000 | |||||||||
| Materials & Equipment | $ 4,000 | $ - 0 | $ - 0 | $ 4,000 | ||||||||||
| Phase 3 |
| 3.1.0 | <Phase 3 Task 1 name> | 9 | 71 | 120 | 400 | 120 | 640 | 100 | 100 | 840 | ||||
| 3.1.1 | <Subtask 3.1.1 name> | 3 | 93 | 40 | ASIC design | 200 | Firmware Design | 40 | Firmware Dev | 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 | 3,960 | ||||
| 3.2.1 | <Subtask 3.2.1 name> | 4 | 370 | 80 | SME II | 400 | Comp. Arch | 1,000 | Comp. design | 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 | 100 | 4,800 | |||||||
| Phase 3 Non-Labor Costs | Travel | $ 48,000 | $ 12,000 | $ 2,000 | $ 62,000 | |||||||||
| Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Phase 4 |
| 3.1.0 | <Phase 4 Task 1 name> | 9 | 71 | 120 | 400 | 120 | 640 | 100 | 100 | 840 | ||||
| 3.1.1 | <Subtask 4.1.1 name> | 3 | 93 | 40 | ASIC design | 200 | Firmware Design | 40 | Firmware Dev | 280 | 100 | Engineer | 100 | 480 |
| 3.1.2 | <Subtask 4.1.2 name> | 6 | 60 | 80 | Software Dev | 200 | SME II | 80 | Software Dev | 360 | - 0 | - 0 | 360 | |
| 3.2.0 | <Phase 4 Task 2 name> | 6 | 460 | 160 | 800 | 1,800 | 2,760 | 1,200 | - 0 | 3,960 | ||||
| 3.2.1 | <Subtask 4.2.1 name> | 4 | 370 | 80 | SME II | 400 | Comp. Arch | 1,000 | Comp. design | 1,480 | 600 | Software Dev | - 0 | 2,080 |
| 3.2.2 | <Subtask 4.2.2 name> | 3 | 427 | 80 | SME II | 400 | Software Dev | 800 | SME II | 1,280 | 600 | Engineer | - 0 | 1,880 |
| : | : | : | : | : | : | : | : | : | : | : | ||||
| Phase 4 Total Hours | 280 | 1,200 | 1,920 | 3,400 | 1,300 | 100 | 4,800 | |||||||
| Phase 4 Non-Labor Costs | Travel | $ 48,000 | $ 12,000 | $ 2,000 | $ 62,000 | |||||||||
| Materials & Equipment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| PROGRAM TOTAL |
| Project Total Hours | 1,264 | 4,560 | 7,528 | 13,352 | 5,340 | 500 | 18,892 |
| Total Project Costs First column is prime, second is | Travel | $ 187,000 | $ 48,000 | $ 8,000 | $ 243,000 | ||
| total subcontractor, third is total consultant, fourth is total | Materials & Equipment | $ 12,000 | $ - 0 | $ - 0 | $ 12,000 |
File details come from the government source that posted it. Updated .