L_and_M_CA-1_-_Proposal_PWBS_with_CLIN_Hours_and_Prices_20190507.xlsx

XLSX spreadsheet 53 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

From the source

PWBS with Pricing

View the file

Other files

File Type Posted
CA-2_Historical_and_Forecasted_Indirect_Rates.xlsx XLSX spreadsheet
L_and_M_TA-2_-_Proposal_PWBS_with_Hours__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
Try for free Login

Text version

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

INSTRUCTIONS

Instructions for completing this CA-1 Cost Attachment worksheet

WBS HOURS AND PRICES TAB
Instruction: Fill in yellow cells with hours and prices
If you decide to use the fields marked "other," provide Statement of Work (SOW) and Contractor Work Breakdown Structure (CWBS) identification
Hours and prices in the gray cells are pre-filled. Do not adjust these numbers.
Additional rows within WBS levels may be added if necessary. Include SOW and CWBS identification as a cross reference
CLIN HOURS AND PRICES TAB
CLIN hours and prices populate automatically from the WBS Hours and Prices Tab. Do not adjust the formulas in this worksheet unless changes to the WBS Hours and Prices Tab require it.
There is an error catch that will alert a discrepancy and turn RED if the hours and price totals do not match the ones on the WBS Prices Tab
When the totals on the WBS and CLIN tabs are in agreement, the error catch returns a sum of zero and turns GREEN.
Additional pricing detail may be provided at lower levels. Please include lower level detail on a separate tab. Links from supplementary data to the WBS Hours and Prices tab are allowed and encouraged. Retain formulas in cells so that mathematical logic may be followed.
BOE SAMPLE WORKSHEET
This worsheet is an example of the level of cost substantiation required to support the assigned hours and prices.

WBS HOURS AND PRICES

EO4 Development Product Work Breakdown Structure (PWBS)
CLIN ALIGNMENTPWBS #SOW PARAGRAPHLevel 1Level 2Level 3TOTAL HOURSTOTAL PRICE
eCASS EO4 Development Grand Total4000$ 130,000.00
00011.01.1EMD Labor (NonRecurring)
00011.13.1Management
1.1.13.1.1, 3.1.17Program Management0$ - 0
1.1.23.1.1Finance Management0$ - 0
1.1.33.1.1Contract Management0$ - 0
1.1.43.1.2, 3.1.14Subcontract Management0$ - 0
1.1.53.1.3, 3.4.3Configuration Management0$ - 0
1.1.63.1.20, 3.3.4Data Management0$ - 0
1.1.73.1.1, 3.1.9, 3.10, 3.1.13, 3, 3.2.1Engineering Management0$ - 0
1.1.83.1.1, 3.1.12, 3.4.2Logistics Management0$ - 0
1.1.93.1.8Risk/Opportunity Management0$ - 0
1.1.103.11Quality Assurance0$ - 0
1.1.11(enter SOW and CWBS identifiers)Other (Specify)0$ - 0
00011.2Reviews/Meetings
1.2.13.1.16, 3.2.2Engineering Reviews/Meetings0$ - 0
1.2.23.1.16Program Reviews/Meetings0$ - 0
1.2.33.1.16Logistics Reviews/Meetings0$ - 0
1.2.4(enter SOW and CWBS identifiers)Other (Specify)0$ - 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$ - 0
00011.43.2.4, except 3.2.4.13 and data rightsSoftware Development0$ - 0
00011.5Integration, Pre-Test & Checkout
1.5.13.2.3.2, 3.2.8interoperability with eCASSEO4 Hardware Integration0$ - 0
1.5.23.2.5this is the whole OTPS compatibility sectionEO4 Software Integration0$ - 0
1.5.3(enter SOW and CWBS identifiers)Other EO4 Integration (Specify)0$ - 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$ - 0
1.6.23.3.5.7DT-B1 Phase 2 (Environmental)0$ - 0
1.6.33.3.5.8DT-B1 Phase 3 (Support for Govt Test)0$ - 0
1.6.4(enter SOW and CWBS identifiers)Other System Test & Evaluation (Specify)0$ - 0
00011.7Logistics
1.7.13.4.1, 3.4.4, 3.4.7General Logistics0$ - 0
1.7.23.4.10Technical Manuals0$ - 0
1.7.33.4.11Training0$ - 0
1.7.4(enter SOW and CWBS identifiers)Other (Specify)0$ - 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$ - 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$ - 0
1.8.33.2.6.2Techical Data Package (TDP) Data CDRL B00H0$ - 0
1.8.43.1.1, 3.3.5, 3.4.3.4,Test Data CDRLs C001-C0030$ - 0
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$ - 0
1.8.63.4.10Technical Manual Data CDRLs E001-E0050$ - 0
1.8.73.4.11Training Data CDRLs F001-F0050$ - 0
1.8.83.1.20.2, 3.2.3.1, 3.3.3Independent Data Environment (IDE) Repository System/Hardware/Tools0$ - 0
1.8.93.2.4.12Data Rights (Specify)0$ - 0
1.8.10(enter SOW and CWBS identifiers)Other Data (Specify)0$ - 0
00011.9Maintenance & Support
1.9.13.1.15Repair/calibration and maintenance of GFP (host eCASS, etc)0$ - 0
1.9.23.1.21, 3.2.7Repair/calibration and maintenance of EDM EO4 Subsystems0$ - 0
1.9.3(enter SOW and CWBS identifiers)Other (Specify)0$ - 0
00011.10EO4 Principal Subcontractors
1.10.1(enter SOW and CWBS identifiers)Principal Subcontractor #10$ - 0
1.10.2(enter SOW and CWBS identifiers)Principal Subcontractor #20$ - 0
1.10.3(enter SOW and CWBS identifiers)Principal Subcontractor #30$ - 0
1.10.4(enter SOW and CWBS identifiers)(etc.)0$ - 0
00022.0EO Subsystems (Recurring)
2.11.2Console Hardware0$ - 0
2.11.2Console Software0$ - 0
2.11.2Console Assembly/Build0$ - 0
2.11.2Console Test (PAT/PRAT)0$ - 0
2.11.3EO Cart0$ - 0
2.11.4EO Install Kits0$ - 0
2.1(enter SOW and CWBS identifiers)Other (Specify)0$ - 0
00033.01.5SMAT/CAL OTPS Mod Kits (Recurring)0$ - 0
00044.01.6Spares Kits0$ - 0
00055.01.7, 3.1.6Earned Value Management (EVM)(Includes EVM CDRL A004)0$ - 0
00066.01.8, 3.5Engineering and Logistics Support Labor4000$ - 0
00077.01.9, 3.5Engineering and Logistics Support Material0$ 100,000.00
00088.01.10, 3.5Engineering and Logistics Support Travel0$ 30,000.00
00099.01.11Data (NSP)NSP$ - 0

CLIN SUMMARY

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

BOE SAMPLE

SECTION L COST ATTACHMENT 3
COST SUBSTANTIATION (BOE) - Sample
CWBS #______ Note: Include WBS at the lowest level at which your estimate was developed.____________
1. PROGRAM
LABOR / MATERIALCOST ESTIMATE TY$ANALOGOUS COST TY$
BREAKOUTABCDEFGH
1921-1ContractorContractorContractorSubcontractorSubcontractorSubcontractor1921-1ContractorContractorContractorSubcontractorSubcontractorSubcontractor
CategoryLabor HoursLabor CostMat'l CostLabor HoursLabor CostMat'l CostCategoryLabor HoursLabor CostMat'l CostLabor HoursLabor CostMat'l Cost
Nonrecurring

Recurring

TOTAL
TOTAL COST ESTIMATE (TY$) A+B+C+DTOTAL COST ANALOGOUS EFFORT (TY$) E+F+G+H

DESCRIPTION OF WORK CONTENT / TECHNICAL PARAMETERS DESCRIPTION OF DIFFERENCES IN WORK CONTENT

ESTIMATE BASE - (Analogous program) BASE COST TY$ ADJUSTMENTS / CALCULATIONS ADJUSTMENTS COST TY$ TOTAL COST ESTIMATE (TY$)

DESCRIPTION OF ESTIMATE BASE / PROCESS DESCRIPTION OF ADJUSTMENTS / CALCULATIONS OTHER (IF NECESSARY)

SECTION L COST ATTACHMENT 4

File details come from the government source that posted it.