A company makes 2 products A and B from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table.
$\begin{array}{lllc}
\text { Product } & 1 & 2 & \text { Avalable resources } \
\hline \text { Labor (hr/unit) } & 3 & 2 & 150 \
\text { Material (ounces/unit) } & 1 & 2 & 200 \
\text { Profit(\$/unit) } & 7 & 6 &
\end{array}$
Management has developed the following set of goals
Goal 1: Produce approximately 40 urits of product 1
Goal 2: Produce approxinately 70 urits of product 2
Goal 3: Achieve a profit aver $400.
Goal 4: Consume less than 150 hours of labor
Goal 5:Consume lesse than 200 \text ounces of material Based on this GP formulation of the problem and the associated optimal integer solution what values should go in cells B2:F16 of the following Excel spreadsheet?

Question

A company makes 2 products A and B from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table.
 $\begin{array}{lllc}
\text { Product } & 1 & 2 & \text { Avalable resources } \
\hline \text { Labor (hr/unit) } & 3 & 2 & 150 \
\text { Material (ounces/unit) } & 1 & 2 & 200 \
\text { Profit(\$/unit) } & 7 & 6 &
\end{array}$
 Management has developed the following set of goals
 Goal 1: Produce approximately 40 urits of product 1
Goal 2: Produce approxinately 70 urits of product 2
Goal 3: Achieve a profit aver $400.
Goal 4: Consume less than 150 hours of labor
Goal 5:Consume lesse than 200 \text ounces of material  Based on this GP formulation of the problem and the associated optimal integer solution what values should go in cells B2:F16 of the following Excel spreadsheet?

Quizplus · Accepted Answer

The Answer of A company makes 2 products A and B from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table.
 $\begin{array}{lllc}
\text { Product } & 1 & 2 & \text { Avalable resources } \
\hline \text { Labor (hr/unit) } & 3 & 2 & 150 \
\text { Material (ounces/unit) } & 1 & 2 & 200 \
\text { Profit(\$/unit) } & 7 & 6 &
\end{array}$
 Management has developed the following set of goals
 Goal 1: Produce approximately 40 urits of product 1
Goal 2: Produce approxinately 70 urits of product 2
Goal 3: Achieve a profit aver $400.
Goal 4: Consume less than 150 hours of labor
Goal 5:Consume lesse than 200 \text ounces of material  Based on this GP formulation of the problem and the associated optimal integer solution what values should go in cells B2:F16 of the following Excel spreadsheet?

A Company Makes 2 Products a and B from 2