I am working on a small personal project that uses fuel burn data about specific aircraft to calculate the total fuel required for a trip. The data looks like this:
| 120000 kg | 150000 kg | 180000kg
----------+------------+-----------+-----------
21,000 ft | 6250 kg/hr | 6350 kg/hr| 6450 kg/hr
22,000 ft | 6225 kg/hr | 6325 kg/hr| 6425 kg/hr
23,000 ft | 6200 kg/hr | 6300 kg/hr| 6400 kg/hr
Based on the table above, you can see that to cruise at 21,000 ft and a weight of 120,000 kg, you would burn 6250kg/hr.
The problem I am having is that in order to calculate total weight, you first need to know total fuel, which you don't have until you know the proper burn rate. What would be the proper way to calculate fuel based on this information?