Operations Management W4:A2

Location Decisions

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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.

8060

6010

3090

3020

Factory Demand X-Coordinate Y-Coordinate
Manchester 14,000
Fayetteville 17,000
Columbia 5,000
Lawrenceburg 3,000

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.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Cite any sources in APA format.

Center of Gravit

y

0

0 0 0 0

1 0 0 0 0

1 0 0 0 0

1 0 0

0 0 0 0
0 0

0 0

CENTER OF GRAVITY
Factory Demand X-Coordinate Y-Coordinate 4 0
Manchester 1
Fayetteville
Columbia
Lawrenceburg

0 0 0 0 0 0 0 0 0 0

Assignment

imately

miles. The yearly demand at each factory is also given.

Factory Demand X-Coordinate Y-Coordinate
Manchester

Fayetteville

60 10

Columbia

Lawrenceburg

30

Week 4 Assignment 2
Location Decisions
A manufacturer of oak barrels has factories in an area at the location coordinates provided in the following table. Each coordinate unit represents appro

x 10
14,000 80 60
17,000
5,000 30 90
3,000 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.

grid

y
90
30
10
x
10 30 50 70 90
70
50

Still stressed from student homework?
Get quality assistance from academic writers!

Order your essay today and save 25% with the discount code LAVENDER