A A Aa A A A U XX APAA ESA 21 15 ABCDE AaBbcDdEe CODE STE Name: Class litem: Student ID: SCM3006 Lesson & Materials Requirements Planning (MRP) Exercise 24 Lot size: 300 units Lond time 1 week Safety clock Or unit 5 7. 7 2- + Problem Product K is made according to the bill of materials (BOM) diagram shown below. 100 products are needed in week 4, 200 in week S, and 100 in week 8. Product Khas a lead-time of one week and no on-hand inventory. Lot-for-lot (1.4L) appronch is used. Minimum order quantity 300 units Immediate Parentis: Week number 1 Gross Requirements Scheduled Receipts Projected on hand . Net Requirements 41 Planned order receipts Planned aner release -- K A (2) A ( B (5) Lot size: LALunts Lead times te weke Safety stock: 50 un 4 4 5 6 74 BD C(3) D (2) 2 2 3 Item: C Minimum order quantity 800 units Immediate Parantis Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements planned order receipts Planned order releases The table below shows additional data for the items A, B, C, and D. A B- CS Lead-time (week) le 12 Heginning inventory (unit) 100 120 50 D 1 100 11 Tusk: Based on the given data, complete the following MRP worksheet. MPS Data Product: K. Lead time: 1 weak On-hand nventory: 0 Week number 12 3 4-15 5 6 7 8 - Required dale 100 200 100 Order release date 100 200 100 - le Item: D Minimum order quantity 400 units Immediate Parents) Week number 1 1 Gross Requirements + Scheduled Receipts + 14 Lot Bize 40Dunia Lead time: 1 week Safety stock 0-uri 5 6 7 2 3 4 2 Item: A Projected on hand 1 Lot size: L4L units Lead time! 10 Week Safely stock. 50 units 45 61 7 8 Net Requirements Planned order receipts Planned order releases Minimum order quantity: 250 units immediate Parent(s); Week number 2 1 2 34 Gross Requirements Scheduled Receipta Projected on hand Net Requirements FIE Planned order receipts -- Planned order releases E A A Aa A A A U XX APAA ESA 21 15 ABCDE AaBbcDdEe CODE STE Name: Class litem: Student ID: SCM3006 Lesson & Materials Requirements Planning (MRP) Exercise 24 Lot size: 300 units Lond time 1 week Safety clock Or unit 5 7. 7 2- + Problem Product K is made according to the bill of materials (BOM) diagram shown below. 100 products are needed in week 4, 200 in week S, and 100 in week 8. Product Khas a lead-time of one week and no on-hand inventory. Lot-for-lot (1.4L) appronch is used. Minimum order quantity 300 units Immediate Parentis: Week number 1 Gross Requirements Scheduled Receipts Projected on hand . Net Requirements 41 Planned order receipts Planned aner release -- K A (2) A ( B (5) Lot size: LALunts Lead times te weke Safety stock: 50 un 4 4 5 6 74 BD C(3) D (2) 2 2 3 Item: C Minimum order quantity 800 units Immediate Parantis Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements planned order receipts Planned order releases The table below shows additional data for the items A, B, C, and D. A B- CS Lead-time (week) le 12 Heginning inventory (unit) 100 120 50 D 1 100 11 Tusk: Based on the given data, complete the following MRP worksheet. MPS Data Product: K. Lead time: 1 weak On-hand nventory: 0 Week number 12 3 4-15 5 6 7 8 - Required dale 100 200 100 Order release date 100 200 100 - le Item: D Minimum order quantity 400 units Immediate Parents) Week number 1 1 Gross Requirements + Scheduled Receipts + 14 Lot Bize 40Dunia Lead time: 1 week Safety stock 0-uri 5 6 7 2 3 4 2 Item: A Projected on hand 1 Lot size: L4L units Lead time! 10 Week Safely stock. 50 units 45 61 7 8 Net Requirements Planned order receipts Planned order releases Minimum order quantity: 250 units immediate Parent(s); Week number 2 1 2 34 Gross Requirements Scheduled Receipta Projected on hand Net Requirements FIE Planned order receipts -- Planned order releases E