1. analysis of using the Centre-of-Gravity Technique: Determine the Centre-of-Gravity of the 7 customer locations (for question 1, you can disregard the 5 potential distribution center sites).

For weights, use the number of containers provided in the Excel file.

Use Excel for the analysis (you can start with Excel Exhibit S7.2, and modify it to suit this case study).

Be sure to show all formulas used in the analysis (i.e. do not just enter figures determined elsewhere).

Once you have determined the coordinates for the centre of gravity, search for the nearest city or town on an application such as Google Maps, and include the closest city/town and country in your report.

The nearest city/town is not one of the customer locations; use the coordinates of the Centre-of-Gravity to find the nearest city / town on a map - this will be a new location not listed anywhere in this project.

2. Use data which has been provided in the file: Data.xlsx for the (x, y) coordinate for each location:

Caution: Coordinates for locations are typically described as (i) latitude (i.e. the North-South or vertical coordinate), and then longitude (i.e. the East-West or horizontal coordinate). However, points on a graph are typically described as (x, y), meaning the horizontal coordinate followed by the vertical coordinate. Therefore, for a graph, the 'x-coordinate' will be represented by longitude, and 'y-coordinate' will be represented by latitude. Be careful not to get these backward!

3. a visual illustration of the analyses from items

(1): a scatterplot graph based on location coordinates.

Ensure each point on the graph is clearly identified (city, type of location, etc).

You can decide whether to prepare one or two graphs for items (1) and (2) - just be sure that the information is clearly communicated.

For clarity, ensure that the 7 customer locations are shown on both. One chart should then include the Centre-of-Gravity, and the other should include the 5 distribution center sites, with the preferred site highlighted in some fashion.

\f