ibiza miami antalya Available time in day Uras is planning to vacation in the famous holiday...

Transcribed Image Text:

ibiza miami antalya Available time in day Uras is planning to vacation in the famous holiday destinations of Ibiza, Miami, and Antalya. The transportation expenses are covered by his employer, YTS Textile. Uras aims to stay in nice hotels, go on yacht trips, and take diving courses in these places. However, he wants to spend as little money as possible on these activities. Uras wants to visit at least 3 beaches, go on 2 yacht trips, and take 3 diving courses during his available time, which is 14 days, 6 days, and 10 days respectively. What is the minimum cost for Uras' vacation given these preferences? The model (LP and/or GP) and data Solution development (using Excel Solver)!!!!!!!! Solve this problem with excel solver !!!!! Sensitivity analysis Beach cost for each Yatch travel cost for each Dive cost for each Ibiza Miami $ 120 $ 80 $ 140 $ 100 $ 120 $ 160 Antalya $ 80 $ 90 $ 170 Number of beach in place: needed time in day for each Number of yatch trips in places needed time in day for each Number of diving courses in places needed time in day for each 3 4 2 2 5 2 14 1 2 2 2 2 2 6 3 2 3 3 3 2 10 ibiza miami antalya Available time in day Uras is planning to vacation in the famous holiday destinations of Ibiza, Miami, and Antalya. The transportation expenses are covered by his employer, YTS Textile. Uras aims to stay in nice hotels, go on yacht trips, and take diving courses in these places. However, he wants to spend as little money as possible on these activities. Uras wants to visit at least 3 beaches, go on 2 yacht trips, and take 3 diving courses during his available time, which is 14 days, 6 days, and 10 days respectively. What is the minimum cost for Uras' vacation given these preferences? The model (LP and/or GP) and data Solution development (using Excel Solver)!!!!!!!! Solve this problem with excel solver !!!!! Sensitivity analysis Beach cost for each Yatch travel cost for each Dive cost for each Ibiza Miami $ 120 $ 80 $ 140 $ 100 $ 120 $ 160 Antalya $ 80 $ 90 $ 170 Number of beach in place: needed time in day for each Number of yatch trips in places needed time in day for each Number of diving courses in places needed time in day for each 3 4 2 2 5 2 14 1 2 2 2 2 2 6 3 2 3 3 3 2 10