he council wants to construct the facilities that will maximize expected daily usage by the residents of...

80.2K

Verified Solution

Question

General Management

he council wants toconstruct the facilities that will maximize expected daily usage bythe residents of the community subject to land and costllimitations. The usage, cost, and land data for each facility arelisted below. The community has $240,000 construction budget and 24arces of land. Because the swimming pool and tennis center must bebuilt on the same part ot the land parcel, however, only one ofthese two facilities can be constructed. Formulate an optimizationmode to assist the council in making its decision. Q1)Write out anyconstraints necessary for this problem in terms of the decisionvariables defined above. Q2) A very inluential citizens group hasmade it clear that it strongly prefers the athletic fielld to thegynnasim; thus the council will not approve the gymnasium unlessthe athletic field is also approved. How can the model be modifiedto incorporate this condition? Q3) The mayor has deicded that nomore than three of the facilities may be constructed wiht fundsfrom this year's budget. How can the model be modified toincorporate this comdition? Please use Solver(EXCEL) to define Q2and Q3

expected usage
facilitypeople/daycost($)Land requirements (acres)
swimming pool60070,0008
tennis center18020,0004
athletic field80050,00014
gymnassium300180,0006

Answer & Explanation Solved by verified expert
3.7 Ratings (460 Votes)
1 The objective is to maximize the usageMaximize Z 600X1 180X2 800X3 300X4Here X1 X2 X3 and X4 are construction of swimming pool tenniscenter athletic field and    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students