Forum Stats

  • 3,827,151 Users
  • 2,260,746 Discussions


Solving LP problem to get optimum values

RCN_86 Member Posts: 25 Red Ribbon


I have a requirement where I need to solve below requirement by achieving optimum possible values.

As you see the above sheet, the ask is to satisfy the customer needs using warehouse capacities to the optimum way ( wherever possible, one customer should get orders from one or few warehouses. i.e, the more nulls we get in the above matrix more it is optimum).

Note: There is no limit to the no of warehouses or customers ( that is it could be M*N matrix)

I am trying to solve this using Oracle SQL/PLSQL. But I believe, python would be having libraries that supports in solving these kind of problems. Python or PLSQL is preferred.

Thanks in advance.