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...
icon
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L