Consider the capital budgeting problem described in the file "Supporting material - I" posted on D2L. A spreadsheet implementation that solves an instance of the problem, consisting of 20 projects and 6 years, is also provided in "Supporting material - II".
Solve the same problem instance using lp_solve mathematical programming solver library from within Python. Lp_solve should compute an optimal solution value of $9,293. Interestingly this is a better solution than what the Excel solver produces as optimal ($9,269).
Upload your Python code and the optimal solution (that is which projects are selected, which are not) to D2L in one file as in the previous assignments.
Hint:
If you add the line below, after the lp object is created, then lpsolve will print detailed information about its progress and the results.
lpsolve('set_verbose', lp, DETAILED)
Hi, thank u for considering me.
I was a research assistant at NUS before, dedicated to R&D work. My research interest is machine learning. So I am quite familiar to decision theory and method & tool used in this field like Linear Programming, python. lp-solve lib and driven for python have already been installed in my machine.
I have done almost the same project before and can finish ur proj within hours.
I place my bid for the lowest price because I hope to have long-term cooperation with u and let's start from this project.
if u have any questions, feel free to leave messages.
I have already solved the problem & am getting the expected solution i.e. $9293. I have checked my solution by editing your excel solution & it works perfectly & gives me the better answer i.e. $9293.
Accept my bid & I'll share the python code with you & the generated solution. I have neatly commented the code with the installation instructions.
I had replied to the previous job post - https://www.freelancer.in/jobs/Python/capital-budgeting-prob/