Location decisions (operation management) –only 4+ star business tutors needed

A manufacturer of oak barrels has factories in an area at the location coordinates provided in the following table. Each coordinate unit represents approximately 10 miles. The yearly demand at each factory is also given.
Factory

Demand

X-Coordinate

Y-Coordinate
Manchester
(Demand) 14,000

(X Coordinate)80

(Y Coordinate)60

Fayetteville
(D)17,000

(X)60

(Y)10

Columbia
(D)5,000

(X)30

(Y) 90

Lawrenceburg
(D)3,000

(X)30

(Y)20

Management has decided to build a new factory to supply raw material to these factories. The location of the new factory should be central to the existing factories.

Respond to the following in a Microsoft Excel worksheet:

What should be the map coordinates of the new factory? Graph the locations of the four factories and the proposed raw material factory.
Is the location of the proposed raw material factory where you expected it to be based on the coordinates of the other factories? Why or why not?
What is the main contributing factor leading to the location of the proposed raw material factory?

Support your responses with examples.

Cite any sources in APA format.

THIS NEEDS TO BE COMPLETED IN EXCEL WITH FUNCTIONS AND COMPLETED BY 8p.m. eastern standard time 6/3/14