Question $4-$ Material Requirements Planning $(10$ marks$)$

A manufacturing company produces product A that comprises of a number of components as follows. Each unit of product A requires two units of component B and one unit of component C$.$ Each unit of component B requires two units of component D and two units of component E$.$ Each unit of component C requires three units of component B $,$ three units of component D and three units of component E $.$ Each unit of component D requires two units of component F $.$ Finally, each unit of component E requires one unit of component F $.$

The lead time for items C$,$ D$,$ and F is one week, for items A and B it is two weeks, and for component E it is three weeks.

Lot$-$for$-$lot $($L$4$L$)$ production quantity is applied for items C$,$ while the lot sizes for producing items A$,$ B$,$ D$,$ E$,$ and F are in multiples of $(25,50,75,60)$ and $100$ units, respectively.

The amount of beginning inventory on hand for components A$,$ B$,$ C$,$ D$,$ E $,$ and F are $10,5,10,70,20$ and $70$ units, respectively.

There are two scheduled receipts from the company's suppliers: $40$ units of component E on Week $5$ and $80$ units of component F in Week $3.$

The customer places an order for product A of $15$ units to be delivered in Week $10$ and $25$ units to be delivered in Week $12.$

Based on the above information, answer the following questions:

a$.$ Draw the low$-$level coded Bill of Material for product A $(1$ mark$)$

b$.$ Construct the complete MRP schedule for the above customer order to determine the planned order releases for all items. Can the company fulfill the customer's orders? $(3$ marks$)$

c$.$ Construct another MRP schedule based on the original scenario with the following changes on items E and F:

$-$ Both items E and F must have no projected available balance of inventory in Week $12.$

$-$ The company has a limited production capacity of $120$ units of item E and $300$ units of item F per week.

$-$ The company is allowed to purchase items E and F at the maximum of $100$ units with schedule receipts in Week $5$ and Week $3$ respectively.

You just need to show the revised MRP schedule for items E and F based on your MRP schedule in sub$-$question b$).$ Can the company fulfill the customer's orders? Explain clearly the iteration $/$ steps you take in constructing the MRP schedule for those two items $(3$ marks$)$

d$.$ Construct another complete MRP schedule based on the original scenario to determine the planned order releases for all items without any on$-$hand inventory and scheduled receipt for all items. Can the company fulfill the customer's order?