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

question 27

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:

Fathers

The male parent or guardian of a child, playing a significant role in the child's development and emotional well-being through support and guidance.

Mothers

Female parents who have given birth to, adopted, or in some cases, assumed the primary care of a child.

Negative Symptoms

Features often found in certain mental illnesses, such as schizophrenia, that include a lack or decrease in the ability to function normally, like diminished emotional expression.

Exaggerated

Describes something made to appear larger, more significant, or more important than it actually is, often through overstatement or hyperbole.