The MRP Department has a problem. Its computer "died" just as it spit out the following information: Planned order release for item J27 -640 units in week 2. The firm has been able to reconstruct all the information they lost except the master schedule for end item 565. The firm is fortunate because J27 is used only in 565s. Given the following product structure tree and associated inventory status record information, determine what master schedule entry for 565 was exploded into the material requirements plan that killed the computer. (Leave no cells blank - be certain to enter "o" wherever required.) Part Number 565 X43 N70 Y36 327 On Hand 0 60 0 200 0 Lot sin Lot-for-lot 120 Lot-for-lot Lot-for-lot Lot-for-lot Lead Time 1 week 1 week 2 weeks 1 week 2 weeks Click here for the Excel Data File 565 X43 Y3621 N78 X43 Bag, Inv, 2 3 Week Quantity 5 5 Beg Inv. 3 S hem 565 LT 1 week Gross requirements Scheduled receipts On hand Net requirements Planned order receipt Planned order release Beg Inv. lam: Y36(2) LT - 1 week Gross requirements Scheduled receipts On hand Net requirements Planned order receipt Planned order release Bog In 2 5 7 Item. J27(4) LT = 2 weeks Gross requirements Scheduled receipts On hand Net requirements Planned order receipt Planned order release