Planning Saved Help Save & Exit Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 120 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.) pictureClick here for the Excel Data File Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Woek 6 Week 7 Week 8 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 70 70 100 0 100 85 80 100 70 70 0 90 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 70 100 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 120 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 100 85 120 120 80 0 90 0 0 100 0 0 0 H A B G E D 1 Problem 14.12 2 MRP Record Part Name: Bicycle Frame Week 1 70 Week 2 70 Week 3 100 Week 4 100 Week 5 85 Week 6 80 Week 7 90 Week 8 100 Part Name: Bicycle Frame Lead time 2 weeks On-hand inventory=0 Safety stock=0 3 Order quantity: L4L 4 Gross requirements 5 Scheduled receipts 6 Available inventory 7 Net requirements 8 Planned order receipts 9 Planned order releases 10 11 MRP Record Lead time 2 weeks On-hand inventory = 0 Safety stock=0 Order quantity: FOQ - 12 100 13 Gross requirements 14 Scheduled receipts 15 Available inventory 16 Net requirements 17 Planned order receipts 18 Planned order releases 19 Week 1 70 Week 2 70 Week 3 100 Week 4 100 Week 5 85 Week 6 80 Week 7 90 Week 8 100 Planning Saved Help Save & Exit Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 120 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.) pictureClick here for the Excel Data File Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Woek 6 Week 7 Week 8 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 70 70 100 0 100 85 80 100 70 70 0 90 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 70 100 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 120 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 100 85 120 120 80 0 90 0 0 100 0 0 0 H A B G E D 1 Problem 14.12 2 MRP Record Part Name: Bicycle Frame Week 1 70 Week 2 70 Week 3 100 Week 4 100 Week 5 85 Week 6 80 Week 7 90 Week 8 100 Part Name: Bicycle Frame Lead time 2 weeks On-hand inventory=0 Safety stock=0 3 Order quantity: L4L 4 Gross requirements 5 Scheduled receipts 6 Available inventory 7 Net requirements 8 Planned order receipts 9 Planned order releases 10 11 MRP Record Lead time 2 weeks On-hand inventory = 0 Safety stock=0 Order quantity: FOQ - 12 100 13 Gross requirements 14 Scheduled receipts 15 Available inventory 16 Net requirements 17 Planned order receipts 18 Planned order releases 19 Week 1 70 Week 2 70 Week 3 100 Week 4 100 Week 5 85 Week 6 80 Week 7 90 Week 8 100