Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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 shown in table below. 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 decide on the number of gallons of each brand of beer to order so as to make the most profit. Formulate a linear programming model for this problem. Define x₁ as the number of gallons of Yodel to order, x2 as the number of gallons of Shotz to order, x3 as the number of gallons of Rainwater to order, and Z as the total profit. Which of the following model formulations is correct? Brand Cost/Gallon Yodel $1.50 Shotz 0.90 Rainwater 0.50

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 shown in table below. 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 decide on the number of gallons of each brand of beer to order so as to make the most profit. Formulate a linear programming model for this problem. Define x₁ as the number of gallons of Yodel to order, x2 as the number of gallons of Shotz to order, x3 as the number of gallons of Rainwater to order, and Z as the total profit. Which of the following model formulations is correct? Brand Cost/Gallon Yodel $1.50 Shotz 0.90 Rainwater 0.50

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
Only need help with the budget constraint
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 shown in table below. 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 decide on the number of gallons of each brand of beer to order so as to make the most profit. Formulate a linear programming model for this problem. Define x₁ as the number of gallons of Yodel to order, x2 as the number of gallons of Shotz to order, x3 as the number of gallons of Rainwater to order, and Z as the total profit. Which of the following model formulations is correct? Brand Cost/Gallon Yodel $1.50 Shotz 0.90 Rainwater 0.50
Transcribed Image Text: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 shown in table below. 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 decide on the number of gallons of each brand of beer to order so as to make the most profit. Formulate a linear programming model for this problem. Define x₁ as the number of gallons of Yodel to order, x2 as the number of gallons of Shotz to order, x3 as the number of gallons of Rainwater to order, and Z as the total profit. Which of the following model formulations is correct? Brand Cost/Gallon Yodel $1.50 Shotz 0.90 Rainwater 0.50
According to Excel's sensitivity report for the previous formulated model (Eagle Tavern), which of the following statement is correct regarding the shadow price of budget constraint? O The shadow price for budget constraint is $.25 O Increasing current budget does NOT result in profit increase for the tavern O The shadow price of $.25 is only valid when the tavern's budget is between [$1100, +infinity] O The shadow price is zero because the tavern has used up all of its current budget
Transcribed Image Text:According to Excel's sensitivity report for the previous formulated model (Eagle Tavern), which of the following statement is correct regarding the shadow price of budget constraint? O The shadow price for budget constraint is $.25 O Increasing current budget does NOT result in profit increase for the tavern O The shadow price of $.25 is only valid when the tavern's budget is between [$1100, +infinity] O The shadow price is zero because the tavern has used up all of its current budget
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS