A B E F. G H 1 Safety Stock 10 20 20 0 0 20 1 Item Description Qty/unit product Level Current Inventory (uni LT (weeks) SRch Receipt Lot Size 2 X Bracket Assembly 1 0 50 0 20 wk 2 FL= 40 3 A Wall Board 2 1 40 1 50 wk 3 L4L 4 B Hanger Subassembly 2 1 100 1 50 wk 3 L4L 5 D Hanger Casting 6 2 200 2 FL = 100 6 E Ceramic knob 2 2 80 2 LFL 7 C Rivet Head Screw 3 1 20 1 FL=50 8 F Metal tong 12 2 800 1 FOP = 2 wk 9 G Plastic cap 6 2 350 2 FOP = 2 wk 10 11 Table 2. MPS of Bracket Assemblies 12 Week 1 2 3 4 5 6 13 X 60 40 80 70 50 100 14 a. Using Excel, create the MRP using the information provided and prepare the planned order release (POR) of each item in the MPS? 15 b. If the demand for Bracket Assemblies is 50 units in week 2, does the MRP face nervousness? How can the nervousness be reduced? 16 17 0 0 10 A B E F. G H 1 Safety Stock 10 20 20 0 0 20 1 Item Description Qty/unit product Level Current Inventory (uni LT (weeks) SRch Receipt Lot Size 2 X Bracket Assembly 1 0 50 0 20 wk 2 FL= 40 3 A Wall Board 2 1 40 1 50 wk 3 L4L 4 B Hanger Subassembly 2 1 100 1 50 wk 3 L4L 5 D Hanger Casting 6 2 200 2 FL = 100 6 E Ceramic knob 2 2 80 2 LFL 7 C Rivet Head Screw 3 1 20 1 FL=50 8 F Metal tong 12 2 800 1 FOP = 2 wk 9 G Plastic cap 6 2 350 2 FOP = 2 wk 10 11 Table 2. MPS of Bracket Assemblies 12 Week 1 2 3 4 5 6 13 X 60 40 80 70 50 100 14 a. Using Excel, create the MRP using the information provided and prepare the planned order release (POR) of each item in the MPS? 15 b. If the demand for Bracket Assemblies is 50 units in week 2, does the MRP face nervousness? How can the nervousness be reduced? 16 17 0 0 10