L_and_M_TA-2_-_Proposal_PWBS_with_Hours__20190507.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
Consolidated Automated Support System (CASS) Fourth Generation Electro-Optics (EO4) Subsystem
Solicitation number
N68335-19-R-0063
Issued by

About this file

PWBS

View the file

Other files

File Type Posted
CA-2_Historical_and_Forecasted_Indirect_Rates.xlsx XLSX spreadsheet
L_and_M_CA-1_-_Proposal_PWBS_with_CLIN_Hours_and_Prices_20190507.xlsx XLSX spreadsheet
DRAFT_Solicitation_N68335-19-R-0063.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

INSTRUCTIONS

Instructions for completing this worksheet

WBS HOURS TAB
Instruction: Fill in yellow cells with hours
If you decide to use the fields marked "other," provide SOW and Contractor Work Breakdown Structure identification
Hours in the gray cells are pre-filled. Do not adjust these numbers.
Additional rows within WBS levels may be added if necessary. Include Statement of Work (SOW) and Contractor Work Breakdown Structure identification as a cross reference
CLIN SUMMARY TAB
CLIN hours populate automatically from the WBS Hours Tab. Do not adjust the formulas in this worksheet unless changes to the WBS Hours Tab require it.
There is an error catch that will alert a discrepancy and turn RED if the hours total does not match the one on the WBS Hours Tab
When the total on the WBS and CLIN tabs are in agreement, the error catch returns a sum of zero and turns GREEN.
Additional labor hour detail may be provided at lower levels. Please include lower level detail on a separate tab. Links from supplementary data to the WBS Hours tab are allowed and encouraged. Retain formulas in cells so that mathematical logic may be followed.
Techical Data Package (TDP) Data CDRL B00H
Technical Manual Data CDRLs E001-E005
Includes EVM CDRL A004

WBS HOURS

EO4 Development Product Work Breakdown Structure (PWBS)
CLIN ALIGNMENTPWBS #SOW PARAGRAPHLevel 1Level 2Level 3TOTAL HOURS
eCASS EO4 Development Grand Total4000
00011.01.1EMD Labor (NonRecurring)
00011.13.1Management
1.1.13.1.1, 3.1.17Program Management0
1.1.23.1.1Finance Management0
1.1.33.1.1Contract Management0
1.1.43.1.2, 3.1.14Subcontract Management0
1.1.53.1.3, 3.4.3Configuration Management0
1.1.63.1.20, 3.3.4Data Management0
1.1.73.1.1, 3.1.9, 3.10, 3.1.13, 3, 3.2.1Engineering Management0
1.1.83.1.1, 3.1.12, 3.4.2Logistics Management0
1.1.93.1.8Risk/Opportunity Management0
1.1.103.11Quality Assurance0
1.1.11(enter SOW and CWBS identifiers)Other (Specify)0
00011.2Reviews/Meetings
1.2.13.1.16, 3.2.2Engineering Reviews/Meetings0
1.2.23.1.16Program Reviews/Meetings0
1.2.33.1.16Logistics Reviews/Meetings0
1.2.4(enter SOW and CWBS identifiers)Other (Specify)0
00011.33.2.3.3, 3.2.3.4, 3.2.3.5, 3.2.3.6, 3.2.3.7, 3.2.3.8, 3.2.3.9, except data rightsHardware Development0
00011.43.2.4, except 3.2.4.13 and data rightsSoftware Development0
00011.5Integration, Pre-Test & Checkout
1.5.13.2.3.2, 3.2.8interoperability with eCASSEO4 Hardware Integration0
1.5.23.2.5this is the whole OTPS compatibility sectionEO4 Software Integration0
1.5.3(enter SOW and CWBS identifiers)Other EO4 Integration (Specify)0
00011.6Test Events
1.6.13.3.5.1, 3.3.5.2, 3.3.5.3, 3.3.5.4, 3.3.5.5, 3,3,5,6DT-B1 Phase 1 (DVT)0
1.6.23.3.5.7DT-B1 Phase 2 (Environmental)0
1.6.33.3.5.8DT-B1 Phase 3 (Support for Govt Test)0
1.6.4(enter SOW and CWBS identifiers)Other System Test & Evaluation (Specify)0
00011.7Logistics
1.7.13.4.1, 3.4.4, 3.4.7Any SOW paragraph that is not related to a CDRLGeneral Logistics0
1.7.23.4.10Technical Manuals0
1.7.33.4.11Training0
1.7.4(enter SOW and CWBS identifiers)Other (Specify)0
00011.8Data (Delivered on CLIN 0009)
1.8.13.1.4, 3.1.5, 3.1.7, 3.1.18, 3.1.19.1, 3.1.20.1, 3.1.20.4, 3.1.22, 3.2.5.1, 3.4.3.3Admin/Management Data CDRLs A001-A00A (Except for EVM CDRL A004)0
1.8.23.2.3.9, 3.2.5.1, 3.2.7.6, 3.2.8, 3.4.3.4Engineering Data CDRLs B001-B00S (Except for TDP CDRL B00H)0
1.8.33.2.6.2Techical Data Package (TDP) Data CDRL B00H0
1.8.43.1.1, 3.3.5, 3.4.3.4,Test Data CDRLs C001-C0030
1.8.53.4.3.1, 3.4.3.2, 3.4.4.3, 3.4.5, 3.4.6, 3.4.7.1, 3.4.7.2, 3.4.8, 3.4.9Logistics Data CDRLs D001-D0090
1.8.63.4.10Technical Manual Data CDRLs E001-E0050
1.8.73.4.11Training Data CDRLs F001-F0050
1.8.83.1.20.2, 3.2.3.1, 3.3.3Independent Data Environment (IDE) Repository System/Hardware/Tools0
1.8.93.2.4.12Data Rights (Specify)0
1.8.10(enter SOW and CWBS identifiers)Other Data (Specify)0
00011.9Maintenance & Support
1.9.13.1.15Repair/calibration and maintenance of GFP (host eCASS, etc)0
1.9.23.1.21, 3.2.7Repair/calibration and maintenance of EDM EO4 Subsystems0
1.9.3(enter SOW and CWBS identifiers)Other (Specify)0
00011.10EO4 Principal Subcontractors
1.10.1(enter SOW and CWBS identifiers)Principal Subcontractor #10
1.10.2(enter SOW and CWBS identifiers)Principal Subcontractor #20
1.10.3(enter SOW and CWBS identifiers)Principal Subcontractor #30
1.10.4(enter SOW and CWBS identifiers)(etc.)0
00022.0EO Subsystems (Recurring)
2.11.2Console Hardware0
2.11.2Console Software0
2.11.2Console Assembly/Build0
2.11.2Console Test (PAT/PRAT)0
2.11.3EO Cart0
2.11.4EO Install Kits0
2.1(enter SOW and CWBS identifiers)Other (Specify)0
00033.01.5SMAT/CAL OTPS Mod Kits (Recurring)0
00044.01.6Spares Kits0
00055.01.7, 3.1.6Earned Value Management (EVM)(Includes EVM CDRL A004)0
00066.01.8, 3.5Engineering and Logistics Support Labor4000
00077.01.9, 3.5Engineering and Logistics Support Material0
00088.01.10, 3.5Engineering and Logistics Support Travel0
00099.01.11Data (NSP)NSP

CLIN SUMMARY

CLINCLIN DESCRIPTIONTOTAL HOURS
0001EMD NRE0
0002EO Consoles, Carts and Install Kits0
0003SMAT/CAL OTPS Upgrade Kits0
0004Spares Kits0
0005Earned Value Management (EVM)0
0006Engineering and Logistics Support Labor4000
0007Engineering and Logistics Support Material0
0008Engineering and Logistics Support Travel0
0009Data (***Not Separately Priced***)NSP
Total4000
Error Catch0(Green is good, red is bad)

File details come from the government source that posted it.