Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 113 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 "O" wherever required.) picture Click here for the Excel Data File Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 70 63 93 93 83 73 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 83 0 93 0 70 63 0 0 0 0 Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 113 Gross requirements Scheduled receipts 70 63 93 93 83 73 83 93 113 113 0 0 0 0 0 0 Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 70 63 93 93 83 73 83 93 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 113 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 113 113 0 0 0 0 0 0