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 weight- related information for the two types of planes, WT88 and BH54. WT88 Can carry BH54can carry Goods A 18 tons 15 tons Goods B 12 tons 20 tons Goods C 20 tons 15 tons 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?

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
icon
Related questions
Question
100%

Please use attached Excel format to solve if possible, I appreciate you

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 weight-
related information for the two types of planes, WT88 and BH54.
WT88 Can carry
BH54can carry
Goods A
18 tons
15 tons
Goods B
12 tons
20 tons
Goods C
20 tons
15 tons
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?
Transcribed Image Text: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 weight- related information for the two types of planes, WT88 and BH54. WT88 Can carry BH54can carry Goods A 18 tons 15 tons Goods B 12 tons 20 tons Goods C 20 tons 15 tons 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?
DATA
MODEL
CONSTRAINTS
LS
DECISION VARIABLES
OBJECTIVE FUNCTION
RELATION
RS
[Name]
Transcribed Image Text:DATA MODEL CONSTRAINTS LS DECISION VARIABLES OBJECTIVE FUNCTION RELATION RS [Name]
Expert Solution
steps

Step by step

Solved in 3 steps with 14 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning