Sunco Oil has refineries in Los Angeles and Chicago.

The Los Angeles refinery can refine up to 2 million barrels of oil per year, and the Chicago refinery up to 3 million. After the oil is refined, it’s shipped to two distribution points, Houston and New York City.

Sunco estimates that each distribution point can sell up to 5 million barrels per year. Because of differences in shipping and refining costs, the profit earned (in dollars) per million barrels of oil shipped depends on where the oil was refined and on the point of distribution.

This information is listed in the file P04_65.xlsx.

Sunco is considering expanding the capacity of each refinery. Each million barrels of annual refining capacity that is added will cost $120,000 for the Los Angeles refinery and $150,000 for the Chicago refinery. Determine how Sunco can maximize its profit (including expansion costs) over a 10-year period.