CDRL B001 Appendix A BLANK 08-14-20.xlsx

XLSX spreadsheet 334 KB Posted

Attached to
Pilot and Aircrew Curriculum Revision and Maintenance (PACRM)
Solicitation number
N6134020R0082
Issued by

About this file

Written by GovTribe AI ·

This document package includes a federal contract solicitation and supporting appendices. The solicitation is for a Pilot and Aircrew Curriculum Revision and Maintenance Multiple Award Contract to support the Naval Air Warfare Center Training Systems Division. The contract will establish indefinite delivery/indefinite quantity agreements to revise and maintain Navy and Marine Corps pilot and aircrew curriculum and electronic classroom systems. The appendices provide templates for contractors to report personnel, subject matter expert hours, logistics response center clerk hours, change request tracking, and equipment status. No products or services, response dates, award dates, pricing terms, or set-asides are specified in the document package.

View the file

Other files

File Type Posted
Att L-13 Govt Resp. Qs 22OCT20 -POST 0004.xlsx XLSX spreadsheet
PACRM RFP 20R0082- 0004 conformed 15Oct2020.docx DOCX document
Att L-7 E2-C2-LSO PBW 15OCT20-0004.xlsx XLSX spreadsheet
DISTRIBUTION D ATTs L8 -0004.docx DOCX document
PACRM RFP 20R0082 amend 0004 15Oct2020.docx DOCX document
Att L-13 Govt Resp. Qs 15OCT20 -0004.xlsx XLSX spreadsheet
PACRM RFP 20R0082- 0003 conformed 14Oct2020.docx DOCX document
Att L-13 Govt Resp. Qs 13OCT20 -0002.xlsx XLSX spreadsheet
PACRM RFP 20R0082 amend 0003 14Oct2020.docx DOCX document
PACRM RFP 20R0082 Amendment 0002.docx DOCX document
Att L-2 CE 06OCT20-0002.xlsx XLSX spreadsheet
Att L-13 Govt Resp. Qs 06OCT20 -0002.xlsx XLSX spreadsheet
DISTRIBUTION D ATTs L8 -0002.docx DOCX document
PACRM RFP 20R0082 Amendment 0002 Conformed.docx DOCX document
PACRM RFP 20R0082 amend 0001 conformed 30SEP20.docx DOCX document
DISTRIBUTION D ATTs L8 and L10 -0001.docx DOCX document
Att L-7 E2-C2-LSO PBW 23SEP20-0001.xlsx XLSX spreadsheet
Att L-13 Govt Resp. Qs 22SEP20 -0001 Final.xlsx XLSX spreadsheet
Att L-3 PP 22SEP20 -0001.xlsx XLSX spreadsheet
Att L-2 CE 22SEP20 -0001.xlsx XLSX spreadsheet
Att L-9a WD 2015-4341 Rev14 AUG20-0001.pdf PDF
PACRM RFP 20R0082 amendment 0001 30SEP20.docx DOCX document
Att J-3 PACT Users Guide 08-18-20.pdf PDF
Att J-2 DIT 4330 08-18-20.pdf PDF
Att L-4 PPQ 08-13-20.docx DOCX document
Att J-4 PACRM Planning DD 254 08-18-20.pdf PDF
Att L-9b CBA N6134017F0028 E2C2.pdf PDF
DISTRIBUTION D ATTs J1 and L8.docx DOCX document
Att L-3 PP Cont Data 08-28-20.xlsx XLSX spreadsheet
Att L-1 Solicitation Question Response Form 08-13-20.xlsx XLSX spreadsheet
Att L-6 MSC Chart BLANK 8-12-2020.xlsx XLSX spreadsheet
PACRM RFP 20R0082 15SEP2020.docx DOCX document
Att L-12 E2 C2 LSO DD 254 PLANNING 08-14-20.pdf PDF
Att J-5 Over and Above Requirement Request Form 08-18-20.docx DOCX document
Att L-7 E2-C2-LSO PBW 08-14-20.xlsx XLSX spreadsheet
Att L-11 CDRL Addressee List 08-13-20.docx DOCX document
Att L-9a WD 2015-4341 Rev13 DEC19.pdf PDF
Att L-10 E2 CDRL PKG 08-14-20.docx DOCX document
Att J-1 PACRM SCOPE 20R0082 08-18-20.docx DOCX document
Att L-2 CE Cont Data 08-28-20.xlsx XLSX spreadsheet
Att J-6 Excess Repair Form 08-18-20.docx DOCX document
Show all 41

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.

Tab 1 Personnel

Contractor PersonnelLeadership / Support
FT/PTQualRe-QualIATIATSecurity/
NamePositionPlatformDOL CATDOL TitleStatusDateDateSecurity +OSAccess Level
Contractor Personnel
FT/PTQualRe-QualIATIATSecurity/
NamePositionPlatformDOL CATDOL TitleStatusDateDateSecurity +OSAccess Level
Contractor PersonnelLSO
FT/PTQualRe-QualIATIATSecurity/
NamePositionPlatformDOL CATDOL TitleStatusDateDateSecurity +OSAccess Level

&"Arial,Bold"Revision and Maintenance &"Arial,Bold"Contractor Performance and Equipment Annex &"Arial,Bold"CDRL: B001

&"Arial,Bold"&A &"Arial,Bold"&P/&N &"Arial,Bold"&F

Tab 2 SME Hours

SME PERFORMANCE SUMMARY REPORT -
CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJunJulAugSepOctNovDecJanFebMarApr
FY-2019
START of Reporting Periodmm/dd/yy
END of Reporting Periodmm/dd/yyCumulative To Date
TOTAL
SME Hours Contracted for Rprt Period(# hrs)0.0
SME Hours Scheduled (SMES)(# hrs)0.0
SME Hours Completed in direct support scheduled hours (SMEC)(# hrs)0.0
Non-chargeable SME Hours Lost (LSME)(# hrs)0.0
Chargeable SME Hours Lost (CLSME)(# hrs)0.0
SME Factor (SMEF) percent%ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!
SME Hours working on CRs(# hrs)0.0
SME Hours working on other(# hrs)0.0

SME Units Contracted for: [ ] Hours per day (HPD) Mon-Fri [ ] 72 Hours per week (HPW) [ X ] Other_54 Hours per week (HPW)

CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJunJulAugSepOctNovDecJanFebMarApr
FY-2019
START of Reporting Periodmm/dd/yy
END of Reporting Periodmm/dd/yyCumulative To Date
TOTAL
SME Hours Contracted for Report Period(# hrs)0.0
SME Hours Scheduled (SMES)(# hrs)0.0
SME Hours Completed in direct support scheduled hours (SMEC)(# hrs)0.0
Non-chargeable SME Hours Lost (LSME)(# hrs)0.0
Chargeable SME Hours Lost (CLSME)(# hrs)0.0
SME Factor (SMEF) percent%ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!
SME Hours working on CRs(# hrs)0.0
SME Hours working on other(# hrs)0.0

SME Units Contracted for: [ ] Hours per day (HPD) Mon-Fri [ ] 72 Hours per week (HPW) [X ] Other 96 Hours per week (HPW)

CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJunJulAugSepOctNovDecJanFebMarApr
FY-2019
START of Reporting Periodmm/dd/yy
END of Reporting Periodmm/dd/yyCumulative To Date
TOTAL
SME Hours Contracted for Rprt Period(# hrs)0.0
SME Hours Scheduled (SMES)(# hrs)0.0
SME Hours Completed in direct support scheduled hours (SMEC)(# hrs)0.0
Non-chargeable SME Hours Lost (LSME)(# hrs)0.0
Chargeable SME Hours Lost (CLSME)(# hrs)0.0
SME Factor (SMEF) percent%ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!
SME Hours working on CRs(# hrs)0.0
SME Hours working on other(# hrs)0.0

SME Units Contracted for: [ ] Hours per day (HPD) Mon-Fri [ x ] 18 Hours per week (HPW) [ ] Other________

&"Arial,Bold"E-2 / LSO Revision and Maintenance &"Arial,Bold"Contractor Performance and Equipment Annex &"Arial,Bold"CDRL: B001

&"Arial,Bold"&A &"Arial,Bold"&P/&N &"Arial,Bold"&F

Tab 3 LRC Clerk

LRC CLERK SUMMARY REPORT
CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJuneJulyAugSepOctNovDecJanFebMarApr
FY-19
START of Reporting Period
END of Reporting PeriodCumulative To Date
TOTAL
LRC Hours Contracted for Rprt Period(# hrs)0
LRC Hours Scheduled (SS)(# hrs)0
LRC Hours Completed in direct support scheduled hours(# hrs)0
Non-chargeable LRC Hours Lost(# hrs)0
Chargeable LRC Hours Lost(# hrs)000000
LRC Factor (SF) percent%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

LRC Units Contracted for: [X] _8___Hours per day (HPD) Mon-Fri [ ] ________ Hours per month (HPM) [ ] Other_______Hours Per Week (HPW)

CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJuneJulyAugSepOctNovDecJanFebMarApr
FY-19
START of Reporting Period
END of Reporting PeriodCumulative To Date
TOTAL
LRC Hours Contracted for Rprt Period(# hrs)0
LRC Hours Scheduled (SS)(# hrs)0
LRC Hours Completed in direct support scheduled hours(# hrs)0
Non-chargeable LRC Hours Lost(# hrs)0
Chargeable LRC Hours Lost(# hrs)000000
0
LRC Factor (SF) percent%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
LRC Units Contracted for:[X ] __8___Hours per day (HPD) Mon-Fri [ ] ________ Hours per month (HPM) [ ] Other_______Hours Per Week (HPW)
CLIN #Contractor Name:
Contract/TaskCMD Location:
Order #:
Weapon System:
Fiscal Year:UnitsMayJuneJulyAugSepOctNovDecJanFebMarApr
FY-19
START of Reporting Period
END of Reporting PeriodCumulative To Date
TOTAL
LRC Hours Contracted for Rprt Period(# hrs)0
LRC Hours Scheduled (SS)(# hrs)0
LRC Hours Completed in direct support scheduled hours(# hrs)0
Non-chargeable LRC Hours Lost(# hrs)0
Chargeable LRC Hours Lost(# hrs)000000
LRC Factor (SF) percent%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Utilization Factor%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

LRC Units Contracted for: [X ] __8___Hours per day (HPD) Mon-Fri [ ] ________ Hours per month (HPM) [ ] Other_______Hours Per Week (HPW)

Tab 4 CR Numbers

FY XX

MayJunJulAugSepOctNovDecJanFebMarAprCumulative
CRs Validated this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs initiated (this period)00000000000000
CRs Due this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs due (this period) (CRD)00000000000000
Total CRs due (including late carryover)0000000000000
CRs Completed (that were due this period)
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs completed (that were due this period)00000000000000
CRs late (that were due this period)0000000000000
Late uncompleted CRs (total carryover) (LCRDPM)00000000000000
Late CRs completed (from carryover)00000000000000
CRs Accepted (this period) [Acceptance is automatic unless rejected for a valid reason by the government within 14 days]
Urgent0
Priority0
Cat 1,2,3 ABC0
Cat 4,5,6 ABC 1,2 D0
Cat 4D,5D,6C0
Other0
Total CRs accepted (this period) (CRA)0000000000000
Late CRs accepted this period (LCARPM)0000000000000
CR Time Factor * (CRTF)
CRTF = (CRA + LCRAPM) / (CRD + LCRDPM)
SEP of previous FYMayJunJulAugSepOctNovDecJanFebMarAprCumulative
CRs Validated this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs initiated (this period)00000000000000
CRs Due this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs due (this period) (CRD)00000000000000
Total CRs due (including late carryover)0000000000000
CRs Completed (that were due this period)
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs completed (that were due this period)00000000000000
CRs late (that were due this period)0000000000000
Late uncompleted CRs (total carryover) (LCRDPM)00000000000000
Late CRs completed (from carryover)00000000000000
CRs Accepted (this period) [Acceptance is automatic unless rejected for a valid reason by the government within 14 days]
Urgent0
Priority0
Cat 1,2,3 ABC0
Cat 4,5,6 ABC 1,2 D0
Cat 4D,5D,6C0
Other0
Total CRs accepted (this period) (CRA)0000000000000
Late CRs accepted this period (LCARPM)0000000000000
CR Time Factor * (CRTF)
CRTF = (CRA + LCRAPM) / (CRD + LCRDPM)
MayJunJulAugSepOctNovDecJanFebMarAprCumulative
CRs Validated this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs initiated (this period)00000000000000
CRs Due this period
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs due (this period) (CRD)00000000000000
Total CRs due (including late carryover)0000000000000
CRs Completed (that were due this period)
Urgent (7 days)0
Priority (14 days)0
Cat 1,2,3 ABC (25 days)0
Cat 4,5,6 ABC 1,2 D (45 days)0
Cat 4D,5D,6C (60 days)0
Other (90 days)0
Total CRs completed (that were due this period)00000000000000
CRs late (that were due this period)0000000000000
Late uncompleted CRs (total carryover) (LCRDPM)00000000000000
Late CRs completed (from carryover)00000000000000
CRs Accepted (this period) [Acceptance is automatic unless rejected for a valid reason by the government within 14 days]
Urgent0
Priority0
Cat 1,2,3 ABC0
Cat 4,5,6 ABC 1,2 D0
Cat 4D,5D,6C0
Other0
Total CRs accepted (this period) (CRA)0000000000000
Late CRs accepted this period (LCARPM)0000000000000
CR Time Factor * (CRTF)
CRTF = (CRA + LCRAPM) / (CRD + LCRDPM)
0
0
0
0
0
0
00000000000000
0
0
0
0
0
0
00000000000000
0000000000000
0
0
0
0
0
0
00000000000000
0000000000000
00000000000000
00000000000000
0
0
0
0
0
0
0000000000000
0000000000000

&"Arial,Bold"E-2 / LSO Revision and Maintenance &"Arial,Bold"Contractor Performance and Equipment Annex

&"Arial,Bold"&A &"Arial,Bold"&P/&N &"Arial,Bold"&F

Tab 5 Equipment Status

Site:
Notes:
Designation
Location (Bldg/Rm)
Training days in this reporting period
Servers
Number of Hours Required (This Reporting Period)
Number of Hours Unavailable
Percent AvailableERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ECR's
Number of Seats
Number of Hours Required (This Reporting Period)
Number of Hours Unavailable
Percent AvailableERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
LRC
Number of Seats
Number of Seats Unavailable
Number of Hours Required (This Reporting Period)
Number of Hours Unavailable
Percent Available100.00%100.00%100.00%
Scheduled Unavailable Next 90 Days (Date)NANANA
Reason for Scheduled Unavailable Time
Anticipated Obsolete Items/SoftwareNoneNoneNone
Working hours (servers/LRC)=Working hours(Servers)=Working hours (servers/LRC) =
Working hours(ECR)=Working hours (ECR)=Working hours (ECR)=
LEGEND:ISD RMreporting responsibility
COMMS reporting responsibility
POCs: Contractor
LSO School
E-2D COMMS

Tab 6 IAWF Tracking Line ID# Employee Type DOD IAWF Type IAWF Level Company System Name Location Employee Last Name Employee First Name Phone# Email Address IA Baseline Certification & Expiration Date or Anticipated Date O/S Trainng & Completion Date or Anticipated Date ACAS Training Completed or Anticipated date SA Appointment Letter Completion Date or Anticipated date SA Ltr -System(s) Listed PAA - System(s) Listed PAA Position Title Listed PAA Letter Completion Date or Anticipated date Comments

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