Solve linear equation optimization

Minimize Cost = 456.67x + 1278.07y + 216.33z

Subject to:

0.72x + 0.82y + 0.65z >= 0.77(x + y + z)

0.95x + 0.85y + 0.72z >= 0.78(x + y + z)

0.95x + 0.85y + 0.72z <= 0.88(x + y + z)

0.3(x + y + z) <= 49275

0.7(x + y + z) <= 49275

Answer 1

[Torsten]

Set up and solve your problem using "linprog":

https://uk.mathworks.com/help/optim/ug/linprog.html

[Vibe]

Thats the problem, I seem not toable to input and understand in inputting it in excel solve

[John D'Errico]

This is not an Excel forum, so we won't teach you how to solve it using Excel.

[Vibe]

can you teahme with anexample

Answer 2

[Alan Weiss]

You might find the examples in the linprog documentation useful.

Alan Weiss

MATLAB mathematical toolbox documentation