A medical center would like to establish a satellite clinic to provide medical care for residents living in recently developed suburbs. Four potential sites are under consideration. Land acquisition, building, and equipment costs have been evaluated, as have population, education level, median household income, and percentage insured. As can be observed from the following table, the factors are reported in different measurement units (metric), so they must be either converted to the same metric or analyzed using other methods, such as the multi-attribute procedures.

	Zip Codes of Potential Sites
Factors	23059	23233	23112	23832
Land	$ 350,000	$ 390,000	$ 245,000	$ 200,000
Building	$ 450,000	$ 450,000	$ 435,000	$ 425,000
Operating	$ 235,000	$ 240,000	$ 220,000	$ 205,000
Pop. Size	15,683	50,296	38,660	25,775
Elderly	7%	12%	6%	5%
Education	92%	96%	93%	90%
Income	$ 73,668	$ 67,917	$ 63,519	$ 61,738
Insured	88.2%	89%	89%	88%

Base on the above data, if population being the most important factor and everything else carries similar weight in the overall location decision, which zipcode is our best choice? Please show your detailed work in the excel file.

This data table is listed in the attached excel sheet. Please download this excel file to work on the problem and upload the completed excel file for submission.

|Source for non-cost factors: Virginia Atlas of Community Health, 2004. \begin{tabular}{|l|l|} \hline Factors & Weights \\ \hline Land & \\ \hline Building & \\ \hline Operating & \\ \hline Pop. Size & \\ \hline Elderly & \\ \hline Education & \\ \hline Income & \\ \hline Insured & \\ \hline Sum of the weight \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Factors } & \multicolumn{4}{|c|}{ Zip Codes of Potential Sites } \\ \hline & 23059 & 23233 & 23112 & 23832 \\ \hline \multicolumn{5}{|l|}{ Land } \\ \hline \multicolumn{5}{|l|}{ Building } \\ \hline \multicolumn{5}{|c|}{ Operating } \\ \hline \multicolumn{5}{|l|}{ Pop. Size } \\ \hline \multicolumn{5}{|l|}{ Elderly } \\ \hline \multicolumn{5}{|c|}{ Education } \\ \hline \multicolumn{5}{|l|}{ Income } \\ \hline \multicolumn{5}{|l|}{ Insured } \\ \hline Sum & & & & \\ \hline \end{tabular}