Pendelton County plans to develop several new recreational facilities that must be completed within the $3.5 million

Question:

Pendelton County plans to develop several new recreational facilities that must be completed within the $3.5 million budget. A survey of county residents has resulted in information about the types of facilities that county residents would like to see built, as described in the following table. The table also shows the cost to construct and maintain each facility, the acres each facility will require, and the average monthly usage of each facility. The county has decided that at least 15 facilities will be built and has set aside 55 acres to be used for construction.
Pendelton County plans to develop several new recreational facilities that

The county has also established the following list of ranked goals:
Rank 1: It would like to spend the entire budget. Rank 2: It would like to build enough facilities so that 15,000 people or more each month can use them.
Rank 3: It wants to avoid using more than the 55 acres that have been set aside for the project.
Rank 4: It would like to avoid spending more than $80,000 per year on maintenance costs for the new facilities.
How many of each type of facility should be constructed?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: