Explore BrainMass
Share

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 March 22, 2019, 3:45 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