Question 1

Solver provides many options for the solution process.For LPs,the two most commonly used are:

Accepted Answer

A) assume linear model,assume negative 
B) assume non-linear model,assume negative 
C) assume non-linear model,assume non-negative 
D) assume linear model,assume non-negative 
E) assume non-linear model,assume non-negative. 
A) assume linear model,assume negative 
B) assume non-linear model,assume negative 
C) assume non-linear model,assume non-negative 
D) assume linear model,assume non-negative 
E) assume non-linear model,assume non-negative.

Question 2

Discuss how the Solver Sensitivity Report is fundamentally different than the other reports.

Accepted Answer

The Sensitivity report contain

Question 3

With Excel Solver,the Target Cell can contain either a formula or a value.

Accepted Answer

A) True 
 B)False

Question 4

In the "Solver Parameters" box of Excel Solver,what is clicked to actually solve the problem?

Accepted Answer

A) "GO" 
B) "OK" 
C) "SOLVE" 
D) "CLOSE" 
E) "START" 
A) "GO" 
B) "OK" 
C) "SOLVE" 
D) "CLOSE" 
E) "START"

Question 5

The four steps to setting up an optimization problem with Excel Solver are easy if you have previously completed the algebraic formulation and spreadsheet model.

Accepted Answer

A) True 
 B)False

Question 6

What are the three reports available when Solver has successfully found an optimal solution?

Accepted Answer

(1)Answer Report,(2)

Question 7

Sausage and Cheese Ltd.prepares three gift packages containing sausages and cheeses.The "Tasters," "Succulent," and "Gourmet" gift packages contain 3 sausages and 6 cheeses,5 sausages and 4 cheeses,and 6 sausages and 5 cheeses,respectively.There are 2500 sausages and 3000 cheeses available for packing,and demand is unlimited.Profits are $2.50,$3.50,and $4.00 for the "Tasters," "Succulent," and "Gourmet" gift packages,respectively.The goal is to maximize profits.Let T,S,and G represent the number of gift packages produced of type "Tasters," "Succulent," and "Gourmet," respectively.What is the objective function for this linear program?

Accepted Answer

A) Max T + S + G 
B) Max 2.5T + 3.5S + 4G 
C) Min T + S + G 
D) Max 10(T + S + G) 
E) Max 9T + 9S + 11G 
A) Max T + S + G 
B) Max 2.5T + 3.5S + 4G 
C) Min T + S + G 
D) Max 10(T + S + G) 
E) Max 9T + 9S + 11G

Question 8

Formulate the following as a linear programming problem.
Jan lives in the country and is having a garage sale tomorrow.She has decided to sell some fresh baked goods in conjunction with the sale.She has excellent recipes for apple pie and for apple turnovers.She has 20.83 pounds of apples.Each pie will require 1.6 pounds of apples and each turnover will require 0.22 pounds of apples.She has discovered that she is short of both flour and sugar and does not want to make another trip to the store tonight.She has 5.7 pounds of flour and 200 grams of sugar.Each pie will require 0.6 pounds of flour and 11 grams of sugar.Each turnover will require .02 pounds of flour and 3 grams of sugar.She will sell pies for $6 each and turnovers for $0.75 each.She has decided to make 8 pies at most,because she is concerned about how well they will sell.

Accepted Answer

Let x1 = number of apple pies

Question 9

Which of the following statements is not correct?

Accepted Answer

A) A function with multiple variables can be linear. 
B) If a constraint is violated,then the problem is infeasible. 
C) A Linear Program as described in Supplement B can have more than one objective function if it has only one constraint. 
D) Non-negativity constraints should be added to Linear Programs when the decision variable represents units of production. 
E) An unbounded solution to a mathematical program may occur if there is not a constraint stopping the objective function value from continuing towards -∞. 
A) A function with multiple variables can be linear. 
B) If a constraint is violated,then the problem is infeasible. 
C) A Linear Program as described in Supplement B can have more than one objective function if it has only one constraint. 
D) Non-negativity constraints should be added to Linear Programs when the decision variable represents units of production. 
E) An unbounded solution to a mathematical program may occur if there is not a constraint stopping the objective function value from continuing towards -∞.

Question 10

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

Accepted Answer

The answer of A specific combination of values of the...

Question 11

In the Excel Solver "Add Constraint" box,what two additional choices are available under the relationship operator list besides ≤,≥,and =?

Accepted Answer

A) gin and bin 
B) int and gin 
C) big and int 
D) inf and bin 
E) int and bin 
A) gin and bin 
B) int and gin 
C) big and int 
D) inf and bin 
E) int and bin

Question 12

An optimal solution to an optimization problem is always feasible.

Accepted Answer

A) True 
 B)False

Question 13

Formulate the following as a linear program.
Joe's Sports Shop is sponsoring a weekly boomerang-throwing contest as part of its spring promotions.Anyone may enter,but the boomerangs used must be purchased at the shop.Demand is unlimited.Two models can be made: the regular model (with a profit of $2 each)and the super model (which yields a $5 profit).However,production facilities are limited.A regular boomerang requires 1 hour of carving and 2 hours of finishing,while a super boomerang takes 3 hours to carve and 2 hours to finish.The skilled crafters employed by the shop have indicated they will spend no more than 75 hours carving and 100 hours finishing boomerangs per week.The owner wishes to allocate production in order to maximize profits.

Accepted Answer

Let R = # of regular models pr

Question 14

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

Accepted Answer

A) objective model 
B) constrained model 
C) constrained optimization problem 
D) decision model 
E) excel model 
A) objective model 
B) constrained model 
C) constrained optimization problem 
D) decision model 
E) excel model

Question 15

The two primary Excel tools for diagnosing problems in models are ___________________.

Accepted Answer

A) Error Auditing and Formula Checking 
B) Error Auditing and Formula Auditing 
C) Error Checking and Formula Auditing 
D) Error Checking and Formula Checking 
E) Error Diagnosing and Formula Debugging 
A) Error Auditing and Formula Checking 
B) Error Auditing and Formula Auditing 
C) Error Checking and Formula Auditing 
D) Error Checking and Formula Checking 
E) Error Diagnosing and Formula Debugging

Question 16

Excel Solver restricts the constraints to either >= or =.

Accepted Answer

A) True 
 B)False

Question 17

What do you need to do before using Solver?

Accepted Answer

A) take an Excel class 
B) enter solver settings into Excel 
C) define all constraints 
D) enter Solver options 
E) have a working,flexible spreadsheet model 
A) take an Excel class 
B) enter solver settings into Excel 
C) define all constraints 
D) enter Solver options 
E) have a working,flexible spreadsheet model

Question 18

Describe guidelines for spreadsheet model development.

Accepted Answer

(1)Develop a correct,flexible,and docume

Question 19

Solver's Changing Cells corresponds to the ________ in the algebraic model.

Accepted Answer

The answer of Solver's Changing Cells corresponds to the ________...

Question 20

Constraints that are not at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value not equal to the right-hand-side value,are called _________________________.

Accepted Answer

A) inequality constraints 
B) non-binding constraints 
C) binding constraints 
D) limiting constraints 
E) shadow constraints 
A) inequality constraints 
B) non-binding constraints 
C) binding constraints 
D) limiting constraints 
E) shadow constraints

Solver provides many options for the solution process.For LPs,the two most commonly used are:

Discuss how the Solver Sensitivity Report is fundamentally different than the other reports.

With Excel Solver,the Target Cell can contain either a formula or a value.

In the "Solver Parameters" box of Excel Solver,what is clicked to actually solve the problem?

The four steps to setting up an optimization problem with Excel Solver are easy if you have previously completed the algebraic formulation and spreadsheet model.

What are the three reports available when Solver has successfully found an optimal solution?

Which of the following statements is not correct?

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

In the Excel Solver "Add Constraint" box,what two additional choices are available under the relationship operator list besides ≤,≥,and =?

An optimal solution to an optimization problem is always feasible.

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

The two primary Excel tools for diagnosing problems in models are ___________________.

Excel Solver restricts the constraints to either >= or =.

What do you need to do before using Solver?

Describe guidelines for spreadsheet model development.

Solver's Changing Cells corresponds to the ________ in the algebraic model.

Constraints that are not at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value not equal to the right-hand-side value,are called _________________________.

Introduction to Operations

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Exam 18: Introduction to Optimization

Solver provides many options for the solution process.For LPs,the two most commonly used are:

Discuss how the Solver Sensitivity Report is fundamentally different than the other reports.

With Excel Solver,the Target Cell can contain either a formula or a value.

In the "Solver Parameters" box of Excel Solver,what is clicked to actually solve the problem?

The four steps to setting up an optimization problem with Excel Solver are easy if you have previously completed the algebraic formulation and spreadsheet model.

What are the three reports available when Solver has successfully found an optimal solution?

Which of the following statements is not correct?

A specific combination of values of the decision variables such that at least one of the constraints is violated results in a(n)______________________.

In the Excel Solver "Add Constraint" box,what two additional choices are available under the relationship operator list besides ≤,≥,and =?

An optimal solution to an optimization problem is always feasible.

A mathematical model in which one is trying to maximize or minimize some quantity while satisfying a set of constraints is a(n):

The two primary Excel tools for diagnosing problems in models are ___________________.

Excel Solver restricts the constraints to either >= or =.

What do you need to do before using Solver?

Describe guidelines for spreadsheet model development.

Solver's Changing Cells corresponds to the ________ in the algebraic model.

Constraints that are not at their limits at the optimal solution of a Linear Program,that is,with the left-hand-side value not equal to the right-hand-side value,are called _________________________.

Introduction to Operations

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters