There are production facilities in Battle Creek, Cherry Creek, and Dee Creek with annual capacities of 500 units, 400 units, and 600 units, respectively. The annual demands at warehouses in Worchester, Dorchester, and Rochester are 300 units, 700 units, and 400 units, respectively. The table below gives the unit transportation costs between the production facilities and the warehouses.
|
|
Worchester
|
Dorchester
|
Rochester
|
|
Battle Creek
|
$20/unit
|
$30/unit
|
$13/unit
|
|
Cherry Creek
|
$10/unit
|
$5/unit
|
$17/unit
|
|
Dee Creek
|
$15/unit
|
$12/unit
|
$45/unit
|
How much of the demand at each of the warehouses must be met by each of the production facilities?
By using Excel Solver (Excel Solver is an Add-in that does not come standard with Excel. Installing it is quick and easy with the right instructions. (I'll provide two PDFs which will help the tutor (once the task is assigned ) to understand the question and they are MUST to review )).
Remember that you must show all work for this assignment and interpret your result.