Problem 12-18 Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the start of week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are in production and will be completed by the start of week 2. (Leave no cells blank-be certain to enter "O" wherever required.) E(2) H3) Master Schedule Week QuantityY Beginning inventory A LT1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beginning inventory B(2) LT= 3 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beginning inventory Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases