Explore BrainMass

Explore BrainMass

    Case example of non-integer optimization using Excel Solver

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 December 25, 2021, 12:01 am ad1c9bdddf


    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.