1. Using a fixed order quantity = 150 for the lot sizing rule

2. Using Lot-for-Lot as the lot sizing rule

3. Using POQ = 2 weeks as the lot sizing rule.

I have modified the problem in the book, by also requiring safety stock of 20 units for this item. You can start with the blank tables in the file MRP Homework 2.xlsx. All the information you need is in this file. Just complete the three MRP tables using the three different lot sizing rules.

Lot Size: Fixed order quantity 150 units Safety Stock = 20 12 13 14 15 16 15 45 40 80 80 - 80 80 Item: Rotor Assembly Lead Time: 2 weeks Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Receipts Planned Releases 1 65 Lot Size: Lot-for-Lot Safety Stock = 20 2 3 15 45 4 40 5 80 6 80 7 80 80 150 Item: Rotor Assembly Lead Time: 2 weeks Week Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Receipts Planned Releases 20 Lot Size: POQ = 2 Weeks Safety Stock = 20 23 15 45 4 40 5 80 6 80 7 80 8 80 65 Item: Rotor Assembly Lead Time: 2 weeks Week Gross Requirements Scheduled Receipts Projected On Hand 150 20 Net Requirements Planned Receipts Planned Releases