b$.$ Develop the MRP schedule for all items given the following information: $(2$ marks each; $14$ marks$)$

Item Present on hand Lead time Lot$-$size rule

A $01$ week L$4$L

B $01$ week L$4$L

C $302$ weeks $*$FOQ of $40$ units

D $1001$ week L$4$L

E $1001$ week L$4$L

F $302$ weeks $*$FOQ of $60$ units

G $01$ week L$4$L

$*$Note: FOQ stands for fixed order quantity. For example, FOQ $=50$ indicates that any order quantity must be $50$ units or some integer multiple of $50$ units. FOQ is usually necessary because the supplier is only willing to sell full boxes of items $($and in this example, each box contains $50$ units$).$

In your tables, show on hand at the beginning of a given period before receiving the planned order receipt for the period. Also, assume that all receipts and releases are at the beginning of each period.