Attachment_08_-_COMR_CDRL_Template_(COR).xlsx

XLSX spreadsheet 65 KB Posted

Attached to
AIR-4. 11, N00421-19-R-0003 Irregular Air Platform Engineering supporting AD-4. 11. 6
Solicitation number
N00421-19-R-0003
Issued by

About this file

This document contains a draft statement of work and related attachments for a federal contract opportunity to provide Irregular Air Platform Engineering services in support of the Naval Air Warfare Center - Aircraft Division. Key details include:

  • The scope of work includes program management, research, analysis, design, parts procurement, installation/integration, test and evaluation, training, and operational support for urgent experiments enabling platform integrations.

  • The anticipated period of performance is a 5-year ordering period under an Indefinite Delivery Indefinite Quantity contract vehicle. The contract type will be cost-plus-fixed-fee, firm-fixed price, and cost reimbursable other direct costs.

  • The place of performance is 70% on-site at Naval Air Station Patuxent River, 15% on-site at Webster Field Annex, and 15% on-site at Yuma Proving Grounds.

  • The response due date for capability statements demonstrating ability to perform the scope of work is July 9, 2018. Statements should not exceed 15 pages and must include company profile, small business status, resources, management approach, security clearances, and relevant experience.

Attachment 08 - COMR CDRL Template (COR)

View the file

Other files

File Type Posted
N00421-19-R-0003 Amendment 0010.pdf PDF
N00421-19-R-0003 Amendment 0009 Conform.pdf PDF
Attachment P3 - P3 Hourly Burdened Rates-Rev 1.xlsx XLSX spreadsheet
Attachment P8 - DoD SAFE Help.pdf PDF
N00421-19-R-0003-0008 Conform.pdf PDF
N00421-19-R-0003 Amendment 0007.pdf PDF
Attachment 04 - OCI List.docx DOCX document
N00421-19-R-0003 Amendment 0006.pdf PDF
N00421-19-R-0003 Amendment 0005 Conform.pdf PDF
N00421-19-R-0003 Amendment 0004.pdf PDF
N00421-19-R-0003_Amendment_0003.pdf PDF
N00421-19-R-0003_Amendment_0002.pdf PDF
N00421-19-R-0003__Amendment_0001.pdf PDF
Attachment_P3_-_P3_Hourly_Burdened_Rates.xlsx XLSX spreadsheet
Attachment_P1_-_P1_Past_Performance_Information_Form.pdf PDF
Attachment_P4_-_P4_Reserved.docx DOCX document
Attachment_P6_-_Cost_Summary.xlsx XLSX spreadsheet
Attachment_11_-_MFR_Implementing_PGI_204.7108(d)(12).pdf PDF
Exhbit_A_-_Contract_Data_Requirements_List.xlsx XLSX spreadsheet
Attachment_05_-_Authorized_Subcontractors.docx DOCX document
Attachment_04_-_OCI_List.docx DOCX document
Attachment_09_-_COMR_CDRL_Template.xlsx XLSX spreadsheet
Attachment_10_-_Sexual_Assault_and_Sexual_Harassment_Training_Criteria.docx DOCX document
Attachment_P5_-_P5_Reserved.docx DOCX document
N00421-19-R-0003_Final.pdf PDF
Attachment_06_-_Authorized_Key_Personnel.docx DOCX document
Attachment_01_-_DD254_signed.pdf PDF
Attachment_P7_-_Subcontractor_Cost_Summary.xlsx XLSX spreadsheet
Attachment_P2_-_P2_Contractor_Performance_Assessment.pdf PDF
Attachment_02_-_CSP_QASP.docx DOCX document
Attachment_07_-_COR_Appointment_Letter.docx DOCX document
Attachment_03_-_Data_Item_Transmittal.docx DOCX document
Attachment_06_-_Authorized_Key_Personnel.doc DOC document
Attachment_P3_Streamlined_Rates.xlsx XLSX spreadsheet
Attachment_07_-_COR_Appointment_Letter.doc DOC document
Attachment_03_-_Data_Transmittal.docx DOCX document
Attachment_04_-_OCI_List.docx DOCX document
Attachment_02_-_CSP_QASP.docx DOCX document
Attachment_01_-_DD254_signed.pdf PDF
Attachment_P5_RESERVED.docx DOCX document
IAPE_Draft_Solicitation_FBO_.pdf PDF
Exhibit_A_-_Contract_Data_Requirements_List.xlsx XLSX spreadsheet
Attachment_05_-_Subcontractors.docx DOCX document
Attachment_09_-_COMR_CDRL_Template_(COR).xlsx XLSX spreadsheet
Attachment_P7_Subcontractor_Cost_Summary.xlsx XLSX spreadsheet
Attachment_08_-_COMR_CDRL_Template.xlsx XLSX spreadsheet
Attachment_P4_RESERVED.docx DOCX document
Attachment_P6_Cost_Summary.xlsx XLSX spreadsheet
IAPE-LOE.pdf PDF
IAPE-SOW.pdf PDF
Show all 50

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 .