A Company Makes 2 Products a and B from 2

Essay

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?