This project is similar to knapsack ([url removed, login to view]). I have a list of 20 - 80 projects. For each project, I calculate the implementation cost, the annual Savings the project will produce when implemented, and the Simple Payback (Cost / Save) for each project.
The objective is to include or exclude projects. The algorithm must maximize the Sum of the $ Saved for all projects included while monitoring as a constraint a Payback value that does not exceed a user defined value i.e. 2.0, 2.5, 3.0 ... Projects with a Save of $0.00 would be eliminated. Payback will always be >0.
Because this is an intermediate step in our process the results are contained in Excel. The results of the routine must be created or moved to excel in the form of a TRUE or FALSE value for each project (where TRUE = include project in result and FALSE exclude project)
13 freelance font une offre moyenne de $171 pour ce travail
Hello, I am expert in Excel, Visual Basic,... I have a lot of experiences in many fields. I can help you well. Please contact me. Best regards.
thank you for your posting. your task is very happy for me. bz i have solved Container Loading Problem, CLP is similar your task(KP) if you hire me, i will complete project ASAP. best regards.
Hello Sir I'm really glad to read this offer,in fact, i already do a semilar project in my study,I'm an enginieer in statistics and i can do it perfectly :) Best regards