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 1 2 3 4 50 Product A 5 6 60 B 110 C 80 Figure 1 B D (2) E (1) D (1) E (2) D (2) E (2) F (2) F (2) F (2) Table 2 TABLE 11.11 INVENTORY RECORD DATA ITEM Data Category D E F Lot-sizing rule FOQ = 150 L4L POQ (P = 2) Lead time 3 weeks 1 week 2 weeks 0 0 30 Safety stock Scheduled receipts 150 (week 3) 120 (week 2) None Beginning inventory 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. Lot Size: Lead Time: 5 6 FOQ = 150 3 weeks 7 1 2 3 4 8 Item: D Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases 150 150 Lot Size: Lead Time: 5 6 L4L 1 week 7 1 2 3 4 8 Item: E Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases 120 0 F Item: Description: Lot Size: Lead Time: Safety Stock: 5 6 POQ, P= 2 2 weeks 30 units 7 8 1 2 3 4 Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases 100