Problem #$4$ Transportation Models

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

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?