b$)$ Materials Requirements Planning $($MRP$)$ provides a means for scheduling the ordering of raw materials and parts. Part of the Bill of Materials for a vacuum coating machine includes the following structure:

The following ordering details are known about each part:

$$ Part $007$ has a lead time of $2$ weeks and a Minimum Order Quantity of $50.$

$$ Part $008$ has a lead time of $1$ week and Economic Order Quantity of $65.$

$$ Part $009$ has a lead time of $2$ weeks and a fixed order period of $3$ weeks i$.$e$.$ there is always $3$ weeks between orders.

The gross requirements for part $007$ over the following $10$ weeks are:

Weeks $12345678910$

Number

of Part $40306020807030$

There are scheduled receipts in week $1$ of $50$ of Part $007,65$ of Part $008$ and $165$ of Part $009.$

Construct the MRP records for all three parts over the ten$-$week planning horizon. $(15$ Marks$)$