Answered step by step
Verified Expert Solution
Question
1 Approved Answer
USING EXCEL SOLVER: The city council of Fayetteville is in the process of approving the construction of a new 200,000 sqft cpnvention center. Two sites
USING EXCEL SOLVER: The city council of Fayetteville is in the process of approving the construction of a new 200,000 sqft cpnvention center. Two sites have ben proposed, and both require exercising the "eminent domain" law to acquire the property. The following table provides data about the proposed (contiguous) properties in both sites together with the acquisition cost. Site 1 Site 2 Property Area (1000 sqft) Cost (51000) Area (1000 sqft) Cost ($1000) 20 1000 80 2800 50 2100 1900 2350 2800 1850 2500 2950 Partial acquisition of property is allowed. At least 75% of property 4 must be acquired if site 1 is selected, and al least 50% of property 3 must be acquired if site 2 is selected. Although site 1 property is more expensive (on a per sqft basis), the construction cost is less than at site 2, because the infrastruction at site 1 is in a much better shape. Construction cost is $25 miliion at site 1 and $27 million at site 2. Which site should be selected, and why properties should be acquired? Find the solution using Solver
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started