Explore BrainMass

Maximizing Bloomington Brewery's Revenue Using Solver

Bloomington Brewery produces beer and ale. Beer sells for $5 per barrel, and ale sells for $2 per barrel. Producing a barrel of beer requires 5 pounds of corn and 2 pounds of hops. Producing a barrel of ale requires 2 pounds of corn and 1 pound of hops. The brewery has 60 pounds of corn and 25 pounds of hops.

A. use solver to maximize Bloomington Brewery's revenue.

© BrainMass Inc. brainmass.com June 19, 2018, 12:33 pm ad1c9bdddf

Solution Summary

This posting contains solution to this linear programming problem using excel solver.