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 $123$ Supply

A $3010520$

B $10101030$

C $20102575$

Demand $406055$

a$.$ Is the problem balanced?

Yes

$,$ If not, where?

Neither

$,$ and by how much?

$0$

b$.$ What is the optimal cost? $

$[$ Select $]$

c$.$ Were you able to meet all demand requirement?

$[$ Select $]$

If not, which destination $($s$)$ was$/$were not met?

$[$ Select $]$

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 $]$