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.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

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]