Examlex

Solved

A Company Makes 2 Products a and B from 2

question 37

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.
 Product 12 Available resources  Labor hr/unit) 32150 Material ounces/unit) 12200 Profit$/unit) 76\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 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 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?


Definitions:

Cultural Audiences

Groups of people characterized by shared cultural backgrounds, values, and interests, targeted in various forms of media and communication.

Linear

Describes a process, relationship, or development that follows a straight line or sequence, often implying a direct proportionality or a single path.

Nonlinear

Not arranged in a straight line or sequence; in storytelling or data analysis, it refers to a narrative or process that does not follow a direct or sequential path.

Time Constraints

Limitations or restrictions on the amount of time available to complete a task or project.

Related Questions