Problem 14-12 Complete the MRP record for a bicycle frame using a LAL 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 wherever required) Part Name: Bleycle frame MRP Record Lead time - 2 weeks On-hand = 0 Safety stock=0 Week 1 Week 2 Week 3 Week 4 Week 6 Week 7 Week Order quantity: LAL Gross requirements Week 6 70 70 50 30 80 50 - 80 0 30 0 Scheduled receipts 70 50 0 0 0 0 Available inventory Net requirements Plan ordel Planned order releases Part Name: Bicycle frame MRP Record Lead time 2 weeks Onhando Week 3 Week 4 Week Week Week 7 Week Week 1 70 100 Week 2 50 100 00 00 Safety stock Order quantity FOO 100 Grow requirements Scheduled recents Avale inventory Nel requirements Panned order receipts Planned order releases 00 00 70 0 0 0 D O 0