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]
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter11: Simulation Models
Section11.4: Marketing Models
Problem 30P: Seas Beginning sells clothing by mail order. An important question is when to strike a customer from...
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
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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