Solved

Exhibit 81
the Following Questions Pertain to the Problem and Spreadsheet

Question 29

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.
 Product  A  B  Avalable resources  Labor hr/unit)  32150 Material ounces/unit)  12200 Manufacturing cost$/unit)  2518 Demand units)  20.10P130.07P2\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 X1 = demand for As and X2 = demand for Bs.Let P1 = price for As and P2 = price for Bs
 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 X<sub>1 </sub>= demand for As and X<sub>2 </sub>= demand for Bs.Let P<sub>1 </sub>= price for As and P<sub>2 </sub>= 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 <sup>Number to make: X</sup><sub>1</sub><sub> </sub>9.42 0 $C$4 <sup>Number to make: X</sup><sub>2</sub><sub> </sub>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
-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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents