This is a 4 part question, each one is worth .20 points each. Using the blank MRP matrix provided by Prof Bolton above, solve for the MRP requirements. Make sure you fill out the MRP matrix and attach the file.

Consider the bill of material for product P and the data given in the following table. The master schedule requirements for P are 70 units in week 6. Items Q and R are manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item S is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order.

R(3) \begin{tabular}{|c|c|c|c|} \hline Item & Lead Time & Quantity on Hand & Scheduled receipts \\ \hline P & 1 & 5 & \\ \hline Q & 1 & 15 & 20 in week 2 \\ \hline R & 2 & 0 & \\ \hline S & 2 & 25 & 15 in week 1 \\ \hline \end{tabular} Master Schedule: \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|l|} \hline Item & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 \\ \hline Quantity & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ LTtem: } \\ Lot Size: \end{tabular} Questions: 1) How many R's should be ordered? 2) When should the order for R s be released? 3) What will the projected on hand inventory of item Q be in week 4 ? 4) What will the proiected on hand inventory of item 5 be in week 8