a.) Convert the given product structure tree into a low-level-coded product structure tree of the end item HS-45. Make sure to show the low-level code for each item in the product structure tree. b) Develop a detailed Material Requirements Planning (MRP) schedule for the Production Planner in AEG which she can use to determine when the orders for the end item HS-45, as well as its subparts, should be released. (You may not get full marks if table is not filled completely, a blank space in the table means the value there is 0!) NOTE: Table required for this question is available on eClass, under document name "MRP Schedule Table.pdf". You are only allowed to fill by Hand. Typed work will not be accepted, hence will not be marked. Use as many tables as you need. Question: Please note that this question has two parts (a and b). You may need to scroll the screen down and navigate left and right to see the whole problem. Clearly label your parts when answering. You are allowed a Maximum of 3 Files for this problem. It would be best if you used a pen to answer. Must show all work/steps completely in the MRP tables. One of the products Atkinson Engineering Group (AEG) Inc. produces is a hair straightener (HS-45), which is an end item. Each HS-45 is composed of items A, B, C, D, E and F. Production Planning Manager at AEG does not consider any safety stock among any of the items and wants to develop an MRP schedule for the hair straightener (HS-45) with the following product structure tree and the information provided below. Item Lead Time On Hand Scheduled Receipts Lot Sizing HS-45 2 5 L4L A 3 8 65 in week 3 Multiples of 65 B 1 0 Minimum 75 C 4 193 630 in week 1 210 in week 3 Multiples of 105 D 2 0 41 in week 2 L4L E 2 275 240 in week 1 Multiples of 80 F 2 14 120 in week 1 Minimum 50 The demand for OM-51 is 25, 60 and 45 units in week 7, week 9, and week 10 respectively. HS-45 B (2) A (3) F (1) E (2) C (2) A (2) D (1) E (2) F (3) C (2)