Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q6: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Identify the
Q7: The _ dialog box lets you put
Q8: You can set up complex business models
Q9: When Solver cannot find a feasible solution,
Q10: Any Solver solution requires a well-organized spreadsheet
Q12: One of the options when assigning constraints
Q13: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Identify the
Q14: The _ function sums a series of
Q15: With Solver, you can change the values
Q16: Having a cell in the worksheet that