CASE_BAA_proposal_LoE_table_template.xlsx

20 KB Posted

Attached to
Cyber Assured Systems Engineering (CASE)
Solicitation number
HR001117S0033
Issued by

About this file

From the source

Not Listed

View the file

Other files

File Type Posted
CASE_BAA_proposal_LoE_table_template.xlsx XLSX spreadsheet
CASE_BAA_Attachment_Proposal_Summary_Chart_Template.pptx PPTX presentation
HR001117S0033-Amendment-02.pdf PDF
HR001117S0033-Amendment-01.pdf PDF
HR001117S0033.pdf PDF

On GovTribe

Work with this file

  • 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 Template

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrMidJrTotalSubCConsltTotal
1.1.0<Phase 1 Task 1 name>713524068024944- 02001,144Notes
1.1.1<Subtask 1.1.1 name>49080280- 0360- 02005601Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>319516040024584- 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- 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>3656483201,6001,968600- 02,568Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>31136080200340800- 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,4002004,652into 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>8100176560648001001001,000
2.1.1<Subtask 2.1.1 name>7519624024360100100560
2.1.2<Subtask 2.1.2 name>41108032040440- 0- 0440
2.2.0<Phase 2 Task 2 name>64171805201,8002,5001,240- 03,740
2.2.1<Subtask 2.2.1 name>44351404001,2001,740400- 02,140
2.2.2<Subtask 2.2.2 name>419040120600760840- 01,600
:::::::::::
Phase 2 Total Hours3561,0801,8643,3001,3401004,640
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>971120400120640100100840
3.1.1<Subtask 3.1.1 name>3934020040280100100480
3.1.2<Subtask 3.1.2 name>6608020080360- 0- 0360
3.2.0<Phase 3 Task 2 name>64601608001,8002,7601,200- 03,960
3.2.1<Subtask 3.2.1 name>4370804001,0001,480600- 02,080
3.2.2<Subtask 3.2.2 name>3427804008001,280600- 01,880
:::::::::::
Phase 3 Total Hours2801,2001,9203,4001,3001004,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,04040014,092
Total Project Costs First column is prime, second isTravel$ 139,000$ 36,000$ 6,000$ 181,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 12,000$ - 0$ - 0$ 12,000

Template no numbers

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrMidJrTotalSubCConsltTotal
1.1.0<Phase 1 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0
1.1.1<Subtask 1.1.1 name>n.a.- 0- 0- 0
1.1.2<Subtask 1.1.2 name>n.a.- 0- 0- 0
1.2.0<Phase 1 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 0
1.2.1<Subtask 1.2.1 name>n.a.- 0- 0
1.2.2<Subtask 1.2.2 name>n.a.- 0- 0
Phase 1 Total Hours- 0- 0- 0- 0- 0- 0- 0
Phase 1 Costs First column is prime, second isTravel$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0
2.1.0<Phase 2 Task 1 name>n.a.- 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>n.a.- 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
Phase 2 Costs First column is prime, second isTravel$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0
3.1.0<Phase 3 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0
3.1.1<Subtask 3.1.1 name>n.a.- 0- 0
3.1.2<Subtask 3.1.2 name>n.a.- 0- 0
3.2.0<Phase 3 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 0
3.2.1<Subtask 3.2.1 name>n.a.- 0- 0
3.2.2<Subtask 3.2.2 name>n.a.- 0- 0
Phase 3 Total Hours- 0- 0- 0- 0- 0- 0- 0
Phase 3 Costs First column is prime, second isTravel$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0
Project Total Hours- 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 .