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:
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, August 12, 2014.
| 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
|
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more