Question $8.$

ABC Oil produces oil at two wells. Well $1$ can produce as many as $150,000$ barrels per day, and well $2$ can produce as many as $200,000$ barrels per day. It is possible to ship oil directly from the wells to $AB{C}^{\text{'}}\text{'}$s customers in Konya and Ankara. Alternatively, ABC could transport oil to the ports of Izmir and Iskenderun and then ship it by tanker to Ankara or Konya. Konya requires $160,000$ barrels per day, and Ankara requires $140,000$ barrels per day. The costs of shipping $1,000$ barrels between two points are shown in Table below. Formulate a transshipment model that could be used to minimize the transport costs in meeting the oil demands of Konya and Ankara. $(-$ means shipment not available$)$ Solve the model on Excel.

$\backslash$table$[[$From$,$To $($$$)],[$Well $1,$Well $2,$Izmir,Iskenderun,Ankara,Konya$],[$Well $1,0,-,10,13,25,28],[$Well $2,-,0,15,12,26,25],[$Izmir$,-,-,0,6,16,17],[$skenderun$,-,-,6,0,14,16],[$Ankara$,-,-,-,-,0,15],[$Konya$,-,-,-,-,15,0]]$