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)
Hello. I got a better solution for total payback <= 2: NOT selected projects: 18, 19, 23, 27, 32, 34, 36, 37, 41, 44, 52 Total saved = 105409.4 Total cost=210480.7 As I wrote in the previous post (I believ Plus
13 freelance font une offre moyenne de $171 pour ce travail
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Plus
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir via VBA macro :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You SIncerel Plus
Hi, I have strong background in Research, Reporting, Statistics, quantitative and qualitative analysis and experience in SPSS. Let me help you. Daily writes scientific papers, and I'm used to technical language. I am r Plus
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics pro Plus
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus
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.
Hi, I am a Mechatronics and Control Engineer, you can check my work on my blog [login to view URL] , I am expert in Programming languages and have designed many such projects. I have also posted m Plus
Hello There, Greetings for the day & hope you are doing fantastic. I have gone through your project requirment and very much confident in getting it done. Please have a look at our works: *[login to view URL] Plus
Hello, in interesting into your project which match with my experiences. I placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliv Plus
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.
I am an engineer in operational research and decision support I have a good command of knapsack problems, ordonnacement and planning. with regard to your project I can model the problem of rigorous way and give a solu Plus
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