Explore BrainMass

Explore BrainMass

    Case example of non-integer optimization using Excel Solver

    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 June 4, 2020, 5:30 am ad1c9bdddf
    https://brainmass.com/business/business-math/case-example-non-integer-optimization-excel-solver-637601

    Attachments

    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

    ADVERTISEMENT