Atch 1a - PWS Appendix 3A.xlsx
XLSX spreadsheet 135 KB Posted
- Solicitation number
- HTC711-24-R-CC01
About this file
This document is an appendix, Appendix 3A and 3A-1, which provides instructions for preparing and submitting aircraft information in response to a federal contract opportunity for international charter airlift services in support of the Civil Reserve Air Fleet (CRAF) program.
The appendix outlines the required information to be provided by offerors, including the number and type of aircraft, FAA registration numbers, cargo/passenger capability, ownership, and preferred stage assignment. It also provides specific instructions for completing the Appendix 3A-1 forms to validate the offeror's CRAF-capable fleet, including requirements for long-range international, short-range international, and domestic aircraft. Offerors must meet minimum requirements for the percentage of CRAF-capable aircraft offered. The document includes detailed guidance on data entry, calculations, and formatting for the Excel-based forms.
View the file
Other files
Show 40 more
50 files listed here. See the rest on GovTribe.
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
Instructions
Instructions for Preparation of
APPENDIX 3A & 3A-1
1. The revised version of the appendix 3A will supersede the previous requirement of providing a stage assignment letter. Each offeror shall indicate on the appendix 3A, number of aircraft, by type and FAA registration number which it is making available for acceptance by the Government. Additional blocks identifying cargo/passenger, and ownership must also be completed. Stage assignment should indicate the carrier’s preference regarding assignment to a particular stage. If “No Preference” is selected, placement of the aircraft within the fleet will be at the discretion of the CRAF office. To prevent stage assignement of a particular aircraft, do not place any marks in the “Carrier Recommendation for Stage Assignment” columns. All aircraft entered on the appendix 3A should be listed on the carrier’s current FAA Operation Specifications (Ops Spec) D085, “Aircraft Listing” to validate aircraft control. Complete the heading of the 3A by entering the carrier name, solicitation contract number, and the effective date of the D085 used to validate company aircraft. All highlighted cells on the forms 3A and 3A-1 require input from the offeror. All other cells have been locked to prevent accidental manipulation of the form.
a. All forms must be prepared utilizing the most current MS Excel-based file, available at http://www.amc.af.mil/library/businesscustomers.asp, located under “Information for Commercial Carriers.”
b. Cargo aircraft data is computed using the 463L pallet (88” x 108” in size).
c. Passenger data is computed using 400 pounds per passenger (includes baggage).
d. When clearing any cell data, only use the “Delete” function on your computer keyboard. Do not use the “Space Bar” to clear cell data, it may cause errors in the pre-calculation or conditional formatting formulas. If you inadvertently select the space bar to erase cell data and an error exist, select the “undo” button to correct the error.
2. Appendix 3A-1, CRAF Capable Fleet Validation (Int’l Segment) Long Range – Tab 5 of the spreadsheet is specifically data collection for aircraft assigned to the Long Range International (LRI) section. Offers made to the Short Range International (SRI) section in conjunction with the LRI offer, will add those aircraft to the appendix 3A-1 Fleet Validation (SRI) spreadsheet on Tab 6. If a carrier offers both categories of aircraft, passenger and cargo a separate appendix 3A-1 will be required for each category to validate the minimum WBE commitment. Each data cell will be explained below.
Long Range Section. Identify aircraft category by deleting the non-applicable type i.e., if the appendix 3A-1 is validating passenger aircraft, delete the word “Cargo” from the heading.
Aircraft Model/Series. Provide aircraft model and series (e.g. B747-400) of each CRAF capable aircraft entered on the carrier’s Ops Spec D085. If the model does not meet LRI minimums, only list the model identifier (e.g. A319). Listing each series of a carrier’s fleet may exceed sufficient space to accommodate all aircraft entries. The carrier’s fleet as listed on the D085 will be listed on the Appendix 3A-1 intended to determine minimum WBE offered. Note: Use only the category (cargo or passenger) of fleet being validated. Aircraft of same model/series with different WBE values must be entered on a new line to account for the dissimilar WBE value.
Total CRAF Capable Aircraft. Enter total number of aircraft meeting the minimum requirements as described in “Section M-3” of the solicitation contract.
(1) All cargo aircraft, regardless of assigned Segment or Section, must be capable of accommodating 108” x 88” (standard military) 463L compatible pallets. Aircraft requiring modification to the Cargo Loading System (CLS) to accommodate the 463L pallet may qualify if the company owns or has access to sufficient quantities of equipment (or kits) necessary for conversion.
(2) Passenger aircraft requiring seat and/or service facilities i.e. lavatories, galleys, reconfiguration must have the available equipment and be able to complete the configuration change to perform airlift services within the respective Stage response time.
Total Aircraft in Fleet. Enter the total number of aircraft for each aircraft model.
Total Aircraft Offered. Enter total number of CRAF capable aircraft offered for that model. Should be the same number of aircraft as listed on the appendix 3A.
Aircraft WBE Value. Enter the wide body equivalent (WBE) value for a single aircraft of each CRAF capable aircraft model. This value may be found on the Form 83 in the “Approximate Base MV Points” block. However, to convert from MV to WBE move the decimal point to the left one digit (example: from 4.22 to .422). Range bonus shall not be considered when computing WBE for this form.
Total WBE Available. This column is self-computed by multiplying “Aircraft WBE Value” with “CRAF Capable Aircraft”.
Total WBE Offered. This column is self-computed by multiplying “Aircraft WBE Value” with “Total Aircraft Offered”.
Percentage of WBE CRAF Capable Fleet Offered. This column is self-computed by dividing “Total WBE Offered” by “Total WBE Available”.
3. Appendix 3A-1, CRAF Capable Fleet Validation (Int’l Segment) Short Range – Tab 6 of the spreadsheet is specifically data collection for aircraft assigned to the Short Range International (SRI) section. If a carrier possesses passenger and cargo aircraft to be offered, a separate appendix 3A-1 will be completed for each aircraft type to validate the minimum WBE commitment. The steps to complete this appendix 3A-1 are similar to the LRI procedures and may be used as depicted above.
4. Appendix 3A-1 (Nat’l Segment) – Tab 7 of the spreadsheet is specifically data collection for domestic carriers. Each data cell will be explained below.
Aircraft Model/Series. Provide aircraft model and series (e.g. B737-800) of each CRAF capable aircraft entered on the carrier’s Ops Spec D085. If the model does not meet Nat’l Segment minimums, only list the model identifier (e.g. MD80). Listing each series of a large carrier’s fleet may not provide sufficient space on the form to accommodate all aircraft entries.
Total CRAF Capable Aircraft. Enter total number of aircraft meeting the minimum requirements as described in “Section M-3” of the solicitation contract.
(1) All cargo aircraft, regardless of assigned Segment or Section, must be capable of accommodating 108” x 88” (standard military) 463L compatible pallets. Aircraft requiring modification to the Cargo Loading System (CLS) to accommodate the 463L pallet may qualify if the company owns or has access to sufficient quantities of equipment (or kits) necessary for conversion.
(2) Passenger aircraft requiring seat and/or service facilities i.e. lavatories, galleys, reconfiguration must have the available equipment and be able to complete the configuration change to perform airlift services within the respective Stage response time.
Total Aircraft in Fleet. Enter the total number of aircraft for each aircraft model.
Total Aircraft Offered. Enter total number of aircraft offered for that aircraft model.
Should be the same number of aircraft as listed on the appendix 3A.
Total Aircraft Available. This column is self-populating using the input from the “CRAF Capable Aircraft” column.
Total Aircraft Offered. This column is self-populating using the input from the “Total Aircraft Offered” column.
Percentage of CRAF Capable Fleet Offered. This column is self-computed by dividing “Total Aircraft Offered” by “Total Aircraft Available”.
5. For questions concerning preparation of these forms, please contact the CRAF office (AMC/A3BC) via phone at (618) 229-1751 or e-mail at AMC-A3BC@scott.af.mil.
Tab 1--3A, (AC 1-35)
| Carrier: | Solicitation | Contract # : | HTC71124RCC01 Atch 1a |
| APPENDIX 3A - LIST OF AIRCRAFT | |||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | Carrier Recommendation |
for Stage Assignment Tails Offered Aircraft Model/Series Cargo or Passenger Reg. Number Own or Lease No Preference LRI Only Stage I Stage II Stage III
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| International Must offer 40% of WBE of their CRAF Capable Aircraft in Fleet |
| Domestic Must offer 15% of CRAF Capable Aircraft in Fleet |
| Appendix 3A, Revised 20160901, Version 2.0 Page 1 of 4 |
&"-,Bold"
Tab 2--3A, (AC 36-70)
| Carrier: | 0 | Solicitation | Contract # : | HTC71124RCC01 Atch 1a | |
| APPENDIX 3A - LIST OF AIRCRAFT | |||||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | Carrier Recommendation |
for Stage Assignment Tails Offered Aircraft Model/Series Cargo or Passenger Reg. Number Own or Lease No Preference LRI Only Stage I Stage II Stage III
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| International Must offer 40% of WBE of their CRAF Capable Aircraft in Fleet |
| Domestic Must offer 15% of CRAF Capable Aircraft in Fleet |
| Appendix 3A, Revised 20160901, Version 2.0 Page 2 of 4 |
Tab 3--3A, (AC 71-105)
| Carrier: | 0 | Solicitation | Contract # : | HTC71124RCC01 Atch 1a | |
| APPENDIX 3A - LIST OF AIRCRAFT | |||||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | Carrier Recommendation |
for Stage Assignment Tails Offered Aircraft Model/Series Cargo or Passenger Reg. Number Own or Lease No Preference LRI Only Stage I Stage II Stage III
| 71 |
| 72 |
| 73 |
| 74 |
| 75 |
| 76 |
| 77 |
| 78 |
| 79 |
| 80 |
| 81 |
| 82 |
| 83 |
| 84 |
| 85 |
| 86 |
| 87 |
| 88 |
| 89 |
| 90 |
| 91 |
| 92 |
| 93 |
| 94 |
| 95 |
| 96 |
| 97 |
| 98 |
| 99 |
| 100 |
| 101 |
| 102 |
| 103 |
| 104 |
| 105 |
| International Must offer 40% of WBE of their CRAF Capable Aircraft in Fleet |
| Domestic Must offer 15% of CRAF Capable Aircraft in Fleet |
| Appendix 3A, Revised 20160901, Version 2.0 Page 3 of 4 |
Tab 4--3A, (106-130)
| Carrier: | 0 | Solicitation | Contract # : | HTC71124RCC01 Atch 1a | |
| APPENDIX 3A - LIST OF AIRCRAFT | |||||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | Carrier Recommendation |
for Stage Assignment Tails Offered Aircraft Model/Series Cargo or Passenger Reg. Number Own or Lease No Preference LRI Only Stage I Stage II Stage III
| 106 |
| 107 |
| 108 |
| 109 |
| 110 |
| 111 |
| 112 |
| 113 |
| 114 |
| 115 |
| 116 |
| 117 |
| 118 |
| 119 |
| 110 |
| 111 |
| 112 |
| 113 |
| 114 |
| 115 |
| 116 |
| 117 |
| 118 |
| 119 |
| 120 |
| 121 |
| 122 |
| 123 |
| 124 |
| 125 |
| 126 |
| 127 |
| 128 |
| 129 |
| 130 |
| International Must offer 40% of WBE of their CRAF Capable Aircraft in Fleet |
| Domestic Must offer 15% of CRAF Capable Aircraft in Fleet |
| Appendix 3A, Revised 20160901, Version 2.0 Page 4 of 4 |
Tab 5--3A-1, Validation (LRI)
| Carrier: | 0 | Contract # : | HTC71124RCC01 Atch 1a | ||
| APPENDIX 3A-1, CRAF CAPABLE FLEET VALIDATION (Int'l Segment) | |||||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | Long Range Section | Passenger or Cargo | ||
| Line Item | Aircraft |
Model/Series by Category (Cargo/Pax)
| As shown on D085 | Total Aircraft in Fleet by Category (Cargo/Pax) |
| As shown on D085 | Total CRAF |
Capable
| Aircraft | Total Aircraft | |
| Offered | Aircaft WBE | |
| Value | Total WBE Available | Total WBE |
| Offered | % of WBE CRAF Capable |
Fleet Offered
| 1 | 0.000 | 0.000 | |||
| 2 | 0.000 | 0.000 | |||
| 3 | 0.000 | 0.000 | |||
| 4 | 0.000 | 0.000 | |||
| 5 | 0.000 | 0.000 | |||
| 6 | 0.000 | 0.000 | |||
| 7 | 0.000 | 0.000 | |||
| 8 | 0.000 | 0.000 | |||
| 9 | 0.000 | 0.000 | |||
| 10 | 0.000 | 0.000 | |||
| 11 | 0.000 | 0.000 | |||
| 12 | 0.000 | 0.000 | |||
| 13 | 0.000 | 0.000 | |||
| 14 | 0.000 | 0.000 | |||
| 15 | 0.000 | 0.000 | |||
| 16 | 0.000 | 0.000 | |||
| 17 | 0.000 | 0.000 | |||
| 18 | 0.000 | 0.000 | |||
| 19 | 0.000 | 0.000 | |||
| 20 | 0.000 | 0.000 | |||
| 21 | 0.000 | 0.000 | |||
| 22 | 0.000 | 0.000 | |||
| TOTALS | 0 | 0 | ERROR:#DIV/0! | ||
| International Must offer 40% of WBE of the CRAF Capable Aircraft in Fleet | Perviously Offered A/C use form 81 | ||||
| Long Range International (LRI) carriers may offer aircraft in the Short Range International (SRI) section when 40% commitment has been met in the LRI section. | New Aircraft with different performance characteristics provide: |
Performance Data Package to inlcude the following
1. Form 82 Front & Back,
2. Form 83, and
3. Computerized Flight Plan (CFP) Appendix 3A-1, 20160901 Page 1 of 1
Tab 6--3A-1, Validation (SRI)
| Carrier: | 0 | Contract # : | HTC71124RCC01 Atch 1a | ||
| APPENDIX 3A-1, CRAF CAPABLE FLEET VALIDATION (Int'l Segment) | |||||
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | Short Range Section | Passenger | ||
| Line Item | Aircraft |
Model/Series by Category (Cargo/Pax)
| As shown on D085 | Total Aircraft in Fleet by Category (Cargo/Pax) |
| As shown on D085 | Total CRAF |
Capable
| Aircraft | Total Aircraft | |
| Offered | Aircaft WBE | |
| Value | Total WBE Available | Total WBE |
| Offered | % of WBE CRAF Capable |
Fleet Offered
| 1 | 0.000 | 0.000 | |||
| 2 | 0.000 | 0.000 | |||
| 3 | 0.000 | 0.000 | |||
| 4 | 0.000 | 0.000 | |||
| 5 | 0.000 | 0.000 | |||
| 6 | 0.000 | 0.000 | |||
| 7 | 0.000 | 0.000 | |||
| 8 | 0.000 | 0.000 | |||
| 9 | 0.000 | 0.000 | |||
| 10 | 0.000 | 0.000 | |||
| 11 | 0.000 | 0.000 | |||
| 12 | 0.000 | 0.000 | |||
| 13 | 0.000 | 0.000 | |||
| 14 | 0.000 | 0.000 | |||
| 15 | 0.000 | 0.000 | |||
| 16 | 0.000 | 0.000 | |||
| 17 | 0.000 | 0.000 | |||
| 18 | 0.000 | 0.000 | |||
| 19 | 0.000 | 0.000 | |||
| 20 | 0.000 | 0.000 | |||
| 21 | 0.000 | 0.000 | |||
| 22 | 0.000 | 0.000 | |||
| TOTALS | 0 | 0 | ERROR:#DIV/0! | ||
| International Must offer 40% of WBE of the CRAF Capable Aircraft in Fleet | Perviously Offered A/C use form 81 | ||||
| Carriers participating in Short Range International (SRI) only, will list their entire fleet as listed on the DO85. Aircraft not CRAF capable will only require population of the "Aircraft Model/Series", "Total CRAF Capable Aircraft" and "Total Aircraft in Fleet" columns. | New Aircraft with different performance characteristics provide: |
Performance Data Package to inlcude the following
1. Form 82 Front & Back,
2. Form 83, and
3. Computerized Flight Plan (CFP) Appendix 3A-1, 20160901 Page 1 of 1
Tab 7--3A-1, Validation (Nat)
| Carrier: | 0 | Contract # : | HTC71124RCC01 Atch 1a |
| FAA OPS SPEC (D085) Aircraft Listing, Effective Date: | 31-Dec-99 | For carriers with large fleets not able to adhere to the 15% rule, disregard "% of CRAF Capable Fleet Offered" total if below 15% | |
| APPENDIX 3A-1, CRAF CAPABLE FLEET VALIDATION (National Segment) | |||
| Line Item | Aircraft |
Model/Series by Category (Cargo/Pax)
| As shown on D085 | Total Aircraft in Fleet by Category (Cargo/Pax) |
| As shown on D085 | Total CRAF |
Capable
| Aircraft | Total Aircraft | ||
| Offered | Total Aicraft Available | Total Aircraft | |
| Offered | % of CRAF Capable |
Fleet Offered
| 1 | 0 | 0 | ||
| 2 | 0 | 0 | ||
| 3 | 0 | 0 | ||
| 4 | 0 | 0 | ||
| 5 | 0 | 0 | ||
| 6 | 0 | 0 | ||
| 7 | 0 | 0 | ||
| 8 | 0 | 0 | ||
| 9 | 0 | 0 | ||
| 10 | 0 | 0 | ||
| 11 | 0 | 0 | ||
| 12 | 0 | 0 | ||
| 13 | 0 | 0 | ||
| 14 | 0 | 0 | ||
| 15 | 0 | 0 | ||
| 16 | 0 | 0 | ||
| 17 | 0 | 0 | ||
| 18 | 0 | 0 | ||
| 19 | 0 | 0 | ||
| 20 | 0 | 0 | ||
| 21 | 0 | 0 | ||
| 22 | 0 | 0 | ||
| TOTALS | 0 | 0 | ERROR:#DIV/0! |
| Domestic Must offer 15% of CRAF Capable Aircraft in Fleet | |
| Appendix 3A-1, 20160901 Page 1 of 1 |
File details come from the government source that posted it. Updated .