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)