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