Please provide the answering showing all the work or steps explaining!

Part 2

Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 100 frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? (Leave no cells blank - be certain to enter "0" wherever required.) Part Name: Bicycle frame MRP Record Lead time = 2 weeks Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 70 50 80 80 70 60 80 80 On-hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 70 50 0 0 0 0 0 0 0 0 0 0 0 0 ol 0 0 0 80 80 701 60 80 80 0 0 80 80 70 60 80 80 80 80 Part Name: Bicycle frame MRP Record Lead time = 2 weeks On-hand = 0 Safety stock = 0 Order quantity: FOQ = 100 Week 1 Week 2 Week 3 Week 4 Week 6 Week 7 Week 8 Week 5 70 Gross requirements 70 50 80 80 60 80 80 100 100 0 0 0 0 0 0 Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases Complete the MRP record for a bicycle seat. (Leave no cells blank - be certain to enter "0" wherever required.) Part Name: Seat MRP Record Lead time = 1 week On-hand = 40 Week 1 Week 2 Week 5 Week 7 Week 8 Week 3 80 Week 4 80 Week 6 60 70 50 70 80 80 100 Order quantity: FOQ = 100 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases