Home /
Expert Answers /
Operations Management /
use-excel-1-radiant-requires-cargo-planes-for-the-transportation-of-their-goods-and-has-approached-pa757
(Solved): use excel 1. Radiant requires cargo planes for the transportation of their goods and has approached ...
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 , 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 to spend in personnel cost, in fuel cost, and 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 , 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?
Expert Answer
To determine the optimal operations for Radiant Airlines based on their budget constraint and cargo plane options, we can use linear programming. Let's define the decision variables and constraints.Decision Variables: Let's denote the number of WT88 cargo planes to hire as 'x' and the number of BH54 cargo planes to hire as 'y'.