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. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54: WT88 Can carry BH54can car Goods A 20 tons 25 tons Goods B 10 tons 20 tons Goods C 20 tons 15 tons Radiant has to transport 100 tons of Goods A, 100 tons of Goods B, and 100 tons of Goods C. VIP charges $2000 for each WT88 and $3000 for BH54. Under the above circumstances, find out the following: (a) What will be the minimum cost to transfer the required goods? (b) How many of WT88 and BH54 Radiant should hire? https://d2vlcm61l7u1fs.cloudfront.net/media%2Fc8c%2Fc8c91f6b-0e62-4abb-b276-a85b786c2dc5%2Fimage

(a) Minimum cost to transfer the required goods is determined by LP model as follows

https://d2vlcm61l7u1fs.cloudfront.net/media%2F964%2F964a91f3-4a47-4e03-9df9-7c2b044e6557%2FphpD4MbCy.png

Formula:

D2 =SUMPRODUCT(B2:C2,$B$8:$C$8) copy to D2:D4, D6

Minimum cost = $ 16000

(b)

Number of WT88 to hire = 2

Number of BH54 to hire = 4

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp