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:

Vaginismus

A condition involving a muscle spasm in the pelvic floor muscles that can make vaginal penetration painful or impossible.

Muscle Spasms

Sudden, involuntary contractions of a muscle or a group of muscles, often causing pain or discomfort.

Vaginal Penetration

The insertion of an object, such as a penis or sex toy, into the vagina.

Delayed Ejaculation

A sexual dysfunction characterized by a prolonged delay or inability to achieve ejaculation despite sexual stimulation.