A manufacturer of oak barrels has factories in an area at the location coordinates provided in the following table. Each...
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.
13 years ago
5
Answer(2)![blurred-text]()
![]()
![blurred-text]()
![]()
Purchase the answer to view it

- facility_location_ans.docx
- facility_location_ans.xlsx
Purchase the answer to view it

NOT RATED
- 201345_98534_1_tm_c_tts271013-22565-86.docx
- 201345_98534_2_tm_c_tts271013-22565-86.xlsx
Bids(1)
other Questions(10)
- Linear relationships between two quantities
- Knowing details about the culture of a prospective international client before a meeting (answer attached)
- QNT 561 Week 6 Learning Team Business Research Methods, Part III
- Physics exercises
- Case Study: Ethical Behavior in Accounting and Financial Management
- Mat 116 Week 9 Capstone DQ
- MAT 116 Week 7 DQs
- LDR 531 Week 6 Learning Team Implementing Leadership Change
- I NEED THIS WITHIN 2 HOURS - MUST BE APA 6th and 100% UNIQUE - WILL BE COPYSCAPED
- RES 342 Final Exam Sample 4 - All 54 questions answers - A++.dot