Attachment 8 COMR CDRL Template COR.pdf

152 KB Posted

Attached to
Advanced Software, Computer, and Network Development and Integration in support of NAWCAD WOLF
Solicitation number
N00421-20-R-0002
Issued by

About this file

Written by GovTribe AI ·

This sources sought notice requests capability statements from businesses for an indefinite delivery indefinite quantity contract to provide advanced software, computer, and network development and integration services in support of the Naval Air Warfare Center - Aircraft Division (NAWCAD) in Patuxent River, Maryland. Services include program management, research, analysis, design, parts procurement, demonstration, test and evaluation, and training. The anticipated period of performance is five years. Responses are due by May 21, 2019. Eligible businesses must have or be able to obtain a TOP SECRET facility clearance. The place of performance is 45% on-site at NAWCAD, 15% on-site at Yuma Proving Grounds, and 40% off-site at a contractor facility. The contract type will be cost-plus-fixed-fee level of effort and completion. Capability statements must demonstrate experience and qualifications to perform the requirements in the draft statement of work, including technical skills for software development, integration, and network support.

View the file

Other files

File Type Posted
N00421-20-R-0002-0006 Conform.pdf PDF
N00421-20-R-0002 Amendment 0005.pdf PDF
Attachment P6 amd 4.xlsx XLSX spreadsheet
Attachment P7 amd 4.xlsx XLSX spreadsheet
N00421-20-R-0002 Amendment 0004.pdf PDF
Attachment P8 - DoD SAFE Help.pdf PDF
N00421-20-R-0002 Amendment 0003.pdf PDF
N00421-20-R-0002 Amendment 0002.pdf PDF
P3 Hourly Burdened Composite Labor Rates.xlsx XLSX spreadsheet
P6 Cost Summary.xlsx XLSX spreadsheet
N00421-20-R-0002 Amendment 0001.pdf PDF
P7 Subcontractor Cost Summary.xlsx XLSX spreadsheet
Attachment P7 - Subcontractor Cost Summary.xlsx XLSX spreadsheet
Attachment 2 QASP.pdf PDF
Attachment 10 MFR.pdf PDF
Attachment 6 Authorized Key Personnel.doc DOC document
P2 CPAQ.pdf PDF
Attachment 3 Data Item Transmittal Form.docx DOCX document
Attachment 5 Authorized Subcontractors.pdf PDF
P1 Past Performance Information Form.pdf PDF
P6 Cost Summary.xlsx XLSX spreadsheet
Exhibit A CDRLs.pdf PDF
Attachment 7 Sexual Assault.pdf PDF
Attachment 01 DD254 BID.pdf PDF
N00421-20-R-0002 ASCNDI.pdf PDF
P3 Composite Rates.xlsx XLSX spreadsheet
Attachment 9 COMR CDRL Template.pdf PDF
P4 Reserved.pdf PDF
P5 Reserved.pdf PDF
P1 Past Performance.pdf PDF
Attachment 07 Sexual Assault and Sexual Harassment.docx DOCX document
Attachment 03 Data Item Transmittal Form.docx DOCX document
Attachment 08 COMR CDRL Template COR ONLY.xlsx XLSX spreadsheet
Attachment 06 Authorized Key Personnel.doc DOC document
Attachment 05 Authorized Subcontractors.docx DOCX document
Attachment 04 Organizational Conflict of Interest List.docx DOCX document
Attachment 01 DD 254.pdf PDF
Attachment 02 ASCNDI QASP CSP.docx DOCX document
P2 Contractor Performance Assessment Questionnaire.pdf PDF
Draft Solicitation (without Sample Task).pdf PDF
P3 Hourly Burdened Composite Labor Rates.xlsx XLSX spreadsheet
P6 Cost Summary.xlsx XLSX spreadsheet
Exhibit A - Contract Data Requirements List.docx DOCX document
Attachment 09 COMR CDRL Template.xlsx XLSX spreadsheet
P7 Subcontractor Cost Summary.xlsx XLSX spreadsheet
Labor_Categories.pdf PDF
Attachment_01_ASCNDI_SOW_PWS.pdf PDF
Draft_SOW_PWS_ASCNDI.pdf PDF
Draft_Labor_Hours_ASCNDI.pdf PDF
2.0_Industry_Communication_Guide_(June_2014).pdf PDF
Show 40 more

50 files listed here. See the rest on GovTribe.

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.

CDRL# Title TO Number

Contractor's Name Contractror's Address

Title of Report

CDRL #

Date of Report Period Covered by Report

Contract number Name if issueing Government Agency Program/System Nomenclature

Security Classification or other appropriate markings

Prime Contract No Burn Rate Invoice Number Hours Invoice Date Labor $ PoP Bid Rate Billing Period Op Rate

Variance Contract Summary Base Mod 2 Percentage

CLIN LABOR HRS 3450 3450

CLIN LABOR Dollars 414,000.00$ 414,000.00$

CLIN TRAVEL 10,000.00$ 5,000.00$

CLIN MATERIAL 20,000.00$ 25,000.00$

Action items noted:

1) Move Ceiling up column F onto Contract Summary level

2) Remove TO Lines 21-33

3) Add funding to Contract Summary Table

4) Remove rows 13-16 from ODC burn area

5) Review format for ODC Burn vs ODC Ceiling

6) Move TO summary to "COR TDL Data Breakout" tab and incorporate efficiencies in data

Decisions:

Roll up tab will occur in each workbook for each TO

Awarded Ceiling Hrs Awarded Ceiling $ Cost Incurred Outstanding Commitments Cost Incurred w/commitments Unfunded Ceiling Balance (funded - Exp) % Ceiling Expended Hrs % Ceiling Expended $ % Ceiling Expended $ w/commitments % Funding Expended EAC Projected funding needed Prime Contract No Labor TO Number Travel Invoice Number Material Invoice Date Total:

PoP TO period Base, OPT I, OPT II Billing Period

Prime Subs

TO Summary TO base TO mod 2 TO mod 5 Funding Expended as of date of report

CLIN LABOR HRS APPN 1 1150 1225 1475 575 287.5

CLIN LABOR Dollars APPN 1 138,000.00$ 147,000.00$ 177,000.00$ 69,000.00$ 34500

CLIN LABOR HRS APPN 2 1725 1725 1725 575 287.5

CLIN LABOR Dollars APPN 2 207,000.00$ 207,000.00$ 207,000.00$ 69,000.00$ 34,500.00$

CLIN LABOR HRS APPN 3 575 500 250 575 287.5

CLIN LABOR Dollars APPN 3 69,000.00$ 60,000.00$ 30,000.00$ 69,000.00$ 34,500.00$ CLIN Travel Dollars APPN 1 6,000.00$ 1,000.00$ 1,000.00$ 1,000.00$ 500.00$ CLIN Travel Dollars APPN 2 2,000.00$ 2,000.00$ 2,000.00$ 1,000.00$ -$ CLIN Travel Dollars APPN 3 2,000.00$ 2,000.00$ 2,000.00$ 1,000.00$ 500.00$ CLIN Material Dollars APPN 1 10,000.00$ 10,000.00$ 10,000.00$ 10,000.00$ 8,000.00$ CLIN Material Dollars APPN 2 5,000.00$ 10,000.00$ 10,000.00$ 10,000.00$ 6,000.00$ CLIN Material Dollars APPN 3 5,000.00$ 5,000.00$ 5,000.00$ 2,500.00$ 1,500.00$

Estimated Amount $ Estimated HRS Funding Recieved $ Funded Hrs Expenditures to Date Funding Balance Funded HRS Bal Outstanding Commitments Cost Incurred To-Date (Total) Current Reg Hrs Current UT/TTA Hrs Total Current Hrs Cummulative Reg Hrs Cummulative UT/TTA Hrs Total Cummulative Hrs EAC Projected date for 75% notification (Based on expenditure to-date) Current Travel Cummulative Travel Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date) Current Material Cummulative Material Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date) Current Other ODC Cummulative Other ODC Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date)

CLIN 1 PoP This row is for TDL Cum This row is for TDL Cummulative for the CLIN Project Name TDL # Subtask # (If Applicable) Description Date Issued Estimated Amount $ Estimated HRS Funding Recieved $ Funded Hrs Expenditures to Date Funding Balance Funded HRS Bal Outstanding Commitments Cost Incurred To-Date (Total) Current Reg Hrs Current UT/TTA Hrs Total Current Hrs Cummulative Reg Hrs Cummulative UT/TTA Hrs Total Cummulative Hrs EAC Projected date for 75% notification (Based on expenditure to-date) Current Travel Cummulative Travel Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date) Current Material Cummulative Material Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date) Current Other ODC Cummulative Other ODC Outstanding Commitments Projected date for 75% notification (Based on expenditure to-date)

TDL1 SME SPT LOE 12 mo 1-Oct-20 150,000.00$ 1250.00 75,000.00$ 625 37,500.00$ 37,500.00$ 145 3,600.00$ 41,100.00$ 160 0 160 480 10 490 1,248.00$ 25-Mar-21 0 0 1350 25-Apr-21 0 0 0 25-May-21 0 0 0 25-Sep-21 TDL 2 (Estimated Amt - Funded) (Funded Hrs - Total Cummulative Reg Hrs) Labor planned for upcomming trip (Expenditures to date + outstanding commitments) (current Reg Hrs + Current UT/TTA Hrs) (current Cummulative Reg Hrs + Current Cummulative UT/TTA Hrs) Includes current Includes current Includes current

Subtask 1 Subtask 2

TDL 2 Total:

TDL 3

Subtask 1 Subtask 2 Subtask 3 Subtask 4 Subtask 5 Subtask 6 Subtask 7

TDL 3 Total:

CLIN 2 PoP This row is for TDL Cummulative for the CLIN

TDL1

TDL 2

Subtask 1 Subtask 2

Total:

TDL 3

Subtask 1 Subtask 2 Subtask 3 Subtask 4 Subtask 5 Subtask 6 Subtask 7

Total:

TO Totals

Travel Material Other ODCLABOR

Action items noted:

1) Rename tab as this is TO not TDL

2) Remove TO summary from Roll up tab and incorporate with the TDL CLIN data tab with efficiencies

Decisions noted:

1) Each TO has its own file.

2) Subcontractor Data should be included with the information below in the appropriate fileds.

Prime Contract No TO Number Invoice Number Invoice Date PoP Billing Period

Prime Subs

CLIN Project TDL # Subtask # (If Applicable) Employee Identifier LCAT On/Off site Key/Non-Key Date Resume submitted Date Resume Approved Date Removed (if Applicable) Name of Replacement Budgeted Hrs Current Hrs Billed Prior Period Adjustment Hr Cummulative Hrs Billed Current UT/TTA Hrs Cummulative UT/TTA Hrs Current Burdened Cost Priod Period Adjustment $ Cumulative Burdnended Cost Projected Total Costs B-1 Approved Rate Cummulative Burdened Cost Projected Total Costs % variation Justification for variation 1 SME SPT LOE 12 mo TDL1 1 1005218 Analyst, Senior On-Site Key 1/1/2015 1/1/2015 N/A N/A 1250 160 0 480 0 10 120.00$ 0 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.00$ 0% N/A

1250 160 0 480 0 10 120.00$ 0 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.00$ 0%

1 System "X" Installation TDL2 1 1003562 PM, Senior Off-site Key 1/1/2015 1/1/2015 N/A N/A 45 22 0 32 0 0 145.00$ 0 4,640.00$ 6,525.00$ 145.00$ 4,640.00$ 6,525.00$ 0% N/A 1 System "X" Installation TDL2 1 1005218 Analyst, Senior On-Site Key 10/1/2016 10/5/2016 N/A N/A 82 40 0 40 0 0 120.00$ 0 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.00$ 0% N/A 1 System "X" Installation TDL2 1 1005874 Analyst, Junior On-Site Non-Key N/A N/A N/A N/A 157 100 0 125 0 0 120.00$ 0 15,000.00$ 18,840.00$ 120.00$ 15,000.00$ 18,840.00$ 0% N/A 1 System "X" Installation TDL2 1 1005489 Engineer, Senior On-Site Non-Key N/A N/A N/A N/A 4520 2250 0 2257 0 0 125.00$ 0 282,125.00$ 565,000.00$ 125.00$ 282,125.00$ 565,000.00$ 0% N/A

1 System "X" Installation TDL2 1 1005987 Engineer, Junior On-Site Non-Key N/A N/A N/A N/A 4575 2250 0 3575 0 0 75.00$ 0 268,125.00$ 343,125.00$ 95.00$ 339,625.00$ 434,625.00$ 21% project required specific certification, COR approved 10/1/2015 1 System "X" Installation TDL2 2 1005289 Systems Analyst, Journeyman On-Site Non-Key N/A N/A N/A N/A 1920 874 0 900 0 0 95.00$ 0 85,500.00$ 182,400.00$ 100.00$ 90,000.00$ 192,000.00$ 5% N/A

1 System "X" Installation TDL2 2 1002659 Systems Analyst, Senior Off-site Non-Key N/A N/A N/A N/A 1920 874 0 900 0 0 105.00$ 0 94,500.00$ 201,600.00$ 120.00$ 108,000.00$ 230,400.00$ 13% Project required specific systems experience, personnel not avilable a rate bid 13219 6410 0 7829 0 0 0 754,690.00$ 1,327,330.00$ 844,190.00$ 1,457,230.00$ 39%

Actual Rate Bid Rate VariationPersonnel Data

Action items noted:

1) Combine this Tab with the Personnel Matrix COR Only file tab

2) Create a roll up at the employee & LCAT level (see new tabs)

3) Create a tripwire trigger field (see employee tab) Decisions noted:

1) Employee identifiers are OK to be used

Prime Contract No TO Number Invoice Number Invoice Date PoP Billing Period

Prime Subs

Employee Identifier CLIN Project TDL # Subtask # (If Applicable) LCAT On/Off site Budgeted Hrs Current Hrs Billed Prior Period Adjustment Hrs Cummulative Hrs Billed Current UT/TTA Hrs Cummulative UT/TTA Hrs Current Burdened Cost Priod Period Adjustment $ Cumulative Burdnended Cost Projected Total Costs B-1 Approved Rate Cummulative Burdened Cost Projected Total Costs % variation Justification for variation 1005218 1 SME SPT LOE TDL1 1 Analyst, Senior 3 1250 160 0 480 0 10 120.00$ 0 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.00$ 0% N/A 1005218 1 System "X" Ins TDL2 1 Analyst, Senior 3 82 40 0 40 0 0 120.00$ 0 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.00$ 0% N/A

1332 200 0 520 0 10 0 62,400.00$ 9,840.00$ 240.00$ 62,400.00$ 159,840.00$

1003562 1 System "X" Ins TDL2 1 PM, Senior 4 45 22 0 32 0 0 155.00$ 0 4,960.00$ 6,975.00$ 145.00$ 4,640.00$ 6,525.00$ 7% N/A 1003562 1 TDL3 1 PM, Senior 4 1920 1800 0 1850 0 0 155.00$ 0 286,750.00$ 297,600.00$ 145.00$ 268,250.00$ 278,400.00$ 7% N/A

1965 1822 0 1882 0 0 291,710.00$ 304,575.00$ 290.00$ 272,890.00$ 284,925.00$ 14%

Personnel Data Actual Rate Bid Rate Variation

Action items noted:

1) Create a roll up at the employee level

2) Create a tripwire trigger field

Prime Contract No TO Number Invoice Number Invoice Date PoP Billing Period

Prime Subs

LCAT CLIN Project TDL # Subtask # (If Applicable) Employee Identifier On/Off site Budgeted Hrs Current Hrs Billed Prior Period Adjustment Hrs Cummulative Hrs Billed Current UT/TTA Hrs Cummulative UT/TTA Hrs Current Burdened Cost Priod Period Adjustment $ Cumulative Burdnended Cost Projected Total Costs B-1 Approved Rate Cummulative Burdened Cost Projected Total Costs % variation Justification for variation Analyst, Senior 1 SME SPT LOE TDL1 1 1005218 3 1250 160 0 480 0 10 120.00$ 0 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.00$ 0% N/A Analyst, Senior 1 System "X" InsTDL2 1 1005689 3 82 40 0 40 0 0 120.00$ 0 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.00$ 0% N/A

1332 200 0 520 0 10 0 62,400.00$ 9,840.00$ 240.00$ 62,400.00$ 159,840.00$ 0%

PM, Senior 1 System "X" InsTDL2 1 1003562 4 45 22 0 32 0 0 155.00$ 0 4,960.00$ 6,975.00$ 145.00$ 4,640.00$ 6,525.00$ 7% N/A PM, Senior 1 Training TDL3 1 1005974 4 1920 1800 0 1850 0 0 155.00$ 0 286,750.00$ 297,600.00$ 145.00$ 268,250.00$ 278,400.00$ 7% N/A

1965 1822 0 1882 0 0 291,710.00$ 304,575.00$ 290.00$ 272,890.00$ 284,925.00$ 14%

Personnel Data Actual Rate Bid Rate Variation

Action items noted:

1) Create a roll up at the LCAT level

Prime Contract No Invoice Number Invoice Date PoP Billing Period This will be a spend plan graph by CLIN

Dollars Month 1 Month 2 Month 3

FUNDED $25,000.00 $25,000.00 $25,000.00

COSTS $15,000.00 $22,500.00 $24,500.00

PROJECTED TOTAL $15,000,000.00 $15,000,000.00 $15,860,000.00

CEILING 15,000,000.00$ 15,000,000.00$ 15,000,000.00$

Hours Month 1 Month 2 Month 3 Budgeted 3840 3840 3840 Billed 450 850 920

PROJECTED 3840 3840 3840

CEILING 7500 7500 7500

$0.00

$2,000,000.00

$4,000,000.00

$6,000,000.00

$8,000,000.00

$10,000,000.00

$12,000,000.00

$14,000,000.00

$16,000,000.00

$18,000,000.00

Month 1 Month 2 Month 3 Month 4

Month 1 Month 2 Month 3 Month 4

Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 $120,000.00 $350,000.00 $15,000,000.00 $15,000,000.00 $15,000,000.00 $15,000,000.00 $50,000.00 $75,000.00 $100,000.00 $13,000,000.00 $14,000,000.00 $14,100,000.00

$15,860,000.00 $15,860,000.00 $15,860,000.00 $15,860,000.00 $15,860,000.00 $15,860,000.00 15,000,000.00$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00$

Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 3840 3840 3840 3840 3840 5760 1050 1500 1750 2250 2550 2950 3840 3840 3840 5760 5760 5760 7500 7500 7500 7500 7500 7500

Month 5 Month 6 Month 7 Month 8 Month 9 Month 10

Chart Title

FUNDED COSTS PROJECTED TOTAL CEILING

Chart Title

Month 5 Month 6 Month 7 Month 8 Month 9 Month

Budgeted Billed PROJECTED CEILING

Month 10 Month 11 Month 12 $15,000,000.00 $15,000,000.00 $15,000,000.00 $14,589,000.00 $15,552,412.00 $15,860,000.00 $15,860,000.00 $15,860,000.00 $15,860,000.00 15,000,000.00$ 15,000,000.00$ 15,000,000.00$

Month 10 Month 11 Month 12 5760 5760 5760 3500 4500 5760 5760 5760 5760 7500 7500 7500

Action it

1) Add h

Month 11 Month 12 h 10 Month 11 Month 12 tems noted:

hours graphic

Prime Contract No TO Number Invoice Number Invoice Date PoP Billing Period

Item Name CLIN SubCLIN TO/TDL/SubtaPO# Description Invoice Number Purpose Vendor Quantity Unit Price Estimated Cost Actual Cost Variance (between estimated and actual costs) Gov Approver if required by Contract Disposition

Cummulative Total:

Traveler CLIN SubCLIN TO/TDL/SubtaDestination Purpose Date of Travel Length (days) Estimated C Actual Cost Variance (between esti Justification Governement Government approval date

Cummulative Total:

Field Services Or other ODC fields to be added based on specific procurement requirement

Material Purchases

Travel

Title Page
IDIQ Basic Roll Up
COR TO Data Breakout
Rate Analysis COR only file
Rate Analysis by employee ID
Rate Analysis by LCAT
COR Spend plan per CLIN
COR ODC Roll Up Reporting

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