How to implement this idea into objective fucntion with Gurobi PY
I am working on an optimization project here and my objective is to come out with the optimal amount of each item to buy at certain vendors that can minimize the cost while meeting the demand(already figured out the demand constraints). Here is a little background for the case below, there are 2 Vendor, 2 distribution centers(DC), 2 items(UPC), 2 Microfulfillment centers (MFC) and the chart also contain the price, weight, and cube of each items.
The freight cost of each vendor(v1, v2) is also below where v1 charges a freight fee based on the total weight and cube of all ordered items from one DC to one MFC; v2 charges a freight fee based on the total order amount(in $) from one DC to one MFC.
Everything else for this model is done except for this complicated freight cost in the objective function. I am stuck on this part and would really appreciate some help on how to implement this freight fee idea. I do have an idea which is to first calculate the total the weight and cube of all ordered items from one DC to one MFC(using gp.quicksum()), then use multiple if-else statements to compare with the cube and weight range and use the corresponding freight fee. The same idea applies to v2 where it is based on the total order amount in dollars.
Would really want some advice on whether my idea will work OR if anyone can share an easier way to implement this idea would be greatly appreciated!
After a decent research, I found that the tiered order amount can be implemented easily by using "Model.addGenConstrPWL()" from gurobi which is a general constraints for Piecewise function.
Below is a link for anyone that wants to take a look!
https://www.gurobi.com/documentation/9.1/refman/py_model_agc_pwl.html
Also, another useful link is below if your piecewise function input is the sum of other variables:
- Implementation of Okapi BM25 in python
- How do I parse a string to a float or int?
- What is the best design pattern when creating an interface for functions that can return a variety of responses?
- How can I sandbox Python in pure Python?
- Currency formatting in Python
- How boxen plot is different from box plot?
- Sorting names by their high scores
- How do I serve both HTML and JSON content with Flask?
- Changing lowercase characters to uppercase and vice-versa in Python
- WARNING Not Found: /favicon.ico in Django
- SQL Alchemy - How to delete a model instance?
- What does the python operator =- do?
- How can I unit test the jinja2 template logic?
- python pandas dataframe select rows with ternary operator
- Selenium using Python - Geckodriver executable needs to be in PATH
- Gunicorn do not reload worker
- How to add timestamp to each request in uvicorn logs?
- How to extract video titles with the Youtube API(Python)
- Cartesian product of dict of lists in Python
- Round to 5 (or other number) in Python
- Why do I get a "ModuleNotFoundError" in VS Code despite the fact that I already installed the module?
- Python: Suppressing errors from going to commandline?
- Problems using MySQL with AWS Lambda in Python
- Is there any benefit of using a dictionary comprehension if an equivalent dict(zip(a, b)) is possible?
- SQLAlchemy - Get query results in same order as IN clause
- Python3 __pycache__ generating even if PYTHONDONTWRITEBYTECODE=1
- Matplotlib.animation: how to remove white margin
- bash script maybe syntax error not sure trying a until loop
- How to typehint dataclass field in function signature
- pdfium library is not working when compiling my code in python