9-7 Using Excel QM:The management of the Executive Furniture Corporation decided to expand the production capacity at
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Expert Answer:
Posted Date:
