M9_2. Local county must decide which type of facilities to construct to increase tourism. Four new facilities have been proposed - an equestrian center, an axe throwing center, a bowling alley, and a pickle ball courts. The council wants to construct facilities that will maximize the expected daily usage by residents of the community, subject to land and cost limitations. The expected daily usage and cost and land requirements for each facility is shown below: The community has a $100,000 construction budget and 10 acres of land. Because the equestrian center and pickle ball courts must be built on the same land parcel, only one of these facilities can be constructed. The county wants to know which of these facilities to construct to maximize the expected daily usage. SOLUTION: The optimal solution, the value of the expected daily usage, should be 325 . All decision variables should be 0 or 1 (this is a constraint). Be sure to use standard LP template and include the formulation in your Excel file. Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos. Questions: a) Which facilities should be constructed? Explain. b) Did the county use their complete budget? Explain. c) There has been a large resurgence in horseback riding and the new estimate for usage is 150 people per day. Would this change your recommendation of facilities to be constructed? How does this impact your budget? Explain. Use the standard LP Template.xlsx provided to you. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. See the diagram of a correct solution provided to you on the first problem. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. M9_2. Local county must decide which type of facilities to construct to increase tourism. Four new facilities have been proposed - an equestrian center, an axe throwing center, a bowling alley, and a pickle ball courts. The council wants to construct facilities that will maximize the expected daily usage by residents of the community, subject to land and cost limitations. The expected daily usage and cost and land requirements for each facility is shown below: The community has a $100,000 construction budget and 10 acres of land. Because the equestrian center and pickle ball courts must be built on the same land parcel, only one of these facilities can be constructed. The county wants to know which of these facilities to construct to maximize the expected daily usage. SOLUTION: The optimal solution, the value of the expected daily usage, should be 325 . All decision variables should be 0 or 1 (this is a constraint). Be sure to use standard LP template and include the formulation in your Excel file. Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos. Questions: a) Which facilities should be constructed? Explain. b) Did the county use their complete budget? Explain. c) There has been a large resurgence in horseback riding and the new estimate for usage is 150 people per day. Would this change your recommendation of facilities to be constructed? How does this impact your budget? Explain. Use the standard LP Template.xlsx provided to you. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. See the diagram of a correct solution provided to you on the first problem. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit