8 SCMG4353P01-1910-12005 A company manufactures a product at its plants in Q,R,

Question

8 SCMG4353P01-1910-12005 A company manufactures a product at its plants in Q,R, and S, then ships the product to its customers n C. D E, F and G The transportation costs in dollars per unit) are as folows from Q to C.D. E. F. and G 20, 17, 13, 16, and 15 from R to C. D, E, F and G 15, 18,22, 19, and 26 from S to C. D. E, F and G 18, 11, 25. 22, and 20 The monthly demand from c. D. E. F. and G are 4400, 6000, 4500, 3500, and 4000 unts, respectively On the other hand, the monthly capacity at plants Q. R and S are 11000, 6000 and 4000 unts, respectivety Suppose the company makes the following monthly transportation decision Send from piant 4400 unts to C., 3500 units to F, 3000 units to G Send from plant R. 6000 units to D Send trom plant S 4000 units to E should check if customers will experience a shortage and it plants will have unused capacity NOTE Do not use any comma in your answers inthe answer Iothefotowing qestons The total distribution cost is Plant Q send a total month per month Ptant R send a lotal per month S send a tota Plant O wil have a lehover (nsed) capacity o Plant R wi have a lefover (unused) capacity of Plant S will have a lehover ( units per month units per month units per month (unused) capacityof u Customer C wis expernence a shortage Customer D will experience a shortage Customer E will experience a shortage units per mont unts per month per month DOLL

Explanation / Answer

1) The total distribution cost per month is 397000 (4400*20+3500*16+3000*15+6000*18+4000*25) 2) Plant Q send a total units per month are 10900 3) Plant R send a total units per month are 6000 4) Plant S send a total units per month are 4000 5) Plant Q will have a leftover (unused) capacity per month are 100 6) Plant R will have a leftover (unused) capacity per month are 0 7) Plant S will have a leftover (unused) capacity per month are 0 8) Customer C will experience a shortage per month are 0 9) Customer D will experience a shortage per month are 0 10) Customer E will experience a shortage per month are 500 11) Customer F will experience a shortage per month are 500 12) Customer G will experience a shortage per month are 1000 13) The Decision is correct, but could be better from transportation point if E is supplied from Q, C by R and D by S.

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.