The file's text, extracted by GovTribe without its formatting.
Summary
| Fleet Calculations Summary Tab |
| This attachment illustrates the process for calculating the Number of Concurrent Aircraft and Maximum Number of Aircraft per day. The summary tab outlines the methodology used to derive each calculation. The tabs for each Fleet will be utilized to perform these calculations. |
| Input Fleet Calculation Drivers |
| Using data submitted in CDRL A013, Daily Status Report, the user shall input the Total Number of Aircraft Assigned by fleet, the Total Number of Property Officer (PO) Fleet Aircraft by fleet, and the daily Validated Fleet Not Mission Capable Supply (NMCS) Percentage, rounded to the nearest whole percentage. Ensure all blue text fields in the Fleet Calculation Drivers for each Fleet tab are completed. All remaining information will update automatically. |
| Calculation 1: Excess Not Mission Capable Supply (NMCS) Adjustment |
| The Fleet NMCS Threshold is 13% for all fleets. If the daily Validated Fleet NMCS Percentage is less than or equal to the NMCS Threshold, no adjustment is applied. If the daily Validated Fleet NMCS Percentage exceeds the Fleet NMCS Threshold, the difference between the two values becomes the Excess NMCS Adjustment percentage for that day. |
| Calculation 2: School Fleet Size |
| The School Fleet size is determined by subtracting the Total Number of PO Fleet Aircraft from the Total Number of Aircraft Assigned. |
| Calculation 3: Number of Concurrent Aircraft |
| The Concurrency Rate in Table 1 below defines the percentage of the fleet required for simultaneous use. The Number of Concurrent Aircraft is calculated by multiplying the School Fleet Size by the Adjusted Concurrency Rate. The Adjusted Concurrency Rate is calculated by subtracting the Excess NMCS Adjustment percentage from the Concurrency rate in Table 1 below. If an Excess NMCS Adjustment applies, the School Fleet Size is multiplied by the difference between the Concurrency Rate and the Excess NMCS Adjustment percentage. The Number of Concurrent Aircraft is rounded down to the nearest whole number. |
| Table 1: Concurrency Rate | |
| Fleet | Concurrency Rate |
| AH-64E | 62% |
| CH-47F | 65% |
| UH-60M | 60% |
| UH-72A Cairns | 71% |
| UH-72A BWS | 71% |
| MV-75 | 60% |
Concurrent Aircraft Time begins when the Contractor issues the aircraft and ends when the aircraft is returned to Contractor control. An aircraft is considered "returned" under either of the following conditions:
a) The aircraft is rejected by the aircrew (no additional time applied).
b) The GTIMS scheduled sortie time for the aircraft ends, plus a 60-minute turnaround window.
| Calculation 4: Maximum Number of Aircraft |
| The Maximum Aircraft Percentage in Table 2 below defines the maximum percentage of each fleet the Contractor must provide each training day. The Maximum Number of Aircraft is calculated by multiplying the School Fleet Size by the Adjusted Maximum Aircraft Percentage. The Adjusted Maximum Aircraft Percentage is calculated by subtracting the Excess NMCS Adjustment percentage from the Maximum Aircraft Percentage rate in Table 2 below. The Maximum Number of Aircraft is rounded down to the nearest whole number. |
| Table 2: Maximum Aircraft Percentage | |
| Fleet | Maximum Aircraft Percentage |
| AH-64E | 145% |
| CH-47F | 135% |
| UH-60M | 145% |
| UH-72A Cairns | 150% |
| UH-72A BWS | 150% |
| MV-75 | 150% |
AH-64E
| AH-64E Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 117 | Total Number of Aircraft Assigned |
| 5 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 117 | Total Number of Aircraft Assigned |
| C5 | 5 | Total Number of PO Fleet Aircraft |
| C6 | 112 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 117 | - | 5 | = | 112 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 62% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 59% | Adjusted Concurrency Rate |
| C9 | 66 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 62% | - | 3% | = | 59% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 59% | X | 112 | = | 66 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 145% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 142% | Adjusted Maximum Aircraft % |
| C12 | 159 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 145% | - | 3% | = | 142% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 142% | X | 112 | = | 159 |
CH-47F
| CH-47F Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 40 | Total Number of Aircraft Assigned |
| 1 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 40 | Total Number of Aircraft Assigned |
| C5 | 1 | Total Number of PO Fleet Aircraft |
| C6 | 39 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 40 | - | 1 | = | 39 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 65% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 62% | Adjusted Concurrency Rate |
| C9 | 24 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 65% | - | 3% | = | 62% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 62% | X | 39 | = | 24 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 135% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 132% | Adjusted Maximum Aircraft % |
| C12 | 51 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 135% | - | 3% | = | 132% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 132% | X | 39 | = | 51 |
UH-60M
| UH-60M Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 115 | Total Number of Aircraft Assigned |
| 2 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 115 | Total Number of Aircraft Assigned |
| C5 | 2 | Total Number of PO Fleet Aircraft |
| C6 | 113 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 115 | - | 2 | = | 113 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 60% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 57% | Adjusted Concurrency Rate |
| C9 | 64 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 60% | - | 3% | = | 57% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 57% | X | 113 | = | 64 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 145% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 142% | Adjusted Maximum Aircraft % |
| C12 | 160 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 145% | - | 3% | = | 142% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 142% | X | 113 | = | 160 |
UH-72A Cairns
| UH-72A IERW Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 167 | Total Number of Aircraft Assigned |
| 2 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 167 | Total Number of Aircraft Assigned |
| C5 | 2 | Total Number of PO Fleet Aircraft |
| C6 | 165 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 167 | - | 2 | = | 165 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 71% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 68% | Adjusted Concurrency Rate |
| C9 | 112 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 71% | - | 3% | = | 68% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 68% | X | 165 | = | 112 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 150% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 147% | Adjusted Maximum Aircraft % |
| C12 | 243 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 150% | - | 3% | = | 147% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 147% | X | 165 | = | 243 |
UH-72A BWS
| UH-72A BWS Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 60 | Total Number of Aircraft Assigned |
| 2 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 60 | Total Number of Aircraft Assigned |
| C5 | 2 | Total Number of PO Fleet Aircraft |
| C6 | 58 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 60 | - | 2 | = | 58 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 71% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 68% | Adjusted Concurrency Rate |
| C9 | 39 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 71% | - | 3% | = | 68% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 68% | X | 58 | = | 39 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 150% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 147% | Adjusted Maximum Aircraft % |
| C12 | 85 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 150% | - | 3% | = | 147% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 147% | X | 58 | = | 85 |
MV-75
| MV-75 Fleet Calculations |
| Refer to the Summary tab for full calculation guidance. Ensure all blue text fields in the Fleet Calculation Drivers are completed. All remaining information will update automatically. |
| Fleet Calculation Drivers | |
| 16% | Validated Fleet NMCS % |
| 14 | Total Number of Aircraft Assigned |
| 1 | Total Number of PO Fleet Aircraft |
| Calculation 1: Excess NMCS Adjustment | | | |
| C1 | 16% | Validated Fleet NMCS % |
| C2 | 13% | Fleet NMCS Threshold |
| C3 | 3% | Excess NMCS Adjustment (If % is = or < Fleet NMCS Threshold, NMCS adjustment is 0%) |
| Excess NMCS Adjustment | | | | |
| C1 | | C2 | | C3 |
| 16% | - | 13% | = | 3% |
| Calculation 2: School Fleet Size | | | |
| C4 | 14 | Total Number of Aircraft Assigned |
| C5 | 1 | Total Number of PO Fleet Aircraft |
| C6 | 13 | School Fleet Size |
| School Fleet Size | | | | |
| C4 | | C5 | | C6 |
| 14 | - | 1 | = | 13 |
| Calculation 3: Number of Concurrent Aircraft | | | |
| C7 | 60% | Concurrency Rate |
| C3 | 3% | Excess NMCS Threshold |
| C8 | 57% | Adjusted Concurrency Rate |
| C9 | 7 | Number of Concurrent Aircraft |
| Adjusted Concurrency Rate | | | | |
| C7 | | C3 | | C8 |
| 60% | - | 3% | = | 57% |
| Number of Concurrent Aircraft | | | | |
| C8 | | C6 | | C9 |
| 57% | X | 13 | = | 7 |
| Calculation 4: Maximum Number of Aircraft | | | |
| C10 | 150% | Maximum Aircraft % |
| C3 | 3% | Excess NMCS Threshold |
| C11 | 147% | Adjusted Maximum Aircraft % |
| C12 | 19 | Maximum Number of Aircraft |
| Adjusted Maximum Aircraft % | | | | |
| C10 | | C3 | | C11 |
| 150% | - | 3% | = | 147% |
| Maximum Number of Aircraft | | | | |
| C11 | | C6 | | C12 |
| 147% | X | 13 | = | 19 |
