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 fill in the By Changing Variable Cells box. She would choose the cells containing the ____.
A) minimum number of onyx and topaz pendants to produce
B) range representing the number of onyx and topaz pendants produced
C) unit cost for both the onyx and topaz pendants
D) total cost to produce each pendant

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 fill in the By Changing Variable Cells box. She would choose the cells containing the ____.
A) minimum number of onyx and topaz pendants to produce 
B) range representing the number of onyx and topaz pendants produced 
C) unit cost for both the onyx and topaz pendants 
D) total cost to produce each pendant

Quizplus · Accepted Answer

The By Changing Variable Cells box is where Solver should look for the values it will adjust to find the optimal solution. In this case, Ava is trying to find the optimal number of topaz and onyx pendants to produce, so she would choose the cells containing the range representing the number of onyx and topaz pendants produced. This is the only option that makes sense for the By Changing Variable Cells box.

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