If you can solve this on Excel please!!

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? 2. Radiant requires cargo planes for the transportation of three distinct goods: A, B, and C. They have contacted VIP Transportation Company to arrange the rental. It has been communicated to Radiant that VIP has two types of cargo planes available, with 55 of each type. Furthermore, VIP has shared weightrelated information for the two types of planes, WT88 and BH54. To transport their cargo, Radiant needs to move 300 tons of Goods A, 300 tons of Goods B, and 350 tons of Goods C. In order to do so, they will require at least two WT88 and two BH54 planes. The cost for each WT88 plane with VIP is $1600 and each BH54 is $1250. Under the above circumstances, find out the following using Linear Programming: (a) What will be the minimum cost to transfer the required goods? (b) How many of WT88 and BH54 Radiant should hire? 3) Paul has to buy two types of Yogurts- Brand A and Brand B for children. He knows the following regarding the Vitamins the yogurts have: It is imperative that Paul ensures the children receive a minimum of 200 units of Vitamin A, 150 units of Vitamin B, and 150 units of Vitamin C. This requirement must be met even if it means purchasing more expensive Brand B yogurts, which cost $2.25 per unit compared to the $1.50 per unit of Brand A. Furthermore, there must be twice as many Brand B yogurts as Brand A yogurts, and currently, only 5 Brand A yogurts are available at the store. Using linear programming find the minimum cost of buying the yogurts to provide the required units of vitamins. How many of each type of yogurt Paul should buy to keep the cost at the minimum. 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? 2. Radiant requires cargo planes for the transportation of three distinct goods: A, B, and C. They have contacted VIP Transportation Company to arrange the rental. It has been communicated to Radiant that VIP has two types of cargo planes available, with 55 of each type. Furthermore, VIP has shared weightrelated information for the two types of planes, WT88 and BH54. To transport their cargo, Radiant needs to move 300 tons of Goods A, 300 tons of Goods B, and 350 tons of Goods C. In order to do so, they will require at least two WT88 and two BH54 planes. The cost for each WT88 plane with VIP is $1600 and each BH54 is $1250. Under the above circumstances, find out the following using Linear Programming: (a) What will be the minimum cost to transfer the required goods? (b) How many of WT88 and BH54 Radiant should hire? 3) Paul has to buy two types of Yogurts- Brand A and Brand B for children. He knows the following regarding the Vitamins the yogurts have: It is imperative that Paul ensures the children receive a minimum of 200 units of Vitamin A, 150 units of Vitamin B, and 150 units of Vitamin C. This requirement must be met even if it means purchasing more expensive Brand B yogurts, which cost $2.25 per unit compared to the $1.50 per unit of Brand A. Furthermore, there must be twice as many Brand B yogurts as Brand A yogurts, and currently, only 5 Brand A yogurts are available at the store. Using linear programming find the minimum cost of buying the yogurts to provide the required units of vitamins. How many of each type of yogurt Paul should buy to keep the cost at the minimum