use excel and make a spread sheet

Determine the number of components produced and purchased next month, according to these ranked goals. Pendelton County plans to develop several new recreational facilities that must be completed within the $3.5 million budget. A survey of county resi- dents has resulted in information about the types of facilities that county resi- dents 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. Facility Cost per Facility Acres per Facility People per Month Annual Maintenance Basketball courts Baseball fields Playgrounds Soccer fields $300,000 $250,000 $ 75,000 $175,000 3 5 2 3 700 1,000 800 1,200 $3,000 $6,000 $3,000 $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