t include the levels. show how product AYEE is 13 marks Its production was planned as indicated in table I below: Table 1 Master Production Schedule of Finished Item AYEE Period 11 12 13 14 15 16 17 18 19 MPS Quantities 20 30 50 40 30 1 10 2 50 For all parts listed in the first column in table 2 below, the following information was obtained. Part Number Current On- Hand 10 Table 2 Schedule Receipts Lot-Sizing Lead Time Safety (SR's) Rule Stock Week Due Quantity Lot-for-lot 1 week 0 150 2 weeks 0 250 250 1 week 20 0 400 2 weeks 0 SO 10 320 b) Determine the MRP explosion for all the 4 parts (B, C, D. E) [2 marks] c) Using the information from part (a) and tables 1 and 2 above complete the MRP worksheet at the back on page 8. (Detach it and affix it to your answer booklet). [17 marks] d) The master scheduler asks you if they can move the MPS of 20 in weeks 3 to week 2. From the data on the MRP records, what would you tell them and why? [2 marks e) Is there anything of special note that is a concern? What and why? [2 marks] MATERIAL REQUIREMENTS PLANNING) - 34 Marks QUESTION 1 (MATERIAL REQUIREMENTS PARTA remium product, named AYEE, is produced at Nice Thines It is constructed as follows: Product AYEE requires 1 unit of B and 2 units of B requires 3 units of D and lunit of E C requires 1 unit of D and 2 units of E. Day the Bill of Material (Product Tree Structure) to show how produAVE constructed. You must include the levels. marks! Its production was planned as indicated in table I below: Table 1 Master Production Schedule of Finished Item AYEE Period 1 2 3 4 5 MPS Quantities 20 30 1 7 10 6 50 12 8 9 40 30 11 50 2990 For all parts listed in the first column in table 2 below, the following information was obtained. Lead Time Safety Stock Part Current Number On- Hand B 10 SO 10 320 Table 2 Schedule Receipts Lot-Sizing (SR's) Rule Week Due Quantity 0 Lot-for-lot 0 150 250 250 0 4 00 week 2 weeks l wock 2 weeks 0 0 20 0 / 12 marks] b) Determine the MRP explosion for all the 4 parts (B, C, D, E) c) Using the information from part (a) and tables 1 and 2 above complete the MRP worksheet at the back on page 8. (Detach it and affix it to your answer booklet). [17 marks! d) The master scheduler asks you if they can move the MPS of 20 in weeks 3 to week 2 From the data on the MRP records, what would you tell them and why? [2 marks] mark e) Is there anything of special note that is a concern? What and why