The following table presents cost, capacity, and demand data for a transportation problem in Stephanie Robbin’s furniture company. Set up the appropriate transportation table and find the optimal solution using Excel's solver. From/To 1 2 3 Supply A 30 10 5 20 B 10 10 10 30 C 20 10 25 75 Demand 40 60 55
The following table presents cost, capacity, and demand data for a transportation problem in Stephanie Robbin’s furniture company. Set up the appropriate transportation table and find the optimal solution using Excel's solver.
| From/To | 1 | 2 | 3 | Supply |
| A | 30 | 10 | 5 | 20 |
| B | 10 | 10 | 10 | 30 |
| C | 20 | 10 | 25 | 75 |
| Demand | 40 | 60 | 55 |
a. Is the problem balanced? [ Select ] ["Yes", "it is balanced", "No", "cannot determine"] , If not, where? [ Select ] ["Neither", "Supply", "Demand"] , and by how much? [ Select ] ["0", "40", "30", "25"]
b. What is the optimal cost? $ [ Select ] ["2,500", "1,100", "1,275", "1,300"]
c. Were you able to meet all demand requirement? [ Select ] ["no", "cannot determine based on the information given", "yes"] If not, which destination (s) was/were not met? [ Select ] ["none, all destinations were met based on supply and demand being equal", "destination 3 by 30 units", "destination 2 by 30 units", "destination 1 by 25 units and destination 3 by 5units", "destination 2 by 25 units and destination 3 by 5units"]
d. What if you are now requiring 15 units to be shipped from origin C to destination 3, what is the total optimal cost? [ Select ] ["no change, same as the original cost", "$1,400", "it reduced the cost by $25", "$1,200", "$1,375"]
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 13 images
