The MRP Department has a problem. Its computer $$died$$ just as it spit out the following information: Planned order release for item J$27=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 J$27$ is used only in $565$s$.$ 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 $"0"$ wherever required.$)$

Part Number On Hand Lot Size Lead Time

$5650$ Lot$-$for$-$lot $1$ week

X$43601201$ week

N$780$ Lot$-$for$-$lot $2$ weeks

Y$36200$ Lot$-$for$-$lot $1$ week

J$270$ Lot$-$for$-$lot $2$ weeks

Click here for the Excel Data File