AutoSave On File E14 F Week 5 MRP table Saved Search (Alt+Q) Home Insert Page Layout Formulas Data Review View Help fx Tara Thompson TT Comments Share 1 2 Rocking Chair A B C D E F G H | J K L M N P Q R S U MRP: Material Requirements Planning Apr 05 Apr 12 Apr 19 Apr 26 May 03 May 10 3 Gross Requirements (GR) 75 75 75 100 100 125 4 Scheduled receipts (SR) 0 200 5 Projected Stock Balance (PSB) 0 0 0 0 0 |SS=10 6 nventory On Hand (IOH) 90 15 140 65 -35 -100 7 Net Requirements (NR) -15 60 -65 35 135 225 Planned Receipts (PR) -15 60 -65 35 135 225 8 Lot Size (Q)] Qd=LFL 9 Planned Order Release (POR) -15 60 -65 35 135 225 |LT=2 10 12 PSB = IOH+SR-GR 13 NR = GR-IOH 14 PR = NR 15 OH = PSB (+ or -)SS. For example, the week of April 12 will add the SS to the PSB 16 POR = PR set back by the #of weeks LT 17 Required Demand = Gross Requirements = GR Use the SS this way: he first time subtract it from nventory, the next week add it o inventory, the next week 18 subtract it, etc @@8-237238238 19 21 Sheet1 Ready Accessibility: Good to go H Type here to search 99+ ? 52F 11:46 AM 9/29/2022 + 70%