I will build an excel solver optimization model
Data Analyst
About this Gig
Do you have a business decision that needs to be optimized using mathematical modelling?
I can help formulate and develop optimization models for structured business problems using linear programming and mixed-integer linear programming (MILP).
Potential applications include:
- Resource allocation.
- Production planning.
- Scheduling.
- Capacity planning.
- Cost minimization.
- Assignment and allocation problems.
My process includes reviewing the problem, defining decision variables, formulating the objective function and constraints, and developing a model based on the available data.
Please contact me before ordering. I need to review the problem, data, objective, and constraints before confirming the scope and delivery time.
Frameworks:
Scikit-learn
•
DeepPy
•
PyTorch
•
Panda
Data type:
Code
Programming language:
Python
•
SQL
Tools:
Jupyter Notebook
•
Excel
•
Colab
APIs:
Google Cloud Vision API
•
OpenAI
My Portfolio
FAQ
What is mathematical optimization?
Mathematical optimization uses mathematical models to identify the best possible solution to a problem while satisfying defined constraints. Examples include minimizing costs, allocating resources, and planning production.
What types of optimization problems can you help with?
I can help with suitable linear programming and mixed-integer linear programming (MILP) problems, including resource allocation, scheduling, production planning, and cost minimization.
What information do you need to build an optimization model?
I need a clear description of the problem, the objective you want to maximize or minimize, the decision variables, the constraints, and any relevant input data.
Can you work with an existing optimization model?
Yes. I can review an existing model, help identify issues, and make agreed modifications depending on its structure and complexity.
Will you explain how the optimization model works?
Yes. I can provide an explanation of the objective function, decision variables, constraints, and solution results, with documentation appropriate to the selected package.
Can you guarantee that the model will find the best possible solution?
I will develop and test the model based on the supplied data, assumptions, and constraints. The quality and feasibility of the solution depend on the accuracy and completeness of the information provided and the capabilities of the solver.
Should I contact you before placing an order?
Yes. Optimization projects can vary significantly in complexity. Please contact me with your problem description and available data so I can assess the scope, feasibility, and delivery time before accepting the project.

