b)Use the Excel Solver to solve your model. State the optimal solution and the value of the objective function.

c) What modifications to your goal program are necessary if the second goal were restated as Maximize the worth of the new tax base? Note: For part (b) and (c), you do not need to rewrite the entire model, only mention the modifications that are relevant. No need to solve your model for this modification.

d) What modifications to your goal program are necessary if a fifth goal is added stating that If the first goal is not achieved, the amount of underachievement should not exceed 25 families? No need to solve your model for this modification.

The Midtown City Council is reviewing housing proposals for a new development aren. There is some dispute among various interest groups as to what goals should be sought. The Zoning Committee has recommended three types of housing: one family houses, deluxe condominiums, and apartments. There are 50 acres available for roning (.e. are designed for building these three types of housing) The Zoning Committee has compiled the following data for each type of housing: Housing Type One Family Deluxe Condo Apartment Land Usage (acres per unit) 25 20 125 Families Housed per Unit 1 4 6 Tax Base Generated per Unit $50,000 $100,000 S150,000 Taxes Required for City Services per Unit $4,000 $8,000 $10,000 The City Council hired a public-opinion survey company to assess the priorities of the citizens. Using this survey, the City Council has established the following goals (in decreasing order of priority): 1. Priority Level 1: Provide housing for at least 500 families. 2. Priority Level 2: Establish at least 55,000,000 worth of new tax base. 3. Priority Level 3: Taxes for city services should be limited to $250.000 4. Priority Level 4: Reserve at least 5 acres for a neighbourhood park area. The Midtown City Council is reviewing housing proposals for a new development aren. There is some dispute among various interest groups as to what goals should be sought. The Zoning Committee has recommended three types of housing: one family houses, deluxe condominiums, and apartments. There are 50 acres available for roning (.e. are designed for building these three types of housing) The Zoning Committee has compiled the following data for each type of housing: Housing Type One Family Deluxe Condo Apartment Land Usage (acres per unit) 25 20 125 Families Housed per Unit 1 4 6 Tax Base Generated per Unit $50,000 $100,000 S150,000 Taxes Required for City Services per Unit $4,000 $8,000 $10,000 The City Council hired a public-opinion survey company to assess the priorities of the citizens. Using this survey, the City Council has established the following goals (in decreasing order of priority): 1. Priority Level 1: Provide housing for at least 500 families. 2. Priority Level 2: Establish at least 55,000,000 worth of new tax base. 3. Priority Level 3: Taxes for city services should be limited to $250.000 4. Priority Level 4: Reserve at least 5 acres for a neighbourhood park area