please can you help solve this in excel solver showing screenshots and explanation on how the answers were achieved, what was input in solver etc

Titanic Cruise Company plans on releasing its 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 ships 17 day maiden voyage will be most profitable. He began by selecting a list of ports for the ships 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 ships maiden voyage.

Port	Projected Revenue	Daily Shore Revenue	Docking Fees	Local Taxes	Fuel Costs	Labor Costs	Supplies & Materials	Total Expenses	Revenue	Profit
Aruba	383897	25897	14258	1189	1237	98230	76390	191304	358000	166696
Bahamas	399777	41777	45221	635	1587	107250	85250	239943	358000	118057
Barbados	393789	35789	86254	526	1897	102370	68730	259777	358000	98223
Jamaica	395899	37899	52899	428	2750	96320	88220	240617	358000	117383
Miami	383894	25894	72899	1199	1674	102390	74380	252542	358000	105458
San Juan	400879	42879	88524	458	2584	106450	73470	271486	358000	86514
St Croix	370455	12455	12455	850	4125	104350	89230	211010	358000	146990
St Martin	430158	72158	72158	254	1528	102890	82760	259590	358000	98410
St Thomas	420548	62548	62548	1026	1458	109370	78390	252792	358000	105208
St John	396974	38974	12685	899	1426	93480	92650	201140	358000	156860