FUEL BURN OPTIMISATION OF JET-PROPELLED AIRCRAFT DURING CLIMB USING EXCEL SOLVER

Abstract

This research paper describes the creation and usage of a fuel burn optimization program for jet-propelled aircraft using Excel Solver. The main goal is to minimize fuel usage during the climb phase, thereby reducing the operational costs and environmental impact. The study uses a mathematical model incorporating various parameters from BADA (Base of Aircraft Data) to estimate the fuel consumption. Excel Solver is then utilized to find the best flight profiles such as airspeed and rate of climb to achieve the lowest possible fuel burn. The results show a significant reduction in fuel consumption across the different flight scenarios. The program’s effectiveness has been validated through various case studies presented in this paper, which demonstrates improvements in fuel burn compared to traditional flight planning methods. The findings illustrate the practical benefits of integrating optimization tools into the aviation operations, leading to cost reduction and also supporting the goal of sustainable aviation by reducing greenhouse gas emissions. Additionally, this study includes recommendations for further refining the model to enhance accuracy and applicability.