Week 10 hw

HW10_answer_sheet.xlsx

P1

1. transportation problem
		From	To (cost)
			1	2	3
		A	$6	$5	$5
		B	11	8	9
		C	4	10	7
	DV	From	To					Supply	Note: Blue cells are your decision variables
			1	2	3	Constraint
		A	0.00	100.00	50.00	150	<=	150
		B	0.00	0.00	0.00	0	<=	85
		C	70.00	0.00	30.00	100	<=	125
		Constraint	70.00	100.00	80.00
			=	=	=
		Demand	70	100	80
	Objective	Minimize Cost	$1,240.00

2. transportation problem
		From	To (cost)
			1	2	3
		A	$8	$14	$8
		B	6	17	7
		C	9	24	10
	DV	From	To					Supply	Note: Blue cells are your decision variables
			1	2	3	Constraint
		A	0.00	120.00	0.00	120	=	120
		B	0.00	20.00	60.00	80	=	80
		C	110.00	0.00	40.00	150	=	150
		Constraint	110.00	140.00	100.00
			=	=	=
		Demand	110	140	100
	Objective	Minimize Cost	3830

3. World Foods, Inc.
		From	To (cost)
			4. Norfolk	5. New York	6. Savannah
		1. Hamburg	$320	$280	$555
		2. Marseilles	410	470	365
		3. Liverpool	550	355	525
		Warehouse	Distribution Center
			7. Dallas	8. St. Louis	9. Chicago
		4. Norfolk	$80	$78	$85
		5. New York	100	120	95
		6. Savannah	65	75	90
	DV	From	To (cost)					Supply from sources
			4. Norfolk	5. New York	6. Savannah	Constraints
		1. Hamburg	0.00	75.00	0.00	75.00	=	75
		2. Marseilles	0.00	0.00	85.00	85.00	=	85
		3. Liverpool	0.00	40.00	0.00	40.00	=	40
		Warehouse	Distribution Center
			7. Dallas	8. St. Louis	9. Chicago	Constraints		Net Flow (distribution center)
		4. Norfolk	0.00	0.00	0.00	0.00	=	0.00
		5. New York	50.00	0.00	65.00	0.00	=	0.00
		6. Savannah	35.00	50.00	0.00	0.00	=	0.00
		Constraints	85	50	65
			<=	<=	<=
		Demand	85	70	65
								220	200
	Objective	Minimize Cost	$83,425