s with the new option.

a$.$ Formulate and solve a spreadsheet model to find an optimal plan for shipping $360$

million barrels of crude oil per year from the oil fields to the refineries, including the

new one in St$.$ Louis, where the amount of crude oil each refinery will receive $($up to

its capacity$)$ is based on minimizing the total annual cost for these shipments. $($Hint:

You can save some time in this and subsequent parts by using the live spreadsheets

for the Texago case study in this chapter$$s Excel files as a starting point.$)$ Compare

the resulting total annual cost for these shipments with the results obtained in Figure

$17\mathrm{.}13$ under the original assumption of a smaller refinery in St$.$ Louis