operations management 2373747 2

/in /by

Assignment 2: Dropbox Assignment

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 approximately 10 miles. The yearly demand at each factory is also given.

Factory
Demand
X Coordinate
Y Coordinate
Manchester
14,000
80
60
Fayetteville
17,000
60
10
Columbia
5,000
30
90
Lawrenceburg
3,000
30
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.

Submission Details

Name your worksheet SU_MGT3059_W4_A2_LastName_FirstInitial.xls.

Submit your worksheet to the W4 Assignment 2 Dropbox by Tuesday, January 27, 2015.

Assignment 2 Grading Criteria
Maximum Points
Calculated the map coordinates of the new factory.
10
Graphed the locations of the four factories and the proposed raw material factory.
15
Analyzed and justified whether the location of the proposed raw material factory is where you expected it to be based on the coordinates of the other factories.
10
Analyzed the main contributing factor leading to the location of the proposed raw material factory.
10
Used correct spelling, grammar, and professional vocabulary. Cited all sources using APA format.
5
Total:
50
 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"