Titanic Cruise Company plans on releasing it’s new “Superliner” cruise ship in time for the peak Spring cruise season. The Superliner is the largest and most expensive cruise ship ever built. The ship will be longer than 4 football fields. The ship has amenities that were never possible before on a commercial cruise ship. Features include rock climbing walls, skydiving simulators, an open air “atrium” version of Central Park, and nearly two dozen specialty restaurants. Sinbad the Sailor, the President and CEO of Titanic, wants to figure out which itinerary for the ship’s 17 day maiden voyage will be most profitable. He began by selecting a list of ports for the ship’s maiden voyage. He then projected 358,000 dollars daily onboard revenue for each port based on the maximum passenger capacity. In addition, he projected daily shore excursion revenue for different ports. Finally, he projected all of the daily expenses for each port including docking fees, local taxes, fuel costs, labor costs, and supplies and raw materials. Sinbad must consider two basic constraints when planning the itinerary. First, the ship must stay at least one day at each of the “target” ports listed because partial-day scheduling is not feasible. Second, the ship cannot spend more than 3 days in any individual target port because maritime regulations and individual port guidelines prevent longer stays. Use the information provided in the next table and help Sinbad find the most profitable itinerary for the ship’s maiden voyage. Port Daily Shore Excursion Revenue Daily Docking Fees Daily Local Taxes Daily Fuel Costs Daily Labor Costs Daily Supplies and materials Aruba $25,897 $14,258 $1,189 $1,237 $98,230 $76,390 Bahamas $41,777 $45,221 $635 $1,587 $107,250 $85,250 Barbados $35,789 $86,254 $526 $1,897 $102,370 $68,730 Jamaica $37,899 $52,899 $428 $2,750 $96,320 $88,220 Miami $25,894 $72,899 $1,199 $1,674 $102,390 $74,380 San Juan $42,879 $88,524 $458 $2,584 $106,450 $73,470 St Croix $32,874 $12,455 $850 $4,125 $104,350 $89,230 St Martin $24,897 $72,158 $254 $1,528 $102,890 $82,760 St Thomas $28,597 $62,548 $1,026 $1,458 $109,370 $78,390 St. John $38,974 $12,685 $899 $1,426 $93,480 $92,650

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...
icon
Related questions
Question

Titanic Cruise Company plans on releasing it’s new “Superliner” cruise ship in time for
the peak Spring cruise season. The Superliner is the largest and most expensive cruise
ship ever built. The ship will be longer than 4 football fields. The ship has amenities that
were never possible before on a commercial cruise ship. Features include rock climbing
walls, skydiving simulators, an open air “atrium” version of Central Park, and nearly two
dozen specialty restaurants.
Sinbad the Sailor, the President and CEO of Titanic, wants to figure out which itinerary for
the ship’s 17 day maiden voyage will be most profitable. He began by selecting a list of
ports for the ship’s maiden voyage. He then projected 358,000 dollars daily onboard
revenue for each port based on the maximum passenger capacity. In addition, he
projected daily shore excursion revenue for different ports. Finally, he projected all of the
daily expenses for each port including docking fees, local taxes, fuel costs, labor costs,
and supplies and raw materials.
Sinbad must consider two basic constraints when planning the itinerary. First, the ship
must stay at least one day at each of the “target” ports listed because partial-day
scheduling is not feasible. Second, the ship cannot spend more than 3 days in any
individual target port because maritime regulations and individual port guidelines prevent
longer stays. Use the information provided in the next table and help Sinbad find the most
profitable itinerary for the ship’s maiden voyage.

Port Daily Shore Excursion Revenue Daily Docking Fees Daily Local Taxes Daily Fuel Costs Daily Labor Costs Daily Supplies and materials
Aruba $25,897 $14,258 $1,189 $1,237 $98,230 $76,390
Bahamas $41,777 $45,221 $635 $1,587 $107,250 $85,250
Barbados $35,789 $86,254 $526 $1,897 $102,370 $68,730
Jamaica $37,899 $52,899 $428 $2,750 $96,320 $88,220
Miami $25,894 $72,899 $1,199 $1,674 $102,390 $74,380
San Juan $42,879 $88,524 $458 $2,584 $106,450 $73,470
St Croix $32,874 $12,455 $850 $4,125 $104,350 $89,230
St Martin $24,897 $72,158 $254 $1,528 $102,890 $82,760
St Thomas $28,597 $62,548 $1,026 $1,458 $109,370 $78,390
St. John $38,974 $12,685 $899 $1,426 $93,480 $92,650
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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.