20170713_12(c)(25.4)_Section_L,_Atch_04_Weight-Mission_Performance_Workbook.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
UH-1N Replacement Program Federal contract opportunity
Solicitation number
FA8629-17-R-2507
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

FA8629-17-R-2507, Section L, Attachment 4: Weight and Mission Performance Workbook

View the file

Other files for this federal contract opportunity

Other files attached to UH-1N Replacement Program, newest first.
File Type Posted
20170829_FA8629-17-R-2507,_Request_for_Clarification__4.pdf PDF
20170817_12(e)(2(vii)_FA8629-17-R-2507,_Request_for_Clarification__3.pdf PDF
FA8629-17-R-2507_Section_J_Atch_23_Integrated_Master_Plan.pdf PDF
FA8629-17-R-2507,_Section_J,_Attachment_25-Section_L,_Attachment_5_TEP_Workbook_(Soft_Copy).xlsx XLSX spreadsheet
FA8629-17-R-2507_0002_Amendment_0002_Signed_SF30.pdf PDF
FA8629-17-R-2507_Section_J,_Attach_25_-_Section_L.pdf PDF
FA8629-17-R-2507,_Request_for_Clarification__2.pdf PDF
20170731_FA8629-17-R-2507_0001_Amendment.pdf PDF
20170721_Section_J,_Atch_25_Section_L.pdf PDF
20170721_Section_J,_Atch_19__Small_Business_Participation_Commitment_Document.pdf PDF
20170721_Section_J,_Exhibit_A_UH-1N_Replacement_CDRL_Package.pdf PDF
20170731_Section_L,_Atch_05_TEP_Workbook_(Expanded_Cells).xlsx XLSX spreadsheet
20170731_Section_J,_Atch_12_CLIN_SOW-PWS_Matrix.pdf PDF
FA8629-17-R-2507,_Request_for_Clarification__1.pdf PDF
FA8629-17-R-2507_Final_RFP_Sections_A-M_without_J_Attachments.pdf PDF
20170713_12(c)(22)_Section_J,_Atch_22_List_of_Commercial_Computer_Software_Licenses_Being_Procured_Under_CLIN_XX05.docx DOCX document
20170713_12(c)(14)_Section_J,_Atch_14_Air_Vehicle_Spares_Listing.xlsx XLSX spreadsheet
20170713_12(c)(25.7)_Section_L,_Atch_07_Code_3_Break_Drivers.xlsx XLSX spreadsheet
20170713_12(c)(8)_Section_J,_Atch_08_Technical_Data_and_Computer_Software_Identification_and_Assertion.xlsx XLSX spreadsheet
20170713_12(c)(7)_Section_J,_Atch_07_UH-1N_Replacement_Pricing_Table_Workbook.xlsx XLSX spreadsheet
20170713_12(c)(25.1)_Section_L_Atch_01_Cross_Reference_Matrix.xlsx XLSX spreadsheet
20170713_12(c)(25.5)_Section_L,_Atch_05_TEP_Workbook.xlsx XLSX spreadsheet
20170713_12(c)(25.6)_Section_L,_Atch_06__CEO_Certification_Letter.docx DOCX document
20170713_12(c)(4)_Section_J,_Atch_04_DD_Form_254.pdf PDF
20170713_12(c)(16)_Section_J,_Atch_16__Training_System_Spares_Listing.xlsx XLSX spreadsheet
20170713_12(c)(27)_Section_J_Atch_27_Special_Tooling_Listing.xlsx XLSX spreadsheet
20170713_12(c)(17)_Section_J,_Atch_17__Training_System_Support_Equipment_Listing.xlsx XLSX spreadsheet
20170713_12(c)(15)_Section_J,_Atch_15_Air_Vehicle_Support_Equipment_Listing.xlsx XLSX spreadsheet
20170713_12(c)(21)_Section_J,_Atch_21_Technical_Manual_Contract_Requirements.pdf PDF
FA8629-17-R-2507_Final_RFP_(Model_Contract).pdf PDF
20170713_12(c)(15)_Section_J,_Atch_15_Air_Vehicle_Support_Equipment_Listing.pdf PDF
20170713_12(c)(22)_Section_J,_Atch_22_List_of_Commerical_Computer_Software_Licenses_Being_Procured_Under_CLIN_XX05.pdf PDF
20170713_12(c)(4)_Section_J,_Atch_04_DD_Form_254.pdf PDF
20170713_12(c)(25)_Section_J,_Atch_25_Section_L.pdf PDF
20170713_12(c)(26)_Section_J,_Atch_26_Section_M.pdf PDF
20170713_12(c)(6)_Section_J,_Atch_06_DD_Form_1653_Transportation_Data.pdf PDF
20170713_12(c)(13)_Section_J,_Atch_13_UH-1N_Replacement_Base_Support_Agreement.pdf PDF
20170713_12(c)(17)_Section_J,_Atch_17_Training_System_Support_Equipment_Listing.pdf PDF
20170707_12(c)(EA)_Section_J,_Exhibit_A_UH-1N_Replacement_CDRL_Package.pdf PDF
20170713_12(c)(20)_Section_J,_Atch_20_Small_Business_Subcontracting_Plan.pdf PDF
20170713_12(c)(19)_Section_J,_Atch_19_Small_Business_Participation_Plan.pdf PDF
20170713_12(c)(27)_Section_J_Atch_27_Special_Tooling_Listing.pdf PDF
20170713_12(c)(7)_Section_J,_Atch_07_UH-1N_Replacement_Pricing_Table_Workbook.pdf PDF
20170713_12(c)(5)_Section_J,_Atch_05_AFMC_Form_158.pdf PDF
20170713_12(c)(10)_Section_J,_Atch_10_DD_Form_2794,_CSDR_Plan_-_Contract_Prime.pdf PDF
20170713_12(c)(11)_Section_J,_Atch_11_Government_Furnished_Information_List.pdf PDF
20170713_12(c)(8)_Section_J,_Atch_08_Technical_Data_and_Computer_Software_Identification_and_Assertion.pdf PDF
20170713_12(c)(23)_Section_J,_Atch_23_Integrated_Master_Plan.pdf PDF
20170713_12(c)(16)_Section_J,_Atch_16_Training_System_Spares_Listing.pdf PDF
20170713_12(c)(3)_Section_J,_Atch_03_UH-1N_Replacement_Statement_of_Work.pdf PDF
Show all 50

UH-1N Replacement Program has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

Instructions:
Provide the mission performance information as requested in the five worksheets of this workbook. Cells that are blacked out do not require your input.
Group Weight Estimate: Provide a group weight estimate for the UH-1N Replacement aircraft. The group weight estimate can be a separate attachment if desired.
Weight Estimate worksheet: Weight inputs shall be in accordance with MIL-STD-3013, Chapter 3 DEFINITIONS. The following definitions shall be used to determine the requested weights in the Weight Estimate tab: 3.10.1 Empty Weight, 3.10.2 Basic Weight, 3.10.3 Operating Weight, 3.10.4 Payload, 3.10.8 Takeoff Gross Weight and 3.10.9 Maximum Takeoff Gross Weight. List all components included in each weight estimate as well as the respective weights (lbs) for each component.

Mission Performance worksheets: Complete the separate worksheets for the ICBM ESR Mission, ICBM Convoy Escort Mission, COOP Transport Mission profiles. The missions are broken down by each segment and provide the altitude (MSL) and temperature (degrees C), as well as the time (minutes), speed (KTAS) or distance (nm) of the segment as needed. Each mission sequentially requests the aircraft weight at the start of the segment, weight at end of the segment, power available, power required, and the power setting used during this segment. Provide the fuel reserve in minutes and pounds at the end of each mission.

Energy Consumption worksheet: No inputs are required. This worksheet calculates, based on the mission performance inputs in the mission profile worksheets, the average energy consumption rate based on the average for the ICBM ESR Mission, ICBM Convoy Escort Mission and COOP Transport Mission profiles.

FA8629-17-R-2507

Section L, Attach 4 13 July 2017

Group Weight Estimate Group Weight Estimate Worksheet

FA8629-17-R-2507

Weight Estimate

WeightWeight Definition (MIL-STD-3013)ICBM ESR Mission Weight (lbs)ICBM Convoy Escort Mission Weight (lbs)COOP Transport Mission Weight (lbs)
1Weight EmptyWeight empty is defined as the weight of the air vehicle, complete by model design definitions, dry, clean, and empty, except for fluids in closed systems such as the hydraulic system. Weight empty includes total structure group, propulsion group, flight controls group, avionics group, auxiliary power plant group, electrical group, etc.
2Basic WeightBasic weight is defined as the weight empty adjusted for standard operational items such as unusable fuel, engine oil, oxygen, and all fixed armament.
3Operating WeightOperating weight is defined as the sum of basic weight plus such factors as crew, crew baggage, steward equipment, emergency equipment, special mission fixed equipment, pylons, racks, and other nonexpendable items not in basic weight. It is equivalent to takeoff gross weight less usable fuel, payload, and any items to be expended in flight.
4Payload WeightPayload is defined as any item which is being transported and is directly related to the purpose of the mission, as opposed to items necessary for the mission. Payload can include—but not be limited to— passengers, cargo, passenger baggage, ammunition, internal and external stores, and fuel which is to be delivered to another air vehicle or site. Payload may or may not be expended.
5Takeoff Gross WeightTakeoff gross weight is defined as the sum of the operating weight, usable fuel weight, payload items required to perform a particular defined mission, and other items to be expended during flight. Takeoff gross weight is determined prior to engine start for air vehicles which have a maximum ground weight equal to maximum takeoff gross weight. Takeoff gross weight is determined at liftoff for air vehicles which have a maximum ground weight higher than maximum takeoff gross weight. In the latter case, the fuel weight expended during warm-up, taxi, and takeoff are excluded.
6Maximum Takeoff Gross WeightMaximum takeoff gross weight is defined as the highest weight

authorized at liftoff. An air vehicle may have more than one maximum takeoff gross weight, such as one for landbased operations and one for carrier/catapult operations.

NOTE: Maximum takeoff gross weight may be the same as maximum gross weight.

ICBM ESR Mission

Segment NumberSegmentAdditional Segment DescriptionTime (min)Distance (nm)Speed (KTAS)End segment Altitude
(ft, MSL)Temp (C)Start Gross Weight (lbs)End Gross Weight (lbs)Fuel Used (lbs)Power RequiredPower AvailablePower Setting
ICBM Emergency Security Response Mission (SRD App D-1)1Start/Taxi/TakeoffUse Table D-1. Payload for the ICBM ESR Mission Profile in the UH-1N Replacement SRD to determine initial takeoff gross weight. Weapons, ammunition and flare weights should represent actual installation system weights.5620035.0Flight Idle
2Departure ClimbStart departure climb at previous segment end weight, altitude and temperature.650034.4
3aFly Enroute to Initial PointStart fly enroute to initial point at the previous segment end weight.35650034.4NTE MCP
3bFly Enroute to Initial Point35650034.4NTE MCP
3cFly Enroute to Initial Point35650034.4NTE MCP
4Loiter to initial pointStart loiter to initial point at the previous segment end weight.5650034.4
5Fly enroute and descent to HOGEStart fly enroute and descent to HOGE at the previous segment end weight, altitude and temperature.10560038.0
6Perform HOGEHOGE performed starting at previous segment end weight.1560038.0
7Descent to objective landing areaStart descent to objective landing area at the previous segment end weight, altitude and 36.2C.470038.0NTE MCP
8Landing at objective areaStart landing at objective area from the previous segment end weight. End weight should reflect dropping 2475 lbs worth of payload.470038.0
9Takeoff and climb to loiterStart takeoff and climb to loiter at the previous segment end weight, altitude and temperature.570036.0
10LoiterStart loiter at the previous segment end weight.45570036.0
11Descent to objective landing areaStart descent to objective landing area at the previous segment end weight, altitude and temperature.470038.0
12Landing at objective landing areaStart landing at the objective landing area at previous segment end weight.470038.0
DescriptionFuel Reserve (mins)Fuel Reserve (lbs)
Calculate reserve fuel (in minutes) after completion of Segment 12 using AFI 11-202v3, paragraph 2.2.3

&18FA8629-17-R-2507

ICBM Convoy Escort Mission

SegmentSegmentSegment DescriptionTime (min)Distance (nm)SpeedEnd segment Altitude (ft)Temp [C]Start Gross Weight (lbs)End Gross Weight (lbs)Fuel Used (lbs)Power RequiredPower AvailablePower Setting
ICBM Convoy Escort Mission (SRD App D-2)1Start/Taxi/TakeoffUse Table D-3. Payload for the ICBM Convoy Escort Mission Profile in the UH-1N Replacement SRD to determine initial takeoff gross weight. Weapons, ammunition and flare weights should represent actual installation system weights.5620035Flight Idle
2Departure ClimbStart departure climb at previous segment end weight, altitude and temperature.650034.4
3Escort ConvoyStart escort convoy at the previous segment end weight.180650034.4
4Fly to descent pointStart fly to descent point at the previous segment end weight.45650034.4
5Descent to landing areaStart descent to landing area at the previous segment end weight, altitude and temperature.
620035
6LandingStart landing at previous segment end weight.620035
DescriptionFuel Reserve (mins)Fuel Reserve (lbs)
Calculate reserve fuel (in minutes) after completion of Segment 6 using AFI 11-202v3, paragraph 2.2.3

&18FA8629-17-R-2507

COOP Transport Mission

Segment #SegmentSegment DescriptionTime (min)Distance (nm)SpeedEnd segment Altitude (ft)Temp [C]Start Gross Weight (lbs)End Gross Weight (lbs)Fuel Used (lbs)Power RequiredPower AvailablePower Setting
COOP/Transport Mission (SRD App D-3)1Start/Taxi/TakeoffUse Table D-5. Payload for the COOP/Transport Mission Profile in the UH-1N Replacement SRD to determine initial takeoff gross weight. Weapons, ammunition and flare weights should represent actual installation system weights.30.030.0Flight Idle
2Departure ClimbStart departure climb at previous segment end weight, altitude and temperature.300.029.4
3Cruise to pick-up pointStart cruise to pick-up point at the previous segment end weight.20300.029.4
4Descent to pick-up pointStart descent to pick-up point at the previous segment end weight, altitude and temperature.
0.030.0
5Perform landing for pick-upStart perform landing for pick-up starting at the previous segment end weight.
Add additional 1800 lbs to end weight for this segment.10.030.0
6Takeoff (HOGE required)Start takeoff to a HOGE based at the previous segment end weight.0.030.0
7Perform HOGEStart perform HOGE at the previous segment end weight.10.030.0
8Climb to Cruise altitudeStart climb to cruise altitude at the previous segment end weight.3300.023.4
9Cruise to drop-off pointStart cruise to drop-off point at the previous segment end weight.1753300.023.4
10Descent to drop-off pointStart descent to drop-off point at the previous segment end weight, altitude and temperature.3000.023.4
11Perform HOGEStart HOGE at the previous segment end weight.13000.023.4
12Descent to drop-off pointStart descent to drop-off point at the previous segment end weight.
3000.035.0
13Perform landing for drop-offStart landing for drop-off at the previous segment end weight. End weight should reflect dropping 1800 lbs worth of payload.13000.035.0
14Takeoff and climb to cruise altitudeStart takeoff and climb to cruise altitude at the previous segment end weight, altitude and temperature.3300.023.4
15Cruise to landing areaStart cruise to landing area at the previous segment end weight.303300.023.4
16Descent to landing areaStart descent to landing area at the previous segment end weight, altitude and temperature.0.030.0
17LandingStart landing at the previous segment end weight.0.030.0
DescriptionFuel Reserve (mins)Fuel Reserve (lbs)
Calculate reserve fuel (in minutes) after completion of Segment 17 using AFI 11-202v3, paragraph 2.2.3

&16FA8629-17-R-2507

Energy Consumption

Engery Consumption
MissionICBM ESRICBM Convoy EscortCOOP/TransportAverage Fuel Consumption Across All Missions
Average Fuel Consumption (gph)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

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