Develop an MRP plan for product A with the product structure given. The demand for product A is given in the table on the second worksheet. The on-hand inventory levels for each item are A=25,B=23,C=50,D=0,E=30. The order quantities for items A,B and D are based on the Lot-for-Lot ordering, which means whenever you need to order you order by how much you need. However, the ordering rule for item C and item E is different. The order quantity for item C is 60 units and for item E is 200 units. This means whenever item C or E need to be replenished, you can only order in specific sizes ( 60 units for item C and 200 units for item E). 1) Determine the low level code (LLC) for each item shown in the bill of material 2) Develop the MRP plan which will tell you when and how much to order each item