Please Solve using Excel and Solver

The Cruise Bob and Carolyn are taking a cruise for their 25th anniversary. Their cruise would port out of New Orleans and promised seven days with a panoply of excursions in Jamaica, Cozumel, and Grand Cayman. A list of excursions at each site and key features of each appear in the table. The excursions were all day affairs, so it was possible to engage in only one per port. The cruise ship sailed at night and docked at each of these three ports at the crack of dawn. By dinner time, the ship was on its way to the next port and next set of excursions. The couple was energetic and active for a pair of 52-year-olds, and while enjoying an upper middle class lifestyle, they didn't want to spend money on excursions that might be better spent on tacky souvenirs. The couple therefore budgeted $250 for the excursions - the prices shown are per couple, so for example, the $60 will pay for both of them to fill up on jerk chicken and mannish water. For each of the duplicate excursions (e.g., snorkeling is offered in all three ports), the couple researched the quality of the activity and ranked the excursion among the available alternatives, with higher numbers indicating better quality. Thus, snorkeling in Jamaica is better than in Cozumel, and snorkeling in Cozumel is better than in Grand Cayman. For the unique experiences, i.e., the turtle farm, the default rating was 3. The couple would like to know which excursions to select for each port in order to have the best cruise experience overall Cost $100 $95 $120 $60 $110 Site Rating Activity Jamaica (J) 3 snorkeling (S) Jamaica (J) 1 party island (P) Jamaica (J) 2 horseback ride (H) Jamaica (J) 3 local cuisine (L) Cozumel (C) 2. snorkeling (S). Cozumel (C) 3 party island (P) Cozumel (C) 1 horseback ride (H) Cozumel (C) 2 local cuisine (L) Cozumel (C) 3 tequila tasting (Te) Grand Cayman (G) 1 snorkeling (S) Grand Cayman (G) 2 party island (P) Grand Cayman (G) 3 horseback ride (H) Grand Cayman (G) 1 local cuisine (H) Grand Cayman (G) 3 turtle farm (Tu) $55 $70 $90 $130 $90 $60 $110 $ 130 $95