A manufacturing plant is producing the following products using available raw materials shown in the below...

   

Transcribed Image Text:

A manufacturing plant is producing the following products using available raw materials shown in the below Table. Resource usage per unit product Resource Available resource Product 1 Product 2 Raw material 1 1 3 Raw material 2 1 1 8 4 Unit profit 1 2 Company aims to determine the optimal number of products to be produced in order to maximize the total profit. Formulate the problem using algebraic method. a) b) Use the Excel solver I A manufacturing plant is producing the following products using available raw materials shown in the below Table. Resource usage per unit product Resource Available resource Product 1 Product 2 Raw material 1 1 3 Raw material 2 1 1 8 4 Unit profit 1 2 Company aims to determine the optimal number of products to be produced in order to maximize the total profit. Formulate the problem using algebraic method. a) b) Use the Excel solver I