Eighty units of end item X are needed at the beginning of week 6, and another 30

Question

Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8.

Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units. (Leave no cells blank - be certain to enter "0" wherever required.)

Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8.

B(2) D(3) D(2 F(2)

Explanation / Answer

There are two solutions:

Net Req X 80 30 B 130 60 D1 240 90 D2 260 120 Part D      Beg. Inv. 1 2 3 4 5 6 7 8   Gross requirements 0 0 0 0 260 240 120 90 0   Scheduled receipts 0 50 0 50 0 50 0 50 0   On hand 20 70 70 120 10 20 0 10 10   Net requirements 0 0 0 0 140 180 100 0 0   Planned-order receipt 0 0 0 0 150 200 100 50 0   Planned-order release 0 0 150 150 50 100 50 0 0

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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