The Amorco Oil Company controls two oil fields.

Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per day. At field 1, it costs $37.50 to extract and refine a barrel of oil; at field 2 the cost is $41.20.

Amorco sells oil to two countries: United Kingdom and Japan. The shipping costs per barrel are shown in the file P05_48.xlsx. Each day, the United Kingdom is willing to buy up to 40 million barrels at $65.80 per barrel, and Japan is willing to buy up to 30 million barrels at $68.40 per barrel. Determine how to maximize Amorco’s profit.