House Beer has three breweries in Portland, New York and Scranton. The cases of beer are...

60.1K

Verified Solution

Question

General Management

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

Answer & Explanation Solved by verified expert

4.0 Ratings (526 Votes)

The network diagram is presented below Table on the costs of distribution from one center to anotherFrom the table above The table below has been constructedThe Network table can be See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Brewery	Boston	Atlantic City
Portland	0.38	1.16
New York	0.50	0.40
Scranton	1.20	0.60

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