Explanation about the restaurant and excursion portion

Assignment Help Operation Management

Reference no: EM131724945

Problem. Captain Stubing of The Pacific Princess seeks to maximize the return for their scheduled 14-day tour of Europe and has a number of options available to him. He can ply his guests with alcohol, upsell them on fancier restaurant fare or include more expensive excursion options. These alternatives are not without tradeoffs, since different guests prefer different options, depending largely on their age and wherewithal. Among the limitations Captain Stubing must consider is the number of excursions; they must offer at least five different alternative excursions. In addition, the restaurant choices must be at least 12 major styles of cuisine and the bar themes down in The Grotto should rotate every other day for the 14 days. It's possible to rotate them twice a day, but any more than that and poor Isaac spends more time tearing down and setting up than he does mixing libations. Ideally, there should be at least one different bar theme for every cuisine type. The total budget for excursions, restaurants and bar has been set by the parent company at $150,000. It costs $1,500 to stock supplies for a major cuisine category, it costs $5,000 to include each different excursion, and it costs $900 to set up with a different bar theme. Based on historical data, Captain Stubing believes that each new bar setup will generate $1,500 profit, each new cuisine type will bring in $5,000, and each excursion type will generate $17,000 for the ship.

A. Formulate and solve the linear programming model for this situation.

B. Captain Stubing runs the LP model associated with the scenario and reads the following about the variable cells report. Provide an interpretation

Objective Coefficient Ranges:

Variable Variable Optima Value Current Coefficient Allowable Increase Allowable Decrease

Bar 12.00 1500.000 1560.000 INFINITY

Cuisine 12.00 5000.000 1660.000 INFINITY

Excursion 24.24 17000.00 INFINITY 3458.333

C. Using the Solution and Range Reports, provide as complete explanation about the Restaurant and Excursion portion.

D. Using Solution and Range Reports, indicate which of Captain Stubing's limitations (RHSs) are reducing his profit.

Reference no: EM131724945

Questions Cloud

Position of your employer with regard to rival companies : Where are we now? What is the competitive position of your employer with regard to rival companies? Good? Average? Weak? D

Ethnocentric-polycentric and geocentric approaches : What are the main advantages and disadvantages of the ethnocentric, polycentric, and geocentric approaches to staffing policy?

What is the sum of all free slack times for all activities : In total, what is the sum of all free slack (free float) times for all activities on a critical path of an arbitrary project?

What is the perma-cookie : Find an article pertaining to Verizon’s ‘Perma-Cookie’. What is the ‘Perma-Cookie’? What privacy implications does such a technology present?

Explanation about the restaurant and excursion portion : Using the Solution and Range Reports, provide as complete explanation about the Restaurant and Excursion portion.

The decision maker can shorten a project : PERT is best suited for. The decision maker can shorten a project. The term Program Management.

Understanding the income demographic for marketing : What is the relevance of understanding the Income demographic for marketing?

Organization is least equipped to deal : Financing risk often must be addressed when an organization is least equipped to deal with it and limited in its options.

Results for hypothetical project : Concerning management science (analytical) results for a 'hypothetical project',

User Account

All Pages