Let's analyze the problem step by step to create the MRP schedule for Item J. --- # Step 1: Understand the given data ### Gross requirements: - Week : 70 - Week 1: 45 - Week 2: 65 - Weeks 3-5: No gross requirements provided (assumed zero) ### On-hand inventory: - Week : 30 - Weeks 1-5: Not specified, so assume unless otherwise mentioned. ### Lead time (LT): 1 week ### Other notes: - Scheduled receipts and planned order receipts are not given initially. - The projected available balance, net requirements, planned order receipts, and planned order releases need to be calculated. --- # Step 2: Calculate projected available balance The projected available balance (PAB) for each week is: \[ \text{PAB} = \text{Previous week's PAB} + \text{Scheduled receipts} - \text{Gross requirements} \] Initial PAB at Week : - On-hand = 30 --- # Step 3: Compute week-by-week ### Week : - On-hand = 30 - Gross requirement = 70 - PAB before requirements = 30 - Net requirement = Max(, Gross requirement - PAB) = 70 - 30 = 40 - Since net requirement > , we need to create a planned order receipt to cover this requirement, considering lead time. ### Step 4: Determine planned order release: - Lead time is 1 week, so planned order release at Week will be for week 1. - Planned order receipt in week 1 = 40 (to satisfy week gross requirement) - No scheduled receipts initially. ### Week 1: - Starting PAB = Previous PAB + scheduled receipts (which are ) = 30 + = 30 - Gross requirement = 45 - PAB before requirements = 30 - Net requirement = 45 - 30 = 15 - Since net requirement > , we need to place a planned order in week 1 to be received in week 2 (due to lead time). - Planned order receipt in week 2 = 15 ### Week 2: - Starting PAB = Previous PAB + planned order receipt from week 1 = 30 + 15 = 45 - Gross requirement = 65 - PAB before requirements = 45 - Net requirement = 65 - 45 = 20 - Need to place a planned order in week 2 to be received in week 3. - Planned order receipt in week 3 = 20 ### Week 3: - Starting PAB = 45 + 20 = 65 - No gross requirements given, so net requirement = - No planned order needed. ### Week 4: - Starting PAB = 65 - Gross requirement = - Net requirement = - No planned order. ### Week 5: - Starting PAB = 65 - Gross requirement = - Net requirement = - No planned order. --- # Step 5: Summarize planned order receipts and releases | Week | Gross requirements | Planned order receipts | Planned order releases | |--------|-------------------------|------------------------------|------------------------------| | | 70 | 40 (received in week 1) | 40 (released in week ) | | 1 | 45 | 15 (received in week 2) | 15 (released in week 1) | | 2 | 65 | 20 (received in week 3) | 20 (released in week 2) | | 3 | | | | | 4 | | | | | 5 | | | | --- # **Final Summary:** - **Planned order releases:** - Week : 40 units - Week 1: 15 units - Week 2: 20 units - These are scheduled to meet gross requirements considering lead time. - **Planned order receipts** are set accordingly in subsequent weeks. --- This completes the detailed step-by-step MRP schedule for Item J.