Ava is setting up a production model for her jewelry-making business. She decides to use Solver to find the optimal number of topaz and onyx pendants to produce with the given constraints. One of the most important constraints is that the minimum number to produce is 100 of each. Please answer the questions below, referencing the above figure as needed.
-Ava is ready to add the constraints and clicks the Add button. Each constraint contains a cell reference to a cell in the worksheet, a comparison operator, and a cell reference or a constraint value. Ava's first constraint is that total cost (H6) cannot exceed $10,000 (C10). She would enter these parameters in the appropriate text box: ____.
A) H6

Question

Ava is setting up a production model for her jewelry-making business. She decides to use Solver to find the optimal number of topaz and onyx pendants to produce with the given constraints. One of the most important constraints is that the minimum number to produce is 100 of each. Please answer the questions below, referencing the above figure as needed.
-Ava is ready to add the constraints and clicks the Add button. Each constraint contains a cell reference to a cell in the worksheet, a comparison operator, and a cell reference or a constraint value. Ava's first constraint is that total cost (H6) cannot exceed $10,000 (C10). She would enter these parameters in the appropriate text box: ____.
A) H6 <= C10 
B) H6 <= 10,000 
C) either a or b 
D) neither a nor b

Quizplus · Accepted Answer

Ava can use either "H6 <= C10" if $10,000 is the value in cell C10, or "H6 <= 10,000" directly entering the value. Both methods correctly set the constraint that H6 cannot exceed $10,000.

Ava Is Setting Up a Production Model for Her Jewelry-Making