Instructions Directions: Answer the following question in a Microsoft Excel document. The partially completed MRP record in Table below provides gross requirements, scheduled receipts, lead time, and beginning on- hand inventory. NOTE: Scheduled Receipts for week 1 = 2,100. Item: F200 Lot size: Description: iPod ear buds Lead time: 2 weeks Be . inv.: 200 Safet stock: 10 Week 1 2 3 4 5 6 7 8 9 Planned OH inventory Planned recei-ts Planned order release 1. Complete the record for a lot size of FOQ = 1,500 units. (8 marks) 2. Complete the record for a lot size of P = 3. {8 marks) 3. Complete the record for an L4L lot size. (8 marks) 4. Which lot size rule results in the lowest average inventory? (3 marks) 5. Which lot size rule results in the fewest/most orders