Question: ****** PLEASE USE EXCEL******* Please explain all of your steps and use excel to solve this question. NIA Manufacturing needs to build a new plant

****** PLEASE USE EXCEL*******

Please explain all of your steps and use excel to solve this question. NIA Manufacturing needs to build a new plant to serve four market regions. NIA has three supply sources. The coordinates of location, the demand of each market region, maximum units from each supply source and the shipping cost from each supply source or to each market region are shown below. Where should NIA locate its plant?

Supply Sources Shipping Cost ($/Ton Mile) Supply (Tons) X coordinate Y coordinate
S1 1.1 140 430 630
S2 1.9 170 760 250
S3 1.4 90 580 450

Markets Shipping Cost ($/Ton Mile) Supply (Tons) X coordinate Y coordinate
M1 2.2 100 500 920
M2 1.3 85 850 300
M3 2.4 65 600 400
M4 1.9 75 200 180

************PLEASE DO NOT COPY AND PASTE*******

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

SHOW ALL WORKINGS ! Please use excel for all graphs Attached are pictures of the original graph But please use the numbers attached here as all the 8s and 2s were changed . 1. Daudi owns and manages...

Q:

please help me answer these questions especially #9 thank you Abstract This case study of capital investment analysis can be applied to the fundamentals of finance course. Ideally this case will also...

Q:

Please Use excel below to help you: Distribution Network Design Problems ISE 470 Problem 1 You have recently been appoimed Conegory Manager for nuts and bolts at IndastryCa, a manufacturer with a...

Q:

Please answer question 2 and please use excel. thanks! CASE 2 In 2009, David Samuelson quit his job at a large beer company to start his own brewery, Ambitious Microbrewery, Inc. (AMI). His family...

Q:

Stuck on a corporate finance question on capital structure (WACC). PLEASE HELP (URGENT). Question 1, part A and B. Would be great if someone can solve it for me, if not, please teach me how to...

Q:

Supply Chain Management Problem Set 1 1. ABC is going to build a new manufacturing plant to serve five market regions. ABC has four supply sources. The coordinates of location, the demand of each...

Q:

Please help to answer question 7 . Please use excel if need be. thanks! CASE 2 In 2009, David Samuelson quit his job at a large beer company to start his own brewery, Ambitious Microbrewery, Inc....

Q:

Please help in answering the listed question at the bottom, especially #1 and #2. Thank you! Abstract This case study of capital investment analysis can be applied to the fundamentals of finance...

Q:

Brands in the Salesforce Dilem DS. INC: SPECTRUM BRAN company's individual and maintain customer relationships, and to clude competition from tak ing advantage of any perceived disruptions during...

Q:

Please I have an article on which the questions come from. Please feel out the form appropriately. Please let me know if you can do a good job on this. I have similar exercise coming. Thanks ARTICLE...

Q:

Show that 1 +2+...+ n = n(n+1)(2n +1) for every positive integer n. 6

Q:

Suppose the population data of heights of students at your college (the x-values) is normally distributed, with a mean of 167.5 centimetres and a standard deviation of 12 centimetres. a. Sketch the...

Q:

Assume your investment horizon is the next 1 month (April-May 2025), provide an in-depth market view for USD/JPY - Your market view needs to be justified by your analysis of data, news and any...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...