Note: Enter your details in the excel sheet. Files without details are not considered Prepare the MRP for Chair Product Chair Week 1 150 Week 2 100 Week 3 50 Week 4 120 Week 5 200 Week 6 250 Week 7 180 Week 8 80 Part chair leg assembly seat back assembly Legs (4) Cross bar Lead time in week 1 2 1 2 Scheduled receipts for Item legs is 100 units in week 3. Independent demand for Seat is 2200 in the 4th week Initial Safety Lot size Inventory Stock 120 75 LFL 200 0 200 0 70 LFL 50 25 100 70 30 LFL 70 30 LFL 1 1 formula for reference OH of peri-1 =(OH+SR+PR-GR)Peri-O Net req Peri-1=Max(GR+$SS-SR-OH,0)Peri-1 PR peri-1=If(Net Req-1>0, (Roundup(Net req-1/$Lot size,0))*$Lot size,) PO=Index(PR array(D17:K17)),row1,$Lead time+2) Chair Leg Assembly Back Assembly Seat Legs Cross bar