Question: Please answer with Excel 2. Radiant requires cargo planes for the transportation of three distinct goods: A, B, and C. They have contacted VIP Transportation

Please answer with Excel
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
