The product structure tree of the speaker kit KJ$11$ is shown as follows. The manager knows that $45$ units, $5$ units, and $10$ units of the speaker kit KJ$11$ are required at the beginning of week $4,$ week $7,$ and week $8,$ respectively. Projected on$-$hand inventory and lead time for the speaker kit KJ$11$ and components are given in the following Table.The manager knows that $5$ units of B are scheduled to arrive at the beginning of week $2$; $25$ units and $5$ units of D are scheduled to arrive at the beginning of week $2$ and week $6,$ respectively. The company uses lot$-$for$-$lot order sizing for KJJ $11$ and components B$,$ C$,$ and E$.$ It$,$ however, uses a lot size of $25$ units for component D$.$ to make Materials Requiements Planning $($MRP$)$ for the speaker kit KJ$1$ and components. URGENT please send in excel