Excel's Solver Tool Has Been Used in the Spreadsheet Below

question 22

Essay

Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all ≥ constraints.
​

a.Give the original linear programming problem.
b.Give the complete optimal solution.

---

Definitions:

Symptom

A sign or indication of something, especially of an illness or disease.

Flat Affect

A condition characterized by a severe reduction in emotional expressiveness, often seen in schizophrenia and depression.

Little Emotion

Experiencing or expressing minimal emotional responses, which could be indicative of certain personality traits or psychological states.

Condition

A specific state of being or existence, often referring to circumstances, health status, or external situations affecting entities or events.