The MPS initial quantities for product A require the assembly to start final assembly according to the following schedule: 100 units in the 2nd week, 250 units in the 4th week, 160 units in the 5th week, 200 units in the 7th week and 90 units in the 8th week. BOM for product A is shown in the figure below, and inventory records data is shown in the table below. Fill out the stock tables provided by creating a material requirement plan for the B, C and D components that include the next 8 weeks. ALT=1 C(1) LT=1 B (2) LT=1 D (2) LT=2 Data Category Lot size rule Delivery time (LT) Scheduled purchases Initial stock B L4L 1 week C FOQ = 300 unit 1 week 200(1 week) o D POQ (P=2) 2 week 0 200 Product: B WEKK 1 2 3 4 5 6 7 8 Gross Needs Scheduled Purchases Planned Stock Scheduled Purchases Scheduled Order Orders Product :C WEKK 1 2 3 4 5 6 7 8 Gross Needs Scheduled Purchases Planned Stock Scheduled Purchases Scheduled Order Orders Product :D WEKK 1 2 3 4 5 6 7 8 Gross Needs Scheduled Purchases Planned Stock Scheduled Purchases