A Location Analysis Has Been Narrowed Down to Three Locations

question 24

Multiple Choice

A location analysis has been narrowed down to three locations. The critical factors, their weights, and the ratings for each location are shown below: $$\begin{array} {c} \quad\quad\quad\quad\quad\quad\quad\quad{ \text { Location } } \\\begin{array} { l c c c c } \text { Factor } &\text { Wt. } & \text { A } & \text { B } & \text { C } \\\hline \text { Labor Cost } & .4 & 70 & 80 & 90 \\\text { Transportation Cost } & .2 & 80 & 80 & 60 \\\text { Market Access } & .2 & 90 & 70 & 60 \\\text { Raw Materials Cost } & .1 & 50 & 70 & 90 \\\text { Utility Cost } & .1 & 80 & 90 & 70\end{array}\end{array}$$ What is the composite score for location A?

• A) 76
• B) 75
• C) 78
• D) 74
• E) 76.33

---

Definitions:

Duplicate Data

Identical copies of data that can occur within a database or dataset, often leading to redundancy and inaccuracies.

Microsoft Access

This Microsoft system for database management unites the relational Microsoft Jet Database Engine with a user-friendly graphical interface and software development utilities.

Manage Data

The process of organizing, storing, protecting, and controlling access to data to ensure its accuracy, reliability, and availability for users.

Define Fields

The process of specifying the name and data type for each column in a database or spreadsheet.