House Beer has three breweries inPortland, New York and Scranton. The cases of beer are sent towarehouses in Boston and Atlantic City and then shipped to thedistribution centers in Pittsburgh, Cincinnati, and Atlanta. Theshipping cost per case from each brewery to each warehouse and thesupply and demand are given below. (15 points)
Warehouse
Brewery | Boston | Atlantic City |
Portland | 0.38 | 1.16 |
New York | 0.50 | 0.40 |
Scranton | 1.20 | 0.60 |
Distribution Center
Warehouse | Pittsburgh | Cincinnati | Atlanta |
Boston | 0.70 | 1.20 | 1.50 |
Atlantic City | 0.50 | 0.90 | 1.20 |
Capacity of Each Brewing | | Demand at Each Distribution Center |
Portland | 1600 | | Pittsburgh | 1800 |
New York | 2000 | | Cincinnati | 2000 |
Scranton | 2500 | | Atlanta | 2300 |
| | | | |
a. Draw the networkdiagram for this problem.
b. Using Excel,solve the above problem and give the optimal solution
