A manufacturing organization needs to plan the materials required for the next six weeks for the manufacture of its end$-$product $($Product A$),$ as per a master production schedule. In addition to the end product, there is an independent requirement of Component $C,$ as it is sold as a spare in the market. The MPS for both the end product and the spares are given in Table. In order to assemble one unit of Product A$,$ Components B to $G$ are required. Figure shows the product structure. The number alongside each component denotes the number of each component required to assemble its immediate parent. An extract of the inventory status $($Table$)$ reveals the inventory on hand. There are no pending orders for delivery. Different lot$-$sizing rules are used for the components of Product A$.$ Moreover, the components have different lead times. All this information is available in Table. Perform an MRP exercise to estimate the quantity and timing of the components required for the manufacture of Product A as per the MPS$.$

Master Production Schedule for the next six periods

$\backslash$table$[[,1,2,3,4,5,6],[$Product A$,100,150,200,100,0,200],[$Component C$,,50,60,,,70]]$

$\backslash$table$[[$Component$,$On hand,Lead time,Lot size$],[$A$,150,1,$LFL$],[$B$,1000,2,$LFL$],[$C$,300,1,$LFL$],[$E$,750,2,3$ periods$],[$F$,1700,6,3$ periods$],[$G$,200,1,400]]$