Attachment_9_-_COMR_CDRL_Template_COR_ONLY.xlsx

XLSX spreadsheet 61 KB Posted

Attached to
Advanced Sensor System Development and Execution (ASSDE) Federal contract opportunity
Solicitation number
N00421-19-R-0069
Issued by
Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

This sources sought notice requests capability statements from interested parties for an indefinite delivery indefinite quantity contract to support the design, development, and demonstration of sensor capabilities including information, surveillance, reconnaissance, electro-optical/infrared, hyper-spectral/multi-spectral imaging, light detection and ranging, radio detection and ranging, electronic intelligence, signals intelligence, chemical/biological/radiation/nuclear/explosive, and sound navigation and ranging technologies for various manned and unmanned airborne, shipborne, and fixed mobile ground platforms. The anticipated single award contract would have a 5-year ordering period and contemplate cost-plus-fixed-fee level of effort and completion labor contract line items as well as cost reimbursable other direct costs for travel and material. Capability statements are due by March 29, 2019 and should address technical capabilities and experience, facility and personnel security clearances, management approach, and past performance. The place of performance includes Naval Air Station Patuxent River, Maryland and Yuma Proving Grounds, Arizona.

Attachment 9 - COMR CDRL Template COR ONLY

View the file

Other files for this federal contract opportunity

Other files attached to Advanced Sensor System Development and Execution (ASSDE), newest first.
File Type Posted
N00421-19-R-0069 Amendment 0010.pdf PDF
P7 Subcontractor Cost Summary.xlsx XLSX spreadsheet
Amendment 0009.pdf PDF
N0042119R0069AMD0008.pdf PDF
Attachment P8 N0042119D0069.xlsx.pdf PDF
N00421-19-R-0069 Amendment 0007.pdf PDF
Attachment P1 - P1 Past Performance Information Form.pdf PDF
N00421-19-R-0069 Amendment 0006.pdf PDF
N00421-19-R-0069 Amendment 0005.pdf PDF
P1_Past_Performance_Information_Form.pdf PDF
Attachment 3 - OCI List.docx DOCX document
N00421-19-R-0069 Amendment 0004.pdf PDF
N00421-19-R-0069 Amendment 0003.pdf PDF
Attachment P1_-_P1 Past Performance Information Form.pdf PDF
N00421-19-R-0069_Amendment_0001.pdf PDF
Attachment_4_-_Authorized_Key_Personnel.docx DOCX document
Attachment_P3_-_Hourly_Burdened_Composite_Labor_Rates.xlsx XLSX spreadsheet
Attachment_P5_-_Reserved.docx DOCX document
Attachment_P7_-_Subcontractor_Cost_Summary_ASSDE.xlsx XLSX spreadsheet
Attachment_7_-_DD_254.pdf PDF
Exhibit_A_-_CDRLS.docx DOCX document
Attachment_5_-_Authorized_Subcontractors.docx DOCX document
Attachment_1_-_Data_Item_Transmittal_Form.docx DOCX document
Attachment_8_-_MFR.pdf PDF
Attachment_P2_-_Contractor_Performance_Assessment_Questionnaire.pdf PDF
Attachment_P4_-_Reserved.docx DOCX document
Attachment_6_-_QASP_CSP.docx DOCX document
Attachment_3_-_OCI_List.docx DOCX document
Attachment_10_-_COMR_CDRL_Template.xlsx XLSX spreadsheet
Attachment_2_-_COR_Appointment_Letter.docx DOCX document
Attachment_P6_-_Cost_Summary.xlsx XLSX spreadsheet
N00421-19-R-0069_ASSDE_Solicitation.pdf PDF
Attachment_P1_Past_Performance.pdf PDF
Attachment_P3_Streamlined_Rates.xlsx XLSX spreadsheet
Attachment_P7_Subcontractor_Cost_Summary.xlsx XLSX spreadsheet
Attachment_7_-_DD_254.pdf PDF
Attachment_2_-_COR_Appointment_Letter.docx DOCX document
N00421-19-R-0069.pdf PDF
Attachment_5_-_Authorized_Subcontractors.docx DOCX document
Attachment_4_-_Authorized_Key_Personnel.docx DOCX document
Exhibit_A_-_CDRLS.docx DOCX document
Attachment_1_-_Data_Item_Transmittal_Form.docx DOCX document
Attachment_6_-_QASP_CSP.docx DOCX document
Attachment_P4_Reserved.docx DOCX document
Attachment_P6_Cost_summary.xlsx XLSX spreadsheet
Attachment_P5_Reserved.docx DOCX document
Attachment_3_-_OCI_List.docx DOCX document
Attachment_P2_CPAQ.pdf PDF
ASSDE_SOW.pdf PDF
ASSDE_LOE.pdf PDF
Show all 50

Advanced Sensor System Development and Execution (ASSDE) has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

  • 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 .