$04.(1$ pt$)$

Consider the following optimization problem:

max $2\mathrm{.}6$x $0\mathrm{.}3$y

subject to:

x $5\mathrm{.}5(1)$ y $2\mathrm{.}9(2)5$x$+3$y$76(3)$

The above optimization problem is assigned to a Business Analyst to solve with the $$Solver$$ tool of Microsoft Excel. Before invoking $$Solver$,$ she sets up the following spreadsheet:

ABCDEF $1$ Optimal Decision Variable Values

$2$XY $3004$

$5$

Objective Function Coefficients $2\mathrm{.}6$

$-0\mathrm{.}3$

$0$

$6789$

$11$ ii $100>=2\mathrm{.}9$

Maximized Objective Function

Constraints

$10$ i $010>=5\mathrm{.}5$

Constraint Coefficients

Amount Used

RHS Limits

$12$ iii $5$

$30<=76$

$6$

Which cells have entries that are wrong?

$($a$)$ B$10,$B$11,$C$10,$C$11$

$($b$)$ B$3,$C$3$

$($c$)$ B$3,$C$3,$C$7$

$($d$)$ B$3,$C$3,$C$7,$D$10,$D$11,$D$12$