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}{rllr}
\text { Product } & 1 & 2 & \text { Available 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 units of product 1.
Goal 2: Produce approximately 70 units of product 2.Goal 3: Achieve a profit over $400.
Goal 4: Consume less than 150 hours of labor Goal 5: Consume less than 200 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}{rllr}
\text { Product } & 1 & 2 & \text { Available 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 units of product 1.
Goal 2: Produce approximately 70 units of product 2.Goal 3: Achieve a profit over $400.
Goal 4: Consume less than 150 hours of labor Goal 5: Consume less than 200 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}{rllr}
\text { Product } & 1 & 2 & \text { Available 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 units of product 1.
Goal 2: Produce approximately 70 units of product 2.Goal 3: Achieve a profit over $400.
Goal 4: Consume less than 150 hours of labor Goal 5: Consume less than 200 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