In: Operations Management
In the following MRP planning schedule for Item J, indicate the correct net requirements, planned-order receipts, and planned-order releases to meet the gross requirements. Lead time is one week. (Leave the cells blank, whenever zero (0) is required.)
|
WEEK NUMBER |
||||||
| ITEM J | 0 | 1 | 2 | 3 | 4 | 5 |
| Gross requirements | 77 | 52 | 75 | |||
| On-hand | 47 | |||||
| Net requirements | ||||||
| Planned-order receipt | ||||||
| Planned-order release | ||||||
|
Below is the screenshot of the MRP schedule -
| J LT 1 Q = L4L |
On Hand | 1 | 2 | 3 | 4 | 5 | |
| Gross Requirement | 0 | 77 | 0 | 52 | 75 | ||
| Scheduled Receipts | 0 | 0 | 0 | 0 | 0 | ||
| Projected on Hand | 47 | 47 | 0 | 0 | 0 | 0 | |
| Net Requirements | 0 | 30 | 0 | 52 | 75 | ||
| Planned Order Receipts | 0 | 30 | 0 | 52 | 75 | ||
| Planned Order Releases | 30 | 0 | 52 | 75 | 0 |
Below is the screenshot of the formula applied -
