solve using Excel. 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$).$

Determine the low level code $($LLC$)$ for each item shown in the bill of material

Develop the MRP plan which will tell you when and how much to order each item