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
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 ALIGNMENT | PWBS # | SOW PARAGRAPH | Level 1 | Level 2 | Level 3 | TOTAL HOURS |
| eCASS EO4 Development Grand Total | 4000 | |||||
| 0001 | 1.0 | 1.1 | EMD Labor (NonRecurring) | |||
| 0001 | 1.1 | 3.1 | Management | |||
| 1.1.1 | 3.1.1, 3.1.17 | Program Management | 0 | |||
| 1.1.2 | 3.1.1 | Finance Management | 0 | |||
| 1.1.3 | 3.1.1 | Contract Management | 0 | |||
| 1.1.4 | 3.1.2, 3.1.14 | Subcontract Management | 0 | |||
| 1.1.5 | 3.1.3, 3.4.3 | Configuration Management | 0 | |||
| 1.1.6 | 3.1.20, 3.3.4 | Data Management | 0 | |||
| 1.1.7 | 3.1.1, 3.1.9, 3.10, 3.1.13, 3, 3.2.1 | Engineering Management | 0 | |||
| 1.1.8 | 3.1.1, 3.1.12, 3.4.2 | Logistics Management | 0 | |||
| 1.1.9 | 3.1.8 | Risk/Opportunity Management | 0 | |||
| 1.1.10 | 3.11 | Quality Assurance | 0 | |||
| 1.1.11 | (enter SOW and CWBS identifiers) | Other (Specify) | 0 | |||
| 0001 | 1.2 | Reviews/Meetings | ||||
| 1.2.1 | 3.1.16, 3.2.2 | Engineering Reviews/Meetings | 0 | |||
| 1.2.2 | 3.1.16 | Program Reviews/Meetings | 0 | |||
| 1.2.3 | 3.1.16 | Logistics Reviews/Meetings | 0 | |||
| 1.2.4 | (enter SOW and CWBS identifiers) | Other (Specify) | 0 | |||
| 0001 | 1.3 | 3.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 rights | Hardware Development | 0 | ||
| 0001 | 1.4 | 3.2.4, except 3.2.4.13 and data rights | Software Development | 0 | ||
| 0001 | 1.5 | Integration, Pre-Test & Checkout | ||||
| 1.5.1 | 3.2.3.2, 3.2.8 | interoperability with eCASS | EO4 Hardware Integration | 0 | ||
| 1.5.2 | 3.2.5 | this is the whole OTPS compatibility section | EO4 Software Integration | 0 | ||
| 1.5.3 | (enter SOW and CWBS identifiers) | Other EO4 Integration (Specify) | 0 | |||
| 0001 | 1.6 | Test Events | ||||
| 1.6.1 | 3.3.5.1, 3.3.5.2, 3.3.5.3, 3.3.5.4, 3.3.5.5, 3,3,5,6 | DT-B1 Phase 1 (DVT) | 0 | |||
| 1.6.2 | 3.3.5.7 | DT-B1 Phase 2 (Environmental) | 0 | |||
| 1.6.3 | 3.3.5.8 | DT-B1 Phase 3 (Support for Govt Test) | 0 | |||
| 1.6.4 | (enter SOW and CWBS identifiers) | Other System Test & Evaluation (Specify) | 0 | |||
| 0001 | 1.7 | Logistics | ||||
| 1.7.1 | 3.4.1, 3.4.4, 3.4.7 | Any SOW paragraph that is not related to a CDRL | General Logistics | 0 | ||
| 1.7.2 | 3.4.10 | Technical Manuals | 0 | |||
| 1.7.3 | 3.4.11 | Training | 0 | |||
| 1.7.4 | (enter SOW and CWBS identifiers) | Other (Specify) | 0 | |||
| 0001 | 1.8 | Data (Delivered on CLIN 0009) | ||||
| 1.8.1 | 3.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.3 | Admin/Management Data CDRLs A001-A00A (Except for EVM CDRL A004) | 0 | |||
| 1.8.2 | 3.2.3.9, 3.2.5.1, 3.2.7.6, 3.2.8, 3.4.3.4 | Engineering Data CDRLs B001-B00S (Except for TDP CDRL B00H) | 0 | |||
| 1.8.3 | 3.2.6.2 | Techical Data Package (TDP) Data CDRL B00H | 0 | |||
| 1.8.4 | 3.1.1, 3.3.5, 3.4.3.4, | Test Data CDRLs C001-C003 | 0 | |||
| 1.8.5 | 3.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.9 | Logistics Data CDRLs D001-D009 | 0 | |||
| 1.8.6 | 3.4.10 | Technical Manual Data CDRLs E001-E005 | 0 | |||
| 1.8.7 | 3.4.11 | Training Data CDRLs F001-F005 | 0 | |||
| 1.8.8 | 3.1.20.2, 3.2.3.1, 3.3.3 | Independent Data Environment (IDE) Repository System/Hardware/Tools | 0 | |||
| 1.8.9 | 3.2.4.12 | Data Rights (Specify) | 0 | |||
| 1.8.10 | (enter SOW and CWBS identifiers) | Other Data (Specify) | 0 | |||
| 0001 | 1.9 | Maintenance & Support | ||||
| 1.9.1 | 3.1.15 | Repair/calibration and maintenance of GFP (host eCASS, etc) | 0 | |||
| 1.9.2 | 3.1.21, 3.2.7 | Repair/calibration and maintenance of EDM EO4 Subsystems | 0 | |||
| 1.9.3 | (enter SOW and CWBS identifiers) | Other (Specify) | 0 | |||
| 0001 | 1.10 | EO4 Principal Subcontractors | ||||
| 1.10.1 | (enter SOW and CWBS identifiers) | Principal Subcontractor #1 | 0 | |||
| 1.10.2 | (enter SOW and CWBS identifiers) | Principal Subcontractor #2 | 0 | |||
| 1.10.3 | (enter SOW and CWBS identifiers) | Principal Subcontractor #3 | 0 | |||
| 1.10.4 | (enter SOW and CWBS identifiers) | (etc.) | 0 | |||
| 0002 | 2.0 | EO Subsystems (Recurring) | ||||
| 2.1 | 1.2 | Console Hardware | 0 | |||
| 2.1 | 1.2 | Console Software | 0 | |||
| 2.1 | 1.2 | Console Assembly/Build | 0 | |||
| 2.1 | 1.2 | Console Test (PAT/PRAT) | 0 | |||
| 2.1 | 1.3 | EO Cart | 0 | |||
| 2.1 | 1.4 | EO Install Kits | 0 | |||
| 2.1 | (enter SOW and CWBS identifiers) | Other (Specify) | 0 | |||
| 0003 | 3.0 | 1.5 | SMAT/CAL OTPS Mod Kits (Recurring) | 0 | ||
| 0004 | 4.0 | 1.6 | Spares Kits | 0 | ||
| 0005 | 5.0 | 1.7, 3.1.6 | Earned Value Management (EVM) | (Includes EVM CDRL A004) | 0 | |
| 0006 | 6.0 | 1.8, 3.5 | Engineering and Logistics Support Labor | 4000 | ||
| 0007 | 7.0 | 1.9, 3.5 | Engineering and Logistics Support Material | 0 | ||
| 0008 | 8.0 | 1.10, 3.5 | Engineering and Logistics Support Travel | 0 | ||
| 0009 | 9.0 | 1.11 | Data (NSP) | NSP |
CLIN SUMMARY
| CLIN | CLIN DESCRIPTION | TOTAL HOURS | |
| 0001 | EMD NRE | 0 | |
| 0002 | EO Consoles, Carts and Install Kits | 0 | |
| 0003 | SMAT/CAL OTPS Upgrade Kits | 0 | |
| 0004 | Spares Kits | 0 | |
| 0005 | Earned Value Management (EVM) | 0 | |
| 0006 | Engineering and Logistics Support Labor | 4000 | |
| 0007 | Engineering and Logistics Support Material | 0 | |
| 0008 | Engineering and Logistics Support Travel | 0 | |
| 0009 | Data (***Not Separately Priced***) | NSP | |
| Total | 4000 | ||
| Error Catch | 0 | (Green is good, red is bad) |
File details come from the government source that posted it.