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.

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

Answer 1

shore excursio docking local fee taxes days to port fuel cost labour supply r total cost revenue total profit revenue each day rank n be spent revenue 4 1189 635 526 191304 239943 6 98230 107250 102370 96320 2 25897 41777 355789 378999 25894 42879 32874 24897 28597 14258 45221 86254 52899 72899 82524 12455 aruba bahamas barbados jamaica miami san juan st croix st martin st thoas st john 1237 1587 1897 2750 1674 2584 4125 1528 1458 76390 85250 68370 88220 74380 73470 89230 428 1199 458 850 254 2 1 3 3 1 358000 358000 358000 358000 358000 358000 358000 358000 1 9 192593 159834 454372 496382 131352 135393 179864 123307 259417 240617 252542 265486 211010 259590 252792 201140 102390 106450 104350 383897 399777 713789 736999 383894 400879 390874 382897 386597 396974 1 7 5 1 72158 102890 82760 10 1 62548 1026 109370 78390 133805 8 1 358000 358000 38974 12685 899 1426 93480 92650 195834 3 3