The following table lists the components needed to assemble an end item $$X$,$ quantities on$-$hand, and lead times. Also, there is a scheduled receipt of $5$ units of subassembly A in week $2$ and lot$-$for$-$lot ordering is used for all items. If $12$ units of the end item are needed at the beginning of week $6,$ prepare a material requirements plan for E$.$

Item X A B C D E F

Quantity on$-$hand $0162404004$

Lead time $($weeks$)1211211$

X

B $(3)$ A

D $(4)$ E E $(2)$ C

E $(5)$ F $(2)$ B $(3)$ A

D $(4)$ E E $(2)$ C

E $(5)$ F $(2)$

Master Week $123456$

Schedule Quantity $12$

X$,$ Lead time $=1$ week Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $0$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

A$,$ Lead time $=2$ weeks Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $1$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

B$,$ Lead time $=1$ week Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $6$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

C$,$ Lead time $=1$ week Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $2$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

D$,$ Lead time $=2$ weeks Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $40$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

E$,$ Lead time $=1$ week Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $400$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases

F$,$ Lead time $=1$ week Beg Inv. W$1$ W$2$ W$3$ W$4$ W$5$ W$6$

Gross requirements $4$

Scheduled receipts

Projected on$-$hand

Net requirements

Planned$-$order receipts

Planned$-$order releases