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 10 10 30 ic 20 10 25 75 Demand 40 60 55 B 10 a. Is the problem balanced? No If not, where? Supply and by how much? 30 5. What is the optimal cost?1.300 c. Were you able to meet all demand requirement? destination 1 by 25 units and if not, which destination (s) was/were not met? d. What if you are now requiring 15 units to be shipped from origin to destination 3 what is the total optimal cost? 51.375