Table 1 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 02 3 4 5 50 760 B 1101 801 Figure 1 02 EU 0 (0) E (23) D E (2 F23 F F Table 2 TABLE 11.11 INVENTORY BECORD DATA Data Category Lounge POQ ( P2) FOO-150 3 we LAL 1 week 0 30 120 See more Beggery None 100 150 0 Solve this problem on a separate paper. Then, use the results to complete the tables provided below, Item: D Lot Size: FOQ = 150 Lead Time: 3 weeks 102 341 5 6 7 8 1501 Description: Week Gross requirements Scheduled receipts Projected hand 150 Planned receipts Planned order releases on Lot Size: 1.4L Lead Time: 1 week 1 2 314 5 6 78 Item: E Description: Week Gross requirements Scheduled receipts Projected Jhand 0 Planned receipts Planned order releases 120 on F Item: Description: Lot Size: POQ, P-2 Lead Time: 2 weeks Safety Stock: 30 units 5 6 7 8 Week Gross requirements Scheduled receipts Projected hand 100 Planned receipts Planned order releases on Table 2 TABLE 11.11 INVENTORY RECORD DATA ITEM E D F POQ ( P2) L4L FOO - 150 3 weeks 1 week 2 weeks Data Category Lot-sizing rule Lead time Safety stock Scheduled receipts Beginning inventory 0 0 30 150 v 3 120 (week 2 None 150 0 100