Examlex

Solved

Exhibit 81
the Following Questions Pertain to the Problem and Spreadsheet

question 67

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


Definitions:

Cleaning Staff

Personnel employed to maintain cleanliness and hygiene in facilities through routine and specialized cleaning tasks.

HIPAA

The Health Insurance Portability and Accountability Act, legislation that provides data privacy and security provisions for safeguarding medical information.

Minimum Necessary

A principle in healthcare and privacy laws requiring the least amount of personal information to be used or disclosed for a specific purpose.

Related Questions