Item: B Lot size: 300 units Lead time: week 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 5, and 100 in week 8. Product K has a lead-time of one week and no on-hand inventory. Lot-for-lot (L4L) approach is used. 1 0 Safety stock units 2 3 4 5 6 7 8 K Minimum order quantity: 800 units Immediate Parent(s); Week number 1 Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases A (2) B (5) B (1) C (3) D (2) Item: C Minimum order quantity: 800 units Immediate Parent(s); Lot size: L4L units Lead time 1 week Safety stock: 50 units 5 6 7 8 D The table below shows additional data for the items A, B, C, and D. A B Lead-time (week) 1 1 1 Beginning inventory (unit) 100 120 50 1 1 2 3 4 1 100 Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Task: Based on the given data, complete the following MRP worksheet. MPS Data Product: K. Lead time: 1 week, On-hand inventory: 0 Week number 1 2 3 3 4 5 6 7 Required date 100 200 100 Order release date 100 200 100 8 Planned order releases Item: D Minimum order quantity: 400 units Immediate Parent(s): Lot size: 400 units Lead time: 1 week Safety stock: 0 units Item: A 1 2 3 Lot size: L4L units Lead time: 1 week Safety stock: 50 units 5 6 7 8 8 4 5 8 Minimum order quantity: 250 units Immediate Parent(s); 7 8 Week number 1 2 3 4 Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases Planned order receipts Planned order releases