Problem 14-12 (Static) 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? Note that scheduled receipts exist in Week 1 and Week 2 as shown in the answer table below. (Leave no cells blank - be certain to enter "0" wherever required.) PrictureClick here for the Excel Data File Part Nome: Bicyclo framo Week 2 Week 8 MRP Record Lead time = 2 weeks On hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases Week 1 70 70 Week 3 80 Week 4 80 Week 5 70 50 50 Week 6 60 0 Week 7 80 0 80 0 0 0 0 Net requirements Planned order receipts Planned order releases Part Name: Bicycle frame Week 5 Week 6 MRP Record Lead time = 2 weeks On-hand-o Safety stock = 0 Order quantity: FOQ = 100 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases Week 1 70 100 Week 2 50 100 Week 3 80 0 Week 4 80 0 Week 7 80 70 60 0 Week 8 80 0 0 0