Data and functions have been entered $($correctly$)$ into Excel as:

$\backslash$table$[[A,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$],[1,$BAK Products,,,,,$8,,],[2,,,,$is$,,,,],[3,$Product,Fab,Final,Production Limit,,Amount Produced,Unit Profit,$],[4,$A$,3,2,1,,,$$$375,],[5,$B$,2,1,1,,,$$$200,],[6,$Resource Used,$0,0,0,,,$:$.,],[7,$:Total Profit,$$0,],[8,$Resource Available,$240,140,80,,,,],[9,,,$a$,,,,,],[10,,,,,,,,],[11,3,,,,,,,]]$

When one sets up the Solver to compute the optimal solution of the BAK problem, which of the following statements are true?

None of the answers are correct.

The optimization goal is minimization.

The "Changing Variable Cells" are F$4$:F$5$

The "set objective" cell would be G$6.$

Exactly two constraints would be added into the constraint dialogue.