Question: Dana Johnson Corp. is considering adding a fourth plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both East St . Louis (

Dana Johnson Corp. is considering adding a fourth plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both East St. Louis (option 1) and St. Louis (option 2) are being considered.
From Existing PlantsToDecaturMinneapolisCarbondaleDemandBlue Earth$20$17$21250Ciro$25$27$20200Des Moines$22$25$22350Capacity300200150
From Proposed PlantsToEast St. Louis (option 1)St. Louis (option 2)Blue Earth$29$27Ciro$30$28Des Moines$30$31Capacity150150
LocationProduction Costs ($)Decatur$50Minneapolis60Carbondale70East St. Louis40St. Louis50
Evaluating only the transportation costs:
a. What is the cost considering East St. Louis = $ [ Select ]["17,400","20,500","17,250","18,500"]
b. What is the cost considering St. Louis? = $ [ Select ]["17,400","17,250","18,345","16,500"]
c. Which location would you choose? [ Select ]["Neither", "Both", "East St. Louis", "St. Louis"]
Now use the transportation data and the unit production costs:
d. What is the cost considering East St. Louis? = $ [ Select ]["63,450","60,900","59,600","62,250"]
e. What is the cost considering St. Louis? = $ [ Select ]["63,250","62,250","60,900","66,900"]
f. Which location would you choose? [ Select ]["Neither","St. Louis", "East St. Louis", "Both"]
From/ToHosp 1Hosp 2Hosp 3Hosp 4SupplyBank 1$8$9$11$1650Bank 2$12$7$5$880Bank 3$14$10$6$7120Demand90704050
a. Is the problem balanced? [ Select ]["", "Yes", "cannot determine", "No"],
b. How many pints of blood are you short? [ Select ]["20","30","0","13"]
c. What is the optimal solution? $ [ Select ]["2,000","2,020","2,500","1,300"]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!