PLEASE ANSWER IN EXCEL

A location analysis for Cook Controls, a small manufacturer of parts for high-technology cable systems, has been narrowed down to four locations. Cook will need to train assemblers, testers, and robotics maintainers in local training centers. Lori Cook, the president, has asked each potential site to offer training programs, tax breaks, and other industrial incentives. The critical factors, their weights, and the ratings for each location are shown in the following table. High scores represent favorable values.

a) The composite (weighted average) rating for

Akron, OH =

(round your response to two decimal places)

The composite (weighted average) rating for

Biloxi, MS =

(round your response to two decimal places)

The composite (weighted average) rating for

Carthage, NY =

(round your response to two decimal places)

The composite (weighted average) rating for

Denver, CO =

b) Based on the given information, the best location for Cook Controls is to choose

c) If the weights for Factor 6 (Labor Cost) and Factor 3 (Operating Cost) were reversed, then using the given information, the best location for Cook Controls is to choose

Factor Description Weight Akron, OH 0.15 Biloxi, MS Carthage, NY Denver, CO 90 85 95 85 0.1 85 80 60 90 0.3 85 85 85 80 Labor availability Technical school quality Operating cost Land and construction cost Industrial incentives Labor cost 0.15 65 75 95 75 0.2 90 80 90 55 0.1 80 85 80 70