Question

SE Appliances manufacturers refrigerators in Richmond, Charlotte, and Atlanta. Refrigerators then must be shipped to meet demand in Washington, New York, and Miami. The table below lists the shipping costs, supply, and demand information.

		To
		Washington	New York	Miami	Supply
From	Richmond	$10	$20	$30	1000
	Charlotte	$15	$25	$20	1500
	Atlanta	$20	$20	$10	2000
	Demand	1000	1800	1200

How many units should be shipped from Atlanta to Miami in order to minimize shipping costs?                        [ Select ] ["1200", "1000", "800", "500"]

Use Excel Quiz 7, Transportation 1

Answer 1

		To
		Washington	New York	Miami	Dummy	Supply	Rows Minimums by sequence of remaing
From	Richmond	$10	$20    1000	$30	0	1000	10	10	10
	Charlotte	$15     1000	$25	$20	0     500	1500/1000/0	15	5	10
	Atlanta	$20	$20    800	$10   1200	0	2000/800/0	20	0	0
	Demand	1000/0	1800/800/0	1200/0	500	4500
	Columns minimum by sequence of remaining	5	0	10	0
		5	0	10	_
		5	0	__	__
	From Atlanta to Miami		1200 units in order to minimize the cost