Question: Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 104 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 104 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.) 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 54 84 84 74 64 84 84 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 54 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 54 84 84 74 64 84 84 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: FOQ = 104 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 104 104 0 0 0 0 0 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!