Your automobile employer wants expand its business in India and plans to open a new plant in India. They are looking for an optimum location to open the new plant in India. You can refer to the below data points and explain which location mechanism you want to recomment to your management team. You can explain your rationale to solve this problem in logical steps. The objective is to maintain the lowest cost possible?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

D1.

 

Your automobile employer wants expand
its business in India and plans to open a
new plant in India. They are looking for an
optimum location to open the new plant in
India. You can refer to the below data
points and explain which location
mechanism you want to recomment to
your management team. You can explain
your rationale to solve this problem in
logical steps. The objective is to maintain
the lowest cost possible?
Sources Markets
Markets
Sources
Destinations Transportation Cost / ton Mile Quantity in tons
Kalda Port
JNPT
Chennai Port
Mumbai
Nagpur
Pune
Nashik
Jaipur
Kolkata
1.67
1.44
1.56
1.26
1.26
1.26
1.26
1.84
2.7
15000
20000
25000
5000
15000
10000
5000
3000
7000
X
Cordinates
Y
95
320
600
500
300
175
150
67
750
750
425
25
100
600
400
350
900
800
Transcribed Image Text:Your automobile employer wants expand its business in India and plans to open a new plant in India. They are looking for an optimum location to open the new plant in India. You can refer to the below data points and explain which location mechanism you want to recomment to your management team. You can explain your rationale to solve this problem in logical steps. The objective is to maintain the lowest cost possible? Sources Markets Markets Sources Destinations Transportation Cost / ton Mile Quantity in tons Kalda Port JNPT Chennai Port Mumbai Nagpur Pune Nashik Jaipur Kolkata 1.67 1.44 1.56 1.26 1.26 1.26 1.26 1.84 2.7 15000 20000 25000 5000 15000 10000 5000 3000 7000 X Cordinates Y 95 320 600 500 300 175 150 67 750 750 425 25 100 600 400 350 900 800
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.