help

Problem 14-12 (Algo) Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 124 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.) RictureClick here for the Excel Data File Part Name: Bicycle frame Week 1 Week 2 Week 3 Week 4 Week 5 Weeks Week 7 Week MRP Record Lead time 2 week On hand 0 Safety stock = 0 Order quantity: LAL Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 74 104 104 70 70 84 94 83 0 74 0 104 0 0 0 0 Part Name: Bicycle frame Week 1 Week 2 Wook Woak 4 Works Woolo Wook? We 104 MFUP Record Lead time 2 week On hand=0 Safety stock=0 Order quantity: FOQ = 124 Gross requirements Scheduled receipts Available inventory Not requirements Planned order receipts Planned order releases 70 124 83 74 124 104 84 0 94 0 104 0 0 0 0