Table I shows the MPS quantity start date for three products: A, B, and C. Develop the material requirements plan for the next 6 weeks for items D, E, and F. The BOMs are shown in Figure 1, and the data from the inventory records are shown in Table 2. Table 1 MPS Quantity Start Dates Product 12 sol B 110 Figure 1 D ED om E EQ F FO Table 2 TABLE 11.11 WENTORY RECORD DATA IT Data Category D POP-20 L . 30 150 0 100 Solve this problem on a separate paper. Then, use the results to complete the tables provided below, save the file and then submit it on E-learning. Item: D Lot Size: FOQ - 150 Description: Lead Time: 3 weeks Week 112 34 5 6 7 8 Gross requirements Scheduled receipts Projected on hand 150 Planned receipts Planned order releases 1 sol Lot Size: L4L Lead Time: 1 week 10 2 345 6 7 8 Item: Description: Week Gross requirements Scheduled receipts Projected hand 0 Planned receipts Planned order releases 120 on F Item: Description: Lot Size: POQ, P = 2 Lead Time: 12 weeks Safety Stock: 30 units 1213145 6 7 8 Week Gross requirements Scheduled receipts Projected hand 100 Planned receipts Planned order releases on