Question

1. Radiant wants to hire Cargo planes for transporting their goods. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes. In addition, they provided the following cost related information about the two types Cargo planes- WT88 and BH54:

	Personnel Cost	Fuel Cost	Maintenance Cost
WT88	2000	1000	2000
BH54	2500	1500	1000

**** SHOW STEPS DONE THROUGH EXCEL PLEASE*****

                     Radiant has $200,000 to spend in personnel cost, $160,00 in fuel cost, and $80,000 in    maintenance cost. Moreover, they have to hire at least one of each type of planes. If WT88 can carry 45 tons of goods and BH54 can carry 65 tons of goods then find out the following:

1. What is the maximum amount Radiant can carry given their budget constraint?
2. To carry the maximum amount how many of WT88 and BH54 radiant should hire.

****SHOW STEPS THROUGH EXCEL PLEASE FOR A and B***

Answer 1

Left no. of WT88 planes be W and No. of BH54 be B.

Total load carried = 45*W + 65*B

We have to maximize this total load

Subject to constraints

2000W + 2500B <= 200,000............Amount to spend in personnel cost

1000W + 1500B <= 16000...............Amount to spend in fuel cost

2000W + 1000B <= 80,000..............Amount to spend in maintenance cost

W, B >= 1..........................................At least 1 plane of each type is required

W, B = integers..................................No. of planes cannot be fractions

We solve the given Linear programming problem in Excel as shown below. We first tabulate the data as shown below:

The above tables in the form of formulas are shown below for better understanding and reference:

We solve the above using Excel Solver as shown below:

The above solution along with Excel Solver extract is shown below for better understanding and reference:

As seen from above,

The maximum amount Radiant can carry given their budget constraint = 715 kg

No. of WT88 to be hired = 13 nos.

No. of BH54 to be hired = 2 nos.

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!