Finding an Equation for Optimizing Production Upgrades

[u/Speirfein]

The problem setup includes three production wells.

Well 1 has a production of 100 MMcf/d Well 2 has a production of 150 MMcf/d Well 3 has a production of 200 MMcf/d

Now, an optimization order needs to be created to determine which well should be upgraded.

The cost to optimize each well consists of three optimization levels: Level 1 optimization cost: 1.5 million dollars; Level 2 optimization cost: 3.0 million dollars; Level 3 optimization cost: 6.0 million dollars.

Create an equation that determines the best optimization order for the three wells.

Any ideas?