please show steps and working

Find the optimal solution for each problem using Excel Solver 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 Salor, the President and CEO of Titanic, wants to figure out which itinerary for the ship's 17 day maiden voyage will bo 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 projectod all of the dally 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 Titanic Cruise Company \begin{tabular}{|c|r|r|r|r|r|r|} \hline Port & DailyShoreExcursionRevenue & DailyDockingFees & DailyLocalTaxes & DailyFuelCosts & DailyLaborCosts & DailySuppliesandmaterials \\ \hline Aruba & $25,897 & $14,258 & $1,189 & $1,237 & $98,230 & $76,390 \\ \hline Bahamas & $41,777 & $45,221 & $635 & $1,587 & $107,250 & $85,250 \\ \hline Barbados & $35,789 & $86,254 & $526 & $1,897 & $102,370 & $68,730 \\ \hline Jamaica & $37,899 & $52,899 & $428 & $2,750 & $96,320 & $88,220 \\ \hline Miami & $25,894 & $72,899 & $1,199 & $1,674 & $102,390 & $74,380 \\ \hline San Juan & $42,879 & $88,524 & $458 & $2,584 & $106,450 & $73,470 \\ \hline St Croix & $32,874 & $12,455 & $850 & $4,125 & $104,350 & $89,230 \\ \hline St Martin & $24,897 & $72,158 & $254 & $1,528 & $102,890 & $82,760 \\ \hline St Thomas & $28,597 & $62,548 & $1,026 & $1,458 & $109,370 & $78,390 \\ \hline St. John & $38,974 & $12,685 & $899 & $1,426 & $93,480 & $92,650 \\ \hline \end{tabular}