Complete the MRP schedule for the product below. Product A Lot Size = 100 Safety

Question

Complete the MRP schedule for the product below.

Product A Lot Size = 100 Safety Stock = 50

Lead Time = 1 week Allocated = 200 In hand =600

WEEKS


     
1  
2     
3  
4  
5      

Gross requirement  
200  
500  
300  
800  
400     

Scheduled receipt  
100                     

Available                         

Net requirements                         

Planned order receipts                         

Planned order releases                         

Explanation / Answer

Product A Lot Size = 100 Safety Stock = 50 Allocated = 200 WEEKS     Lead Time = 1 week 0 1 2 3 4 5 Gross requirement     200 500 300 800 400 Scheduled receipts 100 0 0 0 0 Available/Projected On Hand 600 300 100 100 100 100 Net requirements                            0 250 250 750 350 Planned order receipts                            0 300 300 800 400 Planned order releases   0 300 300 800 400 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

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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