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.
© BrainMass Inc. brainmass.com June 4, 2020, 5:30 am ad1c9bdddfhttps://brainmass.com/business/business-math/case-example-non-integer-optimization-excel-solver-637601
Solution Summary
Simple and understandable example of using Solver in Excel for optimization with the the more realistic and less often seen non-integer case.
$2.19