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 "0" wherever required.)
WEEK NUMBER
ITEM J 0 1 2 3 4 5
Gross requirements 75 50 70
Projected available balance 40
Net requirements
Planned order receipt
Planned order release
Period 1 2 3 4 5
Gross requirements 76 48 72
Scheduled receipts
Item J Projected available balance
LT = 1 Net requirements
Q = L4L Planned order receipt
Planned order release

Answer and Explanation:

As per the data given in the question,

Period                        1                 2                 3                   4              5

Gross requirements 0                75               0                   50             70

Scheduled receipts 0                 0                0                    0               0

Projected available balance 40 0                0                    0               0

Net requirements    0                 35              0                   50              70

Planned order receipts 0            35             0                    50              70

Planned order releases 35          0             50                   70               0

Net requirements =Gross requirements - Projected available balance

= 75 - 40

= 35

Period                       1                    2                3               4                   5

Gross requirements 0                  76              0               48                 72

Scheduled receipts 0                   0                0               0                    0

Projected available balance 32    0               0               0                    0

Net requirements    0                   44               0             48                    72

Planned order receipts 0              44              0             48                   72

Planned order releases 44             0             48             72                     0

Net requirements = Gross requirements - Projected available balance

= 76 - 32

= 44