Using just the Constraints portion of the sensitivity report, indicate which of Captain Stubing's limitations are reducing his profit
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Bar/Food 0 1560 0 5 16
$E$11 Budget 150000 3.4 150000 1E+30 96200
$E$6 Excursions 24.24 0 5 19.24 1E+30
$E$7 Restaurant 12 -1660 12 16 5
$E$8 Bar Low 12 0 7 5 1E+30
$E$9 Bar High 12 0 28 1E+30 16
Answer: Three of the constraints have shadow prices of zero, meaning they are non-binding and thus do not limit his profit. The Bar/Food combination, that is the requirement that there should be at least one bar type for each cuisine type, is holding him back. The budget constraint also limits the profit, for each additional budget dollar he had to start the cruise, he could generate an additional $3.40. If the right hand side of these constraints were increased, then additional profit could be earned. The restaurant constraint also limits profit, but since the shadow price is negative, an additional increase of the RHS reduces the profit. If the number of cuisine type drops by one, the an additional $1,660 can be made.
You might also like to view...
Price is a communication tool
Indicate whether the statement is true or false
When an organization wants to engage in bottom-up change, ________ becomes pivotal in determining the success of the change
A) implementing the action B) diagnosing the organization C) institutionalizing action research D) determining the desired future state