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

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
Get step-by-step solutions from verified subject matter experts
