Using Excel's Solver Add-In, Find the Optimal Solution for the Following

question 6

Multiple Choice

Using Excel's Solver add-in, find the optimal solution for the following problem?
Maximize P = 8x + 3y
subject to $2 x + 4 y \leq 20$
$6 x + 3 y \leq 18$
$and\quad x \geq 0 , y \geq 0$

• A) (x, y) = (3, 0)
• B) (x, y) = (0, 3)
• C) (x, y) = (0, 0)
• D) (x, y) = (0, 5)
• E) None of the answer choices are correct.

---

Definitions:

Collecting Job Information

The process of gathering details about job roles, responsibilities, qualifications, and requirements.

Focus Groups

A research method involving moderated discussions with groups of participants designed to gather opinions on a specific topic.

Employee Logs

Records maintained by organizations to track employee activities, attendance, hours worked, and sometimes specific job duties or project progress.

Job Analysis Information

Data collected about a job, including responsibilities, work conditions, necessary skills, and outcomes, used for defining roles and expectations.