Questions 17-20 Consider the MPS, BOM, and inventory data shown below, to answer questions 17- 20. You can use the assistant table attached. /content/enforced3/375163-1117.202050/Table.xlsx a. Master Production Schedule: the following table shows the MPS quantities for Product A (production lead time = 0 weeks) 2 5 6 Week 1 MPS 3 80 4 BO b. Bill of Material: Item A uses 1 of component D, 2 of component C and 2 of subassembly B. Subassembly B uses 1 of component D. c. Selected Inventory Data: Data Category B D Lot-sizing rule L4L EOQ - 180 EOQ = 40 Lead time (wks) Beginning (on-hand) inventory 30 160 Scheduled receipts 190 (wk 2) 180 (wk 1) 80 (wk 1) 1 1 2 150 Question 17 (5 points) Which one of the following statements concerning item B is TRUE? The net requirement in week 2 is 220. The first planned order release occurs in week 3. The projected on-hand inventory quantity at the end of week 6 is 60 units. There are exactly 2 planned order releases. Question 18 (5 points) When does the first planned order release for item C occur? Week 3 No planned order releases needed Week 1 or 2 Week 4 Question 19 (5 points) What is the projected on-hand inventory for item D in week 5? 10 80 Zero 30 Question 20 (5 points) What is the gross requirement for item D in week 3? 0100 Zero 180 80