Problem 1- Adapted from chapter 6. Develop an MRP spreadsheet record for six periods using the following parameters for the item: Period 1 2 3 4 5 6 Gross Requirements 30 40 40 30 30 30 1 period Lead time (LT) Lot size (Q) 50 units Safety stock (SS) 0 units Inventory 2 units Scheduled receipt 50 units in period 1 a. In what periods are there planned order releases? b. What happens to the timing, number of planned order releases, and average inventory (for periods 1 through 6) if 20 units of safety stock are required? c. What happens to the timing, number of planned order releases, and average inventory (for periods 1 through 6) if a one-week safety lead time is used instead of the safety stock?