Question

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.) B(2) Di2 E 12) DI2) Master Schedule Week Quantity 2 7 Beginning LT=1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beginning B(2) LT 3 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beginning invento | E(2) Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases E(4) LT-1 Beginning inventory 5 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases

Answer 1

Solution :

8 Total A, LT - 1, Lot - L4 Gross Requirements Scheduled Recei Projected On Hand Net requirements Planned order recei Planned order releases On Hand 8 Total B. LT-3,Lot-L4L Gross Requirements Scheduled Recei Projected On Hand Net requirements Planned order recei Planned order releases On Hand 120 120 15 15 15 15 15 15 15 105 105 105 8 Total C, LT -1, Lot L4L Gross Requirements Scheduled Recei Projected On Hand Net requirements Planned order recei Planned order releases On Hand 8 Total E, LT -1, Lot L4L Gross Requirements Scheduled Recei Projected On Hand Net requirements Planned order recei Planned order releases On Hand 210 240 450 130 130 130 130 240 240 240 8 Total H,LT-1, Lot-L4L Gross Requirements Scheduled Recei Projected On Hand Net requirements Planned order recei Planned order releases On Hand 240 720 190 190 720 720 190 720