Problem 4 (20 points) California Tours is planning a group bus trip that for the

Question

Problem 4 (20 points) California Tours is planning a group bus trip that 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 (S) San Francisco (SF) 5000 Oakland (OK) 4500 3600 4100 3500 2500 3200 4000 Palo Alta (PA) San Jose (SJ) San Mateo (SM) Concord (Co Santa Cruz (SC) Monterey (MN 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. Formulate a goal programming model that will help to determine the number of cities to include in the tour. (12 points) Find the optimal solution using Solver. (Provide a printout of the Answer report and the Excel spreadsheet formulation). (6 points) Include a managerial statement that describes verbally the results. (2 points) a. b. c.

Explanation / Answer

Given conditions are :

1) Avoid spending more than $15000 for the total trip.

2) Visit at least 5 cities.

3) Include San Mateo in the tour.

But from the given chart i see that the minimum cost is :

$2500(Concord)+$3200(Santa Cruz)+$3500(San Mateo)+$3600(Palo Alta)+$4000(Monterey) = $16800.

So, all the given conditions are not satisfied here.

Therefore, it is impossible to formulate a goal programming model.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.