Their cruise would port out of New Orleans and promised seven days with a panoply of excursions

Fantastic news! We've Found the answer you've been seeking!

Question:

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.

Part 1

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 the a 3.

Site	Rating	Activity	Cost
Jamaica	3	snorkeling	$100
Jamaica	1	party island	$95
Jamaica	2	horseback ride	$120
Jamaica	3	local cuisine	$60
Cozumel	2	snorkeling	$110
Cozumel	3	party island	$55
Cozumel	1	horseback ride	$70
Cozumel	2	local cuisine	$90
Cozumel	3	tequila tasting	$130
Grand Cayman	1	snorkeling	$90
Grand Cayman	2	party island	$60
Grand Cayman	3	horseback ride	$110
Grand Cayman	1	local cuisine	$130
Grand Cayman	3	turtle farm	$95

What is an appropriate objective function for this vacation?

What is an appropriate objective function and constraints for this vacation?

Part 2

The first day on the cruise was a "day at sea" meaning no port of call, and only the amenities onboard for amusement. Restless and uncomfortably full after seven trips through the buffet, the management scientist gambled away most of his vacation money at the onboard casino. The excursions would be a necessity, but now it became less important to maximize the joy of the excursions and more vital to get off the boat as cheaply as possible while still staying busy at the three pots of call. What is an appropriate objective function for this modified cruise vacation?