Linear Programing W/Intergers

profilecasnod
Home>Homework Answsers>Mathematics homework help>Numerical analysis homework help

I need answers to linear programing ? with Excel data showing work.

12. Betty Malloy, owner of the Eagle Tavern in Pittsburgh, is preparing for Super Bowl Sunday ,and she must determine how much beer to stock. Betty stocks three brands of beer�Yodel, Shotz, and Rainwater. The cost per gallon (to the tavern owner) of each brand is as follows:
Brand:                         Cost/Gallon
Yodel                          $1.50
Shotz                           .90
Rainwater                    .50
The tavern has a budget of $2,000 for beer for Super Bowl Sunday. Betty sells Yodel at a rate of $3.00 per gallon, Shotz at $2.50 per gallon, and Rainwater at $1.75 per gallon. Based on past football games, Betty has determined the maximum customer demand to be 400 gallons of Yodel, 500 gallons of Shotz, and 300 gallons of Rainwater. The tavern has the capacity to stock 1,000 gallons of beer; Betty wants to stock up completely. Betty wants to determine the number of gallons of each brand of beer to order so as to maximize profit..

 

b. Solve the model by using the computer.
 
Max1.5Y+1.65+1.25R
s.t.1.5+.95+5R<=2000
Y<=400 
S<=500 
R<=300 
Y+S+R+1000
Y,S,R>=0 
    • 10 years ago
    • 5
    Report issue
    Answer(2)
    profile
    Solvertutor
    4.0 (19)
    5.0 (2)
    Chat

    Purchase the answer to view it

    blurred-text
    • attachment
      linear_programing.docx
    • attachment
      linear_programing.xlsx
    profile
    smartwork
    3.5 (95)
     (Not rated)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mat_540_week_8_homework.xlsx
    Bids(0)