En cours

Knapsack - Optimize Save within Defined Payback Parameter

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)

Compétences : Excel, Mathématiques, Analyses statistiques, Statistiques, Visual Basic

Voir plus : intermediate excel, en save, 2 sum algorithm, sun identity manager find user form result, save google apps user accounts mysql, save facebook api user quize results information, asp save form result excel, google analytics user defined url parameter, save irc channel user list mysql, external user account creation sharepoint projects, save image table sql server 2005 using parameter, save text file user machine

Concernant l'employeur :
( 1 commentaire ) Chino Hills, United States

N° du projet : #8518052

Décerné à :

Kimon2164

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

100 $ USD en 2 jours
(5 Commentaires)
3.3

13 freelance ont fait une offre moyenne de 171 $ pour ce travail

dpune

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

100 $ USD en 3 jours
(73 Commentaires)
5.9
prameswara

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

30 $ USD en 1 jour
(127 Commentaires)
5.8
Calleus

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

155 $ USD en 3 jours
(30 Commentaires)
5.5
kannasanthosh

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

133 $ USD en 3 jours
(19 Commentaires)
5.4
kevivu

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

232 $ USD en 5 jours
(33 Commentaires)
5.0
simulnetcode1221

A proposal has not yet been provided

155 $ USD en 3 jours
(29 Commentaires)
4.3
jhabibi

I have worked on many problems in integer programming and optimization.

194 $ USD en 2 jours
(2 Commentaires)
3.8
super2lao

A proposal has not yet been provided

357 $ USD en 3 jours
(5 Commentaires)
4.2
elephentplayer

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.

250 $ USD en 3 jours
(16 Commentaires)
3.8
theenggprojects

Hi, I am a Mechatronics and Control Engineer, you can check my work on my blog [url removed, login to view] , I am expert in Programming languages and have designed many such projects. I have also posted m Plus

200 $ USD en 10 jours
(6 Commentaires)
2.9
OVIservices

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: *[url removed, login to view] Plus

250 $ USD en 20 jours
(2 Commentaires)
1.8
gsanggara

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

90 $ USD en 3 jours
(2 Commentaires)
1.0
wenguo214

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.

88 $ USD en 3 jours
(0 Commentaires)
0.0
yassinewafaa

Aucune proposition n'a encore été fournie.

155 $ USD en 2 jours
(0 Commentaires)
0.0
mrdait

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

155 $ USD en 3 jours
(0 Commentaires)
0.0
FREDMANN

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

222 $ USD en 3 jours
(1 Commentaire)
0.0