Formulate this transportation problem and find the optimum solution using Solver.

Below table, the total demand exceeds the total supply. Suppose the there is no penalty costs per unit of unsatisfied demand for the first two destinations. However, the demand of the third destination should be completely satisfied. Formulate this transportation problem and find the optimum solution using Solver.

Table:

$5 $1 $7 10
$6 $4 $6 80
$3 $2 $5 15

75 20 50