Problem 9-10 In the following MRP planning schedule for Item J, indicate the cor

ID: 348249 • Letter: P

Question

Problem 9-10 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 no cells blank be certain to enter "o" wherever required.) WEEK NUMBER ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release 4 47 7 73 34 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 4 73 47 71 tem

Explanation / Answer

The filled up MRP table as follows :

ITEM : J , LT = 1 ,Q = L4L

WEEK 1

WEEK 2

WEEK 3

WEEK 4

WEEK 5

Gross requirement

Projected available balance

Net requirement

Planned order receipt

Planned order release

Following may be noted :

Since there is no requirement during week 3 , Projected available balance for week 3 = Projected available balance for week 2

This leaves no inventory in stock and therefore Projected Available Balance for week 4 = 0

Since lead time = 1 week , Planned order receipt of 8 units during week 4 will reflect as 8 units of Planned Order Release one week earlier i.e. during Week 3

Since there is a Lead time requirement of 1 week , Planned Order Receipt of 71 during week 5 will reflect as Planned order release of 71 during week 4