Attachment 08 COMR CDRL Template COR ONLY.xlsx

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

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 Naval Air Systems Command will issue this single award contract with a period of performance of five years.

The anticipated contract type is cost-plus-fixed-fee with cost reimbursable other direct costs. The place of performance is 45% on-site at NAWCAD, 15% on-site at the Yuma Proving Grounds, and 40% off-site at a contractor facility. Interested businesses must submit a capabilities statement no more than 15 pages demonstrating their ability to perform the requirements by May 21, 2019. The North American Industry Classification System code is 541330 for engineering services and the small business size standard is $38.5 million. The required facility clearance is top secret.

View the file

Other files

File Type Posted
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
N00421-20-R-0002 Amendment 0001.pdf PDF
P7 Subcontractor Cost Summary.xlsx XLSX spreadsheet
P3 Hourly Burdened Composite Labor Rates.xlsx XLSX spreadsheet
P6 Cost Summary.xlsx XLSX spreadsheet
Attachment 3 Data Item Transmittal Form.docx DOCX document
Attachment 5 Authorized Subcontractors.pdf PDF
P1 Past Performance Information Form.pdf PDF
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
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
Attachment 4 OCI.pdf PDF
P6 Cost Summary.xlsx XLSX spreadsheet
Attachment 8 COMR CDRL Template COR.pdf PDF
Attachment 07 Sexual Assault and Sexual Harassment.docx DOCX document
Attachment 03 Data Item Transmittal Form.docx DOCX document
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
P1 Past Performance.pdf PDF
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
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
Labor_Categories.pdf PDF
Attachment_01_ASCNDI_SOW_PWS.pdf PDF
Draft_SOW_PWS_ASCNDI.pdf PDF
2.0_Industry_Communication_Guide_(June_2014).pdf PDF
Draft_Labor_Hours_ASCNDI.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

Text version

Title Page

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

CDRL# & Title TO Number

IDIQ Basic Roll Up

Prime Contract NoBurn Rate
Invoice NumberHours
Invoice DateLabor $
PoPBid Rate
Billing PeriodOp Rate
Variance
Contract SummaryBaseMod 2Percentage
CLIN LABOR HRS34503450
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

CDRL# & Title TO Number

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

COR TO Data Breakout

Awarded Ceiling HrsAwarded Ceiling $Cost IncurredOutstanding CommitmentsCost Incurred w/commitmentsUnfunded CeilingBalance (funded - Exp)% Ceiling Expended Hrs% Ceiling Expended $% Ceiling Expended $ w/commitments% Funding ExpendedEACProjected funding needed
Prime Contract NoLabor
TO NumberTravel
Invoice NumberMaterial
Invoice DateTotal:
PoP
TO periodBase, OPT I, OPT II
Billing Period
Prime
Subs
TO SummaryTO baseTO mod 2TO mod 5FundingExpended as of date of report
CLIN LABOR HRS APPN 1115012251475575287.5
CLIN LABOR Dollars APPN 1$ 138,000.00$ 147,000.00$ 177,000.00$ 69,000.0034500
CLIN LABOR HRS APPN 2172517251725575287.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 3575500250575287.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$ - 0
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
LABORTravelMaterialOther ODC
Estimated Amount $Estimated HRSFunding Recieved $Funded HrsExpenditures to DateFunding BalanceFunded HRS BalOutstanding CommitmentsCost Incurred To-Date (Total)Current Reg HrsCurrent UT/TTA HrsTotal Current HrsCummulative Reg HrsCummulative UT/TTA HrsTotal Cummulative HrsEACProjected date for 75% notification (Based on expenditure to-date)Current TravelCummulative TravelOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current MaterialCummulative MaterialOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current Other ODCCummulative Other ODCOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)
CLIN 1PoPThis row is for TDL Cummulative for the CLINThis row is for TDL Cummulative for the CLIN
Project NameTDL #Subtask # (If Applicable)DescriptionDate IssuedEstimated Amount $Estimated HRSFunding Recieved $Funded HrsExpenditures to DateFunding BalanceFunded HRS BalOutstanding CommitmentsCost Incurred To-Date (Total)Current Reg HrsCurrent UT/TTA HrsTotal Current HrsCummulative Reg HrsCummulative UT/TTA HrsTotal Cummulative HrsEACProjected date for 75% notification (Based on expenditure to-date)Current TravelCummulative TravelOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current MaterialCummulative MaterialOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current Other ODCCummulative Other ODCOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)
TDL1SME SPT LOE 12 mo1-Oct-20$ 150,000.001250.00$ 75,000.00625$ 37,500.00$ 37,500.00145$ 3,600.00$ 41,100.00160016048010490$ 1,248.0025-Mar-2100135025-Apr-2100025-May-2100025-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 currentIncludes currentIncludes 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 2PoPThis 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

TO Number

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.

Rate Analysis COR only file

Prime Contract No
TO Number
Invoice Number
Invoice Date
PoP
Billing Period
Prime
Subs
Personnel DataActual RateBid RateVariation
CLINProjectTDL #Subtask # (If Applicable)Employee IdentifierLCATOn/Off siteKey/Non-KeyDate Resume submitted

King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:

Columns I-L only required when "Key" Date Resume Approved Date Removed (if Applicable) Name of Replacement 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 King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:

Need a new title?

King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:

Columns I-L only required when "Key" Cummulative Burdened Cost Projected Total Costs % variation Justification for variation King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:

Recommend on a per COR basis to determine if justification is required once exceeding a certain percentage

1SME SPT LOE 12 moTDL111005218Analyst, SeniorOn-SiteKey1/1/151/1/15N/AN/A12501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%N/A
12501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%
1System "X" InstallationTDL211003562PM, SeniorOff-siteKey1/1/151/1/15N/AN/A452203200$ 145.000$ 4,640.00$ 6,525.00$ 145.00$ 4,640.00$ 6,525.000%N/A
1System "X" InstallationTDL211005218Analyst, SeniorOn-SiteKey10/1/1610/5/16N/AN/A824004000$ 120.000$ 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.000%N/A
1System "X" InstallationTDL211005874Analyst, JuniorOn-SiteNon-KeyN/AN/AN/AN/A157100012500$ 120.000$ 15,000.00$ 18,840.00$ 120.00$ 15,000.00$ 18,840.000%N/A
1System "X" InstallationTDL211005489Engineer, SeniorOn-SiteNon-KeyN/AN/AN/AN/A452022500225700$ 125.000$ 282,125.00$ 565,000.00$ 125.00$ 282,125.00$ 565,000.000%N/A
1System "X" InstallationTDL211005987Engineer, JuniorOn-SiteNon-KeyN/AN/AN/AN/A457522500357500$ 75.000$ 268,125.00$ 343,125.00$ 95.00$ 339,625.00$ 434,625.0021%project required specific certification, COR approved 10/1/2015
1System "X" InstallationTDL221005289Systems Analyst, JourneymanOn-SiteNon-KeyN/AN/AN/AN/A1920874090000$ 95.000$ 85,500.00$ 182,400.00$ 100.00$ 90,000.00$ 192,000.005%N/A
1System "X" InstallationTDL221002659Systems Analyst, SeniorOff-siteNon-KeyN/AN/AN/AN/A1920874090000$ 105.000$ 94,500.00$ 201,600.00$ 120.00$ 108,000.00$ 230,400.0013%Project required specific systems experience, personnel not avilable a rate bid
13219641007829000$ 754,690.00$ 1,327,330.00$ 844,190.00$ 1,457,230.0039%

TO Number

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

Rate Analysis by employee ID

Prime Contract No
TO Number
Invoice Number
Invoice Date
PoP
Billing Period
Prime
Subs
Personnel DataActual RateBid RateVariation
Employee IdentifierCLINProjectTDL #Subtask # (If Applicable)LCATOn/Off siteBudgeted HrsCurrent Hrs BilledPrior Period Adjustment HrsCummulative Hrs BilledCurrent UT/TTA HrsCummulative UT/TTA HrsCurrent Burdened CostPriod Period Adjustment $Cumulative Burdnended CostProjected Total CostsB-1 Approved RateCummulative Burdened CostProjected Total Costs% variationJustification for variation
10052181SME SPT LOE 12 moTDL11Analyst, Senior312501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%N/A
10052181System "X" InstallationTDL21Analyst, Senior3824004000$ 120.000$ 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.000%N/A
133220005200100$ 62,400.00$ 9,840.00$ 240.00$ 62,400.00$ 159,840.00
10035621System "X" InstallationTDL21PM, Senior4452203200$ 155.000$ 4,960.00$ 6,975.00$ 145.00$ 4,640.00$ 6,525.007%N/A
10035621TDL31PM, Senior4192018000185000$ 155.000$ 286,750.00$ 297,600.00$ 145.00$ 268,250.00$ 278,400.007%N/A
196518220188200$ 291,710.00

King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:

For Cells in orange Create conditional formatting or other rule to show tripwire being exceeded.

Note to COR, if labor tripwires are not approved as part of pre-award actions, then post-award actions are required once tripwire is exceeded $ 304,575.00 $ 290.00 $ 272,890.00 $ 284,925.00 14%

TO Number

Action items noted:

1) Create a roll up at the employee level

2) Create a tripwire trigger field Decisions noted:

1) Employee identifiers are OK to be used

Rate Analysis by LCAT

Prime Contract No
TO Number
Invoice Number
Invoice Date
PoP
Billing Period
Prime
Subs
Personnel DataActual RateBid RateVariation
LCATCLINProjectTDL #Subtask # (If Applicable)Employee IdentifierOn/Off siteBudgeted HrsCurrent Hrs BilledPrior Period Adjustment HrsCummulative Hrs BilledCurrent UT/TTA HrsCummulative UT/TTA HrsCurrent Burdened CostPriod Period Adjustment $Cumulative Burdnended CostProjected Total CostsB-1 Approved RateCummulative Burdened CostProjected Total Costs% variationJustification for variation
Analyst, Senior1SME SPT LOE 12 moTDL111005218312501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%N/A
Analyst, Senior1System "X" InstallationTDL2110056893824004000$ 120.000$ 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.000%N/A
133220005200100$ 62,400.00$ 9,840.00$ 240.00$ 62,400.00$ 159,840.000%
PM, Senior1System "X" InstallationTDL2110035624452203200$ 155.000$ 4,960.00$ 6,975.00$ 145.00$ 4,640.00$ 6,525.007%N/A
PM, Senior1TrainingTDL3110059744192018000185000$ 155.000$ 286,750.00$ 297,600.00$ 145.00$ 268,250.00$ 278,400.007%N/A
196518220188200$ 291,710.00$ 304,575.00$ 290.00$ 272,890.00$ 284,925.0014%

TO Number

Action items noted:

1) Create a roll up at the LCAT level Decisions noted:

1) Employee identifiers are OK to be used

COR Spend plan per CLIN

Prime Contract No
Invoice Number
Invoice Date
PoP
Billing Period
This will be a spend plan graph by CLIN
DollarsMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
FUNDED$25,000.00$25,000.00$25,000.00$120,000.00$350,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$15,000,000.00
COSTS$15,000.00$22,500.00$24,500.00$50,000.00$75,000.00$100,000.00$13,000,000.00$14,000,000.00$14,100,000.00$14,589,000.00$15,552,412.00$15,860,000.00
PROJECTED TOTAL$15,000,000.00$15,000,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,860,000.00$15,860,000.00$15,860,000.00$15,860,000.00
CEILING$ 15,000,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$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00$ 15,000,000.00
HoursMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
Budgeted384038403840384038403840384038405760576057605760
Billed450850920105015001750225025502950350045005760
PROJECTED384038403840384038403840576057605760576057605760
CEILING750075007500750075007500750075007500750075007500

Action items noted:

1) Add hours graphic

FUNDED Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 25000 25000 25000 120000 350000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 COSTS Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000 22500 24500 50000 75000 100000 13000000 14000000 14100000 14589000 15552412 15860000 PROJECTED TOTAL Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 CEILING Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000

Budgeted Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 3840 3840 3840 3840 3840 3840 3840 3840 5760 5760 5760 5760 Billed Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 450 850 920 1050 1500 1750 2250 2550 2950 3500 4500 5760 PROJECTED Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 3840 3840 3840 3840 3840 3840 5760 5760 5760 5760 5760 5760 CEILING Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

COR ODC Roll Up Reporting

Prime Contract No
TO Number
Invoice Number
Invoice Date
PoP
Billing Period
Material Purchases
Item NameCLINSubCLINTO/TDL/SubtaskPO#DescriptionInvoice NumberPurposeVendorQuantityUnit PriceEstimated CostActual CostVariance (between estimated and actual costs)Gov Approver if required by ContractDisposition

Cummulative Total:

Travel
TravelerCLINSubCLINTO/TDL/SubtaskDestinationPurposeDate of TravelLength (days)Estimated CostActual CostVariance (between estimated and actual costs)JustificationGovernement approverGovernment approval date
Cummulative Total:
Field Services Or other ODC fields to be added based on specific procurement requirement

TO Number

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