Need help in an optimization problem for a manufacturing plant. I have a matrix of the ordered quantities by order and by sku and the stock quantities vector.

I want a model that allow us to assign the current stock to the orders and return the production plan in a way that minimizes the average amount of days that a unit is in stock. I can produce $100,000$ units per day of any sku. Some orders share the skus.

The result I want is an ordered list of the production per order per sku.

I want a model for implementation in python so I can run it with different inputs. I already managed to get a python model that solves the first part of my problem. What I detailed is the second part. Basically I have a stock, the first part is an optimization model that assigns the stock in order to maximize the number of completed orders. What I want is that after this, the remaining stock is assigned to the orders according to my optimization objective.Basically I need a script that outputs a list in the correct order of what to produce with the objective to minimize the Average days a unit would be in stock.

I think that for this model you must assume that the remaining stock $($after first optimization model$)$ is received the first day. Then, each production day will output $100,000$ units $($pounds$)$ of any sku.

Actually What I want is the stock to be assigned and the production plan listed with the objective to minimize the average amount of days a unit will be in stock.

give me python code for the problem. For this problem you will take pedidos matrix csv file from your side and stock csv file also. I will adjust these csv file with my actual file. Please add the png of these csv file data,