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 Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming: What is the maximum amount Radiant can carry given their budget constraint? Can you solve using solver ? (I did this but I got a wrong answer) Data Personnel Cost Fuel Cost Maintenance Cost Tons WT88 2000 1000 2000 55 BH54 2500 1500 1000 85 Model Decision Variables # of WT88 0 x BH54 0 y Objective Function Tons MAX amount 0 Constraints LS Relation RS [Name] 0 GTE 1 [NN X] 0 GTE 1 [NN Y] 0 LTE 200000 [PERSONNEL COST] 0 LTE 160000 [FUEL COST] 0 LTE 80000 [MAINTEN COST] 0 GTE 2 [AT LEAST WT88] 0 GTE 2 [AT LEAST BH54]
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 Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming: What is the maximum amount Radiant can carry given their budget constraint? Can you solve using solver ? (I did this but I got a wrong answer) Data Personnel Cost Fuel Cost Maintenance Cost Tons WT88 2000 1000 2000 55 BH54 2500 1500 1000 85 Model Decision Variables # of WT88 0 x BH54 0 y Objective Function Tons MAX amount 0 Constraints LS Relation RS [Name] 0 GTE 1 [NN X] 0 GTE 1 [NN Y] 0 LTE 200000 [PERSONNEL COST] 0 LTE 160000 [FUEL COST] 0 LTE 80000 [MAINTEN COST] 0 GTE 2 [AT LEAST WT88] 0 GTE 2 [AT LEAST BH54]
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.4SA
Related questions
Question
- 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 |
Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming:
- What is the maximum amount Radiant can carry given their budget constraint?
Can you solve using solver ? (I did this but I got a wrong answer)
Data | |||||||||||
Personnel Cost | Fuel Cost | Maintenance Cost | Tons | ||||||||
WT88 | 2000 | 1000 | 2000 | 55 | |||||||
BH54 | 2500 | 1500 | 1000 | 85 | |||||||
Model | |||||||||||
Decision Variables | |||||||||||
# of | |||||||||||
WT88 | 0 | x | |||||||||
BH54 | 0 | y | |||||||||
Objective Function | |||||||||||
Tons | |||||||||||
MAX amount | 0 | ||||||||||
Constraints | |||||||||||
LS | Relation | RS | [Name] | ||||||||
0 | GTE | 1 | [NN X] | ||||||||
0 | GTE | 1 | [NN Y] | ||||||||
0 | LTE | 200000 | [PERSONNEL COST] | ||||||||
0 | LTE | 160000 | [FUEL COST] | ||||||||
0 | LTE | 80000 | [MAINTEN COST] | ||||||||
0 | GTE | 2 | [AT LEAST WT88] | ||||||||
0 | GTE | 2 | [AT LEAST BH54] | ||||||||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
Recommended textbooks for you
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
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