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's production plan contains no nonlinear formulas or arrangement. What should she do to the solving method used by the Solver?
A) Leave the default GRG Nonlinear solving method.
B) Change the solving method to Goal Seek.
C) Change the solving method to Binary LP.
D) Change the solving method to Simplex LP.

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's production plan contains no nonlinear formulas or arrangement. What should she do to the solving method used by the Solver?
A) Leave the default GRG Nonlinear solving method. 
B) Change the solving method to Goal Seek. 
C) Change the solving method to Binary LP. 
D) Change the solving method to Simplex LP.

Quizplus · Accepted Answer

Since Ava's production plan contains no nonlinear formulas or arrangement, the best option for the solving method used by the Solver is Simplex LP. This method is suitable for linear problems with multiple constraints and objectives, which is the case in Ava's production model. Therefore, option D, Change the solving method to Simplex LP, is the best choice.

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