Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 beerYodel, 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.Bettywantstodecide on thenumberofgallonsofeachbrandofbeertoordersoastomake the most profit. Formulate a linear programming model for this problem. Define x1 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.

a. According to Excels sensitivity report for the previous formulated model (Eagle Tavern), the shadow price for the capacity constraint is

0

1.25

1.5

1.6

b. According to Excels sensitivity report for the previous formulated model (Eagle Tavern), which of the following statement is correct regarding the shadow price of budget constraint?

The shadow price for budget constraint is $.25

Increasing current budget does NOT result in profit increase for the tavern

The shadow price of $.25 is only valid when the taverns budget is between [$1100, +infinity]

The shadow price is zero because the tavern has used up all of its current budget

c. According to Excels sensitivity report for the previous formulated model (Eagle Tavern), the sensitivity range for the objective function coefficient of x3 (or Rainwater) is

[1.25, +infinity]

[1.5, +infinity]

[-infinity, 1.5]

[-infinity, 1.25]

d. According to Excels sensitivity report for the previous formulated model (Eagle Tavern), which of the following statement is false?

As long as the profit for each gallon of Yodel at the tavern is $1.25 or above, the optimal solution remains the same for the tavern

As long as the profit for each gallon of Shotz at the tavern is $1.25 or above, the optimal solution remains the same for the tavern

As long as the profit for each gallon of Rainwater at the tavern is $1.5 or below, the optimal solution remains the same for the tavern

As long as the storage capacity of the tavern is no more than 900 gallons, the optimal solution would suggest the tavern to offer all three brands of beer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Affordable Housing Finance

Authors: K. Hawtrey

2009th Edition

0230555187, 978-0230555181

More Books

Students also viewed these Finance questions