Please answer the following questions using the tables below (the questions are interconnected)! I will rate you highly! Please show your work!

You are the location manager for a small but growing airline primarily servicing European routes. You need to locate new maintenance facilities and have gathered the data found in the table below to make a preliminary Factor Rating Model.

		Spain	Spain	Spain	UK	UK	UK	Germany	Germany	Germany
Factor	Importance Weights	Madrid	Barcelona	Valencia	London	Leeds	York	Munich	Hamberg	Berlin
Financial Incentives	0.15	100	90	50	100	40	80	40	10	70
Skilled Labor	0.20	80	50	70	70	100	50	80	40	40
Existing Facility	0.25	90	30	20	70	90	10	10	60	100
Wage Rates	0.15	40	80	50	10	100	60	100	60	30
Real Estate Cost	0.15	30	70	70	10	40	50	60	60	70
Expansion Possibilities	0.10	80	10	40	70	60	70	40	70	20

1) The Factor Rated Score for Madrid is:

Format with one decimal placer.

2) The Factor Rated Score for York is:

Format with one decimal place.

3) The Factor Rated Score for Hamberg is:

Format with one decimal place.

4) The top-scoring city is:

• Madrid
• Barcelona
• Valencia
• London
• Leeds
• York
• Munich
• Hamberg
• Berlin

You present this data and the executive board never gets beyond a discussion of the factors and importance weights. Two groups emerge the"Build New Group" and the"Buy and Expand Group".

TheBuild New Group has decided on these Factors and Importance weights:

Factor	Importance Weights
Financial Incentives	0.25
Skilled labor	0.35
Wage rates	0.15
Real estate cost	0.25

TheBuy and Expand Group wants these factors and importance scores:

Factor	Importance Weights
Financial Incentives	0.15
Skilled labor	0.20
Existing facility	0.25
Wage rates	0.15
Expansion possibilities	0.25

None of the other data changes. All of the city's scores for the factors stay the same.

You have been asked to re-calculate the Factor Rating Scores for each of these options.

5) Using the "Build New" criteria which city has the highest score?

• Madrid
• Barcelona
• Valencia
• London
• Leeds
• York
• Munich
• Hamberg
• Berlin

6) What is the score for the best"Build New"city?

Format with one decimal place.

7) Using the "Buy and Expand" criteria, which city has the highest score?

• Madrid
• Barcelona
• Valencia
• London
• Leeds
• York
• Munich
• Hamberg
• Berlin

8) What is the score for the best"Buy and Expand" city?

Format with one decimal place.