Explore BrainMass

Explore BrainMass

    Calculating Composite Rating for Different Locations

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    A location analysis for Temponi Controls, a small manufacturer of parts for high-technology cable systems, has been narrowed down to four locations. Temponi will need to train assemblers, testers, and robotics maintainers in local training centers. Cecilis Temponi, 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 locations are shown in the following table. High scores represent favorable values.

    Factors Weight Akron, OH Biloxi, Ms Carthage, TX Denver, CO
    Labor
    Availability .15 90 80 90 80
    Technical
    School
    Quality .10 95 75 65 85
    Operating
    Cost .30 80 85 95 85
    Land and
    Construction
    Cost .15 60 80 90 70
    Industrial
    Industrial .20 90 75 85 60
    Labor cost .10 75 80 85 75

    A. Compute the composite rating for each location
    B. Which site would you choose
    C. Would you reach the same conclusion if the weights for operating cost and labor cost were reversed? Recompute as necessary and explain.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:26 pm ad1c9bdddf
    https://brainmass.com/business/business-management/calculating-composite-rating-different-locations-231415

    Solution Summary

    Solution describes the steps to find out the weighted composite rating for different locations based upon rating provided to various factors. Attached as Excel spreadsheet.

    $2.19

    ADVERTISEMENT