please include how to solve in excel as well !

6-34 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. COST ACRES PEOPLE ANNUAL PER PER PER MAINTEN- FACILITY FACILITY FACILITY MONTH ANCE Basketball $300,000 3 700 $3.000 courts Baseball fields $250,000 5 1,000 $6,000 Playgrounds $ 75,000 2 800 $3,000 Soccer fields $175,000 3 1,200 $7.000 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