Product A is made of Four units of B and two units of C. B is made of three units of D and two E. C is made of two units of F and one unit of E. Lead times for purchase of each unit are: A takes one week, B takes two weeks, C takes one week. D and E take 2 weeks and F takes 3 weeks. Assume that there is a demand for 150 units of A in week 8. There is on-hand inventory of 100 units of B, and 20 units of C. There is a scheduled receipt of E for 500 units in week three. Assume all items are purchased L4L except for item D which is ordered in multiples of 50, F which is ordered in multiples of 200 and E which is 500

A) Show the bill of materials (product structure tree)

B) Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline MRP Worksheet & Week Number & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline & Quantity & & & & & & & & \\ \hline & & & & & & & & & \\ \hline Item: & Gross requirements & & & & & & & & \\ \hline & Scheduled receipts & & & & & & & & \\ \hline Quantity = & Projected on hand & & & & & & & & \\ \hlineLT= & Net requirements & & & & & & & & \\ \hline Lot Size = & Planned-order receipts & & & & & & & & \\ \hline On hand = & Planned-order releases & & & & & & & & \\ \hline & & & & & & & & & \\ \hline Item: & Gross requirements & & & & & & & & \\ \hline & Scheduled receipts & & & & & & & & \\ \hline Quantity = & Projected on hand & & & & & & & & \\ \hline LT= & Net requirements & & & & & & & & \\ \hline Lot Size = & Planned-order receipts & & & & & & & & \\ \hline On hand = & Planned-order releases & & & & & & & & \\ \hline & & & & & & & & & \\ \hline Item: & Gross requirements & & & & & & & & \\ \hline & Scheduled receipts & & & & & & & & \\ \hline Quantity = & Projected on hand & & & & & & & & \\ \hline LT= & Net requirements & & & & & & & & \\ \hline \end{tabular}