Unformatted text preview: 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. (Provide a printout of the Answer report and the Excel spreadsheet formulation). Fall 2010 Page 1...
View Full Document
- Fall '05
- San Francisco, San Francisco Bay Area, San Mateo, following candidate cities, Integer/Binary Programming ADM2302, individual original submission