Slover kind of tool in sap

Dear all

I need to develop the functionality of solver tool (a tool available in MS-excel for optimization technique) in sap. This needs to be used for stock optimization.

The requirement is to allocate the available stock (SOH) to all the customers ordered in that month.

For example, there are 3 customers A, B and C and each of them have given an order of 70, 160 and 265 respectively but the stock on hand is only 400 at plant. Also, each customer will have some stock left i.e. A has 30 units stock on hand, B has 20 and C has 50 units respectively. Hence for customer A, the stock allocated is 54 out of the 70 requested and B has 131 out of 160 and C has 215 out of 265. This is arrived using solver tool in MS excel.

Please help me with the logic.

Regards,

Nagesh N