California Tours is planning a group bus trip for the following candidate cities in the table below.
Question:
California Tours is planning a group bus trip for the following candidate cities in the table below. Also included are the total costs for the group to visit those cities on the tour.
City | Cost ($) |
San Francisco (SF) | 5000 |
Oakland (OK) | 4500 |
Palo Alta (PA) | 3600 |
San Jose (SJ) | 4100 |
San Mateo (SM) | 3500 |
Concord (CO) | 2500 |
Santa Cruz (SC) | 3200 |
Monterey (MN) | 4000 |
To plan the trip, three prioritized goals are listed below, in order of importance.
P1: Avoid spending more than $15000 for the total trip.
P2: Visit at least 5 cities.
P3: Include San Mateo in the tour.
a. Formulate a goal programming model that will help to determine the number of cities to include in the tour.
b. Find the optimal solution using Solver. Use Pre-emptive goal programming. (Provide a printout of the Answer report and the Excel spreadsheet formulation). Also include a managerial statement that describes verbally the results.
Expert Answer:
