Question: (Same data as question 1). You are trying to decide on a location for a new factory. You've score three possible locations (1-5, where 5

(Same data as question 1). You are trying to decide on a location for a new factory. You've score three possible locations (1-5, where 5 is best) on the criteria that are relevant: traffic, cost, size, electric, water, and sewer. You've asked two analysts to weigh each criteron according to their subjective judgments of how important they are. The weights and scores are in the attached spreadsheet. According to Analyst 2, which location is the top choice, and what's its score? Spreadhseet Location 2,388 Location 2,374 Location 1,368 Location 1, 374 A 1 2 Traffic 3 Cost 4 Size 5 Electric 6 Water 7 Sewer B D E F Analyst 1 weig Analytst 2 weig Location 1 Location 2 Location 3 12 8 2 4 3 15 12 4 3 5 20 20 3 2 12 10 5 5 4 21 30 4 4 2 20 20 4 3 5 4 w | 5

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 General Management Questions!

You are trying to decide on a location for a new factory. You've score three possible locations (1-5, where 5 is best) on the criteria that are relevant: traffic, cost, size, electric, water, and...

please write a good conclusion knowing the new plant is going to be in Mexico, I will give you a good comment Sember 2010 Schuhe, vice president of nocturer of altors ATV Side by Sidst dions and...

Questions 1-5 In September 2010 Suresh Krishna, vice president of manufacturer of all-terrain vehicles (ATV), Side-by-Sides, perations and integration at Polaris Industries Inc., a Snowmobiles, sat...

Please read the case and answer the questions , i will write excellent comments, Thank you in advance Sember 2010 Schuhe, vice president of nocturer of altors ATV Side by Sidst dions and integration...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

SUMMIT MARITIME: FACILITY LOCATION AND LAYOUT DESIGN In September 2017, Paulson Joseph, managing director of Summit Maritime Pvt. Limited (Summit Maritime), a marine consulting firm and luxury boat...

Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "?" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

please see case study and questions that need to be answered. thank you This that and handsode CASE: Data Tech, Inc. The helped is in the table Fact Party Sean attach Lection 33 Factor Proximity to 4...

Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

Attached is Accounting assignment along side recommended readings to answer certain questions. Thank you Assignment 1 Problem 1 15 points Reading - W. L. Ferrara, Cost/Management Accounting: The 21st...

The main flavor component of the hazelnut is (2E, 5S)-5-methyl-2-hepten-4-one. Write a structural formula or build a molecular model showing its stereochemistry.

A company has a policy that states: Our employees will be paid at the mean of their peers. After a study was done it was learned that one employee group is being paid at the 25th percentile and an...

Exercise 1.1 Find the word or phrase from the list below that best matches the description in the following questions. Use the num bers to the left of the words in the answer. Each answer should be...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...