Problem #$4$ Transportation Models

Please answer the transportation model data and Excel Output to answer questions $24$ to $27.$

$\backslash$table$[[,,$Unit Shipping Cost,Supply,,$],[$Sources$,$Plant A$,$Plant B$,$Plant C$,$Plant D$,,],[w,5\mathrm{.}00,10\mathrm{.}00,10\mathrm{.}00,5\mathrm{.}00,10\mathrm{.}00,,],[x,10\mathrm{.}00,5\mathrm{.}00,5\mathrm{.}00,0\mathrm{.}00,20\mathrm{.}00,,],[Y,10\mathrm{.}00,5\mathrm{.}00,20\mathrm{.}00,5\mathrm{.}00,30\mathrm{.}00,,],[z,5\mathrm{.}00,20\mathrm{.}00,10\mathrm{.}00,5\mathrm{.}00,20\mathrm{.}00,,],[$Demand$,10\mathrm{.}00,30\mathrm{.}00,10\mathrm{.}00,20\mathrm{.}00,,,],[,,$xeel Solv,er Outp,,,,$],[,,$Destin,ations,,,,$],[$Sources$,$Plant A$,$Plant B$,$Plant C$,$Plant D$,$Sum,,Supply$],[w,0\mathrm{.}00,0\mathrm{.}00,10\mathrm{.}00,0\mathrm{.}00,10\mathrm{.}00,,10],[x,0\mathrm{.}00,\backslash$table$[[20\mathrm{.}00]],0\mathrm{.}00,0\mathrm{.}00,20\mathrm{.}00,,20],[Y,10\mathrm{.}00,10\mathrm{.}00,0\mathrm{.}00,0\mathrm{.}00,20\mathrm{.}00,,30],[Z,0\mathrm{.}00,0\mathrm{.}00,0\mathrm{.}00,20\mathrm{.}00,20\mathrm{.}00,,20],[$Sum$,10\mathrm{.}00,30\mathrm{.}00,10\mathrm{.}00,\backslash$table$[[20\mathrm{.}00]],,,],[,=,=,=,=,$Ttl Cost,Sxxxx$,],[$Demand$,10,30,10,20,,,]]$

Question # $24$: $-$ Based on the Excel Solver, the minimum total transportation cost is$?$

Question # $25$: $-$ Based on the Excel Solver, what source will have an excess supply?

Question # $26$: $-$ Based on the Excel Solver, the amount shipped from $Z$ to Plant $D$ will be:

Question #$27$: $-$ Based on the Excel Solver output, the dummy destination will receive what amount?