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