1. Complete the MRP schedule for the product below. Product A Lot Size = 75 Safe

Question

1. Complete the MRP schedule for the product below. Product A Lot Size = 75 Safety Stock = 50 Lead Time = 1 week Allocated = 100 in hand =300 WEEKS 1 2 3 4 5 Gross requirement 500 700 400 500 Scheduled receipt 600 Available on hand 300+600-100-50=750 Net requirements Planned order receipts Planned order releases

Explanation / Answer

Product A Lot Size = 75 Safety Stock = 50 Allocated = 100 WEEKS     Lead Time = 1 week 0 1 2 3 4 5 Gross requirement     500 700 400 500 0 Scheduled receipts 600 0 0 0 0 Available/Projected On Hand 300 250 0 50 0 0 Net requirements 0 450 400 450 0 Planned order receipts 0 450 450 450 0 Planned order releases   0 450 450 450 0 0 Projected On Hand Calculation = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement* Net Requirement = Last Period Closing + Scheduled Receipt - Gross Requirement (If the above calculation results in negative amount, then such amount is taken as Net Requirement, else 0) Planned Receipt = If Net Requirement > 0, Planned Receipt as per Lot Size Planned Order Release = If Planned Receipt >0, Order as per Lead Time to be placed, Here 1 week before *Projected On Hand Calculation for first week = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement - Allocated - Safety Stock

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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