9-7 Using Excel QM:The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses.

The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.

TO FROM	ALBUQUERQUE	BOSTON	CLEVELAND	CAPACITY
DES MOINES	$5	$4	$3	300
EVANSVILLE	$8	$4	$3	150
FORT LAUDERDALE	$9	$7	$5	250
REQUIREMENTS	200	200	300