Question
1. True or false: Solver may yield a solution that indicates less than a whole number of items to be produced 2. Yes or No?
1. True or false: Solver may yield a solution that indicates less than a whole number of items to be produced
2. Yes or No? You receive the following message from Solver: "Target Cells Must Be in the Formula." Is Solver ready to run
3. True or False? Constraints are logical conditions that a solution to an optimization problem must satisfy
4. What three things do you need to specify before running Solver?
A | Limits, constraints, and sensitivity |
B | Target cell, iterations, and limits |
C | Decision variables, limits, and iterations |
D | Target cell, decision variables, and constraints |
5. Solver adjusts the ______________ in the decision variable cells to satisfy the limits on constraint cells and produce the results you want for the objective cell
A | Functions |
B | Limits |
C | Formuals |
D | Values |
6. If Solver cannot find a solution, you can click on the ___________ button to control the aspects of how Solver solves a problem.
A | Retry |
B | Methods |
C | Options |
D | Iterations |
7. To determine how many items should be produced, you program Solver to produce a minimum value as a target cell objective. Solver indicates that zero items should be produced. What programming error listed below would lead to this result?
A | Setting the Objective box to "max" |
B | Setting the Objective box to "max" and not checking the Assume Non-Negative box in Options |
C | Not setting a minimum number of items to be produced in Constraints |
D | Setting the Objective box to "max" and checking the Assume Non-Negative box in Options |
8. Which of the following would not result in a constraint being added to the programming for Solver?
A.) Management defining minimum outputs |
B.) A limited inventory of raw materials needed for production |
C.) A limited availability of a machine to produce a specific item |
D.) Marketing changing the selling price of the items produced |
9. Complete the sentence. The target cell (or objective cell) contains ___________________.
A | A formula that represents the objective, or goal, of the problem a decision variable |
B | Information that puts constraints on the objective |
C | A solution to the problem you are trying to solve |
10. True or false? If you change the programming in your spreadsheet, you need to run Solver again and determine a new solution.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started