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
-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
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
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The Lagrange multipliers can be used to<br>A)
Q27: The main difference between linear (LP) and
Q38: If the "Standard LP/Quadratic Engine" option is
Q53: Exhibit 8.1<br>The following questions pertain to the
Q59: Exhibit 8.1<br>The following questions pertain to
Q60: The GRG algorithm terminates when it<br>A)has completed
Q62: Exhibit 8.1<br>The following questions pertain to
Q65: Exhibit 8.1<br>The following questions pertain to
Q66: A company wants to locate a new
Q68: An office supply company is attempting