Question

The objective of a linear programming problem is to maximize 1.50A + 1.50B, subject to 3A + 2B ≤ 600, 2A + 4B ≤ 600, 1A + 3B ≤ 420, and A,B ≥ 0. Using Lingo software determine the optimal product mix for this problem? (include Lingo output)

Please use excel! Thanks!

Answer 1

Solution using LINGO is as follows:

Result:

A = 150

B = 75

Optimal objective value =  1.5*150+1.5*75

= 337.5

-----------------------------------------------------------------------

Using Excel

Create Excel model as follows:

Enter Solver Parameters as follows:

Click Solve to generate the result.

After that, values will appear automatically in yellow cells.

Result:

A = 150

B = 75

Objective function value = 1.5*150+1.5*75 = 337.5