use excel

1. Radiant requires cargo planes for the transportation of their goods and has approached VIP Transportation Company for this specific purpose. VIP has presented two options of cargo planes - WT88 and BH54, and has provided comprehensive cost-related information for both of them. Radiant Airlines has a clear plan in place for allocating funds towards personnel, fuel, and maintenance expenses. They are Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. To ensure maximum efficiency, they require a minimum of three planes for each type, with two options available: the WT88, boasting a weight capacity of 65 tons, and the BH54, capable of transporting up to 85 tons. Through the implementation of Linear Programming, help Radiant Airlines determine the necessary information required for optimal operations. (a) What is the maximum amount Radiant can carry, given their budget constraint? (b) How many WT88 and BH54 radiant should hire to carry the maximum amount