Explore BrainMass
Share

Create a optimal model and solve in excel

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

Parts A & B.

-create model
-solve in excel doc
- state solution point & OFV in sentence form

(Define variables, objective function, constraints with units and labels.)

SHOW ALL WORK! - I need to understand how you got the solutions you did.

© BrainMass Inc. brainmass.com March 22, 2019, 1:47 am ad1c9bdddf
https://brainmass.com/math/linear-transformation/create-a-optimal-model-and-solve-in-excel-551502

Attachments

Solution Preview

10
a) Let xi = 1 if a substation is located at site i (i=1,...,7), 0 otherwise.

We want to ...

Solution Summary

The solution gives detailed steps on finding optimal solution using a real exampe. All are answered in excel.

$2.19