Question

In: Operations Management

A paint company has four manufacturing plants (W, X, Y, and Z) that require 30,000, 20,000,...

A paint company has four manufacturing plants (W, X, Y, and Z) that require 30,000, 20,000, 10,000, and 20,000 paint cans, respectively. Three paint can suppliers (A, B, and C) have indicated their willingness to supply up to 40,000, 20,000, and 30,000 cans per month, respectively. The total cost (shipping plus price) of delivering 100 cans from each supplier to each manufacturing plant is as below.

Manufacturing plant
supplier W X Y Z
A $54 $48 $50 $46
B 52 50 54 48
C 46 48 50 52

Currently, supplier A is shipping 20,000 cans to plant X and 20,000 cans to Z. Supplier B is shipping 30,000 cans to W, and supplier C is shipping 10,000 cans to Z. Does the present delivery arrangement minimize the cost to the paint company? If not, find a plan that does minimize total costs.

Solutions

Expert Solution

Based on the given data, we tabulate the same as shown below:

Total Demand = 30000 + 20000 + 10000 + 20000 = 80000

Total Supply = 40000 + 20000 + 30000 = 90000

Since Total Supply > Total Demand, this is an unbalanced problem. Hence, there will be "<=" sign for Supply constraints in Solver

We solve the given problem in Excel using Excel Solver as shown below:

This is the least cost shipping schedule as shown in blue in middle table.

The cost for shipping schedule given in the question, we get the total cost as:

The total cost shown in above table in orange is more than total cost we found in the optimum solution as shown in blue.

-----------------------------------------------------------------------------------------------------------------------

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

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!


Related Solutions

Please explain this prolog code line by line. union([X|Y],Z,W) :- member(X,Z), union(Y,Z,W). union([X|Y],Z,[X|W]) :- \+ member(X,Z),...
Please explain this prolog code line by line. union([X|Y],Z,W) :- member(X,Z), union(Y,Z,W). union([X|Y],Z,[X|W]) :- \+ member(X,Z), union(Y,Z,W). union([],Z,Z).
Assume the following preference order for four goods, w, x, y, and z, of a total...
Assume the following preference order for four goods, w, x, y, and z, of a total of 26 people: # of people 9 6 2 4 5 W X Y Y Z Z Y X Z X X Z Z X Y Y W W W W You want to extract the will of the group and employ different rules. What is the group's preference order when you employ: A) Plurality Vote B) Condorcet Vote C) Borda Count D) "Vote...
a.Consider a hypothetical gas of four distinguishable particles, labeled W, X, Y and Z. Assume that...
a.Consider a hypothetical gas of four distinguishable particles, labeled W, X, Y and Z. Assume that they are distributed between only two translational quantum states of energies 2E and 4E. How many different configurations of this gas are there? b.Consider a hypothetical gas of three distinguishable particles, labeled A, B and C. Each of the particles has only three quantum states of energies 5E, 10E and 15E. How many different configurations of this gas have a total energy of 30E?...
The following logic function is given as a sum of minterms F(W,X,Y,Z) = ∑W,X,Y,Z(7,8,10,11,13) + D(5,...
The following logic function is given as a sum of minterms F(W,X,Y,Z) = ∑W,X,Y,Z(7,8,10,11,13) + D(5, 9, 15). (25 points) a) Draw the K-Map and find the minimal sum-of-products expression for this function. b) Draw the circuit implementing this expression c) Give all input pair or pairs where transition between them would create a timing hazard d) Draw the timing diagram showing the glitch corresponding to the pair or one of the pairs. Assume ALL gate delays are equal e)...
You are going to invest $20,000 in a portfolio consisting of assets X, Y, and Z...
You are going to invest $20,000 in a portfolio consisting of assets X, Y, and Z as follows: Asset X: Annual return-10% Probability-0.50 Beta- 1.2 Proportion- 0.333 Asset Y: Annual Return-8% Probability-0.25 Beta- 1.6 Proportion- 0.333 Asset Z: Annual Return- 16% Probability- 0.25 Beta 2.0 Proportion- 0.333 Given the information, what is the expected annual rate of return of this portfolio? What is the beta of the portfolio in the table (containing X, Y, and Z)?
If x = 5, y = 6, z = 4, and w = 3.5, evaluate each...
If x = 5, y = 6, z = 4, and w = 3.5, evaluate each of the following statements, if possible. If it is not possible, state the reason. ((++y) * z) % x (x % y) % (--z) a)     Static_cast<int> ((--y) + x / z) Static_cast<int> (w + Static_cast<double> (x / z + w))
Proposition 8.59. Suppose that X, Y, W, Z, A, B are sets. Let f : X...
Proposition 8.59. Suppose that X, Y, W, Z, A, B are sets. Let f : X → Y , W ⊆ X, Z ⊆ X, A ⊆ Y , and B ⊆ Y . Then the following are true: prove the following ? (1) f(W ∩ Z) ⊆ f(W) ∩ f(Z). (2) f(W ∪ Z) = f(W) ∪ f(Z). (3) f−1(A ∩ B) ⊆ f−1(A) ∪ f−1(B) 4) f−1(A ∪ B) = f−1(A) ∪ f−1(B). (5) X−f−1(A)⊆f−1(Y −A). (6) W...
The curried version of let f (x,y,z) = (x,(y,z)) is let f (x,(y,z)) = (x,(y,z)) Just...
The curried version of let f (x,y,z) = (x,(y,z)) is let f (x,(y,z)) = (x,(y,z)) Just f (because f is already curried) let f x y z = (x,(y,z)) let f x y z = x (y z)
Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X...
Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X Y Z Unit selling price $100 $130 $210 Unit variable costs $60 $30 $180 Labor-hours per unit 4 5 3 a. What is the break-even point (in units) if Monica were to sell only product X? b. What is the break-even point (in units) if Monica sells products X, Y, and Z according to the following sales-mix? X Y Z Sales Mix 55% 15%...
Let X, Y ⊂ Z and x, y ∈ Z Let A = (X\{x}) ∪ {x}....
Let X, Y ⊂ Z and x, y ∈ Z Let A = (X\{x}) ∪ {x}. a) Prove or disprove: A ⊆ X b) Prove or disprove: X ⊆ A c) Prove or disprove: P(X ∪ Y ) ⊆ P(X) ∪ P(Y ) ∪ P(X ∩ Y ) d) Prove or disprove: P(X) ∪ P(Y ) ∪ P(X ∩ Y ) ⊆ P(X ∪ Y )
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT