Question 1

The main difference between linear LP)and nonlinear programming problems NLP)is that

Accepted Answer

A) NLP must have a nonlinear objective function 
B) Some constraints in NLP may be nonlinear 
C) No interaction terms are allowed in NLP 
D) Only one constraint in NLP can be nonlinear 
A) NLP must have a nonlinear objective function 
B) Some constraints in NLP may be nonlinear 
C) No interaction terms are allowed in NLP 
D) Only one constraint in NLP can be nonlinear

Question 2

Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources,labor and material.The company wants to determine the selling price which will maximize profits.A unit of A costs 25 to make and demand is estimated to be 20 ? .10 * Price of A.A unit of B costs 18 to make and demand is estimated to be 30 ? .07 * Price of B.The utilization of labor and materials and the available quantity of resources is shown in the table.A reasonable price for the products is between 100 and 200.
 $\begin{array}{lccc}
\text { Product } & \text { A } & \text { B } & \text { Avalable resources } \
\hline \text { Labor hr/unit) } & 3 & 2 & 150 \
\text { Material ounces/unit) } & 1 & 2 & 200 \
\text { Manufacturing cost\$/unit) } & 25 & 18 & \
\text { Demand units) } & 20-.10^{*} \mathrm{P}_{1} & 30-.07^{*} \mathrm{P}_{2} &
\end{array}$
 Let XS1U1B11 S1U1B0= demand for As and XS1U1B12 S1U1B0= demand for Bs.Let PS1U1B11 S1U1B0= price for As and PS1U1B12 S1U1B0= price for Bs
  
-A company wants to locate a new warehouse to minimize the distance traveled by its delivery trucks.It has four stores and their coordinates are listed in the accompanying spreadsheet.What formula goes in cell D9 of the spreadsheet?
$$\begin{array} { | r | c | c | c | r | } 
\hline & \text { A } & \mathrm { B } & \mathrm { C } & \mathrm { D } \
\hline 1 & & & & \
\hline 2 & & \text { X-Coordinate } & \text { Y-Coordinate } & \
\hline 3 & \text { Warehouse } & 103.800 & 101.000 & \text { Distance: } \
\hline 4 & \text { Store 1 } & 100 & 130 & 70.082 \
\hline 5 & \text { Store 2 } & 90 & 60 & 84.424 \
\hline 6 & \text { Store 3 } & 210 & 80 & 50.749 \
\hline 7 & \text { Store 4 } & 180 & 110 & 18.532 \
\hline 8 & & & & \
\hline 9 & & \text { Total Distance: } &223.787 & \
\hline
\end{array}$$

Accepted Answer

A) =MIND4:D7)^2 
B) =SUMD4:D7) 
C) =SQRTD4^2+D5^2+D6^2+D7^2) 
D) =SQRTMMULTB3:C3,D4:D7)) 
A) =MIND4:D7)^2 
B) =SUMD4:D7) 
C) =SQRTD4^2+D5^2+D6^2+D7^2) 
D) =SQRTMMULTB3:C3,D4:D7))

Question 3

The Lagrange multipliers can be used to

Accepted Answer

A) estimate the impact of a small change in the RHS of the constraints on the objective function 
B) estimate the impact of an arbitrary change in the RHS of the constraints on the objective function 
C) estimate the impact of a small change in the RHS of the constraints on the shadow prices 
D) estimate the impact of a large change in the RHS of the constraints on the shadow prices 
A) estimate the impact of a small change in the RHS of the constraints on the objective function 
B) estimate the impact of an arbitrary change in the RHS of the constraints on the objective function 
C) estimate the impact of a small change in the RHS of the constraints on the shadow prices 
D) estimate the impact of a large change in the RHS of the constraints on the shadow prices

Question 4

If the "Standard LP/Quadratic Engine" option is chosen in the Analytic Solver Platform ASP)task pane,ASP

Accepted Answer

A) will test for non-linearity in the model and apply GRG. 
B) will test for non-linearity in the model and apply Simplex. 
C) uses the B & B algorithm to solve the problem. 
D) will apply Simplex if the linearity test passes. 
A) will test for non-linearity in the model and apply GRG. 
B) will test for non-linearity in the model and apply Simplex. 
C) uses the B & B algorithm to solve the problem. 
D) will apply Simplex if the linearity test passes.

Question 5

Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources,labor and material.The company wants to determine the selling price which will maximize profits.A unit of A costs 25 to make and demand is estimated to be 20 ? .10 * Price of A.A unit of B costs 18 to make and demand is estimated to be 30 ? .07 * Price of B.The utilization of labor and materials and the available quantity of resources is shown in the table.A reasonable price for the products is between 100 and 200.
 $\begin{array}{lccc}
\text { Product } & \text { A } & \text { B } & \text { Avalable resources } \
\hline \text { Labor hr/unit) } & 3 & 2 & 150 \
\text { Material ounces/unit) } & 1 & 2 & 200 \
\text { Manufacturing cost\$/unit) } & 25 & 18 & \
\text { Demand units) } & 20-.10^{*} \mathrm{P}_{1} & 30-.07^{*} \mathrm{P}_{2} &
\end{array}$
 Let XS1U1B11 S1U1B0= demand for As and XS1U1B12 S1U1B0= demand for Bs.Let PS1U1B11 S1U1B0= price for As and PS1U1B12 S1U1B0= price for Bs
  
-An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local businesses.Annual demand is 20,000 units and each cartridge costs the store $25.It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item.The following spreadsheet has been set up to solve the problem.What cell is the variable cell in this problem?
$\begin{array}{|c|c|c|}
\hline & \text { A } & \text { B } \
\hline 1 & & \
\hline 2 & &  \
\hline 3 & \text { Annual Demand: } &20,000 \
\hline 4 & & \
\hline 5 & \text { Cost per Unit: } &\$25 \
\hline 6 & \text { Ordering Cost: } & \$ 30 \
\hline 7 & \text { Carrying Cost: } & 25 \% \
\hline 8 & &  \
\hline 9 & \text { Order Quantity: } &483.73 \
\hline 10 & &  \
\hline 11 & \text { Total Cost: } &\$ 502,738.61 \
\hline
\end{array}$

Accepted Answer

A) B3 
B) B7 
C) B9 
D) B11 
A) B3 
B) B7 
C) B9 
D) B11

Question 6

A company wants to locate a new warehouse to minimize the distance travelled by its delivery trucks.It has four stores and their coordinates are listed in the below.
Formulate the objective function for this problem.Let X and Y represent the X,Y coordinates of the new warehouse.

Accepted Answer

The answer of A company wants to locate a new...

Question 7

Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources,labor and material.The company wants to determine the selling price which will maximize profits.A unit of A costs 25 to make and demand is estimated to be 20 ? .10 * Price of A.A unit of B costs 18 to make and demand is estimated to be 30 ? .07 * Price of B.The utilization of labor and materials and the available quantity of resources is shown in the table.A reasonable price for the products is between 100 and 200.
 $\begin{array}{lccc}
\text { Product } & \text { A } & \text { B } & \text { Avalable resources } \
\hline \text { Labor hr/unit) } & 3 & 2 & 150 \
\text { Material ounces/unit) } & 1 & 2 & 200 \
\text { Manufacturing cost\$/unit) } & 25 & 18 & \
\text { Demand units) } & 20-.10^{*} \mathrm{P}_{1} & 30-.07^{*} \mathrm{P}_{2} &
\end{array}$
 Let XS1U1B11 S1U1B0= demand for As and XS1U1B12 S1U1B0= demand for Bs.Let PS1U1B11 S1U1B0= price for As and PS1U1B12 S1U1B0= price for Bs
  
-How much are additional units of Labor worth based on the following sensitivity report?
Changing Cells
Final Reduced
Cell Name Value Gradient
$B$4 Number to make: X1 9.42 0
$C$4 Number to make: X2 1.71 0
Constraints
Final Lagrange
Cell Name Value Multiplier

Accepted Answer

A) 0 
B) 1.21 
C) 2.57 
D) 9.42
$D$8 Wood 42 0
$D$9 Labor 132 1.21
$D$10 Plywood 24 2.57 
A) 0 
B) 1.21 
C) 2.57 
D) 9.42
$D$8 Wood 42 0
$D$9 Labor 132 1.21
$D$10 Plywood 24 2.57

Question 8

An office supply company is attempting to determine the order quantity for Mt.White fountain pens which are sold to local executives.Annual demand is 5,000 units and each pen costs the store $50.It costs $75 to place an order and the inventory carrying cost rate is 30% of the value of the item.
What values should go in cells B3:B11 of the spreadsheet for this problem if Q = 223.61?
 $$\begin{array} { | c | c | c | } 
\hline & \text { A } & \text { B } \
\hline 1 & & \
\hline 2 & & \
\hline 3 & \text { Annual Demand: } & \
\hline 4 & & \
\hline 5 & \text { Cost per Unit: } & \
\hline 6 & \text { Ordering Cost: } & \
\hline 7 & \text { Carying Cost: } & \
\hline \mathbf { 8 } & & \
\hline 9 & \text { Order Quantity: } & \
\hline 10 & & \
\hline 11 & \text { Total Cost: } & \
\hline
\end{array}$$

Accepted Answer

None

Question 9

Exhibit 8.1
The following questions pertain to the problem and spreadsheet below.
A company makes products A and B from 2 resources,labor and material.The company wants to determine the selling price which will maximize profits.A unit of A costs 25 to make and demand is estimated to be 20 ? .10 * Price of A.A unit of B costs 18 to make and demand is estimated to be 30 ? .07 * Price of B.The utilization of labor and materials and the available quantity of resources is shown in the table.A reasonable price for the products is between 100 and 200.
 $\begin{array}{lccc}
\text { Product } & \text { A } & \text { B } & \text { Avalable resources } \
\hline \text { Labor hr/unit) } & 3 & 2 & 150 \
\text { Material ounces/unit) } & 1 & 2 & 200 \
\text { Manufacturing cost\$/unit) } & 25 & 18 & \
\text { Demand units) } & 20-.10^{*} \mathrm{P}_{1} & 30-.07^{*} \mathrm{P}_{2} &
\end{array}$
 Let XS1U1B11 S1U1B0= demand for As and XS1U1B12 S1U1B0= demand for Bs.Let PS1U1B11 S1U1B0= price for As and PS1U1B12 S1U1B0= price for Bs
  
-Refer to Exhibit 8.1.What formula is used in cell B7 of the spreadsheet for this problem?

Accepted Answer

A) = 30 ? .07 * C3 
B) = 20 ? .1 * B3 
C) = B3 ? B4 
D) = B5 * B7 + C5 * C7 
A) = 30 ? .07 * C3 
B) = 20 ? .1 * B3 
C) = B3 ? B4 
D) = B5 * B7 + C5 * C7

The main difference between linear LP)and nonlinear programming problems NLP)is that

The Lagrange multipliers can be used to

If the "Standard LP/Quadratic Engine" option is chosen in the Analytic Solver Platform ASP)task pane,ASP

A company wants to locate a new warehouse to minimize the distance travelled by its delivery trucks.It has four stores and their coordinates are listed in the below. Formulate the objective function for this problem.Let X and Y represent the X,Y coordinates of the new warehouse.

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Regression Analysis

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

Exam 8: Nonlinear Programming and Evolutionary Optimization

The main difference between linear LP)and nonlinear programming problems NLP)is that

The Lagrange multipliers can be used to

If the "Standard LP/Quadratic Engine" option is chosen in the Analytic Solver Platform ASP)task pane,ASP

A company wants to locate a new warehouse to minimize the distance travelled by its delivery trucks.It has four stores and their coordinates are listed in the below. Formulate the objective function for this problem.Let X and Y represent the X,Y coordinates of the new warehouse.

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Regression Analysis

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters