help!

Given the following data, construct a material requirements plan for all components which will result in 200 units of (P) at the beginning of week 6. (Use Excel and submit vour answer in the drop box). B (2) \begin{tabular}{|l|l|l|l|l|} \hline Item & Currently On- Hand & ScheduledReceipt(wk) & Leadtime & Order Quantity \\ \hline P & - & - & 1 & L4L \\ \hline A & 70 & 30( wk3) & 1 & Lot size 100 \\ \hline B & 50 & - & 3 & Lot size 100 \\ \hline \end{tabular}