_{***Please answer c. and d.}

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. a. Is the problem balanced? , If not, where? , and by how much? b. What is the optimal cost? $ c. Were you able to meet all demand requirement? If not, which destination (s) was/were not met