125% Tv EA T Text co Collaborate 99 Format Document View Zoom Insert Table Chart Shape Media Comment Text Body Answer ALL the following questions and upload your answers to Question 1 in Blackboard. Show all your work. Remember that you may only submit one document that includes all of your answers. Complete all the YELLOW CELLS to develop an MRP record for items B, C, and D. If the answer is 0, you can either put 0 or leave the cell blank. Bill of Materials (BOM): Style Layout More A Font Trebuchet MS (Calibri) B (1) C (2) 12 pt B 1 u v D (1) Character Styles None Alignment 5 6 7 8 9 10 Master Production Schedule (MPS) for Item A: Week 1 2 34 Qty 0 100 0 200 Needed (FAS) 0 120 180 60 0 0 t Item Master File (IMF): Item Spacing 1.0 - Single B B D D Lot Sizing Rule POQ (P=3 weeks) Bullets & Lists None L4L (lot for lot) 2 weeks FOQ (Q" = 500) ) 3 weeks 1 week None Lead Time (LT) Scheduled Receipts (SR) Beginning On-Hand (OH) Inventory 200 in week 1 None 0 425 20 Tv 79% Tv FE .. T Text co Collaborate 99 Format Document View Zoom Insert Table Chart Shape Media Comment Text Body 7 7 8 8 9 9 10 Style Layout More Material Requirements Planning (MRP) Records: (150 points) ) ITEM B (POQ, where P = 3 weeks) and LT = 1 week Week 1 2 2 3 3 4 5 6 6 Gross Requirements (GR) Schedule Receipts (SR) Projecte 20 d On units Hand (POH) Planned Receipts (PR) Planned Order Releases (POR) Font Trebuchet MS (Calibri) 12 pt B 1 u v Character Styles None 3 4 5 6 7 7 8 9 10 Alignment ITEM C (L4L) and LT = 2 weeks: Week 1 2 Gross Requirements (GR) Schedule Receipts (SR) Projecte 0 d On units Hand (POH) () Planned Receipts (PR) Planned Order Releases (POR) t Spacing 1.0 - Single 4 5 6 7 7 8 9 10 ITEMD (FOQ = 500) and LT = 3 weeks: Week 1 2 2 3 Gross Requirements (GR) Bullets & Lists None Schedule Receipts (SR) Projecte 425 d On units Hand (POH) Planned Receipts (PR) Planned Order Releases (POR)