Given the BOM and MPS for end items A and B shown below, complete the MRP schedules for A$,$ B$,$ C$,$ D$,$ and E$.$

$$ A B C for A D for A E for C C for B E for B E for C

Weeks $12122122$

Units $-0214124$

MPS

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Item A $0020020002002000$

Item B $00015000150150$

Item A B C D E

Lot Size Rule L$4$L L$4$L FOQ $=500$ FOQ $=1000$ L$4$L

Safety Stock $00020050$

Beginning Inventory $00505001000$

Order quantity $500$

Order quantity $1000$

Required:

Note: Use cells A$2$ to I$19$ from the given information to complete this question. Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

MRP Record Part Name: Item A

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Gross requirements

Scheduled receipts

Available inventory

Net requirements

Planned order receipts

Planned order releases

MRP Record Part Name: Item B

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Gross requirements

Scheduled receipts

Available inventory

Net requirements

Planned order receipts

Planned order releases

MRP Record Part Name: Item C

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Gross requirements

Scheduled receipts

Available inventory

Net requirements

Planned order receipts

Planned order releases

MRP Record Part Name: Item D

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Gross requirements

Scheduled receipts

Available inventory

Net requirements

Planned order receipts

Planned order releases

MRP Record Part Name: Item E

$$ Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$ Week $7$ Week $8$

Gross requirements

Scheduled receipts

Available inventory

Net requirements

Planned order receipts

Planned order releases