A manager must decide on the mix of products to produce for the coming week. Product A requires three minutes per unit for moldi
ng, 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?
1 answer:
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.
You might be interested in