Answered: What will be the minimum cost to…

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 planes to transport three types of goods- A, B, and C. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes, and they have only 80 of each type of plane. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54:

	Goods A	Goods B	Goods C
WT88 Can carry	20 tons	10 tons	20 tons
BH54can carry	25 tons	20 tons	15 tons

Radiant has to transport 500 tons of Goods A, 500 tons of Goods B, and 500 tons of Goods C. VIP charges $2800 for each WT88 and $1200 for BH54. Under the above circumstances, find out the following using Linear Programming:

What will be the minimum cost to transfer the required goods?
How many of WT88 and BH54 Radiant should hire?

Can you check my answer is correct?

Data
		Goods A	Goods B	Goods C	VIP Charge
	WT88 can carry	20	10	20	$ 2,800.00
	BH54 can carry	25	20	15	$ 1,200.00
	Has to transport	500	500	500








Model

Decision Variables
			# of
		WT88	1	x
		BH54	1	y



Objective Function
			COST
		min cost	4000


Constraints
LS	Relation	RS	[Name]
1	GTE	1	[NN X]
1	GTE	1	[NN Y]
45	LTE	500	[GOODS A]
30	LTE	500	[GOODS B]
35	LTE	500	[GOODS B]
1	LTE	80	[WT88]
1	LTE	80	[BH54]