Ops-5G_BAA_proposal_LoE_table_template_SkillSets (002).xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Open Programmable Secure 5G (OPS-5G) Federal contract opportunity
Solicitation number
HR001120S0026
Issued by
Defense Advanced Research Projects Agency

About this file

Written by GovTribe AI ·

This document provides a template for a Level of Effort (LoE) table to be included in a proposal response to the Open Programmable Secure 5G (OPS-5G) Broad Agency Announcement (BAA) from the Defense Advanced Research Projects Agency (DARPA). The LoE table template includes columns for task duration in months, labor intensity in hours per month, and labor hours required for various skill levels across prime contractor, subcontractor, consultant, and total effort. It provides an example LoE table with illustrative numbers and instructions for proposal respondents on using the template to outline their proposed tasks, labor categories, and hours. The OPS-5G BAA seeks proposals to create open source software and systems enabling secure 5G and follow-on mobile networks, addressing challenges such as feature velocity in open software, network-scale botnets, network slicing on untrusted infrastructure, and adaptive adversaries operating at scale, with the long-term goal of establishing a US-friendly ecosystem.

View the file

Other files for this federal contract opportunity

Other files attached to Open Programmable Secure 5G (OPS-5G), newest first.
File Type Posted
HR001120S0026-Amendment-03.pdf PDF
HR001120S0026-Amendment-02.pdf PDF
HR001120S0026-Amendment-01.pdf PDF
HR001120S0026.pdf PDF
Ops-5G_BAA_Attachment_Proposal_Summary_Chart_Template (002).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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

BAA LoE Example

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrSkill SetMidSkill SetJrSkill SetPrime TotalSubC-SrSkill SetSubC-MidSkill SetSubC-JrSkill SetConsultProgram Total
1.1.0<Phase 1 Task 1 name>713524068024944- 0- 0- 02001,144Notes
1.1.1<Subtask 1.1.1 name>49080Engineer280Engineer- 0360- 02005601Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>3195160Software Dev400Software Dev24Software Dev584- 0- 05842Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0<Phase 1 Task 2 name>63851084001,8002,3081,400- 0- 0- 03,7083Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1<Subtask 1.2.1 name>365648Data Scientist320Data Scientist1,600Data Scientist1,968600Software Dev- 02,568Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>311360SME III80SME II200SME I340800Engineer- 01,1404Pasting into proposal as a picture will produce the best results
:::::::::::5If you have more than 12 tasks and subtasks per phase, you can break the table into
Phase 1 Total Hours3481,0801,8243,2521,400- 0- 02004,852into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
Phase 1 Costs First column is prime, second isTravel$ 44,000$ 12,000$ 2,000$ 58,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 8,000$ - 0$ - 0$ 8,000
2.1.0<Phase 2 Task 1 name>810017656064800100- 0- 01001,000
2.1.1<Subtask 2.1.1 name>75196Data Scientist240Data Scientist24Data Scientist360100Engineer100560
2.1.2<Subtask 2.1.2 name>411080Software Dev320SME II40Software Dev440- 0- 0440
2.2.0<Phase 2 Task 2 name>64171805201,8002,5001,240- 0- 0- 03,740
2.2.1<Subtask 2.2.1 name>4435140Data Scientist400Data Scientist1,200Data Scientist1,740400Software Dev- 02,140
2.2.2<Subtask 2.2.2 name>419040SME II120Software Dev600SME II760840Engineer- 01,600
:::::::::::
Phase 2 Total Hours3561,0801,8643,3001,340- 0- 01004,740
Phase 2 Costs First column is prime, second isTravel$ 47,000$ 12,000$ 2,000$ 61,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 4,000$ - 0$ - 0$ 4,000
3.1.0<Phase 3 Task 1 name>971120400120640100- 0- 0100840
3.1.1<Subtask 3.1.1 name>39340Software Dev200Data Scientist40Data Scientist280100Engineer100480
3.1.2<Subtask 3.1.2 name>66080Software Dev200SME II80Software Dev360- 0- 0360
3.2.0<Phase 3 Task 2 name>64601608001,8002,7601,200- 0- 0- 03,960
3.2.1<Subtask 3.2.1 name>437080SME II400Data Scientist1,000Data Scientist1,480600Software Dev- 02,080
3.2.2<Subtask 3.2.2 name>342780SME II400Software Dev800SME II1,280600Engineer- 01,880
:::::::::::
Phase 3 Total Hours2801,2001,9203,4001,300- 0- 01004,800
Phase 3 Costs First column is prime, second isTravel$ 48,000$ 12,000$ 2,000$ 62,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
Project Total Hours9843,3605,6089,9524,040- 0- 040014,392
Total Project Costs First column is prime, second isTotal Travel$ 139,000$ 36,000$ 6,000$ 181,000
total subcontractor, third is total consultant, fourth is totalTotal Materials & Equipment$ 12,000$ - 0$ - 0$ 12,000

Template

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrSkill SetMidSkill SetJrSkill SetPrime TotalSubC-SrSkill SetSubC-MidSkill SetSubC-JrSkill SetConsultTotal
1.1.0<Phase 1 Task 1 name>0n.a.- 0- 0- 0- 0- 0- 0- 0- 0- 0Notes
1.1.1<Subtask 1.1.1 name>n.a.- 0- 01Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>n.a.- 0- 02Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0<Phase 1 Task 2 name>0n.a.- 0- 0- 0- 0- 0- 0- 0- 0- 03Task 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- 0Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>n.a.- 0- 04Pasting into proposal as a picture will produce the best results
:::::::::::5If 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- 0into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
Phase 1 Costs First column is prime, second isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
2.1.0<Phase 2 Task 1 name>0n.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>0n.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 isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
3.1.0<Phase 3 Task 1 name>0n.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>0n.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 isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & 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 isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0

File details come from the government source that posted it. Updated .