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.

AutoSave DH titanic spreadsheet - Compatibility Mode - Saved Search Brandon Gentile BG File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial ~ A E 49 10 General Insert 3X Delete v 3 Paste BIU Ideas $ - % % 48 58 -" Sensitivity Conditional Format as Cell Formatting Table Styles Styles L! Format Sort & Find & Filter Select Editing Clipboard Font Is Alignment Number Ideas Sensitivity A1 fx Port A E F G . 1 J M N 0 R R B Daily Shore Excursion Revenue $25,897 $41,777 $35,789 $ $37,899 $25,894 $42,876 $32,874 $24.897 $28,597 $38,974 C Daily Docking Fees $14,258 $45,221 $86,254 $52,899 $72,899 $88,524 $12.455 $72,158 $62,548 $12,685 D Daily Local Taxos $1,189 $635 $526 $428 $1,199 $458 $850 $254 $1.026 $899 Daily Fuel Daily Labor Daily Supplies Costs Costs and materials $1,237 $98,230 $ $76,390 $1,587 $107.250 $85,250 $1,897 $102,370 $68,730 $2,750 $96,320 $88,220 $1,674 $102,390 $74,380 $2,584 $106,450 $73,470 $4,125 $104,350 $89.230 $1,528 S102.890 $82.760 $1,458 $109,370 $78,390 $1.426 $93,480 $92,650 Port 1 2 Aruba 3 Bahamas 4 Barbados Jamaica 6 Miami 7 San Juan 8 St Croix 9 St Martin 10 St Thomas 11 St. John 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Type here to search O 12:43 PM 9/16/2020