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 -