Question: Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 106 frames. Compare and contrast

Complete the MRP record for a bicycle frame using

Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 106 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 MRP Record Part Name: Bicycle frame Lead time = 2 week On hand = 0 Safety stock = 0 Week 1 Week 4 Week 5 Week 6 Week 7 Week 8 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 106 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases Week 1 70 70 70 106 Week 2 Week 2 56 56 56 106 Week 3 Week 3 86 86 0 0 0 Part Name: Bicycle frame Week 4 Week 5 86 0 76 86 0 76 0 66 Week 6 0 66 0 Week 7 86 0 86 0 Week 8 86 0 86 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!