Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Restaurant From Concept To Operation

Authors: John R Walker

5th Edition

0471740578, 9780471740575

More Books

Students also viewed these General Management questions