15.7 Complete the MRP schedule for Product A.

Week
Product A / 1 / 2 / 3 / 4 / 5 / 6
Lot size = / LFL / Gross requirements / 120 / 340 / 310 / 530 / 410 / 380
Lead time = / 1 / Scheduled Receipts / 275
On hand = / 650 / Available / 750 / 630 / 290 / 0 / 0 / 0
Safety stock = / 100 / Net requirements / 20 / 530 / 410 / 380
Allocated = / 75 / Planned order receipts / 20 / 530 / 410 / 380
Planned order releases / 20 / 530 / 410 / 380
Product B / 1 / 2 / 3 / 4 / 5 / 6
Lot size = / LFL / Gross requirements / 40 / 1060 / 820 / 760
Lead time = / 1 / Scheduled Receipts / 400
On hand = / 430 / Available / 630 / 630 / 590 / 0 / 0 / 0
Safety stock = / 120 / Net requirements / 470 / 820 / 760 / 0
Allocated = / 80 / Planned order receipts / 470 / 820 / 760 / 0
Planned order releases / 470 / 820 / 760 / 0
Product C / 1 / 2 / 3 / 4 / 5 / 6
Lot size = / 1500+ / Gross requirements / 80 / 2120 / 1640 / 1520
Lead time = / 2 / Scheduled Receipts / 1500
On hand = / 460 / Available / 160 / 1660 / 1580 / 960 / 820 / 800
Safety stock = / 140 / Net requirements / 540 / 680 / 700
Allocated = / 160 / Planned order receipts / 1500 / 1500 / 1500
Planned order releases / 1500 / 1500 / 1500
Product D / 1 / 2 / 3 / 4 / 5 / 6
Lot size = / 1000+ / Gross requirements / 0 / 1410 / 2460 / 2280 / 0 / 0
Lead time = / 1 / Scheduled Receipts
On hand = / 1100 / Available / 840 / 840 / 430 / 0 / 0 / 0
Safety stock = / 200 / Net requirements / 570 / 2030 / 2280 / 0 / 0
Allocated = / 60 / Planned order receipts / 1000 / 2030 / 2280 / 0 / 0
Planned order releases / 1000 / 2030 / 2280 / 0 / 0