Purchase Solution

Formulate Linear Programming Model & Solve using Computer

Not what you're looking for?

Ask Custom Question

Betty Malloy owner of the Eagle Tavern in Pittsburgh, is preparing for Super Bowl Sunday, and the must determine how much beer to stock. Betty stocks three brand of beer-Yodel, Shortz,and Rainwater. The cost per gallon (to the tavern owner) of each brand is as follow:

Brand Cost/Gallon
------------------------
Yodel $1,50
Shotz 0.90
Rainwater 0.50

The tavern has a budget of $2,000 for beer for Super Bowl Sunday. Betty sell Yodel at a rate of $3.00 per gallon, Shotz at $2.50 per gallon. Rainwater at $1.75 per gallon. Based on past football games, Betty has determined the maximum customer demand to be 400 gallon of Yodel, 500 gallon of Shotz. and 300 gallon of Rainwater. The tavern has the capacity to stock 1,000 gallons of beer; Betty want to stock up completely. Betty wants to determine the number of gallon of each brand of beer to order so as to maximize profit.

a Formulate a linear programming model for this problem
b Solve the model by using the computer;

Purchase this Solution

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.

Purchase this Solution


Free BrainMass Quizzes
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts