Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an optimization model in excel solver or python
Data analytics, modeling optimization for business
I’m Serhii, PhD in Economics and Associate Professor of Economic Cybernetics. I help businesses turn data into clear decisions: Excel and Power BI dashboards, forecasting and statistical analysis, cus...
About this Gig
Need to find the best plan under real constraints? I will build a clear optimization model that tells you exactly what to produce, ship, schedule or allocate to minimize cost or maximize profit.
What I can model:
- Production planning and product mix
- Transportation and delivery routes
- Staff scheduling and shift planning
- Resource and budget allocation across projects
- Inventory and purchasing decisions
- Assignment and selection problems
What you get:
- A working model in Excel Solver or Python (PuLP / OR-Tools)
- Clean input sheet so you can change data and re-run it yourself
- Optimal solution with charts and a short explanation
- Scenario and sensitivity analysis (Standard and Premium)
Why me: PhD in Economics, associate professor of economic cybernetics and 10+ years of applied modeling for real companies. I explain the logic in plain language, not just send a file.
Please message me before ordering with a short description of your problem and data, so I can confirm the right package.
Technology:
Excel
•
Jupyter Notebook
Analysis Type:
Quantitative Analysis
•
Prescriptive Analysis
Expertise:
Business Insights
•
Algorithms
•
Math
Programming language:
Python
•
VBA
My Portfolio
FAQ
What data do you need from me?
A short description of the decision you need to make, your goal (cost, profit, time) and the data in Excel or CSV: capacities, demand, costs, limits. If data is incomplete, I will help you structure it.
Excel Solver or Python: which should I choose?
Excel Solver is ideal for small and medium problems you want to edit yourself (up to about 200 variables). Python handles large models, integer constraints and repeated runs. I will recommend the best option after seeing your problem.
Can I re-run the model with new data later?
Yes. Every model has a separate input sheet or file and short instructions, so you can update demand, costs or capacities and get a new optimal plan without my help.
What if my problem has no feasible solution?
I will show which constraints conflict and suggest realistic adjustments, so you understand what limits your plan and what it would take to relax them.
