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. Management has developed the following set of goals Based on the following GP formulation of the problem, and the associated optimal solution, what formulas should go in cells D6:F6, B9:F9, and B16 of the following Excel spreadsheet? NOTE: Formulas are not required in all of these cells.

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.  Management has developed the following set of goals  Based on the following GP formulation of the problem, and the associated optimal solution, what formulas should go in cells D6:F6, B9:F9, and B16 of the following Excel spreadsheet? NOTE: Formulas are not required in all of these cells.  ​

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.  Management has developed the following set of goals  Based on the following GP formulation of the problem, and the associated optimal solution, what formulas should go in cells D6:F6, B9:F9, and B16 of the following Excel spreadsheet? NOTE: Formulas are not required in all of these cells.  ​

A Company Makes 2 Products a and B from 2