Product A is an end item and is made from two units of B and four of C. B is mad

Question

Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of two units of F and two of E.

   A has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.

If 85 units of A are required in Week 10, develop the MRP planning schedule, specifying when items are to be ordered and received. There are currently no units of inventory on hand. (Leave no cells blank - be certain to enter "0" wherever required.)

Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of two units of F and two of E.

   A has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.

Explanation / Answer

  Item A Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 0 0 0 85   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 1 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 0 0 0 85   Q = L4L Planned order receipts 0 0 0 0 0 0 0 0 0 85 Planned order releases 0 0 0 0 0 0 0 0 85 0   Item B Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 0 0 170 0   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 2 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 0 0 170 0   Q = L4L Planned order receipts 0 0 0 0 0 0 0 0 170 0 Planned order releases 0 0 0 0 0 0 170 0 0 0   Item C Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 0 0 340 0   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 2 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 0 0 340 0   Q = L4L Planned order receipts 0 0 0 0 0 0 0 0 340 0 Planned order releases 0 0 0 0 0 0 340 0 0 0   Item D Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 510 0 0 0   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 3 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 510 0 0 0   Q = L4L Planned order receipts 0 0 0 0 0 0 510 0 0 0 Planned order releases 0 0 0 510 0 0 0 0 0 0   Item E Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 1020 0 0 0   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 2 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 1020 0 0 0   Q = L4L Planned order receipts 0 0 0 0 0 0 1020 0 0 0 Planned order releases 0 0 0 0 1020 0 0 0 0 0   Item F Period 1 2 3 4 5 6 7 8 9 10 Gross requirements 0 0 0 0 0 0 680 0 0 0   OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0   LT = 3 Projected available balance 0 0 0 0 0 0 0 0 0 0   SS = 0 Net requirements 0 0 0 0 0 0 680 0 0 0   Q = L4L Planned order receipts 0 0 0 0 0 0 680 0 0 0 Planned order releases 0 0 0 680 0 0 0 0 0 0

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

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