The Bronx division of the New York City Economic Development Corporation (EDC) is considering an expansion...

  

Transcribed Image Text:

The Bronx division of the New York City Economic Development Corporation ("EDC") is considering an expansion of entrepreneurial programs into local communities. Three locations are available for incubators: a small start-up site in the East Bronx, a medium size site for more mature ventures in Central Bronx, and a larger site for existing and new ventures in the South Bronx. The following table summarizes the number of jobs, site start-up costs, and annual returns associated with an average venture at each site: Jobs Costs Returns East Bronx 9 $150,000 $85,000 Central Bronx 17 $275,000 $125,000 South Bronx 35 $450,000 $175,000 The EDC has $2,000,000 available to pay start-up costs for new operations in the coming year. Additionally, there are five possible ventures for the East Bronx, seven possible ventures for the Central Bronx location, and three possible ventures for the South Bronx. The EDC wants to plan its expansion in a way that maximizes annual returns and the number of jobs created. 1. Formulate, implement in a spreadsheet, and interpret the construction of an MOLP for this problem. 2. Determine the best possible value for each objective in the problem. Compare and contrast the results across objectives. 3. Implement a goal programming version of the model to determine the solution that minimizes the maximum percentage deviation from the optimal objective function values. What solution do you obtain? Interpret this solution versus each of the results from separate objective values in question 2. 4. Suppose EDC management considers maximizing jobs three times as important as maximizing returns. What solution does this suggest and why? Include in your discussion the opportunity costs of objectives and the value of increasing or decreasing maximum number of ventures for each site. The Bronx division of the New York City Economic Development Corporation ("EDC") is considering an expansion of entrepreneurial programs into local communities. Three locations are available for incubators: a small start-up site in the East Bronx, a medium size site for more mature ventures in Central Bronx, and a larger site for existing and new ventures in the South Bronx. The following table summarizes the number of jobs, site start-up costs, and annual returns associated with an average venture at each site: Jobs Costs Returns East Bronx 9 $150,000 $85,000 Central Bronx 17 $275,000 $125,000 South Bronx 35 $450,000 $175,000 The EDC has $2,000,000 available to pay start-up costs for new operations in the coming year. Additionally, there are five possible ventures for the East Bronx, seven possible ventures for the Central Bronx location, and three possible ventures for the South Bronx. The EDC wants to plan its expansion in a way that maximizes annual returns and the number of jobs created. 1. Formulate, implement in a spreadsheet, and interpret the construction of an MOLP for this problem. 2. Determine the best possible value for each objective in the problem. Compare and contrast the results across objectives. 3. Implement a goal programming version of the model to determine the solution that minimizes the maximum percentage deviation from the optimal objective function values. What solution do you obtain? Interpret this solution versus each of the results from separate objective values in question 2. 4. Suppose EDC management considers maximizing jobs three times as important as maximizing returns. What solution does this suggest and why? Include in your discussion the opportunity costs of objectives and the value of increasing or decreasing maximum number of ventures for each site.

Answer rating: 100% (QA)

1 The EDC could construct an MOLP to maximize annual returns and the number of jobs created as follows Objective Maximize Z 85000X1 125000X2 175000X3 ... View the full answer