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

3 Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 125 frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? Note that scheduled receipts exist in Week Tand Week 2 as shown in the answer table below. (Leave no cells blank-be certain to enter "0" wherever required.) DolctureClick here for the Excel Data File ww 7695 MRP Record Lead bime=2 week On hand = 0 Salety stock=0 Order quantity: LIL Gross requirements Scheduled receipts Available inventory Net requirements Planned onder receipts Planned onder releases MRP Record Lead time-2 week On hand - 0 Safety stock=0 Order Quantity: FOQ=128 Gross requirements Scheduled receipts Available inventory Net requirements Planned onder receipts Planned onder releases Week 1 70 TO Week 1 TO 128 Week 2 76 78 Week 2 76 128 Week3 105 0 Week 3 Part Name: Bicycle frame 105 0 Week 4 105 0 Part Name: Bicycle frame Week 4 Week 5 105 0

 3 Complete the MRP record for a bicycle frame using a

84 0 Week 5 84 0 Week 6 Week 6 85 0 35 0 Week 7 Week 7 95 0 05 0 Week 8 Week 8 105 0 105 0

Complete the MRP record for a bicycle frame using a L 4 L lot-sizing strategy. Repeat using a fixed order quantity of 125 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 blonk - be certaln to enter " 0 " wherever requlred.) Dictureclick here for the Excel Data File

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!