Attachment 0002 - Mission Performance Calculation.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
Fort Rucker Aviation Maintenance (FRAM) II Presolicitation Notice
Solicitation number
W58RGZ-26-R-0026
Issued by

About this file

This is a Mission Performance Calculation worksheet that serves as a technical appendix for the Fort Rucker Aviation Maintenance (FRAM) II contract, detailing the metrics and formulas used to measure contractor performance. The document establishes two primary performance metrics: Daily Mission Performance (DMP) and Monthly Summary Mission Performance (MSMP), both calculated separately for each aircraft fleet based on data from three daily sorties.

The DMP calculation determines whether the contractor meets minimum aircraft availability requirements by comparing adjusted initial issue aircraft against contracted aircraft quantities. A fleet achieves DMP "YES" status when adjusted initial issue aircraft (calculated as total initial issue aircraft minus rejects plus approved IRAPs) equal or exceed the contracted aircraft count. The MSMP calculation measures cumulative monthly performance by factoring in surge aircraft capability, dividing total available aircraft (initial issue plus additional/surge aircraft, adjusted for rejects and IRAPs) by the adjusted initial issue aircraft baseline and multiplying by 100. The worksheet provides worked examples showing DMP calculations at 103.5% and MSMP calculations at 107.1%, illustrating how the contractor can exceed baseline requirements through effective maintenance operations and surge capacity utilization. These performance metrics are critical evaluation factors for the anticipated May 2026 RFP for Army Aviator training aircraft maintenance and logistics support at Fort Rucker, Alabama.

View the file

Other files

File Type Posted
Attachment 0001 - Performance Work Statement.pdf PDF
Attachment 0013 - Quality Assurance Surveillance Plan (QASP).pdf PDF
Exhibit A - Contract Data Requirements List (CDRLs).pdf PDF
DRAFT RFP W58RGZ26R0026 FRAM II.pdf PDF
Attachment 0009 - Government Oversight Team List.pdf PDF
Attachment 0005 - Installation Support Requirements.pdf PDF
Attachment 0007 - Government-Furnished (GF) Property (GFP) _ GF Equipment (GFE) _ GF Material (GFM).pdf PDF
Attachment 0002 - Mission Performance Calculation.xlsx XLSX spreadsheet
Attachment 0001 - Performance Work Statement.pdf PDF
Attachment 0008 - Facilities Listing.pdf PDF
Attachment 0012 - Question Template.xlsx XLSX spreadsheet
Attachment 0009 - Contracting Officer Representative (COR) Designation and Communications Matrix.pdf PDF
Attachment 0003 - Required Aircraft Table.pdf PDF
Exhibit A - Contract Data Requirements List (CDRL).pdf PDF
Attachment 0010 - Antiterrorism (AT) _ Operations Security (OPSEC) Coversheet.pdf PDF
Attachment 0004 - Document Summary List.pdf PDF
Attachment 0006 - Contract Security Classification Specification (DD 254).pdf PDF
Attachment 0014 - Facilities Guide.pdf PDF
Attachment 0011 - Pricing Template.xlsx XLSX spreadsheet
DRAFT RFP W58RGZ26R0026 FRAM II.pdf PDF
Show all 20

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

Sheet1

ATTACHMENT 0002 Mission Performance Calculation (v1.8 13APR26)

DMP

DMP is determined seperately for each fleet using total information for all 3 sorties, each measured day. DMP is YES or NO
C128Contracted Aircraft (The lower of Total Aircraft Requested or Attachment 0004 Required Aircraft Table Requirement)
C230Initial Issue Aircraft Total (The total number of Initial Issue aircraft including spares). This does not include Surge aircraft
C32Initial Issue Aircraft Rejects (The total number of Initial Issue aircraft rejects for all launch periods for the day)
C41Approved IRAPs (The total number approved IRAPs for rejected Initial Issue aircraft)
C529Adjusted Initial Issue Aircraft (=Initial Issue Aircraft Total - (Initial Issue Aircraft Rejects-Approved IRAPs))
DMPYESDMP (DMP is Yes for the fleet for the day if C5-Adjusted Initial Issue Aircraft is >= C1 Contracted Aircraft. DMP is NO for the day for a fleet if C5-Adjusted Initial Issue Aircraft is < C1 Contracted Aircraft
C2C3C4C5
30-(2-1)X100=30-1X100=29X100=1.036X100=103.50
282828
C1C1

MSMP

MSMP is a cumulative monthly measure for each fleet
C128Contracted Aircraft (The lower of Total Aircraft Requested or Attachment 0004 Required Aircraft Table Requirement)
C230Initial Issue Aircraft Total (The total number of Initial Issue aircraft including spares). This does not include Surge aircraft
C32Initial Issue Aircraft Rejects (The total number of Initial Issue aircraft rejects for all launch periods for the day)
C40Approved IRAPs (The total number approved IRAPs for rejected Initial Issue aircraft)
C528Adjusted Initial Issue Aircraft (=Initial Issue Aircraft Total - (Initial Issue Aircraft Rejects-Approved IRAPs))
C2C3C4C5
30-(2-0)X100=30-2X100=28X100=1.000X100=100.00
282828
C1
C628Adjusted Initial Issue Aircraft (not to exceed Contracted Aircraft; capped at 100% prior to surge)
C72Additional Issue/Surge Aircraft Issued (The total number of Additional Issue/surge aircraft issued, including spares)
C81Additional Issue/Surge Aircraft Rejects (The total number of Additional Issue/Surge aircraft rejects for all launch periods for the day)
C91Approved Additional Issue/Surge IRAPs (The total number approved IRAPs for rejected Additional Issue/Surge aircraft)
C1030Additional Issue/Surge Aicraft Total (=(Adjusted Initial Issue Aircraft + Additional Issue/Surge Aircraft Issued)- (Additional Issue/Surge Aircraft Rejects-Approved Additional Issue/Surge IRAPs))
MSMP107.1MSMP (=(Additional Issue/Surge Aircraft Total divided by (/) Adjusted Initial Issue Aircraft) x 100)
C6C7C8C9C10MSMP
(28+2)-(1-1)X100=30-0X100=30X100=1.071X100=107.10
282828
C1

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