Develop a material requirements plan for component $H.$ Lead times for the end item and each compo$-$

nent 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.$ Lot$-$for$-$lot ordering will be used for all items.The MRP Department has a problem. Its computer "died" just as it spit out the following information Pianned 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 kllied the computer, $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$ Click here for the Excel Dota File