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...
Danielle works at a leading restaurant. She is scared of making mistakes at her workplace, so she is very keen on paying attention to details. She also prioritizes quality in her work. In the context of Inscape's DiSC assessment, she would most likely score high in
A. influence. B. dominance. C. conscientiousness. D. steadiness. E. humility.
Britta is trying to measure her salon's productivity during the first quarter. For this period, she should divide _______ by the costs of her staff, loans, materials, and utility bills.
A. the number of clients B. the average daily receipts C. her budgeted costs D. the total salon services and products sold E. her projected revenue
For service-oriented businesses, pricing is determined using cost-based approaches that add the cost of overhead to materials, parts, and labor via markup percentages
Indicate whether the statement is true or false
The key to good quality control is to have periodic inspection points staffed by qualified quality control personnel
Indicate whether the statement is true or false