Case example of non-integer optimization using Excel Solver

FairDev Corp. is considering taking part in one or more development projects A, B, and C. Each requires an investment over the next few years and then would be sold upon completion. Which projects should FairDev take part in and at what fraction of participation, so as to end year 6 with as much cash as possible? Build a linear programming spreadsheet model and solve it using Solver.

© SolutionLibrary Inc. January 28, 2020, 8:10 am 9836dcf9d7