Question

The mayor of New York City would like to build a new facility for public drug treatment. The members of the committee in charge of the project have developed four factors of importance based on their primary concern (and given a weight of 5). The First factor is the capacity to accept a large number of patients; second, The annual lease; third, the confidentiality for patients; and the fourth the accessibility for healthcare workers.

Using the factor-rating method, which site will be preferred?

		Scores (out of 100)                                         weighted score
Factor	Weight	old saint vincent facility	downtown area	port authority area	old saint vincent facility	downtown area	port authority area
Capacity of the facility	4	9	7	9
Annual Lease	4	3	9	6
Confidentiality for patients	3	6	3	5
Accessibility for healthcare workers	2	6	3	2
Totals

The preferred site:

Answer 1

Calculate Weighted Score of each alternative (site) is determined by the following formula

Weighted Score  = Weight * Score

The calculations are shown in Excel sheet as follows:

EXCEL FORMULA:

Preferred site

Weighted score of Downtown area, and Port authority are same and highest of all.

Therefore, preferred sires are Downtown area and Port authority