Brewery has malt, hops and yeast available for brewing. There are 25 pounds of malt, 40 pounds of hops, and the pounds of yeast is 73.

Each barrel of Light uses 1 pound of malt, 2 pounds of hops, and 1 pound of yeast.

Each barrel of Dark uses 3 pounds of malt, 1 pound of hops, and 4 pounds of yeast.

Each barrel of Light yields a profit of $40.

Each barrel of Dark yields a profit of $30.

How many barrels of their Dark and Light beers should Brewery produce to maximize the brewery’s profit?

This problem can be formulated as a linear programming problem.

Requirements:

Provide the formulas for decision variables, objective functions and subject to functions.

Solve the problem using excel. Paste the outputs from screen shot.