Question

In: Operations Management

Determine the best distribution (minimum transportation costs) from suppliers A, B, C, and D to the...

Determine the best distribution (minimum transportation costs) from suppliers A, B, C, and D to the five outlets Dallas, Phoenix, Portland, Montreal, and Orlando.

Two-stage distribution problem: RIFIN Company has recently developed a new
method of manufacturing a type of chemical. The method involves refining a certain
raw material that can be obtained from four overseas suppliers, A, B, C, and D, who
have access to the four ports at Vancouver, Boston, Miami, and San Francisco,
respectively. RIFIN wants to determine the location for plants that will refine the
material. Once refined, the chemical will be transported via trucks to five outlets
located in Dallas, Phoenix, Portland, Montreal, and Orlando.

After an initial study, the choice of location for RIFIN's refineries has been narrowed
down to Denver, Atlanta, and Pittsburgh. Assume that one unit of the raw material is
required to make one unit of the chemical. The amount of raw material that can be
obtained from suppliers A, B, C, and D and the amount of chemical required at the
five outlets are given in the following table (a). The cost of transporting the raw
material from each port to each potential refinery and the cost of trucking the
chemical to outlets are provided in tables (b) and (c), respectively. Determine the
locations of RIFIN's refining plants, the capacities at these plants, and the distribution
pattern for the raw material and processed chemical.

(a) Supply and demand for four sources and five outlets

Raw Material Source Supply Outlet Demand
A 1000 Dallas 900
B 800 Phoenix 800
C 800 Portland 600
D 700 Montreal 500
Orlando 500

(b) Inland raw material transportation cost

From/To Denver Atlanta Pittsburgh
Vancouver 4 13 9
Boston 8 8 5
Miami 12 2 9
San Francisco 11 11 12

(c) Chemical trucking cost

From/To Dallas Phoenix Portland Montreal Orlando
Denver 28 26 12 30 30
Atlanta 10 22 23 29 8
Pittsburgh 18 21 23 18 21

Solutions

Expert Solution

We solve this trans-shipment problem as shown below. We tabulate the data as shown:

Total supply = Total Demand = 3300. hence, we will get all "=" constraints in Excel solver

We solve the given problem as shown below:

The above solution in the form of formulas along with Excel Solver extract is shown below for better understanding and reference:

As seen from the above solution,

The location of refining plants are:

Denver with capacity of 600 units

, Atlanta with capacity of 1500 units

, Pittsburgh with capacity of 1200 units

The distribution pattern is shown in the above solution excel.

_______________________________________________________________________________________

In case of any doubt, please ask through the comment section before Upvote/downvote.


Related Solutions

1.            Determine whether the function f from { a, b, c, d } to {a,...
1.            Determine whether the function f from { a, b, c, d } to {a, b, c, d, e} is injective (one-to-one), surjective (onto) and/or bijective (one-to- one correspondence) : f(a) = a,            f(b) = c,            f(c) = b, f(d) = e a. Is this function injective?              . surjective?              . bijective?              . If your answer is no for any of the above, explain:             b. Is there an inverse for this function?              . c. Is the composition f...
A component is purchased from 3 suppliers, A, B, and C, where the suppliers have respective...
A component is purchased from 3 suppliers, A, B, and C, where the suppliers have respective defective rates of 2%, 6%, and 4%. Of all the components purchased, 20% comes from supplier A, 50% from supplier B, and 30% from supplier C, that is, each shipment comes from each of these suppliers with these probabilities. The company uses the following quality control policy. A sample of 15 units is randomly selected from each shipment of components. If at most 2...
Determine the energy needed to overcome electrostatic repulsion in the (a) D-D, (b) D-3He, and (c)...
Determine the energy needed to overcome electrostatic repulsion in the (a) D-D, (b) D-3He, and (c) T-T reactions.
From the information, determine the total amount of: (a) Manufacturing overhead $ (b) Product costs $ (c) Period costs $
Question Description Knight Company reports the following costs and expenses in May. Factory utilities   $15,500   Direct labor   $69,100 Depreciation on factory equipment   12,650   Sales salaries   46,400 Depreciation on delivery trucks   3,800   Property taxes on factory building   2,500 Indirect factory labor   48,900   Repairs to office equipment   1,300 Indirect materials   80,800   Factory repairs   2,000 Direct materials used   137,600   Advertising   15,000 Factory manager’s salary  ...
Suppose the alphabet is S = {A B C D} and the known probability distribution is...
Suppose the alphabet is S = {A B C D} and the known probability distribution is PA = 0.3, PB = 0.1, PC = 0.5, and PD = 0.1. Decode the Huffman coding result {11000010101110100} to the original string based on the probability distribution mentioned above. The codeword for symbol “D” is {111}. Please writing down all the details of calculation.
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what...
Consider the cross: A/a; b/b; C/c; D/d; E/e x A/a; B/b; c/c; D/d; e/e a) what proportion of the progeny will phenotypically resemble the first parent? b) what proportion of the progeny will genotypically resemble neither parent?
Unit costs are defined as a.   Marginal costs b.   Total costs c.   Average costs d.   Implicit...
Unit costs are defined as a.   Marginal costs b.   Total costs c.   Average costs d.   Implicit costs e.   Inverse costs Group of answer choices 2. In the 1890s, German courts were taking a very different approach to cartels and antitrust. What did the German court rule in the pulp cartel case? a. It ruled the cartel was in monopoly that was illegal b. It ruled that cartels were illegal, but that the wood pulp cartel was not a true cartel...
Which of the following best describes a high supply risk? a. Sourcing from multiple suppliers. b....
Which of the following best describes a high supply risk? a. Sourcing from multiple suppliers. b. Sourcing from ten suppliers with an alternative source of supply. c. Sourcing from one supplier without an alternative source of supply. d. Sourcing from one supplier with an alternative source of supply. Which of the following is not a supplier strategy? a. Partnership. b. Competitive Bidding. c. Secure Supply. d. First respondent wins the order. Which of the following best describes a low supply...
In the following sentences determine the appropriate sampling A, B, C or D A --- RANDOM...
In the following sentences determine the appropriate sampling A, B, C or D A --- RANDOM (SIMPLE RANDOM SAMPLING) B --- SYSTEMATIC C --- STRATIFIED D --- Cumulative (CONGLOMERATES) 1- A company is divided by DIRECTIVES, EMPLOYEES, SECRETARIES AND WORKERS. It is wanted to make a study to know the level of satisfaction in relation to the benefits that the company has. The head of human resources decides to take a random sample of each category. 2- A university career...
Study the following distribution of factor endowments in country A, B, C, and D. Using the...
Study the following distribution of factor endowments in country A, B, C, and D. Using the factor endowment model, explain which factor(s) in each country would support and oppose trade liberalization. Explain why. [2 points] Assuming that trade is contracting (diminishing exposure to international trade), discuss the nature of political coalitions and cleavages (urban-rural/ class conflict) in each country? Land-Labor Ratio High Low Economy Advanced A ABUNDANT Capital Land SCARCE Labor C ABUNDANT Capital Labor SCARCE Land Economy Backward B...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT