Question

A manager must decide on the mix of products to produce for the coming week. Product A requires three minutes per unit for molding, two minutes per unit for painting, and one minute per unit for packing. Product B requires two minutes per unit for molding, four minutes per unit for painting, and three minutes per unit for packing. There will be 600 minutes available for molding, 600 minutes for painting, and 420 minutes for packing. Both products have profit contributions of $1.50 per unit. Formulate this problem as a linear programming problem. (You do not need to solve this problem). If you were solving this problem using Solver, what would you put in the target cell, changing cells? How are you going to enter the constraints?

Answer 1

Answer:

Check the explanation

Explanation:

Going by the question above we will have to first work on the

Formulation of LP:

Maximize profit

Z = 1.5A+1.5B where A - number of units of product A and B - number of units of product B

subject to constraints -

600 minutes available for molding

3A+2B <=600 ---> Molding constraint---> 1

600 minutes available for painting

2A+4B<=600 ---> Painting constraint---> 2

420 minutes available for packing

A+3B<=420 ---> Packing constraint---> 3

A, B, C >=0 ---> Non-negative constraint ---> 4

b) Solution with the help of Excel solver:

Target cell will be the RHS or profit value of the objective function as we are maximizing the profit.

Changing cells will be A and B ---> number of units of products

Constraints will be entered as below. The same are also listed in part A (1,2,3,4).

The attached images below are the formulation.