QUESTION 2: A company manufactures two products A and B. Each A requires two C's and one D. Each D requires two F's and one E, while each E requires one F. Each product B requires one D and two E's. The table below shows data from the inventory records. DATA CATEGORY ITEM C D E F Lot-Sizing Fixed Order Fixed Order Lot for Lot Rule Quantity = 220 Lead Time 3 weeks 2 weeks Quantity 300 3 weeks Period Order Quantity P = 2 Scheduled 280 (week 1) None 300 (week 3) 2 weeks None Receipts Beginning Inventory 25 0 150 600 The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5. Develop the material requirements plan (showing Gross requirements, Scheduled receipts, On hand inventory, Net requirements, and Planned-order release) for the next six weeks for items C, D, E and F. [TOTAL: 30 MARKS]