Radiant wants to hire planes to transport three types of goods- A, B, and C. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes, and they have only 80 of each type of plane. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54: Goods AGoods BGoods CWT88 Can carry20 tons10 tons20 tonsBH54can carry25 tons20 tons15 tons Radiant has to transport 500 tons of Goods A, 500 tons of Goods B, and 500 tons of Goods C. VIP charges $2800 for each WT88 and $1200 for BH54. Under the above circumstances, find out the following using Linear Programming: What will be the minimum cost to transfer the required goods?How many of WT88 and BH54 Radiant should hire?Can you use MS Excel solver to do this?

Given data is Cost of WT88 = $2800 Cost of BH54 = $1200 Transportation of good A = 500 tons…

Answered: Radiant wants to hire planes to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Radiant wants to hire planes to transport three types of goods- A, B, and C. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes, and they have only 80 of each type of plane. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54:

	Goods A	Goods B	Goods C
WT88 Can carry	20 tons	10 tons	20 tons
BH54can carry	25 tons	20 tons	15 tons

Radiant has to transport 500 tons of Goods A, 500 tons of Goods B, and 500 tons of Goods C. VIP charges $2800 for each WT88 and $1200 for BH54. Under the above circumstances, find out the following using Linear Programming: