Question 1

In Linear Programming, users have control over quantities called parameters.

Accepted Answer

A) True 
 B)False

Question 2

What is the optimal solution to the following linear program? 
Max 2X + Y
Subject to
2X + 2Y ? 40
X + Y ? 10
X ? 0
Y ? 0

Accepted Answer

A) the solution is unbounded 
B) (0, 20) 
C) (10, 0) 
D) (20, 0) 
E) the program is infeasible 
A) the solution is unbounded 
B) (0, 20) 
C) (10, 0) 
D) (20, 0) 
E) the program is infeasible

Question 3

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

Accepted Answer

(1)Answer Report, (2

Question 4

Excel's Solver Add-In solves _____________ problems.

Accepted Answer

The answer of Excel's Solver Add-In solves _____________ problems....

Question 5

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 6

Capital Co. is considering which of five different projects to undertake in order to maximize its net present value (NPV). Define Xi as a binary (0-1)variable that equals 1 if project i is undertaken and 0 otherwise, for i = 1,2,3,4,5. The NPV and required capital (in thousands)for each project are listed below.  
Which of the following represents the constraint stating that project 1 can be undertaken only if project 5 is undertaken?

Accepted Answer

A) X1 + X5 ≤ 1 
B) X1 - X5 ≤ 0 
C) X5 - X1 ≤ 0 
D) X1 - X5 ≤ 1 
E) X5 - X1 ≤ 1 
A) X1 + X5 ≤ 1 
B) X1 - X5 ≤ 0 
C) X5 - X1 ≤ 0 
D) X1 - X5 ≤ 1 
E) X5 - X1 ≤ 1

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

In the "Solver Options" box of Excel Solver, what should be checked to ensure that all decision variables are ≥ 0?

Accepted Answer

A) Assume Linear Model 
B) Use Automatic Scaling 
C) Assume Positive 
D) Assume Non-Negative 
E) Assume Nonzero 
A) Assume Linear Model 
B) Use Automatic Scaling 
C) Assume Positive 
D) Assume Non-Negative 
E) Assume Nonzero

Question 9

When was the Simplex Method developed?

Accepted Answer

A) 1927 
B) 1937 
C) 1947 
D) 1957 
E) 1967 
A) 1927 
B) 1937 
C) 1947 
D) 1957 
E) 1967

Question 10

Consider the following three functions:
 f(x)= 6x2
G(x, y)=4x - 3y + 19
H(x, y)= 3xy
Which of the following is true regarding the linearity of the functions?

Accepted Answer

A) none of the functions is linear 
B) all three functions are linear 
C) g(x, y)is linear, but f(x)and h(x, y)are not linear 
D) g(x, y)and h(x, y)are linear, but f(x)is not linear 
E) h(x, y)is linear, but f(x)and g(x, y)are not linear 
A) none of the functions is linear 
B) all three functions are linear 
C) g(x, y)is linear, but f(x)and h(x, y)are not linear 
D) g(x, y)and h(x, y)are linear, but f(x)is not linear 
E) h(x, y)is linear, but f(x)and g(x, y)are not linear

Question 11

Formulate the following as a linear program.
Dane's aircraft muffler manufacturers have 1000 linear feet of steel on hand to manufacture the three top selling muffler sets. Super mufflers (S)provide $35 profit and common (C)mufflers' profit margin is $31, while the deluxe (D)muffler set provides a $40 profit margin. It takes 31 hours to make the super muffler, 29 hours to manufacture the common muffler, and 40 hours to build the deluxe muffler. If Dane is limited to 200 hours a month what is the optimum combination of mufflers to manufacture to maximize his profits?

Accepted Answer

Let S -=supper muffler, C = co

Question 12

Dane's aircraft muffler manufacturers have 1500 linear feet of steel on hand to manufacture the three top selling muffler sets. Super mufflers (S)provide $285 profit and common (C)mufflers' profit margin is $310, while the deluxe (D)muffler set provides a $400 profit margin. It costs Dane $310, $295, and $400 to build each muffler set, respectively. What is the objective function of Dane's aircraft muffler manufacturing?

Accepted Answer

A) Min S, C and D 
B) MAX S, C, and D 
C) Max 285S + 310C + 400D 
D) Min 285S + 310C + 400D 
E) Max 310S + 295C + 400D 
A) Min S, C and D 
B) MAX S, C, and D 
C) Max 285S + 310C + 400D 
D) Min 285S + 310C + 400D 
E) Max 310S + 295C + 400D

Question 13

Slack values for non-binding constraints are equal to 0.

Accepted Answer

A) True 
 B)False

Question 14

A ____________________ contains explicit definitions of the decision variables, an algebraic expression of the objective function, and algebraic statements of the constraints.

Accepted Answer

A) composition 
B) derivation 
C) manipulation 
D) formulation 
E) regurgitation 
A) composition 
B) derivation 
C) manipulation 
D) formulation 
E) regurgitation

Question 15

Uhura Enterprises provides consulting services for customers. Consultants are brought in for two-hour shifts. A consultant will spend one full hour with a customer. The customers remain for that hour and then leave. Each consultant is paid $25 per hour. Let Xi  represent the number of consultants starting their shift at hour i, (i = 1,2,3,4). The firm wishes to minimize salary costs while satisfying demand. Customer demand is as follows. 
1:00-2:00 $\quad$4
2:00-3:00 $\quad$5
3:00-4:00 $\quad$10
4:00-5:00 $\quad$4
5:00-6:00 $\quad$8
Suppose that two of the customers scheduled to arrive at 1:00 could be rescheduled to arrive at 2:00. Which of the following sets of constraints would allow for this rescheduling option? (In the options below, q and qi are binary (0-1)variables.)

Accepted Answer

A) X1 ≥ 4 and X2 ≥ 5 and X1 ≥ 2 and X2 ≥ 7 
B) X1 ≥ 4 and X2 + X3 ≥ 15 and X1 ≥ 2 and X2 + X3 ≥ 17 
C) 50X1 ≥ 4 and 50X2 + 50X3 ≥ 15 and 50X1 ≥ 2 and 50X2 + 50X3 ≥ 17 
D) X1 ≥ 4 - 5000q and X2 + X3 ≥ 15 - 5000q and X1 ≥ 2 -5000(1-q)and X2 + X3 ≥ 17 -5000(1-q) 
E) X1 ≥ 4 + 5000q and X2 + X3 ≥ 15 + 5000q and X1 ≥ 2 + 5000(1-q) and X2 + X3 ≥ 17 + 5000(1-q) 
A) X1 ≥ 4 and X2 ≥ 5 and X1 ≥ 2 and X2 ≥ 7 
B) X1 ≥ 4 and X2 + X3 ≥ 15 and X1 ≥ 2 and X2 + X3 ≥ 17 
C) 50X1 ≥ 4 and 50X2 + 50X3 ≥ 15 and 50X1 ≥ 2 and 50X2 + 50X3 ≥ 17 
D) X1 ≥ 4 - 5000q and X2 + X3 ≥ 15 - 5000q and X1 ≥ 2 -5000(1-q)and X2 + X3 ≥ 17 -5000(1-q) 
E) X1 ≥ 4 + 5000q and X2 + X3 ≥ 15 + 5000q and X1 ≥ 2 + 5000(1-q) and X2 + X3 ≥ 17 + 5000(1-q)

Question 16

In Solver, the __________ is the cell that you want to maximize or minimize.

Accepted Answer

The answer of In Solver, the __________ is the cell...

Question 17

The basic idea for optimization of problems is to find the values of __________ variables that ____________ (minimize)the objective function value, while staying within the _________ .

Accepted Answer

decision,

Question 18

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 19

Which of the following is not one of the steps in setting up the Solver optimization problem?

Accepted Answer

A) specify the target cell 
B) specify the objective cell 
C) specify the changing cell(s) 
D) specify the constraints 
E) specify the Solver options 
A) specify the target cell 
B) specify the objective cell 
C) specify the changing cell(s) 
D) specify the constraints 
E) specify the Solver options

Question 20

Large-scale optimization software can handle how many decision variables and constraints?

Accepted Answer

A) dozens 
B) hundreds 
C) thousands 
D) millions 
E) all of these answer choices are correct 
A) dozens 
B) hundreds 
C) thousands 
D) millions 
E) all of these answer choices are correct

In Linear Programming, users have control over quantities called parameters.

What is the optimal solution to the following linear program? Max 2X + Y Subject to 2X + 2Y ? 40 X + Y ? 10 X ? 0 Y ? 0

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

Excel's Solver Add-In solves _____________ problems.

In the "Solver Options" box of Excel Solver, what should be checked to ensure that all decision variables are ≥ 0?

When was the Simplex Method developed?

Consider the following three functions: f(x)= 6x² G(x, y)=4x - 3y + 19 H(x, y)= 3xy Which of the following is true regarding the linearity of the functions?

Slack values for non-binding constraints are equal to 0.

A ____________________ contains explicit definitions of the decision variables, an algebraic expression of the objective function, and algebraic statements of the constraints.

In Solver, the __________ is the cell that you want to maximize or minimize.

The basic idea for optimization of problems is to find the values of __ variables that (minimize)the objective function value, while staying within the _ .

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

Which of the following is not one of the steps in setting up the Solver optimization problem?

Large-scale optimization software can handle how many decision variables and constraints?

Introduction to Operations Management

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 17: Spreadsheet Modeling: an Introduction

In Linear Programming, users have control over quantities called parameters.

What is the optimal solution to the following linear program? Max 2X + Y Subject to 2X + 2Y ? 40 X + Y ? 10 X ? 0 Y ? 0

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

Excel's Solver Add-In solves _____________ problems.

In the "Solver Options" box of Excel Solver, what should be checked to ensure that all decision variables are ≥ 0?

When was the Simplex Method developed?

Consider the following three functions: f(x)= 6x2 G(x, y)=4x - 3y + 19 H(x, y)= 3xy Which of the following is true regarding the linearity of the functions?

Slack values for non-binding constraints are equal to 0.

A ____________________ contains explicit definitions of the decision variables, an algebraic expression of the objective function, and algebraic statements of the constraints.

In Solver, the __________ is the cell that you want to maximize or minimize.

The basic idea for optimization of problems is to find the values of __________ variables that ____________ (minimize)the objective function value, while staying within the _________ .

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

Which of the following is not one of the steps in setting up the Solver optimization problem?

Large-scale optimization software can handle how many decision variables and constraints?

Introduction to Operations Management

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

Consider the following three functions: f(x)= 6x² G(x, y)=4x - 3y + 19 H(x, y)= 3xy Which of the following is true regarding the linearity of the functions?

The basic idea for optimization of problems is to find the values of __ variables that (minimize)the objective function value, while staying within the _ .