Multiple Choice
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.
Let X1 = demand for As and X2 = demand for Bs.Let P1 = price for As and P2 = 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 D4 of the spreadsheet?
A) =B4-$B$3) ^2+C4-$C$3) ^2
B) =SQRTB4-$B$3) +C4-$C$3) )
C) =SQRTB4-$B$3) ^2+C4-$C$3) ^2)
D) =B4-$B$3) +C4-$C$3)
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The Lagrange multipliers can be used to<br>A)
Q27: The main difference between linear (LP) and
Q36: In NLP a local optimum is best
Q38: If the "Standard LP/Quadratic Engine" option is
Q51: The global optimum solution to a nonlinear
Q54: A company wants to locate a
Q58: NLP problems which have slack in all
Q60: The GRG algorithm terminates when it<br>A)has completed
Q62: Exhibit 8.1<br>The following questions pertain to
Q75: The main difference between linear (LP) and