he MPC system at $123$ Ltd is run weekly to update the master production schedule $($MPS$)$ and MRP records. At the start of Wk$.15,$ the MPS for the end Products Large and Tiny is as follows:

Master Production Schedule

Week $151617181920$ Number

Product: $235$

Large

Product:

Tiny

$6$ units of Subassembly E are required to manufacture one unit of Product Large and $2$ units of subassembly E are required to manufacture one unit of Product Tiny

Purchasing lead time for Subassembly E is $2$ weeks, an order quantity of $1150$ units is used and no $($zero$)$ safety stock is maintained for this item.

Inventory balance for Subassembly E is $171$ units at the start of Wk$.1$ and there is an open order $($scheduled receipt$)$ for units due to be delivered at the beginning of Wk $1.$

Using the Tables attached, complete the following:

Part A

Complete the MRP record for Subassembly E as it would appear at the beginning of Wk $1.(4$ Marks$)$

Part B

During Wk $15$ the following transactions occurred for Subassembly E $(6$ Marks$).$

$1.$ The open order for $1150$ units due to be received at the beginning of Wk $15$ was received however $150$ units were scrapped off this order as they did not meet incoming inspection.

$2.$ A random inventory cycle count during Wk $15$ revealed that a pallet $(1/5$ of a consignment$)$ of Subassembly E had not been logged into the warehouse. The inventory was adjusted accordingly.

$3.$ The customer for Product Large halved their order for Wk $15,$ this happened early enough during Wk $15$ to adjust the MPS for the week.

$4.$ The MPS quantities for Wk $21$ include $250$ units for Product Large and $350$ units for Product Tiny

$5.$ Because of a change in customer order requirements, marketing has requested that the MPS quantity of $2175$ units for Product Tiny scheduled in Wk $18$ be split $40\%60\%$ Wk $17$ and Wk $18.$

$6.$ The requested order was released.

Given this new information, complete the MRP record for Subassembly E as it would appear at the beginning of Wk $16.$