Description

This downloadable virtual product contains a case study applying Excel Solver and integer programming to oil well pump capacity planning. That is, this product is a simple capacity planning Excel Solver template.

In detail, this product includes:

• PDF file with a presentation of the case study.
• Excel sheet with Excel Solver model implementation of the integer program.
• Instructions for how to activate the Solver add-in in Excel.

Who will benefit from this integer optimization Excel solver model?

This downloadable product suits supply chain analysts, operations researchers, transport planners, and students that want to:

• Get a hands-on example on how integer programming can be applied
• Obtain an integer programming optimization template in Excel
• Learn Excel Solver

Brief case study description

A new oil field is prepared for production. Oil pumps are to be installed for crude oil production. There are various types of oil pumps available on the market. They differ in price, surface area requirement, and production capacity.

The problem: Minimize oil pump purchase spending but ensure the required production target. Also, oil field surface area available for pump installation is another constraint that must be considered.

Below is an exemplary satellite image of an oil well field in Texas, USA.

Relevant KPIs traced and outputted by this model

The model contained by this product tracks relevant KPIs.

The following KPIs supported by the model:

• Purchase expenses for oil pumps
• Production output in barrels of oil
• Surface area occupied for oil pump installations

Learn more about integer programming

You can find several other contributions on SCDA related to integer programming, operations research, and capacity planning. Integer optimization problems such as the capacity planning problem solved in this application, can also be implemented and solved with other languages and tools. On SCDA you can find exemplary applications of operations research in e.g. Python, R, Java, Julia, and C++.

Here are some exemplary articles for you to read:

• Link: Integer programming for manufacturing implemented with CPLEX docplex
• Link: Linear integer programming with Google ortools in Python
• Link: Simple linear programming with integer variables in R using lpsolve
• Link: Loading Excel Solver