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
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 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images