5. Develop an MRP spreadsheet record for six periods using the following parameters for the item:

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 15 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?

Period 1 2 3 4 5 6 20 20 40 30 30 30 30 30 Gross requirements 20 Lead time Lot size Safety stock Inventory Scheduled receipt 1 period 50 units O units 2 units 50 units in period 1