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. I prefer you upload the file to me in PDF, but MS Excel will also work. Other formats are not compatible for me to view.

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.

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 projected on hand inventory of item S be in week 8?

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} 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