Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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 especially the last one
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