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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
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.
Needs in-text citations and full references listed and cite any sources in APA format. Also, if possible to use some information from Title: Opreations Management, Author: Jay Heizer; Barry Render, Edition / Copyright: 10, Publisher: Prentice Hall PTR
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