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
Get step-by-step solutions from verified subject matter experts
Study Help