Certainly! Here's a detailed analysis and solution for the given MRP planning schedule: --- # Problem Breakdown The schedule involves planning for **Item J** over 5 weeks, with the following known data: -Gross requirements** are given for weeks, 1, 4, and 5. - **On-hand inventory** at the start (week ) is 30 units. - The lead time (LT) for Item J is 1 week. - The scheduled receipts, projected available balance, net requirements, planned-order receipts, and planned-order releases need to be calculated. --- # Step 1: Fill in Known Data | Item J | Week | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | |---------|---------|---------|---------|---------|---------|---------| | Gross requirements | 70 | 45 | | | 65 | | | On-hand | 30 | | | | | | | Net requirements | | | | | | | | Scheduled receipts | | | | | | | | Projected available balance | | | | | | | | Planned-order receipts | | | | | | | | Planned-order releases | | | | | | | --- # Step 2: Calculate Projected Available Balance (PAB) The formula: \[ \text{PAB}_t = \text{Previous PAB} + \text{Scheduled receipts} + \text{Planned-order receipts} - \text{Gross requirements} \] Since no scheduled receipts or planned-order receipts are given initially, we assume none unless specified. --- # Step 3: Calculate Net Requirements and Planned Order Releases - Net requirements occur when projected available balance is less than gross requirements. - Planned order releases are based on net requirements, considering lead time (LT = 1 week). --- # Week-by-Week Calculation ### Week : - **On-hand**: 30 units - **Gross requirements**: 70 - **Net requirements**: \(70 - 30 = 40\) - **Planned order release (Week )**: \(40\) units (to arrive at week 1 due to lead time) - **Projected available balance** at end of week : \(30 - 70 = -40\) ### Week 1: - **Start with**: Previous projected available balance (after week ) + planned order receipt (arriving at week 1) - **Planned order receipt** from week order: 40 units - **Projected available balance**: \(-40 + 40 = \) - **Gross requirements**: 45 - **Net requirement**: \(45 - = 45\) - **Planned order release** (to arrive in week 2): 45 units ### Week 2: - **Start with**: previous balance + receipt (from week 1 order): + 45 = 45 - **Gross requirements**: (not given, assume ) - **Net requirement**: (since no gross requirements given) - **Planned order release**: none ### Week 3: - **Gross requirements**: (not given, assume ) - **Projected available balance**: 45 - **Net requirement**: ### Week 4: - **Gross requirements**: 65 - **Projected available balance**: 45 (from previous week) - **Net requirement**: \(65 - 45 = 20\) - **Planned order release** (to arrive in week 5): 20 units ### Week 5: - **Projected available balance**: 45 + 20 (from week 4 order) - 65 (gross requirements) = --- # **Final Summary** | Week | Gross Requirements | On-hand | Net Requirements | Planned Order Reqs | Planned Order Releases | Projected Available Balance | |---------|---------------------|---------|------------------|-------------------|------------------------|------------------------------| | | 70 | 30 | 40 | | 40 | 30 - 70 = -40 | | 1 | 45 | -40+ | 45 | | 45 | | | 2 | | 45 | | | | 45 | | 3 | | 45 | | | | 45 | | 4 | 65 | 45 | 20 | | 20 | 45 + 20 - 65 = | | 5 | | | | | | | --- # **Final Notes** - The key is to ensure the net requirements are calculated whenever projected available balance falls below gross requirements. - Planned order releases are scheduled considering the lead time of 1 week. - The schedule accounts for the initial on-hand inventory and planned receipts. --- **Summary:** The MRP schedule for Item J indicates planned order releases at weeks , 1, and 4 to meet the gross requirements at weeks , 1, and 4 respectively, considering the initial on-hand inventory and lead time. No planned receipts are scheduled other than those resulting from these releases.