B

C

D

E

F

G

$q,$

$1$

$1$

L

The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule:

$-160$ units in week $1$;$240$ units in week $2$

$-160$ units in week $4$;$160$ units in week $5$

$-160$ units in week $6$;$120$ units in week $7$

$100$ units in week $8.$

Develop a material requirements plan for the next $8$ weeks for items B$,$ C$,$ and D$.$

hint: You will need $3$ separate MRP tables to solve this question fully

$\backslash$table$[[$Inventory Record Data,$],[$Data Category,Item B$,$Item C$,$Item D$],[$Lot$-$sizing rule,POQ $)=(2,\backslash$table$[[$FOQ $=360$