Answered step by step
Verified Expert Solution
Link Copied!

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,
especially the last one image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

More Books

Students also viewed these Databases questions

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago