QSO320 Managerial Science Class. The questions on an assignment I have are detailed below.

Need help on the questions below

Question 1 (1 point)

 Which of the following would not result in a constraint being added to the programming for Solver?

Question 1 options:

Management defining minimum outputs

A limited inventory of raw materials needed for production

A limited availability of a machine to produce a specific item

Marketing changing the selling price of the items produced

Question 2 (1 point)

 You receive the following message from Solver: “Target Cells Must Be in the Formula.” Is Solver ready to run?

uestion 2 options:

Yes

No

Question 3 (1 point)

 Complete the sentence. The target cell (or objective cell) contains ___________________.

Question 3 options:

A formula that represents the objective, or goal, of the problem a decision variable

Information that puts constraints on the objective

A solution to the problem you are trying to solve

Question 4 (1 point)

 True or False? Constraints are logical conditions that a solution to an optimization problem must satisfy.

Question 4 options:

True

False

Question 5 (1 point)

What three things do you need to specify before running Solver?

Question 5 options:

Determines the value that you need to enter in a single input cell to produce a result that you want in a dependent (formula) cell

Predicts data that is based on the previous data point and the previously predicted data point

Determines the values that you need to enter in multiple input cells to produce a result that you want

Creates a special type of table that displays the results of selected formula cells as you systematically change one or two input cells

Question 6 (1 point)

True or false: Solver may yield a solution that indicates less than a whole number of items to be produced.

Question 6 options:

True

False

Question 7 (1 point)

What reports can you select in the Reports section of the Solver Results dialog box after you’ve run Solver?

Question 7 options:

Sensitivity, Feasibility, Limits

Feasibility, Answer, Sensitivity

Answer, Sensitivity, Limits

Limits, Answer, Feasibility

Question 8 (1 point)

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?

Question 8 options:

Setting the Objective box to “max”

Setting the Objective box to “max” and not checking the Assume Non-Negative box in Options

Not setting a minimum number of items to be produced in Constraints

Setting the Objective box to “max” and checking the Assume Non-Negative box in Options

Question 9 (1 point)

True or false? Solver can only adjust two variables when producing a solution.

Question 9 options:

True

False

Question 10 (1 point)

True or false? Solver solutions are based on probability.

Question 10 options:

True

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"