Question: please help me in this question use the Excel, especially the last one Exercise 3 A health care center is considering locating their new facility

please help me in this question use the Excel,
especially the last one please help me in this question use the Excel,especially the last one

Exercise 3 A health care center is considering locating their new facility either in Miami, Orlando, or Jacksonville in Florida. In making their decision, the following factors are considered: total patient miles per month, facility utilization, average time per emergency trip, expressway accessibility, land, and construction costs, and employee preferences. The management evaluated each possible location using these criteria. The following table presents the weight given to each factor and scores for each location. E 1 Score 2 Location Factor Weight Jacksonville Orlando Miami 3 Total patient miles per month 25 4 5 2 4 Facility utilization 20 3 4 5 5 Avg time per emergency trip 20 3 2 1 6 Expressway accessibility 14 4 3 4 7 Land and construction costs 10 4 2 1 8 Employee preference 10 5 4 2 a. Create names for the columns: 'Weight, "Jacksonville', 'Orlando' and 'Miami'. b. Define a name for the table. c. Calculate the weighted score for each location using the formula 'Weighted Score WeightScore'. d. Define names for the columns that present the weighted scores for each location. e. Identify the best location for the health care center. Note that the best is the location that maximizes the total weighted score. This method of selecting among different alternatives is known as the Preference Matrix method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!