Ra

Rank $3$: It wants to avoid using more than the $55$ acres that have been set aside for the project.

$374-$ Chapter $6$: Integer, Goal, and Nonlinear Programming Models

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?

must be completed within the $$3\mathrm{.}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.

$\backslash$table$[[$Facility$,\backslash$table$[[$Cost$],[$per Facility$]],\backslash$table$[[$Acres$],[$per Facility$]],\backslash$table$[[$People$],[$per Month$]],\backslash$table$[[$Annual$],[$Maintenance$]]],[$Basketball courts,$$300,000,3,700,$$$3,000$nk $3$: It wants to avoid using more than the $55$ acres that have been set aside for the project.

$374q,$ Chapter $6$: Integer, Goal, and Nonlinear Programming Models

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?

$****$Please show the EXCEL table and the sum formulas and where they belong$/$formatting of table. Please show screenshot of the SOLVER with constraints and all the inputs on the solver. If you show excel format and solver no doubtedly will leave a thumbs up$!******$