This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 02/13/2011 for the course ADM 2302 taught by Professor El during the Fall '05 term at University of Ottawa.
 Fall '05
 EL

Click to edit the document details