Question
A furniture manufacturer has recently discovered a new market in the US and wants to set up a factory near his suppliers and retailers. The
A furniture manufacturer has recently discovered a new market in the US and wants to set up a factory near his suppliers and retailers. The coordinate location, the demand in each market, the required supply from each provider, and the shipping cost for each supply source or market (per ton per mile) are: Sources / Markets S/ Ton Mile Fn Tons Dn Coordinates Xn Yn Sources Buffalo 1.90 600 750 1200 Virginia 2.25 850 200 1000 Memphis 1.95 350 120 800 St. Louis 3.25 800 225 825 Markets Atlanta 2.25 550 750 500 Boston 1.50 350 1050 1200 Jacksonville 1.75 250 600 300 Philadelphia 1.85 275 925 975 New York 1.50 300 1000 1100 What should be the coordinates of the new plant? Please use Excel to Answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started