The following table presents cost, capacity, and demand data for a transportation problem in Stephanie Robbins 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"]