Filters
Question type

Study Flashcards

The optimal solution to a LP problem is always at I. A corner point. II) An interior point III) The origin.


A) I is true
B) II is true
C) III is true
D) I and III are true

Correct Answer

verifed

verified

Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft2 of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem. Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft<sup>2</sup> of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem.   The spreadsheet implementation of this formulation applies to the following questions.   -Refer to Exhibit 8.2. What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? ​ Objective Cell: ​ Variables Cells: ​ Constraints Cells: The spreadsheet implementation of this formulation applies to the following questions. Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft<sup>2</sup> of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem.   The spreadsheet implementation of this formulation applies to the following questions.   -Refer to Exhibit 8.2. What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? ​ Objective Cell: ​ Variables Cells: ​ Constraints Cells: -Refer to Exhibit 8.2. What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? ​ Objective Cell: ​ Variables Cells: ​ Constraints Cells:

Correct Answer

verifed

verified

11eaaa11_7eba_f9b0_9885_47c7896f488c_TB2300_00

The GRG and Simplex algorithms are similar in that


A) each algorithm process continues until there is no further improvement in the objective function.
B) both algorithms take their starting solution from the spreadsheet.
C) both return the globally optimal solution.
D) both algorithms return a solution that satisfies at least one constraint at equality.

Correct Answer

verifed

verified

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 formula goes in cell B11 in this problem? 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 formula goes in cell B11 in this problem?   A)  =B3*B7+B9/B3*B6+B9*2+B5*B7 B)  =B3*B5+B3/B9*B6+B9/2*B5*B7 C)  =SQRT(B3*B5+B3/B9*B6+B9/2*B5*B7)  D)  =B3*B3+B3/B9+B6*B9/2*B5*B7


A) =B3*B7+B9/B3*B6+B9*2+B5*B7
B) =B3*B5+B3/B9*B6+B9/2*B5*B7
C) =SQRT(B3*B5+B3/B9*B6+B9/2*B5*B7)
D) =B3*B3+B3/B9+B6*B9/2*B5*B7

Correct Answer

verifed

verified

An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet? An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet?   ​   A)  =SUMPRODUCT(B15:D15,G9:I9)  B)  =SUMPRODUCT(B15:D15,B4:D13)  C)  =SUMPRODUCT(B15:D15,I9)  D)  =SUMPRODUCT(B15:D15,G4:I6) An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet?   ​   A)  =SUMPRODUCT(B15:D15,G9:I9)  B)  =SUMPRODUCT(B15:D15,B4:D13)  C)  =SUMPRODUCT(B15:D15,I9)  D)  =SUMPRODUCT(B15:D15,G4:I6)


A) =SUMPRODUCT(B15:D15,G9:I9)
B) =SUMPRODUCT(B15:D15,B4:D13)
C) =SUMPRODUCT(B15:D15,I9)
D) =SUMPRODUCT(B15:D15,G4:I6)

Correct Answer

verifed

verified

How many local minimum solutions are there on this graph of a function Mark their locations on the graph. ​ How many local minimum solutions are there on this graph of a function Mark their locations on the graph. ​

Correct Answer

verifed

verified

There are three loca...

View Answer

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

Correct Answer

verifed

verified

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 D4 of the spreadsheet? 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 D4 of the spreadsheet?   A)  =(B4-$B$3) ^2+(C4-$C$3) ^2 B)  =SQRT((B4-$B$3) +(C4-$C$3) )  C)  =SQRT((B4-$B$3) ^2+(C4-$C$3) ^2)  D)  =(B4-$B$3) +(C4-$C$3)


A) =(B4-$B$3) ^2+(C4-$C$3) ^2
B) =SQRT((B4-$B$3) +(C4-$C$3) )
C) =SQRT((B4-$B$3) ^2+(C4-$C$3) ^2)
D) =(B4-$B$3) +(C4-$C$3)

Correct Answer

verifed

verified

How much are additional units of labor worth based on the following sensitivity report? How much are additional units of labor worth based on the following sensitivity report?

Correct Answer

verifed

verified

The straight line (Euclidean) distance between two points (X1, Y1) and (X2, Y2) is calculated as


A) X1 − Y1 + X2 − Y2
B) (X1 − X2) 2 + (Y1 − Y2) 2
C) The straight line (Euclidean)  distance between two points (X<sub>1</sub>, Y<sub>1</sub>)  and (X<sub>2</sub>, Y<sub>2</sub>)  is calculated as A)  X<sub>1</sub> − Y<sub>1</sub> + X<sub>2</sub> − Y<sub>2</sub> B)  (X<sub>1</sub> − X<sub>2</sub>) <sup>2</sup> + (Y<sub>1</sub> − Y<sub>2</sub>) <sup>2</sup> C)    D)
D) The straight line (Euclidean)  distance between two points (X<sub>1</sub>, Y<sub>1</sub>)  and (X<sub>2</sub>, Y<sub>2</sub>)  is calculated as A)  X<sub>1</sub> − Y<sub>1</sub> + X<sub>2</sub> − Y<sub>2</sub> B)  (X<sub>1</sub> − X<sub>2</sub>) <sup>2</sup> + (Y<sub>1</sub> − Y<sub>2</sub>) <sup>2</sup> C)    D)

Correct Answer

verifed

verified

The Lagrange multipliers can be used to


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

Correct Answer

verifed

verified

In solving the NLP problem, Solver produced a message "Solver cannot improve the current solution. All constraints are satisfied." This means that Solver found:


A) a local optimal solution
B) a global optimal solution
C) the objective function changed very slowly for the last few iterations
D) a degenerate model

Correct Answer

verifed

verified

D

An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk. The average return for the stocks is: An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk. The average return for the stocks is:   The covariance matrix for the stocks is:   Let: P<sub>i</sub> = proportion of total funds invested in i, i = A, B, C Formulate the NLP for this problem. The covariance matrix for the stocks is: An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk. The average return for the stocks is:   The covariance matrix for the stocks is:   Let: P<sub>i</sub> = proportion of total funds invested in i, i = A, B, C Formulate the NLP for this problem. Let: Pi = proportion of total funds invested in i, i = A, B, C Formulate the NLP for this problem.

Correct Answer

verifed

verified

A NLP problem can have nonlinear objective and a nonlinear constraints

Correct Answer

verifed

verified

​The main difference between shadow prices and Lagrange multipliers involves the range of RHS values over which the shadow price or Lagrange multiplier remains valid

Correct Answer

verifed

verified

​The solution procedure Solver uses to solve NLP problems is called the generalized reduced gradient (GRG) algorithm

Correct Answer

verifed

verified

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 constraint would you impose on this problem to ensure that at least one order is placed per year? 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 constraint would you impose on this problem to ensure that at least one order is placed per year?   A)  MAX B9 B)  B9 = 1 C)  B9 ≥ 1 D)  MIN B11


A) MAX B9
B) B9 = 1
C) B9 ≥ 1
D) MIN B11

Correct Answer

verifed

verified

The main difference between shadow prices and Lagrange multipliers is


A) the range of RHS values over which the Lagrange multipliers or the shadow prices remain valid
B) that shadow prices overestimate the impact of a small change in the RHS of the constraints on the objective function
C) that shadow prices underestimate the impact of a small change in the RHS of the constraints on the objective function
D) they are equivalent

Correct Answer

verifed

verified

A

Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft2 of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem. Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft<sup>2</sup> of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem.   The spreadsheet implementation of this formulation applies to the following questions.   -Refer to Exhibit 8.2. What formula would you place into cell B5 to calculate Total Floor Area? The spreadsheet implementation of this formulation applies to the following questions. Exhibit 8.2 The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft<sup>2</sup> of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem.   The spreadsheet implementation of this formulation applies to the following questions.   -Refer to Exhibit 8.2. What formula would you place into cell B5 to calculate Total Floor Area? -Refer to Exhibit 8.2. What formula would you place into cell B5 to calculate Total Floor Area?

Correct Answer

verifed

verified

What is the straight line (Euclidean) distance between the points (5,7) and (1, 11) ?


A) 2.83
B) 5.65
C) 8
D) 16

Correct Answer

verifed

verified

Showing 1 - 20 of 87

Related Exams

Show Answer