Question: Q2: A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are two origins for

Q2: A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are two origins for this material, which must be shipped to three manufacturing plants. The current network has the following characteristics:

Costs	Plant 1	Plant 2	Plant 3	Supply
Raw material source 1	$6	$8	$9	400
Raw material source 2	$4	$7	$3	600
Demand	500	500	500	Supply < Demand

The firm has identified two potential sites for a third raw material source; these are identified as Candidate A and Candidate B. From A, the costs to ship would be $9 to Plant 1, $12 to Plant 2, and $12 to Plant 3. From B, these costs would be $11, $14, and $8. The new source, wherever it is located, will have a capacity of 500 units. Solve with the transportation method. Which site should be selected? (10 points. Please show your Solver results from Excel)

How do you do this on excel?

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!

3. In column G, Brett wants to calculate the number of days the invoice is overdue. If the age of the invoice is greater than 30 days, it is overdue. Calculate the days overdue as follows: a. b. C....

Q2: A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are two origins for this material, which must be shipped to three...

Q1: Arnold Tofu owns and operates a chain of 12 vegetable protein hamburger restaurants in Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions...

Q2: A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are two origins for this material, which must be shipped to three...

A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are two origins for this material, which must be shipped to three...

Q3) (25 points) A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are three origins for this raw material, Which must be...

Q3) (25 points) A firm has established a distribution network for the supply of a raw material critical to its manufacturing. Currently there are three origins for this raw material, which must be...

Question 1 1 / 1 pts One difference in the stepping - stone method compared to the intuitive methods is: the stepping - stone method never finds a feasible solution. the stepping - stone method does...

21. The Queen City Nursery manufactures bags of potting soil from compost and topsoil. Each cubic foot of compost costs 12 cents and contains 4 pounds of sand, 3 pounds of clay, and 5 pounds of...

Problem 5 (5 points) A firm has established a distribution network for the supply of a raw material critical to its manufacturing process. Currently there are two origins for this raw material, which...

Why is pH important in biological systems? Be sure to include examples in your essay and include enough information to earn the available points. You should include numbers and/or calculations to...

Despite a series of quality checks by a company that makes television sets, there is a probability of 0.0007 that when a purchaser unpacks a newly purchased television set it does not work properly....

Crisis Period (2007-2008) Describe the risk culture at WaMu? Provide some examples to support your position.

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...