Transportation Problem (supply chain), business and finance homework help

/in /by

Transportation Problem (supply chain), business and finance homework help

Q: 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.