# A company produces beer and Ale from hops. A gallon of beer requires 2 lb of California hops and 4lb of Florida hops. A gallon of beer sells for \$10…

A company produces beer and Ale from hops. A gallon of beer requires 2 lb of California hops and 4lb of Florida hops. A gallon of beer sells for \$10 and costs \$5 to produce. A gallon of ale requires 1 lb of California hops and 1lb of Florida hops. A gallon of ale sells for \$6 and costs \$4 to produce. A total of 30 lb of California hops and 50lbs of Florida hops are available. All beer and ale that is produced can be sold. marketing considerations require that at least 11 gallons of beer be produced. We need to formulate appropriate linear program and solve it using XL solver. Also need to answer following questions ?

a. What would company’s profit be if an additional constraint that required that the amounts of beer and ale to be produced were in the ratio of 11:6 is imposed ?

b. Suppose that an additional 5 lb of Florida hops were available at a total cost of \$5. Should the company obtain these ?

c. what would be companies profit be if at least 12 gallons of beer to be produced?

d.what would be the companies profit be if an additional constraint of beer and ale to be produced is at 11:6

e. Suppose an additional 5lb of florida hops is available at \$5, should the company purchase it explain?

f.what would be the optimal solution if a gallon of beer requires 2lb of california hops and 5lbs of florida hops